文档介绍：SPREADSHEET MODELING IN CORPORATE FINANCE
To pany Principles of Corporate Finance by Brealey and Myers
CRAIG W. HOLDEN
Richard G. Brinkman Faculty Fellow and Associate Professor
Kelley School of Business
Indiana University
Prentice Hall, Upper Saddle River, New Jersey 07458
To Kathryn, you’re the inspiration,
and to Diana and Jimmy, with joy and pride.
Craig
CONTENTS
Preface
PART 1 TIME VALUE OF MONEY
Chapter 1 Single Cash Flow
Present Value
Future Value
Problems
Chapter 2 Annuity
Present Value
Future Value
System of Four Annuity Variables
Problems
Chapter Present Value
Constant Discount Rate
General Discount Rate
Problems
Chapter 4 Real and Inflation
Constant Discount Rate
General Discount Rate
Problems
Chapter 5 Loan Amortization
Basics
Sensitivity Analysis
Problems
PART 2 VALUATION
Chapter 6 Bond Valuation
Basics
By Yield To Maturity
System Of Five Bond Variables
Dynamic Chart
Problems
Chapter 7 Stock Valuation
Two Stage
Dynamic Chart
Problems
Chapter 8 The Yield Curve
Obtaining It From Bond Listings
Using It To Price A Coupon Bond
Using It To Determine Forward Rates
Problems
Chapter 9 . Yield Curve Dynamics
Dynamic Chart
Problems
PART 3 CAPITAL BUDGETING
Chapter 10 Project NPV
Basics
Forecasting Cash Flows
Working Capital
Sensitivity Analysis
Problems
Chapter 11 Cost-Reducing Project
Basics
Sensitivity Analysis
Problems
Chapter 12 Break-Even Analysis
Based On Accounting Profit
Based On NPV
Problems
Chapter 13 Three Valuation Methods
Adjusted Present Value
Flows To Equity
Weighted Average Cost of Capital
Problems
PART 4 FINANCIAL PLANNING