ACG-Your Company #1 – Balance Sheets, Income Statements, Sta…

This is the first of several spreadsheets and assignments you will complete related to the Your Company Project.

1. Download and save this template spreadsheet, . This is a financial statement analysis spreadsheet template file accompanying the Financial Reporting, Financial Statement Analysis and Valuation textbook.
2. Name and save your spreadsheet file as ACG 5153 YC1 LastName FirstName.
3. Open the spreadsheet tab titled Data. This spreadsheet is set up so that you enter Your Companys data in the green shaded cells with a blue font. You must manually type the data in those cells FOR ALL SIX YEARS.

1. 1. 1. Input Your Company’s name, your name as analyst, and the six years column headings on the spreadsheet.
      2. Ensure that you have SIX years of Annual Reports downloaded for your company as data for input into the FASP 9e spreadsheet. (You will use the six years of data downloaded from SEC EDGAR 10-K reports for Your Company for supplemental data as needed.)
      3. Manually type in the Balance Sheet, Income Statement, Statement of Cash Flows, and Supplementary Data amounts/numbers into the appropriate cells in the Data tab of the FSAP 9e spreadsheet file FOR ALL SIX YEARS. See the textbook authors instructions on entering data included in in the FSAP 9e spreadsheet.
      4. As you input your data, be sure to notice that the most recent year is the year furthest to the right. The years in the FSAP 9e spreadsheet are in the opposite order of the data downloaded in the Annual Reports from Your Company’s website and from SEC Edgar.
      5. Ensure that your data entry is correct and that all the cells in lines 154 thru 156 (FINANCIAL DATA CHECKS) on the “Data” tab, and lines 14 thru 17 (DATA CHECKS) on the Analysis tab of the FSAP 9e spreadsheet file show “0” as the calculated amounts.
      6. Use amounts in the Data Check cells on both tabs in the spreadsheet to help you identify input errors.
2. Review the Rubric for Assignment Your Company #1 to ensure that your completed assignment meets the grading criteria.
3. Save the data you entered in your spreadsheet file named as ACG 5153 YC1 LastName FirstName.
4. Submit your completed assignment in Canvas in the assignment by the due date and time.

Get fast, custom help from our academic experts, any time of day.

Place your order now for a similar assignment and have exceptional work written by our team of experts.

Secure 100% Original On Time Delivery