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

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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