Question;Makeup AssignmentThe questions in this assignment all use Intel (ticker: INTC) as the analysis company. In order torespond to the questions, you will need to use the financial statements on pages 48 to 51 ofIntel?s 10-K SEC report for the fiscal year ended December 25, 2010. This report can be obtainedfrom the ?Filings / Search for Company Filings? section of www.sec.gov. Whenever the questionsrefer to ?FYE 12/2010? they are referring to the fiscal year ended 12/25/2010 which is covered inthe above mentioned 10-K report. Whenever the questions refer to ?FYE 12/2011? they arereferring to the fiscal year ending in December 2011, assuming this is a future year which has notyet been reported.1. Define the term ?book value? and state Intel?s book value at the end of its FYE 12/2010.2. Define the term ?market value? and state Intel?s markets value at the end of its FYE 12/2010.3. Explain why there is a difference between the two values.4. State the one account (account title and amount) that explains most of the difference betweennet income (NI) and cash flow from operations (CFO).5. Explain why this account is included in one calculation (NI) and not in the other (CFO).6. One of Intel?s competitors, Advanced Micro Devices (ticker: AMD) reported net income of7.25%, compare this figure to Intel?s and state if Intel?s figure is favorable or unfavorable toshareholders as compared to AMD?s.7. Define the term ?current ratio.? Calculate Intel?s current ratio for its FYE 12/2010 and compare itto the same ratio for the prior year. Is the ratio for the FYE 12/2010 better or worse than the prioryear?s?8. Define the term ?days sales in inventory.? Calculate Intel?s days sales in inventory for its FYE12/2010 and compare it to the same ratio for the prior year. Is the FYE 12/2010 ratio better orworse than the prior year?s?For questions 9 to 12: Intel is forecasting that in FYE 12/2011 it will pay no dividends and it willgrow its sales by 25%. Intel expects every single one of its accounts to vary proportionately withsales. Intel is preparing a simple financial planning model for its FYE 12/2011 using only thefollowing accounts: Sales, costs, net income, assets, liabilities and equity. If needed, Intel will takeon more debt (but not more equity) to finance its growth in FYE 12/2011.9. Prepare an income statement for FYE 12/2010 using the same figures as reported in Intel?s10K but using only the above listed accounts.10. Prepare a balance sheet FYE 12/2010 using the same figures as reported in Intel?s 10K butusing only the above listed accounts.11. Prepare a pro-forma income statement for FYE 12/2011 considering the assumptionsstated above.12. Prepare a pro-forma balance sheet for FYE 12/2011 considering the assumptions statedabove and making sure it is reconciled with the pro-forma income statement (i.e. equityincrease = net income).13. According to its statement of cash flows, Intel paid dividends of $3,503 million during its FYE12/2010. Define ?dividend payout ratio? and state Intel?s dividend payout ratio for its latest fiscalyear.14. Define ?internal growth rate? and calculate Intel?s internal growth rate assuming Intel plans tomaintain the retention ratio it had in its FYE 12/2010.15. Define ?sustainable growth rate? and calculate Intel?s sustainable growth rate assuming Intelplans to maintain the retention ratio it had in its FYE 12/2010.
Paper#48192 | Written in 18-Jul-2015Price : $31