Free Spreadsheet Templates

Free Spreadsheet Templates

Spreadsheet templates are widely used by investors and companies to build sophisticated financial models with the aim to accurately forecast the financial performance of a company. Finance spreadsheets are used to answer specific financial questions such as how does the finance structure look like, what is the internal rate of return of an investment proposition or how much will be the equity stakes after several rounds of financing. Company valuation excel spreadsheet focus on the value of a company, mostly via the Discounted Free Cash Flow (DCF) analysis.

True finance excel templates are prepared for financial modeling purposes and are a bit more complicated to build than spreadsheets for personal or accounting use. The expected financial performance heavily depends on its assumptions and the development of important key value drivers – specific to the business or its industry – which need to be carefully analyzed. Also for professional use the calculations need to be a bit more sophisticated and allow for scenario and sensitivity analysis to better understand the associated risks. Thus financial model spreadsheets can be quite time-consuming to build. That’s why we have developed eFinancialModels.

Below we shortly review the free spreadsheet templates available on eFinancialModels. If you know of any other good financial spreadsheet, which should be reviewed and made available to eFinancialModels community, please drop us a note.

 

Spreadsheet Templates for IT Businesses

Mobile App Spreadsheet

A mobile app business normally derives revenues from paid downloads, in App advertising and subscriptions. The app developers then have to think about their marketing budget to figure out how much they can pay to acquire one customer so that they can scale their business in a profitable way. These calculations require a sophisticated spreadsheet. eFinancialModels provides such spreadsheet template to make it easy for app developers to forecast the cash flows of their app and show a convincing business case to their investors and partners.

Below screenshots provides a cockpit view on the assumptions and outputs of the financial model, which the spreadsheet contains.

Spreadsheet Template

Average rating:

This Financial Model for Mobile Apps provides an easy way to forecast the financial performance for an App sold in the App Stores and deriving revenues from paid downloads, advertisement and subscriptions.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Mobile App Spreadsheet

 

 

Spreadsheet for SaaS Companies

Software as a Service (SaaS) has become an important concept to consider for any IT company due to new cloud deployment technologies and faster internet connections. The specialty of SaaS companies is to charge a subscription fee for the use of its service. Forecasting the cash flows for a SaaS company requires quite a bit of financial modeling but must be done as for many SaaS companies a proper cash management is key to survive. The spreadsheet template for SaaS companies thus makes the financial modeling exercise easier and allows to calculate all the company and investor relevant metrics such as Average Revenue per User (ARPU) for SaaS companies. Find below the screenshots of the cockpit view with several more detailed financial spreadsheets included in the model.

Download our SaaS spreadsheet templates for different financial purposes at efinancialmodels.com.  It’s perfect way to analysis your business for budget planning, project management and invoicing.

Finance Excel Template

The SaaS Financial Model provides a simple way to derive the financial forecast for a Software as a Service (SaaS) internet company. The Financial Model calculates the DCF Value, IRR, Breakeven, ARPU, Customer Lifetime Value…

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download SaaS Spreadsheet

 

Spreadsheet for eCommerce Companies

Starting an eCommerce business has become a great way to start a company. An eCommerce business relies on the Internet to find its customers and thus needs to find cost-effective ways to drive traffic to its website. Thus one of the key metrics to consider for an eCommerce business, are its Customer Acquisition Costs (CAC). These costs need to be lower than the Customer Lifetime Value (CLV) and pay for all costs during the customer lifetime. Only then, the entrepreneur has a viable business model. A spreadsheet template specific to ecommerce companies is needed to understand the business’ cash flows and build the appropriate financial model. See below the screenshot of the cockpit of the spreadsheet provided by eFinancialModels while the model also includes several more detailed spreadsheets to forecast the cash flows for the eCommerce business.

Finance Excel Template

The eCommerce Valuation Model forecasts the expected financials for a webshop or eCommerce business and calculates the resulting DCF value.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download eCommerce Spreadsheet

 

Finance Excel Templates

IRR Spreadsheet

The Internal Rate of Return (IRR) provides a framework to understand the financial attractiveness of an investment. As the IRR should be higher than its opportunity costs – measured by the WACC – IRR also provides an answer whether to undertake a project or not. In case of investment projects, such as building a new Greenfield plant, the IRR is calculated based on the free cash flows the project will generate over its lifetime. This spreadsheet provides a comprehensive forecast for cash flows and the balance sheet for a project finance project. Below screenshot includes the IRR calculation while the financial model contains a comprehensive forecast about the project’s financials (income statement, balance sheet and cash flow statement) for a period of 10 years.

company valuation excel spreadsheet

The IRR Project Finance Analysis forecasts the expected financials for a greenfield project and calculates the levered and unlevered Internal Rate of Return (IRR).

Add to wish list
Add to wish list

Download IRR Spreadsheet

 

Cap Table Spreadsheet

The capitalization table (cap table) spreadsheet provides an overview about the capitalization and ownership stakes during a series of financing rounds. In this finance excel template, the funding series normally start with seed financing followed by Series A, B, C, etc. By raising more equity financing, existing investors get diluted each time new financing is raised, meaning their equity stakes get smaller. The cap table spreadsheet template provides entrepreneurs with a quick overview to understand the impact of equity financing scenarios on their share ownership stakes. Below screenshots provide the important calculation of the cap table spreadsheet. Apart from the investor’s stakes in the company, also their IRR is calculated based on entry and exit valuation.

company valuation excel spreadsheet company valuation excel spreadsheet company valuation excel spreadsheet

Average rating:

This is a simple capitalization (cap) table template which allows entrepreneurs to understand the dilution effect of capital raisings and a simple stock option plan.

Add to wish list
Add to wish list

Download CAP Table Spreadsheet

 

Leveraged Buyout Spreadsheet

Private Equity firms normally have a different way of looking at a company up for acquisition than a family or corporate buyer. First, as a financial investor who focuses primarily on the strategy rather than execution, they will require a management team to actually run the company on a daily basis. Thus its called Buyout when the acquisition is done with the existing management team, Buy-In when a new management team is being brought in. Second, Private Equity firms prefer stable cash flows and have a preference to use financial leverage to increase their returns through financial engineering (leverage). Third a Private Equity investor normally is structured as a fund, thus has an investment horizon of ca. 5 years as investors will want to exit. Thus a spreadsheet used for Leveraged Buyout (LBO) analysis needs to include a debt schedule and an entry / exit calculation to come up with the expected IRR for this investment. This finance excel template or LBO spreadsheet provides the required framework to run the respective analysis.

Finance Excel Template

The Private Equity Leveraged Buyout Model offers a simple template to calculate the financial returns (IRR and cash on cash multiple) of a leveraged buyout acquisition from a Private Equity investment perspective.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download LBO Spreadsheet

 

 

WACC Spreadsheet

The Weighted Average Cost of Capital (WACC) is an important framework to calculate the discount rate for Net Present Value (NPV) analysis in Discounted Free Cash Flow valuation models. This WACC finance spreadsheet template provides the framework to calculate the WACC based on a variety of assumptions related to the cost of equity and the cost of debt. The finance Excel template is structured as below:

Spreadsheet Template

This model calculates the Weighted Average Cost of Capital (WACC) which can be used as discount rate for any DCF calculation.

Add to wish list
Add to wish list

Download WACC Spreadsheet

 

 

Tax Loss Carry Forward Spreadsheet

A business with tax loss carry forwards, which can deduct past losses from current profits, is more valuable than a business without tax loss arry forwards. Ergo you will end up paying higher taxes in the future. CFOs and Financial analysts therefore use a spreadsheet template to analyze and calculate how much value those tax loss carry forwards have. eFinancialModels  provides such finance Excel template to calculate the future tax savings and the Net Present Value of such tax loss carry forwards. Below screenshots show the deductions of tax loss carry forwards and tax carry backs from the taxable income.

Spreadsheet Template
Schedule for the use of tax loss carryforwards

Taxable income and deductions of tax loss carryforwards and tax carrybacks

This valuation model provides a framework for the valuation of tax loss carryforwards and tax carrybacks via Net Present Value (NPV) calculation.

Add to wish list
Add to wish list

Download Tax Loss Carry Forward Spreadsheet

 

Debt Amortization Spreadsheet

Ever wanted to know how long it takes till the financial debt has been repaid? This is the financial spreadsheet to use. Simply enter the relevant figures and the model outputs the number of years required till the debt has been fully amortized. The screenshot below provides an excerpt of the spreadsheet and summary sheet contained in the model.

Finance Excel Template

This simple amortization table calculates how long it takes for a monthly installment to repay debt via monthly installments.

Add to wish list
Add to wish list

Download Debt Amortization Spreadsheet

 

Spreadsheet Templates for Real Estate Businesses

Real Estate Property Flipping Spreadsheet

This spreadsheet template provides real estate investors with the framework to forecast the cash flows from a renovation and property flipping project and allows them to understand their financial benefit.

Finance Excel TemplateI

Cash Flow to Owner

This financial model allows you to calculate the return (ROI) when buying a real estate property to renovate and flip.This financial model allows you to calculate the return (ROI) when buying a real estate property…

Add to wish list
Add to wish list

 

Real Estate Developer Spreadsheet

This free spreadsheet templates allows you calculate the financial returns when developing a gated community real estate project. The spreadsheet includes different sheets to input the master plan for 3 main categories of buildings (e.g. condos, apartment, commercial) and up to 10 subcategories each, a pricing sheet to forecast rent and sale income, some other sheets and a cockpit spreadsheet to control the model and easily play around with the assumptions. Based on the projected cash flows the IRR for equity shareholders is calculated. The model is made for a buy and rent scenario, a buy and sell scenario is expected to be added in the future. Below screenshot provides an excerpt of the spreadsheets contained in the model.

Master plan

Add to wish list
Get it Here Excluding 7.7% tax

Download Real Estate Developer Spreadsheet

See here, for more related real estate developer spreadsheets.

Average rating:

This financial model can be used to evaluate the financial feasibility of a real estate development project and present it in investor grade quality to your partners. There is everything in there which is needed…

Add to wish list
Purchase Excluding 7.7% tax

The purpose of this model is to give investors and sponsors a clear picture of what their projected cash flow returns will be (based on over 30 Inputs) as well as perform sensitivity analysis on…

Add to wish list
Purchase Excluding 7.7% tax

The Gated Community Financial Model calculates the profitability of a real estate development project with residential and commercial buildings.

Add to wish list
Purchase Excluding 7.7% tax

 

 

Commercial Real Estate Spreadsheet

Investing in commercial real estate has become a valid alternative for investors, as one normally has to deal with less tenants for the same amount of square meters as residential real estate and the rental contracts can be more long-term. Investors are more sophisticated and need to understand the return potential when entering into a commercial real estate investment. This analysis requires quite some time, for which a good spreadsheet template is needed.

The commercial real estate investment model normally has a variety of sheets where the rent-roll is the most important one. Rent-roll is a simple list with all tenants renting space in the property and there is normally an algorithm used to predict the future cash flows of the tenants based on assumptions such as the length of renewed leases and periods of vacancies. Thus a spreadsheet template is needed which helps you to steer the assumptions in a simple way, calculate the cash flows and the return for investors. Of interest to investors are especially cash on cash multiples for their equity investment and their expected IRR. Below screenshot shows the summary of the spreadsheets contained in the model.

EFM Commercial Real Estate Investment Model

Download Commercial Real Estate Spreadsheet

The commercial real estate valuation model template can be used to quickly value a commercial property such as an office building, industrial site, logistics or storage or a retail building via DCF valuation.

Add to wish list
Purchase Excluding 7.7% tax

The Commercial Real Estate Investment Model allows calculating the investor return when investing in a commercial real estate property. The financial model is especially helpful when identiying the uplift potential from non-letted area and assessing…

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

 

Rental Property Spreadsheet

Real estate investors who are looking to buy and rent a residential property want to understand the future cash flows of their investment and their benefits when paying down the mortgage. The rental property spreadsheet template provides the framework to model the cash flows for a buy and rent project. The financial model outputs the IRR to investors. Thus investors can easily check how well their investment project compares to their other investment projects. Below screenshot provides an excerpt while the financial model contains a more detailed spreadsheets to forecast the cash flow to the property owner.

Executive Summary

The rental property financial model calculates the homeowner's IRR and long it takes to repay a mortgage when the property is rented.

  • Rental properties net operating income
    Rental properties net operating income
The financial model contains: Rental income and expenses Gross yield and…

Add to wish list
Add to wish list

Download Rental Property Spreadsheet

 

Parking and Shuttle Bus Operator Spreadsheet

This financial model allows you to understand the future cash flows of a parking and shuttle bus operator. You can input the number of parking spaces, the average daily rate and the cost assumptions to operate a shuttle bus e.g. from an airport or a hotel car park. The spreadsheet outputs the investor relevant metrics. So if you ever have wondered how profitable it might be to rent and operate a car park, this is the spreadsheet template for the relevant financial calculations. Below screenshots provides you with the cockpit view where you can easily change the assumptions and immediately see the output.

Spreadsheet Template

Average rating:

The Parking Operator Financial Model forecasts the expected revenues and costs for the operation and management of a rented car parking space with associated shuttle bus service. The financial model calculates the project's profitability via…

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Parking Operator Spreadsheet

 

Financial Model Templates for Renewable Energy Businesses

Biogas Spreadsheet

The spreadsheet template for biogas projects models the expected cash flows and calculates the NPV and IRR. This spreadsheet includes a comprehensive financial model to also understand the expected balance sheet over the next yeas. Thus the spreadsheet template provides an easy way to come up with a multi-year financial plan for a biogas project. Below screenshot shows the key assumptions used in the financial model.

Key Assumptions

The Biogas Financial Model forecasts the expected financials for a Biogas plant project and calculates the IRR and NPV values for the project.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Biogas Energy Spreadsheet

Wind Energy Spreadsheet

The Wind Energy financial model provides the framework to derive the income, balance sheet and cash flow for a wind park project. The spreadsheet calculates the IRR and NPV for the project to allow investors to understand its financial viability. The spreadsheet template provides all what is needed to quickly understand a wind park project from a financial perspective. See below the assumption used in the spreadsheet.

company valuation excel spreadsheet
Key Assumption Sheet

Average rating:

The Wind Energy Financial Model forecasts the expected financials for a Wind Park project and calculates the project's IRR and NPV.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Wind Energy Spreadsheet

 

Solar Energy Spreadsheet

This financial model calculates the IRR and NPV for a solar energy project. The spreadsheet projects the income statement, balance sheet and cash flows for the solar park over the next years and allows investors important insights in how to finance the project and its financial viability. The spreadsheet template can easily be understood when reading the summary.

Key assumptions

Average rating:

The Solar Energy Financial Model forecasts the expected financials for a Solar Park project and calculates the project's IRR and NPV.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

 

Company Valuation Excel Spreadsheets

DCF Spreadsheet

The DCF spreadsheet provides a framework to value a company based on the Discounted Free Cash Flow (DCF) analysis. This company valuation excel spreadsheet template allows a comprehensive view about a company’s expected Income, Balance Sheet and Cash Flows during the next years. Below screenshot discloses how the DCF calculation is being done, while the company valuation spreadsheet contains more detailed financial projections to derive the company’s cash flows from the expected income statement, balance sheet and cash flow statement.

DCF Analysis

This simple DCF model in Excel allows you to value a company via the Discounted Free Cash Flow (DCF) valuation method. The discounted cash flow valuation model uses a three statement model to derive free…

Add to wish list
Add to wish list

Download DCF Spreadsheet

 

Hotel Valuation Spreadsheet

Another company valuation Excel spreadsheet is the Hotel Valuation spreadsheet, which measures the returns for a hotel investment and comes up with a DCF Value for the hotel. The spreadsheet template uses similar logic as a commercial real estate investment model but is very specific to the hospitality industry by taking into account the revenue streams from the hotel and restaurant. The hotel spreadsheet template gives you a structure to model the cash flows for the hotel, provides a DCF valuations framework and the tools to understand the profitability of the investment through IRR analysis.

EFM Hotel Financial Model

The Hotel Valuation Financial Model provides a simple way to forecast the expected cash flows for a hotel investment and calculates the relevant investor metrics such as the IRR (levered and unlevered).

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Hotel Valuation Spreadsheet

 

Gold Mine Spreadsheet

Ever wanted to understand how profitable it could be to start a gold mine? This finance spreadsheet template calculates the cash flows from the gold mine based on the ore grade and gold content as well provides a structure to assume all the related cost assumptions. The spreadsheet then calculates the investor relevant metrics to understand the profitability of the gold deposit.

Gold Mining

The Gold Mine Investment Model is used to determine the financial feasibility of a proposed Gold Mine Investment. The Financial Model outputs IRR and NPV based on the Mine Life expectation.

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Gold Mine Spreadsheet

 

Poultry Farm Spreadsheet

As per Bill Gates, there is no better investment for poor people than a poultry farm. This spreadsheet template goes a bit beyond this claim and models the expected cash flows for a mid-sized broiler farm operation by using specific poultry farming related assumptions. Therefore, it makes it easier to come up with a business plan as required by banks and investors to understand the expected cash flows of the farm over the next years. The company valuation Excel spreadsheet also contains a valuation framework to calculate the value of the poultry farm via DCF analysis. Below screenshot summarizes the financial spreadsheets contained in this model.

company valuation excel spreadsheet

The Poultry Farm Valuation Model allows forecasting the financial statements for a poultry farm based on operational metrics such as the hatchery ratio, mortality rate etc. The financial model calculates the resulting DCF value of…

Add to wish list
Purchase Excluding 7.7% tax
Add to wish list
Get it Here Excluding 7.7% tax

Download Poultry Farm Spreadsheet

 

For more free spreadsheets, please check our main page financial model templates.

 

 

 

One response... add one

It is very useful tool for even any professional people. Many thanks to Cyrill, founder of e-Financial Models. best wishes .

Leave a Reply