Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You use Microsoft Excel to prepare a standard ratio analysis table for all your clients. Your table includes all 17 ratios listed in the Wiley

image text in transcribed
image text in transcribed
You use Microsoft Excel to prepare a standard ratio analysis table for all your clients. Your table includes all 17 ratios listed in the Wiley textbook Chapter 5 Appendix 5A. Your table includes all ratios for the current and prior year to four decimal points. In summary, your standard ratio analysis table includes: 0 Column 1: it List the ratio number 1-17. 0 Column 2: Type Indicate the type of ratio - Liquidity, Activity, etc. 0 Column 3: Ratio Indicate the name of the ratio. 0 Column 5: 2011 Indicate the 2011 ratio. 0 Column 4: 2012 Indicate the 2012 ratio. 0 Column 6: Change Indicate the year-to-year change. 0 Column 7': Assessment Indicate Good, Bad, or N/A. You include an Assessment column with your assessment of each year-to-year change: 0 Good Year-to-year change makes the company seem to be a better investment. 0 Bad Year-to-year change makes the company seem to be a worse investment. 0 N/A Not applicable; no year-to-year change. In making this assessment, you consider what the year-to-year change indicates about the company's nancial improvement or deterioration m its value to a potential investor. You usually do not explain your assessment, although occasionally you do this in a memo if your client specically asks you to. You format and print two versions of this table to your clients: one version shows the ratios to four decimal points and a second version shows the formulas that you used to calculate the ratios. To generate the second version, in Excel, you go to the Formulas tab and click the Show Formulas button. Your intent in providing this version is to show your work so that your client could re-perform it if you gave them your Excel le; so, you can show either numbers or the Excel cell references in this version

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting

Authors: Charles T. Horngren, Gary L. Sundem, William O. Stratton, Phillip Beaulieu

6th Canadian edition

013257084X, 1846589207, 978-0132570848

More Books

Students also viewed these Accounting questions