| Colin & Jill's Cash Flow Statement |
| Colin | | | Jill |
| Gross income | $100,000.00 | | Gross income | $25,000.00 | $2,083.33 |
| RRSP deduction | $3,600.00 | | RRSP deduction | $2,400.00 | $200.00 |
| RPP deduction | $10,000.00 | | RPP deduction | $1,250.00 | $104.17 |
| Taxable Income | $86,400.00 | | Taxable Income | $21,350.00 | $1,779.17 |
| Income Expenses | Annual | Monthly | Income Expenses | Annual | Monthly |
| Colin Income | | | Jill Income |
| Gross Income | $100,000.00 | $8,333.33 | Gross Income | $25,000.00 | $2,083.33 |
| Total tax deductions | $43,227.56 | $3,602.30 | Total tax decductions | $8,406.55 | $700.55 |
| CPP decductions | $2,544.30 | $212.03 | CPP decductions | $1,042.39 | $86.87 |
| EI deductions | $995.04 | $79.59 | EI deductions | $401.38 | $33.45 |
| Total income tax | $46,766.90 | $3,893.91 | Total income tax | $9,850.32 | $820.86 |
| Net Income | $53,233.10 | $4,436.09 | Net Income | $15,149.68 | $1,262.47 |
| | | | Total Net Income | $68,382.78 | $5,698.57 |
| Expenses | | | Percentage |
| Housing | Annual | Monthly | 29.29% |
| Mortgage | $22,770.84 | $1,897.57 | 0.31% |
| Home Insurance | $240.00 | $20.00 | 6.95% |
| Property Tax | $5,400.00 | $450.00 |
| Housing Maintain | | | 0.93% |
| House Repairing | $720.00 | $60.00 | 0.77% |
| Painting | $600.00 | $50.00 | 1.54% |
| Appliance | $1,200.00 | $100.00 |
| Utilities | | | 2.32% |
| Electricity /water | $1,800.00 | $150.00 | 1.23% |
| Gas | $960.00 | $80.00 | 1.54% |
| Internet&TV&homephone | $1,200.00 | $100.00 | 0.93% |
| Cellphone | $720.00 | $60.00 |
| Insurance | | | 1.08% |
| Individually life insurance | $840.00 | $70.00 | 1.33% |
| Coli-Disability Insurance | $1,034.28 | $86.19 | 0.12% |
| Coli-Supplemental Life Inc | $90.00 | $7.50 |
| Groceries and Food | | | 23.15% |
| Groceries | $18,000.00 | $1,500.00 | 1.54% |
| Eat-out | $1,200.00 | $100.00 | 0.77% |
| Take-out | $600.00 | $50.00 | 0.46% |
| Daily drink/coffee | $360.00 | $30.00 |
| Transportation | | | 1.85% |
| Colin-car insurance | $1,440.00 | $120.00 | 1.70% |
| Jill-Vehicle insurance | $1,320.00 | $110.00 | 1.85% |
| Gas | $1,440.00 | $120.00 | 0.31% |
| Maintenance | $240.00 | $20.00 | 0.15% |
| Parking | $120.00 | $10.00 | 3.66% |
| Dodge Ram Loan | $2,844.96 | $237.08 | 4.15% |
| Mazda 3 Loan | $3,226.32 | $268.86 | 0.23% |
| Parking | $180.00 | $15.00 | 0.31% |
| Vehicle licensing | $240.00 | $20.00 |
| Child care | | | 0.42% |
| Griffin ,Lacrosse | $324.00 | $27.00 | 0.46% |
| Toy | $360.00 | $30.00 |
| Investment | | | 4.63% |
| Colin,RRSP | $3,600.00 | $300.00 | 3.09% |
| Jill, RRSP | $2,400.00 | $200.00 |
| Entertainment | | | 0.15% |
| Alcohol | $120.00 | $10.00 | 0.46% |
| Activities Tickets | $360.00 | $30.00 | 0.15% |
| Travel | $120.00 | $10.00 |
| Clothing | | | 0.77% |
| Clothes | $600.00 | $50.00 | 0.23% |
| Laundry cleaning | $180.00 | $15.00 |
| Medical | | | 0.08% |
| Medicines | $60.00 | $5.00 |
| Personl Care | | | 0.39% |
| Hairdresser/barbers | $300.00 | $25.00 | 0.22% |
| Other(face cleaner) | $168.00 | $14.00 |
| Gifts | | | 0.46% |
| Gifts | $360.00 | $30.00 | 100.00% |
| Total Expenses | $77,738.40 | $6,478.20 |
| Net Cash Flows | ($9,355.62) | ($779.64) |
Mr.Q
part_one.xlsx
