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 managed 9 outside vendors and our team. As if tracking the project was not a nightmare, one day the partner on the project commented – “Phew! Even after so much of effort we may not generate the hurdle rate!”

It dawned on me – finance was also a crucial part of Project Management.

All the PM templates

We had all those great looking Gantt Charts, issue tracking sheets and a whole lot of other project management and tracking tools. Obviously they were not as great as Chandoo’s PM templates (He is the host here! ;-))

clip_image002

But they were fine. We had the project under control and everything seemed to be fine. But the client had put in a clause which said that we would be not be paid per month, but based on reaching certain milestones. The project direction had been changed and unluckily we were to reach the contracted milestones late!

It’s all about money honey!

From my experience I realize that most of the project managers are concentrated on making sure that the delivery is on time. They don’t step back and think whether their action makes business sense. After the bitter pill, I realized that businesses (and the projects) were there to make money. If you lose sight of that objective, it can hit you hard.

All the project managers should be ready to learn at least a bit of finance and financial statements.

Accountants have their own language!

Just like all natives of England speak English, France speak French, Microsoft speak dot net, Sun speak Java – Accountants and Finance guys speak GAAP (or a variant – IFRS!). They have their own accounting principles.

Now if you visit France, you may not want to be an expert in French. Believe me it never hurts to know a few words in French. Since business is all about making money, it would never hurt to know the language of the finance people.

Basically Finance guys follow standards called GAAP (Generally Accepted Accounting Principles) or IFRS (International Financial Reporting Standards). It tells you the policy of telling what would be revenue, costs, capital expenditure, etc. Based on these principles, companies communicate the financial statements to the outside world. Once you know the principles, you can interpret them and understand about the performance of the company.

Where can I see them speak?

All the public companies in US have to give out their financial statements in the form of 10K (Yearly) and 10Q (Quarterly) statements. These are listed on sec.gov.in, EDGAR database and are free for you to download. The basic process is very simple.

· Just visit: http://www.sec.gov/edgar/searchedgar/companysearch.html and search for your favorite listed company

clip_image004

· Click on your selected company

clip_image006

· Select the relevant report

clip_image008

· And you can get to the financial statements (Consolidated)

clip_image010clip_image012

Similarly you can create your own financial statements for the project. It need not be exactly compliant with what the accountants have to say, but it should definitely be close.

You want to learn more?

Pristine and Chandoo.org are planning to launch a course on Excel for Project Managers. This course enables Project Managers do their work better by using Excel & Financial concepts.

This would be an online course and we are expecting to launch the program by first week of November.

Next Steps

What has your experience been with Commercial aspects of Project Management? Lets discuss the issues that you faced and I will try to explain the basics of financial statements in some of the next posts. Hope that you find them interesting.

For any queries regarding the cash impact or financial modeling, feel free to put the comments in the blog or write an email to paramdeep@edupristine.com

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

12 Responses

  1. Hello Chandoo and Pristine,

    The concept of running a Project Managers course sounds VERY interesting! I am currently enrolled in the VBA and my general productivity is increasing immensely as a result.

    I look forward to hear exactly what the idea of the course is. I am rather junior in my organisation so the only project management I do is either myself, one other person (or sometimes my bosses work !!). I am interested not just in knowing some cool tips for helping the process in EXCEL but also general tips; I look forward to hearing what this new course will offer!!

    Happy customer;
    -Nick

  2. Hello Chandoo & Pristine.

    I’m a Product Manager (kind of multiple Projects manager here) and I am asked now to add the “financial” part of development management in my reports. We are trying to build a dashboard for both Project Managers and managers.

    I’d love to attend this course. Will have to ask my boss though. 🙂

    -Cyril

  3. Not sure what your degree was in but this whole column is stating the obvious. Any decent System Analysis and Design class would hit this point let alone any finance degree program. Granted I did most of my finance coursework before my MIS work.

    Chandoo’s PM templates are elementary so if you did not have tools that were at lest as good Chandoo’s then your company was clueless about project management. Then again my companies IT department is clueless about project management so it is a pretty common problem. You would think they would ask for help from our project management department which does construction PM.

  4. Asking questions are in fact nice thing if you
    are not understanding something completely, except
    this paragraph offers nice understanding even.

  5. Firslty, I think you are awesome.

    But, emphasising the necessity for project managers to grasp basic finance concepts and communicate effectively with financial teams can significantly improve project outcomes. I’ve had to enage with finance teams on several projects, and the larger it is, the more important it is. Tracking the different aspects of spend, and the cashflow (so when things are going to hit the bank account) is really important. Great read!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.