Excel Applications for Corporate Finance

Part I. Excel: Setting The Stage -- 1. Making And Using Spreadsheets -- 2. Bringing Data Into Excel -- Part Ii. Working With Accounting Statements -- 3. Making And Getting Accounting Statements -- 4. Ratio Analysis -- Part Iii. Time Value Of Money -- 5. Calculating Present And Future Values -- 6. Compounding And Interest Rate Conversion -- 7. Loan Amortization And Payment Composition -- Part Iv. Valuing Simple Financial Assets -- 8. Valuing Bonds -- 9. Valuing Stocks -- Part V. Capital Budgeting Decision Rules -- 10. Net Present Value -- 11. Other Capital Budgeting Decision Rules -- Part Vi. Risk, Return And The Cost Of Capital -- 12. Measuring Risk And Return -- 13. Calculating Beta -- 14. Analyzing The Security Market Line -- 15. Weighted Average Cost Of Capital -- Part Vii. Cash Flow Analysis And Estimation -- 16. Estimating Future Cash Flows: Pro Forma Analysis -- 17. Scenario Analysis And Sensitivity Analysis -- Part Viii. Advanced Topics In Corporate Finance -- 18. Option Valuation In Corporate Finance -- 19. International Corporate Finance. Troy A. Adair, Jr. Accompanying Cd-rom Entitled: Excel Tutor. System Requirements For Accompanying Cd-rom: Windows 98 Se, Me, 2000 Professional, Xp Professional Or Home; Internet Explorer 5.5; Windows Media Player 7.0; Pentium Ii Or Higher With Minimum 300 Mhz Processor; 64 Mb Ram (128 Mb Ram With Windows Xp); Sound Card And Speakers.