90.2K

Verified Solution

Link Copied!

I've an accounting assessment tomorrow and I've no idea how to prepare a cash budget, the notes I have are useless. If you help explain how you got each number id appreciate it. Thank you in advance.

Q3. BUDGETING Hannigan Ltd. is a successful food manufacturing company and is planning its 2020 Cash Budget. They have made the following forecast for trading: January February March April May June Sales: 100,000 125.000 133,000 97,000 128.000 90.000 Purchases 37,000 40,000 31,000 41,000 29,000 38.000 You are also informed: 1) 30% of Sales will be paid in cash immediately, with the remaining 70% paid one month following the sale. Total sales in December 2019 are expected to be 84,000. 2) All purchases will be on Credit and are paid for one month after purchase. Purchases in December 2019 are expected to be 35,000. 3) Equipment will be bought and paid for in February for 123,000. 4) The annual rent is expected to be 66,000, payable monthly in equal instalments. 5) Wages, payable as incurred, are expected to be 18,500 per month 6) The opening cash balance is 12,500. Required: (a) Prepare a cash budget for the six months to June. (24 Marks) (b) Outline TWO ways in which any shortfall in cash flow that you discover in (a) above could be overcome. (6 Marks) (Total 30 Marks)

Answer & Explanation Solved by verified expert

See Answer