Explaining The Effects of a Waterfall Model with Multiple IRR Hurdles

This is all about financial incentives. Everyone wants to make the best returns possible over time. The best measure of that is IRR or internal rate of return. This model shows and explains the way this is done so that a joint venture real estate deal with investors and sponsors results in an equitable and max profit focused result.

Build and Run a Golf Course - 5 Year Financial Model

This excel template has been designed to fit the needs of anyone looking to see the viability of building and running a golf course. The financial model goes over 5 years and has focused on bottom-up assumptions directly related to this type of business.

Total Contract Value Goal Tracking (YTD and Remaining Annual Revenue)

This is a great tool to use for any business that has mid-size contract sizes that last for a given amount of months. Based on 4 simple data inputs, you can see your current YTD billings and your remaining billings. The logic is 100% automated. A dashboard view allows the user to see how they are projected to finish the year based on some annual sales goal.

Customer Pipeline Manager - CRM in Google Sheets

I have built various excel and google sheet based sales pipeline or customer pipeline styled templates, but this latest version allows the user to start right away without much, if any, required customizations. It simply tracks customers through the pipeline as well as their annual value.

Marketplace Startup Financial Model with Cap Table

If you are looking into the financials and dynamics of building a marketplace-style business, this financial model is going to be useful. Additionally, I have added cap table and distribution logic that scales over time for maximum strategic functionality. You will be able to accurately forecast a wide range of scenarios and see metrics all the way down to after-tax cash flow.

Financial Model - Freemium Startup - 5 Year Forecast

A freemium business model is a type of strategy that many organizations have adopted or started as. I have done some for different clients and it really ties into some of my most popular builds (SaaS and Mobile App). I have never put the logic together in this way and the main value-add is having revenue logic for ad revenue, better visuals, and better cash flow summaries / return logic.

Saving for a Home - Excel Financial Planner

If you are trying to save money for a new home, it might help to know what your after tax free cash flow looks like over the next 5 years or so. I have built a nice tool that may help you see how long you are going to have to save for and how much free cash you will have pre and post home purchase.

Financial Model to Help Decide to Pay Off All Debt or Invest That Money Instead

This is something individuals and businesses alike often think about when deciding what is the most financially sound thing to do. Anybody that has ever had a loan has come across this decision to some degree. You will see the logic can get complex when actually trying to build something that shows an accurate apples to apples comparison.

Loan Payback Optimizer: Excel Model - How Extra Principal Payments Can Save Money

If you are trying to solve for the savings of paying extra principal on loans over time, this will help. The financial model done here will tell you the effect of adding an extra amount of cash to your regular debt service payments of standard principal and interest loans.

An Income Generating Retirement Plan - Excel Financial Model

If you were trying to do the math on if your investments were going to generate enough annual income for you to live off of, you may find that this tool will help you in retirement planning. The type of investments this is geared for are those that produce income that is spendable each year up to 50 years. There is logic to adjust for inflation as well.