### Goalseek Example 1- Question

*To follow along go to 15.6*

## YouTube

## If YouTube doesn’t work, click here

Use Goalseek to find solutions as explained below

- Product 1: Net Profit % on retail price of 12.5% given that only Costs can change
- Product 2: Net Profit % on Selling Price of 25% given that the retail price can change
- Product 3: What must the Retail Price be if the total of Discount and Costs can only be 750 000

### Goalseek Example 1- Solution

## YouTube

## If YouTube doesn’t work, click here

### Goalseek Example 2- Question

*To follow along go to 15.7*

## YouTube

## If YouTube doesn’t work, click here

Without creating a circular reference we need to provide a bonus based on profit after tax of 10%

of the profit after tax

### Goalseek Example 2- Solution

## YouTube

## If YouTube doesn’t work, click here

### Goalseek Example 3- Question

*To follow along go to 15.8*

## YouTube

## If YouTube doesn’t work, click here

We need to achieve a total Profit after tax after 5 years of 500 000. Using Goalseek try and achieve this with the following constraints:

- We can change the inflation rate on the selling price BUT the inflation on cost price must always be 1% more than the selling price inflation
- The maximum we can allow the selling price inflation to go to is 8%
- We can’t change year 1 and 2’s units sold as we are quiet certain about that, but we can increase the sales in Year 3 to 5. The pattern will stay the same so you need to increase it as a curve i.e. all 3 years increase by 10% for example.
- The net result of the above changes must give a Total Profit After tax after 5 year (Cell L32) of 500 000

### Goalseek Example 3- Solution

## YouTube