equired:

ompute the annual dollar changes and percent changes for each of the following items. Round ercent change to $1$ decimal place.

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

$\backslash$hline & Current Year & Prior Year & Dollar Change & Percent Change & & $\backslash \backslash$

$\backslash$hline ash & $\backslash$$$7,440$ & $\backslash$$$8,000$ & $(\backslash$$$560)$ & $=$ROUND $(0\mathrm{.}07,1)$ & & $\backslash \backslash$

$\backslash$hline ccounts receivable & $54,000$ & $18,000$ & $36,000$ & V $200\mathrm{.}0\backslash \%$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{\backslash$multirow$[$t$]\{3\}\{*\}\{$Formula must include the ROUND function, and round to $1$ decimal place.$\}\}\backslash \backslash$

$\backslash$hline quipment, net & $44,000$ & $40,000$ & $4,000$ & $\backslash ($ r $\backslash$quad $10\mathrm{.}0\backslash \%\backslash )$ & & $\backslash \backslash$

$\backslash$hline and & $91,680$ & $66,000$ & $25,680$ & V $40\mathrm{.}0\backslash \%$ & & $\backslash \backslash$

$\backslash$hline tal assets & $\backslash$$$197,120$ & $\backslash$$$132,000$ & $\backslash$$$65,120$ & V $260\mathrm{.}0\backslash \%$ & & $\backslash \backslash$

$\backslash$hline

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

udents: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work. othing in this area will be graded, but it will be submitted with your assignment.

Required:

Express the items in common$-$size percents. Round to $3$ decimal places.

I do not know what excel formulas to use! please help