CREATE A GOAL-SEEK ANALYSIS: MICROSOFT'S GOAL IF THEY WANTED TO MAKE 250 MILLION BY NEXT YEAR & MICROSOFT'S GOAL IF THEY WANTED TO BREAK EVEN (show the original vs revised & formulas used) (ITEM: MIRCOSOFT OFFICE)

BALANCE SHEETS \begin{tabular}{|c|c|c|c|c|} \hline June 30, & & 2022 & & 2021 \\ \hline \multicolumn{5}{|l|}{\begin{tabular}{l} Assets \\ Current assets: \end{tabular}} \\ \hline Cash and cash equivalents & \multirow[t]{2}{*}{$} & 13,931 & \multirow[t]{2}{*}{$} & 14,224 \\ \hline Short-term investments & & 90,826 & & 116,110 \\ \hline Total cash, cash equivalents, and short-term investments & & 104,757 & & 130,334 \\ \hline Accounts receivable, net of allowance for doubtful accounts of $633 and $751 & & 44,261 & & 38,043 \\ \hline Inventories & & 3,742 & & 2,636 \\ \hline Other current assets & & 16,924 & & 13,393 \\ \hline Total current assets & & 169,684 & & 184,406 \\ \hline Property and equipment, net of accumulated depreciation of $59,660 and $51,351 & & 74,398 & & 59,715 \\ \hline Operating lease right-of-use assets & & 13,148 & & 11,088 \\ \hline Equity investments & & 6,891 & & 5,984 \\ \hline Goodwill & & 67,524 & & 49,711 \\ \hline Intangible assets, net & & 11,298 & & 7,800 \\ \hline Other long-term assets & & 21,897 & & 15,075 \\ \hline Total assets & $ & 364,840 & $ & 333,779 \\ \hline \multicolumn{5}{|l|}{ Liabilities and stockholders' equity } \\ \hline \multicolumn{5}{|l|}{ Current liabilities: } \\ \hline Accounts payable & $ & 19,000 & $ & 15,163 \\ \hline Current portion of long-term debt & & 2,749 & & 8,072 \\ \hline Accrued compensation & & 10,661 & & 10,057 \\ \hline Short-term income taxes & & 4,067 & & 2,174 \\ \hline Short-term unearned revenue & & 45,538 & & 41,525 \\ \hline Other current liabilities & & 13,067 & & 11,666 \\ \hline Total current liabilities & & 95,082 & & 88,657 \\ \hline Long-term debt & & 47,032 & & 50,074 \\ \hline Long-term income taxes & & 26,069 & & 27,190 \\ \hline Long-term unearned revenue & & 2,870 & & 2,616 \\ \hline Deferred income taxes & & 230 & & 198 \\ \hline Operating lease liabilities & & 11,489 & & 9.629 \\ \hline Other long-term liabilities & & 15,526 & & 13,427 \\ \hline Total liabilities & & 198,298 & & 191,791 \\ \hline \multicolumn{5}{|l|}{ Commitments and contingencies } \\ \hline \multicolumn{5}{|l|}{ Stockholders' equity: } \\ \hline \multirow{2}{*}{\multicolumn{5}{|c|}{ Common stock and paid-in capital - shares authorized 24,000 ; outstanding 7,464}} \\ \hline & & & & 83,111 \\ \hline Retained earnings & & 84,281 & & 57,055 \\ \hline Accumulated other comprehensive income (loss) & & (4,678) & & 1,822 \\ \hline Total stockholders' equity & & 166,542 & & 141,988 \\ \hline Total liabilities and stockholders' equity & $ & 364,840 & $ & 333,779 \\ \hline \end{tabular} Refer to accompanying notes. ITEM 8. FINANCIAL STATEMENTS AND SUPPLEMENTARY DATA INCOME STATEMENTS Refer to accompanying notes