Create a table in excel of all the sources of financing for walmart. use the balance sheet that you are provided. you should be able to determine long-term debt, short-term debt, and sources of equity financing. determine which source of debt should be used in calculating the cost of long-term debt. What is the cost of long-term debt? (List source and cost).

EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 (\$ MILLIONS) ASSETS Current Assets: Cash and Equivalents Accounts Receivable Inventory Prepaid Expenses Total Current Assets Net Property, Plant \& Equipm Goodwill Other Long-Term Assets Total Assets \begin{tabular}{rr} 2019 & 2018 \\ & \\ 7,722 & 6,756 \\ 6,283 & 5,614 \\ 44,269 & 43,783 \\ 3,623 & 3,511 \\ \hline 61,897 & 59,664 \\ 111,395 & 114,818 \\ 31,181 & 18,242 \\ 14,822 & 11,798 \\ \hline 219,295 & 204,522 \\ \hline \hline \end{tabular} LIABILITIES Current Liabilities: \begin{tabular}{lrr} Accounts Payable & 47,060 & 46,092 \\ Accrued Liabilities & 22,159 & 22,122 \\ Short-Term Borrowings & 5,225 & 5,257 \\ Current Portion of Long-Term Debt \& Capital Leases & 2,605 & 4,405 \\ Other Current Liabilities & 428 & 645 \\ \cline { 2 - 3 } Total Current Liabilities & 77,477 & 78,521 \\ & & \\ Long-Term Debt \& Capital Leases & 50,203 & 36,825 \\ Deferred Income Taxes and Other & 11,981 & 8,354 \\ Total Liabilities & 139,661 & 123,700 \end{tabular} EQUITY Common Stock and Paid-In Capital Retained Earnings Other Comprehensive Income (Loss) Total Common Equity Non-Controlling Interest Total Equity \begin{tabular}{rr} 3,253 & 2,943 \\ 80,785 & 85,107 \\ (11,542) & (10,181) \\ \hline 72,496 & 77,869 \\ 7,138 & 2,953 \\ \hline 79634 & 80822 \\ \cline { 2 } & \end{tabular} Total Liabilities \& Equity 219,295204,522 EXHIBIT 2: WALMART INC., CONSOLIDATED BALANCE SHEET AS OF JANUARY 31 (\$ MILLIONS) ASSETS Current Assets: Cash and Equivalents Accounts Receivable Inventory Prepaid Expenses Total Current Assets Net Property, Plant \& Equipm Goodwill Other Long-Term Assets Total Assets \begin{tabular}{rr} 2019 & 2018 \\ & \\ 7,722 & 6,756 \\ 6,283 & 5,614 \\ 44,269 & 43,783 \\ 3,623 & 3,511 \\ \hline 61,897 & 59,664 \\ 111,395 & 114,818 \\ 31,181 & 18,242 \\ 14,822 & 11,798 \\ \hline 219,295 & 204,522 \\ \hline \hline \end{tabular} LIABILITIES Current Liabilities: \begin{tabular}{lrr} Accounts Payable & 47,060 & 46,092 \\ Accrued Liabilities & 22,159 & 22,122 \\ Short-Term Borrowings & 5,225 & 5,257 \\ Current Portion of Long-Term Debt \& Capital Leases & 2,605 & 4,405 \\ Other Current Liabilities & 428 & 645 \\ \cline { 2 - 3 } Total Current Liabilities & 77,477 & 78,521 \\ & & \\ Long-Term Debt \& Capital Leases & 50,203 & 36,825 \\ Deferred Income Taxes and Other & 11,981 & 8,354 \\ Total Liabilities & 139,661 & 123,700 \end{tabular} EQUITY Common Stock and Paid-In Capital Retained Earnings Other Comprehensive Income (Loss) Total Common Equity Non-Controlling Interest Total Equity \begin{tabular}{rr} 3,253 & 2,943 \\ 80,785 & 85,107 \\ (11,542) & (10,181) \\ \hline 72,496 & 77,869 \\ 7,138 & 2,953 \\ \hline 79634 & 80822 \\ \cline { 2 } & \end{tabular} Total Liabilities \& Equity 219,295204,522