Discount rate 8% Assume the project is completed in Year 0 Year 3 Total 140,000 40,000 40,000 40,000 0.79 1 2 Costs Discount factor Discounted costs 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 0 200,000 200,000 200,000 0.86 0 186,000 172,000 158,000 516,000| Benefits Discount factor 1 0.93 0.79 Discounted benefits Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NPV Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback In Year 1 © Cengage Learning 2016 FIGURE 4-5 JWD Consulting net present value and return on investment example

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Perform a financial analysis for a project using the format provided in Figure 4-5. Assume that the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9 percent discount rate, and round the discount factors to two decimal places. Create a spreadsheet or use the business case financials template on the companion website to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on
your financial analysis.

Discount rate
8%
Assume the project is completed in Year 0
Year
3 Total
140,000 40,000 40,000 40,000
0.79
1
2
Costs
Discount factor
Discounted costs
1
0.93
0.86
140,000 37,200 34,400 31,600 243,200
0 200,000 200,000 200,000
0.86
0 186,000 172,000 158,000 516,000|
Benefits
Discount factor
1
0.93
0.79
Discounted benefits
Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NPV
Cumulative benefits - costs (140,000) 8,800 146,400 272,800
ROI
112%
Payback In Year 1
© Cengage Learning 2016
FIGURE 4-5 JWD Consulting net present value and return on investment example
Transcribed Image Text:Discount rate 8% Assume the project is completed in Year 0 Year 3 Total 140,000 40,000 40,000 40,000 0.79 1 2 Costs Discount factor Discounted costs 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 0 200,000 200,000 200,000 0.86 0 186,000 172,000 158,000 516,000| Benefits Discount factor 1 0.93 0.79 Discounted benefits Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NPV Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback In Year 1 © Cengage Learning 2016 FIGURE 4-5 JWD Consulting net present value and return on investment example
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education