TAILIEUCHUNG - Spreadsheeet Modelling in corporate Finance

For nearly 20 years, since the emergence of PCs, Lotus 1-2-3, and Microsoft Excel in the 1980’s, spreadsheet models have been the dominant vehicles for finance professionals in the business world to implement their financial knowledge. Yet even today, most Corporate Finance textbooks rely on calculators as the primary tool and have little (if any) coverage of how to build spreadsheet models. This book fills that gap. It teaches students how to build financial models in Excel. | Spreadsheet Modeling in Corporate Finance To accompany 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 3 Net 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 .

• Ngân hàng - Tín dụng
• Time value of money
• capital budgetting
• finance planning
• corporate finance
• Cash Flow
• Discount Rat
• Future value of Money
• Present value of Money
• Rates of return amortization
• Time lines show timing of cash flows
• Time line for an ordinary annuity
• The Time Value of Money
• Time and Money
• Financial Calculator
• Present Value
• Future Value
• Interest rate
• Inventory model
• Crashable lead time
• Management of the current assets
• Solution algorithm
• Managerial Accounting
• Lecture Managerial Accounting
• Kế toán quản trị
• Managerial finance
• Lecture Managerial finance
• Rates of return
• Intermediate accounting
• Lecture Intermediate accounting
• Single sum problems
• Present value measurement
• Compound interest
• Finance management
• Fundamentals of finance management
• Time lines
• The power of compound interest
• Savings problem
• The balloon payment
• Stocking and price reduction decisions
• Non instantaneous deteriorating items
• Complex and time consuming
• Decision making processes
• Lecture Money and Banking
• Bài giảng Tiền tệ và Ngân hàng
• Money and Banking
• Future value concepts
• Financial environment
• Financial Accounting
• Financial management
• Fundamentals of financial management
• Financial statement
• Quản lý tài chính
• Personal financial planning
• Personal financial
• Lecture Personal financial planning
• Financial planning
• Engineering economics
• Lecture Engineering economics
• Time value
• Money application
• Determining operating costs
• Calculating annual costs
• Lecture Financial accounting
• Future amounts
• Present values
• Financial instruments
• Business decision
• Kế toán tài chính
• Business finance
• Business organisation
• Fundamentals of finance
• Lecture Business finance
• Capital market
• Equity securities
• Issues in financial accounting
• Financial statements
• Future values
• Lecture Engineering economy
• Engineering economy
• Bài giảng Kinh tế kỹ thuật
• Computation of simple interest
• Accumulated interest
• Financial transactions