Perform financial analysis for a project using the formats provided in Figure 4-4, Figure 4-5 and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Perform financial analysis for a project using the formats provided in Figure 4-4, Figure 4-5 and Figure 4-6. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $180,000 in Year 0 and 50,000 each year in Years 1, 2, and 3. estimated benefits are $0 in Year 0 and $190,000 each year in Years 1, 2, and 3. Assume that costs and benefits are estimated at the beginning of the year. Use a 8.5 percent discount rate, and round the discount factors to two decimal places to do the following: 1) Calculate NPV using Excel NPV formula in a spreadsheet (similar to Fig 4-4). 2) Create a spreadsheet (similar to Fig 4-5) to calculate NPV, ROI, and payback period. 3) Show using a chart (similar to Fig 4-6) in which year the payback occurs. In addition, 4) write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. (Be sure to show all computations using formula - in Microsoft Excel) Figure 4-4. Net Present Value Example A Discount rate 15 16 17 13 Cash flow 14 NPV- B 10% с 1 2 3 PROJECT 1 YEAR 1 YEAR 2 4 Benefits $0 5 Costs $5,000 6 Cash flow 7 NPV- 8 9 10 PROJECT 2 YEAR 1 YEAR 2 YEAR 3 11 Benefits 12 Costs D E F YEAR 3 YEAR 4 YEAR 5 TOTAL $2,000 $3,000 $4,000 $5,000 $14,000 $1,000 $1,000 $1,000 $1,000 $9,000 $5,000, ($5,000) $1,000 $2,000 $3,000 $4,000 $2,316 Formula =npv(b1,b6:f6) G YEAR 4 $1,000 $2,000 $4,000 $4,000 $4,000 $2,000 ($1,000) $3,201 Formula =npv(b1,b13:f13) YEAR 5 TOTAL $15,000 $2,000 $2,000 $2,000 $2,000 $10,000 $0 $2,000 $2,000 $2,000 $5,000 Note that totals are equal, but NPVs are not because of the time value of money Figure 4-5. JWD Consulting NPV Example Discount rate 8% Assume the project is completed in Year 0 0 Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits Year ROI 1 2 140,000 40,000 40,000 40,000 1 0.93 0.86 0.79 140,000 37,200 34,400 31,600 243,200 3 Total 0 200,000 200,000 200,000 1 0.93 0.86 0.79 0 186,000 172,000 158,000 516,000 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 112% Payback In Year 1 Figure 4-6. Charting the Payback Period 600,000 500,000- 400,000- $ 300,000. 200,000 100,000 0 0 Payback Payback Cumulative costs Year 2 Cumulative benefits 3 Perform financial analysis for a project using the formats provided in Figure 4-4, Figure 4-5 and Figure 4-6. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $180,000 in Year 0 and 50,000 each year in Years 1, 2, and 3. estimated benefits are $0 in Year 0 and $190,000 each year in Years 1, 2, and 3. Assume that costs and benefits are estimated at the beginning of the year. Use a 8.5 percent discount rate, and round the discount factors to two decimal places to do the following: 1) Calculate NPV using Excel NPV formula in a spreadsheet (similar to Fig 4-4). 2) Create a spreadsheet (similar to Fig 4-5) to calculate NPV, ROI, and payback period. 3) Show using a chart (similar to Fig 4-6) in which year the payback occurs. In addition, 4) write a paragraph explaining whether you would recommend investing in this project, based on your financial analysis. (Be sure to show all computations using formula - in Microsoft Excel) Figure 4-4. Net Present Value Example A Discount rate 15 16 17 13 Cash flow 14 NPV- B 10% с 1 2 3 PROJECT 1 YEAR 1 YEAR 2 4 Benefits $0 5 Costs $5,000 6 Cash flow 7 NPV- 8 9 10 PROJECT 2 YEAR 1 YEAR 2 YEAR 3 11 Benefits 12 Costs D E F YEAR 3 YEAR 4 YEAR 5 TOTAL $2,000 $3,000 $4,000 $5,000 $14,000 $1,000 $1,000 $1,000 $1,000 $9,000 $5,000, ($5,000) $1,000 $2,000 $3,000 $4,000 $2,316 Formula =npv(b1,b6:f6) G YEAR 4 $1,000 $2,000 $4,000 $4,000 $4,000 $2,000 ($1,000) $3,201 Formula =npv(b1,b13:f13) YEAR 5 TOTAL $15,000 $2,000 $2,000 $2,000 $2,000 $10,000 $0 $2,000 $2,000 $2,000 $5,000 Note that totals are equal, but NPVs are not because of the time value of money Figure 4-5. JWD Consulting NPV Example Discount rate 8% Assume the project is completed in Year 0 0 Costs Discount factor Discounted costs Benefits Discount factor Discounted benefits Year ROI 1 2 140,000 40,000 40,000 40,000 1 0.93 0.86 0.79 140,000 37,200 34,400 31,600 243,200 3 Total 0 200,000 200,000 200,000 1 0.93 0.86 0.79 0 186,000 172,000 158,000 516,000 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 112% Payback In Year 1 Figure 4-6. Charting the Payback Period 600,000 500,000- 400,000- $ 300,000. 200,000 100,000 0 0 Payback Payback Cumulative costs Year 2 Cumulative benefits 3
Expert Answer:
Answer rating: 100% (QA)
1 NPV Calculation Discount rate 850 Project Year 0 Year 1 Year 2 Year 3 Benefits 0 190000 190000 190... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
Perform a financial analysis for a project using the format provided in figure. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Find the minimum and maximum values of (x, y) = x 2 y on the ellipse 4x 2 + 9y 2 = 36.
-
Lando Corporation is a domestic company with two wholly owned domestic subsidiaries. Michaels, CPA, has been engaged to audit the financial statements of the parent company and one of the...
-
The current through a \(60-\mathrm{W}\) light bulb is \(2 \mathrm{~A}\) when connected to a nonideal battery with \(\mathrm{emf} \mathscr{E}=120 \mathrm{~V}\). Determine the bulb's resistance and...
-
Develop the appropriate dimensionless parameters for the period \(\tau\) of transverse vibration of a turbine rotor of mass \(m\) connected to a shaft of stiffness \(k \doteq F / L\) and length...
-
Dylan worked for a propane gas distributor as an accounting clerk in a small Midwestern town. Last winter, his brother Mike lost his job at the machine plant. By January, temperatures were sub-zero,...
-
1. Many courses use group projects. What are some of the things that make positive group project experiences? 2. How can a manager motivate employees? Give some specific ideas. Include when you've...
-
Figure 13-31 is an SSD for the use case Check out books in the university library system. Do the following: a. Develop a first-cut sequence diagram that only includes the actor and problem domain...
-
For a population, the value of standard deviation is 2.65. A random sample of size 10 observations 8, 4, 10, 5, 5, 4, 9, 4, 3, 7. What is the point estimate of ? Also, find 90% confidence interval...
-
Define family law and identify the kinds of issues that are addressed in a family law practice.
-
Define slip and creep with respect to belt drives.
-
Define substantive fairness. What factors will a court consider in determining the substantive fairness of a premarital agreement?
-
Explain the role of clutch in power transmission.
-
Define unbundled legal services.
-
Construction Management organizations should provide training to all employees in: a) ethics and standards of practice b) AIA design standards for types of buildings done c) insurance fraud d)...
-
Juarez worked for Westarz Homes at construction sites for five years. Bever was a superintendent at construction sites, supervising subcontractors and moving trash from sites to landfills. He...
-
Use PowerPoint, Visio, or similar software to create a WBS in chart form (similar to an organizational chart-see the sample in the top of Figure). Assume the Level 2 categories are initiating,...
-
Why is activity definition the first process involved in project time management?
-
Describe three different types of software that can assist in project quality management.
-
Explain the difference between isotropic total cross-section and the transport crosssection as in Eq. (5.49). Why transport cross-section is not used in the transport theory? Data From Equation...
-
Following up on question number 3, assume the school conducts a manifestation determination meeting. Tim attends the meeting with his parents. At the meeting, Tim tells the team that smoking helps...
-
Which of the following is not a characteristic of a defined benefit plan? A. A guaranteed retirement benefit. B. Risk of preretirement inflation assumed by employer. C. Benefits based upon the...
Study smarter with the SolutionInn App