Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have to calculate the overall npv,Roi, and breakeven points at different discount rates in a excel sheet using the data below What i got
I have to calculate the overall npv,Roi, and breakeven points at different discount rates in a excel sheet using the data below
What i got so far
Year | 0 | 1 | 2 | 3 | 4 | 5 | Discount Rate : | 10% | |
Net Economic Benefit | $0 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | |||
PV of Benefits | $45,455 | $41,322 | $37,566 | $34,151 | $31,046 | ||||
NPV of all Benefits | |||||||||
One Time Costs | -47,500 | 0 | 0 | 0 | 0 | 0 | |||
Recurring Costs | $0 | $-32,000 | $-32,000 | $-32,000 | $-32,000 | $-32,000 | |||
PV of Recurring Costs | |||||||||
NPV of all costs | $-47,500 | ||||||||
Overall NPV | |||||||||
Overall ROI | |||||||||
Break Even Analysis | |||||||||
Yearly Cash flow | -47500 | ||||||||
Overall cash Flow | -47500 | ||||||||
Breakeven between years | |||||||||
Actual Brakeven |
|
EXAMPLE I AM FOLLOWING
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Net economic $0 $50,000 $50,000 $50,000 $50,000 $50,000 benefit Onetime costs $47,500 Recurring costs $o $32,000 $32,000 $32,000 $32,000 $32,000Step 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