Question

In: Finance

What are the steps for solving for MIRR using a Ti-84 calculator given the following information:...

What are the steps for solving for MIRR using a Ti-84 calculator given the following information: (Please list all steps and keys to press to arrive to the conclusion)

C0

C1

C2

IRR

NPV@10%

Project A

-$1.6M

+$10M

-$10M

25%, 400%

-$0.77M

Solutions

Expert Solution

The present value of the cash flows can be found by using the Financial calculator. Calculate the total present value of each of the cash flows, starting from period 1 (leave out the cash outlays). Clear the TVM keys and then enter the cash flows (remember that we are ignoring the cost of the investment at this point): press 2nd CE/C to clear the cash flow keys. Now, press CF then 0 Enter down arrow, 10 Enter down arrow(twice). Now, press the NPV key and enter 10 Enter down arrow when prompted for the interest rate. To get the present value of the cash flows press CPT. We find that the present value is $9.09

To find the future value of the cash flows, enter -9.09 into PV, 2 into N, and 10 into I/Y. Now press CPT FV and see that the future value is $11.

Now, we need to find the PV of the cash outflows, for that we need to enter the cash outlays into financial calculator;

Clear the TVM keys and then enter the cash flows (remember that we are ignoring the cost of the investment at this point): press 2nd CE/C to clear the cash flow keys. Now, press CF then -1.6 Enter down arrow, 0 Enter down arrow(twice), -10 Enter down arrow(twice). Now, press the NPV key and enter 10 Enter down arrow when prompted for the interest rate. To get the present value of the cash flows press CPT. We find that the present value is -$9.86446281

At this point our problem has been transformed into an $9.86446281 investment with a lump sum cash flow of $11 million at period 2. The MIRR is the discount rate (I/Y) that equates these two numbers.

Enter -9.86446281 into PV and then press CPT I/Y. The MIRR is 5.60% per year.


Related Solutions

HOW WOULD YOU COMPUTE THIS BY HAND AND USING A TI-84 CALCULATOR? WHAT ARE THE STEPS...
HOW WOULD YOU COMPUTE THIS BY HAND AND USING A TI-84 CALCULATOR? WHAT ARE THE STEPS FOR THE CALCULATOR? also for 2, how do you calculate PMT for TVM solver on Calc Consider the after-tax cash flows below from a project that is being considered by Despondus Corporation. Since the project is an extension of the firm's current business, it carries the same risk as the overall firm. Year 0 1 2 3 4 5 Cash Flow -$264,000 $92,000 $66,000...
Please explain steps to find these answers on the TI 84 plus calculator: A machine used...
Please explain steps to find these answers on the TI 84 plus calculator: A machine used to fill gallon sized paint cans is regulated so that the amount of paint dispensed has a mean of 128 ounces and a standard deviation of 0.20 ounce. You randomly select 40 cans and carefully measure the contents. The same mean of the cans is 127.9 ounces. Does the machine need to be reset? Explain your reasoning.
How to Factor Polynomials on a Graphing Calculator (TI-83 and TI-84)
How to Factor Polynomials on a Graphing Calculator (TI-83 and TI-84)
For the answer please show you work : please include steps/functions used on TI 84+ calculator...
For the answer please show you work : please include steps/functions used on TI 84+ calculator (mandatory). a. State the hypotheses and identify the claim. b. Find the critical value. c. Compute the test value. d. Make the decision./Summarize the results In a magazine survey, 60% of respondents said that they used reusable shopping bags, 32% asked for plastic, and 8% requested paper. A random sample of 300 shoppers revealed that 28 asked for paper, 120 requested plastic, and the...
I need what to put on the TI-84 calculator and verify that all conditions of the...
I need what to put on the TI-84 calculator and verify that all conditions of the Central Limit Theorem have been met. Answer is next to the question on the bracket. Note: Before answering the following questions, make sure to verify that all conditions of the Central Limit Theorem have been met. 7.2.1 On an average day in 2013, 83% of women and 65% of men spent some time doing household activities such as housework, cooking, lawn care, and financial...
3. Interpret calculator display: The following TI-84 Plus calculator display presents a 99% confidence interval for...
3. Interpret calculator display: The following TI-84 Plus calculator display presents a 99% confidence interval for the difference between two proportions. a. (1pt) Compute the point estimate of p1 − p2. Round to the nearest thousandth. b. (2pt) Fill in the blanks: We are 99% confident that the difference between the proportions is between ___________and_____________ . Round values to the nearest thousandth.
If possible, please explain how to calculate with a Ti-84 Plus calculator. In the following problem,...
If possible, please explain how to calculate with a Ti-84 Plus calculator. In the following problem, check that it is appropriate to use the normal approximation to the binomial. Then use the normal distribution to estimate the requested probabilities. Do you try to pad an insurance claim to cover your deductible? About 44% of all U.S. adults will try to pad their insurance claims! Suppose that you are the director of an insurance adjustment office. Your office has just received...
USING Graphing Calculator: TI 84+ AND +4 METHOD, NOT WALDS (please:)) The test statistic of z=-2.50...
USING Graphing Calculator: TI 84+ AND +4 METHOD, NOT WALDS (please:)) The test statistic of z=-2.50 is obtained when testing the claim that p<0.75 a. find the critical value(s) b. Using sig. level alpha=0.05 should we reject null or fail to reject null?
can you show steps using the TI-84 plus? not using excel function. 19. Mercury in Sushi...
can you show steps using the TI-84 plus? not using excel function. 19. Mercury in Sushi An FDA guideline is that the mercury in fish should be below I part per million (ppm). Listed below are the amounts of mercury (ppm) found in tuna sushi sampled at different stores in New York City. The study was sponsored by the New York Times, and the stores (in order) are D’Agostino, Eli’s Manhattan, Fairway, Food Emporium, Gourmet Garage, Grace’s Marketplace, and Whole...
I'm using my TI-84 plus calculator trying to figure out the critical value(s). All I need...
I'm using my TI-84 plus calculator trying to figure out the critical value(s). All I need to know is how to do the problem on the calculator. I have tried everything. I did (area/2 and Df= 99) that was wrong) then I tried (1-area and Df= 99) that was wrong to) I tried it other ways and can't seem to get it down. I just need somebody to explain it to me step by step on how they got it....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT