Module 03 Written Assignment - Formulas, Functions, and Formatting
Gladiola
PersonalBudgetWorkbook.xlsx
Sheet1
| | January | February | March | April | May | June | July | August | September | October | November | December |
| Income |
| Salary | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 |
| Total | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 | $1,500.00 |
| Expenditure |
| Rent | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 | $300.00 |
| Cable | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 | $60.50 |
| Internet | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 | $18.00 |
| Phone | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 | $30.50 |
| Electricity | $25.30 | $25.30 | $40.00 | $25.30 | $25.30 | $25.30 | $25.30 | $25.30 | $25.30 | $25.30 | $25.30 | $25.30 |
| Shopping | $140.50 | $140.50 | $140.50 | $180.00 | $140.50 | $140.50 | $140.50 | $140.50 | $140.50 | $140.50 | $140.50 | $250.00 |
| Leisure | $45.00 | $45.00 | $45.00 | $45.00 | $90.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 | $45.00 |
| Savings | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 | $200.00 |
| Retirement | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 |
| Total | $919.80 | $919.80 | $934.50 | $959.30 | $964.80 | $919.80 | $919.80 | $919.80 | $919.80 | $919.80 | $919.80 | $1,029.30 |
| Net Income/Loss | $580.20 | $580.20 | $565.50 | $540.70 | $535.20 | $580.20 | $580.20 | $580.20 | $580.20 | $580.20 | $580.20 | $470.70 |
Sheet2
| | November | December |
| Income |
| Salary | $1,500.00 | $1,500.00 |
| Total | $1,500.00 | $1,500.00 |
| Expenditure |
| Rent | $300.00 | $300.00 |
| Cable | $60.50 | $60.50 |
| Iternet | $18.00 | $18.00 |
| Phone | $30.50 | $30.50 |
| Electricity | $25.30 | $25.30 |
| Shopping | $140.50 | $250.00 |
| Leisure | $45.00 | $45.00 |
| Savings | $200.00 | $200.00 |
| Retirement | $100.00 | $100.00 |
| Total | $919.80 | $1,029.30 |
| Net Income/Loss | $580.20 | $470.70 |
