Question

In: Finance

Please explain how to answer using a finance calculator, preferably BA II Plus A project has...

Please explain how to answer using a finance calculator, preferably BA II Plus

A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%. What is the project’s MIRR? What is the project’s PI? What is the project’s payback period? What is the project’s discounted payback period?

Solutions

Expert Solution

1) calculation of payback period:

Payback period = initial cost/ net cash inflows

= 40,000/9000

=4.444 years

2) calculation of discounted payback period

Years amount PVF@11% p.v cumulative P.V
1 9000 0.9009 8108.1 8108.1
2 9000 0.8116 7304.4 15,412.5
3 9000 0.7312 6580.8 21,993.3
4 9000 0.6587 5928.3 27,921.6
5 9000 0.5935 5341.5 33,263.1
6 9000 0.5346 4811.4 38,074.5
7 9000 0.4817 4335.3 42,409.8
42299.8

Discounted payback period formula=

= Year before full maturity + unrecovered amount

/discounted cash flow for they year full maturity.

DPB= 6Years +40,000-37,964.5/4335.3

= 6.47 years

3) calculation of the PI

PI= pv of future cash flows/initial investment

= 42,409.8/40000

=1.06

4) calculation of MIRR for the project;-

It is assumed the future cash flows are reinvested at cost of capital.do,we can realise the at the end the project.so,it can be called terminal cash inflows.

Calculation of terminal cash inflows

Here cash flows is uniform ,so,we can use future value annuity to calculate the terminal cash inflows

Terminal cash inflows = 9000 FVAF(11%,6Years) +9000

=9000× 8.7833 +9000

=88,049.7

MIRR= [(terminal cash inflows/ cash outflows)1/n. ] - 1

= [(88,049.7/40000)]1/7 -1

= 0.11932

MIRR = 11.932%


Related Solutions

***PLEASE SOLVE EITHER USING A BA II PLUS CALCULATOR OR SHOW STEPS*** The answer is included...
***PLEASE SOLVE EITHER USING A BA II PLUS CALCULATOR OR SHOW STEPS*** The answer is included but I want to learn the steps. Do not use Excel Ehrmann Data Systems is considering a project that has the following cash flow and WACC data. What is the project's MIRR? Note that a project's MIRR can be less than the WACC (and even negative), in which case it will be rejected. 13.74%               WACC: 8.75% Year                                  0                   1                   2                   3      Cash flows                ...
Find the R, in step by step by using financial calculator BA II plus. P0 =...
Find the R, in step by step by using financial calculator BA II plus. P0 = $1,040 = $34(PVIFAR%,40) + $1,000(PVIFR%,40)
Please answer with steps for BA II finc. calculator (not excel steps) a. You anticipate that...
Please answer with steps for BA II finc. calculator (not excel steps) a. You anticipate that you will need $1,500,000 when you retire 30 years from now. You just join a new firm and your first annual salary is $100,000 to be received one year from today. You also received one time signing bonus of $50,000 today. You decided that you will put all you signing bonus into your account plus you will contribute $X every year starting next year...
How would you calculate this on a TI BA II Plus: ACE Co. is considering the...
How would you calculate this on a TI BA II Plus: ACE Co. is considering the purchase of two machines. Machine A costs $100,000 with annual cost of $20,000. It will last for 5 years, and have a salvage value of $5,000 at the end of 5 years. Machine B costs $145,000 with annual costs of $17,500, and has a useful life of 8 years. The discount rate is 10%. Which machine should the company buy?
how would you solve this on a ba ii plus? You made an investment of $10,500...
how would you solve this on a ba ii plus? You made an investment of $10,500 into an account that paid you an annual interest rate of 2.2 percent for the first 5 years and 6.6 percent for the next 9 years. What was your annual rate of return over the entire 14 years?
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...
Please ANSWER ALL (explanation with or without BA 2 calculator greatly appreciated) #1. What is the...
Please ANSWER ALL (explanation with or without BA 2 calculator greatly appreciated) #1. What is the value today of a money machine that will pay $3,042.00 every six months for 11.00 years? Assume the first payment is made 5.00 years from today and the interest rate is 6.00% #2. What is the value today of a money machine that will pay $4,796.00 per year for 8.00 years? Assume the first payment is made today and that there are 8.0 total...
Using the BAII Plus calculator I am having a difficult time using this calculator to solve...
Using the BAII Plus calculator I am having a difficult time using this calculator to solve this MIRR 0 =-325,000 1=50,000 2= 75,000 3=-60,000 4=225,000 5=300,000 Required rate of return =15% We discount all negative CFs(at 15%) time 0 We compound all positive cash flows (at 15%) to 5 years This is now the TV or Terminal Value Please help me understand how to calculate these numbers?
Assume that interest is the only finance charge. Use financial calculator to answer the questions. How...
Assume that interest is the only finance charge. Use financial calculator to answer the questions. How much interest would be paid on a $6,000 installment loan to be repaid in 48 monthly installments of $158.11? Round the answer to 4 decimal places. _____% per month What is the APR on this loan? Round the answer to 2 decimal places. _____%
please answer the question using Excel with formula please explain how the answer came 1. Many...
please answer the question using Excel with formula please explain how the answer came 1. Many drugs used to treat cancer are expensive. BusinessWeek reported on the cost per treatment of Herceptin, a drug used to treat breast cancer. Typical treatment costs (in dollars) for Herceptin are provided by a simple random sample of 10 patients. 5798​7446​5119​5376​5495​5237​4814​6578​3717​5920 a. Develop a point estimate of the mean cost per treatment with Herceptin. b. Develop a point estimate of the standard deviation of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT