Scribd
Upload
33 views14 pages

Oc&c Ot速算表 - used 0117

1. The document contains numerical data, tables, and calculations related to options and scenarios. 2. Key details include revenue, costs, growth rates, market sizes, prices, and calculations of value, benefits, and returns for options A, B, and C. 3. Financial metrics such as PE ratios, acquisition prices, market shares, and return multiples are provided for evaluating the options.

Uploaded by

Charlotte Cheung
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
33 views14 pages

Oc&c Ot速算表 - used 0117

1. The document contains numerical data, tables, and calculations related to options and scenarios. 2. Key details include revenue, costs, growth rates, market sizes, prices, and calculations of value, benefits, and returns for options A, B, and C. 3. Financial metrics such as PE ratios, acquisition prices, market shares, and return multiples are provided for evaluating the options.

Uploaded by

Charlotte Cheung
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 14

4.286% 43.

42

1.20876931
22.3766515616

-1364
1567644000
1,738,074,924
270000 275000 5000 328186.688 334264.21875
560000 700000 140000 680683.5 850854.375
50000 50000
2500 4000 1500
196500

a 36250
b 5000
c 35000 0.50310689156
13750

662450.906
1531537.88

2020 2021 1.2


1250 30 1280 1330
1530 100 1630 1691.2

0.21926747857
3021.2

0.50693031742
197.649136
Q2-4

2012 2013 2014 2015 2016 2017 Expect


A 0
B 0
Total 0 0 0 0 0 0
Exchange 0 0 0 0 0 0

Exchange rate 1.5

Growth rate A 1.02


B 1.02

Growth year A 5
B 5

79.17696
Q5

Knowning: b s
A B Total Price
Option 1 1 1 18.5
Option 2 1 -1 6.5

Then:

Price of A 12.5
Price of B 6

Then:
A B Total Price
Option 3 1 2 18.25

Discount rate 0.5 1


Q6

Days Units Results


Option 1 10 10 100

Option 2 1 50 50

Option 3 100 10 1000

Option 4 10 10 100

Speed 1
Q11-12

Estimate Actual Difference Difference %


A 756 783 27 3.57%
B 695 717 22 3.17%
C 489 529 40 8.18%
D 406 397 -9 -2.22%
E 299 312 13 4.35%
F 0 #DIV/0!
G 0 #DIV/0!
Total 2645 2738 93 3.52%

Other 456 433 -23 -5.04%

Total after other 3101 3171 70 2.26%

Current Value 2645000

Growth rate 1.07

Growth year 4

Estimated Value 3467055.446


Q13-15

Old New Option 1

Cost:

Lobor Cost 48,000 12,000 18,000.0


per hour 0.04 0.10
hours per bar 1.00 1.00
bars per year 1,200,000 120,000

Manager Cost - 28,800


salary per manager 4,800 4,800
# - 6.00 -14,400

Set up Cost - 12,000

Maintanance Cost 6,000

Other Cost - -

First Year Cost 48,000 58,800 18,000

10,800

thousand 2017 2018 2019 2020


Revenue 842 864 886 908
Real
Labor Cost 29 30 31 32

Cost % #DIV/0! #DIV/0! #DIV/0! #DIV/0!

Growth Rate 1.04


Option 2 Option 3 Option 4 Option 5

-1,200.0 3,600.0

-2,880.0

-2,400.0

1,800.0

-1,200 -600 720 -

2021
930
930.66
34

3.62%
Q16 黄色格子填基准月数

Benchmarking Value

1 2 3 4 5 6
delta

Option 1 0 0 0 0 0

Option 2 0 0 0 0 0

Option 3 0 0 0 0 0

Option 4 0 0 0 0 0

Option 5 0 0 0 0 0

Option 6 0 0 0 0 0

Benchmarking Value 10000

1 2 3 4 5 6
delta 0.93 1.2 1.34 0.79 0.77 0.85

Option 1 0 0 0 0 0

Option 2 0 0 0 0 0

Option 3 9328.358 11194 15000 11850 9124.5 7755.825

Option 4 0 0 0 0 0

Option 5 0 0 0 0 0

Option 6 0 0 0 0 0
Q17

Calculate real time


58 Real Time 5

A:

Actual 6 Slow: - Actual -10 Slow: -


WATCH 64 WATCH -5

Belief -2 Slow: + Belief -5 Slow: +


BELIEVE 62 BELIEVE -10

Real time B:

Actual -6 Slow: - Actual 0 Slow: -


WATCH -2 5

Belief 2 Slow: + Belief 3 Slow: +


BELIEVE 8
Q18
注意单位统一
return or pay-back period, benefit, loss
A B C

Latest revenue 2300 1600 800

PE 6 25 15

Acquisition Price 13800 40000 12000

Market size 40000 40000 40000

Market Share 10% 60% 30%

Average Price 1 1 1

Future Value 4000 24000 12000

Benefits -9800 -16000 0


return multiple 0.29 0.60 1.00

-171% -140% -100%


Q6

Knowing:

X Y Z
Option 1 1 1 1 39

Option 2 1 -2 10

Then：

Option 3 1 3 29

Option 4

Speed

You might also like