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
-
Compute if the dividend on the CD is 0 and the payoff is $1300 max(0, 1300 S5.5) + max(0, S5.5 2600) and the initial price is to be $1300.
-
A pendulum in a local reference frame (see Fig. 5.7) is constrained in a point along the \(z^{\prime}\) axis so that it can swing freely in the \(x^{\prime} y^{\prime}\) plane. The pendulum is...
-
Opticom, Inc. a manufacturer of fiber optic communications equipment, uses a j ob-order costing system. Since the production process is heavily automated, manufacturing overhead is applied on the...
-
Malimali Fish Products Ltd, A Malindi-based firm dealing in fish products, conducts training programmes for all its line managers. The managers ar expected to master, in particular, procedures in...
-
Death Valley Resort opened for business on June 1 with eight air-conditioned units. Its trial balance before adjustment on August 31 is presented here. Other data: 1. Insurance expires at the rate of...
-
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...
-
Show that the describing function for the saturation element in the previous problem is given by \[\frac{B_{1}}{A} e^{j \phi_{1}}=\frac{2}{\pi}\left[\sin ^{-1}\left(\frac{1}{A}ight)+\frac{1}{A} \cos...
-
How might you encode audio (or video) data in two packets so that if one packet is lost, then the resolution is simply reduced to what would be expected with half the bandwidth? Explain why this is...
-
Use mpeg_play to play an MPEG-encoded video. Experiment with options, particularly -nob and -nop, which are used to omit the B and P frames, respectively, from the stream. What are the visible...
-
Please describe how a dependent social planner operates within a multilevel government, determines a production plan, selects a policy, and calculates shadow prices.
-
Consider a simple UDP-based protocol for requesting files (based somewhat loosely on the Trivial File Transport Protocol [TFTP]). The client sends an initial file request, and the server answers (if...
-
ARP and DNS both depend on caches; ARP cache entry lifetimes are typically 10 minutes, while DNS cache is on the order of days. Justify this difference. What undesirable consequences might there be...
-
An American importer needs to pay 250,000 in 90 days and would like to use currency options to hedge the risk of appreciation of the pound. Should the importer buy a call or a put option on pound?...
-
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?
-
Assume the following inputs for parts a, b, and c below. The market portfolio has an expected return of 12% and a standard deviation of returns of 20%. The risk-free rate is 5%. a) The stock ABC has...
-
Suppose your MasterCard calculates interest using the average daily balance method, and the monthly interest rate is 1.1%. The itemized billing for the month of August is shown below. Detail Date...
-
Instructions - You will complete this week's task by submitting: A completed AIT QAPI Leadership Rounding Guide Attach Your CMS Comparison Report as from the CMS Compare Site in PDF format/or JPeg...
Study smarter with the SolutionInn App