Question: You are working on completing your analysis for a new client, John Young. You have just finished preparing his Net Worth and Cash Flow Statements,
You are working on completing your analysis for a new client, John Young. You have just finished preparing his Net Worth and Cash Flow Statements, see below.
| John Young Net Worth Statement As of September 30, 2022 | |
| Assets: Liquid Assets Chequing Account Cashable GIC | $3,100 $5,000 |
Personal Possessions | $12,000 |
| Real Estate Assets House | $760,000 |
| Investment Assets RRSP Portfolio | $121,000 |
Total Assets | $901,100 |
| Liabilities: Current Liabilities Credit Card Balance | $9,000 |
| Long-term Liabilities Student loan Mortgage | $19,000 $331,000 |
Total Liabilities | $359,000 |
Net Worth | $542,100 |
| John Young Cash Flow Statement As of September 30, 2022 | |
| Inflows: Gross Income Less Deductions Income Tax $16,050.00 CPP Contribution $ 3,499.80 EI $ 952.74 Total Deductions $20,502.54 | $80,000 ($20,502.54) |
Net Income (Take Home Pay) | $59,497.46 |
Outflows: | |
| Fixed Expenses: Mortgage $18,000 Property Tax $ 4,000 Insurance $ 1,300 RRSP Contribution $ 3,600 Student Loan Payment $ 4,200 Credit Card Payment $ 2,400 Car Payment $ 4,800 Total Fixed Expenses $38,300 | |
| Variable Expenses: Heat $ 3,000 Utilities $ 7,000 Food $ 3,200 Clothing $ 1,800 Entertainment $ 7,200 Donations $ 1.200 Gifts $ 1,000 Total Variable Expenses $24,400 | |
Total Expenses | $62,700 |
Surplus/Deficit | ($3,202.54) |
Requirements:
- Analyze John's Net Worth statement and provide your comments. (3 marks)
- Analyze John's Cash Flow statement and provide your comments. (3 marks)
- Choose 3 ratios and complete the calculation, analyze the result and provide your comments.
Please help. ^^
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
