Seller Financing Financial Model and Tax Calculator

 This is a standalone financial model built in MS Excel. It was designed to show the entire economic perspective of purchasing something and then selling it via seller financing. Tax effects are included in the monthly and annual summary. All logic is on a single tab for ease of duplication / usability.

Small Business Tools: Financial Models, Trackers, and More

 I designed this template bundle to fit the average mom and pop shop / small business. These were handpicked based on what is most generally useful to the widest audience of this sector. You will find helpful financial models, tools, and templates built in Excel and Google Sheets that are usable to the average person.

Employee Time Sheets: HR Management Tool

 This MS Excel template is a great tool for any HR department or small business to use. It makes tracking time and creating nice printable time sheets easy. There is a primary database tab that is queried with formulas to create the dynamic reports. This is built for use for many employees and for aggregate reporting as well as individual reporting.

Daily Inventory Tracker in MS Excel

 This sheet makes it easy to keep track of your inventory balances for management and reporting purposes. There is logic for alert triggers when inventory gets below a certain balance as well as valuation drivers based on average cost of goods sold per unit. 

Short-term Rental Real Estate Model

 If you were looking at getting into the STR business as a real estate investor (short-term rentals), then this financial model is MS Excel is a must have. The template is robust enough to handle large operations or just single operator investment planning. The model goes for a max period of 15 years and you can account for the purchase/renovation, operations, and exit of up to 20 properties or 20 tranches of properties all on the same timeline.

HR Tool: Expected Savings from Terminations

 It is not a pretty thing, but sometimes companies get into financial trouble and they can't support their own payroll anymore. Whatever the reason may be, this means people are going to have to be terminated (fired) and to plan that process out, a good financial calculator can help HR make more informed decisions.

10 Year Unit Based Real Estate Acquisition Financial Model (monthly and annual view)

 This is a great tool for smaller acquisition that need to be quantified by units. These units will have different inputs for annual rent per square foot, start month, and a secondary increase for new annual rent per square foot and the month that happens for each. The equity stack allows for enough flexibility for traditional debt and sponsor/investor preferred equity (hard or soft). If you are just a single operator that is fine, simply zero out the investor percentages.

SaaS Pricing Sensitivity Analysis and Simulator

 Any SaaS (software as a service) business or really any recurring revenue organization will benefit from this pricing tool. With the template, you can isolate various variables within customer configuration in order to see how that effects key performance metrics (LTV, CaC, IRR, LTV to CaC ratio, months to pay back CaC). i.e. adjust retention rate or hold all else equal and adjust contract value and contract terms. There are up to 10 configurations available.

Multi-Member Fund Portfolio Management Tool in Excel

 This is some of the most complicated logic I have ever done, but if you are trying to track the activity of a fund over time, that has up to 20 members, this tool should help you out. Investment management software is very expensive for a reason and this template was made to give a workaround for smaller funds that want to accurately track holdings activities and the profits generated.

Volume Discount Pricing Calculator: Excel Template and Sensitivity Analysis

 If you are a business that wants to figure out how to maximize discounts on volume in an optimal way, this Excel template will help give a lot of perspective and allow the user to test various sensitivities to see what is feasible based on cost of goods sold and operating expenses.