WCreate a vertical analysis(fill the blanks from the last 2 pictures) for income statement and balance sheet with the data(of the first 2 pictures)

Fill this:

A1 Microsoft Corporation Balance Sheet 37 1 turrent assets: 42 Cash and cash equivalents otal cash, cash equivalents, and shon 32.981113240 46 Inventories otal current sets 49 roperty and equipment, et 50 quity and other investments 51 oodw 59 8S1139. 23.734 183 6023 1843 5.122 17 tangible assets, net 54 otal assets abilities and stockbolders" equity 8Corrent labllities 59 Moounts payable 60 Short-term debt 61 Cument poetion of long-term debt 62 Aacrued compensation 63 Income taxes 64 hort-term unearned revenue 65 Seourities lending payable 1390 89 9.07212.90 5.819526 67 otal current liabilities 68 ong-term debe 69 ong-term uncarned revenue 70 erred income taxes 71 18377 644 ther long-term liabilities otal liabilities 74 tockbolders' equity Common ssock and paid-in capital shares authorized 24,000 75 outstanding 7,708 and 7,808 76 etained earning 2648 22 78 |-tal stockholders' equity A1 Microsoft Corporation Balance Sheet 37 1 turrent assets: 42 Cash and cash equivalents otal cash, cash equivalents, and shon 32.981113240 46 Inventories otal current sets 49 roperty and equipment, et 50 quity and other investments 51 oodw 59 8S1139. 23.734 183 6023 1843 5.122 17 tangible assets, net 54 otal assets abilities and stockbolders" equity 8Corrent labllities 59 Moounts payable 60 Short-term debt 61 Cument poetion of long-term debt 62 Aacrued compensation 63 Income taxes 64 hort-term unearned revenue 65 Seourities lending payable 1390 89 9.07212.90 5.819526 67 otal current liabilities 68 ong-term debe 69 ong-term uncarned revenue 70 erred income taxes 71 18377 644 ther long-term liabilities otal liabilities 74 tockbolders' equity Common ssock and paid-in capital shares authorized 24,000 75 outstanding 7,708 and 7,808 76 etained earning 2648 22 78 |-tal stockholders' equity