第 20 节，共 22 节
How to Create a Debt Schedule in Excel with PMT, IPMT & IF Functions
课时22 节课
- 1How to Link the 3 Financial Statements in Excel
- 2Discounted Cash Flow Analysis (DCF Formula)
- 3Capital Markets: Who Are The Key Players?
- 4How to Read a Financial Statement
- 5Financial Statement Analysis: Income Statement
- 6How to Build a Financial Model in Excel (Part 1)
- 7Fixed Income Fundamentals
- 8Behavioral Finance Fundamentals: Decision-Making Biases
- 9Sensitivity Analysis for Financial Modeling
- 10How to Build a Forecasting Model in Excel (FP&A)
- 11Mining Financial Modeling & Valuation Course
- 12How to Write VBA Macros in Excel
- 13How to Calculate Net Present Value, Annuity & Perpetuity
- 14Introduction to Corporate Finance: Course Video
- 15Advanced Excel Formulas: Course Preview
- 16How to use Goal Seek for What-If Analysis in Excel
- 17Audit Financial Models: Go To Special Function in Excel
- 1810-Step Acquisition Checklist: M&A Checklist
- 19Accretion/Dilution Analysis | How to Calculate Pro-Forma EPS
- 20How to Create a Debt Schedule in Excel with PMT, IPMT & IF Functions
- 21How to Calculate Net Capital Expenditure [CapEx]
- 22How to Calculate Internal Rate of Return [IRR]