TY - BOOK AU - Adair, Troy A. TI - Excel applications for corporate finance. SN - 9780072931723 AV - HF5548.4.M523 .A33 2005 PY - 2005/// CY - Boston PB - McGraw-Hill/Irwin KW - Excel applications KW - for corporate finance KW - Electronic spreadsheets KW - Microsoft Excel (Computer file) N1 - PART I - EXCEL: SETTING THE STAGE Chapter 1 - Making and Using Spreadsheets Chapter 2 - Bringing Data into Excel PART II - WORKING WITH ACCOUNTING STATEMENTS Chapter 3 - Making and Getting Accounting Statements Chapter 4 - Ratio Analysis PART III - TIME VALUE OF MONEY Chapter 5 - Calculating Present and Future Values Chapter 6 - Compounding and Interest Rate Conversion Chapter 7 - Loan Amortization and Payment Composition PART IV - VALUING SIMPLE FINANCIAL ASSETS Chapter 8 - Valuing Bonds Chapter 9 - Valuing Stocks PART V - CAPITAL BUDGETING DECISION RULES Chapter 10 - Net Present Value Chapter 11 - Other Capital Budgeting Decision Rules PART VI - PART V -- RISK, RETURN AND THE COST OF CAPITAL Chapter 12 - Measuring Risk and Return Chapter 13 - Calculating Beta Chapter 14 - Analyzing the Security Market Line Chapter 15 - Weighted Average Cost of Capital PART VII - CASH FLOW ANALYSIS AND ESTIMATION Chapter 16 - Estimating Future Cash Flows: Pro Forma Analysis Chapter 17 - Scenario Analysis and Sensitivity Analysis PART VIII - ADVANCED TOPICS IN CORPORATE FINANCE Chapter 18 - Option Valuation in Corporate Finance Chapter 19 - International Corporate Finance N2 - Teaches students how to build financial models in Excel to solve common corporate finance problems. This book comes packaged with an Excel tutorial CD-ROM to brush up on their spreadsheet skills. It helps students learn the intuition behind building the spreadsheets so that they can apply it to other types of problems ER -