Prepare a dcf analysis on amdmiddot ultimate goal is for to

Assignment Help Financial Accounting
Reference no: EM13350601

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: EM13350601

Questions Cloud

1 polymer diffusion the figure below shows the result of a : 1 polymer diffusion the figure below shows the result of a particle tracking experiment where lateral positions of
Part a - performance objectivereport and monitor : part a - performance objectivereport and monitor expenditure and compare with financial plans so that recommendations
Metropolitan city church managementmetropolitan city church : metropolitan city church managementmetropolitan city church management mccm has hired you as a consultant to modernize
Calculate the stock price of ibm1using ddm pe ggm multiple : calculate the stock price of ibm1.using ddm pe ggm multiple approach show the calculation2. make your assumptions about
Prepare a dcf analysis on amdmiddot ultimate goal is for to : prepare a dcf analysis on amdmiddot ultimate goal is for to determine a range of implied amd share price you believe is
Forecasting with time series analysis objective crusty : forecasting with time series analysis objective crusty pizza executives have to forecast december sales for the 10
Each report may cover all items included in the description : each report may cover all items included in the description of the project below1. toxic and hazardous waste how are
Mathematical programming and optimisationindividual : mathematical programming and optimisationindividual assignmentapproach this as if it were a piece of commercial work
Question 1 give examples of companies that have improved : question 1. give examples of companies that have improved their market position market leader by dramatically shifting

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!

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