Income Statement Revenue Less Operating Expenses Selling Expenses Advertising Administration Expenses Depreciation Insurance Utilities Rent Wages Office expenses Financial Expenses Bank fees Interest on loan Net Profit Budget for next year $160,000 $10,500 $10,500 | Increase by 5% 15% diminishin $14,000 ' 9 value $5,800 Increase by 3% $3,800 Increase by 8% $39,600 Increase by 2% $18,000 Decrease by 5% $15,261 $96,461 @ 3% of revenue $1,200 Decrease by 2% $26,400 $27600 | No change $25,439 Balance Sheet Current Assets Cash Accounts Receivable Non-Current Assets Equipment $108,000 Accumulated Depreciation Equipment -$28,600 Total Assets Current Liabilities GST Payable Non-Current Liabilities Loan Total Liabilities Net Assets Capital Opening Capital Net Profit $22,619 $6,270 $79,400 $2,850 $30,000 $50,000 $25,439 $28,889 $108,289 $32,850 $75,439 $75,439 Revenue Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Hours Price Revenue Quarter Total Accounts Receivable Collection Schedule Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Revenue GST Collections @ 50% Collections @ 40% Collections @ 10% Total cash collected Quarter Collections Operating Expenses Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Selling Expenses Advertising Total Selling Admin Expenses Depreciation Insurance Utilities Rent Wages Office expenses Total Admin Financial Expenses Bank Fees Interest on loan Total Financial Total Quarter TotalCash Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Cash Inflow Accounts Receivable Total Inflow Cash Outflow Advertising Insurance Utilities Rent Wages Office expenses Bank Fees Interest on loan GST payable Total Outflow Net Inflow/Outflow Quarter Inflow/Outflow Opening Cash Net Inflow/Outflow Closing Cash GST Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun GST collected SO so so SO SO SO so SO so SO Less GST Paid on: Advertising Insurance Utilities Rent Office expenses Total GST paid Total GST Payable Quarter GST PaidIncome Statement Budget Quarter Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Month Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun Revenue Less Operating Expenses Net Profit Quarter Net Profit Balance Sheet Budget Current Assets Cash Accounts Receivable Non-Current Assets Equipment Accumulated Deprn- Equip Total Assets Current Liabilities GST Payable Non-Current Liabilities Loan Net Assets Capital Opening Captial Net Profit