All articles with 'Financial Modeling' Tag
I have a quick announcement to make. As you know, we run 2 online courses on Financial Modeling.
1) Financial Modeling School
2) Project Finance Modeling School
After running them for almost 2 years, we are now planning to hike the fees by $50. See below table to know about new fees.Continue »
So what’s the cash with Facebook? Last time, we announced the launch of a new module on getting the cash flow statement in our financial modelling course and also discussed the procedure to create the cash flow statement. I had shared with you the template for financial statements for Facebook. I had asked you to implement the steps and create the cash flow model for Facebook!
We know that the devil is in the details. Last time we discussed the process and in this post, we would implement the cash flow statement for Facebook using the indirect method.Continue »
If there was a challenge in any Finance 101 course at any B School, I think Creating the Cash Flow Statement would score the max. When I was pursuing my MBA, the biggest enigma for me was to go from the Balance Sheet and Income Statement to the Cash Flow statement via the indirect route. I could never get it right!
There were two challenges, the bigger was obviously unclear concepts plus I didn’t know how to play with Excel! I have worked hard on both and let me show you, how they can be used to get the right cash flow statement in no time!
Actually the concept is simple and excel makes it run on steroids!Continue »
We briefly covered Excel’s Go To Special function in the Managing Spreadsheet Risk series and in this post, we are going to explore Go to special feature in detail and learn how to use it.
What is Go To Special?
Go To Special is a tool within Microsoft Excel that enables you to quickly select cells of a specified type within your Excel worksheet. Once you get to grips with this function and what it can be used for you will wonder how you ever lived without it. Read on…,Continue »
Project Managers often report financial numbers to the management. In a dynamic world, these numbers are usually based on a lot of factors that may or may not be under your control. So the top management demands that the numbers be reported as per different economic scenarios – Optimistic, Normal or Pessimistic. It is important […]Continue »
Background – Spreadsheet Risk Management
In the Managing Spreadsheet Risk series so far we have looked at the concept of spreadsheet risk and how to manage it both at a company level and at a spreadsheet level using Excel functionality. In this final article we are going to have a quick look at an example of spreadsheet auditing software.
What to look for in a Spreadsheet Risk Management Software
First off I should state that there is a wide range of spreadsheet auditing solutions in the marketplace of different types and styles and at a variety of costs. In this section I would like to take a little time to explain the criteria we applied when we were sourcing auditing software.Continue »
This series of articles will give you an overview of how to manage spreadsheet risk. These articles are written by Myles Arnott from Excel Audit Part 1: An Introduction to managing spreadsheet risk Part 2: How companies can manage their spreadsheet risk Part 3: Excel’s auditing functions Part 4: Using external software packages to manage […]Continue »
In the second installment on Excel Spreadsheet Risk Management, Myles takes a look at How companies can manage spreadsheet risk?.
He tells us, how we can set a formal governance framework to reduce or mitigate spreadsheet risk. Go ahead and read. And please tell us how your company manages spreadsheet risk in comments.Continue »
Have you created models which run into 20 – 30 years? You might have noticed that navigating to the last year (the last column) is probably the most boring part (and also the most time consuming part). Excel does provide you a shortcut (Ctrl + end), but that hardly works! It’s been a while since […]Continue »
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 […]Continue »
Offset() function to Calculate IRR for Dynamic Range When you start the project can you be sure, for how long will you operate it? A VC gives you funds to buy a commercial project. You are to operate the project for some time and then sell it off! Can you tell me today, when you […]Continue »
On a cup of green tea with a friend I grabbed the golden rule of accounting. It is simple (You can easily miss if it came your way!) and can be applied to almost all the accounts (Depreciation, Gross Block, Cash, Equity, Debt) – You name it, and you have to use it! So concentrate […]Continue »
Hello friends & readers of Chandoo.org,
I am very excited to tell you that our financial modeling & project finance classes are open for registration starting today.
In this article, you can learn about our training program, how it can help you & payment instructions.Continue »
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!Continue »
Last time we had discussed the use of SumProduct() to ease your life for calculation of consolidated revenues and depreciation. This time we would be using the sum function! Yes you heard it right – The Sum function.
But we would use the Sum function with a small trick! We would use it to calculate running cumulative sum! And believe me, you would need this function so many times – to calculate accumulated depreciation, cumulative debt, Profits to Retained Earnings and almost all the accounts that would consolidate into the balance sheet.Continue »