Track the amount of hours and total $ billed for various jobs that your company has done. The database style entry allows for clean reporting and the creation of nice visuals as well as all kinds of options for reporting.
Excel Tool for FIFO Based Cost of Goods Sold (COGS) Calculation
If you are looking to save some time on figuring out what your cost of goods sold value is, this Excel template is going to be of assistance. It automates a calculation that nearly always is done manually by Accountants. The reason being is that you can't easily setup formulas to do it.
Professional Services Firm / Agency: Startup 5-Year Financial Model
I have some new revenue logic that fits perfectly with this kind of a professional services business model. Think about any organization that has professionals working for it and bills out time to clients at some hourly or daily rate. CPA and law firms are a perfect example, but also talent / creative art / photography agencies and general 'Request for Proposal' or RFP businesses fit perfectly. This also applies to a consulting firm of nearly any kind.
Starting a Franchise - Financial Modeling - Scaling Into 12 Locations
This model is hyper-focused on giving the prospective franchise owner the ability to plan out the cash flow needs of scaling or ramping into 12 locations. On a granular level, you will be able to plan the month each franchise agreement is signed, the month development starts, and the month revenue starts.
The Ultimate To-Do List Tracking Tool - Google Sheets
You know when you have to do regular recurring maintenance and you just can't remember the last time it was done? Well, that problem will be wiped out with this universal to-do list tracking tool that was built in Google Sheets.
Preferred Equity Model - Up to 10 Years - Includes Common Equity Waterfall
In the last series of preferred return templates, I said I was going to do a preferred equity version. Well, I have done so and this is it. Also included is an optional common equity waterfall that sits below the preferred hurdle. I think the logic here is super cool as well as useful. It lets the user look at possible cash flows given various project funding structures.
Preferred Return Model in Excel - Up to 10 Years
This joint venture cash flow waterfall template shows the resulting distributions of an investor and sponsor based upon an investor preferred return. All the user has to input in is the project contributions (equity requirements) and distributions per year and everything flows from that.
Multi-family Real Estate Acquisition Excel Model - Includes IRR Hurdles and Refinance Options
I have done quite a few real estate models over the years. This forecasting template was made for quick underwriting analysis. The main output is an annual pro forma, cash flow waterfall with IRR hurdles (optional) and logic to account for a dynamic refinance liquidity event. All of these things affect the cash flow that is available and how it is split as well as the overall return on investment of the project.
Economics of a Zoo / Aquarium / Amusement Park: Startup Financial Model
Yes, most Zoos and Aquariums run as non-profits, but that doesn't mean they don't need financial planning. It is just that they don't distribute profits nor are supposed to have profits. They simply have cash in and out and all extra cash is supposed to be re-invested by the operator. Often times, a Zoo will be run by the government rather than private industry, but it depends on where you are in the world. This excel model allows the user to do the planning of startup costs and on-going operations really well.
SaaS Model - Ratio Driven Growth - For Startups
I have done quite a few SaaS financial models and quite a few more customizations therein. One of the main build-ups I had not done is one based on the ratio between different employee types combined with quota attainment of account executives. The below template offers this modelling style.
Subscribe to:
Posts (Atom)