Business start up project
Redhand
SandscreenFinancialAppendix.xlsx2
| DEFAULT VALUES / DROPDOWNS / CHECKBOXES | Calculate Years | |||||||||||||||||
| Cell or description | Choice | Value Chosen | Value Adjusted | 3 | <--Start Month | |||||||||||||
| New/Existing | 2 | 1975 | <--Start Year | |||||||||||||||
| 3 | <--Y/E Month | |||||||||||||||||
| Form of Company | Corporation | 1 | 1 | 2024 | <--Y/E Year | |||||||||||||
| Partnership | 3/15/75 | <--Start Date | ||||||||||||||||
| Proprietorship | 3/15/24 | <--Y/E Date | ||||||||||||||||
| Co-operative | ||||||||||||||||||
| Industry Sector | Other | 1 | Calculate Differences | |||||||||||||||
| Accommodation/Food Services | 588 | <-Months between StartDate & Y/E | ||||||||||||||||
| Administrative and Support | 49 | <-Years between StartDate & Y/E | ||||||||||||||||
| Agriculture, Forestry, Fishing and Hunting | 588 | <-Months between Today & Startup Date | ||||||||||||||||
| Arts, Entertainment, and Recreation | 0 | <-Months Between Today & Y/E | ||||||||||||||||
| Construction | ||||||||||||||||||
| Educational Services | Calculate Vlookup Value | |||||||||||||||||
| Finance & Insurance | 0 | <--If startup: Add Historical Column? | ||||||||||||||||
| Health Care/Social Assistance | 1 | <-Is Existing? (1=Yes) | ||||||||||||||||
| Information | 3 | <-Existing: No. of Historical Columns | ||||||||||||||||
| Management of Companies/Enterprises | 0 | <-Existing; Add Interim? | ||||||||||||||||
| Manufacturing | 30 | <--Vlookup Value | ||||||||||||||||
| Mining | ||||||||||||||||||
| Other Services | 6 VLookupTable | |||||||||||||||||
| Professional, Scientific, and Technical Services | Final Choice--> | Mar-2022 | Mar-2023 | Mar-2024 | Dec-1899 | Mar-2025 | Mar-2026 | Mar-2027 | ||||||||||
| Public Administration | Titles--> | HISTORICAL | 0 | 0 | 0 | PROJECTED | ||||||||||||
| Real Estate/Rental and Leasing | Error--> | 3 | Mar-2025 | Mar-2026 | Mar-2027 | PROJECTED | ||||||||||||
| Retail Trade | Startup--> | 0 | Mar-2024 | Mar-2025 | Mar-2026 | PROJECTED | ||||||||||||
| Transportation and Warehousing | Startup + historical | 1 | 588 months | Mar-2024 | Mar-2025 | Mar-2026 | HISTORICAL | PROJECTED | ||||||||||
| Utilities | Startup-as-First-Year | 2 | (0 months) | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | ||||||||||
| Waste Management/ Remediation Services | 1Year--> | 10 | Mar-2024 | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | ||||||||||
| Wholesale Trade | $A$155 | 1Year+Int--> | 11 | Mar-2024 | Interim | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | ||||||||
| Start Date | Month | 1 | Mar-24 | 2Year--> | 20 | Mar-2023 | Mar-2024 | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | ||||||
| Fiscal Year | January | 1 | Year | 2Year+int--> | 21 | Mar-2023 | Mar-2024 | Interim | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | |||||
| Interim | February | 1 | Mar-24 | 3Year--> | 30 | Mar-2022 | Mar-2023 | Mar-2024 | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | |||||
| March | 1 | 3Year+Int--> | 31 | Mar-2022 | Mar-2023 | Mar-2024 | Interim | Mar-2025 | Mar-2026 | Mar-2027 | HISTORICAL | PROJECTED | ||||||
| April | 1 | 0 | 0 | <--RecalculateYet (for macro) | ||||||||||||||
| May | 1 | 0 | $G$446 | <--LastCellEdited (for macro) | ||||||||||||||
| June | ||||||||||||||||||
| July | YearsBetween-> | 49 | To reset sheet: copy these formulas to C31 | |||||||||||||||
| August | MnthBetween-> | 0 | 1 | |||||||||||||||
| September | 1 | |||||||||||||||||
| October | 1 | |||||||||||||||||
| November | 1 | |||||||||||||||||
| December | 1 | |||||||||||||||||
| N/A | 1 | |||||||||||||||||
| Start Year | 1 | Year | ||||||||||||||||
| 2 | 2023 | Loan Dropdowns | Married Dropdown | |||||||||||||||
| 3 | 2022 | 9 | 7 | |||||||||||||||
| 4 | 2021 | 5 | 7 | |||||||||||||||
| 5 | 2020 | 4 | ||||||||||||||||
| 6 | 2019 | |||||||||||||||||
| 7 | 2018 | |||||||||||||||||
| 8 | 2017 | |||||||||||||||||
| 9 | 2016 | |||||||||||||||||
| 10 | 2015 | |||||||||||||||||
| 11 | 2014 | |||||||||||||||||
| 12 | 2013 | |||||||||||||||||
| 13 | 2012 | |||||||||||||||||
| 14 | 2011 | |||||||||||||||||
| 15 | 2010 | |||||||||||||||||
| 16 | 2009 | |||||||||||||||||
| 17 | 2008 | |||||||||||||||||
| 18 | 2007 | |||||||||||||||||
| 19 | 2006 | |||||||||||||||||
| 20 | 2005 | |||||||||||||||||
| 21 | 2004 | |||||||||||||||||
| 22 | 2003 | |||||||||||||||||
| 23 | 2002 | |||||||||||||||||
| 24 | 2001 | |||||||||||||||||
| 25 | 2000 | |||||||||||||||||
| 26 | 1999 | |||||||||||||||||
| 27 | 1998 | |||||||||||||||||
| 28 | 1997 | |||||||||||||||||
| 29 | 1996 | |||||||||||||||||
| 30 | <1996 | |||||||||||||||||
| Y/E | 1 | Year | ||||||||||||||||
| 2 | 2021 | |||||||||||||||||
| 3 | 2022 | |||||||||||||||||
| 4 | 2023 | |||||||||||||||||
| 5 | 2024 | |||||||||||||||||
| 6 | 2025 | |||||||||||||||||
| Interim | 1 | Year | ||||||||||||||||
| 2 | 2021 | |||||||||||||||||
| 3 | 2022 | |||||||||||||||||
| 4 | 2023 | |||||||||||||||||
| 5 | 2024 | |||||||||||||||||
| Married Dropdown | Married | |||||||||||||||||
| Single | ||||||||||||||||||
| Living Common Law | ||||||||||||||||||
| Widowed | ||||||||||||||||||
| Divorced | ||||||||||||||||||
| Separated | ||||||||||||||||||
| Other | ||||||||||||||||||
| FinancingType | Operating Loan | |||||||||||||||||
| Term Loan | ||||||||||||||||||
| Subordinated Loan | ||||||||||||||||||
| Lease | ||||||||||||||||||
| Mortgage | ||||||||||||||||||
| Letter of Credit | ||||||||||||||||||
| Line of Credit | ||||||||||||||||||
| Revolving Credit | ||||||||||||||||||
| Other | ||||||||||||||||||
| Repayment | Weekly | |||||||||||||||||
| Monthly | ||||||||||||||||||
| Quarterly | ||||||||||||||||||
| Semi-annually | ||||||||||||||||||
| Other | ||||||||||||||||||
| Repayment2 | Blended + Interest | |||||||||||||||||
| Blended | ||||||||||||||||||
| Interest Only | ||||||||||||||||||
| Other | ||||||||||||||||||
| Maturity Date | 2024 | |||||||||||||||||
| 2025 | ||||||||||||||||||
| 2026 | ||||||||||||||||||
| 2027 | ||||||||||||||||||
| 2028 | ||||||||||||||||||
| 2029 | ||||||||||||||||||
| 2030 | ||||||||||||||||||
| 2031 | ||||||||||||||||||
| 2032 | ||||||||||||||||||
| 2033 | ||||||||||||||||||
| 2034 | ||||||||||||||||||
| 2035 | ||||||||||||||||||
| 2036 | ||||||||||||||||||
| 2037 | ||||||||||||||||||
| >2037 | ||||||||||||||||||
Financial Plan
| LEGAL NAME | |||||||||
| TRADING NAME | |||||||||
| ADDRESS | |||||||||
| PHONE | FAX | ||||||||
| FORM OF COMPANY | Corporation | ||||||||
| DATE COMPANY STARTED | |||||||||
| LAST FISCAL YEAR END | |||||||||
| LAST INTERIM STATEMENT | |||||||||
| BUSINESS SECTOR | |||||||||
| NAICS CODE | |||||||||
| % OF SALES THAT | |||||||||
| GO TO EXPORT | |||||||||
| HISTORICAL | 0.00 | 0.00 | 0.00 | PROJECTED | 0.00 | 0.00 | |||
| SALES ACTIVITIES | 10/1/18 | 10/1/19 | 10/1/20 | 12/31/99 | 10/1/21 | 10/1/22 | 10/1/23 | ||
| TOTAL SALES ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| SALES ACTIVITIES (%) | |||||||||
| 0 | |||||||||
| 0 | |||||||||
| 0 | |||||||||
| 0 | |||||||||
| 0 | |||||||||
| ASSUMPTIONS REGARDING SALES | |||||||||
| HISTORICAL | 0.00 | 0.00 | 0.00 | PROJECTED | 0.00 | 0.00 | |||
| SALES ACTIVITIES | 10/1/18 | 10/1/19 | 10/1/20 | 12/31/99 | 10/1/21 | 10/1/22 | 10/1/23 | ||
| Opening Inventory | |||||||||
| Material Purchases | |||||||||
| Freight & Duty | |||||||||
| Other | |||||||||
| Closing Inventory (-) | |||||||||
| Total Material Costs ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Services / utilities | |||||||||
| Depreciation | |||||||||
| Overhead | |||||||||
| Other | |||||||||
| TOTAL COST OF SALES ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| COST OF SALES (%) | |||||||||
| Opening Inventory | |||||||||
| Material Purchases | |||||||||
| Freight & Duty | |||||||||
| Other | |||||||||
| Closing Inventory (-) | |||||||||
| Total Material Costs (%) | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Services / utilities | |||||||||
| Depreciation | |||||||||
| Overhead | |||||||||
| Other | |||||||||
| TOTAL COST OF SALES (%) | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||
| ASSUMPTIONS REGARDING COST OF SALES | |||||||||
| HISTORICAL | 0.00 | 0.00 | 0.00 | PROJECTED | 0.00 | 0.00 | |||
| SALES ACTIVITIES | 10/1/18 | 10/1/19 | 10/1/20 | 12/31/99 | 10/1/21 | 10/1/22 | 10/1/23 | ||
| Selling Salaries | |||||||||
| Traveling | |||||||||
| Advertising | |||||||||
| Shipping & Delivery | |||||||||
| Depreciation | |||||||||
| Other | |||||||||
| Total Sales Expenses ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| Management Salaries | |||||||||
| Office Salaries | |||||||||
| Professional Fees | |||||||||
| Telecommunication | |||||||||
| Depreciation | |||||||||
| Office Expenses | |||||||||
| Insurance & Taxes | |||||||||
| Bank Charges | |||||||||
| Interest on L.T.D. | |||||||||
| Bad Debts | |||||||||
| Other | |||||||||
| Total Admin. Expenses ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| Research & Development ($) | |||||||||
| TOTAL EXPENSES ($) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | ||
| EXPENSES (%) | |||||||||
| Selling Salaries | |||||||||
| Traveling | |||||||||
| Advertising | |||||||||
| Shipping & Delivery | |||||||||
| Depreciation | |||||||||
| Other | |||||||||
| Total Sales Expenses (%) | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% | ||
| Management Salaries | |||||||||
| Office Salaries | |||||||||
| Professional Fees | |||||||||
| Telecommunication | |||||||||
| Depreciation | |||||||||
| Office Expenses | |||||||||
| Insurance & Taxes | |||||||||
| Bank Charges | |||||||||
| Interest on L.T.D. | |||||||||
| Bad Debts | |||||||||
| Other | |||||||||
| Total Admin Expenses (%) | |||||||||
| Research & Development (%) | |||||||||
| TOTAL EXPENSES (%) | |||||||||
| ASSUMPTIONS REGARDING EXPENSES | |||||||||
| HISTORICAL | 0.00 | 0.00 | 0.00 | PROJECTED | 0.00 | 0.00 | |||
| SALES ACTIVITIES | 10/1/18 | 10/1/19 | 10/1/20 | 12/31/99 | 10/1/21 | 10/1/22 | 10/1/23 | ||
| Total Sales | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Total Cost of Sales | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||
| Gross Profit | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Sales Expenses | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||
| Admin Expenses | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||
| R&D | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | |||
| Total Expenses | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| PROFITS / LOSS FROM OPERATIONS BEFORE AMORTIZATION AND TAX | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Amortization | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| PROFITS / LOSS FROM OPERATIONS BEFORE TAX | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Taxes | |||||||||
| Net income | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| NOTES TO INCOME STATEMENT | |||||||||
| 2024 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loan | ||||||||
| Accounts Receivable | Accounts Payable | ||||||||
| Inventory | Accruals | ||||||||
| Prepaid Expenses | Current Portion of L.T.D. | ||||||||
| Other | Income Taxes Payable | ||||||||
| Other | |||||||||
| Current Assets | $0.000 | Current Liabilities | $0.000 | ||||||
| Land | Term Debt | ||||||||
| Building | Shareholders' Advances | ||||||||
| Furniture & Fixtures | Other | ||||||||
| Equipment & Machinery | Non Current Liabilities | $0.000 | |||||||
| Other | |||||||||
| Net Fixed Assets | $0.000 | Common Shares | |||||||
| Preferred Shares | |||||||||
| Research & Development | Retained Earnings | ||||||||
| Other Assets | Contributed Surplus | ||||||||
| Other Assets | $0.000 | TOTAL SHAREHOLDERS' EQUITY | $0.000 | ||||||
| TOTAL ASSETS | $0.000 | LIABILITIES + S/H EQUITY | $0.00 | ||||||
| STATEMENT OF FINANCIAL POSITION (CON'T) | |||||||||
| 2025 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loan | ||||||||
| Accounts Receivable | Accounts Payable | ||||||||
| Inventory | Accruals | ||||||||
| Prepaid Expenses | Current Portion of L.T.D. | ||||||||
| Other | Income Taxes Payable | ||||||||
| Other | |||||||||
| Current Assets | $0.000 | Current Liabilities | $0.000 | ||||||
| Land | Term Debt | ||||||||
| Building | Shareholders' Advances | ||||||||
| Furniture & Fixtures | Other | ||||||||
| Equipment & Machinery | Non Current Liabilities | $0.000 | |||||||
| Other | |||||||||
| Net Fixed Assets | $0.000 | Common Shares | |||||||
| Preferred Shares | |||||||||
| Research & Development | Retained Earnings | ||||||||
| Other Assets | Contributed Surplus | ||||||||
| Other Assets | $0.000 | TOTAL SHAREHOLDERS' EQUITY | $0.000 | ||||||
| TOTAL ASSETS | $0.000 | LIABILITIES + S/H EQUITY | $0.000 | ||||||
| STATEMENT OF FINANCIAL POSITION (CON'T) | |||||||||
| 2026 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loan | ||||||||
| Accounts Receivable | Accounts Payable | ||||||||
| Inventory | Accruals | ||||||||
| Prepaid Expenses | Current Portion of L.T.D. | ||||||||
| Other | Income Taxes Payable | ||||||||
| Other | |||||||||
| Current Assets | $0.000 | Current Liabilities | $0.000 | ||||||
| Land | Term Debt | ||||||||
| Building | Shareholders' Advances | ||||||||
| Furniture & Fixtures | Other | ||||||||
| Equipment & Machinery | Non Current Liabilities | $0.000 | |||||||
| Other | |||||||||
| Net Fixed Assets | $0.000 | Common Shares | |||||||
| Preferred Shares | |||||||||
| Research & Development | Retained Earnings | ||||||||
| Other Assets | Contributed Surplus | ||||||||
| Other Assets | $0.000 | TOTAL SHAREHOLDERS' EQUITY | $0.000 | ||||||
| TOTAL ASSETS | $0.000 | LIABILITIES + S/H EQUITY | $0.000 | ||||||
| STATEMENT OF FINANCIAL POSITION (CON'T) | |||||||||
| 2027 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loan | ||||||||
| Accounts Receivable | Accounts Payable | ||||||||
| Inventory | Accruals | ||||||||
| Prepaid Expenses | Current Portion of L.T.D. | ||||||||
| Other | Income Taxes Payable | ||||||||
| Other | |||||||||
| Current Assets | $0.000 | Current Liabilities | $0.000 | ||||||
| Land | Term Debt | ||||||||
| Building | Shareholders' Advances | ||||||||
| Furniture & Fixtures | Other | ||||||||
| Equipment & Machinery | Non Current Liabilities | $0.000 | |||||||
| Other | |||||||||
| Net Fixed Assets | $0.000 | Common Shares | |||||||
| Preferred Shares | |||||||||
| Research & Development | Retained Earnings | ||||||||
| Other Assets | Contributed Surplus | ||||||||
| Other Assets | $0.000 | TOTAL SHAREHOLDERS' EQUITY | $0.000 | ||||||
| TOTAL ASSETS | $0.000 | LIABILITIES + S/H EQUITY | $0.000 | ||||||
| NOTES TO STATEMENT OF FINANCIAL POSITION | |||||||||
| 2025 | April | May | June | July | August | September | |||
| Collection of Sales | |||||||||
| Loans/ Investments | |||||||||
| Sale of Assets | |||||||||
| Other | |||||||||
| Total Source | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Purchases Payment | |||||||||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Utilities & Taxes | |||||||||
| Sales Expenses | |||||||||
| Administrative Expenses | |||||||||
| Interest | |||||||||
| Repayment of the Debt | |||||||||
| Other | |||||||||
| Total Application | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Surplus/ (Deficit) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Opening Cash Position | $0.000 | $0.000 | |||||||
| CASH / LOAN REQUIRED | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| 2025 (con't) | October | November | December | January | February | March | |||
| Collection of Sales | |||||||||
| Loans/ Investments | |||||||||
| Sale of Assets | |||||||||
| Other | |||||||||
| Total Source | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Purchases Payment | |||||||||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Utilities & Taxes | |||||||||
| Sales Expenses | |||||||||
| Administrative Expenses | |||||||||
| Interest | |||||||||
| Repayment of the Debt | |||||||||
| Other | |||||||||
| Total Application | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Surplus/ (Deficit) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Opening Cash Position | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| CASH / LOAN REQUIRED | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| CASH FLOW (CON'T) | |||||||||
| 2026 | April | May | June | July | August | September | |||
| Collection of Sales | |||||||||
| Loans/ Investments | |||||||||
| Sale of Assets | |||||||||
| Other | |||||||||
| Total Source | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Purchases Payment | |||||||||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Utilities & Taxes | |||||||||
| Sales Expenses | |||||||||
| Administrative Expenses | |||||||||
| Interest | |||||||||
| Repayment of the Debt | |||||||||
| Other | |||||||||
| Total Application | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Surplus/ (Deficit) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Opening Cash Position | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| CASH / LOAN REQUIRED | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| 2026 (con't) | October | November | December | January | February | March | |||
| Collection of Sales | |||||||||
| Loans/ Investments | |||||||||
| Sale of Assets | |||||||||
| Other | |||||||||
| Total Source | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Purchases Payment | |||||||||
| Direct Labour Wages | |||||||||
| Repairs & Maintenance | |||||||||
| Utilities & Taxes | |||||||||
| Sales Expenses | |||||||||
| Administrative Expenses | |||||||||
| Interest | |||||||||
| Repayment of the Debt | |||||||||
| Other | |||||||||
| Total Application | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Surplus/ (Deficit) | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| Opening Cash Position | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| CASH / LOAN REQUIRED | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | $0.000 | |||
| NOTES TO CASH FLOW | |||||||||
| 2024 | 2025 | ||||||||
| Land | |||||||||
| Building | |||||||||
| Equipment & Machinery | |||||||||
| Furniture & Fixtures | |||||||||
| Research & Development | |||||||||
| Total Assets | $0 | $0 | |||||||
| Working Capital | |||||||||
| Total Others | $0 | $0 | |||||||
| Existing Loan 1 | |||||||||
| Creditor | |||||||||
| Purpose | |||||||||
| Type | |||||||||
| Collateral | |||||||||
| Outstanding | |||||||||
| Maturity Date | |||||||||
| Interest Rate | |||||||||
| Repayment | |||||||||
| Existing Loan 2 | |||||||||
| Creditor | |||||||||
| Purpose | |||||||||
| Type | |||||||||
| Collateral | |||||||||
| Outstanding | |||||||||
| Maturity Date | |||||||||
| Interest Rate | |||||||||
| Repayment | 0 | ||||||||
| Existing Loan 3 | |||||||||
| Creditor | |||||||||
| Purpose | |||||||||
| Type | |||||||||
| Collateral | |||||||||
| Outstanding | |||||||||
| Maturity Date | |||||||||
| Interest Rate | |||||||||
| Repayment | 2 | ||||||||
| NOTES REGARDING FINANCIAL REQUIREMENTS | |||||||||
| HISTORICAL | PROJECTED | ||||||||
| Oct-20 | Oct-21 | Oct-22 | Oct-23 | ||||||
| Current Ratio | - 0 | - 0 | - 0 | - 0 | |||||
| Age of Accounts Receivable | - 0 | - 0 | - 0 | - 0 | |||||
| Inventory Turnover (times) | - 0 | - 0 | - 0 | - 0 | |||||
| Interest Coverage | - 0 | - 0 | - 0 | - 0 | |||||
| Total Debt to Equity (%) | - 0 | - 0 | - 0 | - 0 | |||||
| Return on Investment (%) | - 0 | - 0 | - 0 | - 0 | |||||
| Return on Assets (%) | - 0 | - 0 | - 0 | - 0 | |||||
| Asset Turnover (times) | - 0 | - 0 | - 0 | - 0 | |||||
| NOTES REGARDING PERFORMANCE INDICATORS | |||||||||
| DIRECTOR / BACKER Nº 1 | |||||||||
| LAST NAME | |||||||||
| FIRST NAME & INITIALS | |||||||||
| ADDRESS | |||||||||
| TELEPHONE: WORK | DATE OF BIRTH | ||||||||
| (if less than 3 years at present one) | |||||||||
| PRESENT EMPLOYER | PREVIOUS EMPLOYER | ||||||||
| EMPLOYER'S TELEPHONE | TELEPHONE | ||||||||
| HOW LONG IN CURRENT JOB? | HOW LONG? | ||||||||
| SALARY | SALARY | ||||||||
| FAMILY | |||||||||
| YOUR STATUS | |||||||||
| Nº OF DEPENDENTS | (excluding spouse) | ||||||||
| SPOUSE'S LAST NAME | SPOUSE'S EMPLOYER | ||||||||
| FIRST NAME | TELEPHONE | ||||||||
| DATE OF BIRTH | HOW LONG? | ||||||||
| OCCUPATION | SALARY | ||||||||
| FINANCIAL STATUS | SOURCE OF INCOME | ANNUAL AMOUNT | COMMENTS | ||||||
| 0 | |||||||||
| $0 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loans (owing) | ||||||||
| RRSP | Credit Cards | ||||||||
| Life Insurance (cash value) | Mortgages, etc. | ||||||||
| Real Estate (present value) | 0 | ||||||||
| Automobiles | 0 | ||||||||
| Stocks, bonds, etc. ($ value) | Total Liabilities | $0 | |||||||
| Household & Personal Effects | |||||||||
| 0 | |||||||||
| Total Assets | $0 | NET WORTH | $0 | ||||||
| DIRECTOR / BACKER Nº 2 | |||||||||
| LAST NAME | |||||||||
| FIRST NAME & INITIALS | |||||||||
| ADDRESS | |||||||||
| TELEPHONE: WORK | DATE OF BIRTH | ||||||||
| (if less than 3 years at present one) | |||||||||
| PRESENT EMPLOYER | PREVIOUS EMPLOYER | ||||||||
| EMPLOYER'S TELEPHONE | TELEPHONE | ||||||||
| HOW LONG IN CURRENT JOB? | HOW LONG? | ||||||||
| SALARY | SALARY | ||||||||
| FAMILY | |||||||||
| YOUR STATUS | |||||||||
| Nº OF DEPENDENTS | (excluding spouse) | ||||||||
| SPOUSE'S LAST NAME | SPOUSE'S EMPLOYER | ||||||||
| FIRST NAME | TELEPHONE | ||||||||
| DATE OF BIRTH | HOW LONG? | ||||||||
| OCCUPATION | SALARY | ||||||||
| FINANCIAL STATUS | SOURCE OF INCOME | ANNUAL AMOUNT | COMMENTS | ||||||
| Employment | |||||||||
| 0 | |||||||||
| $0 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loans (owing) | ||||||||
| RRSP | Credit Cards | ||||||||
| Life Insurance (cash value) | Mortgages, etc. | ||||||||
| Real Estate (present value) | 0 | ||||||||
| Automobiles | 0 | ||||||||
| Stocks, bonds, etc. ($ value) | Total Liabilities | $0 | |||||||
| Household & Personal Effects | |||||||||
| 0 | |||||||||
| Total Assets | $0 | NET WORTH | $0 | ||||||
| DIRECTOR / BACKER Nº 3 | |||||||||
| LAST NAME | |||||||||
| FIRST NAME & INITIALS | |||||||||
| ADDRESS | |||||||||
| TELEPHONE: WORK | DATE OF BIRTH | ||||||||
| (if less than 3 years at present one) | |||||||||
| PRESENT EMPLOYER | PREVIOUS EMPLOYER | ||||||||
| EMPLOYER'S TELEPHONE | TELEPHONE | ||||||||
| HOW LONG IN CURRENT JOB? | HOW LONG? | ||||||||
| SALARY | SALARY | ||||||||
| FAMILY | |||||||||
| YOUR STATUS | |||||||||
| Nº OF DEPENDENTS | (excluding spouse) | ||||||||
| SPOUSE'S LAST NAME | SPOUSE'S EMPLOYER | ||||||||
| FIRST NAME | TELEPHONE | ||||||||
| DATE OF BIRTH | HOW LONG? | ||||||||
| OCCUPATION | SALARY | ||||||||
| FINANCIAL STATUS | SOURCE OF INCOME | ANNUAL AMOUNT | COMMENTS | ||||||
| 0 | |||||||||
| $0 | |||||||||
| ASSETS | LIABILITIES | ||||||||
| Cash | Bank Loans (owing) | ||||||||
| RRSP | Credit Cards | ||||||||
| Life Insurance (cash value) | 0 | Mortgages, etc. | 0 | ||||||
| Real Estate (present value) | 0 | 0 | |||||||
| Automobiles | 0 | 0 | |||||||
| Stocks, bonds, etc. ($ value) | 0 | Total Liabilities | $0 | ||||||
| Household & Personal Effects | 0 | ||||||||
| Total Assets | $0 | NET WORTH | $0 | ||||||
| END OF SECTION 7. PLEASE PRINT THIS DOCUMENT AND | |||||||||
| INCLUDE IT IN THE APPENDIX OF THE BUSINESS PLAN | |||||||||
A&P
(You can find it here)
http://www.statcan.gc.ca/subjects-sujets/standard-norme/naics-scian/2007/list-liste-eng.htmSTART-UP OR LESS THAN 1 YEAR IN BUSINESS
IN BUSINESS OVER 1 YEAR
STATUS
PLEASE FILL IN THE FOLLOWING INFORMATION
HOME
HOME
HOME
Glossary
| [ ACCOUNTS PAYABLE] | ||
| Amounts owed by a business to its suppliers, usually as a result of credit purchases for inventory or services, other expenses (i.e. utilities), or taxes. | ||
| [ ACCOUNTS RECEIVABLE] | ||
| Amounts owed to you by your customers (under A/R Trade) or other entities (under Other). | ||
| [ ACCRUALS] | ||
| Amounts due to employees but not yet disbursed, sales tax collected but not yet sent on, etc. | ||
| [ ADMINISTRATIVE EXPENSES] | ||
| Operating costs incurred in the normal course of running a business, such as telephone, management and office salaries, professional fees, property taxes, etc. | ||
| [ AGE OF ACCOUNTS RECEIVABLE] | ||
| Financial ratio defined as 365 days divided by the accounts receivable turnover. To determine the latter, divide net credit sales by average accounts receivable. Compute average accounts receivable by adding opening and ending accounts receivable, divide the result by 2 | ||
| This ratio shows how fast a business is collecting from its customers. The higher the number, the longer it takes the business to receive payment, translating into a possible lack of working capital. | ||
| [ ASSET] | ||
| Anything owned by a person or a business that has commercial or exchange value. Assets may be tangible or intangible and may include accounts and notes receivable, cash, inventory, equipment, real estate, goodwill, etc. | ||
| [ ASSET TURNOVER] | ||
| Financial ratio defined as Sales divided by Total assets. It measures the business' use of assets to generate income, more specifically the level of capital investment relative to its sales volume. The higher the turnover, the more efficiently the business is managing its assets. | ||
| [ BOOK VALUE] | ||
| Value of an asset as shown on the statement of financial position. The book value takes into account depreciation and is often different from its market value. | ||
| [ BREAK-EVEN POINT] | ||
| The point in time at which a new business’ revenues (dollar volume of sales) equals its fixed and variable expenses. | ||
| [ BUDGET] | ||
| An estimate of future income and expenses over an accounting period (quarterly, yearly, etc.) used as a financial control for business. | ||
| [ BUSINESS FINANCING PLAN ] | ||
| An outline of the business goals, the purposes of its loans, and the benefits to the business resulting from the loans. It can also include summaries of historical, market and other data. | ||
| [ CAPITAL ] | ||
| The owner's equity in the business. It can take the form of the proprietor's or partners' capital, or, if incorporated, that of common stock, preferred shares and retained earnings. | ||
| [ CASH FLOW BUDGET ] | ||
| A spreadsheet of monthly inflows (e.g., earnings) and outflows (e.g., expenses) of cash in the business during an accounting period, usually 1 year. It helps a business plan its financial requirements. | ||
| [ CLOSING INVENTORY ] | ||
| Value of the total inventory or the number of units that a business has on hand at the end of the accounting period. | ||
| [ COGS ] | ||
| Abbreviated form of Cost of Goods Sold, also called Cost of Sales | ||
| [ CONTRIBUTED SURPLUS ] | ||
| Any capital contributed to a business other than through the issue of shares. It includes share redemption, donation from a shareholder, certain dividend transactions. | ||
| [ CORPORATION ] | ||
| Legal entity incorporated under federal or provincial legislation. This entity is distinct from parties or individuals that own it. Shareholders are not liable for debts or obligations of the corporation. | ||
| [ COST OF SALES ] / [ COST OF GOODS SOLD ] | ||
| Abbreviated as COGS, also called Cost of Sales. Direct cost of producing or providing the business' goods or services. It includes direct labour costs and production overhead plus opening inventory plus purchases less closing inventory. | ||
| [ CURRENT ASSETS ] | ||
| Cash and other assets that, in the normal course of operations, may be converted into cash, or consumed into the production of income within one year from the date of the Statement of Financial Position. They include cash, accounts receivable, allowance for doubtful accounts, inventory and prepaid expenses. | ||
| [ CURRENT INCOME TAX ] | ||
| Taxes on the income earned by your company that is payable within the next twelve months. | ||
| [ CURRENT LIABILITIES ] | ||
| Outstanding debts of the business that are payable within one year of the date of the Statement of Financial Position. They include a credit line, accounts payable, accruals (ex. sales tax collected), income tax and current portion of the long term debt. | ||
| [ CURRENT PORTION OF LONG-TERM DEBT ] | ||
| How much you will pay back on your loan (principal, not including interest) this fiscal year | ||
| [ CURRENT RATIO ] | ||
| Financial ratio defined as Currents assets divided by Current liabilities that measures the business' ability to meet its current obligations on time and to have funds available for its current operations. | ||
| [ DEPRECIATION ] | ||
| The decline of the value of equipment or other assets over time. Your accountant can help you choose the right method for the type of asset. | ||
| [ DEFERRED TAXES ] | ||
| Taxes that will not be paid until a later date. If a company uses a separate accounting method when calculating taxes, any difference between the two methods will be indicated here. | ||
| [ DISBURSEMENTS ] | ||
| Funds paid out of a business in settlement of obligations. | ||
| [ DIVIDENDS ] | ||
| Company earnings that are paid to stockholders | ||
| [ DRAWINGS ] | ||
| Withdrawals of assets (usually cash) from a business by a sole proprietor or a partner. | ||
| [ EQUIPMENT ] | ||
| All machinery and equipment used by the business to earn revenue. It has a limited lifespan and thus is subject to depreciation. | ||
| [ FINANCIAL STATEMENTS ] | ||
| Formal reports, prepared from accounting records, describing the financial position and performance of the business. They comprise the Statement of Financial Position, the Income Statement, the Statement of Changes in Financial Position. See also these definitions. | ||
| [ FIXED ASSETS ] | ||
| Also called capital assets. Property or equipment, not intended to be sold, owned by a business for use in its operations and expected to have a useful life of several fiscal periods. Included in this are land, buildings, vehicles, furniture and equipment. | ||
| [ FIXED COSTS ] | ||
| Amounts that do not vary with changes in the volume of sales or production (i.e. rent, depreciation, interest payments). | ||
| [ FORECAST ] | ||
| Estimate or prediction of future sales, expenditures, profits, etc | ||
| [ FREIGHT & OTHER DUTY ] | ||
| Under Cost of Goods Sold, these represent the amounts paid to transport goods from your suppliers | ||
| [ GROSS PROFIT ] | ||
| Net Sales less Cost of Goods Sold. It represents the profit made by the business before deducting selling, administrative and financial expenses. It helps to evaluate sales performance, buying policies, mark-ups, and inventory controls. | ||
| [ INCOME STATEMENT ] | ||
| Financial statement showing revenues, expenses and net income of a business over an accounting period. | ||
| [ INCORPORATION ] | ||
| Legal process of bringing a company into existence by filing appropriate documentation with federal or provincial legislation. | ||
| [ INTANGIBLE ASSETS ] | ||
| Assets that cannot be touched, weighed or measured. They cannot be used for payments of debts and include goodwill (probability that a regular customer will remain so), patent, trademark, incorporations costs. They may produce income and can be sold, that is why they are listed under assets. | ||
| [ INTEREST COVERAGE RATIO ] | ||
| Financial ratio defined as Income before interest and taxes divided by Interest expense. It reflects the number of times business income cover interest expenses and represents a safety margin for the business. | ||
| [ INVENTORY ] | ||
| Dollar value (cost or market, whichever is lower) of all stock of physical items that a business uses in its production process or has for sale. | ||
| [ INVENTORY TURNOVER ] | ||
| Financial ratio defined as Cost of goods sold divided by Average inventory. Compute average inventory by adding opening and ending inventory, divide the result by 2. It measures the number of times inventory has been sold in a given year. If it is low, it means that products are not selling well. | ||
| [ LABOUR EXPENSES ] | ||
| Total direct cost to the business for its employees during an accounting period. Includes actual wages paid and cost of all fringe benefits, unless listed separately. | ||
| [ LEASE ] | ||
| Legal contract covering the use of property drawn up between an owner (lessor) and a tenant (lessee) for a stated amount of money (rent) and for a specified length of time. | ||
| [ LEASEHOLD IMPROVEMENTS ] | ||
| Renovations and other improvements done to the leased property at the expense of the lessee. | ||
| [ LIABILITIES ] | ||
| Amounts owed by the business to its creditors, not necessarily to be paid immediately. An obligation to remit money or services at a future date, ex. accounts payable, loans. | ||
| [ LINE OF CREDIT ] | ||
| Agreement between a lender and a borrower under which the latter can borrow continuously up to a fixed maximum amount. | ||
| [ LONG-TERM LIABILITIES ] | ||
| Outstanding term loans less the current portion (see definition of Current Liabilities) that are not due within the next 12 months. | ||
| [ MARKET ] | ||
| A group of consumers that can be described in a specific way (e.g., men aged 25 to 35 with an annual income of over $40,000 and living in the Toronto area.) | ||
| [ MATERIAL PURCHASES ] | ||
| Under your Cost Of Sales, all goods that you buy that are directly related to producing your goods or services. | ||
| [ MARKET SEGMENT ] | ||
| Part of a market (e.g., men aged 25 to 35 with an annual income of over $40,000 who live in the Toronto area and are interested in the arts) | ||
| [ NAICS CODE ] | ||
| North American Industry Classification System -- a standardized system of 6-digit codes to identify industries in Canada, the U.S., and Mexico. It replaces the old 4-digit SIC. | ||
| [ NET PROFIT ] | ||
| Excess of all revenues over all expenses during the same accounting period. | ||
| [ NET PROFIT MARGIN ] | ||
| Net profit divided by sales; expressed as a percentage | ||
| [ NICHE ] | ||
| Part of a market segment (e.g., men aged 25 to 35 with an annual income of over $40,000 who live in the Toronto area and are interested specifically in performance arts) | ||
| [ NON-OPERATING ITEMS ] | ||
| Income or expenses that are not part of your company’s day to day operations, such as interest earned on investments. | ||
| [ OPENING INVENTORY ] | ||
| Value of total inventory or number of units a business has on hand at the opening of the accounting period. | ||
| [ OPERATING FORECAST ] | ||
| Anticipated earnings of a business determined by estimating sales and subtracting expected expenses. | ||
| [ OPERATING PROFIT (ALSO OPERATING INCOME) | ||
| Excess of revenue of a business over its expenses, excluding income derived from sources other than its regular activities, i.e. extraordinary income and expenses, income taxes, dividends, bonuses, withdrawals by owners. | ||
| [ OVERHEAD ] | ||
| Costs not directly attributable to the production of a good, ex. salary of factory manager, property taxes. | ||
| [ PARTNERSHIP ] | ||
| Form of business ownership in which two or more individuals (or companies) provide the equity capital for a business enterprise. Partners share in the profits as well as the losses of the business. | ||
| [ PREPAID EXPENSES ] | ||
| Expenses paid in advance during an accounting period (ex. a two-year insurance premium), part of which will be "used up" in the upcoming accounting period. The unused portion of the expense is considered a current asset and recorded as such on the Statement of Financial Position. | ||
| [ PROFESSIONAL FEES ] | ||
| Fees paid for professional services (for example, accountants, lawyers, or consultants). | ||
| [ PROFIT ] | ||
| Total revenue less total expenses for an accounting period calculated in accordance with generally accepted accounting principles. | ||
| [ PUBLIC SERVICES ] | ||
| Costs for services typically provided by public corporations, such as electricity, water, and gas. | ||
| [ RATIO ANALYSIS ] | ||
| Analysis that compares financial ratios of a business from one year to another to determine the change in performance over time; it also compares financial ratios of a business to that of other similar businesses or to that of its industry to determine its performance in relation to others. | ||
| [ REPAIRS & MAINTENANCE ] | ||
| Costs related to the upkeep of your equipment. You can estimate this from historical data, use a percentage of equipment cost, or use life cycle data or outsourced maintenance contract costs | ||
| [ RETAINED EARNINGS ] | ||
| Profits not spent or distributed among owners of a business but reinvested in it. | ||
| [ RETURN ON ASSETS ] | ||
| Financial ratio defined as Net income plus Interest expense (net of tax) divided by Total assets. It indicates how efficiently the business has used its available resources to generate income | ||
| [ RETURN ON INVESTMENT ] | ||
| Financial ratio defined as Net income after taxes divided by Average shareholders' equity. Compute the latter by adding opening and ending balances, divide the result by 2. It measures the profitability of the business for its shareholders. | ||
| [ REVENUE ] | ||
| Gross proceeds received by a business from the sale of goods or services during an accounting period. It also includes gains from the sale or exchange of assets, interest and dividends earned on investments and other increases in owner's equity. | ||
| [ SALARIES ] | ||
| Employees' salaries are generally listed separately from management's. It is also common practice to separate salaries that are related to production (put under Cost of Goods Sold), sales (put under Sales Expenses) and administration (put under Expenses). | ||
| [ SALES ] | ||
| Total value of goods sold or revenue from services rendered. Returns and discounts must be shown as a reduction from total sales. | ||
| [ SALES EXPENSES ] | ||
| Operating costs directly related to the selling of a product or service (selling salaries, commission, advertising, etc). | ||
| [ SERVICES & UTILITIES ] | ||
| Costs for services typically provided by public corporations, such as electricity, water, and gas. | ||
| [ SHAREHOLDERS EQUITY ] | ||
| Net assets (i.e., minus liabilities) that belong to owners of the business. | ||
| [ SHIPPING & DELIVERY ] | ||
| Under Expenses, costs related to shipping goods from your suppliers and to your clients. | ||
| [ SIC ] | ||
| Standard Industrial Classification (SIC) -- a system of 4-digiet codes for identifying various industries, divised in the U.S. in the 1930s. This has been replaced by the NAICS. | ||
| [ SOLE PROPRIETORSHIP ] | ||
| Form of business owned and operated by one individual who is responsible for the debts and obligations of the business. | ||
| [ STATEMENT OF CHANGES IN FINANCIAL POSITION ] | ||
| Financial statement showing the fluctuation of capital of a business over an accounting period. | ||
| [ STATEMENT OF FINANCIAL POSITION ] | ||
| Financial statement listing all assets, liabilities and equity of a business at a certain point in time. It provides a quick "snapshot" of a business. | ||
| [ TERM LOAN ] | ||
| Loan having a fixed term of repayment greater than one year, and a monthly or seasonal principal reduction schedule. | ||
| [ TOTAL DEBT-TO-EQUITY RATIO ] | ||
| Financial ratio defined as Total liabilities divided by Shareholders' equity. It measures the solvency of the business: if this ratio is high, the business is at higher risk of not meeting its obligations should a drop in sales occur. | ||
| [ VARIABLE COSTS ] | ||
| Expenses that vary directly with changes in the volume of sales or production, e.g. raw material costs and sales commissions. | ||
| [ WORKING CAPITAL] | ||
| Financial ratio defined as Current assets minus Current liabilities. It represents the amount of cash a business has to develop itself as opposed to the capital it has invested in fixed assets. A high ratio means the business can convert some assets into cash or obtain cash readily to meet its current obligations and represents a safety cushion for creditors. |
A
B
C
D
E
F
G
I
L
M
N
O
P
R
S
T
V
W
/xl/drawings/drawing3.xml#UserGuide!A1UserGuide
| There are 4 different types of companies in Canada: | ||||||
| Proprietorship | Simplest form of business, which offers relatively low start-up costs and few regulations, | |||||
| but where you are personally responsible for all debts and obligations. | ||||||
| Partnership | Each partner shares the profits and obligations; requires a partners/shareholders agreement. | |||||
| agreement | ||||||
| Corporation | A legal entity, entailing more regulations, higher startup costs, and higher taxes, but | |||||
| where shareholders have limited responsibility for the debts and obligations of the | ||||||
| company | ||||||
| Co-operative | A corporation controlled by its members | |||||
| The SIC / NAICS codes are used to identify your industry sector. More information | ||||||
| can be found here. | ||||||
| Under Sales Activities, enter the products or services you will sell. (You can have up to 5 categories of | ||||||
| products or services; many companies use only 1 or 2. This is not a product list, but a logical division of | ||||||
| your product mix. It might help to divide them by source of revenue, product line, production methods, etc. | ||||||
| - | For example, instead of 1) strawberry jam, 2) apricot jam, 3) blueberry jam, 4) peanut butter, | |||||
| 5) almond butter, and 6) hazlenut spread, try 1) jams and 2) nut-based products. | ||||||
| Establish expected sales, in dollars, for the next 3 years using the strategies and activities you set in | ||||||
| your Sales and Marketing Plan. If you are already in operations, also provide sales levels for the last 3 | ||||||
| years; they will help you set future sales levels. | ||||||
| Write down the implicit and explicit assumptions you have been using. For example, if your sales targets | ||||||
| assume an increase of 20%, you would indicate that it is due to a planned promotional campaign. If you | ||||||
| assume no new product from your competitors, include it here. This process is useful to verify that your | ||||||
| sales levels are realistic. | ||||||
| It may be a good idea to seek advice from your accountant when developing your business plan. Be sure | ||||||
| to go over the plan together, as it is you, and not your accountant, who will be seeking financing and who | ||||||
| will be explaining the plan to your banker or investor. | ||||||
| Ensure that all of the decisions made in the previous sections appear in your financial plan. Too often, we | ||||||
| forget that our great advertising and promotional campaigns, along with the benefits we offer employees as | ||||||
| an incentive to stay with us, all have a cost! | ||||||
| Historical | ||||||
| Use your financial (audited if possible) statements to fill out this section. Totals and sub-totals | ||||||
| are computed automatically. | ||||||
| Assumptions | Use this section to comment on and explain (give % of growth, ratios, etc.) the financial | |||||
| evolution of your business. Explain why things (negative or positive) have happened and | ||||||
| their impact on your financial results. | ||||||
| Describe from your historical data the elements on which you rely for your future projects; | ||||||
| the bases on which you are building your future. | ||||||
| Projected | ||||||
| Based on your plans (sales and marketing, human resources and operating), forecast the evolution of your | ||||||
| business over the next two years. This is where the results of your plan and actions are seen. | ||||||
| The assumptions you make are critical to these projected figures and it is at this level that you may have to | ||||||
| generate different versions of your plan reflecting the different sales and costs scenarios. | ||||||
| Totals and sub-totals computed automatically. | ||||||
| Assumptions | Your projected figures will be based on two key elements: your sales objectives and the | |||||
| costs of your planned activities. | ||||||
| Some costs (e.g. purchase of equipment) and sales estimates (orders known in advance | ||||||
| from a good client for example) can be done easily. Use real figures as much as possible. | ||||||
| Often you will have to use hypotheses or make assumptions: | ||||||
| - | historical information (trend in revenues will continue, average annual growth | |||||
| rate of last five years will be used for the coming two years, etc.); | ||||||
| - | adjusted historical information: last year's growth rate + x% because market | |||||
| conditions have changed or because we plan to launch a new product, etc; | ||||||
| - | ratios: industry or market or company specific ratios (e.g. advertising is 3% | |||||
| of sales; fringe benefits and programs are 30-40% of salaries paid); | ||||||
| - | comparison: our company intends to follow the evolution of company Y; | |||||
| - | market data: the market will grow at x%, our revenues will grow at y% ( or | |||||
| x% + z% because we expect to gain market shares); we expect to have a | ||||||
| x% market share of a total $X market size. | ||||||
| Remember that your assumptions must be relevant; evaluate their strength. These assumptions will add | ||||||
| credibility to your numbers. | ||||||
| Present your historical sales figures (and your projected sales) on a product (or product line) or a region | ||||||
| (market, segment) basis. It is often easier to project sales from a 'smaller' unit (product or region) than from | ||||||
| the larger unit (total sales). | ||||||
| If your business is a startup, please provide the assumptions that explain your sales forecasts. | ||||||
| For a new business, it can be easier to use a bottom-up method: determine the expected sales for each | ||||||
| product in each region and add up these numbers. You can use the market size you established earlier to | ||||||
| test your figures. | ||||||
| Also referred to as cost of goods sold (COGS) or variable costs since they vary with your level of | ||||||
| production (they increase if production and sales increase). | ||||||
| These are the costs incurred to generate sales levels. For a goods producing business, this | ||||||
| means material costs such as inventory and raw materials, direct labour costs (employees | ||||||
| involved in production, for example), repair and maintenance costs for machinery (usually | ||||||
| calculated based on a percentage of equipment cost), utilities, and so on. For a service | ||||||
| business, this section includes costs related to personnel, utilities and taxes. | ||||||
| You can use a constant ratio of costs/sales over time, based on past performance or industry | ||||||
| data. This ratio tends to be quite steady over the years, but you can lower it with productivity | ||||||
| gains -- for example. more productive machinery, a simpler layout, ISO norms, or better | ||||||
| organization. | ||||||
| These are the fixed costs of running your business -- basically, everything aside from costs | ||||||
| related to production or sales. When they increase or decrease, it is usually as a lump sum. | ||||||
| They include management and office salaries (as opposed to direct labour costs included in the | ||||||
| cost of goods sold), professional fees (lawyer, accountant, and the like), telecommunications, | ||||||
| office supplies, insurance and taxes, advertising & promotion, depreciation, bank charges, | ||||||
| interest expenses related to long term debt and bad debts incurred by your business. | ||||||
| Factors that can affect these expenses | ||||||
| - | new machinery (impact on interest paid on long-term debt) | |||||
| - | new administrative employees | |||||
| - | expenses related to ISO implementation | |||||
| - | new software | |||||
| You should enter other income or special expenses not included in the prior sections. From this | ||||||
| information, and the sales, cost of goods sold and expenses entered previously, BDC Business | ||||||
| Plan automatically computes operating profit, net profit and cash flow from operations. | ||||||
| Depending on the results, you may want to elaborate different scenarios or change your | ||||||
| assumptions. Save your business plan under separate names if you want to produce different | ||||||
| scenarios from optimistic to pessimistic. Remember that these scenarios will affect the results | ||||||
| in the Statement of Financial Position estimates and in the Cash Flow Budget. | ||||||
| Based on other estimates, you should be in a position to estimate: | ||||||
| - | other income (revenues from interest, asset disposition for example) | |||||
| - | taxes (current and deferred) using current federal and provincial rates; | |||||
| - | depreciation expenses (based on a percentage of the asset's value) | |||||
| - | dividends to be paid out to shareholders | |||||
| The Statement of Financial Position indicates the assets, debts and capital of your business. | ||||||
| The projected Statement of Financial Position is a result of the assumptions and the situations portrayed in the | ||||||
| Income Statement (and, consequently, of sales, COGS and expenses). It should therefore be | ||||||
| developed when you are satisfied with the results of your Income Statement. | ||||||
| If you are operating a new business, you can use industry ratios and adjust them according to | ||||||
| investments in equipment (assets) and its effect on long-term debt (liabilities). | ||||||
| -For more information on industry ratios, | click here. | |||||
| If your business has been in operations for a few years, you can use historical ratios applied to | ||||||
| the new projected sales figures (they usually follow a similar pattern). Obviously, new investments | ||||||
| must be taken into account. | ||||||
| You can also increase current assets and current liabilities (which are short-term) by the percentage | ||||||
| of sales growth you forecast in your projected Income Statement, since they, too, often follow a | ||||||
| similar trend and pattern. | ||||||
| In current liabilities, you can estimate the expected annual repayment of long term debt you | ||||||
| intend to make. | ||||||
| Special projects and equipment or technology expenditures should be incorporated into long | ||||||
| term assets (net fixed assets) to reflect the long term nature of their contribution to the | ||||||
| company’s ongoing operations. Be sure to subtract the estimated accumulated amortization. | ||||||
| For long term liabilities, take last year's Statement of Financial Position number plus the borrowing you intend to | ||||||
| do minus the repayments in the current year. | ||||||
| Total Assets vs. Total Liabilities | ||||||
| On a Statement of Financial Position, these two must be the same. | ||||||
| A positive or a negative cash flow will determine how your business will use its loans. | ||||||
| A positive cash flow means that your business can meet its short term obligations. A negative | ||||||
| cash flow means that you will use short-term financing (line of credit, working capital, personal | ||||||
| investment). | ||||||
| A cash flow budget will allow you to foresee, month by month, how much you will need and | ||||||
| when you will need it. This budget has to be completed on a monthly basis for the next 2 | ||||||
| years of operations. | ||||||
| It is important to measure the impact of your scenarios set earlier in the Income Statement | ||||||
| on this budget. You may need to move some activities to other months to take into account | ||||||
| seasonality of sales, necessary investments or cash disbursements. | ||||||
| All sources of funds must be listed in the month they are expected to be received: | ||||||
| - | Collection of sales (this should follow the seasonality of sales) | |||||
| - | Interest and revenue on loans and investments | |||||
| - | Sale of assets (usually a lump sum) | |||||
| - | Others (paybacks/rebates from suppliers, interests on credit terms to clients, | |||||
| recuperation of bad debts, etc.) This amount should be small compared to sales. | ||||||
| All expenses must be listed in the month they are expected to be disbursed: | ||||||
| - | Purchase payments (raw materials, finished products, equipment and tools, | |||||
| general operating expenses) | ||||||
| - | Salaries when paid (consider number of pays in the month) | |||||
| - | Repayment of debt (capital and interest) | |||||
| - | Other expenses listed under Expenses. | |||||
| Be sure to take into account any seasonal changes, the number of employees, the timetable for | ||||||
| purchasing raw materials and small equipment, and so on. And remember that some sales made | ||||||
| in month X might not be paid in the same month; this is true for some expenses, depending on | ||||||
| the credit terms you negotiate.. | ||||||
| Annual payments (taxes for example) can be divided in twelve equal payments. | ||||||
| A surplus allows your business to invest, purchase equipment, pay back loans or reward | ||||||
| shareholders; a deficit will require the use of a short-term loan or a personal investment. | ||||||
| In this section, you list what financing you will require and why – either for purchasing assets | ||||||
| such as land, building, equipment, or furniture, for R&D, or for short-term working capital. | ||||||
| Assets | List all long-term assets (land, equipment, etc) you intend to buy | |||||
| in the coming two years to achieve your sales target.You should also | ||||||
| include shorter-term assets such as investments by shareholders, | ||||||
| inflow of working capital, etc. | ||||||
| Notes | Detail the financing you have secured, including the financial institution, | |||||
| the purpose of the loan (equipment, for example), and the type of loan | ||||||
| (term loan, venture capital, etc). You should also give the capital left | ||||||
| to be repaid, the maturity date, the interest rate, and your repayment | ||||||
| schedule. | ||||||
| BDC Business Plan automatically computes major accounting ratios based on numbers entered | ||||||
| on previous forms (Statement of Financial Position and Income Statements), | ||||||
| You will use these results as benchmarks to compare your recent performance to the average of | ||||||
| the last 3 years. Your banker will compare your ratios to industry averages to get a clear picture | ||||||
| of your financial plan. | ||||||
| Visit BDC's website for more information. | ||||||
| Give the personal status of your company’s principals (up to 3) and their families. This information | ||||||
| allows your banker to understand you better; it also provides information on the resources you | ||||||
| can make available to your business. | ||||||
| For first-time entrepreneurs, this section provides information on your background and your | ||||||
| abilities to manage your new business. | ||||||
| Income | Indicate all sources and amounts and identify them as regular or temporary | |||||
| Assets | Show balance in cash (and current account, i.e. highly liquid assets), in | |||||
| RRSPs, the purchase value of life insurance policies, the value of | ||||||
| automobiles and effects such as furniture, and the book value of investments. | ||||||
| Liabilities | Show balance and outstanding amounts for all loans. | |||||
Data
| 1990 |
| 1991 |
| 1992 |
| 1993 |
| 1994 |
| 1995 |
| 1996 |
| 1997 |
| 1998 |
| 1999 |
| 2000 |
| 2001 |
| 2002 |
| 2003 |
| 2004 |
| 2005 |
| 2006 |
| 2007 |
| 2008 |
| 2009 |
| 2010 |
| 2011 |
| 2012 |
| 2013 |
| 2014 |
| 2015 |
| 2016 |
| 2017 |
| 2018 |
| 2019 |
| 2020 |
| 2021 |
| 2022 |
| 2023 |
| 2024 |
| 2025 |
| 2026 |
| 2027 |
| 2028 |
| 2029 |
| 2030 |
