In a VLOOKUP formula, what does the argument column_index_number mean? 1. the secret INDEX number that each column in an Excel worksheet has
2. the number of the column within the selected table array where the lookup result is located
3. a numerical representation of the letters at the top of a worksheet; for example, A= 1, B = 2, etc.
numbers a user assigns to columns in a worksheet

Balance sheet the assets of dallas & associates consist entirely of current assets and net plant and equipment. the firm has total assets of $2 5 million and net plant and equipment equals $2 million. it has notes payable of $150,000, long-term debt of $750,000, and total common equity of $1 5 million. the firm does have accounts payable and accruals on its balance sheet. the firm only finances with debt and common equity, so it has no preferred stock on its balance sheet. a. what is the company's total debt? b. what is the amount of total liabilities and equity that appears on the firm's balance sheet? c. what is the balance of current assets on the firm's balance sheet? d. what is the balance of current liabilities on the firm's balance sheet? e. what is the amount of accounts payable and accruals on its balance sheet? [hint: consider this as a single line item on the firm's balance sheet.] f. what is the firm's net working capital? g. what is the firm's net operating working capital? h. what is the explanation for the difference in your answers to parts f and g?

You hold a diversified $100,000 portfolio consisting of 20 stocks with $5,000 invested in each. the portfolio's beta is 1.12. you plan to sell a stock with b = 0.90 and use the proceeds to buy a new stock with b = 1.50. what will the portfolio's new beta be? do not round your intermediate calculations.

Which of the following constitute the types of unemployment occurring at the natural rate of unemployment? a. frictional and cyclical unemployment.b. structural and frictional unemployment.c. cyclical and structural unemployment.d. frictional, structural, and cyclical unemployment.