Project A requires an initial outlay at t = 0 of $1,000, and its cash flows are the same in Years 1 through 10. Its IRR is 15%, and its WACC is 8%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. %
Step-1:Calculation of annual cash flows | ||||||
At IRR, Present value of annual cash flow is equal to its initial cost. | ||||||
Annual cash flow | =pmt(rate,nper,pv) | Where, | ||||
$ 199.25 | rate | = | 15% | |||
nper | = | 10 | ||||
pv | = | $ -1,000.00 | ||||
Step-2:Calculation of MIRR | ||||||
Year | Cash flow | |||||
0 | $ -1,000.00 | |||||
1 | $ 199.25 | |||||
2 | $ 199.25 | |||||
3 | $ 199.25 | |||||
4 | $ 199.25 | |||||
5 | $ 199.25 | |||||
6 | $ 199.25 | |||||
7 | $ 199.25 | |||||
8 | $ 199.25 | |||||
9 | $ 199.25 | |||||
10 | $ 199.25 | |||||
Finance rate | 8% | |||||
Investment rate | 8% | |||||
MIRR | =mirr(values,finance rate,reinvestment rate) | |||||
= 11.18% | ||||||
Note: | ||||||
Values is the cash flow from year 0 to year 10. | ||||||
Project A requires an initial outlay at t = 0 of $1,000, and its cash flows...
A)Project L requires an initial outlay at t = 0 of $40,000, its expected cash inflows are $15,000 per year for 9 years, and its WACC is 14%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. B) Project L requires an initial outlay at t = 0 of $88,310, its expected cash inflows are $14,000 per year for 10 years, and its WACC is 14%. What is the project's IRR? Round...
Project A requires an initial outlay at t = 0 of $4,000, and its cash flows are the same in Years 1 through 10. Its IRR is 16%, and its WACC is 9%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. %
Project A requires an initial outlay at t = 0 of $3,000, and its cash flows are the same in Years 1 through 10. Its IRR is 14%, and its WACC is 12%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
Project A requires an initial outlay at t = 0 of $5,000, and its cash flows are the same in Years 1 through 10. Its IRR is 14%, and its WACC is 8%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. Please use excel to show work
Project A requires an initial outlay at t = 0 of $4,000, and its cash flows are the same in Years 1 through 10. Its IRR is 16%, and its WACC is 11%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
Project L requires an initial outlay at t = 0 of $50,000, its expected cash inflows are $11,000 per year for 9 years, and its WACC is 10%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. 0%
Project L requires an initial outlay at t = 0 of $45,000, its expected cash inflows are $8,000 per year for 9 years, and its WACC is 10%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
Project L requires an initial outlay at t = 0 of $45,000, its expected cash inflows are $11,000 per year for 9 years, and its WACC is 13%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. ? %
Project L requires an initial outlay at t = 0 of $40,000, its expected cash inflows are $11,000 per year for 9 years, and its WACC is 10%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.
Project L requires an initial outlay at t = 0 of $35,000, its expected cash inflows are $13,000 per year for 9 years, and its WACC is 13%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places. %