perpare a personal cash flow statement

Family friend, Todd Church, has asked you to help him gain control of his personal finances. Single and 35 years old, Todd is employed as a salesperson for a technology company here in Winnipeg, Manitoba. His job allows him to mostly work from home. His annual salary is $93600. He has payroll deductions for El and CPP contributions, and income taxes. Todd also recently moved from his cramped one-bedroom apartment with rent of $1,250 per month to a purchased two-bedroom condominium valued at $275,000 and a current mortgage balance of $220,000, at 4% interest, with blended mortgage payments of $2,050. Utilities and property taxes are included in the monthly condo fees. Todd needed the extra space so he could have a home office space for his work on-line. The condo is in an executive community with access to two golf courses, a lake, and an activity/fitness centre. Todd currently owns a car valued at $21000 with an outstanding car loan balance of $18,000 (the car loan has a low dealer incentive interest rate at 1.5% which means there is about 21 months remaining on the car loan). The car will have a residual value of $10,000 once the loan is paid off and will likely cost an additional $300 per month to maintain by the time the car loan is paid off. FNCE-1016 Case Details February 2021 After having reviewed his other monthly expenses since the move, you have uncovered the following: Todd is surprised by how much money he spends monthly on clothes ($150) and entertainment ($450). He uses his credit card for these purchases (the credit card balance is $6,500 and climbing) but has little trouble making the required minimum monthly payment. He would, however, like to gain control over his finances and see the balance on all his debts go down, and/eventually pay his credit card off completely. Todd's other goal is to save $400 a month so that he can retire 20 years from now at 55 . He would like to start saving in five years, so he can pay off his credit card and car loan first. He does not think the delay will affect the final amount of retirement savings he will accumulate. Todd currently has about $1,000 in his chequing account and $500 in his savings account. He has furniture valued at $3,950 and owns 600 shares of an internet stock, currently valued at $1,800, which Todd believes has the potential to make him rich. Family friend, Todd Church, has asked you to help him gain control of his personal finances. Single and 35 years old, Todd is employed as a salesperson for a technology company here in Winnipeg, Manitoba. His job allows him to mostly work from home. His annual salary is $93600. He has payroll deductions for El and CPP contributions, and income taxes. Todd also recently moved from his cramped one-bedroom apartment with rent of $1,250 per month to a purchased two-bedroom condominium valued at $275,000 and a current mortgage balance of $220,000, at 4% interest, with blended mortgage payments of $2,050. Utilities and property taxes are included in the monthly condo fees. Todd needed the extra space so he could have a home office space for his work on-line. The condo is in an executive community with access to two golf courses, a lake, and an activity/fitness centre. Todd currently owns a car valued at $21000 with an outstanding car loan balance of $18,000 (the car loan has a low dealer incentive interest rate at 1.5% which means there is about 21 months remaining on the car loan). The car will have a residual value of $10,000 once the loan is paid off and will likely cost an additional $300 per month to maintain by the time the car loan is paid off. FNCE-1016 Case Details February 2021 After having reviewed his other monthly expenses since the move, you have uncovered the following: Todd is surprised by how much money he spends monthly on clothes ($150) and entertainment ($450). He uses his credit card for these purchases (the credit card balance is $6,500 and climbing) but has little trouble making the required minimum monthly payment. He would, however, like to gain control over his finances and see the balance on all his debts go down, and/eventually pay his credit card off completely. Todd's other goal is to save $400 a month so that he can retire 20 years from now at 55 . He would like to start saving in five years, so he can pay off his credit card and car loan first. He does not think the delay will affect the final amount of retirement savings he will accumulate. Todd currently has about $1,000 in his chequing account and $500 in his savings account. He has furniture valued at $3,950 and owns 600 shares of an internet stock, currently valued at $1,800, which Todd believes has the potential to make him rich