| Retirement Expense |
| Expenses |
| Housing | Annual | Monthly | Percentage |
| Home Insurance | $240.00 | $20.00 | 0.52% |
| Property Tax | $5,400.00 | $450.00 | 11.63% |
| Housing Maintain |
| House Repairing | $720.00 | $60.00 | 1.55% |
| Painting | $600.00 | $50.00 | 1.29% |
| Appliance | $1,200.00 | $100.00 | 2.59% |
| Utilities |
| Electricity /water | $1,200.00 | $100.00 | 2.59% |
| Gas | $960.00 | $80.00 | 2.07% |
| Internet&TV&homephone | $600.00 | $50.00 | 1.29% |
| Insurance |
| Individually life insurance | $840.00 | $70.00 | 1.81% |
| Coli-Disability Insurance | $1,034.28 | $86.19 | 2.23% |
| Coli-Supplemental Life Inc | $90.00 | $7.50 | 0.19% |
| Groceries and Food |
| Groceries | $18,000.00 | $1,500.00 | 38.78% |
| Eat-out | $600.00 | $50.00 | 1.29% |
| Daily drink/coffee | $720.00 | $60.00 | 1.55% |
| Transportation |
| Colin & Jill -car insurance | $1,200.00 | $100.00 | 2.59% |
| Gas | $960.00 | $80.00 | 2.07% |
| Maintenance | $240.00 | $20.00 | 0.52% |
| Parking | $120.00 | $10.00 | 0.26% |
| Vehicle licensing | $240.00 | $20.00 | 0.52% |
| Investment |
| Colin,RRSP | $3,600.00 | $300.00 | 7.76% |
| Jill, RRSP | $2,400.00 | $200.00 | 5.17% |
| Entertainment |
| Activities Tickets | $600.00 | $50.00 | 1.29% |
| Travel | $1,200.00 | $100.00 | 2.59% |
| Clothing |
| Clothes | $1,200.00 | $100.00 | 2.59% |
| Laundry cleaning | $180.00 | $15.00 | 0.39% |
| Medical |
| Medicines | $600.00 | $50.00 | 1.29% |
| Personl Care |
| Hairdresser/barbers | $300.00 | $25.00 | 0.65% |
| Other(face cleaner) | $168.00 | $14.00 | 0.36% |
| Gifts |
| Gifts | $1,200.00 | $100.00 | 2.59% |
| Total Expenses | $46,412.28 | $3,867.69 | 100.00% |
| Total after-tax retirement income=(46412.28-3600-10000)*(1-0.13)=$28546.68 |
Mr.Q
part_3.xlsx
