Sebastian Janus
Sebastian Janus

Free Excel Templates for Finance and Controlling

All free Excel templates from nugrow on one page: briefly explained, with download and the matching article.

Updated on
Free Excel templates for finance and controlling from nugrow

The short answer

Here are nugrow's free Excel templates in one place. Each template has input cells (blue on yellow), formulas that calculate automatically, and invented example values that you replace with your own. Every template comes with an article that explains how it works.

Liquidity and runway

Calculate your runway

How long does the cash last? The template calculates three scenarios from cash balance, revenue and costs. Download Excel · Read the article

13-week cash flow forecast

Short-term cash planning week by week, the way banks and shareholders ask for it in a crisis. The template and the guide are in the 13-week cash flow forecast article.

Planning and controlling

Budget versus actual variance analysis

Budget and actual per line for month and year, with threshold, flag and comment field. Download Excel · Read the article

Headcount and personnel cost plan

Personnel costs role by role for twelve months, with start month, FTE share and on-costs. Download Excel · Read the article

Month-end close calendar

17 tasks spread across ten working days, with calculated due dates. Download Excel · Read the article

Metrics

Unit economics calculator

CAC, LTV, LTV to CAC and payback from marketing and sales costs, customer numbers, revenue, margin and churn rate, with a sensitivity table. Download Excel · Read the article

Funding

Dilution calculator

Ownership after seed and Series A, with pre-money, option pool and chart. Download Excel · Read the article

Interim CFO and finance team

Interim CFO offer comparison

Weight up to four offers against twelve criteria and compare total cost. The template and guide are in the article Interim CFO brief and comparing offers.

100-day plan for an interim CFO

Three phases with tasks, deadlines and a progress display. Download Excel · Read the article

How to use the templates

Replace the example values with your own figures and check the assumptions with your accountant or tax advisor. The templates are working aids and do not replace tax, legal or financial advice. If you are looking for support with planning and controlling, see interim accounting and FP&A.

Frequently asked questions

Are the Excel templates really free?

Yes. The files can be downloaded directly, with no form and no sign-up.

What do the coloured cells mean?

Blue text on a yellow background marks input cells. All other cells contain formulas and calculate automatically.

Are the example values real?

No. All numbers in the templates are invented and only show how the template works. You replace them with your own figures.

Do the templates replace advice?

No. The templates are working aids. They do not replace tax, legal or financial advice.

Sebastian Janus
Sebastian Janus
Interim CFO for private-equity and venture-capital backed companies, founder of nugrow GmbH

Sebastian Janus is an interim CFO for private-equity and venture-capital backed companies, with more than 15 years in finance leadership, fundraising, M&A and restructuring. He founded one of the first German online shoe retailers in 2005, took it through two exits and then served as e-commerce CFO at a listed retail group. He has run nugrow GmbH in Bochum since 2018.

About the author

This article is by Sebastian Janus, interim CFO and finance operating partner. He founded one of the first German online shoe retailers in 2005, took it through two transactions and then served as e-commerce CFO at a listed retail group. Since 2018 he has run nugrow GmbH in Bochum, taking on finance responsibility on a temporary basis – mostly at private-equity and venture-capital backed SaaS and tech companies.

Sebastian Janus: profile and career

Strengthen your finance function – from reporting to finance leadership

Interim CFO, CFO as a service and financial modelling – from over 350 projects since 2019. First profiles within 24 hours.
Book an intro call
Or call us directly: +49 234 47995220