Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
128x Filetype XLSX File size 0.17 MB Source: assets.ctfassets.net
Sheet 1: Cover
| Financial Model Template | ||||||||||||||||||
| OVERVIEW | ||||||||||||||||||
| Company Name | Company X | |||||||||||||||||
| Financial year end | 31-Jul | |||||||||||||||||
| First forecast month | Aug-21 | |||||||||||||||||
| Last forecast month | Jul-24 | |||||||||||||||||
| Frequency | Monthly | |||||||||||||||||
| Currency | NZ$ | |||||||||||||||||
| The model uses Revenue, Cost and Cashflow assumptions (to be inputted in the 'Assumptions - monthly' sheet) to create Profit & Loss and Cashflow summaries. Additional notes supporting the assumptions are provided at the bottom of the 'Assumptions - monthly' sheet. The model aims to be simple, functional and user friendly. It has the functionality to capture 36 months (3 years) of forecasts for a business operating in up to two markets, with two products. |
||||||||||||||||||
| DISCLAIMER | ||||||||||||||||||
| Important notice We have not sought to verify the accuracy or reasonableness of any data, information, assumptions and explanations provided by [company name] (you) or another source contained in the [model name] (Model). No undertaking, representation, warranty or other assurance, expressed or implied, is made or given by or on behalf of NZTE as to the quality, suitability, accuracy, reasonableness or the completeness of the information contained in the Model, the integrity of the Model itself or NZTE’s work on it. We are not responsible for any errors or misstatements in, or omission from, the Model. Use of the Model is entirely at your own risk. Please note that the Model has not been independently reviewed or audited including (for the avoidance of doubt): (a) the way tax has been calculated or realised; (b) balance sheet calculations; (c) cell referencing and any formula used in the Model (and the accuracy of these); or (d) the robustness of the assumptions and forecasts contain within the Model. Provision of this Model by NZTE does not constitute legal, financial or business advice. You must obtain this independently. NZTE will not be liable for any loss, cost, or expense you and/or any third parties suffer or incur arising directly or indirectly from the use of, or reliance on, the Model. Intellectual property rights in data provided to NZTE by you or that you put into the Model (Pre-existing IP) remains owned by you. All intellectual property rights in the Model other than the Pre-Existing IP become the property of NZTE as they arise and continue to be held by NZTE. To the extent NZTE holds intellectual property rights in the Model, it grants you a non-exclusive, perpetual, royalty free licence to use the Model. You must not present the Model to any third party as an NZTE model. |
||||||||||||||||||
| INSTRUCTIONS FOR USER | ||||||||||||||||||
| - Only change cells which are formatted: | xxx | |||||||||||||||||
| - Insert assumptions in the 'Assumptions' tab | ||||||||||||||||||
| - Provide supporting notes in the 'Assumptions' tab | ||||||||||||||||||
| GUIDANCE NOTES ON FINANCIAL MODELS | ||||||||||||||||||
| A financial model is a tool used to forecast a company’s financial future. Here’s a handful of tips for you to consider. 1. A financial model should enable a manager and/or investor to clearly identify: a. Key revenue drivers and assumptions. A financial model should provide granular revenue information on the business’ current and future revenue projections – e.g. volumes and prices by product, customer and/or geography. The more granular the breakdown, the more information an investor has to make an informed valuation decision. Commentary should be provided regarding the key ‘step-changes’ in the model e.g. new product launches and new markets etc. b. The cost assumptions supporting a company’s growth strategy. The cost assumptions need to align with the company’s revenue projections e.g. if a company is forecasting to generate revenue in a new market, there should be an increase in labour costs leading up to the step-change in revenue. Generally, companies incorrectly forecast the costs required to support large revenue increases – such as, research & development, sales & marketing, administration etc. Costs should be separated into variable costs and fixed overheads and represent the costs of getting a company’s product to the customer. c. Potential cashflow shortfalls and capital requirements. A financial model should track a company’s cash balance, its cash conversion cycle and identify when potential cashflow shortfalls may occur. This also helps identify and address/plan capital requirements. d. Use of funds raised. For each capital raise, a financial model needs to clearly show how the invested capital is going to be used (which is consistent with investment documents). 2. A financial model must align with a company’s business model and the long-term strategy that is articulated in the investment documents – e.g. New product launches and new markets must be reflected in both the model and supporting documents. 3. A financial model should be structured so a user can easily change key assumptions – such as volume and price forecasts – so they can see how these assumptions impact a company’s growth prospects. 4. A financial model must be well presented, summarised and easy to use and update. For key assumptions, it is useful to record the source of the assumption and when it was last updated. |
||||||||||||||||||
| Company X | |||||||||||||||||||||||||||||||||||||||||
| ASSUMPTIONS | Starting | 1-Aug-21 | 1-Sep-21 | 1-Oct-21 | 1-Nov-21 | 1-Dec-21 | 1-Jan-22 | 1-Feb-22 | 1-Mar-22 | 1-Apr-22 | 1-May-22 | 1-Jun-22 | 1-Jul-22 | 1-Aug-22 | 1-Sep-22 | 1-Oct-22 | 1-Nov-22 | 1-Dec-22 | 1-Jan-23 | 1-Feb-23 | 1-Mar-23 | 1-Apr-23 | 1-May-23 | 1-Jun-23 | 1-Jul-23 | 1-Aug-23 | 1-Sep-23 | 1-Oct-23 | 1-Nov-23 | 1-Dec-23 | 1-Jan-24 | 1-Feb-24 | 1-Mar-24 | 1-Apr-24 | 1-May-24 | 1-Jun-24 | 1-Jul-24 | Notes | |||
| Ending | 31-Aug-21 | 30-Sep-21 | 31-Oct-21 | 30-Nov-21 | 31-Dec-21 | 31-Jan-22 | 28-Feb-22 | 31-Mar-22 | 30-Apr-22 | 31-May-22 | 30-Jun-22 | 31-Jul-22 | 31-Aug-22 | 30-Sep-22 | 31-Oct-22 | 30-Nov-22 | 31-Dec-22 | 31-Jan-23 | 28-Feb-23 | 31-Mar-23 | 30-Apr-23 | 31-May-23 | 30-Jun-23 | 31-Jul-23 | 31-Aug-23 | 30-Sep-23 | 31-Oct-23 | 30-Nov-23 | 31-Dec-23 | 31-Jan-24 | 29-Feb-24 | 31-Mar-24 | 30-Apr-24 | 31-May-24 | 30-Jun-24 | 31-Jul-24 | |||||
| FY | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | |||||
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | |||||
| REVENUE | |||||||||||||||||||||||||||||||||||||||||
| Market 1 | |||||||||||||||||||||||||||||||||||||||||
| Product 1 | |||||||||||||||||||||||||||||||||||||||||
| Units | # | 200 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 1 | |||
| Price | NZ$ | $500.00 | $525.00 | $551.25 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | $578.81 | ||||
| Revenue | NZ$ | $100,000 | $262,500 | $275,625 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | ||||
| Product 2 | 3, 4 | ||||||||||||||||||||||||||||||||||||||||
| Units | # | 5 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 1 | |||
| Price | NZ$ | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | $1,000.00 | ||||
| Revenue | NZ$ | $5,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | ||||
| Market 1 units | # | 205 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | 550 | ||||
| Market 1 Revenue | NZ$ | $105,000 | $312,500 | $325,625 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | $339,406 | ||||
| Market 2 | 2 | ||||||||||||||||||||||||||||||||||||||||
| Product 1 | |||||||||||||||||||||||||||||||||||||||||
| Units | # | 100 | 250 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | 1 | |||
| Price | NZ$ | $400.00 | $500.00 | $550.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | $600.00 | ||||
| Revenue | NZ$ | $40,000 | $125,000 | $137,500 | $150,000 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| Product 2 | |||||||||||||||||||||||||||||||||||||||||
| Units | # | 10 | 120 | 250 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 1 | |||
| Price | NZ$ | $800.00 | $1,000.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | ||||
| Revenue | NZ$ | $8,000 | $120,000 | $300,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | ||||
| Market 2 units | # | 110 | 370 | 500 | 750 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| Market 2 Revenue | NZ$ | $48,000 | $245,000 | $437,500 | $750,000 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| Product 1 Revenue | NZ$ | $140,000 | $387,500 | $413,125 | $439,406 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| Product 2 Revenue | NZ$ | $13,000 | $170,000 | $350,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | $650,000 | ||||
| Other Revenue | NZ$ | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | 5 | |||
| Total Revenue | NZ$ | $158,000 | $562,500 | $768,125 | $1,094,406 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| REVENUE BY MARKET | |||||||||||||||||||||||||||||||||||||||||
| REVENUE BY PRODUCT | |||||||||||||||||||||||||||||||||||||||||
| PRODUCTION COSTS (part of Cost of Goods Sold) | 6 | ||||||||||||||||||||||||||||||||||||||||
| Production costs - Product 1 (% of Revenue) | % | 40.0% | 40.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | 30.0% | ||||
| Production costs - Product 1 | NZ$ | $56,000 | $155,000 | $123,938 | $131,822 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| Production costs - Product 2 (% of Revenue) | % | 30.0% | 30.0% | 30.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | ||||
| Production costs - Product 2 | NZ$ | $3,900 | $51,000 | $105,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | $130,000 | ||||
| Production costs - Other Revenue (% of Revenue) | % | 30.0% | 30.0% | 30.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | 20.0% | ||||
| Production costs - Other Revenue | NZ$ | $1,500 | $1,500 | $1,500 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | ||||
| Total production costs | NZ$ | $61,400 | $207,500 | $230,438 | $262,822 | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | #NAME? | ||||
| WAGES | 6 | ||||||||||||||||||||||||||||||||||||||||
| Direct Wages (part of Cost of Goods Sold) | |||||||||||||||||||||||||||||||||||||||||
| Sales | |||||||||||||||||||||||||||||||||||||||||
| Member 1 | NZ$ | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | $9,250 | ||||
| Member 2 | NZ$ | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | $7,917 | ||||
| Member 3 | NZ$ | $- | $- | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | $8,750 | ||||
| Member 4 | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | ||||
| Team 1 | |||||||||||||||||||||||||||||||||||||||||
| Member 1 | NZ$ | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | ||||
| Member 2 | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Member 3 | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Member 4 | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | ||||
| Team 2 | |||||||||||||||||||||||||||||||||||||||||
| Member 1 | NZ$ | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | ||||
| Member 2 | NZ$ | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | ||||
| Member 3 | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Member 4 | NZ$ | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | ||||
| Total Direct Wages | NZ$ | $78,417 | $78,417 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | ||||
| Indirect Wages (part of Overheads) | |||||||||||||||||||||||||||||||||||||||||
| Management | |||||||||||||||||||||||||||||||||||||||||
| CEO | NZ$ | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | ||||
| General Manager | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Other | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Total Indirect Wages | NZ$ | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | ||||
| Total Wages | NZ$ | 101,333 | 101,333 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | 110,083 | ||||
| ADDITIONAL OVERHEAD EXPENSES | 6 | ||||||||||||||||||||||||||||||||||||||||
| Consultancy fees | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | ||||
| Insurance | NZ$ | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | ||||
| Legal & Accounting fees | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | ||||
| Advertising | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | ||||
| Marketing expenses | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | ||||
| Occupancy costs | NZ$ | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | ||||
| Research & Development | NZ$ | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | 7 | |||
| Other | NZ$ | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | ||||
| CASH FLOW | |||||||||||||||||||||||||||||||||||||||||
| Opening bank balance | NZ$ | $100,000 | |||||||||||||||||||||||||||||||||||||||
| +/- Movements in working capital | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | 8, 9 | |||
| + Equity raise | NZ$ | $1,000,000 | $1,000,000 | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | ||||
| +/- change in debt | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | 10 | |||
| - Interest | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | 10 | |||
| - Corporate Tax | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | ||||
| - Capital expenditure | NZ$ | $- | $- | $- | $- | $- | $- | $- | $- | $2,000,000 | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | $- | 11 | |||
| NOTES: | |||||||||||||||||||||||||||||||||||||||||
| Insert relevant commentary supporting the assumptions above e.g. market share statistics, staff numbers, manufacturing costs, revenue channels etc. | |||||||||||||||||||||||||||||||||||||||||
| Example notes and questions | |||||||||||||||||||||||||||||||||||||||||
| 1. What is driving the unit numbers in the assumptions above? What are the channels used to sell units? E.g online, direct, distribution | |||||||||||||||||||||||||||||||||||||||||
| 2. Why are you targeting the next market. Have you validated the market? Do you have a relationship with key customers? Have you completed market research? | |||||||||||||||||||||||||||||||||||||||||
| 3. What new product development (NPD) is in the pipeline? Where is the company going? What is next? | |||||||||||||||||||||||||||||||||||||||||
| 4. What is the lag time between R&D/HR investment and the revenue impact of this? | |||||||||||||||||||||||||||||||||||||||||
| 5. What are the other sources of revenue? E.g. grants etc. | |||||||||||||||||||||||||||||||||||||||||
| 6. Are costs scaled proportionately to revenue and take into account any economies of scale efficiencies? | |||||||||||||||||||||||||||||||||||||||||
| 7. Has R&D for NPD been factored in as an expense or capital item? are you committing a % of revenue to R&D? or is it on a project by project basis? | |||||||||||||||||||||||||||||||||||||||||
| 8. Are there any movements in working capital (accounts receivable/accounts payable) that are unique to your business, industry and/or customers/suppliers? | |||||||||||||||||||||||||||||||||||||||||
| 9. Monthly movement in working capital to be entered - assumes that positive a movement is a use of cash, while a negative movement is a receipt of cash | |||||||||||||||||||||||||||||||||||||||||
| 10. Do you have any debt? What are the key debt terms and are you correctly capturing any repayments or interest payments in the cashflow | |||||||||||||||||||||||||||||||||||||||||
| 11. What capital expenditure is planned over the next five years? Does this align with your growth plan? | |||||||||||||||||||||||||||||||||||||||||
| Company X | ||||||||||||||||||||||||||||||||||||||||
| PROFIT & LOSS - monthly | Starting | 1-Aug-21 | 1-Sep-21 | 1-Oct-21 | 1-Nov-21 | 1-Dec-21 | 1-Jan-22 | 1-Feb-22 | 1-Mar-22 | 1-Apr-22 | 1-May-22 | 1-Jun-22 | 1-Jul-22 | 1-Aug-22 | 1-Sep-22 | 1-Oct-22 | 1-Nov-22 | 1-Dec-22 | 1-Jan-23 | 1-Feb-23 | 1-Mar-23 | 1-Apr-23 | 1-May-23 | 1-Jun-23 | 1-Jul-23 | 1-Aug-23 | 1-Sep-23 | 1-Oct-23 | 1-Nov-23 | 1-Dec-23 | 1-Jan-24 | 1-Feb-24 | 1-Mar-24 | 1-Apr-24 | 1-May-24 | 1-Jun-24 | 1-Jul-24 | |||
| Ending | 31-Aug-21 | 30-Sep-21 | 31-Oct-21 | 30-Nov-21 | 31-Dec-21 | 31-Jan-22 | 28-Feb-22 | 31-Mar-22 | 30-Apr-22 | 31-May-22 | 30-Jun-22 | 31-Jul-22 | 31-Aug-22 | 30-Sep-22 | 31-Oct-22 | 30-Nov-22 | 31-Dec-22 | 31-Jan-23 | 28-Feb-23 | 31-Mar-23 | 30-Apr-23 | 31-May-23 | 30-Jun-23 | 31-Jul-23 | 31-Aug-23 | 30-Sep-23 | 31-Oct-23 | 30-Nov-23 | 31-Dec-23 | 31-Jan-24 | 29-Feb-24 | 31-Mar-24 | 30-Apr-24 | 31-May-24 | 30-Jun-24 | 31-Jul-24 | ||||
| FY | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | ||||
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | ||||
| Revenue | ||||||||||||||||||||||||||||||||||||||||
| Market 1 - Product 1 | NZ$ | $100,000 | $262,500 | $275,625 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | $289,406 | |||
| Market 1 - Product 2 | NZ$ | $5,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | $50,000 | |||
| Market 2 - Product 1 | NZ$ | $40,000 | $125,000 | $137,500 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | $150,000 | |||
| Market 2 - Product 2 | NZ$ | $8,000 | $120,000 | $300,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | $600,000 | |||
| Other Revenue | NZ$ | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |||
| Total Revenue | NZ$ | $158,000 | $562,500 | $768,125 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | $1,094,406 | |||
| % change | % | NA | 256% | 37% | 42% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |||
| Cost of Goods Sold | ||||||||||||||||||||||||||||||||||||||||
| Production costs | NZ$ | $61,400 | $207,500 | $230,438 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | $262,822 | |||
| Direct wages | NZ$ | $78,417 | $78,417 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | $87,167 | |||
| Gross profit | NZ$ | $18,183 | $276,583 | $450,521 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | $744,418 | |||
| Margin | % | 12% | 49% | 59% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | 68% | |||
| % change | % | NA | 1421% | 63% | 65% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |||
| Overheads | ||||||||||||||||||||||||||||||||||||||||
| Indirect wages | NZ$ | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | $22,917 | |||
| Consultancy fees | NZ$ | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | $8,333 | |||
| Insurance | NZ$ | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |||
| Legal & Accounting fees | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | |||
| Advertising | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | |||
| Marketing expenses | NZ$ | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | $4,167 | |||
| Occupancy costs | NZ$ | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |||
| Research & Development | NZ$ | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |||
| Other | NZ$ | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | $833 | |||
| Total expenses | NZ$ | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | $50,417 | |||
| EBITDA | NZ$ | ($32,233) | $226,167 | $400,104 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | $694,001 | |||
| Margin | % | (20%) | 40% | 52% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | 63% | |||
| % change | % | NA | NA | 77% | 73% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | |||
| SUMMARY | ||||||||||||||||||||||||||||||||||||||||
no reviews yet
Please Login to review.
