Question

1 Approved Answer

Posted on Sep 28, 2024

Using the blank Excel template provided, prepare a horizontal income statement and balance sheet for Valero and PBF for the years 2018 - 2022. Autosave

Using the blank Excel template provided, prepare a horizontal income statement and balance sheet for Valero and PBF for the years 2018 - 2022.

Autosave C ... W: Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Q go Home Insert Draw Page Layout Formulas Data Review View Automate @ Tell me Conditional Format Formatting as Table cell Insert v Share (x) Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. J10 fx Valero Cash Flow Statement \begin{tabular}{l|l|l|l|l|l|l} PSB Cash Flow & Horizontal & Common Size & F S Analysis Worksheet & Valero Cash Flow \end{tabular} Ready i] qxa Accessibility: Investigate : Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A10 fx \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & & & & & & & & & & & w & \\ \hline & & & & & & & & & & & 2022 & \begin{tabular}{llll} 202020 & 2010 \end{tabular} & & & & & & & \\ \hline Solenency & & & & & & & & & & & & t & & & & & & & \\ \hline Werkine Capital & \begin{tabular}{l} Current Assets. \\ Sirstistios \end{tabular} & Near Term debt-paying ablith & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Current thabifies \\ Working Captal \end{tabular} & & s. & s. & & & s & s & s. & "s.. & s... & s. s. s s & s. & s. & s. & s. & s & s & \\ \hline Current Ratio & Current Assets/ & Near Term debt-paying ablity & & & & & & & & & & 1 & & & & & & & \\ \hline & \begin{tabular}{l} Currentl Lbblitis \\ Current \end{tabular} & & \#olvol & & "\#DIV01" & "Holvol" & "molvol & \#01V01 & \#olvol & "\#olvol" & "Holvol" " & & & \#0IV/01 & "Holvol & "molvol" & \#olvol & "solvol & "solvol \\ \hline Acidrest fatio & & Near Term debt-paying abitind & & & & & & & & & & & & & & & & & \\ \hline & & & "Holvol & " " Holvo1 & & [nolvol" & "Holvol & & & "Holvol" & "Holvol" & & tuolvoit & \#0IVIVI & "Holvol & " "molvol" & HOIV/I & "Solvol & "Holvol \\ \hline Inventon Turover & \begin{tabular}{l} Cost of Good Sold/ \\ \end{tabular} & & & & & & & & & & & 15 & & & & & & & \\ \hline & & & \#OIV/OI & " HOIVOI & "\#olvol" & Holvol: & " Holvol & \#01V/VI & \#OIVIVI & "\#olvol" & "\#OIVIVI" & & \#olivoil & \#0IVIVI & HOVIVI & "HOIVI". & \#olivol & "solvol & "solvol \\ \hline Days Sales sin Reciievable & & Liquidity of Recievable & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & " "olvol & " "Holvol" & "Holvol" & "Holvol & \#01V01 & \#0IV01 & " Holvol" & "Holvol" & & Eolvol & \#OIVIVI & Holvol & " HOLVOI" & Holvol & "Solvol & "Holvol \\ \hline Days Salesin Inventory & Average Inventor/ & Liquidry of Invention & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIV/OI & "\#DIVIV! & "\#0IV/0! " & "Holvol " & " Holvol & \#0IVIV! & \#0IV/VI & "\#OIV/OI" & "Holvol" & & =nolvol & \#0IVI01 & "Holvol & "molvol" & molvol & "Solvol & "Holvol \\ \hline asseryable Outsandin & & Liquility of Payables & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIV/OI & "\#0IV/O! & "\#0IV/0! " & "Holvol " & " molvol & & & "Holvol. & "Holvol. & & & & Holvol & "molvol" & \#DIVIVI & "solvol & "solvol \\ \hline Cass Conversion Cocle & & & & & & & & & - & & & & & E- & & & & & \\ \hline & \begin{tabular}{l} Days Salesin Payables= \\ Cash Conversion Vycle \end{tabular} & Casshmonagement & \begin{tabular}{l} molvol \\ Holvol \\ Holvol \end{tabular} & & & & & & E & \begin{tabular}{l} "nolvol: \\ Holvol \end{tabular} & \begin{tabular}{l} Holvol: \\ Holvol \end{tabular} & & & E & & & \begin{tabular}{l} molvol \\ molvol \\ Holvol \end{tabular} & & \\ \hline Debtto Equiry Ratio & Totalliablities/ & Creditorvs Equity Financing & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & "\#01VIVI & "\#OIVOI" & "Holvol: & " Holvol & \#OIVOII & & "Holvol" " & "Holvol" " & & & \#OIVOVI & Holvol & "HOIVI". & \#OIVOI & "solvol & "solvol \\ \hline Debt To Total Capitizatior & Totallibilitiss & Creditorvs Equitr financing & & s & s & s & s. & & & s & s & s & & & & & & & \\ \hline & & & & stivivi & & & & & & & & "tolvol "solvor "solvol & & & Holvol & "molvol" & \#olvol & "solvol & "solvol \\ \hline Times Interest Earned & (Net Income + Interess Expense + Income Taxes)/ & Interest Paving abliny & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & & "\#OIVI01" & "Holvol" & " Holvol & \#01V01 & \#01V01 & "Holvol" & "Holvol" & & & \#0IV01 & Holvol & "molvol" & \#olvol & "Solvol & "Solvol \\ \hline Pefformance & & & & & & & & & & & & & & & & & & & \\ \hline Asset Tumover & Net sales/I & TotalAsset Effeciency & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIVIVI & "\#0IVIV! & "\#0IV/0!" & "Holvol: & "Holvol & \#0IVIVI & \#OIVIV! & " \#OIVIVI" & "Holvol" & & \#olivol & \#0IV/O! & Holvol & "molvol" & \#DIVIVI & "solvol & "solvol \\ \hline Return on Sales(1) & Net Income + Net of Tax Interest Expensel & Proffitablity ofs & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & & "\#OIVI01" & "Holvol" & " Holvol & \#01V01 & \#01V01 & "Holvol" & "Holvol" & & Aolvol & \#olvol & "nolvol & " Holvol" & \#DIV/OI & "solvol & "Holvol \\ \hline Returnon assest(1) & Net Income + Net of Tax Interest Expensel & Profitablityof Afsests & & & & & & & & & 1 & 1 & & & & & & & \\ \hline & & & Holvol & " \#olvol & "\#OIVOI" & "Holvol: & "Holvol & \#0IVOI & \#olvol & "\#OIVIVI" & "Holvol" " & & & \#OIVOI & Holvol & "Holvol" & \#OIVIVI & "solvol & "Holvol \\ \hline Returnon Equity & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Equity & & \#OIV/O! & "\#DIVOI & "\#0IV/0! " & [Holvol. & " nolvo: & \#0IVIV! & \#0IVIVI & " \#OIVOI" " & "Holvol" & & Folvol & \#0IV/0! & Holvol & " "Dolvol" & molvol & "Solvol & "Holvol \\ \hline Average Interest Rate & & Interest Rate Paid on Debt & & & & & & & & & & & & & & & & & \\ \hline 11 & Horizontal & FS A & alysis & Worl & ksheet & & & lero C & iash 1 & & & SB Cash Flow & & + & & & & & \\ \hline \end{tabular} Ready if x2 Accessibility: Investigate -C +40% : Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Automate @ Tell me Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A10 fx \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{VevturquilymatioA} & & & \multirow[t]{2}{*}{ D } & \multirow[t]{2}{*}{E} & \multirow[t]{2}{*}{F} & \multirow[t]{2}{*}{ G } & \multirow[t]{2}{*}{H} & 1 & \multirow[t]{2}{*}{1} & \multirow[t]{2}{*}{ k } & \multirow[t]{2}{*}{L} & \multirow[t]{2}{*}{ m } & \multirow[t]{2}{*}{N} & \multirow[t]{2}{*}{0} & \multirow[t]{2}{*}{p} & \multirow[t]{2}{*}{a} & \multirow[t]{2}{*}{R} & s & T & u & v & w & x \\ \hline & Total Stockholders Equity & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Debt To Equity Ratio & & \#DIV/0! & " \#DIV/0! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Debt To Total Capitizatior & \begin{tabular}{l} Total Liabilities/ \\ TotalLiabilities +Total Equity \end{tabular} & Creditor vs Equity Financing & \begin{tabular}{ll} $ & : \\ $ \end{tabular}: & $ & \begin{tabular}{l} $ \\ $ \end{tabular} & \begin{tabular}{l} $ \\ $ \end{tabular} & $ & & & & $ s: & \begin{tabular}{l} s: \\ s: \end{tabular} & $ & \begin{tabular}{l} $ \\ $ \end{tabular} & \begin{tabular}{l} $ \\ $ \\ $ \end{tabular} & & & & & & & & \\ \hline & Debt tocapt & & \#DIV/0! & \#DIV/o! & \#DIV/0! & r \#DIV/0! & "\#DIV/0! & & & & "\#DIV/0! & #DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & & & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Times Interest Earned & (Net Income + Interest Expense + Income Taxes)/ & Interest Paying Ability & & & & & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Interest Expenses \\ Times Interest Earned \end{tabular} & & \#DIV/0! & " \#DIV/0! & [DDIV/0! & [ \#DIV/0! & " \#DIV/0! & \#DIV/0! & \#DIV/0! & & [ \#DIV/0! & [ \#DIV/0! & [DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & [\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Rerformance & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Asset Turnover & Net Sales/ & Total Asset Effeciency & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Total Assets & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Asset Turnover & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/o! & \#DIV/0! & \#DIV/0! & & " \#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Return on Sales(1) & Net Income + Net of Tax Interest Expense/ & Profitability of Sales Given Ass & & & & & & & & & & & & & & & & & & & & & \\ \hline & Sales & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Sales & & \#DIV/o! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/o! & \#DIV/0! & \#DIV/o! & & [\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & [\#DIV/0! & \#DIV/0! & \#DIV/0! & "\#DIV/o! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Return on Assets (1) & Net Income + Net of Tax Interest Expense/ & Profitability of Assets & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average TotalAssets & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Assets & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Return on Equity & Net Income/ & Profitability of Equity & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Stockholders Equity & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Equity & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & \#DIV/0! \\ \hline Average Interest Rate & Interest Expense/ & Interest Rate Paid on Debt & & -5 & & & & - & - & & & - & & & & & & & & & & & \\ \hline & Average Total Liabilities & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Interest Rate & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/o! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Earning Per Share & Net Income/ & Income per Share & & & & & & & & & & & & & & & & & & & & & \\ \hline Earning Per Share & Average Number of Common Shares Outstanding & Income per Share & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earning Per Share & & #DIV/0! & " \#DIV/o! & "\#DIV/0! & " \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & \#DIV/0! \\ \hline Price Earnings Ratio & Market Price Per Share / & Market Value Multiple of Earn & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earnings Per Share & & & & & & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Price Earnings Ratio \\ \end{tabular} & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/o! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Dividend Yield & Cash Dividends Per Common Share/ & & & & & & & & & & & & & & & & & & & & & & \\ \hline Dowidendrield & \begin{tabular}{l} Cash Dividends Per Common Share/ \\ Market Price Per Common Share \end{tabular} & Dividend Return on Market Pr & & & & & & & & & & & & & & & & & & & & & \\ \hline & Dividend Yield & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/o! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Dividend Payout & Cash Dividends per common share/ & Earnings Payout \% & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earnings Per Common Share & & & & & i. & & 4= & 3 & & Fine & & & = & & & & & & & & & \\ \hline & Dividend Payout & & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & \#DIV/o! & \#DIV/0! & \#DIV/0! & "\#DIV/0! & [\#IIV/0! & \#DIV/0! & & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! \\ \hline \end{tabular} 3 Input cellfor data Autosave C ... W: Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Q go Home Insert Draw Page Layout Formulas Data Review View Automate @ Tell me Conditional Format Formatting as Table cell Insert v Share (x) Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. J10 fx Valero Cash Flow Statement \begin{tabular}{l|l|l|l|l|l|l} PSB Cash Flow & Horizontal & Common Size & F S Analysis Worksheet & Valero Cash Flow \end{tabular} Ready i] qxa Accessibility: Investigate : Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A10 fx \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & & & & & & & & & & & w & \\ \hline & & & & & & & & & & & 2022 & \begin{tabular}{llll} 202020 & 2010 \end{tabular} & & & & & & & \\ \hline Solenency & & & & & & & & & & & & t & & & & & & & \\ \hline Werkine Capital & \begin{tabular}{l} Current Assets. \\ Sirstistios \end{tabular} & Near Term debt-paying ablith & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Current thabifies \\ Working Captal \end{tabular} & & s. & s. & & & s & s & s. & "s.. & s... & s. s. s s & s. & s. & s. & s. & s & s & \\ \hline Current Ratio & Current Assets/ & Near Term debt-paying ablity & & & & & & & & & & 1 & & & & & & & \\ \hline & \begin{tabular}{l} Currentl Lbblitis \\ Current \end{tabular} & & \#olvol & & "\#DIV01" & "Holvol" & "molvol & \#01V01 & \#olvol & "\#olvol" & "Holvol" " & & & \#0IV/01 & "Holvol & "molvol" & \#olvol & "solvol & "solvol \\ \hline Acidrest fatio & & Near Term debt-paying abitind & & & & & & & & & & & & & & & & & \\ \hline & & & "Holvol & " " Holvo1 & & [nolvol" & "Holvol & & & "Holvol" & "Holvol" & & tuolvoit & \#0IVIVI & "Holvol & " "molvol" & HOIV/I & "Solvol & "Holvol \\ \hline Inventon Turover & \begin{tabular}{l} Cost of Good Sold/ \\ \end{tabular} & & & & & & & & & & & 15 & & & & & & & \\ \hline & & & \#OIV/OI & " HOIVOI & "\#olvol" & Holvol: & " Holvol & \#01V/VI & \#OIVIVI & "\#olvol" & "\#OIVIVI" & & \#olivoil & \#0IVIVI & HOVIVI & "HOIVI". & \#olivol & "solvol & "solvol \\ \hline Days Sales sin Reciievable & & Liquidity of Recievable & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & " "olvol & " "Holvol" & "Holvol" & "Holvol & \#01V01 & \#0IV01 & " Holvol" & "Holvol" & & Eolvol & \#OIVIVI & Holvol & " HOLVOI" & Holvol & "Solvol & "Holvol \\ \hline Days Salesin Inventory & Average Inventor/ & Liquidry of Invention & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIV/OI & "\#DIVIV! & "\#0IV/0! " & "Holvol " & " Holvol & \#0IVIV! & \#0IV/VI & "\#OIV/OI" & "Holvol" & & =nolvol & \#0IVI01 & "Holvol & "molvol" & molvol & "Solvol & "Holvol \\ \hline asseryable Outsandin & & Liquility of Payables & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIV/OI & "\#0IV/O! & "\#0IV/0! " & "Holvol " & " molvol & & & "Holvol. & "Holvol. & & & & Holvol & "molvol" & \#DIVIVI & "solvol & "solvol \\ \hline Cass Conversion Cocle & & & & & & & & & - & & & & & E- & & & & & \\ \hline & \begin{tabular}{l} Days Salesin Payables= \\ Cash Conversion Vycle \end{tabular} & Casshmonagement & \begin{tabular}{l} molvol \\ Holvol \\ Holvol \end{tabular} & & & & & & E & \begin{tabular}{l} "nolvol: \\ Holvol \end{tabular} & \begin{tabular}{l} Holvol: \\ Holvol \end{tabular} & & & E & & & \begin{tabular}{l} molvol \\ molvol \\ Holvol \end{tabular} & & \\ \hline Debtto Equiry Ratio & Totalliablities/ & Creditorvs Equity Financing & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & "\#01VIVI & "\#OIVOI" & "Holvol: & " Holvol & \#OIVOII & & "Holvol" " & "Holvol" " & & & \#OIVOVI & Holvol & "HOIVI". & \#OIVOI & "solvol & "solvol \\ \hline Debt To Total Capitizatior & Totallibilitiss & Creditorvs Equitr financing & & s & s & s & s. & & & s & s & s & & & & & & & \\ \hline & & & & stivivi & & & & & & & & "tolvol "solvor "solvol & & & Holvol & "molvol" & \#olvol & "solvol & "solvol \\ \hline Times Interest Earned & (Net Income + Interess Expense + Income Taxes)/ & Interest Paving abliny & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & & "\#OIVI01" & "Holvol" & " Holvol & \#01V01 & \#01V01 & "Holvol" & "Holvol" & & & \#0IV01 & Holvol & "molvol" & \#olvol & "Solvol & "Solvol \\ \hline Pefformance & & & & & & & & & & & & & & & & & & & \\ \hline Asset Tumover & Net sales/I & TotalAsset Effeciency & & & & & & & & & & & & & & & & & \\ \hline & & & \#OIVIVI & "\#0IVIV! & "\#0IV/0!" & "Holvol: & "Holvol & \#0IVIVI & \#OIVIV! & " \#OIVIVI" & "Holvol" & & \#olivol & \#0IV/O! & Holvol & "molvol" & \#DIVIVI & "solvol & "solvol \\ \hline Return on Sales(1) & Net Income + Net of Tax Interest Expensel & Proffitablity ofs & & & & & & & & & & & & & & & & & \\ \hline & & & Holvol & & "\#OIVI01" & "Holvol" & " Holvol & \#01V01 & \#01V01 & "Holvol" & "Holvol" & & Aolvol & \#olvol & "nolvol & " Holvol" & \#DIV/OI & "solvol & "Holvol \\ \hline Returnon assest(1) & Net Income + Net of Tax Interest Expensel & Profitablityof Afsests & & & & & & & & & 1 & 1 & & & & & & & \\ \hline & & & Holvol & " \#olvol & "\#OIVOI" & "Holvol: & "Holvol & \#0IVOI & \#olvol & "\#OIVIVI" & "Holvol" " & & & \#OIVOI & Holvol & "Holvol" & \#OIVIVI & "solvol & "Holvol \\ \hline Returnon Equity & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Equity & & \#OIV/O! & "\#DIVOI & "\#0IV/0! " & [Holvol. & " nolvo: & \#0IVIV! & \#0IVIVI & " \#OIVOI" " & "Holvol" & & Folvol & \#0IV/0! & Holvol & " "Dolvol" & molvol & "Solvol & "Holvol \\ \hline Average Interest Rate & & Interest Rate Paid on Debt & & & & & & & & & & & & & & & & & \\ \hline 11 & Horizontal & FS A & alysis & Worl & ksheet & & & lero C & iash 1 & & & SB Cash Flow & & + & & & & & \\ \hline \end{tabular} Ready if x2 Accessibility: Investigate -C +40% : Special Project Excel Template Without Rubric Oct 23 2023-2 - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Automate @ Tell me Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. A10 fx \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{3}{*}{VevturquilymatioA} & & & \multirow[t]{2}{*}{ D } & \multirow[t]{2}{*}{E} & \multirow[t]{2}{*}{F} & \multirow[t]{2}{*}{ G } & \multirow[t]{2}{*}{H} & 1 & \multirow[t]{2}{*}{1} & \multirow[t]{2}{*}{ k } & \multirow[t]{2}{*}{L} & \multirow[t]{2}{*}{ m } & \multirow[t]{2}{*}{N} & \multirow[t]{2}{*}{0} & \multirow[t]{2}{*}{p} & \multirow[t]{2}{*}{a} & \multirow[t]{2}{*}{R} & s & T & u & v & w & x \\ \hline & Total Stockholders Equity & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Debt To Equity Ratio & & \#DIV/0! & " \#DIV/0! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Debt To Total Capitizatior & \begin{tabular}{l} Total Liabilities/ \\ TotalLiabilities +Total Equity \end{tabular} & Creditor vs Equity Financing & \begin{tabular}{ll} $ & : \\ $ \end{tabular}: & $ & \begin{tabular}{l} $ \\ $ \end{tabular} & \begin{tabular}{l} $ \\ $ \end{tabular} & $ & & & & $ s: & \begin{tabular}{l} s: \\ s: \end{tabular} & $ & \begin{tabular}{l} $ \\ $ \end{tabular} & \begin{tabular}{l} $ \\ $ \\ $ \end{tabular} & & & & & & & & \\ \hline & Debt tocapt & & \#DIV/0! & \#DIV/o! & \#DIV/0! & r \#DIV/0! & "\#DIV/0! & & & & "\#DIV/0! & #DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & & & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Times Interest Earned & (Net Income + Interest Expense + Income Taxes)/ & Interest Paying Ability & & & & & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Interest Expenses \\ Times Interest Earned \end{tabular} & & \#DIV/0! & " \#DIV/0! & [DDIV/0! & [ \#DIV/0! & " \#DIV/0! & \#DIV/0! & \#DIV/0! & & [ \#DIV/0! & [ \#DIV/0! & [DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & [\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Rerformance & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Asset Turnover & Net Sales/ & Total Asset Effeciency & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Total Assets & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Asset Turnover & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/o! & \#DIV/0! & \#DIV/0! & & " \#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Return on Sales(1) & Net Income + Net of Tax Interest Expense/ & Profitability of Sales Given Ass & & & & & & & & & & & & & & & & & & & & & \\ \hline & Sales & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Sales & & \#DIV/o! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/o! & \#DIV/0! & \#DIV/o! & & [\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & [\#DIV/0! & \#DIV/0! & \#DIV/0! & "\#DIV/o! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Return on Assets (1) & Net Income + Net of Tax Interest Expense/ & Profitability of Assets & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average TotalAssets & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Assets & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Return on Equity & Net Income/ & Profitability of Equity & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Stockholders Equity & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Return on Equity & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & \#DIV/0! \\ \hline Average Interest Rate & Interest Expense/ & Interest Rate Paid on Debt & & -5 & & & & - & - & & & - & & & & & & & & & & & \\ \hline & Average Total Liabilities & & & & & & & & & & & & & & & & & & & & & & \\ \hline & Average Interest Rate & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & " \#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/o! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Earning Per Share & Net Income/ & Income per Share & & & & & & & & & & & & & & & & & & & & & \\ \hline Earning Per Share & Average Number of Common Shares Outstanding & Income per Share & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earning Per Share & & #DIV/0! & " \#DIV/o! & "\#DIV/0! & " \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & \#DIV/0! \\ \hline Price Earnings Ratio & Market Price Per Share / & Market Value Multiple of Earn & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earnings Per Share & & & & & & & & & & & & & & & & & & & & & & \\ \hline & \begin{tabular}{l} Price Earnings Ratio \\ \end{tabular} & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/o! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline Dividend Yield & Cash Dividends Per Common Share/ & & & & & & & & & & & & & & & & & & & & & & \\ \hline Dowidendrield & \begin{tabular}{l} Cash Dividends Per Common Share/ \\ Market Price Per Common Share \end{tabular} & Dividend Return on Market Pr & & & & & & & & & & & & & & & & & & & & & \\ \hline & Dividend Yield & & \#DIV/0! & " \#DIV/o! & "\#DIV/0! & [ \#DIV/0! & "\#DIV/0! & \#DIV/0! & \#DIV/o! & & "\#DIV/0! & [\#DIV/0! & "\#DIV/0! & "\#DIV/0! & "\#DIV/0! & \#DIV/o! & \#DIV/0! & & "\#DIV/0! & "\#DIV/0! & \#DIV/0! & "\#DIV/0! & "\#DIV/0! \\ \hline & & & & & & & & & & & & & & & & & & & & & & & \\ \hline Dividend Payout & Cash Dividends per common share/ & Earnings Payout \% & & & & & & & & & & & & & & & & & & & & & \\ \hline & Earnings Per Common Share & & & & & i. & & 4= & 3 & & Fine & & & = & & & & & & & & & \\ \hline & Dividend Payout & & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & & \#DIV/0! & \#DIV/o! & \#DIV/0! & \#DIV/0! & "\#DIV/0! & [\#IIV/0! & \#DIV/0! & & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! & \#DIV/0! \\ \hline \end{tabular} 3 Input cellfor data