Please help me fill in these charts. Riverside Sweets, a retail candy store chain, reported the following figures:

RIVERSIDE SWEETS

Additional financial information:

a$.75\%$ of net sales are on account.

b$.$ Market price of stock is $$36$ per share on June $30,2024$

c$.$ Annual dividend for $2024$ was $$1\mathrm{.}50$ per share.

d$.$ All short$-$term investments are cash equivalents.

Perform a horizontal analysis on the balance sheets for $2023$ and $2024.$

$($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.$)$

RIVERSIDE SWEETS

RIVERSIDE SWEETS Balance Sheet June $30,2023$ and $2024$ Increa ecrease$)20242023$ Amount Percentage Assets Current Assets: Cash $ $125,000$ $ $119,000$ Short$-$term Investments $685,000650,000$ Accounts Receivable $225,000198,000$ Merchandise Inventory $65,00070,000$ Other Current Assets $195,000191,000$ Total Current Assets $1,295,0001,228,000$ Property, Plant, and Equipment $875,000832,000$ Total Assets $ $2,170,000$ $ $2,060,000$ Liabilities Current Liabilities: Accounts Payable $ $265,000$ $ $251,750$ Accrued Liabilities $641,000725,523$ Total Current Liabilities $906,000977,273$ Long$-$term Liabilities Bonds Payable $250,000150,000$ Mortgage Payable $150,000175,000$ Total Long$-$term Liabilities $400,000325,000$ Total Liabilities $1,306,0001,302,273$ Stockholders' Equity Common Stock, $$1$ par, $225,000$ shares issued and outstanding $225,000225,000$ Paid$-$In Capital in Excess of Par $58,00058,000$ Retained Earnings $581,000474,727$ Total Stockholders' Equity $864,000757,727$ Total Liabilities and Stockholders' Equity $ $2,170,000$ $ $2,060,000$

HINTS

For cell references, begin the formula with an equals sign $(=),$ use the balance in this worksheet for your calculations, and press the enter key.

Perform a vertical analysis on the income statement.

$($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.$)$

HINTS

For cell references, begin the formula with an equals sign $(=),$ use the income statement in this worksheet for your calculations, and press the enter key.

Compute the following ratios. Do not round your calculations.

$($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.$)$

Working Capital

Current Ratio

Acid$-$Test $($Quick$)$ Ratio

Cash Ratio

Accounts Receivable Turnover

Days' Sales in Receivables

Inventory Turnover

Days' Sales in Inventory

Gross Profit Percentage

Debt Ratio

Debt to Equity Ratio

Times$-$Interest$-$Earned Ratio

Profit Margin Ratio

Rate of Return on Total Assets

Asset Turnover Ratio

Rate of Return on Common Stockholders' Equity

Earnings per Share $($EPS$)$

Price$/$Earnings Ratio

Dividend Yield

Dividend Payout

HINTS

Cell $|$ Hint:

C$5|$ Begin the formula with an equals sign $(=),$ use the balance in the horizontal analysis worksheet for your calculations, and press the enter key.

C$7|$ Use the function $=$SUM$()$ to calculate the numerator.

C$9|=(0\mathrm{.}75*\text{'}$Vertical Analysis'!C$8)/((\text{'}$Horizontal Analysis'!C$14+$'Horizontal Analysis'!D$14)/2)$

C$10|$ Assume $365$ days in a year and use the correct ratio in this worksheet for your calculations.