Only solve using excel with reference. proper steps and explanation. All parts or skip. Cost of EquityCost of DebtRisk Free Return Rate4%Probability of Default2%Market Return8%Debt yield to maturity5%Company Return10%Loss Rate40%Beta1.05Beta0.95Using 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 EquityRequired return of security i = risk free rate + Beta x (value of equity [return of market] - risk free rate)T₁ =rf+ B₁x (E [Rmkt] -rfCost of Equity =Cost of Debtra = yield to maturity - probability of default x expected loss rateCost 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 newcruise 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 bemet 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 12million shares outstanding and currently trades at a value of $51 per share. Cabana Cruise Line has outstanding debt of $150 million, a default rate of0.10%, and has a 40% tax rate. Additional information is provided in the tables below.Cost of EquityCost of DebtRisk Free Return Rate4%Probability of Default2%Market Return8%Debt yield to maturity5%Company Return10%Loss Rate40%Beta1.05Betal0.95Using 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 EquityRequired return of security i-risk free rate + Beta x (value of equity [return of market] - risk free rate)nry+ B₁x (E [Rakt]-ryCost of Equity=Cost of Debtra = yield to maturity-probability of default x expected loss rateCost of Debt =

Cost of capital:The concept of "cost of capital" encapsulates the expense a company incurs to…

Answered: Cabana Cruise Line offers cruise ship…

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

See similar textbooks

Similar questions

Adidas is evaluating a proposal for a new product. If they launch the product, they will use an existing facility in the production process, which they previously acquired for $4 million. They currently lease it to a third party, and they expect to continue to do so if they don't use it for the new product. They rent it out for $102,000 and they expect that to remain flat for the foreseeable future. The project requires immediate investment in CAPX of $1.3 million, which will be depreciated on a straight-line basis over the next 10 years for tax purposes. The project will end after eight years, at which time they expect to salvage some of the initital CAPX and sell it for $469,000. The project requires immediate working capital investments equal to 10% of predicted first-year sales. After that, working capital will remain at 10% of the following year's expected sales. They expect sales to be $4.6 million in the first year and to stay constant for eight years. Total…
New York City is evaluating the construction of a new train station to serve a new high-speed rail system. The Capital Projects Team is responsible for evaluating whether the project is economically acceptable. The Capital Projects Team estimates that the new train station will generate $1B in annual revenue, and provide $1B a year in cost savings. The new train line will cannibalize some of the existing revenues the City receives from its current train system. The value of this cannibalization is estimated at $500 MM a year. The new station's costs of Maintenance and Operation are anticipated to amount to be $250 MM per year. The initial investment required to design and build the train station is expected to be $15 B. New York City is considered to be a high credit and can borrow long-term in the capital markets at a rate of 6%. The Capital Projects Team evaluates these types of projects over a study period of 25 years. What is the Modified B/C Ratio? .94 1.00 1.07 1.10
Consider the following information. In order to satisfy a sharp increase in demand due to the end of the pandemic, LLC is evaluating investing in one of two major projects; these projects will be called Project A and Project B. In order to mitigate risk, LLC has asked Rachel Consulting Limited to conduct some market research. Rachel Consulting is being paid $2.5m a fixed fee for her expert consulting services. Project A has an initial outlay of $45 million and Project B has an initial outlay of $60 million. Project A will generate additional revenues of $25 million starting at the end of year 1 until the end of year 10. It will also incur additional working capital expenses of $75 million immediately, this working capital will be recovered at the end of the project. Project B will generate additional revenues of $35 million starting at the end of year 1 until the end of year 10. It will also incur additional working capital expenses of $90 million immediately, this working capital will…
Mad Scientist, Inc. is considering investing into the nanotechnology business. After conducting a detailed due diligence process, the company's board decided that the current cost of entry into the nanotechnology business is too high. The board also thinks that the commercialization of technological advancements will eventually drive costs down and the company should get into the nanotech business one or two years from now, when they can realize a higher NPV on their investment. Given the above, the board has chosen the option to: Expand Abandon Delay
Coronado Skateboards is considering building a new plant. David Al-Saigh, the company's marketing manager, is an enthusiastic supporter of the new plant. Jennifer Miller, the company's chief financial officer, is not so sure that the plant is a good idea. Currently, the company purchases its skateboards from foreign manufacturers. The following figures were estimated for the construction of a new plant: Cost of plant Annual cash inflows Annual cash outflows Estimated useful life Salvage value Discount rate $6,360,000 $6,360,000 $5,883,000 15 years $1,060,000 David believes that these figures understate the true potential value of the plant. He suggests that by manufacturing its own skateboards the company will benefit from a "buy Canadian" patriotism. He also notes that the firm has had numerous quality problems with the skateboards manufactured by its suppliers. He suggests that the inconsistent quality has resulted in lost sales, increased warranty claims, and some costly lawsuits.…
Suppose you are a panelist, and you must evaluate if the design is feasible or not. You look at the breakdown of expenses, possible revenues, etc. Here are some important chapters and discussions taken from a certain plant design. Chapter 3: Market Study This plant design, entitled “IIVSDROP: The First Ear Dropper Solution Manufacturing Plant in the Philippines” considers a 30-year period of study, starting 2021, after finishing its construction by 2020. All projections, and interest rates set by the company shall be evaluated within this 30-year period. The inflation rate shall not be included in the computation and a minimum attractive rate of return is set at 20%. Chapter 4: Products Our company produces ear dropper solution which can be sold for PHP. 125.00 per bottle. Annually, the company can produce 1000 pallets of the product. Each pallet is stacked with 14 layers and each layer consists of 8 boxes. A box contains 12 bottles of ear dropper for wholesale…
You are considering producing a new golf ball for sale in China to meet agr~wing demand in the country. This golf ball is less expensive to manufacture compared with a better-known brand, but it meets all requirements set by the United States Golf Association (USGA) for play at any competitive event. Production will require an initial outlay for the purchase of equipment worth $1,500,000. The equipment has a six-year life with an expected salvage value of $100,000. You already own the land on which the project will be located. The land has a current market value of $100,000, and its price is expected to grow by 5% per year. If you decide not to produce the golf balls, you will sell the land. You have also gathered the following information: You expect revenue of $500,000 per year for each year of operation. Your direct cost of producing the golf ball is expected to be 30% of the revenue. The operating cost, including marketing, is another 15% of the revenue. You will need to pay a…
Without prejudice to your answers to previous questions, and assume that Davao plans to market its product in a new territory. Davao estimates that an advertising and promotion program costing P61,500 annually would need to be undertaken for the next two or three years. In addition, a P25 per ton sales commission over and above the current commission to the sales force in the new territory would be required. How many tons would have to be sold in the new territory to maintain Davao’s current after-tax income of P94,500?
music promoter has had an offer to bring a famous musical group from England to Australia, as part of its world tour to promote its new album. The music promoter has done smaller tours previously, but nothing on the scale proposed by the manager of this famous group, the tour will cost several million dollars, but is likely to have revenue which will result in substantial profits for those involved.The promoter has some contacts at a national radio station which can promote the tour, and there is at least one financier who is interested in financing the tour in return of course for a share of the revenue from the tour.The promoter is calling for a meeting of the different interested parties, he is not sure what business organisation would be best to manage and conduct the proposed tour, particularly as it is going to involve various diverse entities, each with their own separate business interests.Explain:• The options open to the different parties in what business structure they might…
You are considering producing a new golf ball for sale in China to meet agrowing demand in the country. This golf ball is less expensive to manufacture compared with a better known brand, but it meets all requirements set by the United States Golf Association (USGA) for play at any competitive event. Production will require an initial outlay for the purchase of equipment worth $1,500,000. The equipment has a six-year life with an expected salvage value of $100,000. You already own the land on which the project will be located. The land has a current market value of $100,000, and its price is expected to grow by 5% per year. If you decide not to produce the golf balls, you will sell the land. You have also gathered the following information:(i) You expect revenue of $500,000 per year for each year of operation. Yourdirect cost of producing the golf ball is expected to be 30% of the revenue.(ii) The operating cost, including marketing, is another 15% of the revenue.(iii) You will need to…
Liv Enterprise is considering a national launch of 2 corn chip products under project A and B. The National launch will require the following:Additional manufacturing equipment; Project A: K900, 000.00 and Project B: K1, 000,000.00 Upgrading Existing Facilities; Project A: K100, 000.00 and Project B: K400,000.00 Both of the above would be paid for at the outset and would be depreciated in the accounts over a five year period using straight line with a residual value of for both for Project A and B of zero.Projected revenues and costs over a period of five years are given in table below:Project AYear Revenue Costs1 K1,200,000.00 K1,340,000.002 K2,000,000.00 K1,670,000.003 K2,000,000.00 K1,520,000.004 K2,250,000.00 K1,685,000.005 K2,250,000.00 K1,685,000.00 Project B Year Revenue Costs1 K1,300,000.00 K1,460,000.002 K2,100,000.00 K1,520,000.003 K2,200,000.00 K1,400,000.004…
Parker Hannifin of Cleveland, Ohio manufactures CNG fuel dispensers. It needs replacement equipment to streamline one of its production lines for a new contract, but plans to sell the equipment at or before its expected life is reached at an estimated market value for used equipment. Select between the two options using the corporate MARR of 15% per year and a future worth analysis for the expected use period. Also, write the FV spreadsheet functions that will display the correct future worth values. Option D E First cost, $ −62,000 −77,000 AOC, $ per year −15,000 −21,000 Expected market value, $ 8,000 10,000 Expected use, years 3 6

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS