# Bill the Spender

Good Essays
1231 Words
Grammar
Plagiarism
Writing
Score
Bill the Spender
Cases

Each student must turn in any two of the four cases.

The due date for each case is different. For whichever cases you select, submit your answers on paper (an Excel printout is fine) by the due date. Also be prepared to explain your answer to the case for the class on the evening of the due date (after the lecture). Bring your Excel file to class on a flash drive or laptop.

Case 1 – Time Value of Money
Due Date: 2/13/2013

There are two people: Joe Spender and Bill Saver. Both have just turned 24 years old. Neither has any savings.

Both have just finished college and are starting their first job, making \$41,000 each. For simplicity, assume their salaries remain the same throughout their careers. Also assume that there are no taxes.

Both will retire at age 68, at the end of the year, and both will earn 6.25% annually (at the end of each year) on their investments (i.e., savings).

Joe saves nothing every year. That is, he spends all of his income.

Bill saves and invests 3/8 of his income every year. Income is defined as salary + earnings on investments. Assume that he invests at the end of each year (no interest is earned in the first year working).

By the time they retire, which person will have spent more?

At what age are they spending the same amount annually (round your answer)?

At what age will they have spent the same amount cumulatively (round your answer)?

How much does each have in the account at retirement?

Case 2 – Portfolio Theory
Due Date 3/6/2013

You are a financial advisor. The following clients come to you for advice:

Josephine
Josephine has just landed her first job out of graduate school. She is working for one of the Big Four, earning \$50,000 per year. She expects her salary to increase by 3% each year. Josephine has a goal of retiring after 36 years and then traveling the world in retirement for 20 years. Once she retires she will move all of her assets into Treasury

## You May Also Find These Documents Helpful

• Good Essays

3. George is 45 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 15 years so that he can retire at age 60. He expects to live to the maximum age of 85 and wants to be able to withdraw \$35,000 per year from the account on his 61st through 85th birthdays. The account is expected to earn 9% per annum for the entire period of time. Determine the size of the annual deposits that must be made by George. (Points : 3.71)…

• 2078 Words
• 9 Pages
Good Essays
• Good Essays

Make a list of your living expenses and try to estimate monthly expenses. Does Joe have enough left over to live comfortably if he buys the house? Should he go with the 15 or the 30-year…

• 704 Words
• 3 Pages
Good Essays
• Good Essays

Look for an annuity that will be equal to \$26,103.01 in present value. Let S be the unknown amount of fixed annual savings.…

• 1422 Words
• 7 Pages
Good Essays
• Better Essays

d. If you can earn 9% per year, how much will you have to save each year if you want to retire in 40 years with \$3 million?…

• 1085 Words
• 4 Pages
Better Essays
• Satisfactory Essays

Today is your birthday and you are now 37! You are planning your retirement and have decided that you can save \$8,000.00 per year to go toward your retirement. The plan is to make your first deposit one year from today. You found a mutual fund that is expected to provide a return of 7.5% per year. You plan to retire at the age of 65, exactly 28 years from today. It is your expectation that you will live for 25 years after your retirement. Under these assumptions, how much can you spend each year after you retire? Your first withdrawal will be made at the end of your first retirement year.…

• 278 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

Clarence Weather spoon, a super salesman contemplating retirement on his fifty-fifth birthday, decides to create a fund on an 9% basis that will enable him to withdraw \$31,400 per year on June 30, beginning in 2018 and continuing through 2021. To develop this fund, Clarence intends to make equal contributions on June 30 of each of the years 2014–2017. How…

• 1181 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

for 22 years. How much will he have after 22 years, if the interest rate is 2.85%,…

• 1243 Words
• 5 Pages
Satisfactory Essays
• Satisfactory Essays

• 758 Words
• 6 Pages
Satisfactory Essays
• Good Essays

Q23: Calculating Annuities You are planning to save for retirement over the next 30 years. To do this, you will invest \$700 a month in a stock account and \$300 a month in a bond account. The return of the stock account is expected to be 10 percent, and the bond account will pay 6 percent. When you retire, you will combine your money into an account with an 8 percent return. How much can you withdraw each month from your account assuming a 25-year withdrawal period?…

• 2329 Words
• 10 Pages
Good Essays
• Good Essays

In conclusion, the monthly cost of them is exceeds their monthly income, so they need to do some exchange to improve their financial situation.…

• 1002 Words
• 5 Pages
Good Essays
• Good Essays

A wedding is also in her plans. Emily and her boyfriend, Paul, have set a wedding date two years in the future, after he finishes medical school. In addition, Emily and Paul want to buy a home of their own in 5 years. This might be possible because two years later, Emily will be eligible to access a trust fund left to her as an inheritance by her late grandfather. Her trust fund has\$80,000 invested at an interest rate of 5%.…

• 1238 Words
• 6 Pages
Good Essays
• Satisfactory Essays

Rodriguez operates a variety store that provides an annual revenue of \$480 000. Each year, he pays \$25 000 in rent for the store, \$15 000 in business taxes, and \$350 000 on products to sell. He estimates he could put the \$80 000 he has invested in the store into his friend’s restaurant business instead and earn an annual 20 percent profit on his funds. He also estimates that he and his family could earn a total annual wage of \$90 000 if they worked somewhere other than the store.…

• 362 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

Sunrise Industries wishes to accumulate funds to provide a retirement annuity for its vice president of research, Jill Moran. Ms. Moran, by contract, will retire at the end of exactly 12 years. Upon retirement, she is entitled to receive an annual end-of-year payment of \$42,000 for exactly 20 years. If she dies prior to the end of the 20-year period, the annual payments will pass to her heirs. During the 12-year “accumulation period,” Sunrise wishes to the fund the annuity by making equal, annual, end-of-year deposits into an account earning 9% interest. Once the 20-year “distribution period” begins, Sunrise plans to move the accumulated monies into an account earning a guaranteed 12% per year. At the end of the distribution period, the account balance will equal zero. Not thate the first deposit will be made at the end of year 1 and that the first distribution payment will be received at the end of year 13.…

• 453 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

Calculating Annuity Values Bilbo Baggins wants to save money to meet three objectives. First, he would like to be able to retire 30 years from now with retirement income of \$20,000 per month for 20 years, with the first payment received 30 years and 1 month from now. Second, he would like to purchase a cabin in Rivendell in 10 years at an estimated cost of \$325,000. Third, after he passes on at the end of the 20 years of withdrawals, he would like to leave an inheritance of \$750,000 to his nephew Frodo. He can afford to save \$2,000 per month for the next 10 years. If he can earn an 11 percent EAR before he retires and an 8 percent EAR after he retires, how much will he have to save each month in years 11 through 30?…

• 1454 Words
• 6 Pages
Satisfactory Essays
• Satisfactory Essays

(5 points) Dominique has just turned 65 and she has deposited her annual payment of \$20,000 into her retirement account. She made her first such saving deposit into this fund on her 35th birthday. Dominique has also retired and wants to figure out how much money she has in her retirement account for her retired life. You are Dominique's friend who knows finance. How much is Dominique's savings worth today given that the fund has earned an annual return of 5.5%? (Enter just the number without the \$…

• 1414 Words
• 6 Pages
Satisfactory Essays