Spreadsheet Data: Annual Budget, Income, and Expenditure for

School: Australian National University - Course: BSBITU 402 - Subject: Accounting

This document is Spreadsheet Data. It is part of the supporting assessment resources for Assessment Task 2 of BSBITU402. King Edward VII College Pty Ltd ABN 012 444 555 IncomeAnnual budgetJULAUG Certificate III in International Trade$75,000.00 $9,000.00 $7,500.00 Certificate IV in International Trade$125,000.00 $12,500.00 $20,000.00 Diploma of International Trade$150,000.00 $21,000.00 $30,000.00 Expenditure Accounting fees$12,000.00 $4,000.00 $2,000.00 Advertising fees$10,000.00 $1,000.00 $1,500.00 Computer software$1,000.00 $500.00 $- Electricity$1,500.00 $300.00 $300.00 Insurance$4,800.00 $400.00 $400.00 Internet$1,300.00 $150.00 $200.00 Office supplies$2,700.00 $200.00 $400.00 Printing$2,200.00 $270.00 $300.00 Rent$60,000.00 $5,000.00 $5,000.00 Repairs and maintenance$3,200.00 $400.00 $300.00 Salaries$195,000.00 $13,000.00 $13,000.00 Superannuation expenses$20,000.00 $1,500.00 $1,500.00 Telephone$2,500.00 $4,500.00 $500.00 Travel$2,100.00 $-$3,000.00 Profit = Income - Expenditure Total Income$426,000 Total Expenditure$320,550 Profit made$105,450 Annual budget summary for July 2015 to June 2016 Monthly Budget (2015) OctoberNovemberDecember $7,500.00 $10,500.00 $5,000.00 $20,000.00 $16,000.00 $10,000.00 $15,000.00 $18,000.00 $15,000.00 $42,500.00 $44,500.00 $30,000.00 Monthly Budget (2015) OctoberNovemberDecember $1,000.00 $1,000.00 $1,000.00 $1,000.00 $500.00 $1,000.00

$80.00 $80.00 $30.00 $200.00 $100.00 $100.00 $400.00 $400.00 $400.00 $100.00 $120.00 $100.00 $200.00 $200.00 $300.00 $200.00 $200.00 $200.00 $5,000.00 $5,000.00 $5,000.00 $150.00 $200.00 $300.00 $17,000.00 $16,000.00 $16,250.00 $2,000.00 $1,500.00 $2,000.00 $150.00 $200.00 $200.00 $100.00 $100.00 $200.00 $27,580.00 $25,600.00 $27,080.00