Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
262x Filetype XLSX File size 0.05 MB Source: www.melbourne.vic.gov.au
Sheet 1: Instructions
| City of Melbourne | |
| Small Business Grants 2020 | |
| Instructions for Completing Projected Financial Templates | |
| The tabs on the right are templates for Profit & Loss Statement, Balance Sheet and Cash Flow Statement.These templates are used as a guide only and give an indication of the details required. Applicants have the option to submit their own financial statements that contain similar amount of details or use these templates to complete the financial projections. Regardless of the templates you use, please provide sufficient assumptions/notes to support the projected financial data. | |
| Note 1 | Financial periods |
| All applicants are to submit two years of Projected Profit & Loss Statements, Projected Balance Sheets and Projected Cash Flow | |
| for the financial years ended 2020 (Year 1) and 2021 (Year 2). For the Cash Flow, complete the data in the month when the business starts. | |
| Note 2 | Reliability and accuracy of the financial projections |
| All applicants have the responsibility to make sure that the financial projections submitted are accurate and reasonable. The projected | |
| Balance Sheets should balance and reflect the financial results and cash flows forecasts. For Profit & Loss Statement and Balance Sheet, | |
| only yearly results are required (or for a period if the business starts during the year), whereas Cash Flow statement is to be | |
| submitted with monthly results. Under 'Assumptions', where indicated, you are encouraged to provide sufficient details to explain how the amounts | |
| have been determined. | |
| Note 3 | Data Entry |
| Only enter data in cells highlighted in green. Cells not highlighted are formulated and are not to be over-written. | |
| New lines can be inserted as required. To preserve the formulas, right click to insert a new line item. | |
| Besides accurate financial data, detailed assumptions/notes are equally important for our assessment purpose. | |
| For any discrepancies (eg. Balance sheet does not balance) in the financial statements, please provide sufficient explanations. | |
| Company name: | ||
| ABN Number: | ||
| Projected Profit and Loss Statement for the financial year ended 30/06/2020 (Year 1) | ||
| Item | Amount | Assumptions |
| $ | ||
| Revenue | ||
| Product Sales | Provide explanation of how this amount has been determined (eg. Product A: number of units sold * unit price) | |
| Services | Provide explanation of how this amount has been determined (eg.Service C: number of hours * hourly charge) | |
| Total Revenue (a) | 0 | |
| Cost of Goods Sold | ||
| Product Sales | Provide explanation as to how this was calculated | |
| Services | If relevant, provide details of any direct costs associated with the delivery of a service or services. | |
| Total Cost of Goods Sold (b) | 0 | |
| Gross Profit (c) | 0 | (a) - (b) |
| Expenses | ||
| Employee Expenses | ||
| Salaries | Provide details of number of staff to be employed for the year and their annual salary and if applicable, the period for which they will be employed | |
| Oncosts | This amount is to be calculated applying a rate to cover superannuation, workcover etc.(eg. 15% of salaries) | |
| Selling Expenses | ||
| Advertising | Include the amount of proposed spend for this item | |
| Communications | Include the amount of proposed spend for this item | |
| Marketing | Include the amount of proposed spend for this item | |
| Occupancy Expenses | ||
| Utilities (electricity,gas,water) | Include the amount of proposed spend for this item | |
| Rent | Include the amount of proposed spend for this item | |
| Rates | Include the amount of proposed spend for this item | |
| Repairs & Maintenance | Include the amount of proposed spend for this item | |
| Administration and other Fixed Expenses | ||
| Accounting Fees | Include the amount of proposed spend for this item | |
| Legal Fees | Include the amount of proposed spend for this item | |
| Stationery & Postage | Include the amount of proposed spend for this item | |
| Motor Vehicle | Include the amount of proposed spend for this item | |
| Finance Expenses | ||
| Bank Charges | Include the amount of proposed spend for this item | |
| Interest - Loan | Calculate interest to be paid on loans showing the principal amount/s and interest rate/s. | |
| Interest - Bank Overdraft | Include interest to be paid on bank overdrafts | |
| Insurance | Include the amount of premiums to be paid on insurance policies | |
| Depreciation / amortisation | Include the charge on depreciable assets. Show depreciation rate/s. | |
| Other Expenses | ||
| Item (1) | Include details for other expense items. Insert new lines if required | |
| Item (2) | Include details for other expense items. Insert new lines if required | |
| Total Expenses (d) | 0 | |
| Net Operating Profit (Loss) | 0 | (c) - (d) |
| Explanatory notes (provide additional notes as required to explain any of the amounts included in the profit and Loss projection) : |
| Company name: | ||
| ABN Number: | ||
| Projected Profit and Loss Statement for the financial year ended 30/06/2021 (Year 2) | ||
| Item | Amount | Assumptions |
| $ | ||
| Revenue | ||
| Product Sales | Provide explanation of how this amount has been determined (eg. Product A: number of units sold * unit price) | |
| Services | Provide explanation of how this amount has been determined (eg.Service C: number of hours * hourly charge) | |
| Total Revenue (a) | 0 | |
| Cost of Goods Sold | ||
| Product Sales | Provide explanation as to how this was calculated | |
| Services | If relevant, include any direct costs associated with service delivery. Provide details. | |
| Total Cost of Goods Sold (b) | 0 | |
| Gross Profit (c) | 0 | (a) - (b) |
| Expenses | ||
| Employee Expenses | ||
| Salaries | Provide details of number of staff to be employed for the year and their annual salary and if applicable, the period for which they will be employed. | |
| Oncosts | This amount is to be calculated applying a rate to cover superannuation, workcover etc.(eg. 15% of salaries) | |
| Selling Expenses | ||
| Advertising | Include the amount of proposed spend for this item | |
| Communications | Include the amount of proposed spend for this item | |
| Marketing | Include the amount of proposed spend for this item | |
| Occupancy Expenses | ||
| Utilities (electricity,gas,water) | Include the amount of proposed spend for this item | |
| Rent | Include the amount of proposed spend for this item | |
| Rates | Include the amount of proposed spend for this item | |
| Repairs & Maintenance | Include the amount of proposed spend for this item | |
| Administration and other Fixed Expenses | ||
| Accounting Fees | Include the amount of proposed spend for this item | |
| Legal Fees | Include the amount of proposed spend for this item | |
| Stationery & Postage | Include the amount of proposed spend for this item | |
| Motor Vehicle | Include the amount of proposed spend for this item | |
| Finance Expenses | ||
| Bank Charges | Include the amount of proposed spend for this item | |
| Interest - Loan | Include interest to be paid on loans | |
| Interest - Bank Overdraft | Include interest to be paid on bank overdrafts | |
| Insurance | Include the amount of premiums to be paid on insurance policies | |
| Depreciation / amortisation | Include the charge on depreciable assets | |
| Other Expenses | ||
| Item (1) | Include details for other expense items. Insert new lines if required | |
| Item (2) | Include details for other expense items. Insert new lines if required | |
| Total Expenses (d) | 0 | |
| Net Operating Profit (Loss) | 0 | (c) - (d) |
| Explanatory notes (provide additional notes as required to explain any of the amounts included in the Profit and Loss projection) : |
no reviews yet
Please Login to review.
