Question: Use the information & assumptions below to: 1. Generate a Pro forma Income Statement for next year 2. Generate a Pro forma Balance Sheet for

Use the information & assumptions below to: 1.
Use the information & assumptions below to: 1. Generate a Pro forma Income Statement for next year 2. Generate a Pro forma Balance Sheet for the current year end AND projected next year end Information & Assumptions for Company Inc.: VVVVVVVVVVV V VV VVVV Sales this past year were: $1,000,000. Sales are expected to grow 10% next year. Cost of Goods Sold have historically run at 68% of sales. No change expected. Selling, General & Administrative Expenses have historically run at 12% of sales. No change expected. Depreciation Expense - Fixed assets are depreciated over a ten-year useiul life. Interest expense is paid at an average rate of 8% on current long-term interest-bearing debt of $250,000. Last year's tax rate was 38%, but under the new tax plan next year's tax rate is expected to be 22%. Dividend payout ratio is assumed to stay at 35%. Minimum cash balance is $25,000 (balance unchanged from past scal year end) Beginning receivables is $70,000. Beginning inventory is $50,000. Beginning xed assets stand at $380,000. New xed assets expected to be acquired total $180,000. Beginning payables is $20,000. Beginning equity is $255,000. Inventory Days has historically run at 44. Receivable Days Outstanding has historically run at 28. Payable Days has historically run at 20. 3. Based upon your pro forma income statement and balance sheet, calculate the sustainable growth rate for Inc. Interpret what information is provided by this metric. 4. Sustainable growth rate is often used by bankers and other external analysts to assess a company's creditworthiness. Explain how a banker might practically use this information (namely the sustainable growth rate). 5. Sensitivity analysis is \"What If\" analysis. If you were the owner of Inc. why might you perform a sensitivity analysis? Explain

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!