MGMT332 Financee

profileS.p
MGMT332_Excel_Template_3.xls

Prob. 1

JRA Inc.
Yrs. 1-6 7 +
Sales growth 2.8% 2.5% Cash Flows
Costs (% of sales): 1 2 3 4 5 6
Cost of Goods Sold 52% Sales 66.0
Advert., Prom., & Selling 23% Cost of Goods Sold
General & Administrative 5% Advert., Prom., & Selling
Rates: General & Administrative
Tax rate 21% Net Income before Tax
Discount rate 6.6% Taxes
Results Net Income after Tax
PV of NCF (incl. TV) Cash flow adjustments:
+ Cash 3.3 Working Capital 1.4 1.3 1.2 1.1 1.0 0.9
- Debt 3.5 Capital Expenditures 2.0 1.9 1.8 1.7 1.6 1.5 TV
Total Equity (M$) Net Cash Flows
- # of shares outstanding (M) 14.0
- Price/share ($)
alfonso canella: The perpetuity formula is the present value of all cash flows from years 7 and on. It is a significant portion of the firm's value and the assumed growth rate should be carefully considered.
alfonso canella: This calculation is the value of the firm. To get the value of the equity, add cash and subtract interest bearing debt. The equity value is then divided by the number of shares outstanding to get the price per share. Note that many firms buy back their shares to boost their stock price!
alfonso canella: This is the long term or steady state growth rate for the firm. It is crucial for the firm' stock price. The higher it is, the more valuable the firm is.
alfonso canella: The discount rate is the firm's weighed average cost of capital - that is, the weighed cost of debt and equity. To invest, the firm should get a return higher than the discount rate. This number can go up or down depending on the perceived risk of each investment - up for higher risk and and down for lower risk.

Prob. 2

JTM Airlines
Rates:
Discount rate
Risk-free rate
Scenario: No Real Options
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Cash from Operations 5.0 5.6 6.2 6.8 7.4 8.0 8.6 9.2 9.8 10.4 11.0 11.6 12.2 12.8 13.4
minus: Capital Expenditures 8.0 9.0 2.0 2.3 2.6 2.9 3.2 3.5 3.8 4.1 4.4 4.7 5.0 5.3 5.6
= Net Cash Flow
Terminal Value 55.0
PV of NCF
Scenario: Real Options Option Pricing:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 PV of Cap. Ex. (Yrs. 1-2)
Cash from Operations 5.0 5.6 6.2 6.8 7.4 8.0 8.6 9.2 9.8 10.4 11.0 11.6 12.2 12.8 13.4 Maturity 5.0
minus: Capital Expenditures 2.0 2.3 2.6 2.9 3.2 3.5 3.8 4.1 4.4 4.7 5.0 5.3 5.6 PV of NCF
= Net Cash Flow Risk free rate
Terminal Value 55.0 Volatility 55%
PV of NCF BS calculations:
PV of Cap. Ex. (Yrs. 1-2) d1 - 0
N(d1) - 0
d2 - 0
N(d2) - 0
Price of call - 0
Difference:
- Value of Option over PV
- % of PV
Text answer here.
alfonso canella: The NPV function of Excel makes quick work of the yearly cash flows by present valuing them according to when they happen. The terminal value must also be included. It can be put in as a year 16 and included in the NPV function or as a year 15 cash flow, as done here.
alfonso canella: The largest cash outflows in the project are considered to be the cost of doing the project. The smaller cash outflows are seen to be operating costs. So, the two large Cap Ex are discounted using the risk free rate as these investments will be made no matter what. Because they will be made no matter what, they are not risky, so the risk free rate is used.
alfonso canella: This is the option pricing formula. It is called the Black-Scholes formula as it was devised by Fisher Black and Myron Scholes. It has five inputs: time to maturity (in years), risk free rate (the alternative investment), the volatility of prices for the specific project (so if this were an oil industry project, the volatility would be the price volatility of crude oil), the strike price (that is, the PV of the Cap Ex necessary to do the project), and the present value of the cash flows that accrue from doing the project.
alfonso canella: The NPV function of Excel makes quick work of the yearly cash flows by present valuing them according to when they happen. The terminal value must also be included. It can be put in as a year 16 and included in the NPV function or as a year 15 cash flow, as done here.

Prob. 3

JTM Airlines
Airport Expansion
Start Phase I Phase II Phase III PV of Revenues Costs Net Probability Expected Value
Success 300
55% 25
East Coast
20% 34
Failure - 0
45% 20
Success 180
55% 29
West Coast
33% 40
Failure - 0
45% 22
Success
66% 30 Success 410
70% 23
Caribbean
25% 43
Start Failure - 0
32 30% 7
Failure - 0
22% 33
Failure - 0
34% 40

v. MAR 2021

No content - Intentionally left blank