Answer:
January $11,200
February $10,000
March $10,000
Explanation
CASH BUDGET FOR JANUARY
Beginning cash balanc$16,000
Add: Cash receipts 240,000
Cash available 256,000
Less: Cash payments
For inventory purchases220,000
For S&A expenses 62,000
Interest expense per month 800
Total budgeted payment 282,800
Payments minus receipts
Surplus (shortage) (26,800)
Financing Activity
Borrowing (repayment) 38000
Ending cash balance 11200
CASH BUDGET FOR FEBRUARY
Beginning cash balanc$11,200
Add: Cash receipts 232,000
Cash available 243,200
Less: Cash payments
For inventory purchases 164,000
For S&A expenses 64,000
Interest expense per month 1180
Total budgeted payment 229,180
Payments minus receipts
Surplus (shortage) 14,020
Financing Activity
Borrowing (repayment) (4,020)
Ending cash balance 10,000
CASH BUDGET FOR MARCH
Beginning cash balance $10,000
Add: Cash receipts 272,000
Cash available 282,000
Less: Cash payments
For inventory purchases 190,000
For S&A expenses 54,000
Interest expense per month 1,140
Total budgeted payment 245,140
Payments minus receipts
Surplus (shortage) 36,860
Financing Activity
Borrowing (repayment) (26,850)
Ending cash balance 10,000