Follow these steps describing how the MIRR is calculated to complete the table for Project X....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Follow these steps describing how the MIRR is calculated to complete the table for Project X. The Project X has just one outflow: $1,000 at t = 0, this means that it is not discounted and its PV = $1,000. (Note: If the project has more than one outflow, you need to find the PV at t = 0 for each one and sum them to arrive at the PV of total costs for use in the MIRR calculation.) You need to find the future value of each inflow compounded at the WACC out to the terminal year, which is the year the last inflow is received. (Hint: Assume that cash flows are reinvested at the WACC.) You have the cost at t = 0, $1,000, and the FV. There is some discount rate that will cause the PV of the terminal value to equal the cost. That interest rate is defined as the MIRR. (Note: Using your financial calculator, enter N = 4, PV = 1,000, PMT= 0, and FV. Then when you press the I/YR key, you get the MIRR. Some calculators have a built-in MIRR function that streamlines the process. In Excel, you can use either the RATE function or MIRR function to calculate the MIRR.) Project X WACC = 12% Inflow 1 2 3 4 0 -$1,000 $700 $650 $550 $400 Complete the following table. NPV = FV MIRR = = Suppose a firm is considering two mutually exclusive equally risky projects with WACC = 12% and the following cash flows: 2 3 4 0 1 -$1,000 $700 $650 Project X $550 $400 Project Y -$1,000 $950 $600 $500 $350 How can you calculate the MIRR for the project that maximizes shareholder value? Assuming that your professional financial calculator is able to calculate the MIRR, use the following table to indicate which values you should enter to compute the MIRR for Project X. CFO Input Keystroke Output Arrow down CF CF CF3 Arrow down Arrow down Arrow down CF4 Arrow down IRR I MIRR Suppose that your calculator does not have the ability to compute the MIRR. Here are the steps you need to take to calculate the MIRR for Project Y. 1. Use the following table to indicate which values you should enter to compute the net present value (NPV) of all cash inflows. CFO CF2 Input Keystroke Output Arrow down CF1 CF3 Arrow down Arrow down Arrow down CF4 Arrow down I/Y NPV 2. Use the following table to indicate which values you should enter to compute the future value of the NPV. Input Keystroke Output N Input Keystroke Output I/Y N 3. Use the following table to indicate which values you should enter to compute the MIRR. PV PV PMT PMT Finally, you can answer the question: The MIRR for the project FV FV I/Y maximizes shareholder value. Now it's time for you to practice what you've learned. Suppose a firm is considering two mutually exclusive equally risky projects with WACC = 12% and the following cash flows: Project A Project B O 28.31% What is the MIRR of the project that maximizes the shareholder return? O 30.62% 41.19% 0 1 2 3 $700 $650 $550 - $1,000 -$1,000 $950 $600 $500 $350 O 67.77% 4 5 $400 $325 $445 Follow these steps describing how the MIRR is calculated to complete the table for Project X. The Project X has just one outflow: $1,000 at t = 0, this means that it is not discounted and its PV = $1,000. (Note: If the project has more than one outflow, you need to find the PV at t = 0 for each one and sum them to arrive at the PV of total costs for use in the MIRR calculation.) You need to find the future value of each inflow compounded at the WACC out to the terminal year, which is the year the last inflow is received. (Hint: Assume that cash flows are reinvested at the WACC.) You have the cost at t = 0, $1,000, and the FV. There is some discount rate that will cause the PV of the terminal value to equal the cost. That interest rate is defined as the MIRR. (Note: Using your financial calculator, enter N = 4, PV = 1,000, PMT= 0, and FV. Then when you press the I/YR key, you get the MIRR. Some calculators have a built-in MIRR function that streamlines the process. In Excel, you can use either the RATE function or MIRR function to calculate the MIRR.) Project X WACC = 12% Inflow 1 2 3 4 0 -$1,000 $700 $650 $550 $400 Complete the following table. NPV = FV MIRR = = Suppose a firm is considering two mutually exclusive equally risky projects with WACC = 12% and the following cash flows: 2 3 4 0 1 -$1,000 $700 $650 Project X $550 $400 Project Y -$1,000 $950 $600 $500 $350 How can you calculate the MIRR for the project that maximizes shareholder value? Assuming that your professional financial calculator is able to calculate the MIRR, use the following table to indicate which values you should enter to compute the MIRR for Project X. CFO Input Keystroke Output Arrow down CF CF CF3 Arrow down Arrow down Arrow down CF4 Arrow down IRR I MIRR Suppose that your calculator does not have the ability to compute the MIRR. Here are the steps you need to take to calculate the MIRR for Project Y. 1. Use the following table to indicate which values you should enter to compute the net present value (NPV) of all cash inflows. CFO CF2 Input Keystroke Output Arrow down CF1 CF3 Arrow down Arrow down Arrow down CF4 Arrow down I/Y NPV 2. Use the following table to indicate which values you should enter to compute the future value of the NPV. Input Keystroke Output N Input Keystroke Output I/Y N 3. Use the following table to indicate which values you should enter to compute the MIRR. PV PV PMT PMT Finally, you can answer the question: The MIRR for the project FV FV I/Y maximizes shareholder value. Now it's time for you to practice what you've learned. Suppose a firm is considering two mutually exclusive equally risky projects with WACC = 12% and the following cash flows: Project A Project B O 28.31% What is the MIRR of the project that maximizes the shareholder return? O 30.62% 41.19% 0 1 2 3 $700 $650 $550 - $1,000 -$1,000 $950 $600 $500 $350 O 67.77% 4 5 $400 $325 $445
Expert Answer:
Related Book For
Posted Date:
Students also viewed these finance questions
-
How many registered voters would vote to elect a female president? A curious political scientist selected two equivalent samples of voters. One group was given the description of a hypothetical male...
-
How many registered voters would vote to elect a female president? A curious political scientist selected two equivalent samples of voters. One group was given the description of a hypothetical male...
-
A stiff, straight, horizontal wire of length 25 cm and mass 20 g is supported by electrical contacts at its ends, but is otherwise free to move vertically upward. The wire is in a uniform, horizontal...
-
Suppose that the volatilities used to price a six-month currency option are as in Table 20.2. Assume that the domestic and foreign risk-free rates are 5% per annum and the current exchange rate is...
-
Presented below are three different transactions related to materiality. Explain whether you would classify these transactions as material. (a) Blair Co. has reported a positive trend in earnings...
-
At a historic UN Summit in September 2015, world leaders adopted the 2030 Agenda for Sustainable Development. This agenda contains 17 sustainable development goals to be implemented by countries over...
-
Selected transactions for the Brook Wang Company are presented in journal form below. Post the transactions to T-accounts. Make one T-account for each item and determine each accounts endingbalance....
-
Government spending as a fiscal policy tool is used to: A) ?Decrease the national debt B) ?Directly stimulate economic activity by increasing demand C) ?Reduce inflation D) ?Lower interest rates
-
On June 1, John Sullivan opened a real estate office in Hamilton called Sullivan Realty. The following transactions were completed for the month of June. Note that facsimile documents have been...
-
Armed with a down payment, take out a loan for 30 year fixed at 8% with a monthly payment of $4,000 a month. a. How much would they receive as a loan: b. Amortize the first three payments on the...
-
In-house training programs are learning opportunities developed by the organization in which they are used. An in-house trainingprogram is usually the second step in the training process and is often...
-
create dataFrame of Sharpe ratio in 2020 and (B) dataFrame of Sharpe ratio in 2021. Then merge (A) dataFrame of Sharpe ratio in 2020 and (B) dataFrame of Sharpe ratio in 2020. The merged keys should...
-
A firm with annual revenues of $8,760,000 has DSO of 30 days. Calculate the change in receivables that would occur if the firm's collections deteriorated so that DSO increased to 50 days.
-
Students will be given 30 minutes for the following activity. Each student will use the Bingo sheet provided. Students will need to complete each square individually by writing their response to the...
-
Suppose you are the financial manager of a firm considering the following five projects (expand below to see the five projects). Five Projects Under Construction Five Projects Under Consideration...
-
Imagine that a group is seeking a $50,000 grant for the purpose of improving the processing and examination of DNA evidence collected pursuant to criminal investigations in a local police department....
-
Imagine you are the HR manager at a company, and a female employee came to you upset because she felt a male coworker was creating a hostile work environment by repeatedly asking her out on dates...
-
A step tracer input was used on a real reactor with the following results: a. What is the mean residence time tm? b. What is the variance 2 ? For t 10 min, then C = 0 For 10 st 30 min, then C+= 10...
-
Derive an equation for the time necessary to completely burn a 100 m carbon particle as a function of D 0 . Also calculate the burning rate constant. Use the KS values of the parameter values, for...
-
If it takes 11 minutes to cook spaghetti in Ann Arbor, Michigan, and 14 minutes in Boulder, Colorado, how long would it take in Cuzco, Peru? Discuss ways to make the spaghetti more tasty. If you...
-
If a politician running for office does not speak in general terms, does not try to move to the middle of the political spectrum, and does not take polls, is the median voter model therefore wrong?
-
Voters often criticize politicians running for office who do not speak in specific terms (i.e., who do not specify which spending programs will be cut, whose taxes will be raised, etc.). If voters...
-
Consider Jack who attends both his sons high school football games and a few professional football games too. At which games is Jack more likely to be well behaved? Why?
Study smarter with the SolutionInn App