fbpx

All articles with 'Financial Modeling' Tag

Details about our Financial Modeling Class

Published on Jul 18, 2011 in Financial Modeling

Hi there,

Do you know that Chandoo.org run an online training program on Financial Modeling & Project Finance Modeling?

So far, we have trained more than 200 students thru this program and now, I am excited to announce that from July 27th, you can join this course again.

Read this short post to understand how our program can benefit you.

Continue »

Sumproduct function to Consolidate Revenues?

Published on Jul 12, 2011 in Excel Howtos, Financial Modeling

Chandoo.org is all about simplifying life using Excel. When I first started visiting the site, I was amazed at the amount of information on the site, which made your life easier. My next few posts would be about excel functions which can make your life for Financial Modeling easier! These are simple examples that you […]

Continue »

NPV() function to calculate Present Value

Published on Jul 5, 2011 in Financial Modeling, Learn Excel
NPV() function to calculate Present Value

Today, let us learn how to use NPV() function in Excel & create a simple financial model.

If you are dealing with cash and valuations, you are bound to have come across the NPV function. If you don’t know the assumptions behind the same, I bet it could cost you your job!

Let’s take a simple project – You buy a MSFT stock for USD 100. You receive a dividend of USD 10 in the first year, USD 20 in the second year, USD 40 in the third year and then you sell it out for USD 140. If you could have alternatively put this money in bank at 10% interest rate, have you gained anything?

How do you model this in excel? In this tutorial we understand how you can use NPV to do this analysis and what kind of pitfalls you can land into!!

Continue »

Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]

Published on Jun 16, 2011 in Financial Modeling, Training Programs
Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]

Hello Friends & Readers,

Our Singapore Excel & Financial Modeling Boot-camp is ready for your consideration.

We will be conducting it from July 8th to 10th.

Please read this short page to know details about the program and how to enroll.

Who is this boot-camp for?

This boot-camp is aimed at business analysts, financial analysts & managers, who use Excel all the time. If you are an Excel new-bie, this boot-camp is not for you. Otherwise, you will enjoy this.

Continue »

Do you want to attend an Excel Workshop in Singapore? [Survey]

Published on Jun 3, 2011 in Financial Modeling, Training Programs
Do you want to attend an Excel Workshop in Singapore? [Survey]

I have happy news for you.

Paramdeep (from Financial Modeling School) and I am going to organize an Excel Workshop in Singapore during first (or second) week of July.

We want to know if you are interested in this. So please take a few minutes and go thru this small post.

Who is this workshop for?

If you are a financial or business analyst, this workshop is for you. We will be discussing various Excel & Financial Modeling topics during the 12 hour workshop (spread across 2-3 days)

Continue »

Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]

Published on May 24, 2011 in Financial Modeling, Learn Excel
Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]

You take an apartment on rent at $1000 per month and the owner puts an escalation clause saying 10% increment each 3 years. How do you model this in excel? In this tutorial we understand how escalations at certain frequency can be implemented using the mod function in excel. What is the mod() function Simply […]

Continue »

3+1 Ways to Learn Advanced Excel

Published on Mar 2, 2011 in Financial Modeling, Learn Excel, products
3+1 Ways to Learn Advanced Excel

Many of us want to learn advanced Excel and make progress in our career. But how to do it? In this post, I show 3+1 ways in which you can learn advanced excel.

Last week I did an interview with Robert Mundigl of clearlyandsimply.com. Robert is an Excel wizard. You may know him thru the KPI Dashboard articles he has written on chandoo.org a while ago.

We spent about 90 minutes discussing some really cool & advanced Excel stuff. The interview will be available shortly on Excel School for our Dashboard students. But here is a snapshot of the dashboard we discussed in the interview. Robert taught me how to make such a dashboard using Excel.

Continue »

Financial Modeling School is Open, Please Join Today

Published on Feb 23, 2011 in Financial Modeling, products
Financial Modeling School is Open, Please Join Today

Hi my friends & readers of chandoo.org,

I have an exciting news for you. We have just opened the doors for our financial modeling course.

Please click here to learn more about the program & join.

What is Financial Modeling School?

This is an online training program for financial modeling, project finance modeling. I have partnered with Pristine Education, a company in India that specializes in Financial Modeling training to conduct this program.

This program is aimed at investment bankers, financial analysts, commercial bankers, equity research associates, project managers, sponsors, real estate project managers etc. to help them understand the nuances of project finance, financial modeling and create complex financial models using MS Excel.

Read rest of this post to learn more about the program.

Continue »

Details about upcoming Financial Modeling School

Published on Feb 18, 2011 in Financial Modeling, products
Details about upcoming Financial Modeling School

We are opening Financial Modeling School for 2nd batch of classes on 23rd February. It feels very exciting to re-run this successful program. I want to share a few details about the program so that those of you interested to join can know more about it.

Please read this short post to learn 10 things about the financial modeling school program.

Continue »

Modeling Interest During Construction (IDC) – Excel Project Finance

Published on Feb 16, 2011 in Financial Modeling, Learn Excel
Modeling Interest During Construction (IDC) – Excel Project Finance

In the second part of our series on project finance using Excel, Paramdeep tells us how to model “interest during construction” in real estate and construction type of projects. We take a case of hospital construction and learn how to calculate the IDC using circular references.

You can also download both blank and completed model so that you can test the skills.

Continue »

Introduction to Project Finance Modeling in Excel

Published on Feb 8, 2011 in Financial Modeling, Learn Excel
Introduction to Project Finance Modeling in Excel

This is a guest post written by Paramdeep from Pristine. Chandoo.org runs Financial Modeling School program in partnership with Pristine Careers. Visit Financial Modeling School to learn more and sign-up for our newsletter.

Greetings!

It’s been long time since we interacted on Chandoo.org. Actually I was very busy teaching the 105 awesome students for financial modeling in Excel. We all worked together to create some easy and some complex financial models. I found the journey to be quite exciting and enriching (From the feedback that I got, my students too didn’t find it bad either 😉 )

During the interaction, I found that a lot of students were looking for financial modeling around the project financing as well. So we thought why not introduce financial modeling for project finance.

In this post I will speak about some of the key aspects of a project finance model and why it can be different from modeling a normal company.

Continue »

FREE Excel Financial Model for Analyzing an IPO – Download Today

Published on Oct 22, 2010 in Financial Modeling

Lets keep this quick and short, As some of you may know, There is a mega IPO (initial public offering) going on in India these days. It is for a company called Coal India Ltd. So my partners at Pristine Education thought, it would be cool to build a financial model analyzing the IPO. Click […]

Continue »

Financial Modeling School is now Open – Register today!

Published on Oct 18, 2010 in Financial Modeling

Hi all,

A very quick announcement. We have opened Financial Modeling School for registrations now. Click here to learn more about the program and sign-up.

You get $100 discount if you are one of the first 100 students to sign-up. So go ahead and enroll today.

Continue »

Financial Modeling School Coming on Monday [Details Inside]

Published on Oct 14, 2010 in Financial Modeling, products
Financial Modeling School Coming on Monday [Details Inside]

Financial modeling is a no catwalk. You can not look pretty, wear ridiculous outfits and expect to find if a project is worth investing money in. That is why I am very happy to announce Financial Modeling School.

Please read this short post to learn more about the program.

Continue »

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 »