You are to prepare a set of exemplar financial reports, which the trainee accountants can place in the file and use for
Posted: Mon May 02, 2022 6:46 am
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:
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:
Estimated Purchases:
All purchases are on credit and suppliers are paid one month
after goods are bought.
Expenses:
Will be much appreciated if its done in excel sheet.
the trainee accountants can place in the file and use for
reference.
You must:
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:
Estimated Purchases:
All purchases are on credit and suppliers are paid one month
after goods are bought.
Expenses:
Will be much appreciated if its done in excel sheet.