Question: i dont know where to start . how do i construct a six year pro forma income statement Use Excel to construct six-year pro forma


Use Excel to construct six-year pro forma income statements and calculate the incremental unlevered net income for the first six years. 3 Assumptions (Amounts in \$ Thousands Unless Otherwise Indicated) 4 Initial Capital Expenditure (Year 0 ) 5 Useful Life of Equipment 6 Annual Depreciation 7 Sales in Year 1 8 Sales Growth Rate per Year through Year 6 9 Sales Growth Rate in Year 7 and beyond 10 Free Cash Flow Growth Rate in Year 7 and beyond 11 Cost of Goods Sold (\% of sales) 12 Incremental SG\&A Expense 13 Market Research Expense 14 Initial Net Working Capital (Year 0) 19 Tax Rate 20 Cost of Capital 20%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
