ancialStatement Analysis

ng Excelfor financial analysis

erside Sweets, a retail candy store chain, reported the following figures:

$\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$RIVERSIDE SWEETS$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Balance Sheet$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$June $30,2023$ and $2024\}\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline & & $2024$ & & $2023\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Assets$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Current Assets:$\}\backslash \backslash$

$\backslash$hline Cash & $\backslash$$ & $125,000$ & $\backslash$$ & $119,000\backslash \backslash$

$\backslash$hline Short$-$term Investments & & $685,000$ & & $650,000\backslash \backslash$

$\backslash$hline Accounts Receivable & & $225,000$ & & $198,000\backslash \backslash$

$\backslash$hline Merchandise Inventory & & $65,000$ & & $70,000\backslash \backslash$

$\backslash$hline Other Current Assets & & $195,000$ & & $191,000\backslash \backslash$

$\backslash$hline Total Current Assets & & $1,295,000$ & & $1,228,000\backslash \backslash$

$\backslash$hline Property, Plant, and Equipment & & $875,000$ & & $832,000\backslash \backslash$

$\backslash$hline Total Assets & $\backslash$$ & $2,170,000$ & $\backslash$$ & $2,060,000\backslash \backslash$

$\backslash$hline & & & & $\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Liabilities$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Current Liabilities:$\}\backslash \backslash$

$\backslash$hline Accounts Payable & $\backslash$$ & $265,000$ & $\backslash$$ & $251,750\backslash \backslash$

$\backslash$hline Accrued Liabilities & & $641,000$ & & $725,523\backslash \backslash$

$\backslash$hline Total Current Liabilities & & $906,000$ & & $977,273\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Long$-$term Liabilities$\}\backslash \backslash$

$\backslash$hline Bonds Payable & & $250,000$ & & $150,000\backslash \backslash$

$\backslash$hline Mortgage Payable & & $150,000$ & & $175,000\backslash \backslash$

$\backslash$hline TotalLong$-$term Liabilities & & $400,000$ & & $325,000\backslash \backslash$

$\backslash$hline Total Liabililies & & $1,306,000$ & & $1,302,273\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{5\}\{|$l$|\}\{$Stockholders$\text{'}$ Equity$\}\backslash \backslash$

$\backslash$hline Common Stock,$\backslash$$$1$ par, $225,000$ shares issued and outstanding & & $225,000$ & & $225,000\backslash \backslash$

$\backslash$hline Paid$-$In Capital in Excess of Par & & $58,000$ & & $58,000\backslash \backslash$

$\backslash$hline Retained Earnings & & $581,000$ & & $474,727\backslash \backslash$

$\backslash$hline TotalStockholders' Equity & & $864,000$ & & $757,727\backslash \backslash$

$\backslash$hline Total Liabilities and Stockholders' Equity & $\backslash$$ & $2,170,000$ & $\backslash$$ & $2,060,000\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$

ditional financial information:

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

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

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

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

$-$ the blue shaded areas on the ENTERANSWERS tab for inputs.

WAYS use cell references and formulas where appropriate to receive full credit. If you copy$/$paste from the Instructions tab you will marked wrong. Allvalues should be added as positive numbers. 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.$)$ 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

$1.$ 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 follow ng 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.$)$

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.