From the course: Excel for Finance: Building a Three-Statement Operating Model

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Forecasting the revenue

Forecasting the revenue - Microsoft Excel Tutorial

From the course: Excel for Finance: Building a Three-Statement Operating Model

Start my 1-month free trial Buy for my team

Forecasting the revenue

“

- [Instructor] Okay, so now that our annual work is done, let's go back to the monthly section of our model and start building it out line by line from the top. I'm going to press control home. Let's go back to the beginning. I'm in the monthly section. And the very first request from the CFO, model out the big box revenue, just keep it as steady state year over year growth, please calculate it, we already did that in the annual section, so we're going to reference it. So let's go out to where our forecast begins. Can we have that nice visual indicator of where we flip from actual to forecast so it's easy to see. We're going to build out just a simple year over year growth formula for this revenue. Now, if you have more extensive FP&A experience might be thinking, well year over year growth isn't comprehensive enough. I hear you on that but the beauty of this model is the groundwork is good, right? So whether you build…

Contents