Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please calculate WACC and show excel formula. Thank you Apache Airlines, a privately held firm, is looking to buy additional gates at its home airport

image text in transcribed

image text in transcribed

Please calculate WACC and show excel formula. Thank you

Apache Airlines, a privately held firm, is looking to buy additional gates at its home airport for $800,000 Apache has $240,000 in the bank but that money may not be spent as it is used to pay salaries, suppliers, and equipment Apache asked its bank for a loan but the bank refused saying that Apache's interest-bearing debt to equity was too high at 3.1 The bank said that Apache needed to lower that ratio below 2.3 in order to get the loan Separately, SkyBlue Airlines has approached Apache to see if Apache will buy it. A B E 1 2 3 4 5 6 Component 1 Net Income (M$) 2 Earnings per share 3 # of shares (M) 4 Price per share 5 Market Value - Equity (M) 6 Market Value - Debt (M) 7 Market Value - Total (M) 8 - % Debt 9 -% Equity 10 Beta (levered) 11 Beta (unlevered) 12 Average Beta (unlevered) Caledonian 33.40 1.04 32.12 14.00 450 341 791 43% 57% 1.07 0.61 D Laker Source 24.10 Given 1.53 Given 15.75 Net Income / Earnings per share 12.63 Given 199 # of shares x Price per share 75 Given 274 Market Value - Debt + Equity 27% Market Value - Debt / Market Value - Total 73% 1 -% Debt 0.93 Given 0.68 Beta (levered) x % Equity 0.64 Average 7 8 9 10 11 12 13 14 15 16 17 18 19 Values for combined Apache/SkyBlue airline: % Debt 50.0% % Equity 50.0% Beta (relevered) 1.28 Risk free rate 6.0% Market risk premium 5.0% Expected equity return 12.4% Expected cost of debt 7.0% Tax rate 21.0% WACC 20 Given 1-% Debt Average Beta (unlevered) / % Equity Assumption Historical figure CAPM calculation Given Statutory rate Weighed average of costs of equity and debt 21 22 23 24 25 26

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Research Methods And Applications In Empirical Finance

Authors: Adrian R. Bell, Chris Brooks, Marcel Prokopczuk

1st Edition

1782540172, 978-1782540175

More Books

Students also viewed these Finance questions