Problem
Levi Ackerman decided to resign from his current job and start his own café. He is investing $50,000 of his own money and took out a business loan worth $100,000. Levi handed in his resignation in May 2021, purchased and fully paid for an established café costing $109,000 in June 2021, and plans to open shop on 1 July 2021.
Additional information:
1. Annual depreciation for the non-current assets taken over from the previous owner totals $18,000.
2. Additional equipment costing $5,000 were purchased and paid for in June. These equipment are depreciated on a straight-line basis and have an expected useful life of ten years with no residual value.
3. Assume that monthly payment for the loan is $780, of which $240 relates to interest payment and the remainder relates to principal repayment.
4. One month's credit is received from inventory suppliers and Levi will utilise this payment term, paying the amounts owed one day before it is due. Inventories costing $4,000 are acquired in June 2021. Subsequent monthly purchases will be at a level that replaces forecasted sales for the month.
5. A 40% mark-up is added onto the cost of inventory to determine the selling price (i.e., sales as a percentage of cost of sales is 140%).
6. Forecasted monthly sales are $22,400 for July, $25,200 for August and September, and $30,800 from October onwards. Assume any credit sales are paid within the month of sale.
7. Operating expenses, excluding cost of sales and depreciation of non-current assets, are estimated at $5,400 per month.
8. Levi intends to make monthly cash drawings of $1,000.
Task
A. Compute cash budget for the six months ended 31 December 2021. (Can have a month in each column. Start with the opening balance, then cash receipts, cash payments, net cash flow and closing balance).
B. Compute an income statement for the six months ended 31 December 2021. Assume a 30% tax rate.