Calculate the NPV at 9% and the IRR for the following projects: An initial outlay of...

Calculate the NPV at 9% and the IRR for the following projects: An initial outlay of $69,724 and an inflow of 15,000 followed by four consecutive inflows of $17,000

Expert Solution

Year	Cashflow	PVF@9%	*CashflowPVF**
0	(69,724)	1	(69,724.00)
1	15,000	0.9174	13,761.47
2	17,000	0.8417	14,308.56
3	17,000	0.7722	13,127.12
4	17,000	0.7084	12,043.23
5	17,000	0.6499	11,048.83

NPV = Cashflow*PVF

= -5434.79

IRR is the rate at which NPV =0. IRR is calculated using trial and error method

Since NPV at 9% is negative take a lower rate say 8%.

Year	Cashflow	PVF@9%	*CashflowPVF**
0	(69,724)	1	(69,724.00)
1	15,000	0.9259	13,888.89
2	17,000	0.8573	14,574.76
3	17,000	0.7938	13,495.15
4	17,000	0.7350	12,495.51
5	17,000	0.6806	11,569.91

NPV = Cashflow*PVF

= -3699.78

IRR = R1+(NPV1*(R2-R1))/(NPV1-NPV2)

= 8+(-3699.78*(9-8))/(-3699.78+5434.79)

= 8+(-3699.78)/1735.01

= 5.87%

= 6%

jeff jeffy answered 11 months ago

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $11,000 resulting...

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $11,000 resulting in a single free cash flow of $17,051 after 6 years b. An initial outlay of $11,000 resulting in a single free cash flow of $52,527 after 14 years c. An initial outlay of $11,000 resulting in a single free cash flow of $113,017 after 19 years d. An initial outlay of $11,000 resulting in a single free cash flow of $13,784 after 4...

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $9,000 resulting...

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $9,000 resulting in a single free cash flow of $17,118 after 7 years ____% b. An initial outlay of $9,000 resulting in a single free cash flow of $46,991 after 13 years ____% c. An initial outlay of $9,000 resulting in a single free cash flow of $109,128 after 19 years ____% d. An initial outlay of $9,000 resulting in a single free cash flow of...

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting...

(IRR calculation) Determine the IRR on the following projects: a. An initial outlay of $10,000 resulting in a single free cash flow of $16,863 after 7 years b. An initial outlay of $10,000 resulting in a single free cash flow of $50,003 after 14 years c. An initial outlay of $10,000 resulting in a single free cash flow of $114,691 after 23 years d. An initial outlay of $10,000 resulting in a single free cash flow of $14,283 after 3...

NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of...

NPV, PI, and IRR calculations) You are considering a project with an initial cash outlay of $70,000 and expected free cash flows of $28,000 at the end of each year for 6 years. The required rate of return for this project is 7 percent. a. What is the project's payback period? b. What is the project's NPV? c. What is the project's PI? d. What is the project's IRR?

Calculate the internal rate of return on the following projects: Initial outlay of $50,000 with an...

Calculate the internal rate of return on the following projects: Initial outlay of $50,000 with an after-tax cash flow of $10,000 per year for eight years. Initial outlay of $600,000 with an after-tax cash flow of $120,000 per year for ten years. Initial outlay of $25,000 with an after-tax cash flow $11,500 per year for three years.

Problem 10-8 Calculate the NPV at 8% and the IRR for the following projects. Round the...

Problem 10-8 Calculate the NPV at 8% and the IRR for the following projects. Round the answers to two decimal places. Use a minus sign to indicate a negative NPV. An initial outlay of $69,724 and an inflow of $15,000 followed by four consecutive inflows of $17,000. Do not round intermediate calculations. Round PVF and PVFA values in intermediate calculations to four decimal places. NPV $ IRR % An initial outlay of $25,424 followed by two zero cash years and...

1. (NPV and IRR calculation)East Coast Television is considering a project with an initial outlay of...

1. (NPV and IRR calculation)East Coast Television is considering a project with an initial outlay of $X (you will have to determine this amount). It is expected that the project will produce a positive cash flow of $55,000 a year at the end of each year for the next 16 years. The appropriate discount rate for this project is 9 percent. If the project has an internal rate of return of 12 percent, what is the project's net present value?...

These are the cash flows for two projects. Calculate the NPV and IRR for both. Then...

These are the cash flows for two projects. Calculate the NPV and IRR for both. Then select the best project according to the NPV measure. Use a WACC of 10% for both projects. The investments are 7 for project 1, and 8 for project 2. Cash flows for project 1 year 1 2 3 4 cash 4 6 2 4 Cash flows for project 2 year 1 2 3 4 cash 3 2 7 4 Calculate the NPV for project...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...

Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%

NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of...

NPV & IRR: Find the NPV (assume 8% just to calculate NPV initially) & IRR of these projects. When would you choose one over the other (i.e. what is the crossover rate)? Draw the NPV profile using 11 intervals of interest rates ranging from (and including) 0% to 100%. Place all data, ratios, calculations, findings, etc. in the first Excel sheet with references to the information in other sheets. Time A CF B CF 0 -10000 -10000 1 12000 9000...

Question