From the course: Excel: Financial Modeling with Dynamic Arrays

Unlock this course with a free trial

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

Calculating revenue

Calculating revenue - Microsoft Excel Tutorial

From the course: Excel: Financial Modeling with Dynamic Arrays

Start my 1-month free trial Buy for my team

Calculating revenue

“

- [Instructor] Once you are happy with your assumptions, you can use them to calculate the revenue of the business. Let's jump back to our model and go to the operations tab. And before we calculate the revenue, let's have a look at these helper rows across the top. So you can see here that we've used a named range called years, to populate out how far we're going to go. And you can find the name by going to the name box. You can just click on years and it will take you to the assumptions there. You can see that we also have another named range called start date, which we'll use in a minute. So you can see here also that we've used an INT function, which will round down the month divided by 12 to the nearest integer, and we'll use that to calculate our indexation a little later on in the model. So what we'll do now is add our months across the top, and we can do that using an edate. So our start date we know is going to be the named range start, and we want to now add on the number of…

Contents