Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

13. Estimate the gross profit for 2021 as follows: a. In cell C15, create a formula without using a function that subtracts the vendor cost

image text in transcribedimage text in transcribed

13. Estimate the gross profit for 2021 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 2021 (cell C10). Use absolute references to each cell in the formula. Copy the formula from cell C15 to the range D15:115 to complete the estimates for 2021. b. C. 14. Complete the growth estimates for the years 2022 to 2025 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 2021 (cell C15). b. Use an absolute row reference to cell C14. Copy the formula from cell C16 to the range C17:C19 to enter the first estimates for 2023-2025. Copy the formulas from the range C16:C19 to the range D16:119 to enter the remaining sales projections. Unit Projections Vendor cost Sales price Shipping cost 2021 sales units 45.98 125.00 7.98 10,000 Gross Profit From Sales Projections Growth estimates 8% 12% 16% S 4% 20% 24% 28% 2021 2022 2023 2024 2025

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Cost Analysis

Authors: Roger Hussey

1st Edition

160649239X, 9781606492390

More Books

Students also viewed these Accounting questions

Question

Wear as little as possible

Answered: 1 week ago

Question

Be relaxed at the hips

Answered: 1 week ago