Question

Option #1: Time Value of Money Personal Finance Application

Your friend Sue has asked you to help her out as she is developing her financial plan. Help her come up with a plan for her finances and how she can set herself up for financial success!

She has an after tax income of $48,000 and budgets $30,000 for necessary expenses. This leaves $18,000 to spend on debt and savings annually. (Assume all annuity payments are in the form of ordinary annuities.)

Part A: Debt

1. Sue has a current balance of $20,000 on her credit card. She has a minimum monthly payment of $500 and an APR of 17.25% (divide by 12 to get the monthly rate). How many months will it take Sue to pay off her credit card debt?

2. Suppose Sue would like to purchase a new car. She believes she can spend $550 a month on a car. She has been approved for a 4.50% loan (divide by 12 for monthly rate) for 36 months. What is the maximum amount she can spend on a car as not to exceed her $550 a month budget?

Part B: Savings

1. Sue would like to save up for a down payment on a home she hopes to purchase in 5 years. If she wishes to have $20,000 saved up at the end of five years and can earn 3.5% annually in her savings account. If she would like to make equal annual deposits, what amount will her deposits need to be in order to reach her goal?

2. Sue received $20,000 as an inheritance from her uncle. He stipulated that she save this money for her 2 children's college education. She would like to have $50,000 saved up in 10 years. What annual interest must she earn in order to reach this goal (she will make no additional deposits to this account)?

Part C: Offering Advice

1. Calculate the total annual amount of debt and savings payments Sue has planned in the scenarios above.

2. If she has any of her $18,000 remaining after her credit card, auto loan, and savings are made offer advise on how this should be divided (make more than the minimum payments or make additional deposits to savings). Be sure to offer reasons on why she should choose to follow your advice rather than spend the cash.

Submit your 3 to 4 page paper in a Word document, showing all of your calculations (attach Excel File if necessary) with a minimum of four references (at least 2 scholarly/peer reviewed).

Answer 1

Part A

1.

Interest	17.25
Periodic Payments	500
Future Value	20000
Number of periods
NPER(17.25/12,500,0,20000,0)

NPER = 4.56Years = 54Months

2.

Periodic savings(PMT)	550
Interest	4.50%
Months	36
Value after 3 years	FV(4.5%/12,36,-550,0,1) = $21,235.69

Maximum amount she can spend is 21235$

Savings

3.

Interest	3.50%
Tenure	5
Future Value	20000
Periodic Payments needed	($3,603.50)
	pmt(3.5%,5,0,20000,1)

Sue need to save an amount of 3603 Per annum for 5 years to reach her goals

4.

Present value received	20000
Future value required	50000
Tenure	10years
Interest Rate	RATE(10,0,-20000,50000,1)

She needs to invest in a asset class which gives return of 10%

C. Advice

5.

Savings	Amount	Debt	Amount
Car	550 Per Month	Credit card	500 Per month
Inherited amount	20000 One time
Home goals	3600 Per Annum