How was this number calculated? Ty, will leave thumbs up! the number that is...

90.2K

Verified Solution

Question

Finance

How was this number calculated?

Ty, will leave thumbs up!

image

the number that is circled in blue, how was the calculated?

D E G Today 9488.80 2 Assumptions 3 Revenue growth(%) 4 COGS/Sales(%) 5 S&A/Sales(%) 5 Tax Rate(%) Current assets/ Sales(%) 3. Current liability/Sales(%) Yearly depreciation equals capes. o Cost of Capital 1 Termnial Grwoth Rate (%) FY1 7.00% 60.00% 28.00% 38.00% 38.00% 15.00% FY2 6.50% 60.00% 27.50% 38.00% 38.00% 14.00% FY3 6.50% 59.50% 27.00% 38.00% 38.00% 13.00% FY4 6.50% 59.50% 26.50% 38.00% 38.00% 12.00% FY5 6.00% 59.00% 26.00% 38.00% 38.00% 11.00% FY6 6.00% 39.00% 25.50% 38.00% 38.00% 10.00% FY7 6.00% 58.50% 25.00% 38.00% 38.00% 10.00% FY8 6.00% 58.50% 25.00% 38.00% 38.00% 10.00% FY9 6.00% 58.00% 25.00% 38.00% 38.00% 10.00% 10 FY10 6.00% 58.00% 25.00% 38.00% 38.00% 10.00% 3625.30 1786.70 12.00% 4.00% WACC MV of the Firm 10.11% 10400.25 3 Revenue 4 COS 5 S&A 6 EBIT 7 Tax 8 OCF 6091.8096 2842.84448 1218.36192 462.9775296 755.3843904 6487.777224 2973.564561 1351.620255 513.6156969 838.0045581 11515.80457 12264.33187 13000.19178 13780.20329 14607.01549 15483.43642 16412.4426 17397.18916 6851.903721 7297.2774637670.113151 8130.31994 8545.104059 9057.810303 9519.216708 10090.36971 3109.2672353250.047946 3380.0498633513.951839 3651.753872 3870.859104 4103.11065 4349.297289 1554.633617 1717,006462 1950.028767 2135.93151 2410.157555 2554.767009 2790.115242 2957.522157 590.7607746 652.4624555741.0109316 811.6539737915.859871 970.8114632 1060.243792 1123.85842 963.8728427 1064.544006 1209.017836 1324.277536 1494.297684 1583.955545 1729.87145 1833.663737 o Change Net Working Capital 496.59368 259.9172096 283.8402536 309.775143 321.325495 348.4051398 231.5074153 245.3978602 260.1217318 275.7290357 2 FCFF 3 Terminal Value 4 PV OF FCFF 5 PV OF FCFF USING WACC 6 SUM of ALL CF 7 Value Equity 258.7907104 578.0873485 680.0325892 754.7688633 887.6923407 975.8723963 1262.790269 1338.557685 1469.749718 1557.934701 26509.19466 231.0631343 460.8476949 484.0337648 479.6692576 503.7004738 494.4073263 571.2221873 540.6209987 $30.0064826 9036.864481 235,0249026 476.7864035 509.3605687 513.42235 348.3886602 547.5001283643.409719 619.3821435 617.6325462 10711.49236 Using WACC Sum of ALL CF 15422.39978 14123.79978 13332.4358 13035,8355 9 Share Price 54.33785915 63.77336245 D E G Today 9488.80 2 Assumptions 3 Revenue growth(%) 4 COGS/Sales(%) 5 S&A/Sales(%) 5 Tax Rate(%) Current assets/ Sales(%) 3. Current liability/Sales(%) Yearly depreciation equals capes. o Cost of Capital 1 Termnial Grwoth Rate (%) FY1 7.00% 60.00% 28.00% 38.00% 38.00% 15.00% FY2 6.50% 60.00% 27.50% 38.00% 38.00% 14.00% FY3 6.50% 59.50% 27.00% 38.00% 38.00% 13.00% FY4 6.50% 59.50% 26.50% 38.00% 38.00% 12.00% FY5 6.00% 59.00% 26.00% 38.00% 38.00% 11.00% FY6 6.00% 39.00% 25.50% 38.00% 38.00% 10.00% FY7 6.00% 58.50% 25.00% 38.00% 38.00% 10.00% FY8 6.00% 58.50% 25.00% 38.00% 38.00% 10.00% FY9 6.00% 58.00% 25.00% 38.00% 38.00% 10.00% 10 FY10 6.00% 58.00% 25.00% 38.00% 38.00% 10.00% 3625.30 1786.70 12.00% 4.00% WACC MV of the Firm 10.11% 10400.25 3 Revenue 4 COS 5 S&A 6 EBIT 7 Tax 8 OCF 6091.8096 2842.84448 1218.36192 462.9775296 755.3843904 6487.777224 2973.564561 1351.620255 513.6156969 838.0045581 11515.80457 12264.33187 13000.19178 13780.20329 14607.01549 15483.43642 16412.4426 17397.18916 6851.903721 7297.2774637670.113151 8130.31994 8545.104059 9057.810303 9519.216708 10090.36971 3109.2672353250.047946 3380.0498633513.951839 3651.753872 3870.859104 4103.11065 4349.297289 1554.633617 1717,006462 1950.028767 2135.93151 2410.157555 2554.767009 2790.115242 2957.522157 590.7607746 652.4624555741.0109316 811.6539737915.859871 970.8114632 1060.243792 1123.85842 963.8728427 1064.544006 1209.017836 1324.277536 1494.297684 1583.955545 1729.87145 1833.663737 o Change Net Working Capital 496.59368 259.9172096 283.8402536 309.775143 321.325495 348.4051398 231.5074153 245.3978602 260.1217318 275.7290357 2 FCFF 3 Terminal Value 4 PV OF FCFF 5 PV OF FCFF USING WACC 6 SUM of ALL CF 7 Value Equity 258.7907104 578.0873485 680.0325892 754.7688633 887.6923407 975.8723963 1262.790269 1338.557685 1469.749718 1557.934701 26509.19466 231.0631343 460.8476949 484.0337648 479.6692576 503.7004738 494.4073263 571.2221873 540.6209987 $30.0064826 9036.864481 235,0249026 476.7864035 509.3605687 513.42235 348.3886602 547.5001283643.409719 619.3821435 617.6325462 10711.49236 Using WACC Sum of ALL CF 15422.39978 14123.79978 13332.4358 13035,8355 9 Share Price 54.33785915 63.77336245

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students