A comprehensive financial dashboard highlighting customer and revenue mix, investment returns, and financial projections.

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 Gold, Silver, and Bronze subscriptions and memberships.

Outputs:

– 7-year Annual Financial Statement
– Monthly Financial Statements
– Dashboard with IRR
– Payback Period
– Financial Ratios

Potential Users

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

File Type: .xlsx