MBA 580 Sales Forecast

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

580

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

12

Uploaded by DeaconRose12996

Report
Year 0 1 2 3 4 5 6 7 8 9 Your Company $187.10 $192.90 $198.88 $205.05 $211.40 $217.96 $224.71 $231.68 $238.86 $246.26 BMW $126.10 $130.77 $135.60 $140.62 $145.82 $151.22 $156.82 $162.62 $168.63 $174.87 Toyota $275.40 $286.14 $297.30 $308.89 $320.94 $333.46 $346.46 $359.98 $374.01 $388.60 VW $282.90 $295.06 $307.75 $320.99 $334.79 $349.18 $364.20 $379.86 $396.19 $413.23 0 1 2 3 4 5 6 7 8 9 10 $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00 $450.00 $500.00 Sales Growth of the Whole Market Years Whole Market Sales Growth in Billions
10 $253.90 $181.34 $403.76 $431.00
Year 0 1 2 3 4 5 6 7 8 9 Ohio Motor Works (OMW) $ 3.80 $ 4.19 $ 4.61 $ 5.09 $ 5.60 $ 6.18 $ 6.81 $ 7.50 $ 8.26 $ 9.11 BMW $ 1.60 $ 2.01 $ 2.52 $ 3.16 $ 3.97 $ 4.98 $ 6.25 $ 7.85 $ 9.85 $ 12.36 Toyota $ 4.80 $ 5.99 $ 7.48 $ 9.33 $ 11.64 $ 14.53 $ 18.14 $ 22.63 $ 28.25 $ 35.25 VW $ 8.40 $ 10.35 $ 12.75 $ 15.71 $ 19.35 $ 23.84 $ 29.37 $ 36.19 $ 44.58 $ 54.93 0 1 2 3 4 5 6 7 8 9 10 $- $10.00 $20.00 $30.00 $40.00 $50.00 $60.00 $70.00 $80.00 Sales Growth Connected Vehicle Market Years Connective Vehicle Sales In Billions
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10 $ 10.04 $ 15.51 $ 43.99 $ 67.67 137.21 0 1 2 3 4 5 6 7 8 9 10 $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 $350.00 $400.00 $450.00 $500.00 Sales Growth of the Whole Market Years Whole Market Sales Growth in Billions
Year 0 1 2 3 4 5 6 7 8 9 Sales Traditional 183.3 190.8153 198.63873 206.78292 215.26101 224.08672 233.27427 242.83852 252.7949 263.15949 Sales Connected 3.8 4.1876 4.6147352 5.768419 7.2105238 9.0131547 11.266443 14.083054 17.603818 22.004772 Total Sales 187.1 195.0029 203.25346 212.55133 222.47154 233.09987 244.54071 256.92157 270.39871 285.16426 Gross Margin Traditional 27.495 28.622295 29.795809 31.017437 32.289152 33.613007 34.991141 36.425778 37.919234 39.473923 Gross Margin Connected 0.798 0.879396 0.9690944 1.211368 1.51421 1.8927625 2.3659531 2.9574414 3.6968017 4.6210022 Total Gross Margin 28.293 29.501691 30.764903 32.228805 33.803362 35.50577 37.357094 39.383219 41.616036 44.094925 R&D and Capital Costs 4.1 4.133 1.16699 1.2019997 1.2380597 1.2752015 1.3134575 1.3528613 1.3934471 1.4352505 Notes: Your company grows connected cars at 10.2%/year for 2 years, then grows connected cars at 25%/year. Your company grows traditional cars at industry growth rate of 4.1 %/year. Margin for connected cars: 21%. Margin for traditional cars: 15%. Numbers shown in billions. There are two additional R&D costs for this option in year 0 and year 1.
10 273.94903 27.505965 301.45499 41.092354 5.7762527 46.868607 1.478308 0 1 2 3 4 5 6 7 8 9 10 0 50 100 150 200 250 300 350 Sales Forecast Data Option A Sales Traditional Sales Connected Years Sales Forcast in Billions 10 15 20 25 30 35 40 45 50 Gross Margin Forcast Sales Option A Gross Margin in Billions
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0 1 2 3 4 5 6 7 8 9 10 0 5 10 Gross Margin Traditional Gross Margin Connected Years G
Year 0 1 2 3 4 5 6 Sales Traditional $183.30 $190.82 $198.64 $206.78 $215.26 $224.09 $233.27 Sales Connected $3.80 $4.19 $4.61 $5.09 $5.60 $6.18 $6.81 Total Sales $187.10 $195.00 $203.25 $211.87 $220.87 $230.26 $240.08 Gross Margin Traditional $27.50 $28.62 $29.80 $31.02 $32.29 $33.61 $34.99 Gross Margin Connected $0.80 $0.88 $0.97 $1.07 $1.18 $1.30 $1.43 Total Gross Margin $28.29 $29.50 $30.76 $32.09 $33.47 $34.91 $36.42 R&D and Capital Costs $1.10 $1.13 $1.17 $1.20 $1.24 $1.28 $1.31 Notes: Your company grows connected cars at 10.2%/year. Your company grows traditional cars at industry growth rate of 4.1 %/year. Margin for connected cars: 21%. Margin for traditional cars: 15%. R&D and Capital Costs grow at a rate of 3%. 0 1 2 3 4 5 6 Your Company $ 3.80 $ 4.19 $ 4.61 $ 5.09 $ 5.60 $ 6.18 $ 6.81 BMW $ 1.60 $ 2.01 $ 2.52 $ 3.16 $ 3.97 $ 4.98 $ 6.25 Toyota $ 4.80 $ 5.99 $ 7.48 $ 9.33 $ 11.64 $ 14.53 $ 18.14 VW $ 8.40 $ 10.35 $ 12.75 $ 15.71 $ 19.35 $ 23.84 $ 29.37 Connected Sales Growth by Year
0 1 2 3 4 5 6 Your Company $187.10 $192.90 $198.88 $205.05 $211.40 $217.96 $224.71 BMW $126.10 $130.77 $135.60 $140.62 $145.82 $151.22 $156.82 Toyota $275.40 $286.14 $297.30 $308.89 $320.94 $333.46 $346.46 VW $282.90 $295.06 $307.75 $320.99 $334.79 $349.18 $364.20 Whole Market Growth by Year
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7 8 9 10 $242.84 $252.79 $263.16 $273.95 $7.50 $8.26 $9.11 $10.04 $250.34 $261.06 $272.27 $283.99 $36.43 $37.92 $39.47 $41.09 $1.57 $1.74 $1.91 $2.11 $38.00 $39.65 $41.39 $43.20 $1.35 $1.39 $1.44 $1.48 7 8 9 10 $ 7.50 $ 8.26 $ 9.11 $ 10.04 $ 7.85 $ 9.85 $ 12.36 $ 15.51 $ 22.63 $ 28.25 $ 35.25 $ 43.99 $ 36.19 $ 44.58 $ 54.93 $ 67.67 0 1 2 3 4 $0.00 $50.00 $100.00 $150.00 $200.00 $250.00 $300.00 Sales Forcast O Sales Traditional Sa Yea Sales forcast in Billions 0 1 2 3 4 $0.00 $5.00 $10.00 $15.00 $20.00 $25.00 $30.00 $35.00 $40.00 $45.00 Gross Margins Forcast Gross Margin Traditional G Yea Gross Margins in Billions
7 8 9 10 $231.68 $238.86 $246.26 $253.90 $162.62 $168.63 $174.87 $181.34 $359.98 $374.01 $388.60 $403.76 $379.86 $396.19 $413.23 $431.00
5 6 7 8 9 10 Option B ales Connected ars 5 6 7 8 9 10 t Sales Option B Gross Margin Connected ars
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help