Explain scenario analysis and any problems

Assignment Help Finance Basics
Reference no: EM131076458

Iron Ore What? (IOW) Casting Company is considering adding a new line to its product mix. Sydney Johnson, a recently minted MBA, will be conducting the capital budgeting analysis. The new production line would be set up in unused space in IOW's main plant. The machinery invoice price totals approximately $250,000, with another $20,000 in shipping charges and $30,000 to install the equipment, for a total requirement estimated at $300,000. The machinery has an economic life of 4 years, and IOW has obtained a special tax ruling that places the equipment in the Modified Accelerated Cost Recovery System (MACRS) 3-year class. After 4 years of use the machinery is expected to have a salvage value of $25,000.

The new product line would generate incremental sales of 1,350 units per year for 4 years at an incremental cost of $100 per unit in the first year, excluding depreciation. Each unit can be sold for $200 each in the first year. The sales price and cost are expected to increase by 3% per year due to inflation. Further, to handle the new line, the firm's net working capital would have to increase by an amount equal to 15% of sales revenues. The firm's tax rate is 40%, and its overall weighted average cost of capital is 12%.

1. Calculate and provide the annual sales revenues and costs (other than depreciation). Why is it important to include inflation when estimating cash flows?

2. Construct 4 years of annual incremental operating cash flow statements for IOW Casting Company. Estimate the required net working capital for each year, and the cash flow due to investments in net working capital. Calculate the after-tax salvage cash flow.

3. Calculate the net cash flows for each of the 4 years. Based on these cash flows, what are the project's NPV, IRR, MIRR, PI, payback, and discounted payback? Do these indicators suggest the project should be undertaken? Explain.

4. What does the term "risk" mean in the context of capital budgeting? To what extent can risk be quantified, and, when risk is quantified, is the quantification based primarily on statistical analysis of historical data or on subjective, judgmental estimates? Provide your rationale.

5. Describes sensitivity analysis and discuss a) its primary weakness; and b) its primary usefulness? For the IOW project, perform a sensitivity analysis on the unit sales, salvage value, and cost of capital. Assume that each of these variables can vary from its expected, or "base-case" value by ± 10%, ± 20%, and ± 30%. Include a sensitivity diagram, and discuss the results.

6. Assume that Sydney Johnson is confident of her estimates of all the variables that affect the project's cash flows except unit sales and sales price. If product acceptance is poor, unit sales could be only approximately 1,000 units a year and the unit price would be set at $150. Conversely, an excellent consumer response could produce sales of 2,000 units and a unit price of $220. Sidney believes that there is a 25% chance of poor acceptance, a 25% chance of excellent acceptance, and a 50% chance of average acceptance (the base case). What is the worst-case NPV? The best-case NPV? Use the worst-, base-, and best-case NPVs and probabilities of occurrence to find the project's expected NPV, standard deviation, and coefficient of variation.

7. Explain scenario analysis and any problems, issues, or concerns that surround this type of projection.

8. Define simulation analysis, and discuss its principal advantages and disadvantages.

9. Assume that IOW's average project has a coefficient of variation in the range of 0.2 to 0.4. Would the new product line be classified as high risk, average risk, or low risk? What type of risk is being measured here?

10. IOW typically adds or subtracts 5 percentage points to the overall cost of capital to adjust for risk. Given this consideration, should the new line be accepted? Explain.

11. Describe other subjective risk factors that should be considered before the final decision is made, and their individual impact on the project.

Reference no: EM131076458

Questions Cloud

A system consists of five identical components : As soon as one component fails, the entire system will fail. Suppose each component has a lifetime that is exponentially distributed with λ = .01 and that components fail independently of one another.
Find the points on the ellipse : Find the points on the ellipse 4x2 + y2 = 4 that are farthest away from the point (1, 0). Find the area of the largest rectangle that can be inscribed in the ellipse x2/a2 + y2/b2 = 1
Health care financial reform proposal : Write a paper (1,500-2,000 words) on what you think should be included in a future reform of the health care system, focusing on financial operating changes that would improve efficiency and provide for improved transparency to the public. Include..
The special case of the gamma distribution : The special case of the gamma distribution in which a is a positive integer n is called an Erlang distribution. If we replace b by 1/l in Expression (4.8), the Erlang pdf is
Explain scenario analysis and any problems : Explain scenario analysis and any problems, issues, or concerns that surround this type of projection. Define simulation analysis, and discuss its principal advantages and disadvantages.
Discuss appropriate laws and ethical theories : Provide the summary of the case and identify and state clearly the problem(s) or issue(s) in the case and discuss appropriate laws and ethical theories
Is the resulting tree''s height a minimum : Is the resulting tree's height a minimum? Is the tree complete? Is it full?
Suppose that when a transistor of a certain type : Suppose that when a transistor of a certain type is subjected to an accelerated life test, the lifetime X (in weeks) has a gamma distribution with mean 24 weeks and standard deviation 12 weeks.
The two-parameter gamma distribution : The two-parameter gamma distribution can be generalized by introducing a third parameter g, called a threshold or location parameter: replace x in (4.8) by x - g and  This amounts to shifting the density curves in Figure 4.27 so that they begin the..

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

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