The
Assignment:
Complete this assignment in
the Bongo environment by clicking on the attachment link, which will launch a
new browser window.
Refer to the Course
Materials for additional guidance on completing assignments using Bongo.
The purpose of this
assignment is to prepare a vertical and horizontal common-size analysis.
Financial statement
analysis requires the analyst to utilize calculation tools, such as horizontal,
vertical, and ratio analysis. Interpretation of the ratio analysis allows the
analyzer to observe changes in revenue over time.
For your assignment, locate
and review the last 3 years of the annual report of the company selected for
your Financial Statement Analysis Report. This document is located on the
company's website under Investor Relations. Prepare a vertical and horizontal
analysis in the Balance Sheet and Income Statement tabs of the "Financial
Statement Report Excel Spreadsheet" (FSAR Excel Spreadsheet) provided. The
spreadsheet will serve as a guideline for completing the assignment, the actual
sections or order of reporting from the company's annual report may vary.
Complete only the applicable sections based on the information provided in the
company's annual report.
1.
Complete the horizontal
analysis column of the prior 3
2.
Complete the vertical analysis column for the prior 3
Address in the following
questions in the comments section of both the Balance Sheet and Income
Statement tabs:
1.
What accounts changed for the period and how did this affect the
financial analysis calculation?
2.
Why did the account change during the period? Explain what
business decisions may have caused the change.
3.
How does this change influence the company's performance?
The CLC group will submit
the FSAR Excel Spreadsheet with the analyzed data for the selected company. To
earn full credit on this assignment, the group must show detailed work in
Excel, which includes providing the formulas and comments in the cells, not
just the summary value.
APA style is not required, but
solid academic writing is expected.
This assignment uses a
rubric. Please review the rubric prior to beginning the assignment to become
familiar with the expectations for successful completion.
You are not required to
submit this assignment to LopesWrite.
The instructor will provide
feedback on this assignment. Evidence of revision will be assessed on the final
report.
Get Free Quote!
354 Experts Online