# All articles with 'Financial Modeling' Tag

## Modelling Inventory Run Rate & Cash Flows using Excel

Published on Apr 19, 2017 in Analytics, Charts and Graphs

Imagine you run an office furniture company. You want to stop reordering two brands of furniture – Relaxer (a type of chair) and Boca Top (a type of table). You currently have 20,000 Relaxer chairs and 5,000 Boca Tops. These are valued at \$200,000 and \$100,000 respectively. When sold, they will yield \$100,000 and \$25,000 gross profit. You are hoping to sell them off in 2 or 3 years. You forecast that we can sell off these as per some yearly schedule.

You need to analyze this and prepare a cash flow model.

Let’s learn how to answer such open ended questions using various analysis techniques in Excel.

Continue »

## CP042: Financial Analysis & Modeling concepts – 101

Published on Aug 13, 2015 in Chandoo.org Podcast Sessions, Financial Modeling

In the 42nd session of Chandoo.org podcast, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models.

### What is in this session?

In this podcast,

• Quick announcement about Awesome August
• 5 key finance concepts
• Time value of money
• Compound interest
• Risk free rate of return
• Net Present Value – NPV
• Internal Rate of Return – IRR
• Case study – Uber vs. Your car
• Conclusions
Continue »

## Doing Cost Benefit Analysis in Excel – a case study

Published on Jan 28, 2015 in Analytics, Charts and Graphs, Financial Modeling

Imagine you are the in-charge of finance department at Hogwarts. So one fine day, while you are practicing the spells, Dumbledore walks in to your office and says, “Our electricity bills are way too high. As the muggles don’t accept wizard money, we have to find a way to reduce our power consumption.”

So you summoned the previous 12 month utility bills to examine energy consumption patterns, and pretty soon you realized that most of the electricity consumption is due to the light bulbs. You suddenly have a brilliant idea. Why not replace the light bulbs with a variety that consumes low power? A light bulb moment indeed.

Your next step is to figure out what varieties of light bulbs are out there. Fortunately this is easier than catching a snitch in a game of quidditch. A quick search revealed that there are 3 types of light bulbs:

• Regular incandescent bulbs (the kind Hogwarts currently uses)
• Compact Fluorescent Light bulbs (CFL)
• Light Emitting Diode bulbs (LED)

Now your job is to do a cost benefit analysis of these options and pick one.

Continue »

## CP019: 6 Tips for Best Practice Modeling – Interview with Danielle from Plum Solutions

Published on Sep 4, 2014 in Chandoo.org Podcast Sessions

In the 19th session of Chandoo.org podcast, lets talk about modeling best practices.

### What is in this session?

I am very happy to interview my good friend, blogger, author, excel trainer & business-women – Danielle Stein Fairhurst for this session. I first met Danielle when I went to Sydney, Australia in April 2012. Our friendship & collaboration grew a lot in the last 2.5 years. She is a great speaker & trainer. This episode is loaded with her trademark style commentary, explanation & tips for better modeling. I hope you will enjoy it.

In this podcast, you will learn,

• Introduction to Danielle & her work
• 6 Tips for Best Practice Modeling
• Write consistent formulas
• Avoid hard-coding
• Smart referencing
• Ditch the bad habits
• Document assumptions
• Format & label things
• Resources for learning more
Continue »

## Implementing Modular Spreadsheet Development – a walkthrough

Published on May 21, 2014 in Financial Modeling, VBA Macros

In the first article on Modular Spreadsheet Development, we got a high level overview of Modular Spreadsheet Development principles. This article discusses the practical implementation of these principles in Excel.

From my experience using Modular Spreadsheet Development over the past decade, there are three increasingly-efficient methods of implementation in Microsoft Excel:

1. Manual implementation;
2. VBA automated implementation; and
3. Commercial add-in implementation.

This article provides a comprehensive overview of each of these methods and a summary of their advantages and disadvantages.

Continue »

## Modular Spreadsheet Development – A Thought Revolution

Published on May 7, 2014 in Financial Modeling

This article provides a high level overview of Modular Spreadsheet Development principles. In next part the implementation of these concepts will be discussed.

### Modular Spreadsheet Development – An awesome concept

I want to share a concept with you so awesome that once you understand it you may never use Excel the same way again.

This concept, called Modular Spreadsheet Development, makes it possible to build spreadsheets exponentially faster while reducing the risk of errors and making spreadsheets much easier to understand.

This concept is not completely new, but I’m writing this article because the spreadsheet modelling world would be a much better place if it was more commonly adopted.

Continue »

## Calculate CAGR (Compounded Annual Growth Rate) using Excel [Formulas]

Published on Apr 29, 2014 in Financial Modeling

Lets talk about how we can use Excel to calculate Compounded Annual Growth Rate (CAGR for short).

What is CAGR? What does it signify?

Let us say you are the CEO of ACME Inc. You have been selling various widgets since 2009. In your latest annual report you want to tell your shareholder at what rate you have been growing ACME Inc. sales. The figure are,

• 2009 – \$150 Mn
• 2010 – \$125 Mn
• 2011 – \$160 Mn
• 2012 – \$174 Mn
• 2013 – \$195 Mn
• 2014 – \$210 Mn

Now, if you see the growth rates, they are all over the place. Right from -16.67% to 28%. But you want to report a single annual growth rate.

This is where CAGR (Compounded Annual Growth Rate) comes handy.

Continue »

## Introducing ‘Finance for Non-finance people’ training program

Published on Jan 10, 2013 in Financial Modeling, products

Dear readers & supporters of Chandoo.org,

I am very glad to announce that our brand new online course – “Finance for non-finance people” is now available for your consideration. Please take a few minutes to read this short message to understand what this program is & how it benefits you. If you are ready to join, please click here.

What is Finance for Non-finance people course?

This course aims to teach financial fundamentals & introduce you to the world financial analysis in a no-nonsense way.

We start by introducing financial analysis and the basic jargon. Then we talk about 3 important components of any company’s finances – Balance Sheet, Income Statement & Cash flow Statement.

Then we discuss about various analytical techniques like ratio analysis, valuation mechanisms, break-even analysis.

Finally we explain advanced accounting concepts like long-lived assets, depreciation, explore trend analysis and unit economics.

In a nut-shell, this course takes someone with no finance background and makes them proficient in world of finance.

Continue »

## Macros for Automatically Implementing Modeling Best Practices

Published on Nov 29, 2012 in Financial Modeling, VBA Macros

In the first part on our Modeling Best Practices series, we learned 5 best practices to follow. This article shows how to automatically implement the best practices using macros.

Continue »

## Best Practice Modeling – Make these 5 changes today

Published on Aug 29, 2012 in Financial Modeling

Our guest author, Myles Arnott discusses what Best Practice Modeling is and offers 5 practical, easy to implement tips to get you started.

Best Practice Tip #1: Apply a modeling life cycle
Best Practice Tip #2: Give structure to your spreadsheets
Best Practice Tip #3: Make cells consistent based on their behavior
Best Practice Tip #4: Use similar formulas
Best Practice Tip #5: Build error checks in to your models

Continue »

## Financial Modeling School Price Hike from Tomorrow

Published on Jul 16, 2012 in Financial Modeling

Hi there,

How was your weekend? We had lovely weather. So spent most of the time playing with kids, running some errands & relaxing.

I just want to give you a quick update about our Financial Modeling School. We will be hiking course fees for this program starting tomorrow midnight (Tuesday, 17 July – 11:50 Pacific Time).
If you have been considering to join this program, please go ahead and enroll now to save money.

Continue »

## Join our Financial Modeling Class before fee hike [Quick update]

Published on Jun 20, 2012 in Financial Modeling

Hello lovelies,

I have a quick announcement to make. As you know, we run 2 online courses on Financial Modeling.

1) Financial Modeling School
2) Project Finance Modeling School

After running them for almost 2 years, we are now planning to hike the fees by \$50. See below table to know about new fees.

Continue »

## Creating Cash Flow Statement by Indirect Method – II

Published on Apr 17, 2012 in Financial Modeling

So what’s the cash with Facebook? Last time, we announced the launch of a new module on getting the cash flow statement in our financial modelling course and also discussed the procedure to create the cash flow statement. I had shared with you the template for financial statements for Facebook. I had asked you to implement the steps and create the cash flow model for Facebook!

We know that the devil is in the details. Last time we discussed the process and in this post, we would implement the cash flow statement for Facebook using the indirect method.

Continue »

## Creating Cash Flow Statement by Indirect Method – I

Published on Apr 11, 2012 in Financial Modeling

If there was a challenge in any Finance 101 course at any B School, I think Creating the Cash Flow Statement would score the max. When I was pursuing my MBA, the biggest enigma for me was to go from the Balance Sheet and Income Statement to the Cash Flow statement via the indirect route. I could never get it right!

There were two challenges, the bigger was obviously unclear concepts plus I didn’t know how to play with Excel! I have worked hard on both and let me show you, how they can be used to get the right cash flow statement in no time!

Actually the concept is simple and excel makes it run on steroids!

Continue »

## What is so special about Go To Special? [15 tips]

Published on Mar 12, 2012 in Excel Howtos

We briefly covered Excel’s Go To Special function in the Managing Spreadsheet Risk series and in this post, we are going to explore Go to special feature in detail and learn how to use it.

What is Go To Special?

Go To Special is a tool within Microsoft Excel that enables you to quickly select cells of a specified type within your Excel worksheet. Once you get to grips with this function and what it can be used for you will wonder how you ever lived without it. Read on…,

Continue »