Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Using Spreadsheet 21.10, assess the present value of a 1% increase in college tuition as a fraction of the present value of labor income.

Short Answer

Expert verified

a. PV (Labour income)= 2010917.42

PV (College tuition) = 167741.16

PV (College tuition) / PV (Labour income) = 8.34%

b. PV (Labour income)= 2010917.42

PV (College tuition) = 169418.58

PV (College tuition) / PV (Labour income) = 8.42%

Step by step solution

01

Definition of labour income

The income earned by employed people is known as labour income.

02

Calculation of PV and PV with 1% increase in tution

Retirement Years

Income growth

Rate of inflation

Savings rate

ROR

Extra costs

25

0.07

0.03

0.15

0.06

0.0291

40000

Age

Income

Defactor

Savings

Cumulative savings

rConsumption

Expenditures

30

50,000

1.00

7,500.00

7,500

42500

0

31

53,500

1.03

8,025.00

15,975

44150

0

35

70,128

1.16

10,519.00

61,658

51419

0

45

1,37,952

1.56

20,693.00

3,08,859

75264

0

48

1,68,997

1.70

25,349.00

3,75,099

84378

68,097

49

1,80,826

1.75

27,124.00

3,54,588

87654

70,140

50

1,93,484

1.81

29,023.00

2,60,397

91,058

144489

51

2,07,028

1.86

31,054.00

1,58,252

94595

148824

52

2,21,520

1.92

33,228.00

1,24,331

98268

76644

53

2,37,026

1.97

35,554.00

88,401

102084

78943

54

2,53,618

2.03

38,043.00

1,31,748

106049

0

55

2,71,372

2.09

40,706.00

1,80,359

110167

0

65

5,33,829

2.81

80,074.00

10,90,888

161257

0




11,16,851.00


Real Annuity

22048

PV (Labour income)= 2010917.42

PV (College tuition) = 167741.16

PV (College tuition) / PV (Labour income) = 8.34%

Retirement Years

Income growth

Rate of inflation

Savings rate

ROR

Extra costs

25

0.07

0.03

0.15

0.06

0.0291

40000

Age

Income

Defactor

Savings

Cumulative savings

rConsumption

Expenditures

30

50,000

1.00

7,500.00

7,500

42500

0

31

53,500

1.03

8,025.00

15,975

44150

0

35

70,128

1.16

10,519.00

61,658

51419

0

45

1,37,952

1.56

20,693.00

3,08,859

75264

0

48

1,68,997

1.70

25,349.00

3,74,418

84378

68,097

49

1,80,826

1.75

27,124.00

3,53,165

87654

70,140

50

1,93,484

1.81

29,023.00

2,57,444

91,058

145934

51

2,07,028

1.86

31,054.00

1,53,633

94595

150312

52

2,21,520

1.92

33,228.00

1,18,688

98268

77411

53

2,37,026

1.97

35,554.00

81,609

102084

79733

54

2,53,618

2.03

38,043.00

1,24,549

106049

0

55

2,71,372

2.09

40,706.00

1,72,727

110167

0

65

5,33,829

2.81

80,074.00

10,77,222

161257

0




11,16,851.00


21771

PV (Labour income) = 2010917.42

PV (College tuition) = 169418.58

PV (College tuition) / PV (Labour income) = 8.42%

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

A hedge fund with $1 billion of assets charges a management fee of 2% and an incentive fee of 20% of returns over a money market rate, which currently is 5%. Calculate total fees, both in dollars and as a percent of assets under management, for portfolio returns of:

a. 2 5%

b. 0

c. 5%

d. 10%

Use the following information to answer Problems l2–16:

Primo Management Co. is looking at how best to evaluate the performance of its managers. Primo has been hearing more and more about benchmark portfolios and is interested in trying this approach. As such, the company hired Sally Jones, CFA, as a consultant to educate the managers on thebest methods for constructing a benchmark portfolio, how best to choose a benchmark, whether the style of the fund under management matters, and what they should do with their global funds in terms of benchmarking.

For the sake of discussion, Jones put together some comparative two-year performance numbers that relate to Primo’s current domestic funds under management and a potential benchmark.

As part of her analysis, Jones also takes a look at one of Primo’s global funds. In this particular portfolio, Primo is invested 75% in Dutch stocks and 25% in British stocks.

The benchmark invested 50% in each—Dutch and British stocks. On average, the British stocks outperformed the Dutch stocks. The euro appreciated 6% versus the U.S. dollar over the holding period, while the pound depreciated 2% versus the dollar. In terms of the local return, Primo outperformed the benchmark with the Dutch investments but underperformed the index with respect to the British stocks.

Question: Calculate the amount by which the Primo portfolio out- (or under-) performed the market over the period, as well as the contribution to performance of the pure sector allocation and security selection decisions.

a. Suppose the spot price of the British pound is currently $1.50. If the risk-free interest rate on one-year government bonds is 4% in the United States and 3% in the United Kingdom, what must the forward price of the pound be for delivery one year from now?

b. How could an investor make risk-free arbitrage profits if the forward price were higher than the price you gave in answer to ( a )? Give a numerical example.

Use the following information to answer Problems l2–16:

Primo Management Co. is looking at how best to evaluate the performance of its managers. Primo has been hearing more and more about benchmark portfolios and is interested in trying this approach. As such, the company hired Sally Jones, CFA, as a consultant to educate the managers on thebest methods for constructing a benchmark portfolio, how best to choose a benchmark, whether the style of the fund under management matters, and what they should do with their global funds in terms of benchmarking.

For the sake of discussion, Jones put together some comparative two-year performance numbers that relate to Primo’s current domestic funds under management and a potential benchmark.

As part of her analysis, Jones also takes a look at one of Primo’s global funds. In this particular portfolio, Primo is invested 75% in Dutch stocks and 25% in British stocks.

The benchmark invested 50% in each—Dutch and British stocks. On average, the British stocks outperformed the Dutch stocks. The euro appreciated 6% versus the U.S. dollar over the holding period, while the pound depreciated 2% versus the dollar. In terms of the local return, Primo outperformed the benchmark with the Dutch investments but underperformed the index with respect to the British stocks.

Question: What is the within-sector selection effect for each individual sector?

Use the following information to answer Problems l2–16:

Primo Management Co. is looking at how best to evaluate the performance of its managers. Primo has been hearing more and more about benchmark portfolios and is interested in trying this approach. As such, the company hired Sally Jones, CFA, as a consultant to educate the managers on thebest methods for constructing a benchmark portfolio, how best to choose a benchmark, whether the style of the fund under management matters, and what they should do with their global funds in terms of benchmarking.

For the sake of discussion, Jones put together some comparative two-year performance numbers that relate to Primo’s current domestic funds under management and a potential benchmark.

As part of her analysis, Jones also takes a look at one of Primo’s global funds. In this particular portfolio, Primo is invested 75% in Dutch stocks and 25% in British stocks.

The benchmark invested 50% in each—Dutch and British stocks. On average, the British stocks outperformed the Dutch stocks. The euro appreciated 6% versus the U.S. dollar over the holding period, while the pound depreciated 2% versus the dollar. In terms of the local return, Primo outperformed the benchmark with the Dutch investments but underperformed the index with respect to the British stocks.

Question: If Primo decides to use return-based style analysis, will the R2 of the regression equation of a passively managed fund be higher or lower than that of an actively managed fund?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free