Single New Business Model
Important Notices:
Sales are currently suspended. We appreciate your understanding.
The “E-Commerce Single Financial Forecast Model” was created with the assumption that a company will start a new business. This is an example of a single new business project dealing with multiple products.
Here, we will create a financial forecast model that assumes the online sales business of PCs. We purchase PCs from multiple PC manufacturers and plan to sell them on our website.
The first is a top-down analysis that performs estimation calculations from assumptions of market demand. It is a huge merit to be able to judge how much sales can be expected every year from the viewpoint of market demand, and what factors are affecting sales. This is a particularly important analysis for businesses where product supply meets market demand.
The second is bottom-up analysis, which is an estimation calculation based on the assumption of production and supply. By understanding the maximum supply (i.e., maximum sales volume) in terms of production and supply, you can estimate the maximum sales. In the case of in-house production, it is also an advantage that the cost of sales can be calculated in detail. This is a particularly important analysis for businesses where product supply does not meet market demand, that is insufficient supply.
The third is a consolidated model that effectively combines the two analyzes performed above to output more realistic results. It is useful for building a management strategy that considers both market demand and field operation. Improving business judgment is key to success, as sharp insights are essential to problem solving at this stage.
The fourth is, as a reference, a method of making future financial forecasts on the assumption that the company’s financial statements are at hand. This is called year-on-year growth rate analysis. This analysis method is used by many financial analysts and is different from the above three cases where the forecast model was created in terms of supply and demand. It is a product that meets the needs of small and medium-sized enterprise finance personnel who want to see the work of other professionals.
Important: All four models are financial forecasting models for cases where the supply of products almost meets the demands of the market. Therefore, priority is given to analysis from market demand.
On the other hand, another “EC-Multi Model” introduces the case where the supply of products does not meet the demand of the market.
The point here is that different products naturally have different popularity, price, conversion rate, order frequency, purchase volume, cost, and supply from suppliers.
Since all the products sold are in the same PC category, the unit can be unified and calculated. Therefore, the average value obtained is also meaningful. However, in the case of the “EC Multi Financial Forecast Model”, the units are also different because each product or service category is different.
This is the most versatile content of our financial services that can be leveraged for many business models.
It is intended for entrepreneurs, business owners, project managers, planners, and finance personnel. Therefore, we have divided it into three models that are analyzed on a supply-demand basis and one model that is analyzed on a year-on-year growth rate basis. The latter is primarily for corporate finance personnel. I think this configuration is the best for learning purposes.
In addition, we have created a series of charts and graphs that are useful for analysis and presentation. It also includes a dashboard designed for printing on A4 paper, which is useful for creating concise and easy-to-understand reports.
When purchasing for the first time, please consider the “EC-Basic Model” rather than here. These models require more advanced Excel knowledge and are more computationally intensive.
It comes with an instruction manual so you can get an overall picture of your financial analysis. Starting from the overview of financial model, it explains how to enter data into Excel, the flow of calculation, how to read financial statements, analysis results, and output charts, and how to print on A4 paper, etc. Furthermore, we have tried to include supplementary notes in the template as much as possible to help understanding.
Finally, if you are interested in a predictive model with scenario function, please check the “EC-Multi Model” page.
In summary, these forecasting models are recommended for business owners and entrepreneurs who have a keen interest in financial analysis, as well as project managers, planners, and finance professionals.
- Target of these models: Any business people interested in finance and strategy
- Required Excel proficiency: Intermediate to advanced level
Built-in Features
- Setting Assumptions
- Revenue, Expenses, and Balance Sheet Estimations
- Creating Income Statement, Balance Sheet, and Cash Flow Statement
- Customer Index for Analysis
- Not included in “2-4. EC Single Historical & Forecast Model”
- Break-Even Analysis
- Valuation
- Output Charts and Graphs
- Ratio & Pyramid Analysis
- Summary Dashboard
Selling Prices
1. EC Single Top-Down Financial Forecast Model
| Contents: | “2-1. EC Single Top-Down Financial Forecast Model” – Excel Template 2022 – English – One Main Worksheet – One Summary Dashboard for A4 Printing Instruction Manual (English) |
| Supplementary Information: | – Standard Level – Approximately 1,800 rows of Excel worksheet maximum |
| Selling Price: Template only | Not Available |
| Selling Price: Template + Premium Support | Price: $572 per model with premium support – With One Month Premium Learning Support – For those who want to learn efficiently – There is a limit to the number of people |
2. EC Single Bottom-Up Financial Forecast Model
| Contents: | “2-2. EC Single Bottom-Up Financial Forecast Model” – Excel Template 2022 – English – One Main Worksheet – One Summary Dashboard for A4 Printing Instruction Manual (English) |
| Supplementary Information: | – Standard Level – Approximately 1,800 rows of Excel worksheet maximum |
| Selling Price: Template only | Not Available |
| Selling Price: Template + Premium Support | Price: $572 per model with premium support – With One Month Premium Learning Support – For those who want to learn efficiently – There is a limit to the number of people |
3. EC Single Consolidated Financial Forecast Model
| Contents: | “2-3. EC Single Consolidated Financial Forecast Model” – Excel Template 2022 – English – Three Main Worksheets – Three Summary Dashboards for A4 Printing Instruction Manual (English) |
| Supplementary Information: | – Advanced Level – Approximately 2,000 rows of Excel worksheet maximum |
| Selling Price: Template only | Not Available |
| Selling Price: Template + Premium Support | Price: $572 per model with premium support – With One Month Premium Learning Support – For those who want to learn efficiently – There is a limit to the number of people |
Important: This integrated model is created on the assumption that the customer understands the above top-down analysis and bottom-up analysis. Therefore, the model is only for existing customers who have already purchased both models.
4. EC Single Historical & Forecast Financial Model
This product is in preparation.
| Contents: | “2-4. EC Single Historical & Forecast Financial Model” – Excel Template 2022 – English – One Main Worksheet – One Summary Dashboard for A4 Printing Instruction Manual (English) |
| Supplementary Information: | – Standard Level – Approximately 1,100 rows of Excel worksheet maximum |
| Selling Price: Template only | Price: $297 per model – With One Week Template Technical Support – For those who learn and solve by themselves |
| Selling Price: Template + Premium Support | Price: $517 per model with premium support – With One Month Premium Learning Support – For those who want to learn efficiently – There is a limit to the number of people |
Here, the title name is changed to something that is generally easy to understand. To be precise, it is called “Year-on-Year Growth Rate Analysis Financial Model”.
Important:
This model is built on the assumption that the customer has financial statements: income statement and balance sheet. The cash flow statement is not essential because it can be derived from the above two, but it is better to have it in advance for numerical check. The content was aimed mainly for those in charge of finance of small and medium-sized enterprises.
Customer Referral Discount Program
The customer referral discount program is applicable to these products.
$70 or $50 discount applies to both existing customer who have introduced a new customer and an introduced new customer.
For details, please see the corresponding page from the link below or the sidebar on the right.