FREE!
Excel Templates
Explore our wide variety of MS Excel Templates
From creating financial forms to analyzing risk, we have many templates that can speed up your financial modeling.
Don’t worry, multiple downloads won’t cause you to be added more than once to our mailing list.
1. Financial Forms
- Build Balance Sheets using values from the Profit & Loss Statement and Cash Flow Statement
- Derive Indirect Cash Flow from your Income Statement
- Differentiate FCFF vs FCFE
- Calculate AR, AP, and Customer Deposit Lines using Revenue and Cash Projections
2. Scenarios & Automations
- Calculate the distribution of sales over several years using multiple methods
- Create generic profiles to allocate values by month in perpetuity
- Allocate standard batches against an ongoing value list
- Determine a payback period from any cashflow
3. Risk Analysis
- Add scenarios based on different forms by using the ‘Developer Tab’
- Perform risk-analysis by testing assumptions in absolute & relative terms
- Perform sensitivity analysis using a data table with two variables
4. Inventory & Personnel
- Calculate inventory purchases based on Revenue, COGS, and anticipated inventory turns
- Create a Manufacturing Schedule
- Create a WIP Schedule based on production hours and Generic Profiles
- Forecast and normalize personnel requirements from manufacturing hours
5. CAPEX & Debt
- Calculate Principal and Interest Payments using Mortgage or Cash Style Methods
- Create a depreciation schedule using Useful Life and Declining Balance methods
6. Financial Calculations
- Determine your Factory or Fully Burdened Rate
- Account for customer credits in your P&L, CF & BS
- Calculate lease payments in two ways and determine your Equity Cushion
- Calculate Income Tax on P&L using your Tax Loss schedule
Sign Up To Get Free Excel Templates
Fill the form our below and we will email you a link to thte free Excel Templates