You are a financial planner working for Personal Finance, Inc. in Boise, Idaho. The owner of the company, Andrew Burke, has asked you to meet with John and Mary Smith to discuss their financial plans and needs and provide a financial plan for them. Andrew would like to discuss the report with you prior to presenting it to John and Mary. Andrew strongly believes that personal debt is a burden and should be paid off as soon as possible, allowing individuals more financial independence.

You met with John and Mary at the beginning of June 2018 to gather their information. By the end of 2018, both John and Mary will be 30 years old. Further, they were expecting their first child to be born in the latter half of December 2018.

John and Mary are both employed and their pre-tax annual income is $75,000 and $60,000, respectively.The Smiths income tax rate is 28%. They still owe student loans of $18,000; the annual interest rate on the loans is 4.00% and there are 24 monthly payments remaining. In addition, John and Mary have a consumer loan of $7,000 which carries an annual interest rate of 4.25% and it has 24 monthly payments remaining. Finally, due to their liberal spending John and Mary have amassed an unpaid credit card balance of $20,000. The annual interest rate on their credit card loan is 16.99% and they just make the minimum monthly required payment which is 2% of the balance currently owed.

When you inquired, John and Mary told you that they currently rent a nice apartment for $1,300 a month. However, they would like to explore the possibility of buying their own house as soon as possible after their child is born. Actually, they have already looked around and houses they liked in their area sell for $190,000. You told them that to get a mortgage loan to buy the house, the down payment is 10% of the house price, while the closing costs are 2% of the loan amount. In light of the information you provided, they indicated that, since they have no savings currently, they would like to save the money required for the down payment and the closing costs during 2019 and then buy their house at the beginning of 2020. You also indicated to them that 30-year mortgage loans carry a 4.55% annual interest rate and require monthly payments. At the same time, you explained to John and Mary that they can put the money they will be saving in 2019 towards the down payment and the closing costs in an interest earning account.

John and Mary also wanted to know about saving money for their childs college education. Youexplained to them that currently the average annual cost of college is $35,000, increases by 4% each year, and college lasts for four years. As you told them, the good thing is that if they start saving once their child is born they will have 18 years to save the money needed for college.

Lastly, when you asked, John and Mary said they want to retire when they turn 65 and have enough savings by then to last them until they turn 80. After that who knows, they said! However, theyindicated that during their retirement they would like to have as much of a real after-tax annual income as they currently have.

Once you collected the above information, you agreed that you will meet with the Smiths in two weeks to explain to them your recommendations.

In preparing your report, you had to make the following simplifying assumptions:

Rent is paid at the end of each month

Payments on the mortgage loan, the credit card loan, consumer loan, and student loan take place

at the end of each month

Savings for the house down payment and closing costs, the childs college education cost, and

retirement accrue at the end of each month

The childs college tuition is due at the beginning of each of the four years

Annual income is due at the end of each retirement year

Then, you:

1- Calculated the monthly payments the Smiths currently make on the credit card loan, the consumer

loan, and the student loan, as well as the monthly after-tax amount of money they have left over

after they make these payments and also pay their rent.

2- Calculated the amount of money the Smiths have to deposit each month in their childs college

fund account; deposits start on January 31, 2019, end on the childs eighteenth birthday month,

and you estimated the annual interest rate on their savings to be 5%.

3-Calculated the amount of money the Smiths have to save each month in 2019 to have enough

money by December 31, 2019 to cover the down payment and the closing costs for their new

house; you estimated the annual interest rate on their savings to be 2%.

4- Calculated the monthly payment on the 30-year mortgage loan the Smiths will take for their new

house; payments start January 31, 2020.

5-Prepared an amortization schedule for the first year of the mortgage loan.

6- Calculated how long it will take the Smiths to pay off their credit card loan if they continued

paying the minimum required payment (recall this payment is 2% of their $20,000 credit card

loan) and the total interest they will pay on this credit card loan.

7-Calculated the amount of money the Smiths should save each month (starting January 31, 2019)

towards their retirement goal; you estimated the annual inflation rate to be 2% and the annual

interest on their savings to be 5% between now and the time the Smiths turn 80.

Once you were done with your calculations, you met with Andrew to discuss your findings and propose a plan for the Smiths. Andrew agreed that all these calculations were necessary but he raised a major concern. Specifically, he thought that, if they continue making the minimum required payment, it will take too long for the Smiths to pay off their credit card loan and, since the rate on this loan is very high, they will end up paying too much in interest. So, he suggested that in your final plan you make sure that the Smiths pay off their credit card loan in the next six months; i.e., between July 2018 and December 2018. Although this will require higher payments in these six months, Andrew indicated, it will make it much easier for the Smiths to reach the rest of their financial goals.

Based on your findings and Andrews input: 8. Prepare a detailed financial plan for the Smiths showing their monthly after-tax income and

monthly savings/payments they have to make in the next 25 months (starting July 31, 2018) to reach their financial goals. Be specific. Also, write a report explaining your recommendations to John and Mary Smith.