Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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