Conduct a quick sensitivity analysis on the model

Assignment Help Financial Accounting
Reference no: EM132898078

Question - Coleman Technologies is considering a major expansion program that has been proposed by the company's information technology group. Before proceeding with the expansion, the company must estimate its cost of capital. Suppose you are an analyst with Coleman Technologies and you have been tasked with estimating the different components of cost of capital. The following data has been provided to you to assist with your task.

1. The firm's tax rate is 25%.

2. For the bond: a) The current price is $1,153.72. b) The coupon rate is 12%. c) The years to maturity is 15 years. d) New bonds would be privately placed with no flotation cost.

3. For preferred stock: a) The current price is $111.10 b) The dividend rate is 10%. The par value is $100.

4. For common stock: a) The current price is $50 per share. b) The last dividend (D0) was $4.19. Dividends are expected to grow at a constant annual rate of 5% in the foreseeable future. Ignore flotation costs.

5. Coleman's target capital structure is 30% debt, 10% preferred stock, and 60% common equity.

Before Tax cost of debt =10%, after tax cost of debt= 7.5%, cost of preferred stock= 9%, common stock= 13.8%, WACC= 11.43%.

Required - Conduct a quick sensitivity analysis on the model you used to answer the previous questions. For the sensitivity analysis change (by either increasing or decreasing) the value of one of the factors which affects WACC. Describe what you changed and describe its impact on WACC. Also, hypothesize on what economic/political factors could drive such a change.

Reference no: EM132898078

Questions Cloud

David alleged industrial espionage : What steps might have been taken to detect David's alleged industrial espionage?
Why due process is important for the accused : In a well written posting, In your opinion, Why due process is important for both the accused and for the criminal justice system?
How long will it be before you have enough to buy the car : You have $42,000 today that can be invested at your bank. The bank pays 5.0% annual interest on its accounts. How long will it be before you have enough to buy
Which identity group in society affected by social problem : Explain the key elements of your proposed study: What is the social problem? Which identity group in society is most affected by this social problem?
Conduct a quick sensitivity analysis on the model : Coleman's target capital structure is 30% debt, 10% preferred stock, and 60% common equity. Conduct a quick sensitivity analysis on the model
Explain the role of intuition in decision making. : Explain the role of intuition in decision making.
Determine whether the system is observable : Determine whether the system is observable - Design a full-order state observer to estimate the state vector of the system. In your observer stet design
Symptoms of underlying problems at company : Identify at least two symptoms of underlying problems at your company.
Define free trade and define trade wars : Define free trade and define trade wars and consider the pros and cons of free trade, referring to the theory of comparative advantage

Reviews

Write a Review

Financial Accounting Questions & Answers

  Compute the payoff certificate of deposit issue

Compute the payoff (future value) of a 181 day $1,000 certificate of deposit issued on March 15, 2015 that offers 5 percent coupon rate under ACT/ACT.

  Find the effective annual rate

Calculating Annuity Present Value, EPR & Annual Percentage Rate - What rate should the shop report? Find the effective annual rate?

  Determine the amount of the impairment loss

determine the amount of the impairment loss to be recognized by Maynilad Bank, and give the entry in the books of the company to record the impairment.

  Find the amount of interest expense pertaining to the bond

Find the amount of interest expense pertaining to the bond that the company will report on its income statement for the year ending December 31, 20X1

  Amount of deferred taxes to be reported on the balance sheet

The book basis of depreciable assets for Erwin Co. is $870,000, and the tax basis is $750,000 at the end of 2015. The enacted tax rate is 34% for all periods. Determine the amount of deferred taxes to be reported on the balance sheet at the end of 20..

  Should the company xyz incorporate the feature

Assuming the discount rate is 6%, should the company XYZ incorporate the feature based on Net Present Value (NPV) Analysis?

  What is the profitability index for a net present value

What is the profitability index for a Net Present Value of benefits totaling $400,000 and Net Present Value of costs totaling $200,000?

  Compute the acquisition cost of the equipment

Compute the acquisition cost of the equipment. Clearly identify each element of cost

  The temporary book–tax difference for the depreciable asset

Ayres Services acquired an asset for $80 million in 2013. The asset is depreciated for financial reporting purposes over four years on a straight-line basis (no residual value). For tax purposes the asset’s cost is depreciated by MACRS.

  Balance sheet reporting issues

Crumple Car Rentals is planning to expand into the western part of the United States and needs to acquire approximately 400 additional automobiles for rental purposes. Create a wholly owned leasing subsidiary that would borrow the money with a guaran..

  What the current ratio expressed as a proportion is

The current assets of Vaughn Company are $292900. The current liabilities are $146450. The current ratio expressed as a proportion is

  How to compute number of units that would have to be sold

Compute the margin of safety in units. Compute the number of units that would have to be sold to reach Sedaprasa Sdn Bhd's target net income of RM17,500.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd