Budget Schedules & Expected Outcomes – Using the information provided, prepare the following… 1 answer below »

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadlines.


Order a Similar Paper Order a Different Paper

Budget Schedules & Expected Outcomes
(15 marks, weighted 50% of assignment total)
Using the information provided, prepare the following operating and financial budgets for the twelve-month period from January 2020 to December 2020.
Operating Budgets: Monthly Sales Revenue Labour Budget (including labour cost per appointment type) Monthly Operating Expense Budget Financial Budgets: Budgeted Income Statement for the year ended 31 December 2020 Monthly Cash flow Budget Budgeted Balance Sheet for the year ended 31 December 2020 Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document). The first worksheet should contain your raw/input data and assumptions from this assignment overview sheet. All future worksheets should be linked to this data. Show all calculations and use Excel functions where possible. While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without difficulty.