45 46 48 49 50 51 52 53 54 55 56 57 58 60 62 63 168638RRRRRERERE 67 40 hallo TULUNDI 41 The data in the following exhibit will be used in throughout this Sheet. 42 For each of the companies across the top of the following exhibit, you will be asked to write formulas to calculate the Balance Sheet ratios Hint You should be able to write a formula for the first company and copy it across to the other columns for the other companies 43 71 72 73 76 A 78 79 B < Ready C Revenues Cost of Revenues EBIT Interest Expense Net Income D EXHIBIT COMPANY DATA FOR Balance Sheet ANALYSIS eBay 10.746 2,382 2,222 326 2.530 2,202 Accounts Receivable Accounts Receivable (Prior Period) Average Accounts Receivable Inventores Inventories (Prior Period) Average Inventories Other Current Assets Accounts Payable Accounts Payable (Prior Period) Average Accounts Payable Other Current Liabilities Short-term Debl Long-term Debl Equity Current Assets E 1282 3882 383 General All Employees (unrestricted) 1,499 330 1,546 70 Before applying the data to Balance Sheet ratios, first calculate the following totals. Row 76 Current Assets = Dash - Accounts Receivable + Inventories + Other Current Assets Flow 77 Current Labilities Accounts Payable + Short-term Debt + Other Current Liabilities Flow 78 Debt = Short-term Debt - Long-term Debt Flow 79 Capital= Desi- Equity 7,675 6.281 eBay ACCOUNTS Balance Sheet G Exxon rsoll Rand 279.332 15,668 10.848 244 262 20.839 1,917 766 221 20,840 1.338 3.042 903 19.638 21,274 20.456 18.958 16,992 17.975 1272 21.063 21,701 21,382 17,258 20,538 198,528 1,678 1.555 1,617 472 1,705 1.556 1.631 351 3,741 7,065 H Exxon rsoll Rand J & J 81.581 27,091 20,049 1,005 15,297 18,107 14,098 13,490 13,794 8,599 8,765 8,682 3,649 7,537 7.310. 7.424 2,796 27,684 59,752 J & J FSA Balance Sheet Accessibility: Investigate PepsiCo 64,661 29,381 10,110 1,525 12,515 8,721 6,079 5,956 6,018 3,128 2,947 3,038 3,693 7,213 6,727 6,970 3,277 4,026 28.295 14,602 PepsiCo UPS 71,861 58.010 7,024 605 4,791 4,225 8,958 8,773 8,866 2,217 5,188 3,934 4,561 2,322 2,805 19,931 3,037 UPS M SFAM Balance Sheet DISRUPTIVE DIGITIZATION O EXCEL