Please answer the question and also complete the excel part! Thanks!

B D E F G H j Question 1 1 1 pils units For a new product, sales volume in the first year is estimated to be 80.000 units and is projected to grow at a rate of 4% per year. The selling price is $12 and will increase by $0.50 each year. Per-unit variable costs are $2, and annual fixed costs are $400.000. Per unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. Develop a spreadsheet model in worksheet NPV to calculate the net present value of profitaver a 3-year period, assuming a 4% discount rate. Use good spreadsheet engineering principles, such as separating data from calculation, breaking complex calculation into smaller parts, etc. According to your calculation, the NPV of total profits is 8 1 2 3 A 1 New Product Sales 2 Beginning Sales volume 3 Growth in sales volume per year 4 Beginning selling price 5 Increase in selling price per year 6 Beginning variable cost per unit 7 Beginning annual fixed costs Increase in varibale cost per year 9 Increase in fixed cost per year 10 Discount rate 11 YEAR 11 YEAR 12 Sales volume 13 Selling price 14 Sales revenue 15 16 Unit variable cast 10 unit 17 Variable costs 18 Fixed costs 10 19 Total costs 20 Profit 21 NPV 22 23 24 B D E F G H j Question 1 1 1 pils units For a new product, sales volume in the first year is estimated to be 80.000 units and is projected to grow at a rate of 4% per year. The selling price is $12 and will increase by $0.50 each year. Per-unit variable costs are $2, and annual fixed costs are $400.000. Per unit costs are expected to increase 5% per year. Fixed costs are expected to increase 8% per year. Develop a spreadsheet model in worksheet NPV to calculate the net present value of profitaver a 3-year period, assuming a 4% discount rate. Use good spreadsheet engineering principles, such as separating data from calculation, breaking complex calculation into smaller parts, etc. According to your calculation, the NPV of total profits is 8 1 2 3 A 1 New Product Sales 2 Beginning Sales volume 3 Growth in sales volume per year 4 Beginning selling price 5 Increase in selling price per year 6 Beginning variable cost per unit 7 Beginning annual fixed costs Increase in varibale cost per year 9 Increase in fixed cost per year 10 Discount rate 11 YEAR 11 YEAR 12 Sales volume 13 Selling price 14 Sales revenue 15 16 Unit variable cast 10 unit 17 Variable costs 18 Fixed costs 10 19 Total costs 20 Profit 21 NPV 22 23 24