Online Flower Shop Financial Model

Description
Online Flower Shop Financial Model presents the business case of a brand new start-up Online Shop with an upfront investment in a website, SEO, logo, and copywriting. The model contains the three financial statements including the cash flows and calculates the relevant metrics (Sensitivity Analysis, Break-even Analysis, Diagnostic Tools, Project evaluation, and Charts). The financing options for the project include a standard long-term loan as well as an investment made by the investors. The marketing sheet ( include inbound and outbound costs sheet which also contains how many customers will achieve as a result).
So a quick overview of the Financial Model, in the contents tab you can see the structure of the model and by clicking on any of the headlines be redirected to the relevant worksheet.
How To Use Model
On the Input tab, you can feed the financial information for the model such as sales price, cost, expenses, etc. Inputs shown in this model with a Peach fill and, call up (that is direct links from other cells) fill in grey with black letters while calculations depict in white fill and black characters.
In the sensitivity analysis tab, you can see a high-level report with the main business scenarios. The tab shows how the company’s profit will look in case of any uncertainty. For example, if the cost or expenses increased by 10%.
Another useful tab is the break-even analysis where you can see the items needed to be sold every day and their currency value to break even.
Calculations: This is where all calculation performs. The revenues are calculated based on the product or services sold, promotion, pricing, promotions, and marketing campaign, and deducting the business variable and fixed costs the operating profit is resulting. Based on the assets financed and the gearing of the financing the interest and depreciation are calculated in this model. With the help of working capital assumptions, we have measured the impact on business cycles. In last, the level of the investment. consider calculating the relevant debt financing.
In the PnL Monthly tab: everything is aggregated into the relevant statements: profit and loss, balance sheet, and cash flow every month.
Moving to the Project Valuation tab, a company valuation is performed by using the free cash flows with discount rates to the firm and then a series of investment metrics are presented (IRR, NPV, ROE).
In the Dashboard tab: Various graphs present the revenues, cash analysis, break-even analysis, sensitivity, assets vs liabilities, startup summary, etc.