value 7066 35084 value value value 1284 38092 value

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 14,344.0 14,548.4 3,887.0 (2,908.0) Feb-27-2013 O REP 176,552 (102,916) (56,921) (514) 8,228 (6,762) (11,652) 6,015 144,701 (79,811) (55,989) (402) 8,355 (4,629) (12,730) (505) 160,883 (93,817) (57,022) (382) 8,304 (3,805) (10,849) 3,312 205,240 (126,513) (53,689) 282 8,001 (8,671) (8,446) 16,204 188,704 (108,297) (57,001) (1,887) 7,848 (9,855) (9,989) 9,523 180,400 (107,193) (56,746) 413 8,310 (6,106) (11,437) 7,641 216,049 (127,130) (62,886) (256) 9,047 (8,149) (12,859) 13,816 265,543 (160,516) (67,601) 5,638 9,767 (13,510) (11,986) 27,335 330,375 (209,781) (69,430) 3,672 10,253 (22,535) (13,839) 28,715 338,738 (209,667) (68,480) (78) 11,416 (26,165) (15,462) 30,302 361,706 (229,113) (71,832) 859 12,250 (26,342) (15,387) 32,141 425,071 (284,724) (74,057) 1,941 12,379 (33,941) (19,318) 27,351 275,564 (183,816) (65,509) (1,291) 11,917 (15,427) (22,491) (1,053) 343,997 (231,513) (69,943) 2,932 14,760 (18,941) (26,871) 14,421 437,637 (304,035) (75,387) (1,234) 15,583 (27,254) (30,975) 14,335 428,376 (301,120) (69,713) 669 15,888 (24,349) (34,271) 15,480 PV Sum of PV Debt O/S DCF (to Equity) Shares O/S DCF per share 15,393.0 3,150.28 (514.0) (11,652.0) 6,377.3 11,751.4 2,665.24 (402.0) (12,730.0) 1,284.6 12,934.4 2,321.50 (382.0) (10,849.0) 4,024.9 19,632.4 3,246.66 282.0 (8,446.0) 14,715.0 19,833.2 2,867.80 (1,887.0) (9,989.0) 10,825.0 15,685.5 3,047.95 413.0 (11,437.0) 7,709.4 23,258.5 3,048.72 (256.0) (12,859.0) 13,192.2 29,322.0 3,698.57 5,638.0 (11,986.0) 26,672.5 37,656.2 3,966.65 3,672.0 (13,839.0) 31,455.8 42,656.4 4,653.25 (78.0) (15,462.0) 31,769.6 42,506.9 5,118.06 859.0 (15,387.0) 33,097.0 44,210.0 5,422.32 1,941.0 (19,318.0) 32,255.3 21,568.0 5,180.81 (1,291.0) (22,491.0) 2,966.8 33,972.3 6,009.18 2,932.0 (26,871.0) 16,042.4 42,517.7 6,605.07 (1,234.0) (30,975.0) 16,913.8 PV Sum of PV Debt O/S DCF (to Equity) Shares O/S DCF per share (Target Price) Indirect Method CFO CAPEX FCF (1,157.0) 8,950.0 (1,082.0) (1,873.0) 3,624.0 (42.0) 56,170.0 (26,871.0) PV Sum of PV Debt O/S DCF (to Equity) Shares O/S DCF per share (Target Price) Direct Method (2) EBITDA * (1-T) T * Depreciation Changes in NWC CAPEX FCF (13,018.0) (22,491.0) (7,185.0) (15,387.0) (488.0) (19,318.0) - - (3,757.0) (714.0) 934.0 (5,441.0) 72.0 6,228.0 280.0 52,002.0 (7,185.0) (6,896.0) (677.0) (14,763.0) (2,217.0) 30,460.0 14,760.0 14,760.0 44,474.0 6,265.31 669.0 (34,271.0) 17,137.4 PV Sum of PV Debt O/S DCF (to Equity) Shares O/S DCF per share 21,442.0 (11,652.0) 9,790.0 16,436.0 (12,730.0) 3,706.0 15,013.0 (10,849.0) 4,164.0 22,937.0 (8,446.0) 14,491.0 22,889.0 (9,989.0) 12,900.0 21,268.0 (11,437.0) 9,831.0 28,498.0 (12,859.0) 15,639.0 40,551.0 (11,986.0) 28,565.0 48,138.0 (13,839.0) 34,299.0 49,286.0 (15,462.0) 33,824.0 52,002.0 (15,387.0) 36,615.0 59,725.0 (19,318.0) 40,407.0 28,438.0 (22,491.0) 5,947.0 48,413.0 (26,871.0) 21,542.0 55,345.0 (30,975.0) 24,370.0 56,170.0 (34,271.0) 21,899.0 PV Sum of PV Debt O/S DCF (to Equity) Shares O/S DCF per share #VALUE! (79,850) #VALU...
View Full Document

Ask a homework question - tutors are online