Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the IRR? (using Excel formula) What is the NPV? (using Excel formula and assuming average risk at 10%) Year Expected Net Cash Flow
What is the IRR? (using Excel formula)
What is the NPV? (using Excel formula and assuming average risk at 10%)
Year Expected Net Cash Flow
0 ($100,000)
1 $30,000
2 $30,000
3 $30,000
4 $30,000
5 $30,000
5 (salvage value) $20,000
For NPV do you include year 0 in NPV formula or calculate NPV on years 1-5+salvage and then add year 0 to the excel calculation?
Does the salvage value get included in both calculations? Thanks
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