100 140- - DE BIA 3 - Amo - - 41 -T- 1 NOTE: Inputs necessary are in orange Light gray is output Zoom Video Communication Key inputs 200,000 20 25% 20.000 100.000 30,000 25,000 15 W 21.00 Sales Operating cost 40000 and Coat Der 200.000 50000 20,000 60,000 70,000 14700 115,300 2 240,000 60000 20.000 60,000 100.000 21000 139.000 280,000 70000 20,000 60,000 130,000 27800 162.700 . 320,000 30000 20,000 10,000 160,000 13600 186,400 360,000 10000 20,000 60,000 190,000 19909 210,100 DO 180,000 120,000 300.000 300,000 240.000 0 60,000 NCS 0 0 0 0 0 0.00 30.DON Ant Calebt NWE DING 25.000 0 70.00 25,000 0 25,000 0 25,000 0 25,000 0 35.000 7.75 315,300 CRTA depreciation 325,000 60000 139,000 162,700 186.400 235.100 111.7 1.16 OOON SON Mara so + ProForma- Det for inputs in Pro Forme Scenario Analysis MacBook Pro File Est View insert Format Data Tools Add-ons Help Last edit was made ustedex 10.27. PMshan Deng 1001 - 6000 123- Dew Art 10 NOTE: Inputs necessary are in orange Light gray is output Zoom Video Communication Key Inputs al Sales 200,000 20% Case sharing 25% 20,000 300,000 Salvage Value 30.000 Lunetmen NWA 25.000 WC of sales 15.oo 21.00% Operating cost 40000 Fans Cout Depreciation CIT 200,000 50000 20,000 60,000 70,000 14700 115,300 240,000 10000 20.000 50,000 100,000 21000 139,000 280,000 70000 20,000 60,000 130,000 27300 162,700 320.000 30000 20,000 60,000 160,000 13600 186.400 360.000 90000 20,000 60,000 190.000 39900 210,100 OG 180,000 120,000 Net Rand Assets NOS 300,000 100,000 240,000 0 60.000 0 0 0 30. OON 30.00% 70.00% 7.75% NWC DONWC 25.000 25,000 25,000 0 25,000 0 25,000 0 25,000 0 D A Eye Ana Celebt -25.000 115,300 153,000 162,700 186,400 235 100 CHIA depreciation -325,000 60000 Cart of it 111.76% 1.16 0.0 16.6 NY RS Marbet retum annual (Wack 00% Pro Forma- Details for inputs in Pro Forma- Scenario Analysis MacBook Pro Year 0 Sales Operating cost 0 Fixed Cost Depreciation EBIT 1 200,000 50000 20,000 60,000 70,000 14700 115,300 2 240,000 60000 20,000 60,000 100,000 21000 139,000 3 280,000 70000 20,000 60,000 130,000 27300 162,700 4 320,000 80000 20,000 60,000 160,000 33600 186,400 5 360,000 90000 20,000 60,000 190,000 39900 210,100 tax OCF 0 Net Fixed Assets NCS Salvage Value 300,000 300,000 240,000 0 180,000 0 120,000 0 60,000 0 0 0 NWC D(NWC) 25,000 25,000 25,000 0 25,000 25,000 0 25,000 0 0 -25,000 115,300 CFFA depreciation -325,000 60000 139,000 162,700 186,400 235, 100 NPV IRR 2 3 Sal OF 40000 Fi 5 D 6 El Zoom Video Communication Key Inputs Initial Sales Sales Growth Cost share (operating expenses) Fixed Cost Upfront Investment in NFA Salvage Value Upfront investment in NWA NWC as a % of sales Tax rate 7 200,000 20% 25% 20,000 300,000 30,000 25,000 15.00% 21.00% 9 10 11 12 13 15 Leverage ratio Debt-to-Assets Equity-to-Assets Cost of debt 30.00% 30.00% 70.00% 7.75% 16 17 18 19 20 Cost of Equity beta 3-month Bill (Risk free) Market return (annual) 111.76% 1.16 0.09% 96.36% 21 22 23 24 WACC 80% 25 100 140- - DE BIA 3 - Amo - - 41 -T- 1 NOTE: Inputs necessary are in orange Light gray is output Zoom Video Communication Key inputs 200,000 20 25% 20.000 100.000 30,000 25,000 15 W 21.00 Sales Operating cost 40000 and Coat Der 200.000 50000 20,000 60,000 70,000 14700 115,300 2 240,000 60000 20.000 60,000 100.000 21000 139.000 280,000 70000 20,000 60,000 130,000 27800 162.700 . 320,000 30000 20,000 10,000 160,000 13600 186,400 360,000 10000 20,000 60,000 190,000 19909 210,100 DO 180,000 120,000 300.000 300,000 240.000 0 60,000 NCS 0 0 0 0 0 0.00 30.DON Ant Calebt NWE DING 25.000 0 70.00 25,000 0 25,000 0 25,000 0 25,000 0 35.000 7.75 315,300 CRTA depreciation 325,000 60000 139,000 162,700 186.400 235.100 111.7 1.16 OOON SON Mara so + ProForma- Det for inputs in Pro Forme Scenario Analysis MacBook Pro File Est View insert Format Data Tools Add-ons Help Last edit was made ustedex 10.27. PMshan Deng 1001 - 6000 123- Dew Art 10 NOTE: Inputs necessary are in orange Light gray is output Zoom Video Communication Key Inputs al Sales 200,000 20% Case sharing 25% 20,000 300,000 Salvage Value 30.000 Lunetmen NWA 25.000 WC of sales 15.oo 21.00% Operating cost 40000 Fans Cout Depreciation CIT 200,000 50000 20,000 60,000 70,000 14700 115,300 240,000 10000 20.000 50,000 100,000 21000 139,000 280,000 70000 20,000 60,000 130,000 27300 162,700 320.000 30000 20,000 60,000 160,000 13600 186.400 360.000 90000 20,000 60,000 190.000 39900 210,100 OG 180,000 120,000 Net Rand Assets NOS 300,000 100,000 240,000 0 60.000 0 0 0 30. OON 30.00% 70.00% 7.75% NWC DONWC 25.000 25,000 25,000 0 25,000 0 25,000 0 25,000 0 D A Eye Ana Celebt -25.000 115,300 153,000 162,700 186,400 235 100 CHIA depreciation -325,000 60000 Cart of it 111.76% 1.16 0.0 16.6 NY RS Marbet retum annual (Wack 00% Pro Forma- Details for inputs in Pro Forma- Scenario Analysis MacBook Pro Year 0 Sales Operating cost 0 Fixed Cost Depreciation EBIT 1 200,000 50000 20,000 60,000 70,000 14700 115,300 2 240,000 60000 20,000 60,000 100,000 21000 139,000 3 280,000 70000 20,000 60,000 130,000 27300 162,700 4 320,000 80000 20,000 60,000 160,000 33600 186,400 5 360,000 90000 20,000 60,000 190,000 39900 210,100 tax OCF 0 Net Fixed Assets NCS Salvage Value 300,000 300,000 240,000 0 180,000 0 120,000 0 60,000 0 0 0 NWC D(NWC) 25,000 25,000 25,000 0 25,000 25,000 0 25,000 0 0 -25,000 115,300 CFFA depreciation -325,000 60000 139,000 162,700 186,400 235, 100 NPV IRR 2 3 Sal OF 40000 Fi 5 D 6 El Zoom Video Communication Key Inputs Initial Sales Sales Growth Cost share (operating expenses) Fixed Cost Upfront Investment in NFA Salvage Value Upfront investment in NWA NWC as a % of sales Tax rate 7 200,000 20% 25% 20,000 300,000 30,000 25,000 15.00% 21.00% 9 10 11 12 13 15 Leverage ratio Debt-to-Assets Equity-to-Assets Cost of debt 30.00% 30.00% 70.00% 7.75% 16 17 18 19 20 Cost of Equity beta 3-month Bill (Risk free) Market return (annual) 111.76% 1.16 0.09% 96.36% 21 22 23 24 WACC 80% 25
