Show results for case 1-3 by changing sales growth and price increase Year 1 $50,373,252.50 Year 2
Fantastic news! We've Found the answer you've been seeking!
Question:
Show results for case 1-3 by changing sales growth and price increase
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
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 ... View the full answer
Posted Date:
Students also viewed these business writing questions
-
Cost of debt, iD 5.43% Corporate tax rate, TC 10.99% Total debt, D 57,104,000,000 Total equity, E 91,560,000,000 Total value of the firm, V 148,664,000,000 Beta, 0.61% Return on the market, iM 11%...
-
Jack purchased a share one year ago for $9.12, and it is now worth $11.86. The share paid a dividend of $1.74 during the year. What was the share's income rate of return during the year? (as a...
-
Show that the growth rate in an index futures price equals the excess return of the portfolio underlying the index over the risk-free rate. Assume that the risk-free interest rate and the dividend...
-
Compute the given derivatives with the help of formulas (1)(4). (a) (b) d dx (1) - x=e
-
Suppose that X1, . . . , Xn comprise a random sample from the normal distribution with unknown mean and variance 1. Suppose that it is desired to test the same hypotheses as in Exercise 3. This...
-
For the system shown in Fig. 8.17, compute the power delivered by the pump to the water to pump 50 gal/min of water at 60F to the tank. The air in the tank is at 40 psig. Consider the friction loss...
-
Sara Beth made annual deposits of $5,000 in an account that paid 4 percent compounded annually. How much money should be in the account immediately after her tenth deposit?
-
In the late 1970s, Kip Tindell (chairman and CEO), Garrett Boone (Chairman Emeritus), and John Mullen (architect) drew up plans for a first of a kind retail store specializing in storage solutions...
-
12) Multiply on a clock: 54 13) Compute 37 mod 7
-
Kate, Bob and Tim work in your team. Each has a separate work role but must liaise with each other to coordinate the workflow and to complete overall team tasks.There is a problem between Kate and...
-
Bruno Corporation is authorized to 20,000 shares of 6%, $100 par, cumulative, convertible preferred stock and 100,000 shares, $10 par value common stock. Bruno has outstanding 6,000 shares of...
-
Kristen's cookie company use case Assume that Kristen is busy during the 6 minutes of mixing time. Submit a report answering the following questions: How long will it take you to fill a rush order?...
-
Analyze and discuss any Fiscal/Monetary Policy recently implemented by the Government of an African country - Nigeria (in recent 0 - 5 years). How has this Policy impacted the Business...
-
Select all that apply The grant date is the date when Multiple select question. the stock options are awarded to individual employees. the expected life of the options has expired. the grant's terms...
-
ECONOMIC DEVELOPMENT Explain your WHY and what interests you about the problem you want to solve. What factor(s) in What Makes A Good Case Study are relevant to you? Explain what you'd like to know...
-
Select all that apply Net income attributable to noncontrolling interests will be a reduction in arriving at net income attributable to controlling shareholders. is an expense in the consolidated...
-
What are the purposes and structure of a balance sheet? a. The balance sheet is a measure of a company's financial position at a specific point in time. b. The balance sheet's performance is broken...
-
Why do markets typically lead to an efficient outcome for buyers and sellers?
-
The order of payments for unsecured priority claims in a Chapter 7 bankruptcy case is such that a. Tax claims of governmental units are paid before claims for administrative expenses incurred by the...
-
Narco is in serious financial difficulty and is unable to meet current unsecured obligations of $30,000 to some 14 creditors who are demanding immediate payment. Narco owes Johnson $5,000, and...
-
How much would the price have to fall for consumers to be willing to buy 1 million more tons of coffee per month?
Study smarter with the SolutionInn App