Accounting

profileSam321
TimeValueofMoneyPart2LectureProblemsSolutions.docx

FNAN 303

Solutions to lecture problems – time value of money, part 2

Lecture Problem 1-a

How much is a building worth that is expected to produce cash flows of $200,000 in 1 year and $500,000 in 2 years if the cost of capital is 10.0 percent? Since there’s no information on expected cash flows at times other than in 1 and 2 years, assume those are the only times with non-zero expected cash flows.

Time

0

1

2

Expected cash flow

0

$200,000

$500,000

Present value

?

PV = C0 + [C1/(1+r)1] + [C2/(1+r)2]

C0 = 0 C1 = 200,000 C2 = 500,000 r = .100

PV = C0 + [C1/(1+r)1] + [C2/(1+r)2]

= 0 + [200,000/(1.100)] + [500,000/(1.100)2]

= 0 + 181,818 + 413,223

= 595,041

Answer: $595,041

====================================

Lecture Problem 1-b

A building that is worth $500,000 and has a cost of capital of 10.0% is expected to produce cash flows of $200,000 in 1 year and X in 3 years. What is X?

Time

0

1

2

3

Expected cash flow

0

$200,000

$0

X

Present value

$500,000

PV = C0 + [C1/(1+r)1] + [C2/(1+r)2]

PV = 500,000 C0 = 0 C1 = 200,000 C2 = 0 C3 = X r = .100

PV = C0 + [C1/(1+r)1] + [C2/(1+r)2] + [C3/(1+r)3]

500,000 = 0 + [200,000/(1.10)] + [0/(1.100)2] + [X/(1.100)3]

500,000 = 0 + [200,000/(1.10)] + [X/(1.100)3]

500,000 = 0 + 181,818 + [X/(1.100)3]

So 500,000 – 181,818 = [X/(1.100)3]

So 318,182 = [X/(1.100)3]

The present value of the cash flow expected in year 3 is $318,182

The value of the cash flow expected in year 3 is X where 318,182 = [X/(1.100)3]

So X = [318,182 × (1.100)3] = $423,500

Confirm:

PV = C0 + [C1/(1+r)1] + [C2/(1+r)2] + [C3/(1+r)3]

PV = 0 + [200,000/(1.100)1] + [0/(1.100)2] + [423,500/(1.100)3]

= 0 + 181,818 + 0 + 318,182

= 500,000 ☺

========================================

Lecture Problem 2

You own a building that is expected to pay annual cash flows forever. What is the value of the building if the cost of capital is 8.0% and annual cash flows of $500,000 are expected with the first one in 1 year?

Time

0

1

2

3

4

Cash flow

$0

$500,000

$500,000

$500,000

$500,000

Present value

?

The cash flows reflect a fixed perpetuity

PV = C / r

C = $500,000 r = .080

PV = $500,000 / .080 = $6,250,000

==============================

Lecture Problem 3-a

You own a building that is expected to pay annual cash flows forever. What is the amount of the annual cash flow produced by a building expected to be if the building is worth $2,300,000, the cost of capital is 5.0%, and annual fixed cash flows are expected with the first one due in one year?

Time

0

1

2

3

4

Cash flow

$0

C

C

C

C

Present value

$2,300,000

The cash flows reflect a fixed perpetuity

C = PV × r

PV = $2,300,000 r = .050

C = $2,300,000 × .050

= $115,000

==============================

Lecture Problem 3-b

What is the present value (as of today) of the expected cash flow produced by a building in 3 years if the building is worth $2,300,000, the cost of capital is 5.0%, and annual fixed cash flows are expected with the first one due in one year?

Approach

1) Find the cash flow expected in 3 years

2) Find the present value of the cash flow expected in 3 years

1) Find the cash flow expected in 3 years

Time

0

1

2

3

4

Cash flow

$0

C

C

C

C

Present value

$2,300,000

The cash flows reflect a fixed perpetuity

C = PV × r

PV = $2,300,000

r = .050

C = $2,300,000 × .050

= $115,000

2) Find the present value of the cash flow expected in 3 years

PV0 = C3 / (1+r)3

C3 = $115,000 (note that all cash flows are $115,000)

r = .050

PV0 = 115,000 / 1.0503

= $99,341

===============================

Lecture Problem 3-c

What is the cost of capital for the building if its value is $1,700,000 and annual cash flows of $100,000 are expected with the first one in 1 year?

Time

0

1

2

3

4

Cash flow

$0

$100,000

$100,000

$100,000

$100,000

Present value

1,700,000

The cash flows reflect a fixed perpetuity

r = C / PV

C = $100,000 PV = $1,700,000

r = $100,000 / $1,700,000 = .0588 = 5.88%

=========================================

Lecture Problem 4

An investment is expected to generate annual cash flows forever. The first annual cash flow is expected in 1 year and all subsequent annual cash flows are expected to grow at a constant rate annually. We know that the cash flow expected in 2 years from today is expected to be $50.00 and the cash flow expected in 5 years from today is expected to be $55.62. What is the cash flow expected to be in 4 years from today?

Approach:

1) Find the annual growth rate

2) Find the cash flow expected in 4 years

Time

0

1

2

3

4

5

CF

0

C1

C2

C3

C4

C5

CF

0

C1

50.00

C3

C4

55.62

CF

0

C1

C2

C2 × (1+g)

C2 × (1+g)2

C2 × (1+g)3

CF

0

C1

C2

C3

C4

C4 × (1+g)

CF

0

C1

C2

C3

C4

C5

1) Find the annual growth rate

We know that Cb = Ca × (1+g)b-a so C5 = C2 × (1+g)3

C2 = 50.00 C5 = 55.62

So 55.62 = 50.00 × (1+g)3

(55.62/50.00) = (1+g)3

(55.62/50.00)(1/3) = [(1+g)3](1/3) = 1 + g

= 1.0361

So g = 1.0361 – 1 = .0361

2) Find the cash flow expected in 4 years

We know that Cb = Ca × (1+g)b-a so C4 = C2 × (1+g)4-2 = C2 × (1+g)2

C2 = 50.00 and g = .0361

So C4 = C2 × (1+g)4-2 = 50.00 × (1.0361)2 = $53.68

We also know that Cb = Ca × (1+g)b-a so C5 = C4 × (1+g)5-4 = C4 × (1+g)1

So 55.62 = C4 × 1.0361

C5 = 55.62 / 1.0361 = $53.68

=================================

Lecture Problem 5-a

You own a building that is expected to pay annual cash flows forever. What is the value of the building if the cost of capital is 8.3% and annual cash flows are expected to grow by 2.3% per year forever with the first one expected to be $500,000 in 1 year?

Time

0

1

2

3

4

Cash flow

$0

$500,000

$500,000 × 1.023

$500,000 × 1.0232

$500,000 × 1.0233

Cash flow

$0

$500,000

$511,500

$523,265

$535,300

Present value

?

The cash flows reflect a growing perpetuity

PV = C1 / (r – g)

C1 = $500,000 r = .083 g = .023

PV = $500,000 / (.083 – .023) = $500,000 / .060 = $8,333,333

====================================

Lecture Problem 5-b

You own a building that is expected to pay annual cash flows forever. If the building is worth $2,300,000, the cost of capital is 5.0%, and annual cash flows are expected with the first one due in one year and all subsequent ones growing annually by 2.2%, then what is the amount of the cash flow produced by the building in 1 year expected to be?

Time

0

1

2

3

4

Cash flow

$0

?

? × (1.022)

? × (1.022)2

? × (1.022)3

Present value

$2,300,000

The cash flows reflect a growing perpetuity

C1 = PV × (r – g)

PV = $2,300,000 r = .050 g = .022

C1 = $2,300,000 × (.050 – .022)

= $2,300,000 × .028

= $64,400

======================================

Lecture Problem 5-c

You own a building that is expected to pay annual cash flows forever. If the building is worth $2,300,000, the cost of capital is 5.0%, and annual cash flows are expected with the first one due in one year and all subsequent ones growing annually by 2.2%, then what is the amount of the cash flow produced by the building in 3 years expected to be?

We know that C1 = $64,400

Therefore, C2 = C1 × (1.022)

And C3 = C2 × (1.022) = C1 × (1.022)2 = 64,400 × (1.022)2 = 67,265

Time

1

2

3

Cash flow

C1

C2

C3

Cash flow

C1

C1 × (1.022)

C2 × (1.022)

Cash flow

C1

C1 × (1.022)

C1 × (1.022)2

Cash flow

64,400

65,816.80

67,264.77

===============================

Lecture Problem 5-d

You own a building that is expected to pay annual cash flows forever. If the building is worth $850,000, the cost of capital is 8.30%, annual cash flows are expected with the first one due in one year and equal to $62,000, and all subsequent cash flows are expected to grow annually by a constant rate, then what is the expected annual growth rate of the expected cash flows?

Time

0

1

2

3

4

Cash flow

$0

62,000

62,000 × (1+g)

62,000 × (1+g)2

62,000 × (1+g)3

Present value

850,000

The cash flows reflect a growing perpetuity

PV = C1 / (r – g), so g = r – (C1 / PV)

PV = $850,000 r = .0830 C1 = $62,000

g = r – (C1 / PV)

= .0830 – (62,000 / 850,000)

= .0830 – .0729

= .0101

= 1.01%

=============================================

Lecture Problem 6

What is the price of an investment that pays you $1,000 per month with the first payment in 1 month and the last payment in 6 months if the expected return for the investment is 1.0% per month?

From the timeline, we can see that the cash flows reflect a 6-period ordinary annuity

Time

0m

1m

2m

3m

4m

5m

6m

Pmt #

1

2

3

4

5

6

CF

0

1000

1000

1000

1000

1000

1000

Time reflects the number of periods from time 0

Pmt # is a count of the number of payments

END Mode

Enter 6 1.0 1,000 0

N I% PV PMT FV

Solve for -5,795.48

======================================

Lecture Problem 7-a

What is the price of a car if the loan from the bank to buy it involves annual payments of $7,300 to the bank for 5 years at an annual interest rate of 9.4 percent with the first annual payment made to the bank in 1 year and a special payment of $5,000 to the bank in 5 years?

The car price equals the opposite of the present value of the loan payments, including the special payment, discounted by the interest rate of the loan.

Time

0

1

2

3

4

5

CF from regular payments

0

-7,300

-7,300

-7,300

-7,300

-7,300

CF from special payment

-5,000

Present value

?

The present value of the loan payments equals:

1) The present value of a 5-period annuity with regular cash flows of -$7,300 and a discount rate of 9.4%

2) A cash flow of -$5,000 in 5 years with a discount rate of 9.4%

1) The PV of the annuity

END mode

Enter 5 9.4 -7,300 0

N I% PMT PV FV

Solve for 28,102

The present value of the cash flows associated with the regular payments is -$28,102

2) PV of -$5,000 in 5 years

Note that mode is not relevant

Enter 5 9.4 0 -5,000

N I% PMT PV FV

Solve for 3,191

The present value of the cash flows associated with the special payment is -$3,191

Combine the 2 pieces

The present value of the loan payments = -$28,102 + (-$3,191) = -$31,293

So the price of the car is $31,293

(Answers may differ slightly due to rounding)

Note: can be done in 1 step, since N = 5 for annuity and N = 5 for special payment

END mode

Enter 5 9.4 -7,300 -5,000

N I% PMT PV FV

Solve for 31,293

The present value of the cash flows associated with the payments is -$31,293

So the price of the car is $31,293

==================================

Lecture Problem 7-b

What is the price of a car if the loan from the bank to buy it involves annual payments of $6,200 to the bank for 5 years at an annual interest rate of 11.7 percent with the first annual payment made to the bank in 1 year and a special payment of $5,000 to the bank in 3 years?

The car price equals the opposite of the present value of the loan payments, including the special payment, discounted by the interest rate of the loan.

Time

0

1

2

3

4

5

CF from regular payments

0

-6,200

-6,200

-6,200

-6,200

-6,200

CF from special payment

-5,000

Present value

?

The present value of the loan payments equals:

1) The present value of a 5-period annuity with regular cash flows of -$6,200 and a discount rate of 11.7%

2) A cash flow of -$5,000 in 3 years with a discount rate of 11.7%

1) The PV of the annuity

END mode

Enter 5 11.7 -6,200 0

N I% PMT PV FV

Solve for 22,517

The present value of the cash flows associated with the regular payments is -$22,517

2) PV of -$5,000 in 3 years

Note that mode is not relevant

Enter 3 11.7 0 -5,000

N I% PMT PV FV

Solve for 3,588

The present value of the cash flows associated with the special payment is -$3,588

Combine the 2 pieces

The present value of the loan payments = -$22,517 + (-$3,588) = -$26,105

So the price of the car is $26,105

(Answers may differ slightly due to rounding)

Note: must be done in 2 steps, since N = 5 for annuity and N = 3 for special payment

=====================================

Lecture Problem 8-a

What is the value of an investment that pays you $1,000 a month with the first payment today and the last payment in 6 months if the discount rate is 1.0% per month?

From the timeline, we can see that the cash flows reflect a 7-period annuity due

Time

0m

1m

2m

3m

4m

5m

6m

Pmt #

1

2

3

4

5

6

7

CF

1000

1000

1000

1000

1000

1000

1000

Time reflects the number of periods from time 0

Pmt # is a count of the number of payments

N = 7 (number of payments, not necessarily when last payment is expected to be made)

BEGIN Mode

Enter 7 1.0 1,000 0

N I% PV PMT FV

Solve for -6,795.48

==============================

Lecture Problem 8-b

What is the value of an investment that pays you $1,000 per month for 7 months if the first payment is today and the discount rate is 1.0% per month?

Monthly payments “for 7 months” tells us that there are 7 payments

From the timeline, we can see that the cash flows reflect a 7-period annuity due

Time

0m

1m

2m

3m

4m

5m

6m

Pmt #

1

2

3

4

5

6

7

CF

1000

1000

1000

1000

1000

1000

1000

Time reflects the number of periods from time 0

Pmt # is a count of the number of payments

N = 7 (number of payments, not necessarily when last payment is expected to be made)

BEGIN Mode

Enter 7 1.0 1,000 0

N I% PV PMT FV

Solve for -6,795.48

====================================

Lecture Problem 8-c

What is the value of an investment that pays you $2,000 in 5 months plus $1,000 per month with the first $1,000 payment today and the last $1,000 payment in 5 months if the discount rate is 1.0% per month?

From the timeline, we can see that the cash flows reflect a 6-period annuity due plus a cash flow of $2,000 in 5 months

Time

0

1

2

3

4

5

6

Pmt #

1

2

3

4

5

6

CF

1000

1000

1000

1000

1000

1000 + 2000

0

Value of investment = PV of the6-period annuity due + PV of the cash flow of $2,000 in 5 months

PV of the 6-period annuity due

BEGIN Mode

Enter 6 1.0 1,000 0

N I% PV PMT FV

Solve for -5,853.43

PV of the cash flow of $2,000 in 5 months

PV = C5 / (1+r)5

r = .010

C5 = 2,000 (note: this CF reflects the cash flow not associated with the annuity due)

PV = 2,000 / (1.010)5 = 1,902.93

Mode is not relevant, since PMT = 0

Enter 5 1.0 0 2000

N I% PV PMT FV

Solve for -1,902.93

Aggregate the two sources of value

The value of the investment = 5,853.43 + 1,902.93 = $7,756.36

Important note

You can not do this problem in one calculator step: if you input in $2,000 as FV, the calculator will treat that cash flow as taking place in N periods, which would be in 6 periods and you would produce the following:

BEGIN Mode

Enter 6 1.0 1,000 2,000

N I% PV PMT FV

Solve for -7,737.52

Time line reflected by the preceding:

Time

0

1

2

3

4

5

6

CF

1000

1000

1000

1000

1000

1000

2000

========================================

Lecture Problem 8-d

What is the value of an investment that pays you $2,000 in 6 months plus $1,000 a month with the first $1,000 payment today and the last $1,000 payment in 11 months if the discount rate is 1.0% per month?

From the timeline, we can see that the cash flows reflect a 12-period annuity due plus a cash flow of $2,000 in 6 months

Time

0

1

2

3

4

5

6

7

8

9

10

11

12

Pmt #

1

2

3

4

5

6

7

8

9

10

11

12

CF

1000

1000

1000

1000

1000

1000

1000 + 2000

1000

1000

1000

1000

1000

0

Time reflects the number of periods from time 0

Pmt # is a count of the number of payments

Value of investment = PV of the 12-period annuity due + PV of the cash flow of $2,000 in 6 months

PV of the 12-period annuity due

BEGIN Mode

Enter 12 1.0 1,000 0

N I% PV PMT FV

Solve for -11,367.63

PV of the cash flow of $2,000 in 6 months

PV = C6 / (1+r)6

r = .010

C6 = 2,000 (note: this CF reflects the cash flow not associated with the annuity due)

PV = 2,000 / (1.010)6 = 1,884.09

Mode is not relevant, since PMT = 0

Enter 6 1.0 0 2000

N I% PV PMT FV

Solve for -1,884.09

Aggregate the two sources of value

The value of the investment = 11,367.63 + 1,884.09 = $13,251.72

Note that the investment is worth more when the $2,000 comes sooner (in 6 months vs. 11 months in the previous problem).

===================================

Lecture Problem 9

If Arturo has $50,000 to invest, how much can he expect to receive each year as a fixed annual payment if he receives his first fixed annual payment today, he receives his last payment in 7 years, and he expects to earn 1.0% per year?

The cash flows that Arturo expects to receive reflect an annuity due with 8 annual payments. We want to find the size of the payments such that the annuity due would have a present value of $50,000.

A timeline shows that the number of payments is 8 (even though the last payment occurs in 7 years from now):

Time

0

1

2

3

4

5

6

7

Pmt #

1

2

3

4

5

6

7

8

CF

X

X

X

X

X

X

X

X

BEGIN Mode

Enter 8 1.0 -50,000 0

N I% PV PMT FV

Solve for 6,469.82

Arturo would receive annual payments of $6,469.82

=====================================

Lecture Problem 10

If Arturo has $50,000 to invest in an investment that makes fixed monthly payments of $1,000, how many monthly payments will he receive if he receives his first fixed monthly payment today and his return is 1.0% per month?

Time

0

1

2

N – 2

N – 1

N

0y0m

0y1m

0y2m

Pmt #

1

2

3

N – 1

N

CF

1000

1000

1000

1000

1000

Investment value

50,000

The cash flows that Arturo expects to receive reflect an annuity due with $1,000 monthly payments. We want to find the number of annuity due payments that are necessary for the annuity due to have a present value of $50,000.

BEGIN Mode

Enter 1.0 -50,000 1,000 0

N I% PV PMT FV

Solve for 68.67

Arturo would receive 68.67 payments

==============================

Lecture Problem 11

What is the quarterly interest rate for Tony’s loan if he borrowed $5,400 today, he must make equal quarterly payments of $830, with the first quarterly payment due later today and the last quarterly payment due in 6 quarters?

Timeline tip for FNAN 303: the cash flows occur quarterly so the timeline period is a quarter

Time

0

1

2

3

4

5

6

7

Payment #

1

2

3

4

5

6

7

Regular payments

-$830

-$830

-$830

-$830

-$830

-$830

-$830

0

Present value

-$5,400

The payments associated with the loan reflect an annuity due with 7 regular cash flows of -$830 and a present value of -$5,400. Therefore, the quarterly rate can be found as the rate such that a 7-period annuity due with regular cash flows of -$830 for 7 periods has a present value of -$5,400.

BEGIN mode

Enter 7 5,400 -830 0

N I% PV PMT FV

Solve for 2.51

The interest rate for the loan is 2.51%

============================

Lecture Problem 12

In 5 years, Arturo expects to have $40,000 to invest in a security that will make fixed payments. What annual expected return does his investment need in order for him to receive $9,100 per year with the first fixed annual payment received in 6 years from today and the last annual payment in 12 years from today?

Timeline

Time

0

1

2

3

4

5

6

7

8

9

10

11

12

Re-time

0

1

2

3

4

5

6

7

Pmt #

1

2

3

4

5

6

7

Pmt amt

9,100

9,100

9,100

9,100

9,100

9,100

9,100

Inv val

40,000

We want to find the annual discount rate such that the present value of a 7-period ordinary annuity of 9,100 per year is $40,000. This is the appropriate approach because the annual payments start in 1 year (after the “re-timed” time 0) and end in 7 years (after the “re-timed” time 0), so there are 7 payments.

END Mode

Enter 7 -40,000 9,100 0

N I% PV PMT FV

Solve for 13.20

The investment must have an expected annual return of 13.20%

=================================

Lecture Problem 13-a

I Scream Ice Cream Company is analyzing several of its upcoming flavors. What is the value of peanut chocolate crunch if the discount rate is 6.2 percent and the flavor is expected to generate annual fixed cash flows forever with the first cash flow of $100,000 in 4 years?

The value can be found in 2 steps.

1) Find the value of the flavor as of one year before the first payment is made

2) Find the present value (as of today) of the flavor

Time

0

1

2

3

4

5

6

CF

0

0

0

0

100k

100k

100k

1) The first of an infinite series of fixed payments occurs in 4 years, so we can find the value of the flavor as of 3 years from now as a fixed perpetuity

PV3 = C4 / r

C4 = $100,000 r = .062

PV3 = 100,000 / .062 = 1,612,903

2) The value today of something worth 1,612,903 in 3 years can be found as

PV0 = PV3 / (1+r)3

PV3 = 1,612,903 r = .062

PV0 = 1,612,903 / (1.062)3 = $1,346,588

Mode is not relevant, since PMT = 0

Enter 3 6.2 0 1,612,903

N I% PV PMT FV

Solve for -1,346,588

The value of the flavor is $1,346,588

================================

Lecture Problem 13-b

What is the value of nougat swirl if the cost of capital is 7.2 percent and the flavor is expected to generate annual cash flows forever with the first cash flow of $90,000 in 5 years and all subsequent cash flows growing annually by 1.5 percent?

The value can be found in 2 steps.

1) Find the value of the flavor as of one year before the first payment is made

2) Find the present value (as of today) of the flavor

Time

0

1

2

3

4

5

6

7

CF

0

0

0

0

0

90k

90k × 1.015

90k × 1.0152

CF

0

0

0

0

0

90,000

91,350

92,720

1) The first of an infinite series of constantly growing payments occurs in 5 years, so we can find the value of the flavor as of 4 years from now as a perpetuity with constant growth

PV4 = C5 / (r – g)

C5 = $90,000 r = .072 g = .015

PV4 = 90,000 / (.072 – .015) = 90,000 / (.057) = 1,578,947

2) The value today of something worth 1,578,947 in 4 years can be found as

PV0 = PV4 / (1+r)4

PV4 = 1,578,947 r = .072

PV0 = 1,578,947 / (1.072)4 = $1,195,607

Mode is not relevant, since PMT = 0

Enter 4 7.2 0 1,578,947

N I% PV PMT FV

Solve for - 1,195,607

The value of the flavor is $1,195,607

===============================

Lecture Problem 13-c

I Scream Ice Cream Company is analyzing several of its upcoming flavors. What is the value of coffee toffee if the cost of capital is 8.0 percent and the flavor is expected to generate fixed annual cash flows of $250,000 with the first cash flow in 6 years and the last cash flow in 14 years?

The value can be found in 2 steps.

1) Find the value of the flavor as of one year before the first payment is made

2) Find the present value (as of today) of the flavor

Time

0

1

2

3

4

5

6

7

8

9

10

11

12

13

14

Pmt #

1

2

3

4

5

6

7

8

9

CF

0

0

0

0

0

0

250k

250k

250k

250k

250k

250k

250k

250k

250k

1) The first of a series of 9 fixed payments occurs in 6 years, so we can find the value of the flavor as of 5 years from now as an ordinary annuity with 9 payments of $250,000. The nine fixed payments occur in 6, 7, 8, 9, 10, 11, 12, 13, and 14 years from now.

END Mode

Enter 9 8 250,000 0

N I% PV PMT FV

Solve for -1,561,722

2) The value today of something worth 1,561,722 in 5 years can be found as

PV0 = PV5 / (1+r)5

PV5 = 1,561,722 r = .08

PV0 = 1,561,722 / (1.08)5 = $1,062,882

Mode is not relevant, since PMT = 0

Enter 5 8 0 1,561,722

N I% PV PMT FV

Solve for -1,062,882

The value of the flavor is $1,062,882

1