-
How to Balance Your Forecasted Balance Sheet
A few months ago, I spoke with a financial analyst who didnโt know how to efficiently balance a forecasted balance sheet. Itโs a common challenge, so I thought Iโd share a simple approach that might help those diving into 3-statement modeling. The key? ๐ฆ๐๐ฎ๐ฟ๐ ๐๐ถ๐๐ต ๐ฎ ๐ฏ๐ฎ๐น๐ฎ๐ป๐ฐ๐ฒ๐ฑ ๐ฏ๐ฎ๐น๐ฎ๐ป๐ฐ๐ฒ ๐๐ต๐ฒ๐ฒ๐ ๐ฎ๐ป๐ฑ ๐ฏ๐๐ถ๐น๐ฑ ๐๐๐ฒ๐ฝ ๐ฏ๐ ๐๐๐ฒ๐ฝ, rather โ
-
What Makes a Great Financial Model in Excel?
In past FP&A roles, I often used the slower days around the holidays to refine and improve my models.ย Itโs a great time to step back and reflect, and ask the same question that I have posed to candidates over the years:ย What does good financial modeling look like in Excel? Below is my answer: The โ
-
How to Validate Financial Models Effectively
I have seen a lot of posts on how to create a financial model. But how do you check a model done by somebody else? This is how I do it: (1) Validate the change in the forecast with simple mathNo matter how complicated the model, somebody will try to do math in their head. โ