Perform a financial analysis for a project using the format table provided in the picture below. Assume the projected costs and benefits for this project are spread over four years as follow: Estimated costs are $150,000 in Year 1 and $35,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $85,000 each year in Years 2, 3, and 4. Use a 12 percent discount rate and round the discount factors to two decimal places. Create a table to calculate and display the NPV, ROI, and year in which payback occurs.

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
icon
Concept explainers
Topic Video
Question

Perform a financial analysis for a project using the format table provided in the picture below. Assume the projected costs and benefits for this project are spread over four years as follow: Estimated costs are $150,000 in Year 1 and $35,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $85,000 each year in Years 2, 3, and 4. Use a 12 percent discount rate and round the discount factors to two decimal places. Create a table to calculate and display the NPV, ROI, and year in which payback occurs. 

4567
15
A
1 Discount rate
2
3 PROJECT 1 YEAR 1 YEAR 2
4 Benefits
$0
$2,000
5 Costs
$5,000
$1,000
6 Cash flow
7 NPV-
8
9
10 PROJECT 2 YEAR 1 YEAR 2 YEAR 3
11 Benefits
$1,000 $2,000 $4,000
$2,000 $2,000 $2,000
12 Costs
13 Cash flow
$0 $2,000
14 NPV
16
B
10%
17
C
D
E
YEAR 3 YEAR 4
$3,000 $4,000
$1,000 $1,000
($1,000)
$3,201
Formula =npv(b1,b13:f13)
F
LL
($5,000) $1,000 $2,000 $3,000 $4,000
$2,316
Formula =npv(b1,b6:f6)
G
YEAR 5 TOTAL
$5,000 $14,000
$1,000
$9,000
$5,000,
YEAR 4
YEAR 5 TOTAL
$4,000 $4,000 $15,000
$2,000 $2,000 $10,000
$2,000
$2,000 $5,000
Note that totals are
equal, but NPVs are
not because of the
time value of money
Transcribed Image Text:4567 15 A 1 Discount rate 2 3 PROJECT 1 YEAR 1 YEAR 2 4 Benefits $0 $2,000 5 Costs $5,000 $1,000 6 Cash flow 7 NPV- 8 9 10 PROJECT 2 YEAR 1 YEAR 2 YEAR 3 11 Benefits $1,000 $2,000 $4,000 $2,000 $2,000 $2,000 12 Costs 13 Cash flow $0 $2,000 14 NPV 16 B 10% 17 C D E YEAR 3 YEAR 4 $3,000 $4,000 $1,000 $1,000 ($1,000) $3,201 Formula =npv(b1,b13:f13) F LL ($5,000) $1,000 $2,000 $3,000 $4,000 $2,316 Formula =npv(b1,b6:f6) G YEAR 5 TOTAL $5,000 $14,000 $1,000 $9,000 $5,000, YEAR 4 YEAR 5 TOTAL $4,000 $4,000 $15,000 $2,000 $2,000 $10,000 $2,000 $2,000 $5,000 Note that totals are equal, but NPVs are not because of the time value of money
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
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