How to do horizontal analysis on excel

Grader - Instructions Accounting 2019 Project

Miller-Nobles (7e/13e) - Using Excel ChF15/ChF17 v1
Project Description:
Miller-Nobles (7e/13e) - Using Excel ChF15/ChM2 v1

Steps to Perform:
Step

Instructions

Points Possible

1

Download and open the excel spreadsheet, Miller-Nobles_7e-13e-Using_Excel_ChF15-ChM2_Start.xlsx. This spreadsheet includes 4 tabs; you will enter all answers on the second, the third, and the fourth tabs, Horizontal Analysis, Vertical Analysis, and Ratios. (All answers should be entered in the blue highlighted cells.)

0

2

Riverside Sweets, a retail candy store chain, reported the balance sheets for 2018 and 2019, and the income statement for 2019. Additional financial information: a. 75% of net sales are on account. b. Market price of stock is $36 per share on June 30, 2019. c. Annual dividend for 2019 was $1.50 per share. d. All short-term investments are cash equivalents. Perform a horizontal analysis on the balance sheet for 2018 and 2019. (40 pts) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.)

40

3

Perform a vertical analysis on the income statement. Use a minus sign or parentheses for any decreases. (9 pts) (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.)

9

4

Compute the following ratios. Do not round your calculations. (26 pts) a. Working Capital b. Current Ratio c. Acid-Test (Quick) Ratio d. Cash Ratio e. Accounts Receivable Turnover f. Days’ Sales in Receivables g. Inventory Turnover h. Days’ Sales in Inventory i. Gross Profit Percentage j. Debt Ratio k. Debt to Equity Ratio l. Times-Interest-Earned Ratio m. Profit Margin Ratio n. Rate of Return on Total Assets o. Asset Turnover Ratio p. Rate of Return on Common Stockholders’ Equity q. Earnings per Share (EPS) r. Price/Earnings Ratio s. Dividend Yield t. Dividend Payout (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab you will be marked wrong. All values should be added as positive numbers.)

26

5

Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto-graded excel activity window, and progress to Step 3. Follow on screen instructions. (To review score, navigate to Results in the MyLab and click on Review link.) Hint:

0

Total Points

75

Created On: 07/13/2020 1 Miller-Nobles (7e/13e) - Using Excel ChF15/ChF17 v1