Aug 27, 2016

Joint Venture Real Estate Model: Including IRR Hurdles/Equity Splits/More

This is an fully functioning financial model for joint venture or individual cash flow analysis of a real estate deal. The power of excel is truly amazing. I have included two of my past excel templates within this real estate model. One of the previous templates you know as the amortization schedule. The other is not for sale, but is a fully functional depreciation schedule model with mid-month/quarter/year conventions, bonus depreciation, and all types of depreciation methods.

Aug 25, 2016

Explaining Gordon Growth Model for Valuation (Excel Template)

This is a pretty interesting way to value cash flow that a unit produced and has implemented some very basic financial formulas in order to come to a number. Valuation is a very tricky thing and lots of things can go into trying to value cash flows.

Aug 24, 2016

5-Year SaaS Startup Model in Excel: Includes CAC Payback and Valuation

Understanding and making use of SaaS startup models in excel or google sheets can be difficult and end up wasting a bunch of time. For this reason, I have tried to make a template that has very clear assumptions for subscribers, revenue, costs, and financing.

Aug 23, 2016

Amortization Schedule Excel Template: Includes Loans, Bonds, Interest Summary

This excel sheet was designed to be versatile enough to show an amortization schedule for various loans and include the function of allowing for varying payment amounts and a variable interest rate over time. The other side of this model shows a bond schedule.

Aug 22, 2016

Best Excel Scheduling Template

If you want a really clean and easy way to get all the time tables of your various business activities organized or plan out when employees have to do things, this excel scheduling template/model is great for all kinds of such uses.

Excel Models: New Service Line

What is going on everyone?! So I am going to start really putting the hammer into the value you can get from and in order to do that my content is going to make a bit of a shift from forex trading to excel models and builds that help businesses with decision making, data cleaning/manipulation, visualization, and cash flow analysis.