for cell c14 add an absolute reference and with it being a percentage. 9. Switch to the

for cell c14 add an absolute reference and with it being a percentage. 

Transcribed Image Text:

9. Switch to the Profit Projections worksheet, which sets a schedule for developing and launching the new product and projects its profits for five years. In cell 17, use the TODAY function to insert the current date. 10. In cell 19, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells 17 and 18. Leave the Holidays argument blank. 11. Use the values in the range C14:D14 to fill the range E14:114 with a series of incremented percentages. 12. Use the values in the range B15:B16 to extend the list of years to the range B17:B19 for five years of projections. 13. Estimate the gross profit for 2024 as follows: a. In cell C15, create a formula without using a function that subtracts the vendor cost (cell C7) and the shipping cost (cell C9) from the sales price (cell C8), and then multiplies the result by the projected number of units for sale in 2024 (cell C10). b. Use absolute references to each cell in the formula. C. Copy the formula from cell C15 to the range D15:115 to complete the estimates for 2024. 14. Complete the growth estimates for the years 2025 to 2028 as follows: a. In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2024 (cell C15). b. Use an absolute row reference to cell C14. 9. Switch to the Profit Projections worksheet, which sets a schedule for developing and launching the new product and projects its profits for five years. In cell 17, use the TODAY function to insert the current date. 10. In cell 19, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells 17 and 18. Leave the Holidays argument blank. 11. Use the values in the range C14:D14 to fill the range E14:114 with a series of incremented percentages. 12. Use the values in the range B15:B16 to extend the list of years to the range B17:B19 for five years of projections. 13. Estimate the gross profit for 2024 as follows: a. In cell C15, create a formula without using a function that subtracts the vendor cost (cell C7) and the shipping cost (cell C9) from the sales price (cell C8), and then multiplies the result by the projected number of units for sale in 2024 (cell C10). b. Use absolute references to each cell in the formula. C. Copy the formula from cell C15 to the range D15:115 to complete the estimates for 2024. 14. Complete the growth estimates for the years 2025 to 2028 as follows: a. In cell C16, create a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2024 (cell C15). b. Use an absolute row reference to cell C14.