New Model Upgrade: Mobile Home Park / General Multi-Family Real Estate

This is just a notification to let everyone know the MHP model has been upgraded. You can find it here. The upgrade involves logic that I have been asked to do a few times, but just didn't have the time to get into. The reason why it has taken so much effort is that the usability is geared toward the purchase/construction of many parks or many properties over a longer period (up to 16 years). 

Car Salesperson: Improvement Tracker

This is an awesome template that anybody who sells cars can use to make themselves better. The main benefits include better organization, follow-ups, and win rate analysis. There are monthly stats and visuals over a two-year period across various slicers (meaning track win rate/sales/lost sales/$ earned across different car types/makes and by combination of car type and make).

10 Year Driving Range Financial Model - Monthly and Annual

 This model was fun to build and I did a nice capacity matrix for the seasonality that may have a lot of other uses for all sorts of industries. The model goes out for a period of 10 years and shows monthly and annual granularity with a ton of visuals. There are revenue and expense assumptions that can be used for robust sensitivity and cash flow analysis.

SaaS: Should You Offer a Discount at Cancellation?

I have done a wide range of SaaS financial models. One interesting aspect that such companies may be looking into or looking to optimize is retention rate. Retention rate just means the users that stay with your services over a period of time. The higher the retention rate, the better (meaning lower churn rate). One way to increase retention is by offering pricing discounts at the point of cancellation.

Ad Network - Feasibility and Financial Modeling - Driven by Publisher Metrics

An ad network connects ad inventory from publishers to advertiser demand. By connecting these two groups, the ad network provides value and takes a fee for such value. This model was designed to show the expected financial performance of an ad network based on assumptions related impressions / CPM /fee percentage.