Answered step by step
Verified Expert Solution
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 ...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