fbpx
Search
Close this search box.

All articles with 'Financial Modeling' Tag

Displaying & Selecting a Scenario using VBA [Modeling in Excel]

Published on Sep 24, 2010 in Financial Modeling, VBA Macros
Displaying & Selecting a Scenario using VBA [Modeling in Excel]

If you are building financial models or any other type of excel based decision models, chances are, there will be multiple scenarios in your model. Whenever you have multiple scenarios, you may want an easy, intuitive way to select one of them. In this post, I will present an interesting scenario display & selection technique that I received by email from our reader Itay Maor.

Continue »

Putting it all together – Final Project Evaluation Model [Part 6 of 6]

Published on Sep 21, 2010 in Financial Modeling, Learn Excel

This is a guest post written by Paramdeep from Pristine. Chandoo.org is partnering with Pristine to bring an excel financial modeling online training program for you. This is Part 6 of 6 on Financial Modeling using Excel In this tutorial we are going to learn how to build assumptions & input sheets in our excel […]

Continue »

Modeling & Building Cash-flow Projections for Project Valuation [Part 4,5 of 6]

Published on Sep 2, 2010 in Financial Modeling, Learn Excel
Modeling & Building Cash-flow Projections for Project Valuation [Part 4,5 of 6]

In the 4th and 5th part of our financial modeling series, we will learn how to model and build cashflow projections for project valuation.

We will understand the basics behind cash-flow modeling, what kind of non-cash expenses should be added back to get the free cash-flow. You can also get the blank and completed cash-flow projection worksheets to practice these techniques.

Continue »

We have updates!!!

Published on Aug 30, 2010 in blogging
We have updates!!!

I hate to interrupt the regular programming at Chandoo.org. But I have to give you a few updates before its too late. So here we go: Only 2 days before Wedding Planner price goes up by 50%: Many of you know that we have released a wedding planner software built purely using Excel.  You have […]

Continue »

Building Inputs & Assumptions Sheets – Excel Financial Modeling [Part 3 of 6]

Published on Aug 23, 2010 in Financial Modeling, Learn Excel
Building Inputs & Assumptions Sheets – Excel Financial Modeling [Part 3 of 6]

In the third part of our series on Excel Financial Modeling, we teach you how to make an assumptions worksheet to keep track of various investment, working capital and operational assumptions related to project valuation in place.

You can also download the blank worksheet in which you can fill-up assumptions after reading the business case.

Continue »

12 Rules for Making Better Spreadsheets

Published on Aug 5, 2010 in Financial Modeling, Learn Excel
12 Rules for Making Better Spreadsheets

As part of reader awesomeness week, today I am featuring a list that Larry sent me with 12 beautifully defined rules for making better spreadsheets. He says that spreadsheets should be easy to understand, have a clearly defined purpose and should use Excel features as much as possible. I totally agree with him.

Read the rest of this post to find the rules and download a poster containing these rules. Thanks Larry.

Continue »

Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]

Published on Jul 28, 2010 in Financial Modeling
Building a Layout for Project Evaluation Model & Best Practices [Part 2 of 6]

In the second part of our tutorial we will learn how to prepare the layout of our model to do project evaluation.

If you know basic referencing and formula framework in excel, you can write a model that calculates numbers. Good vs Bad financial model would be decided by the layout of the model.

Before we start discussing on how to build a good layout, lets see the layout that I have in mind. The layout is based on my experience of working as an investment banker and as a consultant and I find it neat.

Continue »

Introduction to Financial Modeling using Excel [Part 1 of 6]

Published on Jul 21, 2010 in Featured, Financial Modeling, Learn Excel
Introduction to Financial Modeling using Excel [Part 1 of 6]

In this and next 5 posts, we are going to learn how to build a financial model to do project evaluation using Excel. The 6 parts of this tutorial are,

  1. Introduction to Financial Modeling
  2. Building a layout for Project Evaluation Model – Best practices
  3. Building Inputs and Assumptions Sheet
  4. Building Projections for Project Evaluation
  5. Modeling the Cash Flow Statement and Projections
  6. Putting it all together – Final Project Evaluation Model

What is financial modeling?

Financial modeling is creating a complete program/ structure, which helps you in coming to a decision regarding investment in a project/ company. Now this could be on a simple piece of paper or in excel. The advantage with excel is that, even if you have calculation speed and accuracy like me (this is one place where I am like Einstien!), then also you would be able to come to the right conclusion!

Continue »

Do You Want to Learn Excel Financial Modeling?

Published on Jul 6, 2010 in Financial Modeling, Learn Excel
Do You Want to Learn Excel Financial Modeling?

Very Quickly, Chandoo.org is partnering with Pristine to start a free course on financial modeling using excel. If you are interested, take this short survey and tell us what topic you want to learn. Back Story One of the advantages of going to a premier MBA college is that you are bound to have good […]

Continue »