(最新)手持业务财务数据(精品)
- 格式：xls
- 大小：520.00 KB
- 文档页数：5
LCS FINANCIAL P
3
3-2
3-2
Table 1. In US Dol
x
=
x
=
=
x
=
x
=
-
=
=
-
=
=
-
=
+
-
=
Market
Size
Facts
Target
Market
Income Statement
ROIC
Cash
Flows
InternalAcctn
g
H/C
LCS FINANCIAL P
Table 2. In RMB
x
=
x
=
=
x
=
x
=
-
=
=
-
=
=
-
=
+
-
=
Cash
Flows
ROIC
Target
Market
Income Statement
Market
Size
Facts
H/C
InternalAcctn
g
LCS FINANCIAL PLANNING MODEL
Category:HandheldInput
Industry:PDACaculated
Target Industry Segment:PDA
Target Geography:China
Source: LCS, Annual Reports, McKinsey Analysis
特注：销售收入为不含税收入，其他数据也应调整。
S Dollars
HistoricalYearUnits19992000200120022003CAGRAverageYahoo!Global Market SizeUS$ Millions#DIV/0!China Share of World MktPercent#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!China Market SizeUS$ Millions#DIV/0!Target Geography Mkt SizeUS$ Millions231.41330.13470.51569.87#DIV/0!Tgt Sgmt as % of Tgt GeogrphyPercent100%100%100%100%Target Market SizeUS$ Millions231.41330.13470.51569.87#DIV/0!Target Market SizeUS$ Millions231.41330.13470.51569.87#DIV/0!Target Market SizeSharePercent9.50%11.30%15.50%20.00%ShareRevenueUS$ Millions21.9837.3072.93113.97#DIV/0!RevenueGross Margin (% of revenue)Percent9.8%10.0%13.5%17.5%Gross MarginGross ProfitUS$ Millions2.153.739.8519.95#DIV/0!SG&A ExpensesUS$ Millions8.517.467.6610.83EBITDA (% of revenue)Percent-28.89%-10.00%3.00%8.00%EBITDA (% of Revenue)EBITDAUS$ Millions-6.35-3.732.199.12#DIV/0!Depreciation & AmortizationUS$ Millions0.090.751.462.28Operating Margin as % of RevenuePercent-29.30%-12.00%1.00%6.00%Operating MarginNet Operating Profit (EBIT)US$ Millions-6.44-4.480.736.84#DIV/0!Tax Rate Adjustment (as %)Percent7.50%7.50%NOPLATUS$ Millions-6.4-4.50.76.3#DIV/0!Capital TurnoverRatio5.005.004.504.00Capital TurnoverInvested CapitalUS$ Millions471628#DIV/0!ROICPercent-147%-60%4%22%ROICNOPLATUS$ Millions-6.4-4.50.76.3Depreciation & AmortizationUS$ Millions0.10.71.52.3New Capital InvestmentUS$ Millions4391240.9%Cash FlowUS$ Millions-11-7-7-4-30.0%Share of Revenue InternalPercent52.00%Internal RevenueUS$Millions11Revenue per headUS$ Millions0.300.140.260.40.52H/C# of employees153143182219US Benchmarks - 1999Aspiration
LCS FINANCIAL PLANNING MODEL
Category:Handheld
Industry:PDA
Target Industry Segment:PDA
Target Geography:China
Source: LCS, Annual Reports, McKinsey Analysis
MB
HistoricalYearUnits19992000200120022003CAGRGlobal Market Size亿人民币#DIV/0!China Share of World MktPercent#DIV/0!#DIV/0!#DIV/0!#DIV/0!#DIV/0!China Market Size亿人民币#DIV/0!Target Geography Mkt Size亿人民币19273947#DIV/0!Tgt Sgmt as % of Tgt GeogrphyPercent100.00%100.00%100.00%100.00%Target Market Size亿人民币19.2127.4039.0547.30#DIV/0!Target Market Size亿人民币19.2127.4039.0547.30#DIV/0!SharePercent0.100.110.160.20Revenue亿人民币1.823.106.059.46#DIV/0!Gross Margin (% of revenue)Percent9.8%10.0%13.5%17.5%Gross Profit亿人民币0.180.310.821.66#DIV/0!SG&A Expenses亿人民币0.710.620.640.90EBITDA (% of revenue)Percent-28.89%-10.00%3.00%8.00%EBITDA亿人民币-0.53-0.310.180.76#DIV/0!Depreciation & Amortization亿人民币0.010.060.120.19Operating Margin as % of RevenuePercent-29.30%-12.00%1.00%6.00%Net Operating Profit (EBIT)亿人民币-0.53-0.370.060.57#DIV/0!Tax Rate Adjustment (as %)Percent7.50%7.50%NOPLAT亿人民币-0.5346-0.370.060.53#DIV/0!Capital TurnoverRatio554.54Invested Capital亿人民币0.360.621.352.36#DIV/0!ROICPercent-146.5%-60.0%4.2%22.2%NOPLAT亿人民币-0.53-0.370.060.53Depreciation & Amortization亿人民币0.010.060.120.19New Capital Investment亿人民币xx0.360.250.731.0240.9%Cash Flow亿人民币xx-0.89-0.56-0.55-0.31-30.0%Share of Revenue InternalPercent52%Internal Revenue亿人民币1#DIV/0!Revenue per head亿人民币0.02490.0119260.021580.03320.04316H/C人153143182219Aspiration
999
