Comprehensive 3-Statement Financial Model (7- years Forecast) for a SPA & Wellness Centre

Description
Description
The Comprehensive financial model for a Spa & wellness business is an interactive, flexible, easy-to-update, and understandable model. The model is structured into Inputs, CAPEX, Debt & Equity Schedule, Working capital, Calculations, Monthly Financial Statement and Yearly Financial Statement Tabs. The model also has an interactive dashboard allowing users to visualize the key items for presentation purposes. On the dashboard, users can understand the model drivers. They also see the key output of the model in the form of charts, ratios, and return analysis

The model assumes the business has a Gold, Silver, and Bronze membership program. In addition, revenue is also captured from walk-in customers. Below are Key revenue sources 

Key Revenue Sources:
Annual Membership Fees
SPA Revenue from walk-in clients
Revenue from Special Procedures (Bottox, Tatoo, etc..)

The model has a dedicated monthly financial statement ( Income statement, cash flow statement, and Balance sheet) tab showing the financial performance of the business monthly over the lifetime of the model. In addition to this, the model also summarizes output the financial statement outputs in a yearly format.

Lastly, we have incorporated a scenario analysis in the model showing the best to worst-case scenarios. The scenario analysis is driven by sensitivities made to various inputs such as spa subscriptions

Outputs:
7-year Annual Financial Statement
Monthly Financial Statements
Dashboard with IRR and Payback Period 
Financial Ratios

Potential Users
-Professional Investors 
-Entrepreneurs
-Corporate Institutions
-Other Financial Modelers/ Consultants
-Postgraduate and Undergraduate Students