Hello Everyone
Please help me in making a cash budget from the following information. I am a new student and would be thankful for your help.
Question:
Mr. David Gladstone setting up a small business providing cleaning services to offices on a trading estate in Scarborough. She has asked you to help her prepare a cash flow forecast for her first 12 months of trading. You should produce a forecast from January to December based on the information provided below. Sales and purchases for the 12 months are expected to be as follows.
At the beginning of January, David Gladstone will buy two small cars, to drive herself and staff to the offices, each costing £10,000. He will invest £15,000 of his own money and has agreed a bank loan of £7000. David Gladstone will receive the loan in January and start repayments the following month at a fixed rate of £250 per month.
When meeting with bank manager, He also agreed a business overdraft that will be charged at a rate of 1 per cent on any negative closing balances. In order to start trading in January, He buys £4000 worth of cleaning equipment, including vacuum cleaners and floor buffers. In addition, He spends £150 on less durable (not as long-lasting) products such as dusters and mops, which He plans to replace every second month. David Gladstone plans to offer 30 days’ credit terms to two of his bigger cleaning contracts. These two combined will account for £2200 of his monthly sales.
David Gladstone has rented a small lock-up to store his equipment and materials at a cost of £600 per month. He will employ four cleaners, each earning £400 per month, and a cleaning supervisor earning an annual salary of £7200. He will withdraw £1000 a month for herself, and hopes to be able to increase this to £1200 per month after six months.
Additional monthly costs include: • £300 car insurance • £20 advertising • £100 fuel.
Thanks again for your help...
Please help me in making a cash budget from the following information. I am a new student and would be thankful for your help.
Question:
Mr. David Gladstone setting up a small business providing cleaning services to offices on a trading estate in Scarborough. She has asked you to help her prepare a cash flow forecast for her first 12 months of trading. You should produce a forecast from January to December based on the information provided below. Sales and purchases for the 12 months are expected to be as follows.
Month | Sales | Purchases |
| January | £5,000 | £600 |
| February | £5,000 | £600 |
| March | £5,000 | £600 |
| April | £5,000 | £600 |
| May | £5,000 | £600 |
| June | £5,000 | £600 |
| July | £4,000 | £500 |
| August | £4,000 | £500 |
| September | £5,000 | £600 |
| October | £6,000 | £650 |
| November | £6,000 | £650 |
| December | £6,000 | £650 |
At the beginning of January, David Gladstone will buy two small cars, to drive herself and staff to the offices, each costing £10,000. He will invest £15,000 of his own money and has agreed a bank loan of £7000. David Gladstone will receive the loan in January and start repayments the following month at a fixed rate of £250 per month.
When meeting with bank manager, He also agreed a business overdraft that will be charged at a rate of 1 per cent on any negative closing balances. In order to start trading in January, He buys £4000 worth of cleaning equipment, including vacuum cleaners and floor buffers. In addition, He spends £150 on less durable (not as long-lasting) products such as dusters and mops, which He plans to replace every second month. David Gladstone plans to offer 30 days’ credit terms to two of his bigger cleaning contracts. These two combined will account for £2200 of his monthly sales.
David Gladstone has rented a small lock-up to store his equipment and materials at a cost of £600 per month. He will employ four cleaners, each earning £400 per month, and a cleaning supervisor earning an annual salary of £7200. He will withdraw £1000 a month for herself, and hopes to be able to increase this to £1200 per month after six months.
Additional monthly costs include: • £300 car insurance • £20 advertising • £100 fuel.
Thanks again for your help...
