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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
Raafia Siddiqui 211098936 Comments s.
Background image of page 2
Raafia Siddiqui 211098936 Monthly Budget September October November December
Background image of page 3
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

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 Right Arrow Icon
Ask a homework question - tutors are online