Use the following information to formulate a simplified cash budget. DEC JAN FEB MAR Sales 50,000 50,000
Question:
Use the following information to formulate a simplified cash budget.
DEC | JAN | FEB | MAR | |
Sales | 50,000 | 50,000 | 50,000 | 75,000 |
Inventory Purchase | 25,000 | 27,000 | 28,000 | 30,000 |
Other Cash Expenses | 15,000 | 15,000 | 22,000 | 37,000 |
Rent | 2,000 | 2,000 | 2,000 | 2,000 |
Depreciation | 10,000 | 10,000 | 10,000 | 10,000 |
Interest Expenses | 1,500 | 1,500 | 1,500 | 1,500 |
Purchases furniture (With cash) | 0 | 0 | 10,000 | 0 |
Sales: 60% of the sales are cash while the remaining 40% are credit sales. One half of the credit sales are collected in the month of sale and one half in the next month.
Purchases: 60% of the purchases are paid in the month of the purchase while 40% are paid in the next month
Other: Assume that other cash expenses and capital purchases are paid for during the month indicated above (for example, other cash expenses of 15,000 for December was paid in December).
Depreciation: Depreciation of Fixed assets is Baht 10,000 per month
Interest: Interest expense is paid quarterly in each Mar, June, Sep, and Dec
Dividends: Cash dividends of $2,000 will be paid in Feb
Rent: Monthly Rent $2,000 will be paid each month
Tax: Taxes of $1,500 are due in Mar
Assume that the beginning cash balance of January 1 is 8,000.
Prepare a cash flow budget for the months of January – March.