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: 92% (13 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
-
Whats the difference between the NVL and NVL2 functions?
-
Accounting models are generally static and generate solutions that are assumed to be valid for an indefinite period of time. However, the world faced by the manager is continually changing. How do...
-
Prepare the cost of goods sold section for Adams Gift Shop. The following amounts are known: Beginning merchandise inventory ....... $26,000 Ending merchandise inventory ........... 23,000 Purchases...
-
Suppose that you are headed toward a plateau 21.6 meters high. If the angle of elevation to the top of the plateau is 23.5, how far are you from the base of the plateau? What is your distance from...
-
The propeller of a ship can be modelled as a device producing a stream of water of a cylindrical shape, the radius of which is Identical to that of the propeller. For simplicity, the velocity...
-
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...
-
The comparative balance sheets for 2024 and 2023 and the statement of income for 2024 are given below for Wright Company. Additional information from Wrights accounting records is provided also....
-
Suppose an ATM of a community bank dispenses $100,000 per week. Restocking the ATM costs $500. The bank has amazing opportunities for investment, so the cost of holding $1 for a year in an ATM is $1....
-
JSOM Company makes custom furniture and uses a joborder-cost system.The company always writes off under/over applied overhead to cost of goods sold.The following data pertains to the first quarter of...
-
DESIGN AN ADVERTISING CAMPAIGN FOR A VIRTUAL MARKETING FIRM WHOSE TARGET AUDIENCE IS SMALL BUSINESS AND ENTREPRENEURS.
-
1. What are typical Specific Fuel Consumptions of Modern High Bypass Turbofan engines? 2. what is N1, N2, N3 in aviation engine?
-
The Company is expected to announce their annual dividend tomorrow. One year ago they paid a dividend of $1.90 , and 5 years ago they paid $1.53 .You believe that future dividends will grow by the...
-
Bastille Corporation prepares monthly cash budgets. Here are relevant data from operating budgets for 2022. All sales and purchases are on account. Budgeted collections and disbursement data are...
-
You continue to work in the corporate office for a nationwide convenience store franchise that operates nearly 10,000 stores. The per- store daily customer count (i.e., the mean number of customers...
-
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?
-
Assignment A partnership is a legal entity formed by two or more people who agree to share the profits and losses of a business. Partnership accounting is the process ofrecording and reporting the...
-
Which statement below correctly describes merchandise inventory?Multiple choice question.Merchandise inventory is an asset reported on the balance sheet and contains the cost of products purchased...
-
Consulta las fuentes orientadas y otras de inters relacionadas con la asignatura y realiza las siguientes actividades: Con los conocimientos adquiridos en la unidad y las orientaciones del...
Study smarter with the SolutionInn App