Always Learning

Excel Modeling in the Fundamentals of Corporate Finance Book and CD-ROM, 2/E
Craig W. Holden, Indiana University

ISBN-10: 0131513435
ISBN-13:  9780131513433

Publisher:  Prentice Hall
Copyright:  2005
Format:  Kit/Package/ShrinkWrap
Published:  01/23/2004


Print this content

In this section:


Description

For undergraduate courses in corporate finance.

Excel Modeling in the Fundamentals of Corporate Finance is a supplemental book and CD. It teaches students how to build financial models with step-by-step instructions in Excel. It can accompany any undergraduate corporate finance textbook, including textbooks by Brealey, Brigham, Gitman, Keown, Ross, and Van Horne.


Features

  • NEW - Updated coverage—Adds an Annual Payments model to the Bond Valuation chapter, adds saving as a percentage of wealth to the Lifetime Financial Planning chapter, updates the yield curve database, updates the tax rates, and updates the dates in all examples.

    • Keeps text up-to-date.

  • Instructions for building financial models, not templates.

    • Students really learn finance by building financial models themselves (active learning), rather than using canned templates which are “black boxes” (passive learning).

  • Every chapter has end-of-chapter problems.

    • Provides students with the opportunity to practice what they have learned.

  • Progression from simple examples to practical, real-world applications—Including Corporate Financial Planning uses three years of historical 10K data on Nike, Inc. (including every line of their income statement, balance sheet, and cash flow statement), constructs a complete financial system (including linked financial ratios), and projects these financial statements three years into the future; Life-Cycle Financial planning that includes a detailed treatment of federal and state tax schedules, Social Security taxes and benefits, etc., permitting the realistic exploration of savings, retirement, and investments choices over a lifetime; US Yield Curve Dynamics shows you a “movie” of 30 years of monthly zero-coupon, yield curves highlighting the dynamics of the US yield curve history.

    • Provides real-world applications that students will comprehend.

  • Can accompany any popular undergraduate corporate finance textbook because the CD provides alternative notation versions—The printed book matches the notation of the Brigham book (Fundamentals of Financial Management by Brigham and Houston). The CD contains PDF files with alternative chapters that match the notation of other popular undergraduate corporate finance books, including:

    • Fundamentals of Corporate Finance by Brealey, Myers, and Marcus

    • Principles of Managerial Finance by Gitman

    • Introduction to Finance by Gitman and Madura

    • Foundations of Finance by Keown, Martin, Petty, and Scott

    • Fundamentals of Corporate Finance by Ross, Westerfield, and Jordan

    • Fundamentals of Financial Management by Van Horne and Wachowicz.


New To This Edition

  • Updated coverage—Adds an Annual Payments model to the Bond Valuation chapter, adds saving as a percentage of wealth to the Lifetime Financial Planning chapter, updates the yield curve database, updates the tax rates, and updates the dates in all examples.

    • Keeps text up-to-date.


Table of Contents

I. TIME VALUE OF MONEY.

1. Single Cash Flow.

Present Value. Future Value. Problems.

2. Annuity.

Present Value. Future Value. System of Four Annuity Variables. Problems.

3. Net Present Value.

Constant Discount Rate. General Discount Rate. Problems.

4. Real and Inflation.

Constant Discount Rate. General Discount Rate. Problems.

5. Loan Amortization.

Basics. Sensitivity Analysis. Problems.

II. VALUATION.

6. Bond Valuation.

Annual Payments. APR vs. EAR. By Yield to Maturity. System of Five Bond Variables. Dynamic Chart. Problems.

7. Stock Valuation.

Two Stage. Dynamic Chart. Problems.

8. U.S. Yield Curve Dynamics.

Dynamic Chart. Problems.

III. CAPITAL BUDGETING.

9. Project NPV.

Basics. Forecasting Cash Flows. Working Capital. Sensitivity Analysis. Problems.

10. Break-Even Analysis.

Based on Accounting Profit. Based on NPV. Problems.

IV. FINANCIAL PLANNING.

11. Corporate Financial Planning.

Actual. Forecast. Cash Flow. Ratios. Sensitivity. Full-Scale Real Data. Problems.

12. Life-Cycle Financial Planning.

Basics. Problems.

V. OPTIONS AND CORPORATE FINANCE.

13. Binomial Option Pricing.

Single Period. Multi-Period. Risk Neutral. Full-Scale Real Data. Problems.

14. Black Scholes Option Pricing.

Basics. Dynamic Chart. Continuous Dividend. Implied Volatility. Problems.

15. Real Options.

Using Black-Scholes. Using the Binomial Model. Sensitivity to Standard Deviation. Problems.


Next Edition(s)

  • Excel Modeling and Estimation in the Fundamentals of Corporation Finance, 3/E
    Holden
    ©2009  |  Prentice Hall  |  Paper; 200 pp  |  Instock
    ISBN-10: 0132079895  |  ISBN-13: 9780132079891
    Brief Description  |  More Info



Back to top

Print this content

In this section:

Facuty Excel Files, 2/E
Holden
©2004  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0131424122  |  ISBN-13: 9780131424128
URL: http://www.prenhall.com/holden

Show Downloadable Files
 | More Info

Back to top


For the Finance Discipline

FinCoach 2.0: CD-ROM Edition
Handa
©2002  |  Prentice Hall  |  CD-ROM Only  |  Instock
ISBN-10: 0130606189  |  ISBN-13: 9780130606181
More Info

Research Navigator: Resources for College Research
Pearson
©2006  |  Prentice Hall  |  Paper  |  Instock
ISBN-10: 0321186079  |  ISBN-13: 9780321186072
More Info


Back to top

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students contact your Pearson Higher Education representative.

Back to top