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...
-
Suppose we have a binomial experiment with 50 trials, and the probability of success on a single trial is 0.02. Is it appropriate to use the Poisson distribution to approximate the probability of two...
-
Harold Monette vacationed at Lake Tahoe last winter. Unfortunately, he broke his ankle while skiing and spent two days at the Sierra University Hospital. Monette's insurance company received a $4,950...
-
A materials purchases journal, a cash payments journal, and a general journal for Vanyo, Inc., a manufacturer of cardboard boxes, are provided in the Working Papers. Your instructor will guide you...
-
Your client, White Corporation, has done well since its formation 20 years ago. This year, it recognized a $50 million capital gain from the sale of a subsidiary. White's CEO has contacted you to...
-
How can I solve this inquiry? The impact of freight movement on a supply chain's environmental and financial sustainability is approached on several different fronts. For instance, the desire for...
-
A slipper-pad bearing (Fig. P1023) is often encountered in lubrication problems. Oil flows between two blocks; the upper one is stationary, and the lower one is moving in this case. The drawing is...
-
signment Roberta is a self-employed accountant. During the year, Roberta incurs the following unreimbursed expenses: View the expenses Requirement Item Identify which of these expenses are deductible...
-
For F = 62 lb, compute the combined moment of the two forces about (a) point O, (b) point C, (c) point D. The moments are positive if counterclockwise, negative if clockwise. Answer: 16 1 1 A...
-
How do the dialectical interplays between ontological veracity and epistemological lucidity furnish the cognitive scaffolding requisite for navigating the labyrinthine vicissitudes of human...
-
63.Wagner sells product A at a price of P21 per unit. Wagner's cost per unit based on the full capacity of 200,000 units is as follows: Direct materials P 4 Direct labor 5 Overhead (2/3 of which is...
-
The New Watch Times is considering a new printing press to increase its productive capacity. If the cost of the press is $500,000 and the relevant cash flows from the project are $90,000 per year...
-
2. Japanese yen (JPY) pairs are quoted with 2 decimal places. Given that currency pairs AUD/JPY andUSD/JPY, if the AUD/JPY is quoted as 80.30, then calculate how much is 1 pip? 3.Hooker Furniture...
-
Research using 10k reports and calculate the following for UPS in the year 2021 and 2022. Return on investments, return on total assets, return on equity, operating profit margin, asset turnover,...
-
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...
-
The first column in Table 8-5 lists transaction amounts that have been summed to obtain a batch total. Assume that all data in the first column are correct. Columns a through d contain batch totals...
-
The Moose Wings Cooperative Flight Club owns a number of airplanes and gliders. It serves fewer than 2,000 members, who are numbered sequentially from the founder, Tom Eagle (0001), to the newest...
-
Use the following data to calculate the effects of different backup approaches. Which approach would you recommend? Why? Consider the time required to backup, the amount of media that must be...
Study smarter with the SolutionInn App