Download an Excel template for this problem online in MyAccountingLab or at http://www.pearsonhighered.com/Horngren. Riverside Sweets, a retail candy store chain, reported the following figures:Additional financial information:
a. 75% of net sales revenue 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.
Requirements
1. Perform a horizontal analysis on the balance sheet for 2018 and 2019.
2. Perform a vertical analysis on the income statement.
3. Compute the following ratios:
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