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:

  1. Analyze John's Net Worth statement and provide your comments. (3 marks)
  2. Analyze John's Cash Flow statement and provide your comments. (3 marks)
  3. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!