Abc Assignment Help

Cash Budget

Code: AMAP501

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


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 




Customer Testimonials