exercise 1,lab 1

# exercise 1,lab 1 - Income Pay \$50,000.00 \$50,000.00...

This preview shows pages 1–3. Sign up to view the full content.

Raafia Siddiqui 211098936 Comments Monthly Budgeting This model gives a depiction of how monthly expenses can be budgeted on Microsoft Excel. It provides information on monthly income and expenses, and independantly subtotal these values Finally, the spreadsheet calculates the monthly suprlus, or deficit. Firstly, information is filled into it's appropriate place. Each month has a separate column. The rows depict student income, expenses and finaly surplus. The total income/expenses is calculated by using the sum option and selecting the apropriate range which must be totalled. Finally the deficit is calculated by using the =(cell)-(cell) operation

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Raafia Siddiqui 211098936 Monthly Budget September October November December
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Income: Pay \$50,000.00 \$50,000.00 \$50,000.00 \$50,000.00 Student Allowance \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 Other Income 1 \$500.00 \$300.00 \$100.00 \$230.00 Other Income 2 \$750.00 \$800.00 \$100.00 \$750.00 Total Income: \$52,250.00 \$52,100.00 \$51,200.00 \$51,980.00 Expenses: Tuition \$1,000.00 \$1,000.00 \$1,000.00 \$1,500.00 Room and Board \$1,000.00 \$1,000.00 \$1,000.00 \$1,000.00 Clothing \$350.00 \$200.00 \$50.00 \$100.00 Car \$500.00 \$200.00 \$339.00 \$780.00 Insurance \$200.00 \$200.00 \$200.00 \$200.00 Books \$500.00 \$0.00 \$0.00 \$0.00 Recreation \$0.00 \$50.00 \$100.00 \$55.00 Credit Cards \$100.00 \$30.00 \$45.00 \$78.00 Total Expenses: \$3,650.00 \$2,680.00 \$2,734.00 \$3,713.00 Monthly Surplus (Deficit): \$48,600.00 \$49,420.00 \$48,466.00 \$48,267.00...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

exercise 1,lab 1 - Income Pay \$50,000.00 \$50,000.00...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online