a. Selected financial ratios computed from Tanner’s financial statements are giv
ID: 2497690 • Letter: A
Question
a. Selected financial ratios computed from Tanner’s financial statements are given below: Current ratio 2.00 Acid-test ratio 1.18 Accounts receivable turnover 16.0 Inventory turnover 9.0 Debt-to-equity ratio 0.870 Times interest earned 5.0 Earnings per share $ 3.72 Return on total assets 10 % b. All sales during the year were on account. c. The interest expense on the income statement relates to the bonds payable; the amount of bonds outstanding did not change throughout the year. d. There were no changes in the number of shares of common stock outstanding during the year. e. Selected balances at the beginning of the current year (January 1) were as follows: Accounts receivable $ 330,000 Inventory $ 440,000 Total assets $ 1,850,000
Required Compute the missing amounts on the company's financial statements. (Input values. Round your final answers to the nearest whole dollar amount.) Income Statement For the Year Ended December 31 $4,700,000 Sales Cost of goods sold Gross margin Selling and administrative e Net operating income Interest expense Net income before taxes Income taxes (40%) 62,000 Net incomeExplanation / Answer
Answer:
Working Notes:
1. Calculation of Total Current Assets
Current Ratio = Current Assets / Current Liabilities = 2.00, therfore, current assets = 2 times current liabilities = 2 x $ 250,000 or Current Assets = $ 500,000
2. Calculation of Current Assets excluding Inventory
Acid Test Ratio = (Current Assets - Inventory) / Current Liabilities = ($ 500,000 - Inventory) / $ 250,000
that is; 1.18 x $ 250,000 = $ 500,000 - Inventory or Inventory = $ 205,000
3. Calculation of Cost of Goods Sold
Inventory Turnover Ratio = Cost of Goods Sold / Average Inventory or 9 x Inventory = Cost of Goods Sold
that is Cost of Goods Sold = 9 x $ 205,000 = $ 1,845,000
4. Calculation of Accounts Receivable
Accounts Receivable Turnover Ratio = Credit Sales / Accounts Receivable or 16 = $ 4,700,000 / Accounts Receivable; that is Accounts Receivable = $ 4,700,000 / 16 = $ 293,750
5. Calculation of Cash & Cash Equivalents
Current Assets = Accounts Receivable + Inventory + Cash & Cash Equivalents or $ 500,000 = $ 293,750 + $ 205,000 + Cash & Cash Equivalents that is Cash & cash equivalents = $ 1,250
6. Calculation of Earnings Before Interest & Tax or Net Operating Income
Times Interest Earned Ratio = EBIT / Interest or 5 = EBIT / $ 62,000 that is EBIT = $ 310,000
7. Calculation of Plant & Equipment , net
Return on Total Assets = EBIT (as per income statement below) / Total Assets or 10% = $ 310,000 / Total Assets that is Total Assets = $ 310,000 / 10% = $ 3,100,000 or Total Current Assets + Plant & Equipment , net = $ 1,488,000 that is Plant & Equipment , net = $ 3,100,000 - $ 500,000 = $ 2,600,000
8. Calculation of Bonds Payable
Interest of Bonds = Coupon Rate x Bonds Payable or $ 62,000 = 10% of Bonds Payable, that is Bonds Payable = $ 62,000 / 10% = $ 620,000
9. Calculation of Common Stock
Earnings per share = Net Income / No. of Common Shares or 3.72 = $ 148,800 / No. of Common Shares that is No. of Common Shares = $ 148,800 / 3.72 = 40,000 shares and Common Stock Value = No. of Common Shares x Par Value per share = 40,000 x $ 2.70 = $ 108,000
Income Statement
Sales (as given in question) $ 4,700,000
Less: Cost of goods Sold (as per above WN 3) $ 1,845,000
Gross Margin $ 2,855,000
Selling & Admin Expenses (Gross Margin - EBIT) $ 2,545,000
Net Operating Income (as per above WN 6) $ 310,000
Interest Expense $ 62,000
Net Income before Taxes $ 248,000
Income Tax at 40% $ 99,200
Net Income $ 148,800
Balance Sheet
Cash $ 1,250
Accounts Receivable $ 293,750
Inventory $ 205,000
Total Current Assets $ 500,000
Plant & Equipment, net $ 2,600,000
Total Assets $ 3,100,000
Current Liabilities $ 250,000
Bonds Payable $ 620,000
Total Liabilities $ 870,000
Common Stock $ 108,000
Retained Earnings (balancing figure) $ 2,122,000
Total Liabilities and Syockholders equity $ 3,100,000
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.