Description |
xxii, 505 pages : illustrations ; 26 cm |
Contents |
1. Introduction to EXCEL® 2010 -- 2. The Basic Financial Statements -- 3. The Cash Budget -- 4. Financial Statement Analysis Tools -- 5. Financial Forecasting -- 6. Break-Even and Leverage Analysis -- 7. The Time Value of Money -- 8. Common Stock Valuation -- 9. Bond Valuation -- 10. The Cost of Capital -- 11. Capital Budgeting -- 12. Risk and Capital Budgeting -- 13. Portfolio Statistics and Diversification -- 14. Writing User-Defined Functions with VBA -- 15. Analyzing Datasets with Tables and Pivot Tables |
Summary |
This provides practical example-based instruction for performing common enterprise tasks with this ubiquitous spreadsheet application. Beginning with an overview of Excel features and the software environment, the work covers finance-specific topics such as basic financial statements, cash budgets, statement analysis tools, forecasting, leverage analysis, time value of money, stock and bond valuation, capital costs, and risk and capital budgeting |
Notes |
Includes index |
Bibliography |
Includes index |
SUBJECT |
Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
|
Subject |
Business -- Computer programs.
|
|
Corporations -- Finance -- Computer programs.
|
|
Corporations -- Finance.
|
|
Electronic spreadsheets.
|
Author |
Shank, Todd M.
|
LC no. |
2011938350 |
ISBN |
1111826242 |
|
9781111826246 |
|