Planning DB For Smart Zena

Phase 1

			10/7/14 12:13
Capital Expenditure Planning & Budgeting for Universal Parts Company
Universal Parts Company - Estimated Cash Flows (CF) for Projects A & B (in thousands of dollars):
	Year	CFA	CFB
	0	($1,000)	($1,000)
	1	$100	$700
	2	$600	$500
	3	$800	$200
Assumme that tax effects, depreciation, salvage values, and all operating costs have been included in the cash flows
Net Present Value (NPV)
(1) Determine each project’s NPV.
WACC =	10.00%
NPVA =	$187.83		Activity: Choose both projects if two projects are independent, and their NPVs are positive
NPVB =	$199.85		Activity: Choose the project with the higher positive NPV if the two projects are mutually exclusive
Internal Rate of Return (IRR)
(1) Determine each project’s IRR.
The internal rate of return (IRR) is that discount rate which forces the NPV of a project to equal zero.
					Activity: Double-click on the equation to find out how you can insert an equation.
The solution to this equation can be found using Excel's IRR function.
IRRA =	18.1%		Activity: Choose both projects if two projects are independent, and their IRRs are higher than the WACC
IRRB=	23.6%		Activity: Choose the project with the higher IRR in excess of WACC if the projects are mutually exclusive
Crossover Rate
(1) Draw NPV profiles for Projects A and B. At what discount rate do the profiles cross?
	Project	Project
WACC	A	B
	$187.83	$199.85
0%	500.00	400.00
5%	330.53	292.95
10%	187.83	199.85
15%	66.66	118.27
20%	-37.04	46.30
25%	-126.40	-17.60
Year	CFDifference
0	$0
1	($600)
2	$100
3	$600
IRR = crossover rate =		8.68%
Modified Internal Rate of Return (MIRR)
(1) Find the MIRRs for Projects A and B.
Activity: MIRR is the internal rate of return for a series of a project’s cash flows, taking into account the cost of investment and interest on reinvestment of cash.
			Activity: Projects A and B's modified IRRs can be solved for by using Excel's MIRR function, entering their cash flows and using the WACC as both the discount rate and the reinvestment rate.
MIRRA =	16.5%
MIRRB =	16.9%
By the MIRR criteria, Project B is preferred to Project A, which is consistent with the NPV decision.
Payback Period
(1) Find the paybacks for Projects A and B.
Payback Calculations
Project A		Years	0	1	2	3
			|	|	|	|
		Cash Flow	-1,000	100	600	800
		Cumulative Cash Flow	-1,000	-900	-300	500
Payback A = 2 + 300/800 =			2.4
Project B		Years	0	1	2	3
			|	|	|	|
		Cash Flow	-1,000	700	500	200
		Cumulative Cash Flow	-1,000	-300	200	400
Payback B = 1 + 300/500 =			1.6

NPV Profiles

$187.83 0 0.05 0.1 0.15000000000000002 0.2 0.25 500 330.52586113810594 187.82870022539419 66.655708062792883 -37.037037037036953 -126.39999999999998 $199.85 0 0.05 0.1 0.15000000000000002 0.2 0.25 400 292.94892560198673 199.8497370398195 118.27073230870405 46.296296296296532 -17.600000000000023

WACC

NPV ($)

Sheet2

Sheet3