Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
196x Filetype XLS File size 0.12 MB Source: www.melbourne.vic.gov.au
Sheet 1: Summary
| City of Melbourne Financial Projections Template | |||
| Summary Projected Profit & Loss, Cashflow and Balance Sheets | |||
| Projected Profit & Loss Statements | |||
| Year 1 | Year 2 | ||
| Total Sales | |||
| Gross Profit | |||
| Fixed Expenses | |||
| Net Profit Before Tax | |||
| Net Profit After Tax | |||
| Projected Cashflow Statements | |||
| Year 1 | Year 2 | ||
| Total Cash Receipts | |||
| Total Cash Payments | |||
| Net Cashflow | |||
| Bank Balance (s) | |||
| Bank Balance (e) | |||
| Projected Balance Sheets (at end of year) | |||
| Year 1 | Year 2 | ||
| Total Current Assets | |||
| Total Operating Assets | |||
| Total Assets | |||
| Total Current Liabilities | |||
| Total Non Current Liabilities | |||
| Total Liabilities | |||
| Net Assets | |||
| Paid Up Capital | |||
| Retained Earnings | |||
| Return On Investment* | |||
| Average ROI | |||
| * Formula for ROI = Net Profit Before Tax divided by total investment. | |||
| City of Melbourne Financial Projections Template | |||||||||||||
| Projected Profit & Loss Statement (1) | |||||||||||||
| Year 1 | JUL | JUN | TOTAL | ||||||||||
| Revenue | |||||||||||||
| Product / Service | |||||||||||||
| Total Revenue | |||||||||||||
| Less: Cost of Goods Sold (2) (COGS)/ Direct Costs (3) | |||||||||||||
| Total COGS / Direct Costs | - | ||||||||||||
| Gross Profit | |||||||||||||
| Gross Profit Percentage (4) | |||||||||||||
| Selling Expenses | |||||||||||||
| Advertising | |||||||||||||
| Communications | |||||||||||||
| Marketing | |||||||||||||
| Motor Vehicle Expenses | |||||||||||||
| Depreciation (5) | |||||||||||||
| Salaries | |||||||||||||
| On Costs (15%) (6) | |||||||||||||
| Sales Commissions | |||||||||||||
| - | - | - | - | - | - | - | - | - | - | - | - | - | |
| - | |||||||||||||
| Administration and other Fixed Expenses (7) | |||||||||||||
| Accounting Fees | |||||||||||||
| Amortisation of Exclusive Licence | |||||||||||||
| Legal Fees | |||||||||||||
| Stationery & Postage | |||||||||||||
| Communications | |||||||||||||
| Salaries | |||||||||||||
| On Costs (15%) | |||||||||||||
| Operational Expenses | |||||||||||||
| Utilities (electricity,gas,water) | |||||||||||||
| Rent | |||||||||||||
| Rates | |||||||||||||
| Repairs & Maintenance | |||||||||||||
| Finance Expenses | |||||||||||||
| Bank Charges | |||||||||||||
| Interest - Loan | |||||||||||||
| Interest - Bank Overdraft | |||||||||||||
| Insurance | |||||||||||||
| Total Operating Expenses | |||||||||||||
| Net Profit Before Tax | |||||||||||||
| Net Profit Before Tax Percentage (8) | |||||||||||||
| Tax @ 30% (company tax rate) | |||||||||||||
| Net Profit After Tax | |||||||||||||
| Net Profit After Tax Percentage (8) | |||||||||||||
| City of Melbourne Financial Projections Template | ||||||||||||
| Projected Cashflow Statement Year One | ||||||||||||
| JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | |
| Cash Receipts | ||||||||||||
| Sales Receipts | ||||||||||||
| Investment | ||||||||||||
| Net GST from Tax Dept | ||||||||||||
| Loan Funds | ||||||||||||
| Total Cash Receipts | ||||||||||||
| Less: | ||||||||||||
| Cash Payments | ||||||||||||
| Selling Expenses | ||||||||||||
| Administration and other Fixed Expenses (7) | ||||||||||||
| Operational Expenses | ||||||||||||
| Finance Expenses | ||||||||||||
| Stock Purchases | ||||||||||||
| Net GST paid to Tax Dept. | ||||||||||||
| Fixed Asset Purchases | ||||||||||||
| Tax Paid | ||||||||||||
| Total Cash Payments | ||||||||||||
| Net Cash Flow | ||||||||||||
| Bank Balance (s) | ||||||||||||
| Bank Balance (e) | ||||||||||||
no reviews yet
Please Login to review.
