Calculate the project irr for the most likely results

Assignment Help Finance Basics
Reference no: EM131223136

LASA: NPV, Sensitivity, Risk, Bias and Ethics in Capital Budgeting

Investment projects should never be selected through purely mechanical processes. Managers should ask questions about the positive net present value (NPV). Good managers realize that the forecasts behind NPV calculations are imperfect. Therefore, they explore the consequences of a poor forecast and check whether it is worth doing more homework. They use several different tools and analysis techniques to answer their "what-if" questions.

In addition, managers should consider the types of bias, both unintentional and intentional, that may enter into the capital budgeting analysis. As part of this assignment, you will examine the potential motivation for unethical behavior by executives that may take place in the capital budgeting process and explain how biasing cash-flow estimates can work to the advantage of the executive who intentionally inserts such bias.

Assume that you are employed by a wood milling company that is evaluating the desirability of adding a new product to their product mix. The product would require the addition of new and different CNC (computer numerical control) milling equipment. Your boss has asked you to analyze a project proposal and recommend whether the project should be accepted or rejected. The most likely project estimates are:

• Unit selling price = $50
• Unit variable cost = $30
• Total fixed costs including depreciation = $300,000
• Expected sales = 30,000 units per year

The projects will last for 10 years and will require an initial investment of $1 million, which will be depreciated straight-line over the project life to a final value of zero. The firm's tax rate is 35% and the required rate of return is 12%.

Your boss recognizes that some of these estimates are subject to error and wants to better understand the risks associated with the project and alternatives for dealing with those risks. You have been asked to include a sensitivity analysis in your report. You are also to explain how changing the discount rate might be helpful.

Your boss has heard about cash flow estimates being biased for personal gain at the company's expense in another firm and would like to better understand that potential problem. You have been asked to address that in your report.

The team developing the proposal estimated that variable cost and sales volume may each turn out to be as much as 10% higher or 10% lower than the initial estimate. To complete this assignment, you are to submit a four to five page paper that includes the following:

Using MS Excel:

• Calculate the project's NPV for the most likely results.
• Calculate the project's NPV for the best-case scenario.
• Calculate the project's NPV for the worst-case scenario.
• Calculate the project IRR for the most likely results.

You will transfer your calculations into your final report. In a 4-5 page paper in MS Word:

• Exhibit your Excel function entries and results, or your calculations using present value tables, for each of your NPV and IRR calculations (A-D) and provide an explanation of all calculations

• Explain your recommendation regarding whether the project should be accepted and a justification of your response.

• Provide an explanation of how adjusting the discount rate in the basic NPV model of capital budgeting deals with the problem of project risk.

• Examine the potential motivation for unethical behavior by executives that may take place in the capital budgeting process and explain how biasing cash-flow estimates can work to the advantage of the executive who intentionally inserts such bias.

The paper must be submitted as a Word document and it must follow APA style guidelines.

Reference no: EM131223136

Questions Cloud

Construct a program flowchart and corresponding pseudcode : Construct a program flowchart and corresponding pseudcode that will compute and output the first number greater than 100 in the preceding series. No input is required.
Generate annually for purchase to be economically viable : MARTA is considering purchasing a fleet of 20 solar powered mini buses. The anticipated purchase price of the fleet is $1,500,000 or $75,000 per bus. Each mini bus is expected to have a useful life of four years when it can be sold for $5000. Assumin..
Two countries with a fixed exchange rate : Observe that two countries with a fixed exchange rate have current inflation rates that differ from each other.- How would you explain these observations in light of the theory of purchasing power parity?
Which statement is not true regarding hydroelectric power : What is the central difference between climate and weather discussed in your text? What is the central theme of the "As Cheap as Coal" portion in Section 8.1 of your text?
Calculate the project irr for the most likely results : Calculate the project's NPV for the most likely results. Calculate the project's NPV for the best-case scenario. Calculate the project's NPV for the worst-case scenario. Calculate the project IRR for the most likely results.
What is total tax liability for the year : Ying, age 15, is a dependent of her parents, who are in the 28% income tax bracket. Ying has the following income for the current year: $4,300 wages from a part time job; $3,000 interest income from a corporate bonds that she owns, and $1200 short-te..
Adopt a hard peg as an exchange rate regime : Explain why a consensus has developed that countries should either allow their exchange rates to float freely or adopt a hard peg as an exchange-rate regime?
Find two articles that discuss financial ratio analysis : Using the Ashford University Library as a resource, find two articles that discuss financial ratio analysis. Identify two advantages and two disadvantages to using ratios in financial analysis.
Compute interest expense for the semi-annual period : On January 1, 2013 the Mack Company issues $16,000,000 of 11% bonds dated January 1. Interest is payable semiannually on June 30 and December 31. The bonds mature in 4 years. The issue price of the bonds was $16,517,057.02 with no bond issue cost. qu..

Reviews

Write a Review

 

Finance Basics Questions & Answers

  What is the company expected growth rate

a. What is the company's expected growth rate? b. If the firm's net income is expected to be $1.1 billion, what portion of its net income is the firm expected to pay out as dividends?

  Value of martell minings stock

If D0=5 and r=9%, what is the value of Martell Minings stock?

  Determine expected payment

Determine expected payment

  In mid march 2007 the us dollar equivalent of a euro was

in mid march 2007 the u.s. dollar equivalent of a euro was 1.3310. in mid july 2009 the u.s. dollare equivalent of a

  What tables might you use from the compound interest charts

What factors would you consider in making your finacial evaluation? What tables might you use from the Compound Interest charts and why?

  Calculate the net present value of this investment assuming

you are considering the purchase of an apartment complex. the following assumptions are made the purchase price is

  A leader in your firm has been studying the foreign

deliverable length750-950 words detailsa leader in your firm has been studying the foreign exchange market for a number

  Health care fundamental financing concepts

Health Care Financing is an introduction to health care's fundamental financing concepts. The interaction of funding resources among government agencies and the private sector in the funding of health services is explored.

  Define the pe valuation method under what circumstances

define the pe valuation method. under what circumstances should a stock be valued using this

  What is your aproxx real rate of return on this investment

You purchased a stock for 47.10, over course of a yr you got $2.40 per share in dividends and inflation avged 3.4 percent. Today you sold your shares for 49.50 a share. What is your aproxx real rate of return on this investment?

  Estimated losses from uncollectible accounts

On December 31, prior to adjustment, Allowance for Doubtful Accounts has a credit balance of $200. An age analysis of the accounts receivable produces an estimate of $1,000 of probable losses from uncollectible accounts. The adjusting entry needed..

  Using foreign-currency futures options instead of underlying

Using foreign-currency futures options instead of underlying foreign-currency futures contracts:

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