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.

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.

Bike Shop: 5-Year Financial Model

If you were thinking about opening up your own bike shop, this template will be of great value in planning out all the financing, financial performance expectations, and minimum initial investment requirement based on the defined assumptions.

Payroll Tracker and Calculator - Budget vs. Actual: Excel Template

Anyone that has to enter payroll into their accounting software and/or calculate it each month will benefit from this Excel template. It is completely editable and easy to use for anyone. The goal is to provide a really organized way for any Accounting department to clean up how they calculate payroll and track it vs. budget.

Employee Tracking Template for HR Departments: Google Sheets

I built this tracking tool in Google Sheets because the conditional formatting and filtering summarizations could not be done easily in Excel. This template was designed for general use by any HR department. It is fully editable once purchased and should improve organization and reporting as well as general decision making that must happen in regards to employees.