Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I cant figure out how to Calculate NPV and IRR in Excel Initial investment outlay of $40 million, consisting of $35 million for equipment and
I cant figure out how to Calculate NPV and IRR in Excel
- Initial investment outlay of $40 million, consisting of $35 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
- Project and equipment life: 5 years
- Sales: $27 million per year for five years
- Assume gross margin of 50% (exclusive of depreciation)
- Depreciation: Straight-line for tax purposes
- Selling, general, and administrative expenses: 10% of sales
- Tax rate: 35%
Assume a WACC of 10%.
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