Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer the following questions and show work: payback period: 5 year ROI without discount 5 year ROI with discount Part 1: Calculating NPV, Payback

please answer the following questions and show work:
payback period:
5 year ROI without discount
5 year ROI with discount
image text in transcribed
Part 1: Calculating NPV, Payback Period and ROI 1. Create a table in Excel that calculates the following: a. The initial development costs for a system were $225,000. b. The maintenance cost is $5,000 a year for the first 2 years. i. $5,500 a year for years 3 and 4 ii. $7,000 for year 5 C. Expected benefits are valued at $55,000 by the end of year 1. i. $60,000 for year 2 ii. $70,000 for year 3 iii. $75,000 for year 4 iv. $80,000 for year 5 d. Calculate the cumulative NPV for all 5 years e. Calculate the Payback Period (years/days) f. Calculate ROI using a discount rate of 8%

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

Recommended Textbook for

Finance Accumulation And Monetary Power

Authors: Daniel Woodley

1st Edition

0367338556, 978-0367338558

More Books

Students also viewed these Finance questions