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. %