Purchase Solution

Understanding Capital Budgeting Practice Problems

Not what you're looking for?

Ask Custom Question

Part 1. Capital Budgeting Practice Problems
a Use expected cash flows:
Year Cash flow
0 -$400,000
1 $100,000
2 $120,000
3 $850,000

Show the PV with the following discount rates: 0%, 2%, 6%, 11%
What is IRR with a cost of capital of 5%?
Plot the discount rate on a chart, show where graph intersects horizontal axis.
Describe what you see in the chart/graph.

b. Use expected cash flows:
Year Cash flow
0 -$815,000

1 $141,000
2 $320,000
3 $440,000
Calculate the IRR.
Show the PV with the following discount rates: 1%, 4%, 10%, 18%
Plot the discount rate on a chart, show where graph intersects horizontal axis.
Describe what you see in the chart/graph.

c. What is the PV of a project requiring a $4.2 million investment has a profitability index of 0.94?

Purchase this Solution
Solution Summary

Your tutorial is attached in excel and includes using NPV and MIRR formulas in Excel to get needed amounts, two graphs with crossover points circled, discussion about the graphs and an analysis of finding NPV from profitability index. A reference for profitability index is included.

Solution Preview

Your tutorial is attached in excel and includes using NPV and MIRR ...

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
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.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Motivation

This tests some key elements of major motivation theories.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

View More Free Quizzes
Related BrainMass Solutions

  • understanding variances from budget; capital vs operations

    388124 Importance of understanding variances from budget; capital vs operations budgeting Why is understanding a variance from a budget so important? Why is capital budgeting done separately from a company operating budget?

  • Potential capital project for Apple, Inc.

    331630 Capital Budgeting Identify a potential capital project for Apple, Inc., describe the project and explain the problems they might encounter getting the funding to see it through.

  • Capital Rationing Model

    One method of doing this is capital budgeting.

  • Capital budgeting Practice True False Exam Questions

    597431 Capital budgeting Practice True False Exam Questions Net Present Value Practice True false questions 1. The three common discounted cash flow methods are net present value, internal rate of return, and payback. 2.

  • Capital Budgeting and Sensitivity Analysis Paper

    As per contemporary research, NPV analysis is the most preferred capital budgeting tool among CFOs worldwide (Graham et al., 2001) Fig. 1: Popularity of different capital budgeting methods Source: "The Theory and Practice of Corporate Finance: Evidence

  • Capital Budgeting Analysis

    Practice Capital Budgeting Analysis Develop an Excel spreadsheet for performing a capital budgeting analysis of the following project: Based on the following project assumptions, develop a capital budgeting analysis and determine the NPV and the IRR

  • Capital Budgeting Techniques for a Utility Company

    Capital budgeting: theory and practice. The Engineering Economist, 30(1), 19-46. Mukherjee, T. K. (2011). Capital Budgeting Techniques. Capital Budgeting Valuation: Financial Analysis for Today's Investment Projects, 13, 151.

  • Finance: Capital budgeting.

    405172 Capital Budgeting Practice Problems I need help with the problem down below. Thanks in advance. *********************** Part 1. Capital Budgeting Practice Problems a.

  • Capital Budgeting: Net present value, IRR, discount profile

    342388 Capital Budgeting: Net present value, IRR, discount profile Part 1. Capital Budgeting Practice Problems a.

View More Related Solutions