AFM 472 Class 13 Excel

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: 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 (13,018.0) (19,318.0) - (15,387.0) 30,460.0 14,760.0 14,760.0 12 months Dec-31-2011 USD (7,185.0) (6,896.0) - (2,217.0) 12 months Dec-31-2010 USD 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 4,502.0 Assets 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 52,684 #VALUE! (79,850) #VALUE! #VALUE! #VALUE! 118,848 1.53% 7.57% 1,967,241 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051 2052 2053 2054 2055 2056 2057 2058 2059 2060 2061 2062 2063 2064 2065 2066 2067 2068 2069 2070 2071 2072 2073 2074 2075 2076 2077 2078 2079 2080 2081 2082 2083 2084 2085 2086 2087 2088 2089 2090 2091 2092 2093 2094 2095 2096 2097 2098 2099 2100 2101 2102 2103 2104 2105 2106 2107 2108 2109 2110 2111 2112 2113 2114 2115 2116 2117 2118 2119 2120 118,848 110,483 120,666 104,279 122,511 98,422 124,385 92,895 126,288 87,677 128,219 82,753 130,180 78,106 132,172 73,719 134,193 69,579 136,246 65,671 138,330 61,983 140,445 58,502 142,593 55,216 144,774 52,115 146,989 49,189 149,237 46,426 151,520 43,819...
View Full Document

This document was uploaded on 02/05/2014.

Ask a homework question - tutors are online