Preferred Equity Model - Up to 10 Years - Includes Common Equity Waterfall

In the last series of preferred return templates, I said I was going to do a preferred equity version. Well, I have done so and this is it. There is common equity that sits below the preferred. I think the logic here is super cool as well as useful. It lets the user look at possible cash flows given various project funding structures.

Preferred Return Model in Excel - Up to 10 Years

This waterfall model shows the resulting cash flows of an investor and sponsor based upon a preferred return existing for the investor. All the user has to input is the project contributions (equity requirements) and distributions per year and everything flows from that.

Multi-Family Real Estate Acquisition Excel Model - Includes IRR Hurdles and Refinance Options

I have done quite a few real estate models over the year. One of the setups I have never fully built out was an annual-based model that allowed for IRR hurdles (meaning you are doing a joint venture between investors and sponsors) and the complex logic of a dynamic refinance liquidity event. All of these things affect the cash flow that is available to split and how it is split.

Financial Model to Startup a Zoo / Aquarium / Park

Yes, most Zoos and Aquariums run as non-profits, but that doesn't mean they don't need financial planning. It is just that they don't distribute profits nor are supposed to have profits. They simply have cash in and out and all extra cash is supposed to be re-invested by the operator. Often times, a Zoo will be run by the government rather than private industry, but it depends on where you are in the world. This excel model allows the user to do the planning of startup costs and on-going operations really well.

SaaS Model - Ratio Driven Growth - For Startups

I have done quite a few SaaS financial models and quite a few more customizations therein. One of the main build-ups I have not done yet is one based on the ratio between different employee types combined with quota attainment of Account Executives.

Depreciation Expense Tracker (up to 95 Fixed Assets at Once)

This was designed to be an easy tool to figure out what your monthly/annual depreciation expense is going to be over time.

Robust 3-Statement Financial Model: For Startups

I had to really dig deep into my old accounting knowledge and do quite a bit of research to get this model right. It is a fully functional and inter-connected excel template that has all 3 financial statements functioning on it. The purpose was to build something that fits 90% of cases. This is typically called a 3-statement financial model and commonly requested for startups by investors/creditors.

Security System Services Startup Financial Model - Includes Expansion MRR and Negative Churn

This financial model was built specifically for the security and alarm services business. It is very similar to a regular SaaS business where you have monthly recurring revenue for subscribers. I have built up to 3 pricing tiers for what customers may pay per month.

When and How Much Inventory to Re-Order: Excel Template

This is a useful excel template (I built it in google sheets as well) to manage inventory re-ordering. Based on a few variable inputs per SKU, the logic in this model will display useful metrics to help you stay on top of inventory levels.

Key Performance Indicator (KPI) Dashboard - Scoring by Category

There are many kinds of views one can take to try and gauge the overall health of their organization or business. This often is said to be done best by a KPI dashboard or some kind of dashboard that reports on different metrics. This is normally done on a 12-month view and/or an annual total.