For This or a Similar Paper Click To Order Now

Assignment #3: Financial Statement Analysis [20%] This assignment relates to the
Assignment #3: Financial Statement Analysis [20%] This assignment relates to the following Course Learning Requirements: CLR 1: Demonstrate the competencies required in the professional workplace. CLR 3: Complete authentic accounting related tasks similar to those one would experience in a typical business. CLR 4: Determine which government regulations apply to different businesses. Objective of this Assignment: In this assignment, students will demonstrate the financial statement analysis skills. Pre-Assignment Instructions: 1. To prepare you for this assignment, read the module 3 content, review all additional resources provided and complete the learning activity 3.1. 2. Download the attached Excel file titled Assignment Tasks: The tasks outlined below are to be completed based on the information provided in the attached excel file. · Perform a Horizontal analysis for the year 2018 to year 2021 Income Statement and Balance sheet. · Perform a Vertical analysis (common size statements) for the year 2018 to year 2021 Income Statement and Balance sheet. o Always consider the first year as the base year for the horizontal analysis. · Provide your observations on the trends of the business, based on your horizontal and vertical analysis. · Assess the business’ liquidity by using liquidity ratios. o Is the company's position improving or deteriorating? Explain your answer. · Assess the business’ profitability by using profitability ratios. o Is the company's position improving or deteriorating? Explain your answer. · Based on the above analysis (horizontal, vertical, and ratios), write a brief financial summary of the business, and explain any observed risks/weaknesses for the business. Assignment Submission: · Your assignment is to be submitted in EXCEL format. It should be submitted with the following guidelines: o Include a cover page with the course code and course name, the assignment number, the title of your assignment, your student ID, your name, the instructor’s name, and the date the assignment is created. o Ensure the first page of your assignment has the title at the top of the page and the sections of your report have headings and subheadings to chunk your assignment into sections for each of the topics you are writing about. o Font should be Arial 12 or Calibri 12. Text must be double spaced but table may be single spaced. o You must cite all your sources of information using APA formatting.

For This or a Similar Paper Click To Order Now

Leave a Reply

Your email address will not be published.

For This or a Similar Paper Click To Order Now