Reference no: EM13944388
Perform a financial analysis for a project using the format. Assume the costs and benefits for this project are spread over four years as follows.
Estimated costs are $155,000 in Year 1 and $5,000 each year in Years 2, 3 and 4. The discount factors will automatically be recalculated. Estimated benefits are $0 in Year 1 and $42,000 each year in Years 2, 3 and 4.
Use a 12% discount rate (interest rate). Use given template to calculate NPV and ROI, and year in which payback occurs.
Show your work by attaching the completed template and write a paragraph explaining whether you would recommend investing in this project based on your financial analysis.
AN INTRODUCTION TO PROJECT MANAGEMENT, FOURTH EDITION
Figure. Intranet project NPV example (Schwalbe, Information Technology Project Management, Sixth Edition, 2010)
|
Discount rate
|
4%
|
|
|
|
|
|
|
|
1
|
2
|
3
|
4
|
Total
|
|
|
Costs
|
150,000
|
5,000
|
5,000
|
4,000
|
|
|
|
Discount factor
|
0.96
|
0.92
|
0.89
|
0.85
|
|
|
|
Discounted costs
|
144,230.769
|
4,622.781
|
4,444.982
|
3,419.217
|
156,717.749
|
|
|
|
|
|
|
|
|
|
|
Benefits
|
0
|
80,000
|
80,000
|
80,000
|
|
|
|
Discount factor
|
0.96
|
0.92
|
0.89
|
0.85
|
|
|
|
Discounted benefits
|
0
|
73,964.497
|
71,119.709
|
68,384.335
|
213,468.541
4
|
|
|
|
|
|
|
|
|
|
|
Discounted benefits - costs
|
-144,230.769
|
69,341.716
|
66,674.727
|
64/965.119
|
56,750.792
|
NPV
|
|
Cumulative benefits - costs
|
-144,230.769
|
-74,889.053
|
-8,214.326
|
50750.792
|
|
|
|
|
|
|
|
|
|
|
|
ROI
|
0.362121027
|
|
|
|
|
|
|
|
|
|
|
Payback In Year 4
|
To determine NPV, follow these steps:
1. Determine the estimated costs and benefits for the life of the project and the products it produces. For example, the intranet project example assumed the project would produce a system in about six months that would be used for three years, so costs are included in Year o, when the system is developed, and ongoing system costs and projected benefits are included for Years 1, 2, and 3.
2. Determine the discount rate. A discount rate is the rate used in discounting future cash flows. It is also called the capitalization rate or opportunity cost of capital. In Figures 2-3 and 2-4, the discount rate is 10% per year, and in Figure 2-5, the discount rate is 8% per year.
|
A process heater uses dowtherm
: A process heater uses Dowtherm A heat transfer fluid to provide 850 kW of heat. Estimate the annual operating cost of the heater if the Dowtherm evaporator is 80% efficient and the price of natural gas is $4.60/MMBtu. Assume 8000 operating hours p..
|
|
Separate independent sample of people
: A demographer, using a random sample of n = 500 people, obtained a 95 percent confidence interval for mean age at marriage (m) in years for US adults. The CI was (26.4, 27.3). Suppose another demographer obtained a separate independent sample of p..
|
|
Memory that stores data sequentially
: A(n) _______ is a type of memory that stores data sequentially. Computers and communication systems use ________ to represent and transfer information between computers and network systems
|
|
Which part of soul discovers what is right and what is wrong
: Which part of the soul (and the city) discovers what is right and what is wrong? How is the judgment of this part of the soul related to the other parts when we act justly? How is it related to them when we act unjustly?
|
|
Determine the discount rate
: Determine the discount rate. A discount rate is the rate used in discounting future cash flows - Determine the estimated costs and benefits for the life of the project and the products it produces
|
|
Reasearch proposal-the pathway core module
: Context The pathway core module is intended to develop your critical and evaluative understanding of the pathway subject area and provide skills enabling you to argue for the value of your pathway specialism,
|
|
Power recovered from the preheated gases
: If the gases leave the tower at 6 atm, 25 °C, and are expanded to, say, 1.5 atm, calculate the turbine exit gas temperatures without preheat, and if the gases are preheated to 400 °C with the reactor off-gas. Also, estimate the power recovered fro..
|
|
Collection of emerald-cut diamonds
: The collection of emerald-cut diamonds contains replications, several diamonds at each weight. Had we fit the linear equation using average prices at each weight rather than individual diamonds, how would the fitted equation and summary measures r..
|
|
Discuss aristophanes plays the ecclesiazusae
: Discuss Aristophanes plays the Ecclesiazusae and The Cloud as attempts to make Socrates look ridiculous. Do they succeed? On the other hand, does Aristophanes have to change Socrates in order to make fun of Socrates?
|