Purchase Solution

PP, IRR and NPV

Not what you're looking for?

Ask Custom Question

Need assistance with computing Payback period (PP), Internal Rate of Return (IRR), and Net present Value (NPV) of the attached file.

OPTION A OPTION B
OPERATING AND OPERATING AND
MAINTENANCE MAINTENANCE
YEAR CAPITAL COST ($) BENEFITS ($) CAPITAL COST ($) BENEFITS ($)
COST ($) COST ($)
(1) 2,000,000 0 0 2,500,000 0 0
(2) 1,000,000 10,000 0 500,000 50,000 750,000
(3) 500,000 70,000 120,000 100,000 750,000
(4) 90,000 600,000 100,000 750,000
(5) 90,000 800,000 100,000 750,000
(6) 90,000 800,000 100,000 750,000
(7) 90,000 800,000 100,000 750,000
(8) 90,000 800,000 100,000 750,000
(9) 100,000 800,000 100,000 750,000
(10) 100,000 500,000 100,000 300,000

The Required Return for this project is 12% and the Critical Acceptance Level is 2.75 years.
1 Using excel to calculate each of the following; show the steps:
(a) Payback Period for Option A & Option B
(b) Internal Rate of Return for Option A & Option B
(c) Net Present Value for Option A & Option B

2 Using the calculations above, clearly present the results for Option A and Option B as though for an audience of city council members.
3 The city council says they can adopt only one of the projects this year. Pick one and justify the choice to the city council.
4 You are getting pushback from the city engineer that both projects are vital and should be done this year. You really want to find a way to make both projects happen. Provide a solution that will allow both projects to be implemented.

Please see the attached excel file

Purchase this Solution

Solution Summary

Solution helps in computation of PP, IRR and NPV

Solution Preview

Need assistance with computing Payback period (PP), Internal Rate of Return (IRR), and Net present Value (NPV) for two hypothetical public infrastructure projects that have the economic profile that follow:

OPTION A OPTION B
OPERATING AND OPERATING AND
MAINTENANCE MAINTENANCE
YEAR CAPITAL COST ($) BENEFITS ($) CAPITAL COST ($) BENEFITS ($)
COST ($) COST ($)
(1) 2,000,000 0 0 2,500,000 0 0
(2) 1,000,000 ...

Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Motivation

This tests some key elements of major motivation theories.