Since all repayments are done on a monthly basis, it makes sense to adopt the month as Enrico’s unit of time. There are five categories for his cash flows: debt repayment, transportation costs, housing costs, other living expenses, and savings. The following paragraphs summarize his estimates of monthly expenses in each of these categories.
Debt Repayment
Enrico’s student loan debt is $20,000 and is to be repaid over the next 120 months (10 years) at a nominal interest rate of 8% compounded monthly (imonth =8/12%= 2/3%). His monthly loan payment is then
AStudent Loan =$20,000(A/P,2/3%,120)=$20,000(0.01213)=$242.60 per month.
Enrico’s credit card debt is $5,000 and is to be completely repaid over the next 120 months at a nominal interest rate of 18% compounded monthly (imonth =1.5%). His monthly credit card payment, assuming no additional usage, is then
ACredit Card =$5,000(A/P,1.5%,120)=$5,000(0.01802)=$90.10 per month.
Enrico’s monthly debt repayment totals $242.60+$90.10=$332.70.
Transportation Costs
The certified pre-owned vehicle Enrico would like to buy costs $15,000. The best rate he can find as a first-time car buyer with no assets or credit history is 9% compounded monthly with a 60 -month repayment period. Based on these figures, his monthly car payment will be
ACar =$15,000(A/P,0.75%,60)=$15,000(0.02076)=$311.40 per month .
Even though the car will be completely repaid after five years, Enrico knows that he will eventually need to replace the car. To accumulate funds for the replacement of the car, he wants to continue to set aside this amount each month for the second five years.
Insurance for this vehicle will cost $1,200 per year, and Enrico has budgeted $100 per month to cover fuel and maintenance. Thus, his monthly transportation costs total $311.40+$1,200/12+$100=$511.40.
Housing Costs
A nice two-bedroom apartment near Enrico’s place of work has a monthly rent of $800. The rental office provided him with a monthly utility cost estimate of $150 to cover water and electricity. Based on this information, $800+$150=$950 per month has been budgeted for his housing costs.
Other Living Expenses
This expense category has troubled Enrico the most. While all the previous categories are pretty straightforward, he knows that his day-to-day spending will have the most variability and that it will be tempting to overspend. Nonetheless, he has developed the following estimates of monthly living expenses not already covered in the other categories:
Food |
$200 |
Phone |
$70 |
Entertainment |
$100 |
Miscellaneous |
|
(clothing, household items) |
$150
|
Subtotal |
$520 |
Savings
Enrico wants to accumulate $40,000 over the next 10 years to be used as a down payment on a condo. He feels that if he chooses relatively “safe” investments (CDs and bonds), he should be able to earn 6% compounded monthly on his savings. He must then set aside
ACondo =$40,000(A/F,0.5%,120)=$40,000(0.00610)=$244.00 per month to reach his goal.
Enrico’s gross monthly starting salary is $48,000/12=$4,000. Based on the information gathered from his family, he estimates his monthly net (take home) pay to be $4,000(0.80)=$3,200. His monthly retirement savings will then be $3,200(0.10)=$320. Thus, the total amount to be set aside each month for the future is $244+$320=$564.
Monthly Financial Plan
Based on the preceding calculations, the following table summarizes Enrico’s monthly financial plan.
|
Net Income |
Expense |
Salary |
$3,200 |
|
Debt repayment |
|
$332.70 |
Transportation costs |
|
511.40 |
Housing costs |
|
950.00 |
Living expenses |
|
520.00 |
Savings |
|
564.00 |
Total |
$3,200 |
$2,878.10 |
Enrico is aware that he has not explicitly accounted for price increases over the next 10 years; however, neither has he increased his annual salary. He is hopeful that, if he works hard, his annual salary increases will at least cover the increase in the cost of living.
You congratulate your friend on his efforts. You feel that he has covered the major areas of expenses, as well as savings for the future. You note that he has $3,200−$2,878.10=$321.90 of “extra” money each month to cover unanticipated costs. With this much leeway, you feel that he should have no problem meeting his financial goals.