Question

In: Finance

Consider a project with a cost of $1000, with the following expected cash inflows, and a...

Consider a project with a cost of $1000, with the following expected cash inflows, and a WACC of 16%.

YEAR 1 $300--Year 2 $400- year 3 $300- Year 4 $500

Show your calculations by way of formulas, numerical values and if you like also by EXCEL for the following.

A. Calculate the present value of cash inflows.

B. Calculate the net present value of cash inflows.

C. Calculate the internal rate of return IRR.

D. Calculate the modified internal rate of return MIRR.

E. You will notice that IRR and MIRR are different in numerical values. Explain (in 5 lines) as to why they are different.

F. If you have to make a decision solely based on IRR or MIRR, which one would you choose and why? Explain in 5 lines.

Make sure you include your calculations by way of formulas, numerical values

Solutions

Expert Solution

Answers

A. PV of cash flows = ($258.62 + $297.27 + $192.20 + $276.15) i.e. $1,024.23

B. NPV of cash flows = $1024.23 - $1000 i.e. $24.23

C. IRR = 17.13%

D. MIRR = 16.70%

E. IRR indicates the internal rate of return that the project is giving from the investment whereas MIRR indicates the modified internal rate of return which states that the invested money will be reinvested during the life of project so due to reinvestment the pv will reduce from the project and so the MIRR is lower then IRR. A project life is 4 years the money in the end of year1 we get will be assumed to be reinvested again and same in year 2 and so on.

F. Since we doont keep our money idle and we would like to reinvest it to earn more. This is the basic concept of fiinance and so tthis concept is a like to MIRR and so i bilieve that MIRR is more logical then IRR and hence we should make decision in terms of MIRR. In the given case MIRR of the project is 16.70% and our requirent is 16% and hence the project is giving more then our requirement and so we should accept the project.


Related Solutions

A project has an initial cost of $148,400 and is expected to produce cash inflows of...
A project has an initial cost of $148,400 and is expected to produce cash inflows of $56,500, $69,540, and $97,867 over the next three years, respectively. What is the discounted payback period if the required rate of return is 10 percent? A. 2.12 years B. 2.54 years C. 2.91 years D. 1.88 years
A project has an initial cost of $ 42,000, expected net cash inflows of $ 9,000...
A project has an initial cost of $ 42,000, expected net cash inflows of $ 9,000 per year for 7 years, and a cost of capital of 12%. What is the project’s NPV ? Please show the steps of your work.
A) A project has an initial cost of $51,125, expected net cash inflows of $14,000 per...
A) A project has an initial cost of $51,125, expected net cash inflows of $14,000 per year for 11 years, and a cost of capital of 14%. What is the project's MIRR? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places. B)A project has an initial cost of $70,350, expected net cash inflows of $11,000 per year for 10 years, and a cost of capital of 11%. What is the...
1 A project has an initial cost of $ 320,000, expected after-tax cash inflows of $...
1 A project has an initial cost of $ 320,000, expected after-tax cash inflows of $ 75,000 per year for 8 years, a net salvage value of $ 30,000, and a cost of capital of 11%. a) What is the project's net present value? b) What is the project's profitability index? c) What is the project's internal rate of return? d) What is the project's modified internal rate of return (assume the investment rate to be equal to the cost...
Helsinki Co. is considering a new project that will cost $328,500. The expected net cash inflows...
Helsinki Co. is considering a new project that will cost $328,500. The expected net cash inflows from this project are $62,000 per year for 8 years. If Helsinki’s weighted average cost of capital (WACC) is 6%, what is the project’s net present value (NPV), IRR, Payback Period, and Discount Period? Please show work.
Part A: A project has an initial cost of $60,025, expected net cash inflows of $11,000...
Part A: A project has an initial cost of $60,025, expected net cash inflows of $11,000 per year for 11 years, and a cost of capital of 14%. What is the project's PI? Do not round your intermediate calculations. Round your answer to two decimal places. Part B: A project has an initial cost of $35,000, expected net cash inflows of $14,000 per year for 10 years, and a cost of capital of 11%. What is the project's MIRR? Do...
Suppose you are evaluating a project with the expected future cash inflows shown in the following...
Suppose you are evaluating a project with the expected future cash inflows shown in the following table. Your boss has asked you to calculate the project’s net present value (NPV). You don’t know the project’s initial cost, but you do know the project’s regular, or conventional, payback period is 2.50 years. Year Cash Flow Year 1 $375,000 Year 2 $475,000 Year 3 $500,000 Year 4 $400,000 If the project’s weighted average cost of capital (WACC) is 8%, the project’s NPV...
Suppose you are evaluating a project with the expected future cash inflows shown in the following...
Suppose you are evaluating a project with the expected future cash inflows shown in the following table. Your boss has asked you to calculate the project’s net present value (NPV). You don’t know the project’s initial cost, but you do know the project’s regular, or conventional, payback period is 2.50 years. Year Cash Flow Year 1 $325,000 Year 2 $475,000 Year 3 $450,000 Year 4 $475,000 1. If the project’s weighted average cost of capital (WACC) is 7%, the project’s...
Suppose a project has a $1,298 cost outlay in Year 0, $1000 net opertating cash inflows...
Suppose a project has a $1,298 cost outlay in Year 0, $1000 net opertating cash inflows for Years 1 - 5, and a $1,500 non-operating cash flow in Year 5. Assuming an 15% cost of capital, what is the project's equivalent annual annuity?
A project has an initial cost of $70,000, expected net cash inflows of $15,000 per year...
A project has an initial cost of $70,000, expected net cash inflows of $15,000 per year for 10 years, and a cost of capital of 12%. What is the project's PI? (Hint: Begin by constructing a time line.) Do not round intermediate calculations. Round your answer to two decimal places.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT