Wilne Execl to Perfoem Horizontal and Vertical Analyhit PhostrM Comparalive data fram the statement of financlal positien of Whyr Lte. are shown below: \begin{tabular}{|c|c|c|c|} \hline & 2004 & 2023 & 2022 \\ \hline Gipront anserts & $1,590,000 & $1,175,000 & $1,275,000 \\ \hline \multicolumn{4}{|c|}{ Property, plant and } \\ \hline vquipment & 3,130,000 & 2800,000 & 2,850,000 \\ \hline Goodwill & 90000 & 100,000 & 0 \\ \hline Total arsets & 34.750,000 & $4,075,000 & 34,075,000 \\ \hline \end{tabular} Student Work Area Required; Provide ingut into cells shaded in vellow in this ternplate, Use mathematical formulas with cell references to the Problem area and work ares is indicated. a. Using herioontal analyak, calcuiste the percentage of the base-year amount, utine 2022 as the bese pear. Corrent asses: Preperty, plant and equipment Toent assets b. Ushe vertical analrits, calculate the peccentage cl the Hane amount for eachveor. Current assets Foperty, plant and egip. Goodnill Total assels 2024 Percentace; $1,530,000 3,130,000 90000 34,250,000 tiner Anawer (1)