User Account

All Pages

Prepare a dcf analysis on amd

Assignment Help Financial Accounting
Reference no: EM134556

Prepare a DCF analysis on AMD· Ultimate goal is for to determine a range of implied AMD share price you believe is related - DCF starting from 2008 to 2020· When showing your homework, we will probe: o Why you select some assumptions on financials o Why you choose some assumptions on WACC / terminal value growth o Why you select some assumptions in creating the sensitivity tables

1. Why you select some assumptions on financials

2. Why you select some assumptions on WACC /terminal value growth

3. Why you select some assumptions in creating the sensitivity tables

Actual   Broker consensus   ATIC estimates
2008A 2009A 2010A 2011E 2012E 2013E 2014E 2015E 2016E 2017E 2018E 2019E 2020E

Revenue
       
% growth
       
EBITDA
 
   
% growth
       
% margin
       
D & A
 
   
% capex
       
EBIT
 
   
% margin
       
NOPLAT tax
 
   
Tax rate %        


 
   
NOPLAT
 
   
% margin
       


 
   
D & A (add back)  
   
Capex
 
   
% revenue        
Change in WC  
   
% revenue        
           
Free Cash Flow        
% growth
 
   
% margin
 
   
Cash conversion (FCF/EBITDA)  
   



Terminal growth

EBITDA exit multiple

#DIV/0!          
0          

  #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.0% 0 0 0 0 0

  #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.0% 0 0 0 0 0
WACC   #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! WACC 0.0% 0 0 0 0 0

  #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.0% 0 0 0 0 0

  #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
0.0% 0 0 0 0 0

WACC Assumptions & Calculation  
WACC (public company)  
Cost of Equity (Ke)    
Risk free rate (rf)    
Beta       
Market risk premium (rm-rf)  
MV of Equity    
Equity/Total Capital    
Net cost of debt    
Risk free rate (rf)    
Debt premium    
Gross cost of debt    
Tax rate      
BV of Debt/(Cash)    
Debt/Total Capital    
MV of Total Capital    

WACC = Weighted Average Cost of Capital

βu = βl / {1 + [(1 - t)D/E]}

Keu = rf + βu(rm - rf)

Kel = rf + βl(rm - rf)

WACC = D/D+E(1-t)Kd + E/D+Ekel

Reference no: EM134556

Questions Cloud

Polymer diffusion and calibration of an optical tweezer : Polymer diffusion and Calibration of an optical tweezer
Monitor expenditure and compare with financial plan : Report and monitor expenditure and compare with financial plans so that recommendations are developed for key stakeholders.
Design a set of 3nf tables for database scenario : Draw an ER diagram for your database scenario. Design a set of 3NF tables for your database scenario.
Calculate the stock price of ibm : Calculate the stock price of IBM - Using the information of the present year to evaluate the current stock.
Prepare a dcf analysis on amd : Prepare a DCF analysis on AMD· Ultimate goal is for to determine a range of implied AMD share price you believe is related -
Forecasting with time series analysis : Develop a sales forecast for each store for December Plot the data for each store.Use data in table.
Write a report on toxic and hazardous waste : Toxic and Hazardous waste: how are they treated, safety measures, regulations in USA about hazardous waste.
Build and describe a prototype model : Mathematical Programming and Optimisation: Build and describe a prototype model Use your model to recommend a schedule of burning and, if required buying fuels
What do you meant by blue ocean strategy : This problem is related to Busniess Management What do you meant by ‘blue ocean' strategy? How does it differ from brainstorming?

Reviews

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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