I have been trying but I can't get the beginning cash balance, loan and interest. I tried to carry over the available cash for the following month but the numbers don't add.

Budget Data LMN Co. Assets as at March 31, 2011 Liabilities and Equity as at March 31, 2011 Accounts Payable Lease Payable 3000 11000 Cash Accounts Receivable Inventory(note 1) Prepaid Supplies Equipment 4000 9000 10000 900 21000 Owners Equity 30900 Total Assets 44900 Total Liabilities and Equity 44900 Required: Prepare a Quarterly Master budget for LMN Co. For the months of April, May and June, Up to and Including the Income Statement Notes: Inventory as at March 31, 2011 consists of 2,000 calculators at a cost of $5.00 per calculator. 2) LMN Co. sells boxes at a selling price per calculator is: $ 8.00 Expected Sales in units: April May June July August 5,000 6,000 8,000 2,000 7,000 4) All sales are on credit and are collected as follows: Month of Sale Month after Sale There are no bad debts 65% 35% 5 $ 5.00 The Wholesale cost per calculator is: Payments for wholesale purchases are: Month of Purchase Month after Purchase 80% 20% Desired Ending Inventory is 10% of next months sales Operating expenses monthly are: Wages $ 9,500.00 Freight 1% of sales Rent $ 2,500.00 Depreciation $ 900.00 Miscellaneaous $ 600.00 Office Equipment is purchased in April for: $ 7,000 Monthly minimum cash balance required $ 4,000.00 Monthly interest on borrowed funds: 1% Assume funds are borrowed at the beginning of the month that they are needed and repaid at the end of the month where excess cash permits repayment Assume simple interest rate, no compounding Interest is repaid at the time of the loan repayment. Cash Budget April May May June June Total Total Beginning Cash Balance Cash Collections Total Cash Available $35,000 $45,200 $58,400 $138,600 Cash Disbursements: April May June Total $35,800 $13,240 Purchases Operating Expenses Other Total Cash Disbursements $17,400 $13,000 $7,000 $37,400 $28,400 $13,080 $0 $41,480 $81,600 $39,320 $7,000 $127,920 $0 $49,040 Net Cash Available Financing: Bank Borrowing Loan Repayment Interest Cost Total Financing Ending Cash Balance