Fundamentals of Corporate Finance
Fundamentals of Corporate Finance
11th Edition
ISBN: 9780077861704
Author: Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Bradford D Jordan Professor
Publisher: McGraw-Hill Education
bartleby

Videos

Textbook Question
Book Icon
Chapter 11, Problem 27QP

Scenario Analysis [LO2] Consider a project to supply Detroit with 35,000 tons of machine screws annually for automobile production. You will need an initial $5,200,000 investment in threading equipment to get the project started; the project will last for five years. The accounting department estimates that annual fixed costs will be $985,000 and that variable costs should be $185 per ton; accounting will depreciate the initial fixed asset investment straight-fine to zero over the five-year project life. It also estimates a salvage value of $500,000 after dismantling costs. The marketing department estimates that the automakers will let the contract at a selling price of $280 per ton. The engineering department estimates you will need an initial net working capital investment of $410,000. You require a return of 13 percent and face a marginal tax rate of 38 percent on this project.

a. What is the estimated OCF for this project? The NPV? Should you pursue this project?

b. Suppose you believe that the accounting department’s initial cost and salvage value projections are accurate only to within ±15 percent; the marketing department’s price estimate is accurate only to within ±10 percent; and the engineering department’s net working capital estimate is accurate only to within ±5 percent. What is your worst-case scenario for this project? Your best-case scenario? Do you still want to pursue the project?

a)

Expert Solution
Check Mark
Summary Introduction

To determine: The estimated operating cash flow (OCF) and Net present value of the project.

Introduction:

Net present value (NPV) refers to the discounted value of the future cash flows at present. In case, the NPV is positive or greater than zero, then the company will accept the project or vice-versa. If there are two mutually exclusive projects, then the company has to select the project that has higher net present value.

Answer to Problem 27QP

The estimated Operating cash flow is $1,846,000.

The NPV of the project is $1,273,596.06.

Explanation of Solution

Given information:

The annual fixed costs are $985,000, variable cost per unit is $185 per ton, number of quantity supplied is 35,000, marginal tax rate is 38%, initial investment on the equipment is $5,200,000, and life of the project is five years. The net initial working capital investment is $410,000 and the required rate of return is 13%.

Formulae:

The formula to calculate the operating cash flow:

Operating cash flow=[(Pv)QFC]×(1Tax rate)+Tax rate×Depreciation

Where,

P refers to the price per unit of the project,

v refers to the variable cost per unit,

Q refers to the number of unit sold,

FC refers to the fixed costs.

The formula to calculate the NPV:

NPV =([(Initial investmentInitial working capital investment)+(Estimated Operating cash flow(Present value of an annuity of $1 period for R% of N period))]+[Net initial working capital investment+Salvage value(1Marginal tax rate)(1+Required rate of return)n])

Where,

n refers to the number of years.

Compute the Operating cash flow (OCF):

Operating cash flow=[(Pv)QFC]×(1Tax rate)+Tax rate×Depreciation=[($280-185)×35,000$985,000]×(138100)+38100×($5,200,0005)=[$95×35,000$985,000](10.38)+(0.38×$1,040,000)=[$3,325,000$985,000]×0.62+$395,200=($2,340,000×0.62)+$395,200=$1,450,800+$395,200=$1,846,000

Hence, the estimated Operating cash flow (OCF) is $1,846,000.

Compute the NPV:

Note: To determine the present value of annuity of $1 period for 8 period at a discount rate of 10%, refer the PV of an annuity of $1 table. Then, find out the 10% discount rate and period of 8 years’ value from the table. Here, the value for the rate 10% and 8 years’ period value is 5.3349.

Net present value =([(Initial investmentInitial working capital investment)+(Estimated Operating cash flow(Present value of an annuity of $1 period for R% of N period))]+[Net initial working capital investment+Salvage value(1Marginal tax rate)(1+Required rate of return)n])=($5,200,000$410,000+$1,846,000(Present value of an annuity of $1 period for 13% of 5 period)+[$410,000+$500,000×(138100)](1+13100)5)=($5,200,000$410,000+$1,846,000(3.51723)+$410,000+($500,000×0.62)1.842435)=($5,200,000$410,000+$6,492,806.58+($410,000+$3,100,0001.842435))=$882,806.58+($720,0001.842435)=$882,806.588+$390787.19=$1,273,593.77

Hence, the NPV is $1,273,593.77.

Expert Solution
Check Mark
Summary Introduction

To discuss: Whether the project is pursued or not based on the computation of NPV.

Explanation of Solution

A project is accepted, when the net present value is positive or greater than zero. This project indicates a positive NPV of $1,273,593.77. Therefore, the project is pursed.

b)

Expert Solution
Check Mark
Summary Introduction

To determine: The worst-case scenario and best-case scenario of the project.

Introduction:

Scenario analysis is a process of analyzing the possible future events. This analysis helps to determine the effect of what-if questions towards the net present value estimates. At the time when the firm begins to look for an alternative, then they might be able to find the possible project, which would result in a positive net present value (NPV).

Answer to Problem 27QP

Worst-case scenario:

The operating cash flow of the worst-case is $1,297,680.

The Net present value (NPV) of the worst-case is -$1,469,585.54.

Best-case scenario:

The operating cash flow of the best-case is $2,394,320.

The Net present value (NPV) of best-case scenario is -$3,206,975.18195.

Explanation of Solution

Given information:

The fixed costs of the project are $985,000. The variable cost per unit is $185 per ton and selling price per unit of the project is $280 per ton. The unit sold is 35,000 tons, required rate of return is 13%, and marginal tax rate is 38%.

The initial cost and salvage value of the projection is ±15%. The price estimate will be accurate within ±10% as per the marketing department. The estimate of net working capital is ±5%.

Formulae:

The formula to calculate the operating cash flow for best or worst-cases scenarios:

Operating cash flow of best or worst case scenario}=[(Pv)QFC]×(1Tax rate)+Tax rate×Depreciation

Where,

P refers to the price per unit of the project,

v refers to the variable cost per unit,

Q refers to the number of units sold,

FC refers to the fixed costs.

The formula to calculate the NPV of best or worst-cases:

Net present value of best or worst-cases}=Initial investment+Best or worst-cases operating cash flow

Note: In the best-case scenario, both the price and sales indicate an increase in the value; whereas, the costs will indicate a decrease in the value. In the worst-case scenario, both the price and sales indicate a decrease but the costs will specify an increase in the value.

Compute the operating cash flow for worst-case scenario:

Note: The tax shield approach is used to determine the operating cash flow of worst-case scenario. In this problem, the price and quantity is decreased by 10%. As a result, both the price and quantity is multiplied by a 10 percent decrease. However, the variable and fixed costs will indicate an increase by 15 percent.

Operating cash flow of worst case scenario}=[(Pv)QFC]×(1Tax rate)+Tax rate×Depreciation=[[($280×(110100)$185)35,000$985,000]×(138100)+38100×$5,200,000×(1+15100)5]=[[(($280×0.9)$185)35,000$985,000]×0.62+0.38×($5,200,000×1.15)5]=[$252$185×35,000$985,000]×0.62+0.38×($5,980,0005)=[($67×35,000)$985,000]×0.62+(0.38×$1,196,000)=[$2,345,000$985,000]×0.62+$454,480=($1,360,000×0.62)+$454,480=$843,200+$454,480=$1,297,680

Hence, the operating cash flow of worst-case scenario is $1,297,680.

Compute the NPV of worst-case scenario:

Net present value =([(Initial investmentInitial working capital investment)+(Estimated Operating cash flow(Present value of an annuity of $1 period for R% of N period))]+[Net initial working capital investment+Salvage value(1Marginal tax rate)(1+Required rate of return)n])=($5,200,000(1+15100)$410,000(1+5100)+$1,297,680(Present value of an annuity of $1 period for 13% of 5 period)+[$410,000(1+5100)+$500,000(115100)×(138100)](1+13100)5)=($5,200,000(1.15)$410,000(1.05)+$1,297,680(3.51723)+$410,000(1.05)+($500,000×0.85×0.62)1.842435)=($5,980,000$430,500+$4,564,239.02+($430,500+$263,5001.842435))=$1,846,260.98+($694,0001.842435)=$1,846,260.98+$376,675.43224=$1,469,585.54

Hence, the NPV of worst-case scenario is -$1,469,585.54.

Compute the operating cash flow for best-case scenario:

Operating cash flow of best case scenario}=[(Pv)QFC]×(1Tax rate)+Tax rate×Depreciation=[[($280×(1+10100)$185)35,000$985,000]×(138100)+38100×$5,200,000×(115100)5]=[[(($280×1.1)$185)35,000$985,000]×0.62+0.38×($5,200,000×0.85)5]=[$308$185×35,000$985,000]×0.62+0.38×($4,420,0005)=[($123×35,000)$985,000]×0.62+(0.38×$884,000)=[$4,305,000$985,000]×0.62+$335,920=($3,320,000×0.62)+$335,920=$2,058,400+$335,920=$2,394,320

Hence, the operating cash flow of best-case scenario is $2,394,320.

Compute the NPV of best-case scenario:

Net present value =([(Initial investmentInitial working capital investment)+(Estimated Operating cash flow(Present value of an annuity of $1 period for R% of N period))]+[Net initial working capital investment+Salvage value(1Marginal tax rate)(1+Required rate of return)n])=($5,200,000(115100)$410,000(15100)+$2,394,320(Present value of an annuity of $1 period for 13% of 5 period)+[$410,000(15100)+$500,000(1+15100)×(138100)](1+13100)5)=($5,200,000(0.85)$410,000(0.95)+$2,394,320(3.51723)+$410,000(0.95)+($500,000×1.15×0.62)1.842435)=($4,420,000$389,500+$8,421,374.1336+($389,500+$356,5001.842435))=$3,611,874.1336+($746,0001.842435)=$3,611,874.1336+$404,898.95165=$3,206,975.18195

Hence, the NPV of best-case scenario is −$3,206,975.18195. Both the best and worst-case scenarios indicate a negative NPV. Therefore, it will be difficult to proceed with project.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
13. Project Analysis You are considering a new product launch. The project will cost $1.675 million, have a four-year life, and have no salvage value; depreciation is straight-line to zero. Sales are projected at 195 units per year; price per unit will be $16,300; variable cost per unit will be $9,400; and fixed costs will be $550,000 per year. The required return on the proiect is 12 percent and the relevant tax rate is 21 percent. a. Based on your experience, you think the unit sales, variable cost, and fixed cost projections given here are probably accurate to within #10 percent. What are the upper and lower bounds for these projections? What is the base-case NPV? What are the best-case and worst-case scenarios? b. Evaluate the sensitivity of your base-case NPV to changes in fixed costs. c. What is the accounting break-even level of output for this project? use excel to solve this
so.4
A 15. Subject:- finance

Chapter 11 Solutions

Fundamentals of Corporate Finance

Ch. 11.5 - What is operating leverage?Ch. 11.5 - How is operating leverage measured?Ch. 11.5 - Prob. 11.5CCQCh. 11.6 - What is capital rationing? What types are there?Ch. 11.6 - Prob. 11.6BCQCh. 11 - Prob. 11.1CTFCh. 11 - Marcos Entertainment expects to sell 84,000...Ch. 11 - Delta Tool has projected sales of 8,500 units at a...Ch. 11 - What is true for a project if that project is...Ch. 11 - A capital-intensive project is one that has a...Ch. 11 - Pavloki, Inc., has three proposed projects with...Ch. 11 - Forecasting Risk [LO1] What is forecasting risk?...Ch. 11 - Sensitivity Analysis and Scenario Analysis [LO1,...Ch. 11 - Prob. 3CRCTCh. 11 - Operating Leverage [LO4] At one time at least,...Ch. 11 - Operating Leverage [LO4] Airlines offer an example...Ch. 11 - Prob. 6CRCTCh. 11 - Prob. 7CRCTCh. 11 - Prob. 8CRCTCh. 11 - Prob. 9CRCTCh. 11 - Scenario Analysis [LO2] You are at work when a...Ch. 11 - Calculating Costs and Break-Even [LO3] Night...Ch. 11 - Prob. 2QPCh. 11 - Scenario Analysis [LO2] Sloan Transmissions, Inc.,...Ch. 11 - Sensitivity Analysis [LO1] For the company in the...Ch. 11 - Sensitivity Analysis and Break-Even [LO1, 3] We...Ch. 11 - Prob. 6QPCh. 11 - Prob. 7QPCh. 11 - Calculating Break-Even [LO3] In each of the...Ch. 11 - Calculating Break-Even [LO3] A project has the...Ch. 11 - Using Break-Even Analysis [LO3] Consider a project...Ch. 11 - Calculating Operating Leverage [LO4] At an output...Ch. 11 - Leverage [LO4] In the previous problem, suppose...Ch. 11 - Operating Cash Flow and Leverage [LO4] A proposed...Ch. 11 - Cash Flow and Leverage [LO4] At an output level of...Ch. 11 - Prob. 15QPCh. 11 - Prob. 16QPCh. 11 - Sensitivity Analysis [LO1] Consider a four-year...Ch. 11 - Operating Leverage [LO4] In the previous problem,...Ch. 11 - Project Analysis [LO1, 2, 3, 4] You are...Ch. 11 - Project Analysis [LO1, 2] McGilla Golf has decided...Ch. 11 - Prob. 21QPCh. 11 - Sensitivity Analysis [LO1] McGilla Golf would like...Ch. 11 - Break-Even Analysis [LO3] Hybrid cars are touted...Ch. 11 - Break-Even Analysis [LO3] In an effort to capture...Ch. 11 - Prob. 25QPCh. 11 - Operating Leverage and Taxes [LO4] Show that if we...Ch. 11 - Scenario Analysis [LO2] Consider a project to...Ch. 11 - Sensitivity Analysis [LO1] In Problem 27, suppose...Ch. 11 - Prob. 29QPCh. 11 - Prob. 30QP
Knowledge Booster
Background pattern image
Finance
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Text book image
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Text book image
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Text book image
International Financial Management
Finance
ISBN:9780357130698
Author:Madura
Publisher:Cengage
Text book image
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Accounting for Derivatives Comprehensive Guide; Author: WallStreetMojo;https://www.youtube.com/watch?v=9D-0LoM4dy4;License: Standard YouTube License, CC-BY
Option Trading Basics-Simplest Explanation; Author: Sky View Trading;https://www.youtube.com/watch?v=joJ8mbwuYW8;License: Standard YouTube License, CC-BY