You would like to know how many cells contain data. Which function should you use?
O COUNT
OSUM
O MIN
ABS

The balance sheet contains the following major sections: current assets long-term investments property, plant, and equipment intangible assets other assets current liabilities long-term liabilities contributed capital retained earnings accumulated other comprehensive income required: the following is a list of accounts. using the letters a through j, indicate in which section of the balance sheet each of the accounts would be classified. if an account does not belong under one of the sections listed, select "not under any of the choices" from the classification drop down box. for all accounts, indicate if the account is a contra account or an account that would normally be deducted on the balance sheet by selecting "yes" from the second drop down box, otherwise select "no". account classification contra or deducted (yes/no) 1. cash 2. bonds payable (due in 8 years) 3. machinery 4. deficit 5. unexpired insurance 6. franchise (net) 7. fund to retire preferred stock 8. current portion of mortgage payable 9. accumulated depreciation 10. copyrights 11. investment in held-to-maturity bonds 12. allowance for doubtful accounts 13. notes receivable (due in 3 years) 14. property taxes payable 15. deferred taxes payable 16. additional paid-in capital on preferred stock 17. premium on bonds payable (due in 8 years) 18. work in process 19. common stock, $1 par 20. land 21. treasury stock (at cost) 22. unrealized increase in value of available-for-sale securities

Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity (ignoring flotation costs). use both the capm method and the dividend growth approach to find the cost of equity.calculate the cost of new stock using the dividend growth approach.what is the cost of new common stock based on the capm? (hint: find the difference between re and rs as determined by the dividend growth approach and then add that difference to the capm value for rs.)assuming that gao will not issue new equity and will continue to use the same target capital structure, what is the company’s wacc? e. suppose gao is evaluating three projects with the following characteristics.each project has a cost of $1 million. they will all be financed using the target mix of long-term debt, preferred stock, and common equity. the cost of the common equity for each project should be based on the beta estimated for the project. all equity will come from reinvested earnings.equity invested in project a would have a beta of 0.5 and an expected return of 9.0%.equity invested in project b would have a beta of 1.0 and an expected return of 10.0%.equity invested in project c would have a beta of 2.0 and an expected return of 11.0%.analyze the company’s situation, and explain why each project should be accepted or rejected g

Prepare beneish corporation's income statement and statement of stockholders' equity for year-end december 31, and its balance sheet as of december 31. there were no stock issuances or repurchases during the year. (do not use negative signs with your answers unless otherwise noted.)