finance QA

profileMr.Q
part_2.xlsx

Sheet1

Coli & Jill's Balance Sheet
Assets Liabilities
Curent Assets Current Liabilities
Bank Account( Joint) $3,400.00 Visa Card -joint $4,700.00
Total current assets $3,400.00 Total current liabilities $4,700.00
Household Assets Long-Term Liabilities
Coli-2014 Dodge Ram $21,995.00 House Mortgage $1,904.43
Jill-2015 Mazda 3 $20,495.00 Mazda Loan $268.86
Possessions in the house $25,000.00 Dodge Loan $237.08
House $475,000.00 Home Morgage $300,000.00
Total household assets $542,490.00 Total long-term liabilities $302,410.37
Investment assets
Jill Group RRSP $15,000.00
Jill personal RRSP $12,500.00
Jill Personal TFSAs $3,500.00
Colin RRSP $31,200.00
Colin TFSAs $7,900.00
Total investment assets $70,100.00
Total Assets $615,990.00 Total Liabilities $307,110.37
Net Worth $308,879.63
Current Ratio: 0.72
Debt to Asset Ratio: 0.0115 Quick Ratio 1.468