Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started