Cash Budget

pages Pages: 4word Words: 890

Question :

Code: AMAP501

Q1. Prepare a monthly Cash Budget using an Excel spreadsheet for Barry Court for the three (3) months ended 31 August 2015.


Show More

Answer :

Cash budget of Happy Feet Shoe House 

Cash budget of HAPPY FEET SHOE STORE
For the three months ending August 2015
ParticularsJun-15Jul-15Aug-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