| Jian Ruan's Expenese |
Home | Syllabus | Access | Excel | Visual Basic | Research
Excel
|
|||||||||
| Six-Month Financial Projection | 4/9/2007 | ||||||||
| July | August | September | October | November | December | Total | |||
| Monthly Gross Income | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $2,500.00 | $8,750.00 | ||
| Expenses | |||||||||
| Food | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 900.00 | ||
| Rent | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 1,800.00 | ||
| Gas | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 900.00 | ||
| Car Maintenance | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 120.00 | ||
| Car Insurance | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 300.00 | ||
| Cell Phone | $ 48.00 | $ 48.00 | $ 48.00 | $ 48.00 | $ 48.00 | $ 48.00 | $ 288.00 | ||
| Clothing | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 200.00 | $ 600.00 | $ 1,600.00 | ||
| Total Expenses | $ 918.00 | $ 918.00 | $ 918.00 | $ 918.00 | $ 918.00 | $ 1,318.00 | $ 5,908.00 | ||
| Monthly Savings | $ 332.00 | $ 332.00 | $ 332.00 | $ 332.00 | $ 332.00 | $ 1,182.00 | $ 2,842.00 | ||
| Expenses Pie | |||||||||
|
|
|||||||||