CASH FLOWS OVER PROJECT #2's LIFE Target Rate of Return 9.229% Net Cash Flows At End...

CASH FLOWS OVER PROJECT #2's LIFE
Target Rate of Return	9.229%
	Net Cash Flows At End of Year
Year Number	0	1	2	3	4
YEAR	2019	2020	2021	2022	2023
CAPITAL PRODUCT #2	-$1,581,500	$486,300	$486,700	$431,100	$1,123,100
Cumulative cash flows	-$1,581,500	-$1,095,200	-$608,500	-$177,400	$945,700
Discounted cash flows	-$1,581,500	$445,211	$407,930	$330,799	$788,981
Cumulative discounted cash flows	-$1,581,500	-$1,136,289	-$728,359	-$397,560	$391,421

Calculate using above information:

1) Net Present Value (NPV)

2) Internal Rate of Return (IRR)

3) Profitability Index (PI)

4) Modified Internal Rate of Return (MIRR)

5) Payback period (PP)

6) Discounted Payback Period (DPP)

Expert Solution

jeff jeffy answered 1 year ago

CASH FLOWS OVER PROJECT #1's LIFE Target Rate of Return 9.229% Net Cash Flows At End...

CASH FLOWS OVER PROJECT #1's LIFE Target Rate of Return 9.229% Net Cash Flows At End of Year Year Number 0 1 2 3 4 YEAR 2019 2020 2021 2022 2023 CAPITAL PRODUCT #1 -$1,461,200 $411,100 $474,300 $640,300 $819,500 Cumulative cash flows -$1,461,200 -$1,050,100 -$575,800 $64,500 $884,000 Discounted cash flows -$1,461,200 $376,365 $397,537 $491,326 $575,701 Cumulative discounted cash flows -$1,461,200 -$1,084,835 -$687,298 -$195,972 $379,729 Calculate using above information: 1) Net Present Value (NPV) 2) Internal Rate of Return (IRR) 3)...

CASH FLOWS OVER PROJECT #4's LIFE Target Rate of Return 9.229% Net Cash Flows At End...

CASH FLOWS OVER PROJECT #4's LIFE Target Rate of Return 9.229% Net Cash Flows At End of Year Year Number 0 1 2 3 4 YEAR 2019 2020 2021 2022 2023 CAPITAL PRODUCT #4 -$963,900 $243,900 $329,300 $434,900 $516,500 Cumulative cash flows -$963,900 -$720,000 -$390,700 $44,200 $560,700 Discounted cash flows -$963,900 $223,292 $276,004 $333,715 $362,843 Cumulative discounted cash flows -$963,900 -$740,608 -$464,603 -$130,889 $231,954 Calculate using above information: 1) Net Present Value (NPV) 2) Internal Rate of Return (IRR) 3)...

Cash Flow Over Project #3 Lifecycle Target Rate of Return 9.229% Net Cash Flows At End...

Cash Flow Over Project #3 Lifecycle Target Rate of Return 9.229% Net Cash Flows At End of Year Year Number 0 1 2 3 4 YEAR 2019 2020 2021 2022 2023 CAPITAL PRODUCT #3 -$1,593,800 $406,900 $445,500 $691,100 $1,106,400 Cumulative cash flows -$1,593,800 -$1,186,900 -$741,400 -$50,300 $1,056,100 Discounted cash flows -$1,593,800 $372,520 $373,398 $530,307 $777,249 Cumulative discounted cash flows -$1,593,800 -$1,221,280 -$847,882 -$317,575 $459,674 Calculate using the above information: 1) Net Present Value (NPV) 2) Internal Rate of Return (IRR)...

Problem 2: Given the net cash flows for Project X (over 3-years) for Aberdeen Company Year...

Problem 2: Given the net cash flows for Project X (over 3-years) for Aberdeen Company Year CF 0-$300,000 1 $120,000 2 $128,000 3 $155,000 The company's capital structure is distributed equally between debt, preferred stock, common stock and new common stock. It has also the following information: 1- After tax cost of debt: 5.4%. Tax rate: 40% 2- Preferred stocks are selling at $80 per share and pay a dividend of $8 per share 3- Common stocks are selling at...

A project generates cash flows of $125k, $125k, and $95k. The required rate of return is...

A project generates cash flows of $125k, $125k, and $95k. The required rate of return is 10%. The value of the project or “asset” is $288,317. Given your answer, which ones are true. IRR = 10% PI = 1.0 NPV = 0

What is the internal rate of return (IRR) of this project given the following cash flows?...

What is the internal rate of return (IRR) of this project given the following cash flows? Year CF 0 -$9,800 1 $1,000 2 $4,500 3 $1,000 4 $1,500 5 $1,700 6 $2,700 Convert your answer to percentage and round off to two decimal points. Do not enter % in the answer box.

16) A project has the following cash flows. What is the internal rate of return? Year/Cash...

16) A project has the following cash flows. What is the internal rate of return? Year/Cash Flow 0/ -$89,300.00 1/ $82,900.00 2/ $4,200.00 3/ $5,800.00 A) 1.02 percent B) 6.77 percent C) 5.97 percent D) 1.11 percent E) 3.45 percent 17) A company wants to purchase a new machine costing $1.46 million. Management is estimating the machine will generate cash inflows of $223,000 the first year and $600,000 for the following four years. If management requires a minimum 12 percent...

The Net Present Value method of project evaluation is preferred over the Internal Rate of Return...

The Net Present Value method of project evaluation is preferred over the Internal Rate of Return method because the Net Present Value method: a. Considers the time value money where IRR does not. b. Considers the risk of the project where the Internal Rate of Return does not. c. Includes all the cash flows in its decision where IRR does not. d. Considers the timing of the cash flows where the Internal Rate of Return does not. e. Assumes a...

a)Compute the Internal Rate of Return (IRR) of the prospective project: Estimated cash flows are $18,200...

a)Compute the Internal Rate of Return (IRR) of the prospective project: Estimated cash flows are $18,200 at the end of every year for 6 years. Cost today is $67,000. b) Should the company accept the project if the company's cost of capital is 7%, and why or why not? Please show all work using the TI BAII Plus Calculator like the example below: Make sure that 2nd I/Y which is P/Y is set to 1.0. Make sure that 2nd PMT...

Internal Rate of Return A project is estimated to cost $300,495 and provide annual net cash...

Internal Rate of Return A project is estimated to cost $300,495 and provide annual net cash flows of $69,000 for six years. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589 5 4.212 3.791 3.605 3.352 2.991 6 4.917 4.355 4.111 3.784 3.326 7 5.582 4.868 4.564 4.160 3.605...

Question