Preferred Return Investment Fund Tracking Spreadsheet: Up to 30 Members

 This is a general fund tracking spreadsheet made for investment funds with up to 30 members (expandable) that have varying start and end dates as well as general contribution rates / preferred returns / and hurdles. The template can handle up to a 20 year period for the entire fund and up to 15 years for any single investor. Enjoy one of the most usable and user friendly out-of-the-box trackers I've ever built.

Financial Model for Real Estate Brokerage

 If you ever wanted to start a real estate brokerage or currently run one and want to play with new economic incentives / financial strategies, then this financial model will be a great tool to use. The spreadsheet goes out for a max of 10 years and shows all summaries on a monthly and annual basis. It is built in MS Excel.

What Does Cap Rate Mean in Real Estate

 This question comes up a lot in real estate. Old pros or new to the industry will find it worth the effort to understand what it means. The full term is capitalization rate and is often referred to as 'cap rate'. It is used to describe property valuations, in real estate models, and as a general communicative term in the industry.

Expense Tracker: Excel and Google Sheet Spreadsheet Template

 Getting a hold on your spending and expenses is the first step to budgeting. This tracking spreadsheet will allow for the automated reporting of expenses by month and by year for up to 250 expense categories and can handle tens of thousands of individual transactions in the data tab.

Excel Template for IRR and DCF Analysis Calculations of Equity Investment Over Time

 If you have ever tried to build a financial model, you will find one of the more tricky and subjective areas is how to calculate the IRR and DCF Analysis for investors. At the project level, you can just run an IRR formula on the cash flow per period (cash in/out) by month or year (with a year 0 for initial investment). However, things can get tricky when you look at the view of investors.

Real Estate Template for Rent Growth Formulas

 One of the most common pieces of logic in all the real estate financial models I've built for customers and as templates has some sort of rent growth logic. This template gives you all the different styles and methodologies that I've used.

How to Calculate Customer Lifetime Value (LTV): SaaS Template

 This Excel spreadsheet was built to let anyone plug in some high level assumptions and see the resulting customer lifetime value. It is designed to be a metric that can be tracked from month-to-month or whatever period you are entering data for.

General Use Real Estate Rent Roll Template

 This is a general use template / spreadsheet for self storage / mobile home parks / multifamily or any acquisition scenario that involves units and monthly rent and/or driven off rent per square foot.

PaaS (Product-as-a-Service) 10 Year Financial Model

 This business model has been in academic literature since the early 90s, but more recently some businesses are experimenting or fully switching over to Product-as-a-Service or 'PaaS' instead of direct sales of their products. This is a financial model to plan out the economics of such a business for up to 10 years.

How to Calculate CaC for SaaS and Considerations

 This is actually one of the more straight forward performance metrics that is calculated in the SaaS industry. However, it is really important to understand if you are scaling up and is involved in a few other important metrics. So, it is at the heart of SaaS business analysis.

Professionally Formatted Income Statement Template in Excel / Google Sheets

 If you are not in Accounting or have not gone through any formal classes, you may want some general guidelines for how to format an income statement within an Excel or Google Sheet spreadsheet. This template and video gives you some tips on what to think about if you are doing so. Note, there are other line items that may come into an income statement not shown in the video and you will see on the example sheet link below I have added a section for COGS and Gross Profit. The general concepts apply throughout even still.

How to Calculate Debt Service Coverage Ratio (DSCR) in Excel / Google Sheets

 This finance calculation is important for ALL businesses that have any kind of traditional bank loan and regular repayments. The bank wants to know your ability to meet debt obligations and this ratio is a pretty clear indicator of that.

How to Calculator Churn Rate in SaaS

 This calculation is not as straight forward as you may think. If you ever tried to calculate the churn rate of a SaaS company, you know it is not straight forward as far as modeling goes. This template is free and makes it a bit more clear the best way to calculate it with accuracy per the renewal rate assumption.

AirBnB Arbitrage Financial Model

 This spreadsheet was built at the request of a viewer from the live stream (10AM est Mon-Fri on YouTube). It actually turned out to be a great use of some of the STR logic I have built in the past. One of my areas of expertise is building 5/10 year commercial real estate deal analyzers. This turned out awesome and works for up to 100 properties.

Hotel Development or Acquisition Financial Feasibility Spreadsheet

 This underwriting template was designed specifically for starting acquiring a hotel. I've done a range of residential and commercial real estate financial models / templates, but never specifically for a hotel. It ended up being a combination of logic from hospitality style models and short-term rentals. Everything came together wonderfully and this financial model is very useful.

Increasing Max Hold Period to 30 Years on Rental Property Analysis Spreadsheet

This is the easiest investment analysis sheet I've built and a customer requested the template be able to handle 30 years worth of time instead of 10. I have updated accordingly.

Financial Planning Spreadsheet for Plumbing Business

 Scaling out a plumbing business involves quite extensive financial planning. You need to account for truck purchases, plumber wages, payroll taxes, variable costs related to your total headcount/truck count, and fixed overheads. This financial model lets you set key assumptions for all of those items and create a comprehensive financial forecast.

ROI Calculator for Rental Property Investment

 This .xls spreadsheet was designed to make it easy to calculate total and average annual ROI for rental property investments. All the assumptions exist on a single tab for easier use and sensitivity analysis on key variables.

Converting Stage-based Google Sheet Customer Pipeline Manager to MS Excel

 Ok, just a quick update here on the sales pipeline management template. I built the Google Sheet version years ago and now I have converted it to MS Excel.

Assisted Living / Nursing Home Facility / Care Home: 10-Year Financial Model

 If you are jumping into the healthcare facility operator or investor pool, this spreadsheet will be of great use. This model will let the user enter bottom-up assumptions about the prospective care home / assisted living facility and generate forecasted financial statements. This financial model has it all. The spreadsheet has clear input/output summaries, three statement model monthly and annual views, visualizations, and so much more.

Update to Refi Proceeds Logic in Mixed Used Real Estate Model

 I was using the debt structure of this financial spreadsheet to work on the assisted living facility model (currently in the works still) and an error came up. Here is more about the fixed version...

Adding Excel Versions of Google Sheet Templates with Dynamic Arrays (To-Do List and Employee Training Tracker)

 Hello and hope everyone had a great week. There were a few template updates that happened. This upgrade involved a few of the more popular Google Sheet templates. I had a request to use them in Excel and so I integrated them in. It was a bit of a challenge because Excel does have dynamic arrays, but they are tricky and there are some caveats.

Can You Discount Future Negative Cash Flows

 If you are brand new to finance, one thing that will come up is a Discounted Cash Flow Analysis (DCF) and this has been around for quite a long time, for good reason, it works!

Adding Rolling Credit Facility to Lending Business Financial Model

 This model update came after the third customer requested the same upgrade to the lending business Excel spreadsheet. The base logic is still the same but the change involves adding a rolling credit facility and updates to cash requirement timing / IRR calculation. This is one of those sheets where I've heard clients tell me that they have spent TONS of money trying to build something similar and in one case a guy said they wanted to charge $40k/mo for the financial modeling of a lending business.

Inventory Management in Google Sheets

 This is a Google Sheets inventory management and tracking spreadsheet. I have never done one specifically in Google Sheets and it turns out there are some really nice functions in this software that make it effective at creating inventory tracking tools for any small / medium business.

Adding DCF Analysis to Preferred Equity and Preferred Return Joint Venture Spreadsheets

I've got another update here today and it involves two joint venture waterfall templates. I built these a few years ago and both have been extremely successful. Now, this latest improvement gives them an even more complete analysis for the user.

Net Worth Tracker - Up to 10 Years

 Well here is a nice free tool for personal finance. It is a spreadsheet built in Google Sheets that allows anyone to track their net worth over time. To access, simply go to the sheet and then hit File and Make a Copy.

Adding DCF Analysis with NPV to Multifamily Real Estate Model and General IRR Cash Flow Waterfall

 I figured that it would be helpful to list out significant changes that I make to the financial models and spreadsheets here on smarthelping, so here we are. This was an upgrade to the multifamily real estate model and general cash distribution IRR hurdle waterfall. They are two separate Excel templates and I've been meaning to include a DCF Analysis for them for some time. That has not been implemented.

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

 Tighten up your small business finances with these trackers, templates, and financial models. Everything is built in Excel spreadsheets or Google Sheets. Great for budgeting, tracking payables/receivables, lead tracking, financial forecasting, inventory management, and more.

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

 If you are trying to track investing activity of a fund (personal or otherwise) over time, this tool will assist you. The Excel spreadsheet below can handle up to 20 members with lots of positions. Investment management software is very expensive for a reason and this template was made to give a workaround for smaller funds or even individuals 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.

Real Estate Flipping Calculator: Renovation / Value-add Drivers

 If you are buying real estate buildings or properties, renovating them, and then re-selling for a higher price, this template will make the financial analysis of such activities easy. It is flexible enough to be used for a single property or a dynamic apartment building / multi-family property that has up to 10 unit types.