Purchase Solution

Accounting: Capital budgeting and Decision Making

Not what you're looking for?

Ask Custom Question

The attached spreadsheet has the inputs and capital budget net cash flows analysis for an investment of $1,000,000 over 10 years, with a WACC of 7.67%.

1) Calculate the Net Present Value, IRR, Profitability Index and Payback Years for this capital budget.

2)Prepare a scenario analysis with the following data:
a) Base Case (average scenario)= 25,000 units sold per year= 55% probability
b) Worst case scenario= 18,750 units sold per year- 25% probability
c) Best Case scenario= 31,250 units sold per year- 20% probability
d) Determine the scenario analysis for NPV and IRR?
e) What does the Risk assessment tell you about the project?

Attachments
Purchase this Solution

Solution Summary

The problem set deals with questions under finance, specifically capital budgeting. The problem set includes net present value, payback and internal rate of return. A Word document and Excel spreadsheet are attached.

Solution Preview

1) Calculate the Net Present Value, IRR, Profitability Index and Payback Years for this capital budget.
Base Case Scenario
Net present value (NPV) ($442,945.70)
IRR -1.93%
Profitability index 0.56
Payback period >10 Years

2) Prepare a scenario analysis with the following data:
a) Base Case (average scenario)= 25,000 units sold per year= 55% probability
b) Worst case scenario= 18,750 units sold per year- 25% probability
c) Best Case scenario= 31,250 units sold per year- 20% ...

Solution provided by:
Education
  • B. Sc., University of Nigeria
  • M. Sc., London South Bank University
Recent Feedback
  • "Thank you."
  • "thank you Chidi Ngene.. if you have any APA references would be great"
  • "Thank you so much for your help, your explanations were easy to understand and apply!"
  • "are you able to highlight the equations used either on the xlsx or a word doc as to how each graph was formed- overall looks fine i just need help understanding this myself"
  • "Chidi Ngene, M. Sc. Was extremely helpful as without the help and guidance I would have failed, but with the help I passed. I still have a lot to learn and in need of the guidance to understand and learn more on the subject. I would recommend Chidi Ngene and BrainMass to anyone that are in need of help. Thank you!!"
Purchase this Solution


Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Introduction to Finance

This quiz test introductory finance topics.