Start with the partial model in the file Ch12 P25 Build a Model.xlsx. Gardial Fisheries is...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Start with the partial model in the file Ch12 P25 Build a Model.xlsx. Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows Project A Project B -$435 -$635 -450 185 -300 185 -150 185. 900 185 900 185 912 185 -300 185 Year 0 1 2 3 4 5 6 7 a. If each project's cost of capital is 9%, which project should be selected? Round your answers to the nearest cent. NPV (Project A): $ NPV (Project B): $ Project A should be selected. If the cost of capital is 14%, what project is the proper choice? Round your answers to the nearest cent. NPV (Project A): $ NPV (Project B): $ b. Construct NPV profiles for Projects A and B. Choose the correct graph. A. C. Ad N $1,200 $1,000- $800- $600 $400 $200 $0 -$200 -$400 $1,200- $1,000+ $800+ $600 $400+ $200 0% $0 -$200 -$400 0% 5% 5% 10% NPV Profiles 10% 15% Cost of Capital - Project A - Project B NPV Profiles 20% 15% 20% Cost of Capital - Project A - Project B 2370 30% 30% B. D. $1,200 $1,000- $800 $600 $400 $200 SO -$200 -$400 $1,200- $1,000- $800 $600 $400 $200 SO -$200 0% -$400 0% 0% + 5% 1005 NPV Profiles 10% 15% Cost of Capital - Project A - Project B NPV Profiles 15% Cost of Capital 20% - Project A 20% - Project B 25% 25% 30% 30% c. What is each project's IRR? (Hint: Using the Excel IRR function, set the guess parameter to be 10%.) Round your answers to two decimal places. IRR (Project A): IRR (Project B): d. What is the crossover rate, and what is its significance? (Hint: Using the Excel IRR function, set the guess parameter to be 10%.) Round your answer for the crossover rate to two decimal places and for the NPV to the nearest cent. The crossover rate is % MIRR at r 9% MIRR at r = 14% % %. The crossover rate represents the cost of capital at which the two projects have the NPV of $ e. What is each project's MIRR at a cost of capital of 9% ? At r = 14% ? Round your answers to two decimal places. Project A Project B % % years f. What is the regular payback period for these two projects? Round your answers to two decimal places. Regular payback period (Project A): Regular payback period (Project B): g. At a cost of capital of 9%, what is the discounted payback period for these two projects? Round your answers to two decimal places. Discounted payback period (Project A): Discounted payback period (Project B): years years % years % h. What is the profitability index for each project if the cost of capital is 9%? Round your answers to three decimal places. Profitability index (Project A): Profitability index (Project B): Start with the partial model in the file Ch12 P25 Build a Model.xlsx. Gardial Fisheries is considering two mutually exclusive investments. The projects' expected net cash flows are as follows: Expected Net Cash Flows Project A Project B -$435 -$635 -450 185 -300 185 -150 185. 900 185 900 185 912 185 -300 185 Year 0 1 2 3 4 5 6 7 a. If each project's cost of capital is 9%, which project should be selected? Round your answers to the nearest cent. NPV (Project A): $ NPV (Project B): $ Project A should be selected. If the cost of capital is 14%, what project is the proper choice? Round your answers to the nearest cent. NPV (Project A): $ NPV (Project B): $ b. Construct NPV profiles for Projects A and B. Choose the correct graph. A. C. Ad N $1,200 $1,000- $800- $600 $400 $200 $0 -$200 -$400 $1,200- $1,000+ $800+ $600 $400+ $200 0% $0 -$200 -$400 0% 5% 5% 10% NPV Profiles 10% 15% Cost of Capital - Project A - Project B NPV Profiles 20% 15% 20% Cost of Capital - Project A - Project B 2370 30% 30% B. D. $1,200 $1,000- $800 $600 $400 $200 SO -$200 -$400 $1,200- $1,000- $800 $600 $400 $200 SO -$200 0% -$400 0% 0% + 5% 1005 NPV Profiles 10% 15% Cost of Capital - Project A - Project B NPV Profiles 15% Cost of Capital 20% - Project A 20% - Project B 25% 25% 30% 30% c. What is each project's IRR? (Hint: Using the Excel IRR function, set the guess parameter to be 10%.) Round your answers to two decimal places. IRR (Project A): IRR (Project B): d. What is the crossover rate, and what is its significance? (Hint: Using the Excel IRR function, set the guess parameter to be 10%.) Round your answer for the crossover rate to two decimal places and for the NPV to the nearest cent. The crossover rate is % MIRR at r 9% MIRR at r = 14% % %. The crossover rate represents the cost of capital at which the two projects have the NPV of $ e. What is each project's MIRR at a cost of capital of 9% ? At r = 14% ? Round your answers to two decimal places. Project A Project B % % years f. What is the regular payback period for these two projects? Round your answers to two decimal places. Regular payback period (Project A): Regular payback period (Project B): g. At a cost of capital of 9%, what is the discounted payback period for these two projects? Round your answers to two decimal places. Discounted payback period (Project A): Discounted payback period (Project B): years years % years % h. What is the profitability index for each project if the cost of capital is 9%? Round your answers to three decimal places. Profitability index (Project A): Profitability index (Project B):
Expert Answer:
Related Book For
Financial Management Theory and Practice
ISBN: 978-1305632295
15th edition
Authors: Eugene F. Brigham, Michael C. Ehrhardt
Posted Date:
Students also viewed these finance questions
-
Nancy Moore, a registered nurse, is assisting Dr. Brown while he performs a minor surgical procedure. Dr. Brown is known to have a quick temper, and he becomes angry if a surgical procedure is...
-
S Complete the following table: Note: Do not round net price equivalent rate and single equivalent discount rate. Round the dollar amounts to the nearest cent. Net price Item List price Chain...
-
Can I have some assistance with this problem? Create a PL/SQL block that contains "PL/SQL- Exceptions" as show in the examples. The Exceptions blocks should be able to handle the following SQL...
-
In Section 36.6 we saw that muons can reach the ground because of time dilation. But how do things appear in the muons reference frame, where the muons half-life is only 1.5 s? How can a muon travel...
-
What are asset management ratios? For retail firms, what is one of the key management ratios? Why?
-
A steel microstructure contains 75% marten site and 25% ferrite; the composition of the marten site is 0.6% C. Using Figure 12-32, determine (a) The temperature from which the steel was quenched and...
-
Which of the following is true regarding the direct write-off method of accounting for uncollectibles? a. The direct write-off method does not adhere to GAAP. b. The direct write-off method does not...
-
Examine and compare one of the following product sets. Base your comparison on such factors as features, costs, convenience, ease of use, and value. a. GPS versus maps. b. Cell phones versus...
-
About a year ago, Eric Robertson bought some shares in the Diamond Mountain Mutual Fund. He bought the fund at $25.00 a share, and it now trades at $26.00. Last year, the fund paid dividends of $0.60...
-
Laredo Leather Company manufactures high-quality leather goods. The companys profits have declined during the past nine months. In an attempt to isolate the causes of poor profit performance,...
-
The first three Taylor polynomial approximations of f(x) = sin(x) are T(x) = x, - T(x) = x 1/6x, T3(x) = x 1/6x3 + 1/120x5.
-
Grey's Anatomy Dr. Derek Shepherd (aka McDreamy) is contemplating purchasing a $36,000 piece of equipment for his future medical practice and to impress the Chief of Surgery. Dr. Miranda Bailey...
-
what is the wet well active volume given sewage discharge of 250 gpm, the dimension of the wet well is 6.66 feet length x 6.66 feet width and height of 12.2 feet?
-
How does the process of catalytic reforming influence the molecular structure and octane rating of hydrocarbons in petroleum refining? Example
-
a) Consider a particle of mass m and charge e, accelerated from rest through an electric potential difference V. Assuming non-relativistic mechanics for the particle, what is the particle's final...
-
Consider the function Find the derivative of y with respect to . dy dx x - 3x+4
-
Find all zeros of the polynomial 3x 3 + 10x 2 9x 4, if one of its zero is 1.
-
In Exercises find dy/dx by implicit differentiation. xy - y = x
-
a. What is a multinational corporation? Why do firms expand into other countries? b. What are the six major factors that distinguish multinational financial management from financial management as...
-
At year-end 2016, Wallace Landscaping's total assets were $2.17 million, and its accounts payable were $560,000. Sales, which in 2016 were $3.5 million, are expected to increase by 35% in 2017. Total...
-
Maggie's Muffins Bakery generated $5,000,000 in sales during 2016, and its year-end total assets were $2,500,000. Also, at year-end 2016, current liabilities were $1,000,000, consisting of $300,000...
-
Calculate the CGT payable in relation to each of the following disposals, assuming in each case that the annual exemption is fully utilised against other gains, that there are no allowable losses and...
-
In October 2012, Matthew bought a piece of rare porcelain for 10,000. The porcelain was damaged in early 2019 and in February of that year Matthew spent 3,850 on restoration work. In July 2019,...
-
Mick Stone disposed of the following assets during tax year 2023-24: (1) On 19 May 2023, Mick sold a freehold warehouse for 522,000. This warehouse was purchased on 6 August 2011 for 258,000, and was...
Study smarter with the SolutionInn App