Financial Model (Toys & Seasonal) Excel TemplateRetail Store Model and Valuation presents the business case of a an up and running retail company mostly oriented in the toys and seasonal gifts. The user needs to input the historical income statement and balance sheet in order for the model to generate the three forecast financial statements as well as multiple valuation methods which will be discusssed later on. So a quick overview of the model, in the contents tab you can see the structure of the

In the Exit Analysis tab

The model's primary purpose is to project the financial statements generated by the tanker over a 30-year horizon (depending on the assumptions set) and calculate the Net Present Value (NPV) and Internal Rate of Return (IRR) of the investment

Then the user needs to fill the working capital (inventory

In the "outputs" tab

The costs to support the drivers of the business are split into direct and indirect expenses

Moving on to the inputs tab

according to a Global Industry Analysts report published in September 2020

and max students per class

The revenues are calculated based on the growth rates and deducting the variable and fixed costs the operating profit is resulting

sustainability assessment

Capital Expenditures (CapEx): Investments in facilities

enabling users to evaluate the attractiveness and profitability of the tanker acquisition and operations project