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

i dont know where to start . how do i construct a six year pro forma income statement
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 income statements and calculate the incremental unlevered net income for the

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

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 Accounting Questions!