Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how do I find the answer with excel? I will give thumbs up to whoever answers. (There is a function in Excel, XNPV, that allows
how do I find the answer with excel?
I will give thumbs up to whoever answers.
(There is a function in Excel, XNPV, that allows us to assign specific dates to each cash flow, but we're not using it. Please use your financial calculator to calculate the NPV of our projected cash flow stream using the original 15% discount rate with the $1,100,000 purchase price. Here is a video tutorial for calculating NPV. Cfo C01 Purchase Price Year 1 Year 2 Year 3 Year 4 CO2 CO3 -1100000 (Note: This is negative!) $100,000 $120,000 $140,000 $155,000 $1,365,000 -$68,328 C04 C05 Year 5 NPV = Did you get about - $68,387? If not, please recheck your work. 3 4 Recall from the introduction that NPV is the price paid subtracted from the value. 5 Our value at 15% was $1,037,014, our price paid was $1,100,000. 6 7 -62986Step 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