Using the Following Information from an Annual Report, Prepare a Vertical

Using the following information from an annual report, prepare a vertical analysis of the consolidated balance sheet at June 30, 20xx. (Round percentage answers to one decimal place.)
$\begin{array}{c}\begin{array}{lll}\\\\\text {Cash and cash equivalents}\\\text {Accounts and other receivables}\\\text {Merchandise inventories}\\\text {Prepaid expenses and other current assets}\\ \text {Total current assets}\\\text {Real estate, net}\\\text {Othey, net}\\\text {Total property and equipment}\\\text {Goodwill net}\\\text {Other assets}\\\text {Total assets}\\\text {Short-term borrowings}\\\text {Accounts payable}\\\text {Accrued expenses and other current liabilities}\\\text {Income taxespayable}\\\text {Total current liabilities}\\\text {Long-term debt}\\\text {Deferred income taxes}\\\text {Other liabilities}\\\text {Total liabilities}\\\text {Common stock}\\\text {Additional paid-in capital}\\\text {Retained earnings}\\\text {Foreign currency transiation adjustments}\\\text {Treasury shares, at cost}\\\text {Total stockholders' equity}\\\text {Total liabilities and stoclholders' equity}\end{array}\begin{array}{lll}\text {June 30,20 x }\\\text {(In millions)}\\\$584\\182\\2,027\\\underline{80}\\\underline{\$2,873}\\\$2,342\\\underline{2.113}\\\underline{\$4,455}\\\$374\\\underline{651}\\\underline{\$8,353}\\\$278\\1,617\\836\\\underline{107}\\\underline{\$2,838}\\\$1,230\\362\\\underline{243}\\\underline{\$4.673}\\\$30\\453\\4,757\\(137)\\\underline{(1,423)}\\\underline{\$3,680}\\\$8,353\end{array}\end{array}$