In the capital budgeting model in Figure 6.5, investment 4 is tied for the largest ROI, but
Question:
In the capital budgeting model in Figure 6.5, investment 4 is tied for the largest ROI, but it is not selected in the optimal solution. How much NPV will be lost if Tatham is forced to select investment 4? Answer by solving a suitably modified model.
Figure 6.5:
Transcribed Image Text:
Capital Budgeting Model Н G. 1 Capital budgeting model Range names used Budget Decisions =Model!$B$10:$H$10 Total_cost=Model!$B$14 Total_NPV=Model!$B$17 =Model!$D$14 3 Input data on potential investments ($ millions) 4 Investment 5 |Cost 2 $2.4 $2.7 12.5% 3 $3.5 $3.9 11.4% 4 $6.9 $4.5 $5.9 $6.8 15.3% $5.0 $5.6 $3.0 $3.3 10.0% 6 NPV 7 ROI $7.7 $5.1 13.3% 12.0% 11.6% 9 Decisions: whether to invest 10 1 if yes, 0 if no 11 1. 12 Budget constraint Total cost $14.9 13 14 Budget $15 15 | 16 Objective to maximize | 17 Total NPV $16.7
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 91% (12 reviews)
Capital budgeting model Input data on potential investments ...View the full answer
Answered By
Ali Khawaja
my expertise are as follows: financial accounting : - journal entries - financial statements including balance sheet, profit & loss account, cash flow statement & statement of changes in equity -consolidated statement of financial position. -ratio analysis -depreciation methods -accounting concepts -understanding and application of all international financial reporting standards (ifrs) -international accounting standards (ias) -etc business analysis : -business strategy -strategic choices -business processes -e-business -e-marketing -project management -finance -hrm financial management : -project appraisal -capital budgeting -net present value (npv) -internal rate of return (irr) -net present value(npv) -payback period -strategic position -strategic choices -information technology -project management -finance -human resource management auditing: -internal audit -external audit -substantive procedures -analytic procedures -designing and assessment of internal controls -developing the flow charts & data flow diagrams -audit reports -engagement letter -materiality economics: -micro -macro -game theory -econometric -mathematical application in economics -empirical macroeconomics -international trade -international political economy -monetary theory and policy -public economics ,business law, and all regarding commerce
4.00+
1+ Reviews
10+ Question Solved
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Question Posted:
Students also viewed these Business questions
-
Change the capital budgeting model in Figure 6.5 so that 80% of each cost in row 5 is incurred right now, at the beginning of year 1, and the other 20% is incurred a year from now, at the beginning...
-
You have recently been hired by Goff Communica-tions Inc. (GCI) in the finance area. GCI was founded 20 years ago by Chris Goff and currently employs over 30,000 workers. GCI is privately owned by...
-
This case study on project evaluation is applicable for beginning courses in corporate finance or finance strategy. Two alternative investment options are available to evaluate. Challenges are...
-
In Exercises use the Limit Comparison Test to determine the convergence or divergence of the series. 0 1 2 n=11n+1
-
Calculate the focal length of a lens in water, given that the index of refraction of the lens is nlens = 1.52 and its focal length in air is 25.0 cm. A. 57.8 cm B. 66.0 cm C. 91.0 cm D. 104 cm
-
Find the braking distance of a sedan that corresponds to z = 1.6. On a dry surface, the braking distances (in feet), from 60 miles per hour to a complete stop, of a sedan can be approximated by a...
-
Fit a Gompertz curve of the form \[y=e^{e^{\alpha x+\beta}}\] to the data of Exercise 11.26. Data From Exercise 11.26 11.26 The following data pertain to water pressure at various depths below sea...
-
Dana Johnson Corp. is considering adding a fourth plant to its three existing facilities in Decatur, Minneapolis, and Carbondale. Both St. Louis and East St. Louis are being considered. Evaluating...
-
This assignment is focused on project selection and the underlying factors used to make this determination. You will need to use the readings/videos, the previous learning modules, along with some...
-
Give the prefix, infix, and postfix expressions corresponding to the tree in Figure 4.71. e b)
-
Make up an example, as described in the previous problem, with 20 possible investments. However, do it so the ROIs are in a very tight range, such as from 12% to 13%. Then use Solver to find the...
-
1. Using the spreadsheet model from Case 2.1 as a starting point, use Solver to find the optimal set of projects to approve. The solution should maximize the total NPV from the approved projects, and...
-
Use Theorem 13.9 to find the directional derivative of the function at P in the direction of v. Data from in Theorem 13.9 THEOREM 13.9 Directional Derivative If f is a differentiable function of x...
-
On April 9, 2015, Starbucks corporation split its shares two-for-one. On the day before the split, Starbucks shares closed at $95.23. Theoretically, after the split the stock price should fall by...
-
Determine the net price if an oven has a list price of $1,800 and the distributor is offering discounts of 12%, 8% and 6%. An invoice dated November 25, 2021 for $1,277 had the terms 4/15, 1.5/30,...
-
Determine the following: a. Vertical reaction at point A. b. Horizontal reaction at point A. c. Moment reaction at point A d. Vertical reaction at point G e. Horizontal reaction at point G f....
-
Encryption Mode-ECB vs. CBC The file pic original. bmp can be downloaded from course Blackboard, and it contains a simple picture. We would like to encrypt this picture, so people without the...
-
Are the payoffs identical for an investor who buys a call option and sells a put option? Explain.
-
What is the risk of an overemphasis on cost when selecting or dealing with an IT vendor?
-
Pearson Education, a publisher of college textbooks, would like to know if students prefer traditional textbooks or digital textbooks. A random sample of students was asked their preference and the...
-
a. Briefly explain the tax benefit rule. b. Is a taxpayer required to report the reimbursement of a medical expense by insurance as income if the reimbursement is received in the year following the...
-
Taxpayers who deduct an expense one year but recover it the next year are required to include the recovered amount in gross income. The tax benefit rule provides relief if the original deduction did...
-
George, a wealthy investor, is uncertain whether he should invest in taxable or tax-exempt bonds. What tax and non-tax factors should he consider?
-
A bank can either invest money for three months at 4.00% or for nine months at 4.50%. Ignoring actual/360 day count adjustments for the purpose of this question, the three against nine FRA quote the...
-
Shuggy Otis, an executive at Slapfish Corp. (SC) intends to retire in 11 years. SC just announced that it will start depositing $500.00 at the end of each quarter into each of its workers' retirement...
-
On January 1, the Hanover Beverage Company replaced the palletizing machine on one of its juice lines. The cost of the machine was $195,000. The machine's expected life is five years or 480,000...
Study smarter with the SolutionInn App