You are required to complete three parts of the final project. PART A-Data Extraction and Analysis...

 

Transcribed Image Text:

You are required to complete three parts of the final project. PART A-Data Extraction and Analysis [20 points] Juan Esquibel, CPA, LLC is a new CPA firm in a city. They offer accounting, bookkeeping, tax preparation and other consulting services to small and medium sized businesses. They want to offer new services in a city. They want to find the new business opportunities. Imagine that you have been hired by Juan Esquibel. You are required to analyze the existing accounting and law firms and their services and recommend which new service(s) they should launch. To do that you should follow the steps below: 1) Extract all accounting firms' information from yelp.com by using Web Scrape. 2) Present the existing services offered by the existing firms in the city. 3) Recommend which one is best to launch. Briefly state your reasoning. Special instructions: The results of your analysis must be presented visually. You should use Excel Pivot Table/Tableau Desktop. You will be applying basic Excel skills such as IF, SUMIF, and COUNTIF. PART B-Impact of ASC 606 (Revenue from Contracts with Customers) on Revenue and Retained Earnings [20 points] Revenue from Contracts with Customers (ASC 606) is a new revenue recognition standard that affects all businesses that enter into contracts with customers to transfer goods or services. Both private and publicly held companies should have started to comply with the new ASC 606 from 2017 and 2018. The main purpose of the standard is to eliminate variations in the way businesses across industries handle accounting for similar transactions. In this report you are required to show impact of ASC606 on companies' revenue and retained earnings. You have to follow the steps below: 1) Collect data on the adoption of ASC606 of 40 companies. Collect their revenue and retained earnings data before and after adoption of ASC 606. You should find all the data on SEC Edgar. 2) Report your findings both in tabular and visual format. You should use Excel Pivot Table/Excel Power BI/Tableau Desktop. 3) Write a report. You are required to complete three parts of the final project. PART A-Data Extraction and Analysis [20 points] Juan Esquibel, CPA, LLC is a new CPA firm in a city. They offer accounting, bookkeeping, tax preparation and other consulting services to small and medium sized businesses. They want to offer new services in a city. They want to find the new business opportunities. Imagine that you have been hired by Juan Esquibel. You are required to analyze the existing accounting and law firms and their services and recommend which new service(s) they should launch. To do that you should follow the steps below: 1) Extract all accounting firms' information from yelp.com by using Web Scrape. 2) Present the existing services offered by the existing firms in the city. 3) Recommend which one is best to launch. Briefly state your reasoning. Special instructions: The results of your analysis must be presented visually. You should use Excel Pivot Table/Tableau Desktop. You will be applying basic Excel skills such as IF, SUMIF, and COUNTIF. PART B-Impact of ASC 606 (Revenue from Contracts with Customers) on Revenue and Retained Earnings [20 points] Revenue from Contracts with Customers (ASC 606) is a new revenue recognition standard that affects all businesses that enter into contracts with customers to transfer goods or services. Both private and publicly held companies should have started to comply with the new ASC 606 from 2017 and 2018. The main purpose of the standard is to eliminate variations in the way businesses across industries handle accounting for similar transactions. In this report you are required to show impact of ASC606 on companies' revenue and retained earnings. You have to follow the steps below: 1) Collect data on the adoption of ASC606 of 40 companies. Collect their revenue and retained earnings data before and after adoption of ASC 606. You should find all the data on SEC Edgar. 2) Report your findings both in tabular and visual format. You should use Excel Pivot Table/Excel Power BI/Tableau Desktop. 3) Write a report.

Answer rating: 100% (QA)

Answer To complete Part A of the final project you will need to follow these steps 1 Extract all acc... View the full answer