ACCOUNTING-Horizontal and Vertical Financial Statement Analysis with Explanatory Narrative.

Horizontal and Vertical Financial Statement Analysis with Explanatory Narrative.
General
formatting requirements:Please construct visually attractive and easily readable worksheets.
Use separate tabs for your horizontal and vertical analyses in a single Excel
worksheet. Examples will be demonstrated in class. Round your calculated
percentages to the nearest one tenth of one percent (e.g., 100.0%; 65.2%; 4.3%,
etc.).

1. Use Excelto prepare a horizontal and a vertical analysis of the following
selected income statement components: Net revenues, gross profit, SG&A
expenses, and Net Income. Give each analysis a descriptive title. The specific
terminology and classifications will vary somewhat across companies. Use the
three most recent years’ income statement data to construct two horizontal
income statement analyses and three vertical analyses.

2. From Item 7 in your
company’s 10-K, locate management’s discussion and analysis of the company’s
financial condition, results of operations, and year-to-year changes in
them.

A. What business segments does
management use to report the company’s financial condition and results and
operations?

B. What factors does management
cite as reasons for the changes, trends, and relationships in your horizontal
and vertical spreadsheets? Organize your analysis under four headings: Net
revenues; inventory and cost of sales; SG&A expenses;, and Net Income. Your
narrative should require approximately 3-4 pages. In your narrative, please
refer to the specific horizontal or vertical percentages you are explaining,
describe more than one factor for each income component, identify relevant
offsetting factors when applicable, and when possible quantify the impact of
those factors.

Note: If management reports
these results separately for each segment, some of the year-to-year percentage
changes they discuss will not line up with the horizontal and vertical
percentages you calculated for your company as a whole. If this occurs, please
note it in your write-up.

 

CLICK HERE TO ORDER A SIMILAR PAPER

We pride ourselves in writing quality essays

CLICK HERE TO CONTACT US

Lets Start Working

Plagiarism Free

We use anti-plagiarism software to ensure you get high-quality, unique papers. Besides, our writers have a zero plagiarism mentality

On Time Delivery

Your essay will be delivered strictly within the deadline.  If you have an urgent order, we can do it!

Money Back Guarantee

We offer warranty service, including free revisions, and a right to request a refund incase your expectations are not met!

THE BEST PAPER WRITER HELPER

Our Advantage

  • Say “NO” to plagiarism – FREE plagiarism report as an addition to your paper
  • The lowest prices that fit excellent quality
  • Authorship – you are the one who possesses the paper. We DO NOT re-sale or re-use any of them.

OUR PAPER WRITER HELPER GOODIES

Our Freebies

  • Free Cover Page
  • Free Revisions
  • Free Reference Page
  • Free 24/7 support

Pin It on Pinterest

Share This