From the course: Excel: Learning Cash Flow Forecasting

Unlock this course with a free trial

Join today to access over 24,600 courses taught by industry experts.

Solution: Forecasting the profit and loss and scenarios in Excel

Solution: Forecasting the profit and loss and scenarios in Excel

From the course: Excel: Learning Cash Flow Forecasting

Start my 1-month free trial Buy for my team

Solution: Forecasting the profit and loss and scenarios in Excel

“

(upbeat music) - [Instructor] Let's take a look at some possible solutions for this highly practical challenge. Recall what you were tasked with doing. First, you were tasked with increasing prices between five and 15%. Well in my model, I created an input cell for price increases over here on my assumptions page. In C24, you'll note that I have price increase, and then in blue font, 0%. To make this easy to understand and a value that I can use throughout my model, I'm actually going to name this input. I'm going to type in in my name box up here to the left, price_increase, and hit Enter. Now when I do, I can put my cursor anywhere in the field on this worksheet or somewhere else, type in equals price, here's price_increase, hit Tab, and it gives me that 0%, but that's not all. What I'm going to do is use my keyboard shortcut Control + H for find and replace. So what I want to do is I want to find anything that refers to assumption C24, and I want to replace it with the name…

Contents