Question

In: Finance

Year Cash Flow Ins 1 $20,000 2 $40,000 3 $40,000 4 $20,000 5 $30,000 Rieger International...

Year Cash Flow Ins 1 $20,000 2 $40,000 3 $40,000 4 $20,000 5 $30,000 Rieger International is attempting to evaluate the feasibility of investing $96000 in a piece of equipment that has a 5 -year life. The firm has estimated the cash inflows associated with the proposal as shown in the following table. The firm has a 9 % cost of capital. a. Calculate the payback period for the proposed investment. b. Calculate the net present value (NPV) for the proposed investment. c. Calculate the internal rate of return (IRR), rounded to the nearest whole percent, for the proposed investment. d. Evaluate the acceptability of the proposed investment using NPV and IRR. What recommendation would you make relative to implementation of the project?

Solutions

Expert Solution

(a)-Payback Period for the Project

Year

Cash Flows ($)

Cumulative net Cash flow ($)

0

-96,000

-96,000

1

20,000

-76,000

2

40,000

-36,000

3

40,000

4,000

4

20,000

24,000

5

30,000

54,000

Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 2 Year + ($36,000 / $40,000)

= 2 Year + 0.90 Years

= 2.90 Years

(b)-Net Present Value (NPV)

Year

Annual Cash Inflow ($)

Present Value Factor at 9%

Present Value of Annual Cash Inflow ($)

1

20,000

0.91743

18,348.62

2

40,000

0.84168

33,667.20

3

40,000

0.77218

30,887.34

4

20,000

0.70843

14,168.50

5

30,000

0.64993

19,497.94

TOTAL

1,16,569.61

Net Present Value = Present Value of annual cash inflows – Present value of cash outflows

= $1,16,569.61 - $96,000

= $20,569.61

NOTE

The Formula for calculating the Present Value Factor is is [1/(1 + r)n], Where “r” is the Discount Rate and “n” is the number of years.

(c)-Internal Rate of Return (IRR)

Step – 1, Firstly calculate NPV at a guessed discount Rate, Say 16%

Year

Annual Cash Flow

Present Value factor at 16%

Present Value of Cash Flow

1

20,000

0.86207

17,241.38

2

40,000

0.74316

29,726.52

3

40,000

0.64066

25,626.31

4

20,000

0.55229

11,045.82

5

30,000

0.47611

14,283.39

TOTAL

97,923.41

Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment

= $97,923.41 - $96,000

= $1,923.41

Step – 2, NPV at 16% is positive, Calculate the NPV again at a higher discount rate, Say 18%

Year

Annual Cash Flow

Present Value factor at 18%

Present Value of Cash Flow

1

20,000

0.84746

16,949.15

2

40,000

0.71818

28,727.38

3

40,000

0.60863

24,345.23

4

20,000

0.51579

10,315.78

5

30,000

0.43711

13,113.28

TOTAL

93,450.82

Net Present Value (NPV) = Present Value of annual cash inflows – Initial Investment

= $93,450.82 - $96,000

= -$2,549.18 (Negative NPV)

Therefore IRR = R1 + NPV1(R2-R1)

                                   NPV1-NPV2

= 0.16 + [$1,923.41 x (0.18 – 0.16)]

              $1,923.41 – (-$2,549.18)

= 0.16 + 0.0084

= 0.1684

= 16.84%

“Therefore, The Internal Rate of Return (IRR) for the Project = 16.84%”

(d)-DECISION

Rieger International should “ACCEPT” the Proposed Investment Project, Since the NPV of the Project is Positive $20,569.61 and the IRR (16.84%) is greater than the Cost of Capital of 9%, and therefore, the project should be accepted.


Related Solutions

Consider the following cash flows: Year Cash Flow 2 $ 22,000 3 40,000 5 58,000 Assume...
Consider the following cash flows: Year Cash Flow 2 $ 22,000 3 40,000 5 58,000 Assume an interest rate of 8.8 percent per year. If today is Year 0, what is the future value of the cash flows five years from now? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) Future value        ? If today is Year 0, what is the future value of the cash flows ten years from now? (Do not...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5...
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5
  Consider the cash flow for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: ($1000), 100, 600, 700, 900, 300 Project B: ($1000), 900, 700, 500, 300, 300 The cost of capital for both projects is 10% 1. Find NPV, IRR and profitability index (PI) of projects A and B. 2. If projects A and B are mutually exclusive, which project would you select 3. Find the crossover rate for projects A and B
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000...
Consider the following cash flows: Year 0 1 2 3 4 5 6 Cash Flow -$10,000 $2,200 $3,300 $2,500 $2,500 $2,300 $2,100 A. Payback The company requires all projects to payback within 3 years. Calculate the payback period. Should it be accepted or rejected? B. Discounted Payback Calculate the discounted payback using a discount rate of 10%. Should it be accepted or rejected? C. IRR Calculate the IRR for this project. Should it be accepted or rejected? D. NPV Calculate...
Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 –...
Year Cash Flow 0 –$ 15,900 1 7,930 2 9,490 3 8,970 4 7,210 5 – 3,580 Required: The company uses an interest rate of 12 percent on all of its projects. Calculate the MIRR of the project using all three methods. (Do not round intermediate calculations. Round your answers to 2 decimal places (e.g., 32.16).) MIRR Discounting approach % Reinvestment approach % Combination approach %
Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5...
Case 2 Geo Tech Cash Flow Template (Base Case) Year 0 1 2 3 4 5 $600,000.00 $1,080,000.00 $1,050,000.00 $750,000.00 $570,000.00 Revenues Cash Costs Set up $280,000.00 $420,000.00 $280,000.00 $140,000.00 $140,000.00 Other operating $240,000.00 $240,000.00 $360,000.00 $360,000.00 $240,000.00 Depreciation $280,000.00 $280,000.00 $280,000.00 EBIT -$200,000.00 $140,000.00 $130,000.00 $250,000.00 $190,000.00 Taxes -$70,000.00 $49,000.00 $45,500.00 $87,500.00 $66,500.00 Net Operating Income After Taxes -$130,000.00 $91,000.00 $84,500.00 $162,500.00 $123,500.00 Add Depreciation $280,000.00 $280,000.00 $280,000.00 Net Operating Cash Flows $150,000.00 $371,000.00 $364,500.00 $162,500.00 $123,500.00 Recovery of...
Investment A: Year: 0 1 2 3 4 5 Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000...
Investment A: Year: 0 1 2 3 4 5 Cash flow: -$14,000 $6,000 $6,000 $6,000 $6,000 $6,000 Investment B: Year: 0 1 2 3 4 5 Cash flow: -$15,000 $7,000 $7,000 $7,000 $7,000 $7,000 Investment C: Year: 0 1 2 3 4 5 Cash flow: -$18,000 $12,000 $4,000 $4,000 $4,000 $4,000 The cash flows for three projects are shown above. The cost of capital is 7.5%. If an investor decided to take projects with a payback period two years or...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000...
Discounted Cash Flow: Year (n) 0 1 2 3 4 Undiscounted cash flow -$600,000 $200,000 $200,000 $200,000 $200,000 DCF @ 11% ∑DCF @11% DCF @ 13% ∑DCF @13% DCF @ 15% ∑DCF @15% Notes: DCF = Discounted Cash Flow ∑DCF = Cumulative Discounted Cash Flow Refer to the following video on how to calculate IRR with Excel. Provide your completed spreadsheet in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above....
YEAR 1 2 3 4 5 6 7 8 CASH FLOW -4090 -559 9380 3743 416...
YEAR 1 2 3 4 5 6 7 8 CASH FLOW -4090 -559 9380 3743 416 3276 -4677 -3074 a) Determine the maximum number of positive IRR roots for the given cash flow according to Descartes Rule. b) Determine the maximum number of positive IRR roots for the given cash flow according to Norstrom Criterion.                                                                                                                      c) Find ERR of the given cash flow if ε=10% per year. IN EXCEL PLZ!!
Year 1 2 3 4 5 Free Cash Flow $22 million $24 million $30 million $31...
Year 1 2 3 4 5 Free Cash Flow $22 million $24 million $30 million $31 million $35 million XYZ Industries is expected to generate the above free cash flows over the next five years, after which free cash flows are expected to grow at a rate of 3% per year. If the weighted average cost of capital is 8% and XYZ has cash of $18 million, debt of $35 million, and 74 million shares outstanding, what is General Industries'...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT