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

  Calculate the amount of phantom profit

Calculate the amount of phantom profit that would result if the company used FIFO rather than LIFO. Describe why this amount is referred to as phantom profit

  Purpose the journal entries that rod corporation

Purpose the journal entries that Rod Corporation recorded during 20X4 related to its investment in Stafford Corporation, considering Rod uses the equity method in accounting for its investment.

  Find gross income from receiving the life insurance proceeds

What amount could Ray include in his gross income from receiving the life insurance proceeds? The insurance company paid Ray $16,000 interest on the life insurance proceeds through the period Carin's estate was in administration.

  Purpose a pension worksheet for the pension plan

Purpose a pension worksheet for the pension plan for 2013 and 2014.

  Evaluate the ratio of fixed assets to long-term liabilities

Evaluate the following: (a) ratio of fixed assets to long-term liabilities, (b) ratio of liabilities to stockholders' equity, (c) ratio of net sales to assets, (d) rate earned on total assets, (e) rate earned on stockholders' equity, and (f) rate ..

  Prepare needed journal entries for 2014 and 2015

Prepare needed journal entries for 2014 and 2015. Be sure to indicate whether each entry should be made to an unrestricted or temporarily restricted fund. You need not, thus, record the indirect costs themselves.

  Prepare general journal entries to record the transactions

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

  Prepare your retirement plan for client

Prepare your retirement plan for Client Expected rate of return on retirement savings

  What is the product cost for the extension product

What is the product cost for the extension product under absorption and variable costing

  Discuss applicable codification references

Applicable Codification references Related presentation and disclosure issues for the notes Any additional clarifying information needed from company management

  Determine the npv of each choice

Propose when should Bell Mountain buy the new accounting system and Determine the NPV of each choice?

  Evaluate service revenue and salaries expense

Judi uses the subsequent chart of accounts: No. 101 Cash, No. 112 Accounts Receivable, No. 126 Supplies, No. 201 Accounts Payable, No. 205 Unearned Revenue, No. 311 Common Stock, No. 400 Service Revenue, No. 726 Salaries Expense, and No. 729 Rent ..

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