Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Cash Burn Rate –**From the name itself, we can understand what cash burn rate is all about?

In simple terms, Cash Burn rate is how quickly the company the cash spends cash due to negative cash flows. But we need to understand it deeply.

In this article, we will go through the meaning of burn rate, when it happens, how it is being calculated and more.

## What is Cash Burn Rate?

The rate at which the cash is being burnt by a company is called the cash burn rate.

Now why it’s important?

Burn rate isn’t very critical in the case of companies that are doing quite well.

However, for the companies that have just got started and don’t have many sales yet, understanding the cash burn rate is important.

Burn rate is applicable specifically to those companies whose cash flows are running on a negative (not positive).

By calculating the cash burn rate, the companies who are running negative on cash flow would understand how long they would be sustainable. That means burn rate is the measure of the sustainability of a company. On the basis of the cash burn rate, the financing options of a company will be decided upon.

When we look at the graph above, we note that Snap’s Inc share prices have declined close to 40% from its IPO price of $24.48 to $15.15 (currently). This is primarily due to very high burn rate and missed revenue targets. We will look at how Snap’s cash burn rate is calculated later in the post.

**Recommended Courses**

### Why is cash burn rate important for the investors?

There’s another reason for which the burn rate is important.

Yes, if you’re a start-up, the investors may be having a glance at you. Guess what they’re calculating? You’re right. They are ascertaining the burn rate of your start-up.

The investors look at two factors to come to a conclusion regarding the burn rate.

4.9 (927 ratings)

First, they look at the company’s revenue. And then, they find out the forecast.

If the revenues of the company are growing as rapidly as per the forecast or more, the investors decide to invest in the company.

And if not, then they look at other start-ups for right opportunities.

So, while looking at your burn rate, two things you should always keep in mind –

- Your sustainability is greatly decided by the burn rate. If the cash is burning more rapidly than the revenues, then your sustainability is at stake.
- Secondly, the investors are always at a look out for your start-up and how it has been performing. So, you need to take steps to take care of the burn rate to attract right investors to your company.

But how to calculate cash burn rate?

Here’s how.

### Cash Burn Rate Calculation

Cash burn rate Calculation is quite easy.

All you need to do is to take two simple steps.

#### Cash Burn Rate Calculation – Step 1

In the first step, you need to zone in the period of time during which you will calculate cash burn rate.

For example, let’s say that you want to know the cash burn of your start-up during the first quarter (i.e. January to March). Then, you need to look at the opening cash balance at the beginning of the time and at the closing balance at the end of the period. In our example, we would look at the opening cash balance on 1^{st} January. And we will also look at the end balance on 31^{st} March.

- Let’s say that on 1
^{st}January, the cash balance is $20,000. - And at the end of the period, the cash balance is $11,000.

That means during these three months, you burned cash of = ($20,000 – $11,000) = $9000.

#### Cash Burn Rate Calculation – Step 2

Now you need to take the second step.

All you need to do is to divide the difference between the opening balance and the ending balance by the number of months.

- In our example, the number of months for the period is 3 months. And the difference is $9000.
- That means the cash burn for the period of the start-up would be = ($9000 / 3) = $3000.

### Relevance of revenues in Cash Burn

How would you understand whether the cash burn rate is low or high?

There comes the relevance of revenues. Once you calculate cash burn rate, you need to look at your sales.

Are your sales more than your burn rate? In our example, the sales of the start-up for the period should at least be $3000 or more. Otherwise, it isn’t a good position to be in.

Now, let’s take a practical example to calculate cash burn rate and illustrate this.

### Cash Burn Rate Example

**Ding Dong Inc. is a start-up company. It is aiming for venture capital funding. Thus it wants to look at its cash burn rate for the last quarter of the year. Here is the following information given for computing the cash burn rate –**

- Cash flow at the beginning of the quarter – $45,000.
- Cash flow at the ending of the quarter – $15,000.

**Since the business has been dry, Ding Dong’s sales for the quarter were just $30,000. Is it enough for the start-up company to remain sustainable? Compare it with the cash burn.**

This is a simple example.

All we need to do is to follow the step by step process to first ascertain the cash burn rate and then we will compare with the sales.

The first step is to compute the difference between the beginning cash balance and the ending cash balance of the last quarter of the year.

The difference is = ($45,000 – $15,000) = $30,000.

Now we need to divide the difference with the number of months in the period to find out the burn rate.

The cash burn of Ding Dong during the last quarter of the year is = ($30,000 / 3) = $10,000.

It has been mentioned that the cash flow for the company was dry during the last quarter. And it could only make revenues of $30,000 during that time. That means the revenue for each month was = ($30,000 / 3) = $10,000 as well.

Since the cash burn is also $10,000, we can easily say that Ding Dong is not in a very good position.

To be able to attract the venture capital funding, it has to improve its sales and its cash flow. It is currently in a situation where the cash burn and the cash inflow are exactly same. That means what the organization has been earning, it’s burning right away.

### Calculating Snap Inc Cash Burn Rate

Now that we know how to calculate cash burn rate with examples, let us apply our knowledge in Snap’s example.

In March, Snap Inc raised over $2.6 billion in its IPO giving it an overall valuation of $20 billion!

source: investor.snap.com

A significant amount of money raised by Snap Inc was invested in Marketable Securities.

source: investor.snap.com

##### Let us look at Snap’s Cash Postition as of 31st March, 2017

source: investor.snap.com

- Cash Position of Snap Inc (March, 2017) = Cash and Cash Equivalents (March, 2017) + Marketable Securities (March, 2017).
- Cash Position of Snap Inc = $1,427,114 + $1,815,442 = $3,242,556

Please note that I am adding marketable securities here as the company has invested a sizable portion of its IPO money in the same. This will help us correctly calculate the Cash Burn Rate.

##### Snap’s Cash and Cash Equivalent as of September 30, 2017

source: investor.snap.com

- Cash Position of Snap Inc (September, 2017) = Cash and Cash Equivalents (September, 2017) + Marketable Securities (September, 2017).
- Cash Position of Snap Inc (September, 2017) = $317,554 + $1,980,514 = $2,298,068
- Cash Burn Rate of Snap Inc in six months (31st March until 30th September 2017) = Cash Position as of 30th September, 2017 – Cash Position as of 31st March.
- Cash burn of Snap Inc in six months (31st March until 30th September 2017) = $2,298,068 – $3,242,556 = -944,488 million
- Cash burn of Snap Inc in one month = -944,488/6 = -157,415

Cash Burn Rate of Snap Inc is **$157 million per month!**

### Cash Burn Rate Video

### Recommended Readings

This has been the guide to Cash Burn Rate, cash burn rate calculation, and examples. You may learn other Corporate Finance Topics here –

- Meaning of Negative Cash Flow
- What is Venture Capital?
- Angel Investment vs Venture Capital
- Time Value of Money or TVM
- Dividend Discount Model or DDM
- FCFF or Free Cash Flows
- NPV vs IRR – Key Differences
- NPV vs XNPV | Top Differences with Excel Examples

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced