Cost of debt capital using the after-tax cost of debt model

Assignment Help Financial Accounting
Reference no: EM131428833

PART: Financial Analysis of Company's Past and Present Performance

COMPANY NAME IS BRISTOL-MYERS SQUIBB.

1. Determine the following for your company:
a. Cost of debt capital using the After-Tax Cost of Debt model
b. Cost of equity capital using the CAPM model
c. Weighted cost of capital
d. Dividend Discount Framework

Use the first year of your forecasted financial statements to perform these calculations. You DO NOT have to do these calculations for all the years, only the first year of your forecasted financial statements.

Must show all work and calculations. Must provide summary or where information was gathered or calculated for assumptions.

The work should be performed on a separate tab in your Financial Analysis Excel file.

2. For both of the valuation models below, develop a valuation for your company.
a. Discounted Cash Flow Model
b. Residual Operating Income Model

These models require multiple years of financial information; therefore, you will use more than just the first year of your forecasted financials statements. You will use all the years of your forecasted financial statements.

Must show all work and calculations. Must provide summary or where information was gathered or calculated for assumptions. This value would be what you would use to buy or sell the company.

The work should be performed on a separate tab in your Financial Analysis Excel file.
3. A) Prepare the company and equity intrinsic value for your company using all of the following Multiple Models:

a. NOPAT Multiple
b. Net Income Multiple
c. Net Operating Assets (NOA) Multiple
d. Book Value Multiple

B) Also calculate the Price per Earnings Ratio (P/E) for your company.

Use the first year of your forecasted financial statements to perform these calculations. You DO NOT have to do these calculations for all the years, only the first year of your forecasted financial statements.

Must show all work and calculations. Must provide summary or where information was gathered or calculated for assumptions

The work should be performed on a separate tab in your Financial Analysis Excel file.

Attachment:- Project - Financial Analysis.zip

Verified Expert

The task required computing the weighted average cost of capital of BMY in the first part which has been done as per the WACC Formula. The valuation model comprises of the second part. The third part consists of Company and Equity Intrinsic Value based on various multiples that has been computed with the help of Johnson & Johnson and Pfizer Inc.

Reference no: EM131428833

Questions Cloud

Calculate the price of a cap : Calculate the price of a cap on the 90-day LIBOR rate in nine months' time when the principal amount is $1,000. Use Black's model with LIBOR discounting and the following information:
Analyze the concepts of patients rights : Analyze the concepts of patients' rights and the overall concerns of physicians and nurses, as they apply to 21st Century American patients. Speculate on the major ways in which these overlapping concerns from all health care professions may influ..
How do you change the culture of an organization : How do you change the culture of an organization? How did the Hawthorne Experiments (Mayo, 1953) contribute to the study of leadership?What is meant by the Hawthorne effect? how did Organizational culture and leadership (Schein, 1993) contribute to t..
Describe the person background and psychological perspective : Write a 700- to 1,050-word paper in which you describe the person's background, psychological perspective, and the contribution he or she made to the field of psychology
Cost of debt capital using the after-tax cost of debt model : Determine the following for your company Cost of debt capital using the After-Tax Cost of Debt model and Cost of equity capital using the CAPM model
Variance analysis discussion : What factors are used byan organization to determine the appropriate discount rate to use for a net present value analysis?
Does a job with any defect at all signal a lack of control : Suppose that records on 132 jobs show a total of 2 defects recorded. What retrospective control limits might then be applied to the 132 different counts of defects? Does a job with any defect at all signal a lack of control?
Evaluate different aspects of organizational change : The Brisson-Banks (2010) article in the required reading for this unit compares the five different change management models presented in this unit, and it describes various situational variables that could influence the effectiveness of each. Util..
What is the difference between leadership and authority : We are in an era of significant backlash against global trade and trade agreements. Where do you stand on globalization? For or against and why? What is systems thinking? How is it linked to exercising leadership? What is the difference between leade..

Reviews

inf1428833

3/22/2017 5:42:21 AM

Great job! can you please give me a brief explanation of how you did the calculation? Honestly i am very satisfied. Greatness!!! Also, can you use Eli Railly instead Johnson & Johnson as competitor? Thanks once more for your deligent Job The best and unique web for students! 100% Excellent!!! Satisfied! Job well done!!!! yahhhhhhhh!

inf1428833

3/22/2017 5:42:13 AM

The company name is ELI LILLY instead of Eli railly. Disregard the ratio explanation. i have handled that entirely just focus on Eli LiLLY. Just want to understand part 5, are these data for Bristol Myers Squibb company as per the guideline? This research is for Bristol Myers Company with its company Eli Lilly:please read the top of the project: PART V: Financial Analysis of Company’s Past and Present Performance COMPANY NAME IS BRISTOL-MYERS SQUIBB.

len1428833

3/16/2017 1:34:50 AM

Note: please read part V guidelines. complete only part V as per its guidelines or steps. I have completed the adjustments for part 3, forecast for part 4. I have attached Nike as an example. take a keen look at nike part V and begin to work in the excel file name project 4. In the excel for project4, scroll to find" part V starts here! and begin from there. use the data from the adjustments and forecast to complete part V. let me know if you need additional data or information

Write a Review

Financial Accounting Questions & Answers

  Calculate total variable labor cost for the coming year

Using High-Low to Calculate Predicted Total Variable Cost and Total Cost for a Time Period that Differs from the Data Period Pizza Vesuvio makes specialty pizzas. Data for the past eight months were collected: Calculate total variable labor cost for ..

  New automated inventory retrieval system to reduce costs

A company is considering the purchase of a new automated inventory retrieval system to reduce costs. The new inventory retrieval system will cost $560,000. How much must be saved each year to recover this investment is seven years at an interest rate..

  Make the appropriate accounting entry as of grant date

On December 31, 2014, ABC Corporation issued 1,000 shares of restricted stock to its Chief Financial Officer. ABC stock had a fair value (closing market price) of $7 per share on December 31, 2014. The service period related to the restricted stock i..

  Calculate the total variance for aluminum for the month

Lata Inc. produces aluminum cans. Production of 11-ounce cans has a standard unit quantity of 4.9 ounces of aluminum per can. During the month of April, 350,000 cans were produced using 1,300,000 ounces of aluminum. Calculate the total variance for a..

  Pang pharmaceutical for drug under development

Blair Biotech enters into a licensing agreement with Pang Pharmaceutical for a drug under development. Blair will receive a payment of $10,000,000 if the drug receives regulatory approval. Based on prior experience in the drug-approval process, Blair..

  Interest expense reported on the income statement

For debt issued at par: interest expense reported on the income statement equals the cash paid for interest. For bond repurchases: Gain (loss. on bond repurchase = Cash paid to repurchase – Net book value of bonds. For debt issued at a discount: inte..

  Calculate the aimed profit percentages

Calculate the aimed profit percentages for the three products and under the full absorption costing method, with overhead costs absorbed on the basis of direct labour hours.

  Determine the ratio of cash flow to net income

Taking into account this change in inventory and operating liabilities on cash flows and your results from (2), compute the ratio of cash flow to net income for 2004.

  Illustrate what is amount and character of gain long

Illustrate what is the amount and character of the gain Longworth will recognize on the sale if the sale proceeds were decreased to $15,000?

  Find the unearned revenue

Enter the adjustment data in the work sheet for the transactions shown below and place the balances in the Adjusted Trial Balance columns.

  Financial statement

Prepare a financial statement for 2014 had

  Authorities responsible for balancing supply and demand

You are working for one of the 107 balancing authorities responsible for balancing the supply and demand in the U.S. Your responsibility is to identify and take actions to compensate demand changes. For the situation shown here IMAGE (grid frequency ..

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