I need help formatting the ratios for an analysis. I think I have calculated them correctly.

Instructions for the project:

Instructions

$*$ Choose any publicly traded company of your choice

$*$ Locate the company$$s latest published annual report

$*$ Review the balance sheet, income statement, and statement of cash flows

$*$ Calculate a minimum of $7$ ratios from the ratios studied during the course

$*$ Complete an analysis of the financial condition of the company based on the ratio analysis and additional information found in the annual report

$*$ Your final report should consist of the following:

o Overview of the company and its industry

o Product$($s$)/($s$)$ervices offered

o History of the stock price

o Results of the financial ratio analysis

o Key financial highlights and lowlights found in the annual report

o Key points from the CEO$$s letter to shareholder$$s in the annual report

o Recommendations to the company on how to improve its financial performance for the future.

o Provides the decision on whether to invest or not in this company with supporting information based on the financial analysis completed.

$*$ Length of assignment $-$ The final project should be $5$ to $7$ pages, not including the financial statements and the ratio analysis, which should be placed in the Appendix. The assignments should be submitted in a Word document with spreadsheets embedded in the Word document, as needed.

o A cover page is also required, but not part of the $5$ to $7$ pages of content. A properly formatted reference page and corresponding in$-$text citations are also required.

$*$ You should use APA formatting

$*$ A minimum of five scholarly citations are required

$*$ Acceptable sources include scholarly articles published within the last five years and your textbook.

What I calculated for the ratios.

current ratio$(171530)/(81814)=2\mathrm{.}0966$ total current asset$($s$)/($t$)$otal current liabilities

quick ratio $($cash $+$ marketable securities $+$ accounts receivable$)()/()$ current liabilities$=(24048+86868+47964)/(81814)=1\mathrm{.}942$

debt$-$to$-$equity ratio total liabilitie$($s$)/($t$)$otal shareholders$$ equity$=\mathrm{.}41998=(119013)/(283379)$

return on assets net incom$($e$)/($ t$)$otal assets$=(73795)/(402392)=\mathrm{.}1834$

return on equity net incom$($e$)/($ s$)$hareholders$$ equity$=(73795)/(283379)=\mathrm{.}2604$

free cash flow net cash provided by operating activities $-$ purchases of property and equipment $101746-32251=69495$

dividend yield didn$$t pay dividends until $2024$ page $24$ of annual report. Part I

Part II

Part III

Part IV

Alphabet Inc.

Consolidated Statements of Income

Year Ended December $31,$

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

$\backslash$hline $\backslash$multirow$[$b$]\{2\}\{*\}\{($in millions, except per share amounts$)\}$ & $\backslash$multicolumn$\{6\}\{|$c$|\}\{$Year Ended December $31.\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{3\}\{|$c$|\}\{2021\}$ & $\backslash$multicolumn$\{2\}\{|$l$|\}\{2022\}$ & $2023\backslash \backslash$

$\backslash$hline Revenues & $\backslash$$ & $257,637$ & $\backslash$$ & $282,836$ & $\backslash (\backslash$$ $\backslash )$ & $307,394\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Costs and expenses:$\}\backslash \backslash$

$\backslash$hline Cost of revenues & & $110,939$ & & $126,203$ & & $133,332\backslash \backslash$

$\backslash$hline Research and development & & $31,562$ & & $39,500$ & & $45,427\backslash \backslash$

$\backslash$hline Sales and marketing & & $22,912$ & & $26,567$ & & $27,917\backslash \backslash$

$\backslash$hline General and administrative & & $13,510$ & & $15,724$ & & $16,425\backslash \backslash$

$\backslash$hline Total costs and expenses & & $178,923$ & & $207,994$ & & $223,101\backslash \backslash$

$\backslash$hline Income from operations & & $78,714$ & & $74,842$ & & $84,293\backslash \backslash$

$\backslash$hline Other income $($expense$),$ net & & $12,020$ & & $\backslash ((3,514)\backslash )$ & & $1,424\backslash \backslash$

$\backslash$hline Income before income taxes & & $90,734$ & & $71,328$ & & $85,717\backslash \backslash$

$\backslash$hline Provision for income taxes & & $14,701$ & & $11,356$ & & $11,922\backslash \backslash$

$\backslash$hline Net income & $\backslash$$ & $76,033$ & $\backslash (\backslash$$ $\backslash )$ & $59,972$ & $\backslash (\backslash$$ $\backslash )$ & $73,795\backslash \backslash$

$\backslash$hline Basic net income per share of Class A$,$ Class B$,$ and Class C stock & $\backslash (\backslash$$ $\backslash )$ & $5\mathrm{.}69$ & $\backslash (\backslash$$ $\backslash )$ & $4\mathrm{.}59$ & $\backslash (\backslash$$ $\backslash )$ & $5\mathrm{.}84\backslash \backslash$

$\backslash$hline Diluted net income per share of Class A$,$ Class B$,$ and Class C stock & $\backslash (\backslash$$ $\backslash )$ & $5\mathrm{.}61$ & $\backslash (\backslash$$ $\backslash )$ & $4\mathrm{.}56$ & $\backslash$$ & $5\mathrm{.}80\backslash \backslash$

$\backslash$hline

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

See accompanying notes.

So

Alphabet $2023$ Annual Report Part I

Part II

Part III

Part IV

Alphabet Inc.

Consolidated Statements of Comprehensive Income

Year Ended December $31,$

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

$\backslash$hline $\backslash$multirow$[$b$]\{2\}\{*\}\{($in millions$)\}$ & $\backslash$multicolumn$\{6\}\{|$l$|\}\{\}\backslash \backslash$

$\backslash$hline & $\backslash$multicolumn$\{2\}\{|$r$|\}\{2021\}$ & & $2022$ & & $2023\backslash \backslash$

$\backslash$hline Net income & $\backslash$$ & $76,033$ & $\backslash$$ & $59,972$ & $\backslash$$ & $73,795\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Other comprehensive income $($loss$)$:$\}\backslash \backslash$

$\backslash$hline Change in foreign currency translation adjustment & & $\backslash ((1,442)\backslash )$ & & $\backslash ((1,836)\backslash )$ & & $735\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Available$-$for$-$sale investments:$\}\backslash \backslash$

$\backslash$hline Change in net unrealized gains $($losses$)$ & & $\backslash ((1,312)\backslash )$ & & $\backslash ((4,720)\backslash )$ & & $1,344\backslash \backslash$

$\backslash$hline Less: reclassification adjustment for net $($gains$)$ losses included in net income & & $(64)$ & & $1,007$ & & $1,168\backslash \backslash$

$\backslash$hline Net change, net of income tax benefit $($expense$)$ of $\backslash (\backslash$$ $394,\backslash$$ $1,056\backslash ),$ and $\backslash (\backslash$$$(698)\backslash )$ & & $\backslash ((1,376)\backslash )$ & & $\backslash ((3,713)\backslash )$ & & $2,512\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{7\}\{|$l$|\}\{$Cash flow hedges:$\}\backslash \backslash$

$\backslash$hline Change in net unrealized gains $($losses$)$ & & $716$ & & $1,275$ & & $168\backslash \backslash$

$\backslash$hline Less: reclassification adjustment for net $($gains$)$ losses included in net income & & $(154)$ & & $\backslash ((1,706)\backslash )$ & & $\backslash ((214)\backslash )\backslash \backslash$

$\backslash$hline Net change, net of income tax benefit $($expense$)$ of $\backslash$$$(122),\backslash$$$110,$ and $\backslash (\backslash$$ $2\backslash )$ & & $562$ & & $(431)$ & & $\backslash ((46)\backslash )\backslash \backslash$

$\backslash$hline Other comprehensive income $($loss$)$ & & $\backslash ((2,256)\backslash )$ & & $\backslash ((5,980)\backslash )$ & & $3,201\backslash \backslash$

$\backslash$hline Comprehensive income & $\backslash (\backslash$$ $\backslash )$ & $73,777$ & $\backslash$$ & $53,992$ & $\backslash$$ & $76,996\backslash \backslash$

$\backslash$hline

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

See accompanying notes.

Alphabet $2023$ Annual Report

$51$