Financial ratios using income statement and balance sheet

Assignment Help Financial Accounting

Reference no: EM131212903

Background: On September 30, 2012, Angie Stowe decided to open a corporation that she will call Mandalay Interiors. Instead of doing anything in September, she decides she will begin the company the next day, October 1, 2012. Assume then that all balances on December 31, 2007, are $0. She has also decided that she will sell shares of stock to the public. Furthermore, she has decided that she will use a perpetual inventory system with the FIFO method. She determines that depreciation methods will be determined based on the items purchased.

The company employs three employees. These employees earn salaries of $80,000 in total per year, paid at the end of each month. The federal income tax withheld is 15%, state taxes withheld are 3.07%, and local taxes withheld are at the rate of 1%. And of course, the company will need to remember FICA taxes of 7.65%. The state unemployment tax rate is 5.4%, and the Federal unemployment tax rate is .8%.

October 01, 2012: Sold 100,000 shares of $5 par common stock for $7.

Sold 10,000 shares of $1 par 10% preferred stock for $10.

October 02, 2012: Purchased inventory on account for $4,000 (200 units @ $20).

October 03, 2012: Purchased machinery costing $500,000, paying $200,000 in cash, and the rest on account (noninterest bearing). Name payable account: Machinery Payable. (Estimated useful life of 10 years, and residual value of $30,000.) Will use double declining method of depreciation.

October 03, 2012: Entered into a lease agreement to rent a building. (No entry needed here)

October 15, 2012: Sold 50 units of inventory for $30 cash.

October 30, 2012: Paid for October rent on building: $1,000.

October 30, 2012: Paid portion of Accounts Payable due: $2,000

October 30, 2012: Paid portion of Machinery Payable owed: $2,500

October 31, 2012: Paid payroll for October

November 1, 2012: Purchased inventory for cash for $5,000 (200 units @ $25)

November 1, 2012: With extra cash available, company decides to invest into other companies with the following investments:

100 shares of Company A stock at $50 per share

500 shares of Company B stock at $90 per share

20 $1000 par value 10% bonds at par plus accrued interest

Interest paid June 31 and December 31

Investments are considered available for sale

November 3, 2012: Purchased office supplies for cash of $1000.

November 15, 2012: Sold 100 units of inventory for $32 cash.

November 16, 2012: Reacquired 20,000 shares of stock for a price of $10.

November 17, 2012: Board of directors declares 10 cents per share dividend payable December 15, 2012, for common shareholders of record on December 1, 2012. Also declares the yearly preferred dividends with the same dates.

November 25, 2012: Sold 100 units of inventory for $32.

November 30, 2012: Paid for November rent on building: $1,000.

November 30, 2012: Paid rest of A/P, $2,000.

November 30, 2012: Paid portion of Machinery Payable owed: $2,500.

November 30, 2012: Paid payroll for November.

December 1, 2012: Purchased inventory for cash: $5000 (200 units @ $25).

December 1, 2012: Purchased new delivery truck on account for $50,000, name payable account: Truck Payable. (Estimated useful life 120,000 miles, residual value $5,000. Will use units of production method for depreciation.)

December 1, 2012: Sold 50 shares of both company A & B stock for $75 and $85 respectively.

December 1, 2012: Sold 200 units of inventory for $32, on account.

December 15, 2012: Paid dividends owed to shareholders.

December 16, 2012: Resold reacquired 10,000 shares for $12.

December 31, 2012: Paid for December rent on building: $1,000.

December 31, 2012: Paid portion of Machinery Payable owed: $2,500.

December 31, 2012: Paid payroll for December.

December 31, 2012: Delivery truck has been used for 10,000 miles this year.

December 31, 2012: A count of supplies reveals we have $400 of supplies left on hand.

December 31, 2012: Fair market values of the available for sale investments:

Company A: $70 per share

Company B: $89 per share

Bonds have no change in value

December 31, 2012: We estimate that 2% of receivables will become delinquent.

Prepare the following financial ratios using the Income Statement and Balance Sheet:

a) Current Ratio

b) Quick Ratio

c) Accounts Receivable Turnover

d) Days Sales in Receivable

e) Earnings Per Share

f) Price Per Earnings Ratio (Assume Market Price = $12)

Reference no: EM131212903

Questions Cloud

Shares of no-par common stock : On February 13, Epperson Company issued for cash 75,000 shares of no-par common stock (with a stated value of $125) at $140. On September 9, Epperson issued at par 15,000 shares of 1%, $60 par preferred stock at par for cash.

Determine the unit product cost for the new product : The management of Archimbaldo Corporation would like to set the selling price on a new product using the absorption costing approach to cost-plus pricing. The company's accounting department has supplied the following estimates for the new product: D..

Ordering cost-carrying cost and total inventory-related cost : Ordering Cost, Carrying Cost, and Total Inventory-Related Cost. La Cucina Company sells kitchen supplies and housewares. Lava stone is used in production of molcajetes (mortars and pestles used in the making of guacamole) and is purchased from extern..

Installing a machine that automates several operations : Astro Co. sold 20,100 units of its only product and incurred a $63,560 loss (ignoring taxes) for the current year as shown here. During a planning session for year 2016’s activities, the production manager notes that variable costs can be reduced 40%..

Financial ratios using income statement and balance sheet : On September 30, 2012, Angie Stowe decided to open a corporation that she will call Mandalay Interiors. Instead of doing anything in September, she decides she will begin the company the next day, October 1, 2012. Prepare the following financial rat..

Explain generally accepted accounting principles : Public companies are required to publish annual financial statements. Suggest the major benefits of companies making financial statement information available to employees. Briefly explain generally accepted accounting principles (GAAP), and describe..

Income statement segmented by flavor : Toxemia Salsa Company manufactures five flavors of salsa. Last year, Toxemia generated net operating income of $40,000. The following information was taken from last year's income statement segmented by flavor (brackets indicate a negative amount):

Acceptable selling price per t-shirt in order to avoid loss : Vanana Tees sells its cool-zone t-shirt for $24 each. Unit product cost are as follows: A special order to 1,200 shirts was recently received. There is enough capacity to fill the order. Filling this order will not disrupt current operations. In nego..

Review the comprehensive annual financial report : Review the comprehensive Annual Financial Report (CAFR) that you have obtained.City of Austin. How many capital projects funds does the government maintain? How can you tell? Are any of these major funds? If so, for what purposes are they maintained?..

User Account

All Pages