3 charts in excel for ratio analysis accounting charting results you


For horizontal analysis, create a two-dimensional line chart over three years and for the vertical analysis, create one bar chart over three years for each of the following balance sheet categories: current assets, long-term assets, current liabilities, long-term liabilities, and cash flows from/used by operating, investing and financing activities. For income statement items, group the different streams of revenue, and group the different categories of operating expenses. For cash flow items, separate cash flows from operating, investing and financing activities. Do not try to chart each line item within the operating, investing and financing activities (that level of analysis is outside the scope of this exercise).


For ratio analysis, group ratios by liquidity, solvency and profitability ratios and create two dimensional line charts over two or three years for each category, depending on whether the ratio you created covers a two or three year period. Whatever you present, it has to be readable and clear to other users of the information that you produce. Placing more than three or four ratios on one chart over at least three years starts to look a little busy. Make sure you space them adequately for easy reading. If your ratios are too busy looking, your group mates should let you know so you can redo them before submission. Visually, there is a difference between the charts you create for vertical, horizontal and ratio analysis. The vertical analysis will produce a chart for each year for each group of items analyzed, as opposed to the horizontal and ratio analysis which will produce one chart for all the years for each group of items analyzed. 

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more