Commercial Aspects of Project Management
In 2005, fresh out of MBA School, I was put on managing an e-business transformation strategy project. It was then that realized that project management was a full time job (I always wondered before that why PMs were even paid a dime!). We created huge Project Management reports for the client, where were tracked and […]
Scenario Analysis for the Project Valuation [Financial Modeling]
Few months ago, we learned how to create a project valuation model in Excel as part of our series on Financial Modeling in Excel.
My Project Evaluation Model had a limitation!! In one of the personal comments that I received, the reader pointed out an important problem!
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.
9 Excel Tips & Downloads Submitted by Our Readers [Reader Awesomeness Week]
Last week I announced Reader Awesomeness Week to celebrate the passion, attitude and knowledge of our little community here. I got 9 interesting and beautiful entries from our readers. In this post you can see 9 tips & downloads submitted by our readers. These include a project management template, a macro to remove blanks, a technique to make Google Earth maps using Excel and several other interesting tips & tricks.
Go ahead and read them, download attached workbooks and become awesome in Excel. 🙂
Gantt Box Chart Tutorial & Template – Download and Try today
On Firday, we proposed a new chart for showing project plans. I chose an ugly name for it and called it Gantt Box Chart. Essentially, a gantt box chart is what you get when a gantt chart and box plot go to a bar, get drunk and decide to make out. It shows the project […]
A Gantt Chart Alternative – Gantt Box Chart
Traditional project plans use Gantt Charts to depict the plan. While gantt charts work great and provide instant picture of overall plan, they fail to communicate the uncertainty in the plan. In most real world projects, the plans always change. Most of the management energy is spent on controlling and communicating about this plan uncertainty. This is where a project plan like gantt box chart can help. This chart (as shown above) clearly shows the variance in end dates of project tasks thus giving a clear picture of uncertainty in the plan. Read more to find out how this chart can be used in project management.
Excel Links – Project Management Edition
It has been quite a while since we had an excel links post. It doesn’t mean that I am not reading anything new on excel or charting. I have been reading lots of awesome articles and useful content and sharing it on my google reader recommendation list. But it is just that I have been […]