C70_Chapter4_Problem1_Cragos_Spreadsheet

C70_Chapter4_Problem1_Cragos_Spreadsheet - 2004 and 2005...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
2004 and 2005 Income Statement and Monthly Cash Budget for the Cragos 2005 2004 Jan. Feb Mar Apr May June July Aug Sept Oct Nov Dec 2005 INCOME Vincent 35655.62 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 3030.73 36368.76 Anne 13000 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 1083.33 12999.96 Dividends 750 62.5 62.5 62.5 62.5 62.5 62.5 62.5 62.5 62.5 62.5 62.5 62.5 750 Interest 765 63.75 63.75 63.75 63.75 63.75 63.75 63.75 63.75 63.75 63.75 63.75 63.75 765 CSB plan 1000 1000 1000 Other 20000 20000 51170.62 4240.31 4240.31 4240.31 4240.31 4240.31 4240.31 4240.31 4240.31 24240.31 4240.31 5240.31 4240.31 71883.72 EXPENSES Mortgage 11986.8 998.9 998.9 998.9 998.9 998.9 998.9 998.9 998.9 998.9 998.9 998.9 998.9 11986.8 Gas 1200 102 102 102 102 102 102 102 102 102 102 102 102 1224 Telephone 960 81.6 81.6 81.6 81.6 81.6 81.6 81.6 81.6 81.6 81.6 81.6 81.6 979.2 Hydro 600 102 102 102 102 102 102 612 Water 300
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 07/20/2011 for the course MGMT 70 taught by Professor Ahmed during the Spring '11 term at University of Toronto.

Ask a homework question - tutors are online