Free Spreadsheet Templates

Free Spreadsheet Templates used for financial modeling

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. Spreadsheets used for financial modeling purposes normally are a bit more complicated to build than spreadsheets for personal or accounting use, as 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.

 

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.

financial_model_for_mobile_apps_3

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.

SAAS__6_ES

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.

eCommerce

Download eCommerce Spreadsheet

 

DCF Spreadsheet

The DCF spreadsheet provides a framework to value a company based on the Discounted Free Cash Flow (DCF) analysis. This 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 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

Download DCF Spreadsheet

 

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.

IRR Analysis

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. 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.

CAPTAB_1 CAPTAB_2 CAPTAB_IRR

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. 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. The LBO spreadsheet template thus provides the required framework to run the respective analysis.

Executive Summary Private Equity View

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 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.

WACC Calculation
Download WACC Spreadsheet

 

Tax Loss Carry Forward Spreadsheet

A business with tax loss carry forwards is more valuable than a business without and thus cannot deduct the carry forwards from future profits. Ergo will end up paying higher taxes in the future. CFOs and Financial analysts thus use a spreadsheet template to analyze and calculate how much value those tax loss carry forwards have. eFinancialModel thus provides such a spreadsheet 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.

Schedule for the use of tax loss carryforwards
Schedule for the use of tax loss carryforwards

Taxable income and deductions of tax loss carryforwards and tax carrybacks

Download Tax Loss Carry Forward Spreadsheet

 

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.

Financial Summary with ROI

Cash Flow to Owner

 

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
Download Rental Property Spreadsheet

 

 

Debt Amortization Spreadsheet

Ever wanted to know how long it takes till the financial debt has been repaid? This is the 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.

Graph showing principal repayment, interest and debt balance
Download Debt Amortization Spreadsheet

 

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

Download Real Estate Developer Spreadsheet

 

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 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

 

Hotel Valuation Spreadsheet

Another spreadsheet is the Hotel Valuation spreadsheet, which measures the returns for a hotel investment. 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 and understand the profitability of the investment through IRR analysis.

EFM_Hotel_Financial_Model

Download Hotel Valuation 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.

es_parking_operator

Download Parking Operator 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. Thus 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 spreadsheet also contains a valuation framework to calculate the value of the farm via DCF analysis. Below screenshot summarizes the spreadsheets contained in this model.

Poultry_Farm_Valuation

 

Download Poultry Farm Spreadsheet

 

 

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

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.

Key Assumption Sheet
Key Assumption Sheet

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

 

Gold Mine Spreadsheet

Ever wanted to understand how profitable it could be to start a gold mine? This 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_4

Download Gold Mine Spreadsheet

 

Do you know of any other suitable financial spreadsheet template, which should be added here? Kindly upload the financial model spreadsheet to make it conveniently available to our community and tell us, so we will include it in our review. If you have any comments, kindly add them below.

 

 

One response... add one

Leave a Reply