28
CASH BUDGET – THE GOLDEN COMPANY
August September October November December
Sales $750,000 $800,000 $900,000
Credit Sales $150,000 $450,000 562,500 600,000 675,000
Cash Receipts
Collections
1st Month – 70 percent $315,000 $393,750 $420,000
2nd Month – 25 percent 37,500 112,500 140,625
Cash Sales 187,500 200,000 225,000
Dividends Received – 0 – 1,000 – 0 –
Other – 0 – – 0 – – 0 –
Total Cash Receipts $540,000 $707,250 $785,625
Cash Disbursements
Manufacturing Costs – ½ $212,500 $227,500 $257,500
Manufacturing Costs – ½ 200,000 212,500 227,500
Operating Costs – ½ 120,000 115,000 130,000
Operating Costs – ½ 100,000 120,000 115,000
Note Payable 60,900 – 0 – – 0 –
Capital Expenditure – 0 – 60,000 – 0 –
Tax Payment – 0 – 50,000 – 0 –
Other – 0 – – 0 – – 0 –
Total Cash Disbursements $693,400 $785,000 $730,000
EOM Balance
Beginning Cash $70,000 $20,000 $20,000
Cash Receipts 540,000 707,250 785,625
Cash Disbursements 693,400 785,000 730,000
EOM Balance ($83,400) ($57,750) ($75,625)
Repay – 0 – 104,262 183,528
Borrow 103,400 182,012 127,903
Final EOM Balance $20,000 $20,000 $20,000
Calculations
October 18th notes payable:
$60,000 principal + $60,000 × .09 × ¼ of a year = $61,350