Using the attached Spreadsheet:

$-$ Prepare a vertical analysis of the balance sheet and income statement for Cal's Carwash. Round percentages to $1$ decimal point.

$-$ Prepare a horizontal analysis of the balance sheet and income statement for Cal's Carwash. Round percentages to $1$ decimal point.

$-$ Compute the following following for $2023($round all percentages to two decimal places$).$

$-$Current Ratio

$-$Quick $($acid$-$test$)$ Ratio

$-$Average days to collect accounts receivable, assuming all sales are on account

$-$Inventory Turnover

$-$Book value per share of Common Stock

$-$Earnings per share on Common Stock

$-$Price$-$Earnings Ratio on Common Stock $($current Market Price is $$16)$

$-$Debt$-$to$-$Assets Ratio

$-$Return on Investments

$-$Return on Equity

$-$The ratio s are to also be included on the Excel spreadsheet that you have been given.$$ You will create a third tab for the ratios.$$ You will also calculate the ratios in Excel. So$,$ when I look at the Excel cell reference there will be a calculation there.$$ You will not work the ratio on paper and then just place the number in Excel.