Question
I need a step by step instruction on how I would enter task in Excel please: 1. Switch to the Profit Projections worksheet, which sets
I need a step by step instruction on how I would enter task in Excel please:
1. 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 I7, use the TODAY function to insert the current date.
2. In cell I9, make a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells I7 and I8. Leave the Holidays argument blank.
3. Use the values in the range C14:D14 to fill the range E14:I14 with a series of incremented percentages.
4. Use the values in the range B15:B16 to extend the list of years to the range B17:B19 for five years of projections.
5. Estimate the gross profit for 2021 as follows:
a. In cell C15, make 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 2021 (cell C10).
b. Use absolute references to each cell in the formula.
c. Copy the formula from cell C15 to the range D15:I15 to complete the estimates for 2021.
6. Complete the growth estimates for the years 2022 to 2025 as follows:
a. In cell C16, make a formula that adds 1 to the growth rate (cell C14) and multiplies the result by the estimated profit from 2021 (cell C15).
b. Use an absolute row reference to cell C14.
c. Copy the formula from cell C16 to the range C17:C19 to enter the first estimates for 2023-2025.
d. Copy the formulas from the range C16:C19 to the range D16:I19 to enter the remaining sales projections.
J1 A B D E F H 1 2 3 MedSight Auditory Instruments Profit Projections Five-year estimates 4 5 Unit Projections Vendor cost Sales price Shipping cost 2021 sales units AtAtA Schedule Current date Product launch Factory days to market 45.98 125.00 7.98 10,000 12/1/2021 Gross Profit From Sales Projections Growth estimates 8% 4% 2021 2022 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Incomplete worksheet Cost Analysis Profit Projections (+
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started