You are to prepare a set of exemplar financial reports, which the trainee accountants can place in the file and use for reference.

You must:

• Prepare a cash budget from the information in Appendix 4

• Appendix 4

  Prepare a three month Cash Budget for Active Sport Gym and Leisure Shop to estimate the cash balance at the end of April from the following information.

  The projected Bank Account balance on 1 January is 32 180.

  Projected Shop Sales Figures:

  	December	January	February	March	April
  Credit Sales ()	4 350	3 150	3 600	3 825	3 900
  Cash Sales ()	1 450	1 050	1 200	1 275	1 300

  Credit customers pay one month after the month of sale.

  Projected Gym Takings:

• January - 22 400
• February - 22 400
• March 10% increase on February
• April - 500 increase on March

• Estimated Purchases:

  All purchases are on credit and suppliers are paid one month after goods are bought.

• December - 3 000
• January - 500 less than December
• February 10% increase on January
• March Same as February
• April 12% increase on March

• Expenses:

• Wages are 11 000 per month. A 5% wage increase is expected from 1 April.
• Light and Heat is 550 per month. An 8% increase is expected from 1 March.
• Maintenance is carried out three times a year February, June and October.
• This costs 55 500 per year.
• General expenses are estimated at 30 000 per year, paid every 2 months starting in February

Will be much appreciated if its done in excel sheet.