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.

Annual Employee Training Tracker: Built in Google Sheets

 Any HR manager out there will be able to make use of this template. It was made to keep track of training / other annual program completions for up to 499 employees at once. The flow is easy for anyone to follow and there is structuring setup so you can keep your workbooks organized for up to 30 years worth of time if needed. (a single workbook per year with link slots for each year).

Dynamic Customer Spend and Retention Curves: Excel Model

 This is some of the most useful and widely needed logic for any business. It doesn't matter if you are trying to forecast for a startup or an existing operation. If the nature of your customer base involves highly fluctuating retention patterns and spend patterns, this financial model will be of use. Common applications would be for SaaS, eCommerce, boutique retail. Also, check out this SaaS Rolling Revenue Forecast.

Vending Machine Ramping Financial Model

You may have never thought of it, or you might be a titan in the industry. Whatever the case is, this Excel template is a great way to build a financial forecast centered around the purchase, deployment, operations, and potential exit of the vending machine business. The assumptions are all bottom-up for maximum investor clarity and more logical revenue / expense forecasting. You simply have to enter the inputs. The focus is on ramping up machines over time and everything is dynamic based on that.