Vai al contenuto principale della pagina
Autore: | Holden Craig W. |
Titolo: | Excel modeling in corporate finance / / Craig W. Holden |
Pubblicazione: | Boston : , : Pearson, , [2015] |
©2015 | |
Edizione: | Fifth, global edition. |
Descrizione fisica: | 1 online resource (230 pages) : illustrations (some color) |
Disciplina: | 005.369 |
Nota di contenuto: | Cover -- Contents -- Preface -- Fifth Edition Changes -- Ready-To-Build Spreadsheets -- What is Unique about This Book -- Conventions Used in This Book -- Craig's Challenge -- ExcelTM Modeling Books -- Suggestions for Faculty Members -- Acknowledgments -- About The Author -- Part 1: Time Value of Money -- Chapter 1: Single Cash Flow -- 1.1 Present Value -- 1.2 Future Value -- Problems -- Chapter 2: Annuity -- 2.1 Present Value -- 2.2 Future Value -- 2.3 System of Four Annuity Variables -- Problems -- Chapter 3: NPV Using Constant Discounting -- 3.1 Nominal Rate -- 3.2 Real Rate -- Problems -- Chapter 4: NPV Using General Discounting -- 4.1 Nominal Rate -- 4.2 Real Rate -- Problems -- Chapter 5: Loan Amortization -- 5.1 Basics -- 5.2 Sensitivity Analysis -- Problems -- Chapter 6: Lease Vs. Buy -- 6.1 Car -- 6.2 Corporate -- Problems -- Part 2: Valuation -- Chapter 7: Bond Valuation -- 7.1 Annual Payments -- 7.2 EAR, APR, and Foreign Currencies -- 7.3 Duration and Convexity -- 7.4 Price Sensitivity -- 7.5 System of Five Bond Variables -- Problems -- Chapter 8: Estimating the Cost of Capital -- 8.1 Static CAPM Using Fama-MacBeth Method -- 8.2 APT or Intertemporal CAPM Using Fama-McBeth Method -- Problems -- Chapter 9: Stock Valuation -- 9.1 Dividend Discount Model -- Problems -- Chapter 10: Firm and Project Valuation -- 10.1 Cash Flows for Five Equivalent Methods -- 10.2 Adjusted Present Value -- 10.3 Free Cash Flow To Equity -- 10.4 Free Cash Flow to the Firm -- 10.5 Dividend Discount Model -- 10.6 Residual Income -- 10.7 Five Equivalent Methods -- Problems -- Appendix: Reconciling the Residual Income Method with Other Approaches to Valuing Firms or Projects -- Chapter 11: The Yield Curve -- 11.1 Obtaining It From Treasury Bills and Strips -- 11.2 Using It To Price A Coupon Bond -- 11.3 Using It To Determine Forward Rates -- Problems. |
Chapter 12: US Yield Curve Dynamics -- 12.1 Dynamic Chart -- Problems -- Part 3: Capital Structure -- Chapter 13: Capital Structure -- 13.1 Modigliani-Miller With No Taxes -- 13.2 Modigliani-Miller With Corporate Taxes -- 13.3 Trade-off Model: Tax Shield vs. Distress Cost -- Problems -- Part 4: Capital Budgeting -- Chapter 14: Project NPV -- 14.1 Basics -- 14.2 Forecasting Cash Flows -- 14.3 Working Capital -- 14.4 Sensitivity Analysis -- Problems -- Chapter 15: Cost-Reducing Project -- 15.1 Basics -- 15.2 Sensitivity Analysis -- Problems -- Chapter 16: Break-Even Analysis -- 16.1 Based on Accounting Profit -- 16.2 Based on NPV -- Problems -- Part 5: Financial Planning -- Chapter 17: Corporate Financial Planning -- 17.1 Actual -- 17.2 Forecast -- 17.3 Cash Flow -- 17.4 Ratios -- 17.5 Sensitivity -- 17.6 Full-Scale Estimation -- Problems -- Chapter 18: Du Pont System of Ratio Analysis -- 18.1 Basics -- Problems -- Chapter 19: Life-Cycle Financial Planning -- 19.1 Taxable Vs. Traditional Vs. Roth Savings -- 19.2 Basic Life-Cycle Planning -- 19.3 Full-Scale Life-Cycle Planning -- Problems -- Part 6: International Corporate Finance -- Chapter 20: International Parity -- 20.1 System of Four Parity Conditions -- 20.2 Estimating Future Exchange Rates -- Problems -- Part 7: Options and Corporate Finance -- Chapter 21: Binomial Option Pricing -- 21.1 Estimating Volatility -- 21.2 Single Period -- 21.3 Multi-Period -- 21.4 Risk Neutral -- 21.5 Average of N and N-1 -- 21.6 Convergence to Normal -- 21.7 American With Discrete Dividends -- 21.8 Full-Scale -- Problems -- Chapter 22: Real Options -- 22.1 Option To Abandon -- 22.2 Option to Expand -- 22.3 Option to Contract -- 22.4 Option To Choose -- 22.5 Compound Option -- Problems -- Chapter 23: Black-Scholes Option Pricing -- 23.1 Basics -- 23.2 Continuous Dividend -- 23.3 Implied Volatility -- Problems. | |
Chapter 24: Debt And Equity Valuation -- 24.1 Two Methods -- 24.2 Impact of Risk -- Problems -- Part 8: Excel Skills -- Chapter 25: Useful Excel Tricks -- 25.1 Quickly Delete The Instructions and Arrows -- 25.2 Freeze Panes -- 25.3 Spin Buttons and the Developer Tab -- 25.4 Option Buttons and Group Boxes -- 25.5 Scroll Bar -- 25.6 Install Solver or the Analysis ToolPak -- 25.7 Format Painter -- 25.8 Conditional Formatting -- 25.9 Fill Handle -- 25.10 2-D Scatter Chart -- 25.11 3-D Surface Chart. | |
Sommario/riassunto: | For courses in corporate finance or financial management at the undergraduate and graduate level. Excel Modeling in Corporate Finance approaches building and estimating models with Microsoft® Excel®. Students are shown the steps involved in building models, rather than already-completed spreadsheets. |
Titolo autorizzato: | Excel modeling in corporate finance |
ISBN: | 1-292-07149-4 |
Formato: | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione: | Inglese |
Record Nr.: | 9910154783503321 |
Lo trovi qui: | Univ. Federico II |
Opac: | Controlla la disponibilità qui |