need part 1 & part 2 answered
need all of this answered
P . TC sti Lab 1-1 Data Analytics in Financial Accounting of fc st t Let's see how we might use financial accounting data to perform some simple De Analytics. The purpose of this lab is to help you identify relevant questions that may be companies in the United States. The company already has some Data Analytics tools that it You were just hired as an analyst for a credit rating agency that evaluates publicly listed which companies are growing quickly. The company uses these analytics to provide rating answered using Data Analytics. Company summary that will allow lenders to set interest rates and determine whether to lend money in the fine place. As a new analyst, you're determined to make a good first impression. Technique Some experience with spreadsheets and basic formulas is helpful here. Software needed Word processor Web browser Screen capture tool (Windows: Snipping Tool: Mac: Cmd + Shift + 4) In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question. Part 2: Translate questions into target fields and value in a database. Part 3: Perform a simple analysis. Part 1: Identify the Questions Think about ways that you might analyze data from a financial statement. You could use a horizontal analysis to view trends over time, a vertical analysis to show account propor- tions, or ratios to analyze relationships. 1. Create a new word processing document and name the file "Lab 1-1 Data Analytics in Financial Accounting Lab- Your name) [Your email address]." 2. Use what you know about financial statement analysis for search the web if you need a refresher) to generate three different metrics for evaluating financial performance 28 For example, if you wanted to evaluate a company's profit margin from one year to the next your question might be, "Has Company X's grens margin increased in the last three years?" Type your three questions in your document. Next to each question generate a hypothetical answer to the question to help you iden tify what your expected output would be. You may use some insight or intuition or search for industry averages to inform your hypothesis. For example: "Hypothesis Apple Ine's gross margin has increased slightly in the past 3 years 4. Save your document, Part 2: Master the Data To answer your questions, you'll need to evaluate specific account values of financial statement paragraphs. As an analyst, you have access to the Security and Exchange Commission's (SECS) EDGAR database of XBRL financial statements as well as a list of XBRL tags from the Financial Accounting Standards Board (FASB) XBRL stands for extensible Business Reporting Language and is used to make the data in financial statements machine-readable. Public companies have been preparing XBRL reports since 2008. While there are some issues with XBRL data, such data have become a useful means for comparing and analyzing financial statements. Every value, date, and paragraph is tagged with a label that identifies what each specific value represents, similar to assign ing attributes in a database. Because companies tag their financial statements with XBRL tags, you can use those tags to identify specific data that you need to answer your ques tions from Part 1 Analyze your questions 5. Evaluate each question from Part 1. There are specific data attributes that will help you find the answer you're looking for. For example, if your question was "Has Company X's) gross margin increased in the last 3 years and the expected answer is "Apple Inc's gross margin has increased slightly in the past 3 years," this tells you what attributes (or fields) to look for company name, gross margin (sales revenus-cost of goods sold). Year 6. For each of your questions, identify the account or data attribute you need to answer your question. Then use FASB's XBRL taxonomy (see next section for instructions) to identify the specific XBRL tags that represent those accounts. For cumple: Company name=EntitySector IndustryClassification Primary Grass margin Gross Profit Sales menus = Sales Revenue Net Cost of goods sold CostOfGoodsAndServicesSold Year=Document Period EndDate 7. Save your document. Identify XARL tags from the FASB's taxonomy: 8. Open a web browser and go to xrlview fash.org 9. Click the next to US GAAP (2016-01-31). 10. Click the ALL (Main/Entire) option, and then click Open to load the taxonomy, 11. Navigate through the financial statements to determine which accounts you need to answer your questions from Part 1. The name of the XBRL tag is found in the proper ties pane next to "Namo." For example, the tag for Total Assets can be found by click ing+ Statement of Financial Position [Abstract). + Statement Table). + Statement Line Items). + Assets | Abstract]. + Assets, Total, as shown in Exhibit I-IA. You may also use the search function. 22 Lab 1-1 Data Analytics in Financial Accounting Let's see how we might use financial accounting data to perform some simple Duta Analytics. The purpose of this lab is to help you identify relevant questions that may be answered using Data Analytics Company summary You were just hired as an analyst for a credit rating agency that evaluates publicly listed companies in the United States. The company already has some Data Analytics tools that it uses to evaluate financial statements and determine which companies have higher risk and which companies are growing quickly. The company uses the analytics to provide ratings that will allow lenders to set interest rates and determine whether to lend money in the first place. As a new analyst, you're determined to make a good first impression Technique . Some experience with spreadsheets and basic formulas is helpful here Software needed Word processor Web browser Screen capture tool (Windows: Snipping Tools Mac: Cmd + Shift + 4) In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question *Part 2: Translate questions into target fields and value in a database. Part 3: Perform a simple analysis Part 1. Identify the Questions Think about ways that you might analyze data from a financial statement. You could use a horizontal analysis to view trends over time, a vertical analysis to show account propor tions, or ratios to analyze relationships 1. Create a new word processing document and name the file "Lab 1-1 Data Analytics in Financial Accounting Lab-Your name Your email address)." 2. Use what you know about financial statement analysis (or search the web if you need a refresher) to generate three different metrics for evaluating financial performance. 28 For example, if you wanted to evaluate a company prontmargin from one year to the next your question might be "Has Company to margin increased in the last three years Type your three questions in your document Next to each question generate a lopothetical answer to the question to help you iden tify what your expected output would be. You may use some insight or intuition or Search for industry averages to inform your hypothesis. For example: "Hypothesis Apple Ines gross margin has increased slightly in the past 3 years TICY TO BE Peut- 4. Save your document ag. METRIC Part 2: Master the Data To answer your questions, you'll need to evaluate specific account values or financial statement paragraphs. As an analyst, you have access to the Security and Exchange Commission's (SEC) EDGAR database of XBRL financial statements as well as a list of XBRL tags from the Financial Accounting Standards Board (FASB), XBRL stands for extensible Business Reporting Language and is used nake the data in financial statements machine readable. Public companies have been preparing XBRL reports since 2008. While there are some issues with XBRL data, such data have become a useful means for comparing and analyzing financial statements. Every value, date, and paragraph is "tagged with a label that identifies what each specific value represents, similar to assis ing attributes in a database. Because companies tag their financial statements with XBRL. tags, you can use those tags to identify specific data that you need to answer your ques tions from Part 1 Analyze your questions: 5. Evaluate each question from Part 1. There are specific data attributes that will help you find the answer you're looking for. For example, if your question was "Has Company X') gross margin increased in the last 3 years?" and the expected answer is Apple Ine's gross margin has increased slightly in the past 3 years, this tells you what attributes (or fields) to look for company name, gross margin (sales revenues-cost of goods sold). year 6. For each of your questions, identify the account or data attribute you need to answer your question. Then use FASB'S XBRL taxonomy (see next section for instructions) to identify the specific XBRL tags that represent those accounts. For example: Company name EntitySector Industry Classification Primary Gross margin-Gross Profit Sales revenues Sales Revenue Net Cost of goods sold = CostorGoodsAndServices Sold Year = Document PeriodEndDate 7. Save your document, Identify XBRL tags from the FASB's taxonomy: 8. Open a web browser, and go to xrlview.asb.org 9. Click the next to US GAAP (2016-01-31). 10. Click the ALL (Main/Entire) option, and then click Open to load the taxonomy, 11. Navigate through the financial statements to determine which accounts you need to answer your questions from Part 1. The name of the XBRI tag is found in the proper ties pane next to "Name" For example, the tag for Total Assets can be found by click ing + Statement of Financial Position Abstract) + Statement Table), + Statement Line Items). + Assets [Abstract) + Assets, Total, as shown in Exhibit IIA. You may also use the search function 29 P . TC sti Lab 1-1 Data Analytics in Financial Accounting of fc st t Let's see how we might use financial accounting data to perform some simple De Analytics. The purpose of this lab is to help you identify relevant questions that may be companies in the United States. The company already has some Data Analytics tools that it You were just hired as an analyst for a credit rating agency that evaluates publicly listed which companies are growing quickly. The company uses these analytics to provide rating answered using Data Analytics. Company summary that will allow lenders to set interest rates and determine whether to lend money in the fine place. As a new analyst, you're determined to make a good first impression. Technique Some experience with spreadsheets and basic formulas is helpful here. Software needed Word processor Web browser Screen capture tool (Windows: Snipping Tool: Mac: Cmd + Shift + 4) In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question. Part 2: Translate questions into target fields and value in a database. Part 3: Perform a simple analysis. Part 1: Identify the Questions Think about ways that you might analyze data from a financial statement. You could use a horizontal analysis to view trends over time, a vertical analysis to show account propor- tions, or ratios to analyze relationships. 1. Create a new word processing document and name the file "Lab 1-1 Data Analytics in Financial Accounting Lab- Your name) [Your email address]." 2. Use what you know about financial statement analysis for search the web if you need a refresher) to generate three different metrics for evaluating financial performance 28 For example, if you wanted to evaluate a company's profit margin from one year to the next your question might be, "Has Company X's grens margin increased in the last three years?" Type your three questions in your document. Next to each question generate a hypothetical answer to the question to help you iden tify what your expected output would be. You may use some insight or intuition or search for industry averages to inform your hypothesis. For example: "Hypothesis Apple Ine's gross margin has increased slightly in the past 3 years 4. Save your document, Part 2: Master the Data To answer your questions, you'll need to evaluate specific account values of financial statement paragraphs. As an analyst, you have access to the Security and Exchange Commission's (SECS) EDGAR database of XBRL financial statements as well as a list of XBRL tags from the Financial Accounting Standards Board (FASB) XBRL stands for extensible Business Reporting Language and is used to make the data in financial statements machine-readable. Public companies have been preparing XBRL reports since 2008. While there are some issues with XBRL data, such data have become a useful means for comparing and analyzing financial statements. Every value, date, and paragraph is tagged with a label that identifies what each specific value represents, similar to assign ing attributes in a database. Because companies tag their financial statements with XBRL tags, you can use those tags to identify specific data that you need to answer your ques tions from Part 1 Analyze your questions 5. Evaluate each question from Part 1. There are specific data attributes that will help you find the answer you're looking for. For example, if your question was "Has Company X's) gross margin increased in the last 3 years and the expected answer is "Apple Inc's gross margin has increased slightly in the past 3 years," this tells you what attributes (or fields) to look for company name, gross margin (sales revenus-cost of goods sold). Year 6. For each of your questions, identify the account or data attribute you need to answer your question. Then use FASB's XBRL taxonomy (see next section for instructions) to identify the specific XBRL tags that represent those accounts. For cumple: Company name=EntitySector IndustryClassification Primary Grass margin Gross Profit Sales menus = Sales Revenue Net Cost of goods sold CostOfGoodsAndServicesSold Year=Document Period EndDate 7. Save your document. Identify XARL tags from the FASB's taxonomy: 8. Open a web browser and go to xrlview fash.org 9. Click the next to US GAAP (2016-01-31). 10. Click the ALL (Main/Entire) option, and then click Open to load the taxonomy, 11. Navigate through the financial statements to determine which accounts you need to answer your questions from Part 1. The name of the XBRL tag is found in the proper ties pane next to "Namo." For example, the tag for Total Assets can be found by click ing+ Statement of Financial Position [Abstract). + Statement Table). + Statement Line Items). + Assets | Abstract]. + Assets, Total, as shown in Exhibit I-IA. You may also use the search function. 22 Lab 1-1 Data Analytics in Financial Accounting Let's see how we might use financial accounting data to perform some simple Duta Analytics. The purpose of this lab is to help you identify relevant questions that may be answered using Data Analytics Company summary You were just hired as an analyst for a credit rating agency that evaluates publicly listed companies in the United States. The company already has some Data Analytics tools that it uses to evaluate financial statements and determine which companies have higher risk and which companies are growing quickly. The company uses the analytics to provide ratings that will allow lenders to set interest rates and determine whether to lend money in the first place. As a new analyst, you're determined to make a good first impression Technique . Some experience with spreadsheets and basic formulas is helpful here Software needed Word processor Web browser Screen capture tool (Windows: Snipping Tools Mac: Cmd + Shift + 4) In this lab, you will: Part 1: Identify appropriate questions, and develop a hypothesis for each question *Part 2: Translate questions into target fields and value in a database. Part 3: Perform a simple analysis Part 1. Identify the Questions Think about ways that you might analyze data from a financial statement. You could use a horizontal analysis to view trends over time, a vertical analysis to show account propor tions, or ratios to analyze relationships 1. Create a new word processing document and name the file "Lab 1-1 Data Analytics in Financial Accounting Lab-Your name Your email address)." 2. Use what you know about financial statement analysis (or search the web if you need a refresher) to generate three different metrics for evaluating financial performance. 28 For example, if you wanted to evaluate a company prontmargin from one year to the next your question might be "Has Company to margin increased in the last three years Type your three questions in your document Next to each question generate a lopothetical answer to the question to help you iden tify what your expected output would be. You may use some insight or intuition or Search for industry averages to inform your hypothesis. For example: "Hypothesis Apple Ines gross margin has increased slightly in the past 3 years TICY TO BE Peut- 4. Save your document ag. METRIC Part 2: Master the Data To answer your questions, you'll need to evaluate specific account values or financial statement paragraphs. As an analyst, you have access to the Security and Exchange Commission's (SEC) EDGAR database of XBRL financial statements as well as a list of XBRL tags from the Financial Accounting Standards Board (FASB), XBRL stands for extensible Business Reporting Language and is used nake the data in financial statements machine readable. Public companies have been preparing XBRL reports since 2008. While there are some issues with XBRL data, such data have become a useful means for comparing and analyzing financial statements. Every value, date, and paragraph is "tagged with a label that identifies what each specific value represents, similar to assis ing attributes in a database. Because companies tag their financial statements with XBRL. tags, you can use those tags to identify specific data that you need to answer your ques tions from Part 1 Analyze your questions: 5. Evaluate each question from Part 1. There are specific data attributes that will help you find the answer you're looking for. For example, if your question was "Has Company X') gross margin increased in the last 3 years?" and the expected answer is Apple Ine's gross margin has increased slightly in the past 3 years, this tells you what attributes (or fields) to look for company name, gross margin (sales revenues-cost of goods sold). year 6. For each of your questions, identify the account or data attribute you need to answer your question. Then use FASB'S XBRL taxonomy (see next section for instructions) to identify the specific XBRL tags that represent those accounts. For example: Company name EntitySector Industry Classification Primary Gross margin-Gross Profit Sales revenues Sales Revenue Net Cost of goods sold = CostorGoodsAndServices Sold Year = Document PeriodEndDate 7. Save your document, Identify XBRL tags from the FASB's taxonomy: 8. Open a web browser, and go to xrlview.asb.org 9. Click the next to US GAAP (2016-01-31). 10. Click the ALL (Main/Entire) option, and then click Open to load the taxonomy, 11. Navigate through the financial statements to determine which accounts you need to answer your questions from Part 1. The name of the XBRI tag is found in the proper ties pane next to "Name" For example, the tag for Total Assets can be found by click ing + Statement of Financial Position Abstract) + Statement Table), + Statement Line Items). + Assets [Abstract) + Assets, Total, as shown in Exhibit IIA. You may also use the search function 29
