Activity #$3$: FNCE$-1016$ Chapters $1-3$

Planning with Personal Financial Statements

CLIENT

Bernard B$$langer has been working full$-$time for the last $4$ years. Last year, a close family friend, $$Aunt Maria$,$ suddenly passed away and left him an inheritance of $$75,000.$ Bernard used the money, as a down payment, to buy a townhouse at the end of $2021$ for $$375,000.$ He obtained a $4\mathrm{.}50\%$ rate $($compounded semi$-$annually$),$ makes monthly payments, and used a $25-$year amortization. The monthly blended mortgage payment is $$1,660\mathrm{.}42$ due at the end of each month. As of February $28$th$,2022$ Bernard has two months of accrued property taxes at $$300$ per month.

Currently his utility bills for the month are unpaid. His utility bills are on a monthly budget plan and Bernard set them up with automatic pre$-$authorized payments $($PAP$)$ from his chequing account on the $5$th of each month following. His $$2,400/$year car insurance and his house insurance are also paid using PAP in equal monthly installments on the first of each month. Although he is usually good at keeping receipts, he does have on average $$200$ miscellaneous cash withdrawals that he simply refers to as $$other$.$

With respect to debt, Bernard has two credit cards. He uses them for clothing, groceries and gas for his car and to collect travel points. Bernard pays them in full each month, usually around the $15$th of the month following, so as not to carry a balance. In addition to his credit cards and mortgage, he also has a car loan. Bernard has no student debt.

As far as the future, Bernard has a savings account with $$1,900$ in it that he uses for emergencies, and his vacation fund, and he has a chequing account with a current balance of $$925.$ There is an RRSP account at his bank and some stocks he purchased for long$-$term investment purposes that his Aunt Maria helped him establish over the past few years. Bernard currently takes home $$3,900$ every month.

Having Maria pass away started to make Bernard think about his future. Although he did graduate with a university degree, he does not have a high level of personal finance knowledge. He started to fill in a cash flow and net worth statement but needs your help to complete it$.$

Fill the yellow blanks