Answered step by step
Verified Expert Solution
Link Copied!

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
image text in transcribed
image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions