1. Without using a function, calculate the 5% projection in 2024 using a formula that subtracts the manufacturing cost and the shipping cost from the sales price and then multiplies the result by the number of sales units. The formula should always reference those exact cells. Copy the formula across the row. 1. Calculate the 5% projection in 2025 by adding 1 to the percentage and then multiplying the result by the 2024 projection. Update the formula to always reference the percentage row. Copy the formula down to fill the remaining years, and then across to fill the remaining percentages. 1. The table is now complete. Delete the row of text below the table