Question

Question 4 (Total marks =15) You are evaluating an investment project, Project XX, with the following...

Question 4 (Total marks =15)
You are evaluating an investment project, Project XX, with the following cash flows:
Period Cash Flow
0 -$200,000
1 $65,000
2 $65,000
3 $65,000
4 $65,000
5 -$65,000
Calculate the following:
(a). Payback period ( 2 marks)
(b). Calculate the discounted cash flows for each year, assuming a 10% discount rate.

(c) Discounted payback period, assuming a 10% cost of capital.
(d) .Net present value, assuming a 10% cost of capital.
(e). Profitability index, assuming a 10% cost of capital.
(f). Modified internal rate of return, assuming reinvestment at 10%.

Homework Answers

Answer #1

1. Payback Period = Total Investment = 200,000 + 65,000 = 265,000

Cash Flow during the life of the project = 260,000

So the firm will not be able to recover the money during the life of the asset

2. Discounted cash flows are

Year Cash Flows PVF PVCI Cummulative cash Flow
0 -200000 1 -200000 -200000
1 65000 0.9091 59090.91 -140909
2 65000 0.8264 53719.01 -87190.1
3 65000 0.7513 48835.46 -38354.6
4 65000 0.6830 44395.87 6041.254
5 -65000 0.6209 -40359.9 -34318.6

3. Discounted pay back period

Present Value of Cash Outflows = 200,000 + 40360 = 240,360

Present Value of Cash Iflows = 206041

SO Discounted payaback period can be determined as it extends beyond the life of the project

4. NPv = Sum tota of all cash flows i.e total of 4th column in the above table = -34,318.60

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
You are evaluating an investment project costing $11,800 initially. The project will provide $3,000 in after-tax...
You are evaluating an investment project costing $11,800 initially. The project will provide $3,000 in after-tax cash flows in the first year and $5,000 each year thereafter for 4 years. The maximum payback period for your company is 3 years. Your company's cost of capital is 14%. 1)What is the payback period for this project? 2)Should your company accept this project based on the payback period criterion? 3)What is the discounted payback period for this project? 4) Should your company...
King Fisher Aviation is evaluating an investment project with the following case flows: $6,000 $5,500 $7,000...
King Fisher Aviation is evaluating an investment project with the following case flows: $6,000 $5,500 $7,000 $8,000 Discount rate 14 percent What is the discounted payback period for these cash flows if the initial cost is 15,000? What if the initial cost is $12,000? What if the cost is $16,000? show all work
Stone Inc. is evaluating a project with an initial cost of $11,500. Cash inflows are expected...
Stone Inc. is evaluating a project with an initial cost of $11,500. Cash inflows are expected to be $1,500, $1,500 and $13,000 in the three years over which the project will produce cash flows. If the discount rate is 11%, what is the payback, net present value and profitability index of the project?
You are analyzing a project and have prepared the following data: Year Cash flows 0 -$275,000...
You are analyzing a project and have prepared the following data: Year Cash flows 0 -$275,000 1 $ 50,000 2 $ 75,000 3 $ 95,000 4 $ 15,000 Required payback period 3 years Required rate of return 5% You are required to: a) Determine the project’s Profitability Index, Internal Rate of Return, NPV and Discounted Payback Period b) Decide whether to accept the project based on the above investment decision criteria?
Suppose the cash flows for project are C0 = -2000; C1 = 500; C2 = 1000;...
Suppose the cash flows for project are C0 = -2000; C1 = 500; C2 = 1000; C3 = 4000, C4= 1000, C5= 500. The discounted payback period is ____________________ and profitability index is ___________________ at a discount rate of 10 percent.
Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4...
Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4 775,000 5 775,000 Year Project B Expected Cash Flows ($) 0 (1,050,000) 1 650,000 2 500,000 3 226,250 4 137,500 5 62,500 Metrics Payback Period (in years) (A)3.54 (B)1.8 Discounted payback period (in years) (A)4.58 (B)2.72 Net Present Value (NPV) (A)$160,816 (B)$151,742 Internal Rate of Return (A)18.90% (B)23.84% Profitability Index (A)1.13 (B)1.14 Modified Internal Rate of Return (MIRR) (A)17.82% (B)18.15% a). Which of the...
​(Discounted payback period​) Sheinhardt Wig Company is considering a project that has the following cash​ flows:...
​(Discounted payback period​) Sheinhardt Wig Company is considering a project that has the following cash​ flows: If the​ project's appropriate discount rate is 9 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is nothing years. ​(Round to two decimal​ places.) YEAR   PROJECT CASH FLOW 0   -60,000 1   20,000 2   50,000 3   65,000 4   55,000 5   40,000
"The FIN340 Company has a WACC of 10.0% and is evaluating a project with the following...
"The FIN340 Company has a WACC of 10.0% and is evaluating a project with the following projected annual cash flows: Period 0 (Start of Project): $-170, Period 1: $-30, Period 2: $30, Period 3: $170, Period 4: $60, Period 5: $15 - Calculate the Modified Internal Rate of Return (MIRR) for this project." 10.41% Insufficient data provided to calculate 10.61% 11.01% 9.65% 11.67% 10.81%
A project has the following total (or net) cash flows.                __________________________________________            &nbs
A project has the following total (or net) cash flows.                __________________________________________               Year          Total (or net) cash flow                _________________________________________ 1 $20,000 2 30,000 3 50,000 4 60,000 _________________________________________ The required rate of return on the project is 15 percent. The initial investment (or initial cost or initial outlay) of the project is $80,000. a) Find the net present value (NPV) of the project. b) Find the profitability index (PI) of the project. c) Calculate the modified internal rate...
im evaluating a project that will cost 500,000, but is expected to produce cash flows of...
im evaluating a project that will cost 500,000, but is expected to produce cash flows of 175,000 per year for 10yrs, with the first cash flow in one year. cost of capital is 11%. what is the discounted payback period of this project?