Accounting

EXERCISE 7 & 11

OCTOBER NOVEMBER DECEMBER JANUARY FEBRUARY MARCH
DETAILS MONTH1 MONTH2 MONTH3 MONTH4 MONTH5 MONTH6 MONTH7 MONTH8 MONTH9
Sales$22,000.00 $25,000.00 $22,000.00 $28,000.00 $15,000.00 $17,000.00
Balances $18,700.00 $21,250.00 $18,700.00 $23,800.00 $12,750.00 $14,450.00
DebtorsSales fig $22,000.00 $25,000.00 $22,000.00 $28,000.00 $15,000.00 $17,000.00
Up Balance $3,300.00
Cash inflow MTH1 15% $3,300.00 $3,750.00$3,300.00 $4,200.00 $2,250.00 $2,550.00
Cash inflow MTH2 60% $11,220.00 $12,750.00 $11,220.00 $14,280.00 $7,650.00 $8,670.00
Cash inflow MTH3 30%$5,610.00 $6,375.00 $5,610.00 $7,140.00 $3,825.00 $4,335.00
Cash inflow MTH4 10% $1,870.00 $2,125.00 $1,870.00 $2,380.00 $1,275.00 $1,445.00
TotalReceipts $3,300.00 $18,270.00 $39,930.00 $63,595.00 $87,860.00 $107,070.00 $- $- $-
Less Payments
Creditors $10,000.00 $8,000.00 $7,000.00$5,000.00
Purchase fig MTH1 100% $10,000.00 $8,000.00 $7,000.00 $5,000.00
Less Expenses
Wages $3,100.00 $2,400.00 $2,900.00
Electricity$350.00 $290.00 $320.00
Packaging $210.00 $170.00 $200.00
Advertising $560.00 $340.00 $410.00
Telephone $- $390.00 $- $200.00Insurance $4,200.00 $- $-
Rent $1,500.00 $1,500.00 $1,500.00
Other $240.00 $240.00 $240.00
Special Payments
TotalPayments $20,160.00 $13,330.00 $12,570.00 $5,200.00
Net Cash Flow $3,300.00 $18,270.00 $39,930.00 $43,435.00 $74,530.00 $94,500.00 $(5,200.00) $- $-