Franchisor Licensing Operator: 10-Year Financial Model and 3-Statement Model Integrated

 This template is designed for a franchisor to plan out the on-boarding of franchisees over time. It goes for up to a period of 10 years and has robust revenue scaling and expense assumptions to fit as many scenarios as possible for this kind of endeavor. Additionally, a fully integrated 3-statement model is included.

Financial Visualizations for any Pitch Deck

 If you are putting together financial projections that need to go into a pitch deck, they need to look professional. This means consistent formatting, easily readable fonts, very clear number display, and consistent coloring that is not distracting. Your only goal is to allow potential investors to easily view what you think your financials will look like over time in a digestible presentation.

Mortgage Savings Calculator: Extra Payment Simulation

 This is an awesome tool that can be used by anybody that has a mortgage and wants to see how much they can save in interest by paying extra on the principal over time. You can setup any kind of extra repayment scheme that fits your personal budget and the model can handle it elegantly.

Cash Flow Waterfall Template: 3 IRR Hurdles

 If you deal in joint venture deals, want to learn about how those deals are financed, and/or need a standalone template to plug in cash contributions and distributions, this model will work for you over and over again. It is the most basic and general version of a cash flow waterfall with 3 IRR hurdles. This is a great place to start for any joint venture endeavor. The incentives that result from this make it a win / win for the LP (investor) and GP (sponsor/operator).

Rolling Revenue SaaS Forecasting Template in Excel

 This is a pain point for any finance department or CFO or consultant that is charged with producing regular rolling revenue forecasts for a SaaS company. The future customers are not so bad, but figuring out the best way to account for revenue of existing customers is much more difficult if you want to do it properly. This involves knowing when customers joined, retention rates, and easily being able to update this over time to continue to get good numbers. The template you see here accomplishes just that.

Cumulative Distribution Joint Venture Cash Flow Model

 This model is setup so that the cash flow splits between the LP and GP are based on the total cash that has been distributed to the LP over time. As the LP receives cumulatively more distributions, the cash flow share can be adjusted. It runs for up to 60 periods (to give max usability for annual or monthly period) and includes final effective percentage share per period and overall IRR for the periods defined. If it is a monthly analysis, just multiple the IRR by 12.

Accounting Ratios: Comprehensive Excel Template

 If you want to analyze private or publicly traded companies, these Accounting ratios will help give some perspective. All ratios include a description of what it is, what a 'good' value is in terms of higher or lower, and the relevant financial statements that are needed to calculate each ratio. The formatting was done to make tracking over time easy and straight forward for comparison of the same company over time or to other companies in the same industry.

Mixed-Use Real Estate Model: Leverage and Joint Venture Options

 This is one of the most satisfying financial models I have done in the real estate space. It is for mixed-use properties, which means an investment in a given location / cluster of locations and each area can be used for different things i.e. residential / offices / food places / or what have you. Each 'use' is separated into its own development costs, operating assumptions, and exit caps, but they are all consolidated on the same model timeline with this Excel template. Model for up to 10 years.

Flat Fee or Fixed Fee Lending Business: 10-Year Financial Model

 This type of lending business was spawned from the original lending business financial model I did awhile back. The difference in this kind of business model is that a fixed percentage or 'fee' is charged based on the total amount borrowed. There is no monthly interest or compounding interest. Also, this kind of endeavor is usually funded with leverage that is lower cost than the flat fee being collected from customers and usually the difference is substantial as that is where the margin is made.

CAGR - Compounding Average Growth Rate

 This is a very simple, but easily forgetting formula that many people in finance or research use. The goal of the CAGR (compounding average growth rate) is to figure out the exact percentage that a beginning value must grow at per period in order to reach a final value in a given number of periods.