Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

1)Consider the following cash flows: Year Cash Flow 0 –$ 33,500 1 13,500 2 18,20

ID: 2753847 • Letter: 1

Question

1)Consider the following cash flows:

Year Cash Flow
0 –$ 33,500
1 13,500
2 18,200
3 10,900

Required:

What is the IRR of the above set of cash flows? (Do not include the percent sign (%). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

2)Your coin collection contains 57 1952 silver dollars.

Required:

If your grandparents purchased them for their face value when they were new, how much will your collection be worth when you retire in 2055, assuming they appreciate at a 6.4 percent annual rate? (Do not include the dollar sign ($). Enter rounded answer as directed, but do not use the rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)

Explanation / Answer

Calculation of IRR:

At IRR as discount rate , NPV of the cash flows should be zero.

Let's calculate NPV at 13% discount rate:

Year

Cash Flows (CF)

PVF (13%)

PV

0

$       (33,500.00)

1

$ (33,500.00)

1

$         13,500.00

0.884955752

$   11,946.90

2

$         18,200.00

0.783146683

$   14,253.27

3

$         10,900.00

0.693050162

$      7,554.25

NPV

$         254.42

At 13% discount rate NPV is positive,

we need a discount rate that makes NPV 0,

so we should take 14% as discount rate

Let's calculate NPV at 14% discount rate:

Year

Cash Flows (CF)

PVF (14%)

PV

0

$      (33,500.00)

1

$ (33,500.00)

1

$         13,500.00

0.877192982

$   11,842.11

2

$         18,200.00

0.769467528

$   14,004.31

3

$         10,900.00

0.674971516

$      7,357.19

NPV

$       (296.40)

Now we have got negative NPV at 14%,

it means IRR is in between 13% and 14%

Lets calculate exact IRR:

Discount rate

NPV

13%

$         254.42

14%

$      (296.40)

Difference

1%

$         550.82

IRR = 13% + 1% * (254.42 / 550.82) =

13.46%

Hence IRR of the project is 13.46%

Calculation of IRR:

At IRR as discount rate , NPV of the cash flows should be zero.

Let's calculate NPV at 13% discount rate:

Year

Cash Flows (CF)

PVF (13%)

PV

0

$       (33,500.00)

1

$ (33,500.00)

1

$         13,500.00

0.884955752

$   11,946.90

2

$         18,200.00

0.783146683

$   14,253.27

3

$         10,900.00

0.693050162

$      7,554.25

NPV

$         254.42

At 13% discount rate NPV is positive,

we need a discount rate that makes NPV 0,

so we should take 14% as discount rate

Let's calculate NPV at 14% discount rate:

Year

Cash Flows (CF)

PVF (14%)

PV

0

$      (33,500.00)

1

$ (33,500.00)

1

$         13,500.00

0.877192982

$   11,842.11

2

$         18,200.00

0.769467528

$   14,004.31

3

$         10,900.00

0.674971516

$      7,357.19

NPV

$       (296.40)

Now we have got negative NPV at 14%,

it means IRR is in between 13% and 14%

Lets calculate exact IRR:

Discount rate

NPV

13%

$         254.42

14%

$      (296.40)

Difference

1%

$         550.82

IRR = 13% + 1% * (254.42 / 550.82) =

13.46%

Hence IRR of the project is 13.46%