Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Show results for case 1-3 by changing sales growth and price increase Year 1 $50,373,252.50 Year 2 $53.570,694.70 Year 3 $56,971,094.54 Year 4 $60,587.334.77 42,471,721.67

Show results for case 1-3 by changing sales growth and price increase



Year 1 $50,373,252.50 Year 2 $53.570,694.70 Year 3 $56,971,094.54 Year 4 $60,587.334.77 42,471,721.67 $18,115,613.10 Year 5 $64,433,115.85 Year 6 $68,523,007.87 Year 7 $72,872,505.80 Year 8 $77,498,088.10 4 Sales 5 Cost of Goods 6 Gross margin 35,311,650.00 37.553,056.98 $16,017,637.71 39.936,737.28 $15,061,602.50 45,167,614.21 48,034,628.52 51,083,626.56 $17,034,357.27 54326,159.76 7 Expenses 8 Advertising s19,265,501.64 $20,488,379.35 $21,788,879.23 $23,171,928.34 $4,031,110.20 $4, 286,905.58 $4,558,937.56 $4,848,236.78 Maintenance $5,155,899.27 $5,483,090.63 $5,831,050.46 $6,201,097.05 500,000.00 600,000.00 440,000.00 10 Rent 11 Salaries 12 Shipping 13 Supplies 14 Web Services 15 Total Expense 16 17 Operating Income 18 Income Tax a9 Net Income 20 520,000.00 555,000.00 420,000.00 1,065,000.00 6,428,483.36 1,000,000.00 1,134,225.00 1,207,949.63 1,286,466.35 390,000.00 400,000.00 1,370,086.66 6,044.790.30 1,813.437.09 6,836, 531.35 7,270,480.17 1,459,142.30 1,553.986.55 1,928,545.01 7.731,973-90 8,222,760.94 8,744.700.70 2,050,959.40 2,181,144.05 2,319,592.17 2,466,828.28 9,299.770.57 604,479.03 2,623,410.21 2,789,931.17 929,977.06 642,848.34 683,653.13 727,048.02 85,000.00 773,197.39 822,276.09 874,470.07 90,100.00 95.506.00 101, 236.36 $16,856,095.01 107,310.54 $14,078,816.62 $15,041,882.29 $15.799,812.45 113,749.17 120,574.12 127,808.57 $17,929,439.62 $18,898,791.79 $20,043,347.86 $21,302,570.97 $982,785.88 $975.755.43 $1,234,544.82 $1,259,518.09 $1,336,062.02 $1,589,587.56 $324,319.34 $321,999.29 $407,399.79 $1,745,531.37 $1,869,357.38 $658,466.54 $415,640.97 $440,900.47 $524, 563.90 $653.756.14 $827,145.03 $576,025.35 $616,887.93 $843,877.12 $895,161.55 $1,065,023.67 $1,169,506.02 $1,252,469.44 21 22 Assumptions 23 Units Sold in Prior Year 24 Unit Cost 25 Annual Sales Growth 26 Annual Price Increase 27 Margin 28 235.411 $150.00 3.25% 3.00% 29.90% 29 30 Case Year 1 Year 2 Year 3 Sales Growth Price Increase Year 4 Year 5 31 Year 6 Year 7 Year 8 Net Income Net Income Net Income 32 Net Income Net Income Net Income Net Net 1 4.255 2.00% Income Income 33 2. 2.25% 3.00% 34 3 1.25% 4.005

Step by Step Solution

3.45 Rating (152 Votes )

There are 3 Steps involved in it

Step: 1

STEP 1 Create a Excel sheet as shown in the Question as below Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 SALES 50373252 53570695 56971095 ... 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

Step: 3

blur-text-image

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

Criminal Law And Procedure

Authors: John M Scheb, John M Scheb II

6th Edition

0495095486, 9780495095484

More Books

Students also viewed these Business Writing questions

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago