Creating Cash Flow Statement by Indirect Method – II
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.
Compare 2 Excel Files using View side by side Mode [Quick Tip]
Often we have 2 workbooks with same data structure but different data. We want to compare both and see how they differ. Lets talk about view side by side mode in Excel and how we can use it in situations like these.
Last chance to sign-up for my Australian Excel Masterclass [Reminder]
Hi readers,
Just a quick reminder. We are closing early-bird discount for my Australian Excel & Dashboards Masterclass on 16th April. So if you want to attend my training program in Sydney, Melbourne or Brisbane, you have very little time left to sign-up.
Click here to sign-up for Advanced Excel & Dashboards Masterclass.
Formula Forensics 018. Retrieving the Nth number from a Range which has Gaps.
Over Easter, while we were all busy eating our Easter Eggs, at the Chandoo.org/Forums, Slk213 was worried about how to retrieve the Nth number from a row of data which had gaps in it.
Today in Formula Forensics we will look at how to solve this problem.
Creating Cash Flow Statement by Indirect Method – I
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!
Consolidate data from different excel files (VBA)
Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.
There are Easter eggs in this file!!!
Hello Friends…,
Happy Easter 2012
It is Easter time again. It has been our tradition to hide some Easter eggs so that you have fun discovering them. I usually hide the eggs in the blog post. But this year, I went one more step and created an Excel file with 3 hidden Easter eggs.
Go ahead and find the eggs. I am sure you will love them 🙂