Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

e the income statement and balance sheet of a firm in this year. Using the information to answer question (1) - (3). This year's Income

e the income statement and balance sheet of a firm in this year. Using the\ information to answer question (1) - (3).\ This year's Income Statement\ Tax rate 25%\ Sales $ 235,000,000\ COGS 170,100,000\ Other expenses 27,752,200\ Depreciation 7,566,900\ EBIT $ 29,580,900\ Interest 4,170,100\ Taxable income $ 25,410,800\ Taxes (25%) 6,352,700\ Net income $ 19,058,100\ Dividends $ 8,925,000\ Add to RE $ 10,133,100\ This year's Balance Sheet\ Assets Liabilities & Equity\ Current Assets Current liabilities\ Cash $ 4,729,200 Accounts payable $ 7,261,700\ Accounts rec. 5,500,800 Notes payable 15,492,900\ Inventory 7,176,200 Total CL $ 22,754,600\ Total CA $ 17,406,200\ Long-term debt $ 40,100,000\ Fixed assets\ Net P&E $ 111,629,300 Shareholder equity\ Common stock $ 6,040,900\ Retained earnings 60,140,000\ Total equity $ 66,180,900\ Total assets $ 129,035,500 Total L&E $ 129,035,500\ Growth rate 20%\ Q1) Using the financial statements information above to calculate the following ratios.\ Current ratio ?\ Quick ratio ?\ Total asset turnover ?\ Inventory turnover ?\ Receivables turnover ?\ Debt ratio ?\ Debt-equity ratio ?\ Equity multiplier ?\ Interest coverage ?\ Profit margin ?\ Return on assets ?\ Return on equity ?\ Q2) What is the sustainable growth rate of the firm?\ Retention ratio, b ?\ Sustainable growth rate ?\ At this sustainable growth rate, prepare the pro forma statements next year and calculate External\ Financing Needed (EFN) in the area below:\ Sales ?\ COGS ?\ Other expenses ?\ Depreciation 7,566,900\ EBIT ?\ Interest 4,170,100\ Taxable income ?\ Taxes ?\ Net income ?\ Dividends ?\ Add to RE ?\ Assets Liabilities & Equity\ Current Assets Current liabilities\ Cash ? Accounts payable ?\ Accounts rec. ? Notes payable ?\ Inventory ? Total CL ?\ Total CA ?\ Long-term debt $ 40,100,000\ Shareholder equity\ Common stock $ 6,040,900\ Fixed assets Retained earnings ?\ Net PP&E ? Total equity ?\ Total Assets ? Total L&E ?\ EFN ?\ Q3) What if the firm is planning for a growth rate of 20% next year? Prepare the pro forma statements next\ year and calculate External Financing Needed (EFN) in the area below:\ Sales ?\ COGS ?\ Other expenses ?\ Depreciation 7,566,900\ EBIT ?\ Interest 4,170,100\ Taxable income ?\ Taxes ?\ Net income ?\ Dividends ?\ Add to RE ?\ Assets Liabilities & Equity\ Current Assets Current liabilities\ Cash ? Accounts payable ?\ Accounts rec. ? Notes payable ?\ Inventory ? Total CL ?\ Total CA ?\ Long-term debt $ 40,100,000\ Shareholder equity\ Common stock $ 6,040,900\ Fixed assets Retained earnings ?\ Net PP&E ? Total equity ?\ Total Assets ? Total L&E ?\ EFN ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling An Introductory Guide To Excel And VBA Applications In Finance

Authors: Joachim Häcker, Dietmar Ernst

1st Edition

1137426578, 978-1137426574

More Books

Students also viewed these Finance questions