Cabana Cruise Line offers cruise ship service to various tropical locations throughout the globe. The company is considering the addition of a new cruise ship to its fleet in order to expand service to new destinations by serving additional patrons. The project involves commissioning a new ship, developing destination ports to accommodate the ship, and promotion of the new destinations. The company uses its WACC as the hurdle rate to be met for new projects. However, since a new project has not been considered in some time, the WACC for the company needs to first be recalculated. Cabana Cruise Line uses a combination of debt and equity to fund operations, and they have a bond rating of A. Market capitalization consists of 12 million shares outstanding and currently trades at a value of $51 per share. Cabana Cruise Line has outstanding debt of $150 million, a default rate of 0.10%, and has a 40% tax rate. Additional information is provided in the tables below. Cost of Equity Cost of Debt Risk Free Return Rate 4% Market Return 8% Probability of Default Debt yield to maturity 2% 5% Company Return 10% Loss Rate 40% Beta 1.05 Beta 0.95 Using the data provided,
Cabana Cruise Line offers cruise ship service to various tropical locations throughout the globe. The company is considering the addition of a new cruise ship to its fleet in order to expand service to new destinations by serving additional patrons. The project involves commissioning a new ship, developing destination ports to accommodate the ship, and promotion of the new destinations. The company uses its WACC as the hurdle rate to be met for new projects. However, since a new project has not been considered in some time, the WACC for the company needs to first be recalculated. Cabana Cruise Line uses a combination of debt and equity to fund operations, and they have a bond rating of A. Market capitalization consists of 12 million shares outstanding and currently trades at a value of $51 per share. Cabana Cruise Line has outstanding debt of $150 million, a default rate of 0.10%, and has a 40% tax rate. Additional information is provided in the tables below. Cost of Equity Cost of Debt Risk Free Return Rate 4% Market Return 8% Probability of Default Debt yield to maturity 2% 5% Company Return 10% Loss Rate 40% Beta 1.05 Beta 0.95 Using the data provided,
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Only solve using excel with reference. proper steps and explanation. All parts or skip.
![Cost of Equity
Cost of Debt
Risk Free Return Rate
4%
Probability of Default
2%
Market Return
8%
Debt yield to maturity
5%
Company Return
10%
Loss Rate
40%
Beta
1.05
Beta
0.95
Using the data provided,
1. Apply CAPM to determine the cost of equity and the cost of debt for Cabana Cruise Line.
2. Apply WACC to determine the hurdle rate that should be used by Cabana Cruise Line.
Cost of Equity
Required return of security i = risk free rate + Beta x (value of equity [return of market] - risk free rate)
T₁ =rf+ B₁x (E [Rmkt] -rf
Cost of Equity =
Cost of Debt
ra = yield to maturity - probability of default x expected loss rate
Cost of Debt =
WACC
=
Rate WACC [Equity / (Equity + Debt)]x rate of equity + [Debt/ (Equity + Debt]] x Rate of debt x (1 - tax rate)
RWACC [E/ (E+D)] x RE+[D/ (E+D)] x Rpx (1-RTax)
WACC =](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7f1b339e-b033-4972-a196-94d0ccb085b9%2F189e0908-6066-4eda-b722-a0709b797a68%2Fkm7pwd_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Cost of Equity
Cost of Debt
Risk Free Return Rate
4%
Probability of Default
2%
Market Return
8%
Debt yield to maturity
5%
Company Return
10%
Loss Rate
40%
Beta
1.05
Beta
0.95
Using the data provided,
1. Apply CAPM to determine the cost of equity and the cost of debt for Cabana Cruise Line.
2. Apply WACC to determine the hurdle rate that should be used by Cabana Cruise Line.
Cost of Equity
Required return of security i = risk free rate + Beta x (value of equity [return of market] - risk free rate)
T₁ =rf+ B₁x (E [Rmkt] -rf
Cost of Equity =
Cost of Debt
ra = yield to maturity - probability of default x expected loss rate
Cost of Debt =
WACC
=
Rate WACC [Equity / (Equity + Debt)]x rate of equity + [Debt/ (Equity + Debt]] x Rate of debt x (1 - tax rate)
RWACC [E/ (E+D)] x RE+[D/ (E+D)] x Rpx (1-RTax)
WACC =
![Cabana Cruise Line offers cruise ship service to various tropical locations throughout the globe. The company is considering the addition of a new
cruise ship to its fleet in order to expand service to new destinations by serving additional patrons. The project involves commissioning a new ship,
developing destination ports to accommodate the ship, and promotion of the new destinations. The company uses its WACC as the hurdle rate to be
met for new projects. However, since a new project has not been considered in some time, the WACC for the company needs to first be recalculated.
Cabana Cruise Line uses a combination of debt and equity to fund operations, and they have a bond rating of A. Market capitalization consists of 12
million shares outstanding and currently trades at a value of $51 per share. Cabana Cruise Line has outstanding debt of $150 million, a default rate of
0.10%, and has a 40% tax rate. Additional information is provided in the tables below.
Cost of Equity
Cost of Debt
Risk Free Return Rate
4%
Probability of Default
2%
Market Return
8%
Debt yield to maturity
5%
Company Return
10%
Loss Rate
40%
Beta
1.05
Betal
0.95
Using the data provided,
1. Apply CAPM to determine the cost of equity and the cost of debt for Cabana Cruise Line.
2. Apply WACC to determine the hurdle rate that should be used by Cabana Cruise Line.
Cost of Equity
Required return of security i-risk free rate + Beta x (value of equity [return of market] - risk free rate)
nry+ B₁x (E [Rakt]-ry
Cost of Equity=
Cost of Debt
ra = yield to maturity-probability of default x expected loss rate
Cost of Debt =](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7f1b339e-b033-4972-a196-94d0ccb085b9%2F189e0908-6066-4eda-b722-a0709b797a68%2Fkxyrf0f_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Cabana Cruise Line offers cruise ship service to various tropical locations throughout the globe. The company is considering the addition of a new
cruise ship to its fleet in order to expand service to new destinations by serving additional patrons. The project involves commissioning a new ship,
developing destination ports to accommodate the ship, and promotion of the new destinations. The company uses its WACC as the hurdle rate to be
met for new projects. However, since a new project has not been considered in some time, the WACC for the company needs to first be recalculated.
Cabana Cruise Line uses a combination of debt and equity to fund operations, and they have a bond rating of A. Market capitalization consists of 12
million shares outstanding and currently trades at a value of $51 per share. Cabana Cruise Line has outstanding debt of $150 million, a default rate of
0.10%, and has a 40% tax rate. Additional information is provided in the tables below.
Cost of Equity
Cost of Debt
Risk Free Return Rate
4%
Probability of Default
2%
Market Return
8%
Debt yield to maturity
5%
Company Return
10%
Loss Rate
40%
Beta
1.05
Betal
0.95
Using the data provided,
1. Apply CAPM to determine the cost of equity and the cost of debt for Cabana Cruise Line.
2. Apply WACC to determine the hurdle rate that should be used by Cabana Cruise Line.
Cost of Equity
Required return of security i-risk free rate + Beta x (value of equity [return of market] - risk free rate)
nry+ B₁x (E [Rakt]-ry
Cost of Equity=
Cost of Debt
ra = yield to maturity-probability of default x expected loss rate
Cost of Debt =
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education