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

M3 Assignment 2 Submission Assignment 2: LASA 1: NPV, Sensitivity, Risk, Bias and Ethics in Capital BudgetingInvestment 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 yearThe 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.By the due date assigned, deliver your assignment to the Submissions Area.Assignment 2 Grading Criteria 
Maximum PointsCalculated and explained the correct NPV for the most likely results. 24Calculated the correct NPV for the best-case scenario and explained results. 20Calculated the correct NPV for the worst-case scenario and explained results. 20Calculated and explained the correct IRR for the most likely results 20Recommended acceptance or rejection of the project and explained the reasons for that recommendation. 20Explained how adjusting the discount rate in the basic NPV model of capital budgeting deals with the problem of project risk. 16Explained the potential motivation for unethical behavior by executives that may take place in the capital budgeting process and how biasing cash-flow estimates can work to the advantage of the executive who intentionally inserts such bias. 36Style (4 points): Tone, audience, and word choice
Organization (12 points): Introduction, transitions, and conclusion
Usage and Mechanics (12 points): Grammar, spelling, and sentence structure
APA Elements (16 points): In text citations and references, paraphrasing, and appropriate use of quotations and other elements of style 44Total: 200
Approximate price: $22
We value our customers and so we ensure that what we do is 100% original..

With us you are guaranteed of quality work done by our qualified experts.Your information and everything that you do with us is kept completely confidential.You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.The Product ordered is guaranteed to be original. Orders are checked by the most advanced anti-plagiarism software in the market to assure that the Product is 100% original. The Company has a zero tolerance policy for plagiarism.The Free Revision policy is a courtesy service that the Company provides to help ensure Customer’s total satisfaction with the completed Order. To receive free revision the Company requires that the Customer provide the request within fourteen (14) days from the first completion date and within a period of thirty (30) days for dissertations.The Company is committed to protect the privacy of the Customer and it will never resell or share any of Customer’s personal information, including credit card data, with any third party. All the online transactions are processed through the secure and reliable online payment systems.By placing an order with us, you agree to the service we provide. We will endear to do all that it takes to deliver a comprehensive paper as per your requirements. We also count on your cooperation to ensure that we deliver on this mandate.