Please could somebody fill in this excel spread sheet as much as they can using the information given below. I need the cash inflows part filled in. aswell as the total available cash flows. and total lifesryle expenes and debt payments. or just one or 2 sections of the spread sheet. Thank you

During your first meeting with John and emily, you promised them a full analysis of their cash flows, assets vs. liabilities, and taxes. To accomplish this task, you took notes during your first meeting with the clients; the notes are summarized below:

Done

• John an oil and gas engineer, age 37
• Emily an administrative assistant at an oil and gas company, age 37 Education loan balance $12,322 (John)
• The couple doesn't have any kids.
• Groceries $700 Gas $400
• Monthly mortgage payments $3,789
• Cash in a chequing account $1,500

(Emily)

• They purchased their home for $300,000 around six years ago, now the house price is $400,000. The house is owned jointly
• Credit card limit $42,000 / balance

$12,000 (Emily)

• Their mortgage original balance was $230,000, the current balance is $150,000.
• John contributes monthly $300 to his

TFSA account

• Cash in chequing account $2,000 (John)
• Educational Loans repayment John $500, and Lana $400 per month.
• Other variable expenses around $700 per month on average.
• Educational loan balance $15,500 (Emily)
• Credit card limit $40,000 / Balance $3,000

(John)

Emily contributes $400 monthly to her

RRSP account

• Emily drives a Honda civic, she purchased the car for $20,000, the car current value is $13,000.
• Emily has RRSP investments of $44,000.
• Joint Saving account balance $23,000
• The monthly electricity bill is $200
• John drives a Ford F150 which he purchased for $60,000, around 3 years ago, the car current value is $22,000
  • John inherited a cabin from his grandparents the cabin estimated market value is $40,000.
  • They recently fully paid off their auto loans.
  • They spend $300 on entertainment monthly
  • Their house holds possessions were $20,000. together, and are valued at
  • They spend $40 on movies each month
  • John has TFSA investments valued

  $50,000

  • Emily earns $60,000 pre-tax. Her CPP/EI/ income taxes are $15,000 per year (note: these amounts include any available tax credits/deductions).
  • They donate $50 to their favorite charity monthly
  • They spend $200 on travel monthly
  • Emily owns jewelry valued $3,245
  • They pay $500 for their cars and house insurance monthly
  • Emily and John each pay $300 monthly on their credit cards
  • They pay for their term life insurance policies $140 each monthly
  • They have joint stock investments account which is valued $35,000.
  • John earns $150,000 pre-tax. He pays CPP/El/ income taxes of $45,000 per year (note: these amounts include any available tax credits/deductions).

CASHI INHOOWS H MULOMAENT INCOME sarye rotal Awatable Cash iollows CASHCUIFLOW' UFESTYUE EXPENSES Non dincretionory Experises (Fixed Expenses) \begin{tabular}{|c|c|} \hline Patio & Value \\ \hline Conario & \\ \hline Corter fiveo & +4 \\ \hline Lianduphe & \\ \hline & \\ \hline \end{tabular}