Makeup Salon Excel Financial Model Template

Description
Introduction to the financial model
Makeup Salon 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, an investment made by the investors and, of course, a marketing sheet (including automated inbound and outbound marketing costs sheet), which also contains how many customers will achieve as a result). Hence 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.
Input tab
You can feed the financial information for the model, such as sales price, cost, expenses, etc. Inputs are always depicted with a Peach fill and grey letters, calls up (direct links from other cells) are filled in grey with black letters, while calculations are depicted with 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 the company’s profit in case of any uncertainty. For example, if the cost or expenses increase by 10%. Another useful tab is the break-even analysis, where you can see the items to sell every day and their currency value to break even.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.
The interest and depreciation calculation is done based on the assets financed and the gearing of the financing. With the help of working capital assumptions, we have measured the impact on business cycles. The PnL Monthly tab has aggregation with 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. Then a series of investment metrics are presented (IRR, NPV, ROE). The Dashboard tab: Various graphs present the revenues, cash analysis, break-even analysis, sensitivity, assets vs. liabilities, startup summary, etc.