Cash flow estimation and capital budgeting

Assignment Help Corporate Finance
Reference no: EM13932971

Cash Flow Estimation and Capital Budgeting

Applying Various Capital Budgeting Methodologies

The objective of a firm is to maximize shareholder wealth. The Net Present Value (NPV) method is one of the useful methods that help financial managers to maximize shareholders' wealth.

Suppose the company that you selected for the Module 1 SLP (Wal-Mart) is considering a new project that will have an initial cash outflow of $125,000,000. The project is expected to have the following cash inflows:

Year Cash Flow ($)

1 2,000,000

2 3,500,000

3 13,500,000

4 89,750,000

5 115,000,000

6 120,000,000

If the project's cost of capital (discount rate) is 12.5%, what is the project's NPV? Should the project be accepted? Why or why not?
You may use the following steps to calculate NPV:

1. Calculate present value (PV) of cash inflow (CF)

PV of CF = CF1 / (1+r)^1 + CF2 / (1+r)^2 + CF3 / (1+r)^3 + CF4 / (1+r)^4 + CF5 / (1+r)^5 + CF6 / (1+r)^6

Where the CFs are the cash flows and r = the project's discount rate.

2. Calculate NPV

NPV = Total PV of CF - Initial cash outflow

or -Initial cash outflow + Total PV of CF

r = Discount rate (12.5%)

If you do not know how to use Excel or a financial calculator for these calculations, please use the present value tables.

Online Learning Center. (n.d.) Present and Future Value Tables. Retrieved from https://highered.mheducation.com/sites/0072994029/student_view0/present_and_future_value_tables.html

Also, consider reviewing https://www.tvmcalcs.com for financial calculator tutorials.

Besides NPV, there are other capital budgeting methodologies including the regular payback period, discounted payback period, profitability index (PI), internal rate of return (IRR), and modified internal rate of return (MIRR). These methodologies don't necessarily give the same accept/reject decisions as NPV.

If the firm has a requirement that projects are paid back within 3 years, would the project be accepted based off the regular payback period? Why or why not? Would the project be accepted based off the discounted payback period? Why or why not?

What is the project's internal rate of return (IRR)? Based off IRR, should the project be accepted? Why or why not? Recall the project's cost of capital is 12.5%. What is the project's modified internal rate of return (MIRR)? Based off MIRR, should the project be accepted? Why or why not?

What are the advantages/disadvantages of NPV, regular payback, discounted payback, PI, IRR, and MIRR? Present these advantages/disadvantages in a table.

SLP Assignment Expectations

You are expected to:

• Describe the purpose of the report and provide a conclusion. An introduction and a conclusion are important because many busy individuals in the business environment may only read the first and the last paragraph. If those paragraphs are not interesting, they never read the body of the paper.

• Answer the SLP Assignment question(s) clearly and provide necessary details.

• Write clearly and correctly-that is, no poor sentence structure, no spelling and grammar mistakes, and no run-on sentences.

• Provide citations to support your argument and references on a separate page. (All the sources that you listed in the references section must be cited in the paper.) Use APA format to provide citations and references.

• Type and double-space the paper.

Whenever appropriate, please use Excel to show supporting computations in an appendix, present financial information in tables, and use the data computed to answer follow-up questions. In finance, in addition to being able to write well, it's important to present information in a professional manner and to analyze financial information. This is part of the assignment expectations and will be considered for grading purposes.

Verified Expert

Reference no: EM13932971

Questions Cloud

An express and local train leave grayslake : An express and local train leave GraysLake at 3 P.M. and hear for Chicago 60 miles away. The express travels twice as fast as the local and arrives 10 hour ahead of the local. Find the speed of each train?
How uk and germany compare on migration : Read the two newspaper articles, each of which adopts a different writing style: Article 1: Refugees welcome? How UK and Germany compare on migration (Appendix 1)
What particular features of global hearing implants market : Could you please provide some assistance with regard to these different features, or at least point me in the right direction to get this information as I'm finding it hard to list the different features for commodity markets and/or global hearing..
What is probability that the entire batch will be rejected : The Niko Electronics Company has just manufactured 5000 CDs, and 3% are defective. If 10 of the CDs are selected and tested, what is the probability that the entire batch will be rejected?
Cash flow estimation and capital budgeting : Describe the purpose of the report and provide a conclusion. An introduction and a conclusion are important because many busy individuals in the business environment may only read the first and the last paragraph
Do the calculations from requirements b and c : Do the calculations from Requirements b and c confirm your speculations in Requirement a?
What speed must he travel to reach a : Robert is travelling on his cycle and has calculated to reach point A at 2 P.M. if he travels at 10 kmph, he will reach there at 12 noon if he travels at 15 kmph. At what speed must he travel to reach A at 1 P.M.?
Variable costs and fixed costs at volume : A company has $6.20 per unit in variable costs and $4.90 per unit in fixed costs at a volume of 50,000 units. If the company marks up total cost by 0.42, what price should be charged if 66,000 units are expected to be sold?
Write the t distribution and its properties with useful exam : Write the t distribution and its properties with useful examples.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd