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.

Dynamic charts are like my favorite food, Mangoes. They tempt, tease and taste awesomely. In this post, we are going to learn how to create a dynamic chart using check boxes and formulas as shown in the animation aside. Are you ready for some excel chart cooking?

You can also download a FREE Dynamic chart template from the post. So go ahead and make your boss drool.

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 2 more [...]

Today we have home work for you. You need to help Johnny figure out how many hours he worked on splitting atoms. He has crazy boss who is behind him for that timesheet. Now Johnny needs your help to write the correct formula so that he can tell his boss how many hours he worked and go home.

Go ahead and read rest of this post and tell your answers using comments. Go!

In todays post I review Excel Everest, an excel spreadsheet that teaches you how to use excel. In this post I am going to review the product and recommend it you.

What more, you can get it for 20% off if you use the discount code chandoo. Go ahead and read rest of the review.

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.

Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?

Now, how do you go about making a chart?