Applying Excel 4: Total Plant Assets 1 10 11 12 13 14 15 16 17 18 19 20 A Current assets Cash Equipment Accumulated Equipment, net Short-term investments Accounts receivable, net Supplies Prepaid expenses Total current assets Long-term investments Long-term notes receivable Investments in stocks and bonds Total long-term investments Plant assets Land Total plant assets Intangible assets: ted Depreciation Multiple Choice С =-E17-E18-F20 =SUM(E17,E18,F19) D Harriet Tubman Company Balance Sheet December 31 Assets =+E17-E18-F19 21 22 23 Copyrights Total assets 24 Which formula in cell F21 accurately computes the value of total plant assets? *SUM(E17,E18,F20) $ 33,000 26.000 46,800 (9.400) $20,700 15,700 29,000 7,300 5,800 $78,500 59,000 37,400 37,000 74,400 8.000 $219,900

eek 1 Statement Matching Amortization JORN BART Accounts Payable R Cash Receipts Land Net Cash Depreciation Expense Net Income Purchased Office Equipment Cash Payments Equipment Cost of Goods Sold Dividends Paid Current Assets Interest Expense Cash From Investing Activities Balance of Retained Earnings Allowance for Doubtful Accounts Cash & Cash Equivalents Accounts Receivable Current Liabilities ㅂㅇㄹ F6 A F7 & J 2⁰ Balance Sheet 8 F8 * Income Statement F9 prt sc F10 C Cash Flow Statement home F11 ㅅ end Retained Earnings Statement F12 (4) J insert

Part 6 Attempt 4/5 for 7 pts. What is the present value of the cash flow from assets from year 2 to 20 (ignoring the one for year 21 for now) (in $ million)? 0+ decimals Submit

Assets Current assets Cash and cash equivalents Accounts receivable, net Supplies Other current assets Total current assets Property and equipment Accumulated depreciation Net property and equipment Goodwill Deferred charges Other Total assets Liabilities and equity Current liabilities Accounts payable Accrued liabilities Current maturities of long-term debt Total current liabilities Operating lease liabilities non-current Long-term debt Other non-current liabilities Total liabilities Total liabilities Common stock Cummulative dividends Retained earnings Other Total equity Total liabilities and equities Revenue, net Operating charges Salaries, wages, and benefits Other operating expenses Supplies expense Depreciation and amortization Lease and rental expense Total operating charges Income from operations Interest expense, net Other (income) expense, net Income before income taxes Provision for income taxes Net income $61,268 1,560,847 Cost of debt (%) Cost of equity (%) Weighted…