Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3. Fleury, Inc. is preparing pro-forma financial statements for 20X1. A junior analyst has begun the work. You are asked to complete the statements
3. Fleury, Inc. is preparing pro-forma financial statements for 20X1. A junior analyst has begun the work. You are asked to complete the statements (see the income statement and balance sheet below). Sales are projected to grow at 25%. All expenses except interest expense is forecasted to remain a constant percent of sales based on 20X0 actuals. Interest expense is expected to grow 20% in 20X1. Assets are also forecasted to remain as a constant percent of sales based on 20X0 actuals. Short-term notes payable and common stock will remain constant. Long-term debt is the plug variable. Complete the balance sheet below. What will the Total Debt Ratio be at the end of 20X1? Net Sales Cost of Goods Sold Other Expenses Earnings before Interest & Taxes Interest Expense Taxable Income Taxes Net Income Dividends Transfer to Retained Earnings Sales Growth Rate Income Tax Rate Dividend Payout Retention Ratio Income Statement ROA ROE Internal Growth Rate (20X1) Sustainable Growth Rate (20X1) $ GA GA GA GA $ $ $ $ $ $ LA LA LA LA $ $ $ Dollars 20X0 20X1 743,000 $ 928,750 (578,000) $ (722,500) (15,200) $ (19,000) 149,800 $ 187,250 (13,440) 173,810 (60,834) 112,977 (33,893) 79,084 (11,200) $ 138,600 $ (48,510) $ 90,090 $ (27,027) $ 63,063 $ 35.00% 30.00% 70.00% 19.90% 34.82% 16.18% 32.23% 25.00% 35.00% 30.00% 70.00% % of Sales 20X0 100.00% 77.79% 2.05% 20.16% 6.53% 12.13% Current Assets: Cash Accounts Receivable Inventories Total Current Assets Fixed Assets Net PPE Total Assets Current Liabilities: Accounts Payable Notes Payable Total Current Liabilities Long-term Liabilities: Long-term Debt Total Liabilities Stockholder's Equity: Common Stock & PIC Retained Earnings Total Stockholder's Equity Total Liabilities & Equities Total Debt Ratio Balance Sheet $ $ $ $ Dollars $ $ $ 20X0 20,240 $ 25,300 32,560 $ 40,700 69,520 $ 86,900 122,320 $ 152,900 $ 330,400 $ 413,000 $452,720 $ 565,900 54,400 $ 13,600 $ 68,000 $ 20X1 $ 126,000 $ 194,000 42.85% 68,000 13,600 81,600 $ 112,000 $ 112,000 $ 146,720 $ 258,720 $452,720 $ 565,900 % of Sales 20X0 2.72% 4.38% 9.36% 16.46% 44.47% 7.32%
Step by Step Solution
★★★★★
3.40 Rating (150 Votes )
There are 3 Steps involved in it
Step: 1
Retained earning in 20X1 Retained earning in 20X0 Ad...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