Valuing Capital Investment Projects
Valuing Capital Investment Projects
Valuing Capital Investment Projects
Investment $ (10,000.00)
Revenue $ 15,000.00 $ 17,000.00
Operating Expense $ (5,833.00) $ (7,833.00)
B Depreciation $ (5,000.00) $ (5,000.00)
Pre-Tax Income $ (10,000.00) $ 4,167.00 $ 4,167.00
Net Income $ (6,000.00) $ 2,500.20 $ 2,500.20
Cash Flow $ (10,000.00) $ 7,500.20 $ 7,500.20
Investment $ (10,000.00)
Revenue $ 10,000.00 $ 11,000.00
Operating Expense $ (5,555.00) $ (4,889.00)
C Depreciation $ (3,333.33) $ (3,333.33)
Pre-Tax Income $ (10,000.00) $ 1,111.67 $ 2,777.67
Net Income $ (6,000.00) $ 667.00 $ 1,666.60
Cash Flow $ (10,000.00) $ 4,000.33 $ 4,999.93
Investment $ (10,000.00)
Revenue $ 30,000.00 $ 10,000.00
Operating Expense $ (15,555.00) $ (5,555.00)
D Depreciation $ (3,333.33) $ (3,333.33)
Pre-Tax Income $ (10,000.00) $ 11,111.67 $ 1,111.67
Net Income $ (6,000.00) $ 6,667.00 $ 667.00
Cash Flow $ (10,000.00) $ 10,000.33 $ 4,000.33
low A
3 1 Payback period A=1 year
Rank High to Low: A or D, B, C B= 2 years
C= 3 years
D= 1 year
3 A IRR = 0%
$ - B IRR = 32%
$ - C IRR = 34%
$ - D IRR = 43%
Rank High to Low: D,C,B,A
B
The rankings differ because the
methods of measuring focus on
different aspects of the project and
also make different assumptions for
measuring the value of investments.
kly the cash flows can a project can recoup the orginal investments into a project. Assumes that return
ments measures the average profit that can be expected from investments. It assumes that money is w
res the effective return rate such that NPV is zero. Assumes that money is reinvested
of benefits minus present value of costs. Assumes that money is reinvested.
because they all have positive NPV and their IRR are greater than the cost of capital
ause it has the highest IRR and NPV if discount is 35%. It also has second highest for other metrics.
. Assumes that returns from investment continues after payback period.
umes that money is worth the same at any time - thereby ignoring the time value of money
for other metrics.
ue of money
Timeline
Tax Rate 40%
Net Working Capital: 27%
A Sales
Cost of Sales
SGA Expenses
Introductory Expense
Depreciation
Income before tax
After Tax Income
Operating Cash Flow
B NPV
IRR
C Yes because the NPV is positive and the IRR is greater than the disco
Year 0 Year 1 Year 2 Year 3 Year 4
0.0000 10.0000 13.0000 13.0000 8.6667
6.0000 7.8000 7.8000 5.2000
2.3500 3.0550 3.0550 2.0367
0.2000 0.0000 0.0000 0.0000
0.1000 0.1000 0.1000 0.1000
1.3500 2.0450 2.0450 1.3300
0.8100 1.2270 1.2270 0.7980
0.0000 0.9100 1.3270 1.3270 0.8980
0.90586
29.5453%
0.0000
0.0000
-1.1700
1.6390
3
A INGRESOS COSTOS
210000 110000
Total Equity
1100000
New Price
110
New Shares
1000
Total Shares
11000
C
D
Modelo de flujo de efectivo de 210 avio
AO
t=
Flujo de efectivo en la entrega
Deposits
Total de ingresos
No, no era razonable porque el valor actual neto del programa Tri Star era
negativo. Tendran que vender 480 aviones apenas para romperse incluso.
Suponiendo que un optimista 10% crecimiento anual en viajes en avin,
Lockheed tendra que capturar el 62% del total del mercado mundial libre de
cuerpo ancho en la prxima dcada para romper incluso. Si tuviramos que
asumir una tasa de crecimiento ms razonable de 5%, el mercado mundial
total slo sera 323 aviones y Lockheed no poda vender 480 avin en un
mercado que se proyecta para tener slo 323 aviones. Yo predecira que la
adopcin del programa Tri Star tendra un impacto negativo en el valor de los
accionistas. Reducira el valor para el accionista porque este programa no
generara un ingreso neto positivo para los accionistas de la empresa.
de efectivo de 210 aviones a 14 millones costo por plano. Millones de dlares.
1967 1968 1969 1970 1971 1972 1973
0 1 2 3 4 5 6
420.00 420.00
140.00 140.00 140.00 140.00
0 0 0 140 140.00 560 560
caja con 300 aviones a un costo de 12,5 millones por avin millones de dlares
1967 1968 1969 1970 1971 1972 1973
0 1 2 3 4 5 6
600.00 600.00
200.00 200.00 200.00 200.00
0 0 0 200 200.00 800 800
70 70 -70 420.00
s
1974 1975 1976 1977
7 8 9 10
600.00 600.00 600.00 600.00
200.00 200.00
800 800 600 600.00
Supuestos
Total aviones = 300
Duracin (aos) = 6
Planes per year = 50
Cost per plane (millions) = 12.5
Annual production cost = 625
Revenue per plane (millions)= 16
Annual sales = 800
Cash flow for deposit = 200.00
Cash flow for sale year = 600.00
Years received early = 2
% deposits received= 25%
Pre-Tri Star = 9%
Discount rate = 10%
Assumptions
Total Planes = 480
Duration (years) = 6
Planes per year = 80
Cost per plane (millions) = 12.5
Annual production cost = 1000
Revenue per plane (millions)= 16
Annual sales = 1280
Cash flow for deposit = 320.00
Cash flow for sale year = 960.00
Years received early = 2
% deposits received= 25%
Pre-Tri Star = 9%
Discount rate = 10%