Project Description:
- Objective: Transfer Domino's Pizza financial data from the SEC Edgar website into an Excel template, ensuring all accounts and totals align correctly with the company's financial statements.
- Requirements: Use the existing account structure without adding or changing accounts, and ensure all totals add up accurately.
Steps to Follow:
- Data Retrieval:
- Access the most recent 10-K report for Domino's Pizza via the SEC Edgar website using the provided link.
- Extract relevant financial data, including balance sheets, income statements, and cash flow statements.
- Excel Template Setup:
- Input the extracted financial data into the specified accounts in the Excel template.
- Ensure each account is correctly aligned with the structure provided (e.g., Current Assets, Liabilities, Shareholders Equity).
- Verification:
- Use Excel formulas to verify that all accounts add up correctly.
- Ensure that the total assets equal the total liabilities and shareholders' equity, maintaining the balance sheet equation.
Skills Required:
- Accounting Knowledge: Understanding of how to interpret and organize financial data according to standard accounting practices.
- Excel Proficiency: Ability to use Excel formulas and functions to ensure data accuracy and alignment.
Resources:
- SEC Edgar Website: Utilize the link to access Domino's Pizza's financial statements.
For dominos company https://www.sec.gov/ix?doc=/Archives/edgar/data/00... In order to fill out the template , Please use the following to obtain the numbers:CONSOLIDATED BALANCE SHEETSCONSOLIDATED STATEMENTS OF INCOMECONSOLIDATED STATEMENTS OF CASH FLOWS The template provided below.