Free Excel templates
Working formulas you can open and change, each with a made-up example already filled in.
- .xlsx
CMA data template in Excel
A six-form CMA data layout with working formulas, from the operating statement to MPBF and fund flow.
Get the template - .xlsx
Term loan DSCR workbook
Five years of DSCR, base and stressed, on open formulas. Change the inputs and see which year breaks.
Get the template - .xlsx
Working capital workbook
Compare Tandon MPBF methods, a turnover-based limit and a 12-month cash budget on one set of figures.
Get the template - .xlsx
Financial ratio workbook
Three years of liquidity, leverage, coverage, turnover and DuPont ratios from P&L and balance sheet inputs.
Get the template - .xlsx
Bank statement analysis worksheet
Twelve months of sample-date balances, ABB, EMI to ABB, credits and bounce counts.
Get the template - .xlsx
FOIR and EMI workbook
Current FOIR, EMI room, loan eligibility and a monthly repayment schedule for up to 120 months.
Get the template