PP, IRR and NPV
Not what you're looking for?
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.