search for data of company AMD of 4-5 years and do cash flow statements and ratios only

read the requirements for cash flow statements and ratios

21F241_Group Project-2 (Protected View) - Word Mailings Review View Help Tell me what you want to do iruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing 1 2 1 3 BFIN 241 Group Project - Fall 2021 Objectives: To evaluate the performance of a public company I To prepare and present recommendations for improving company performance To become familiar with and track key economic indicators The objective will be to create, as your interim report, a set of fully formatted appendices that contain your financial statement data and accurate vertical, horizontal, and ratio analyses. These will serve as the foundation for your final report. Therefore, if you do not submit the interim requirements, or your work is of poor quality, you will be ineligible to complete the final report. You must achieve a grade of at least 65% on the interim report to proceed to the final report. If you do not achieve the 65%, you will be provided with one opportunity to remedy deficiencies in order to move on to the final report. The corrections must be made within one week of receiving your graded interim report and will not alter your assigned interim report grade. If the corrected submission is still deficient, you will receive a grade of zero for the final report. Requirements: Enter balance sheet, income statement and cash flow statement for a minimum of 4 years (maximum 5 years) into the Excel template provided. Consolidate information so all statement data fit on one page 4 e. The 4 or 5 year comparative income statement is on one page The 4 or 5 year comparative balance sheet is on one page The 4 or 5 year comparative cash flow statement is on one page The statements must be properly formatted including relevant headers and subtotals. Your goal is to make the financial statements "user friendly". Present subtotals for key figures (eg. Gross Margin, Total Current Assets, etc.) Use the spreadsheet to calculate all totals Using Excel, and linking all calculations, prepare vertical and horizontal analyses. For the horizontal analysis, set your base year to 100%, Using Excel, and linking all calculations, prepare a ratio analysis for YOUR company (note the Excel template lists all required ratios). Note the requirement to calculate ROA using the DuPont method. Use the spreadsheet to calculate all totals and ratios, it is not a word processor. Your grade is based on the accuracy of the spreadsheet formulae. Delete all instructions and sample information from your submission You are not required to include COMPETITOR ratios. You are not required to interpret the ratios at this time. Your ratio calculations will be examined for accuracy. You will have an opportunity be required to correct and resubmit any errors. You will then be able to interpret accurate data for the final report, A1 th @ https://docs.google.com/spreacher CMPCC-12200 241 Group Project Excel Template . File Edit View Insert Format Data Tools Add-ons Help Last edited yesterday at 18:30 by any 100- 123- Arild 10 BISA. - ... MBT-I fx Company Nam e Company Name AMD Note: DuPont Analysis Replace headers with appropriate year for some companies year will be This depends on the company's fiscal year end Pront margin 2010 2010 2011 Net income ALE 25 IUN. 3725 15 11.13 Sales NVIDIA 259 29 30 21419 Intel 2 DIN 29.97 20N . 2 Y5 TYA y3 Y2 Y1 10 Sales Total Total se utover Your company Competitor Competor 2 74 15 Return on essats Profi Magni Assot TumOve Your Company Compattor 1 Como 2 31 DuPont- DUB Sample CF- Samolence Shot CF - M AUR -IR- 35- PR - retin 2 o BD Type here to search 21F241_Group Project-2 (Protected View) - Word Mailings Review View Help Tell me what you want to do iruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing 1 2 1 3 BFIN 241 Group Project - Fall 2021 Objectives: To evaluate the performance of a public company I To prepare and present recommendations for improving company performance To become familiar with and track key economic indicators The objective will be to create, as your interim report, a set of fully formatted appendices that contain your financial statement data and accurate vertical, horizontal, and ratio analyses. These will serve as the foundation for your final report. Therefore, if you do not submit the interim requirements, or your work is of poor quality, you will be ineligible to complete the final report. You must achieve a grade of at least 65% on the interim report to proceed to the final report. If you do not achieve the 65%, you will be provided with one opportunity to remedy deficiencies in order to move on to the final report. The corrections must be made within one week of receiving your graded interim report and will not alter your assigned interim report grade. If the corrected submission is still deficient, you will receive a grade of zero for the final report. Requirements: Enter balance sheet, income statement and cash flow statement for a minimum of 4 years (maximum 5 years) into the Excel template provided. Consolidate information so all statement data fit on one page 4 e. The 4 or 5 year comparative income statement is on one page The 4 or 5 year comparative balance sheet is on one page The 4 or 5 year comparative cash flow statement is on one page The statements must be properly formatted including relevant headers and subtotals. Your goal is to make the financial statements "user friendly". Present subtotals for key figures (eg. Gross Margin, Total Current Assets, etc.) Use the spreadsheet to calculate all totals Using Excel, and linking all calculations, prepare vertical and horizontal analyses. For the horizontal analysis, set your base year to 100%, Using Excel, and linking all calculations, prepare a ratio analysis for YOUR company (note the Excel template lists all required ratios). Note the requirement to calculate ROA using the DuPont method. Use the spreadsheet to calculate all totals and ratios, it is not a word processor. Your grade is based on the accuracy of the spreadsheet formulae. Delete all instructions and sample information from your submission You are not required to include COMPETITOR ratios. You are not required to interpret the ratios at this time. Your ratio calculations will be examined for accuracy. You will have an opportunity be required to correct and resubmit any errors. You will then be able to interpret accurate data for the final report, A1 th @ https://docs.google.com/spreacher CMPCC-12200 241 Group Project Excel Template . File Edit View Insert Format Data Tools Add-ons Help Last edited yesterday at 18:30 by any 100- 123- Arild 10 BISA. - ... MBT-I fx Company Nam e Company Name AMD Note: DuPont Analysis Replace headers with appropriate year for some companies year will be This depends on the company's fiscal year end Pront margin 2010 2010 2011 Net income ALE 25 IUN. 3725 15 11.13 Sales NVIDIA 259 29 30 21419 Intel 2 DIN 29.97 20N . 2 Y5 TYA y3 Y2 Y1 10 Sales Total Total se utover Your company Competitor Competor 2 74 15 Return on essats Profi Magni Assot TumOve Your Company Compattor 1 Como 2 31 DuPont- DUB Sample CF- Samolence Shot CF - M AUR -IR- 35- PR - retin 2 o BD Type here to search