Use Microsoft Excel to complete this assignment. Each student is to create their own Excel file, and complete
the assignment individually. Wherever possible, the spreadsheet should use formulas and cell referencing.
Format:
• For numbers, use the Accounting format with zero decimal places. The spreadsheet should be
formatted to show amounts to the nearest dollar (no cents). Do not use =ROUND to achieve this, use
the ‘Decrease Decimal’ button in the number section of the Home ribbon:
• If your ending balance sheet is out by $1, do not worry about it.
• Marks will be awarded for a neat, well laid out and formatted spreadsheet. It should be easy to follow
and have a good flow to it.
• Schedules should flow down a worksheet, not side by side. So, the opening balance sheet would be at
the top, the cash receipts schedule below it.
• Lines should be included to show where calculations occur, with double lines at the bottom of each
schedule. See the balance sheet on the previous page.
