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
-
Consider the system shown in Fig. P5.127. Tank A has a volume of 100 L and contains saturated vapor R-134a at 30C. When the valve is cracked open, R-134a flows slowly into cylinder B The piston mass...
-
Explain the nature and roles of accounting and finance.
-
Why is the accuracy of cost allocation so important? Cite real-life examples of either successes or failures in cost allocation.
-
Paediatric Orthopaedic Clinic at the Children's Hospital of Western Ontario The chief of pediatric orthopedic surgery was very concerned by long times that young patients (and their parents) were...
-
On 1 July 206 Mumtaz started a business. The following are her transactions for the first two weeks of trading: July 1 Mumtaz paid capital, $50,000, into the business bank account 2 Bought premises,...
-
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...
-
Besides increased availability, what are two other potential advantages of laboratory-grown lungs (or other tissues) compared to regular donor tissues?
-
THINK ABOUT ALL OF THE DIFFERENT KINDS OF DECISIONS WE MAKE THINK OF HOW PRICE INFLUENCES YOUR DECISION TO BUY SOMETHING. WHAT KIND OF PRODUCTS OR SERVICES? WHAT ARE THE REASONS THAT YOU RELY ON...
-
provide your understanding concerning Abnormal psychology . 2) The field of abnormal psychology is sometimes called what ? 3) A kind of case study that describes the behavior and thought patterns...
-
discuss the mechanisms by which central banks implement quantitative easing, and what are the potential long-term risks associated with this form of monetary policy?
-
Think about positive reinforcement. As a leader, do you think that the best motivation for employees is positive reinforcement?Explain Think about micromanagement that least motivates employees. As a...
-
Date: 9th December 2020 Question 3 [20 marks] (a) Find a minimal spanning tree for the following graph using Kruskal's algorithm, then calculate its weight. (1) 14 E 8 D 18 F 20 15 10 17 Course:...
-
Quasar Tech Co. management is investing $6 million in new machinery that will produce the next-generation routers. Sales to its customers will amount to $1,750,000 for the next three years and then...
-
Quality Chicken grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2012 is: Joint cost of production in July 2012 was $50. A...
-
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?
-
Many complex organizations use parallel career tracks for employees. Give a (short) example of what such a program might look like and describe why an organization might implement such a program. .
-
Technology has been identified as the main factor in the future success of public administration within public service organizations; however, there are some risks and limitations associated with the...
-
4. (25 pt: Dublin Company has a beginning inventory of $60,000 using LIFO. During the third quarter, they sell inventory which cost $120,000, or $22,000 more than they purchased, thus eroding away...
Study smarter with the SolutionInn App