Code: AMAP501
Q1. Prepare a monthly Cash Budget using an Excel spreadsheet for Barry Court for the three (3) months ended 31 August 2015.
Cash budget of Happy Feet Shoe House
Cash budget of HAPPY FEET SHOE STORE | |||
For the three months ending August 2015 | |||
Particulars | Jun-15 | Jul-15 | Aug-15 |
Receipts | |||
Opening cash balance | $8,589.00 | $ (8,340.55) | $(5,815.35) |
Cash sales | $4,468.00 | $3,952.00 | $4,357.00 |
Cash received from debtors | $9,440.00 | $9,068.80 | $8,110.40 |
Total receipts (A) | |||
Payments | |||
Cash paid to creditors | $9,600.00 | $8,936.00 | $7,868.00 |
Electricity | $480.00 | $480.00 | $480.00 |
Rent | $1,150.00 | $1,150.00 | $1,150.00 |
Depreciation on fixtures | $125.00 | $125.00 | $125.00 |
Telephone bill | $741.80 | $688.40 | $730.70 |
ACC levies | $278.00 | $278.00 | $278.00 |
Insurance | $1,177.50 | ||
Advertising | $1,117.00 | $988.00 | $1,089.25 |
Vehicle expense | $218.75 | $218.75 | $218.75 |
Miscellaneous expenses | $320.00 | $320.00 | $320.00 |
Loan repayment | $100.00 | $100.00 | $5,100.00 |
Drawings | $1,200.00 | $1,200.00 | $1,200.00 |
Wages | $400.00 | $400.00 | $400.00 |
GST payment | $2,050.00 | ||
Total payments (B) | $ 17,780.55 | $ 14,884.15 | $20,137.20 |
Closing cash balance (A-B) | $ (8,340.55) | $ (5,815.35) | $ (12,026.80) |
Total | $9,440.00 | $9,068.80 | $8,110.40 |