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 |
Login
Pages: 4
Words: 890