Adair, Troy A. creator text xxu Boston McGraw-Hill/Irwin c2005 monographic eng

print

xiii,257p.; ill.;. 28cm. + 1 CD-ROM (4 3/4 in.) + 1 user manual. 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. Troy A. Adair, Jr. 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 Excel applications for corporate finance Electronic spreadsheets Microsoft Excel (Computer file) HF5548.4.M523 .A33 2005 9780072931723 0072931728 120228 20121213105341.0