Publication number: ELQ-21740-1
View all versions & Certificate
Loan Amortization Schedule in Excel
A loan amortization schedule template along with step-by-step instructions.
Dheeraj Vaidya CFA FRM offers you this Best Practice for free!
download for free
Add to bookmarks
4.8 / 5 (12 votes)
Write a review
People using this Best Practice also downloaded
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule CalculatorSimple and effective tool for debt scheduling and loan amortization506add_shopping_cart
Box IPO (Initial Public Offering)Indepth analysis of BOX IPO with DCF and relative valuation759add_shopping_cart
Comparable Company AnalysisArrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,890add_shopping_cart
Valuation Waterfall GraphShow your audience how the share price of a target company can be broken up in its sub-components1,486add_shopping_cart
Beta Calculation WorksheetCompute the Beta needed for your CAPM as to calculate the expected return of a company's share1,159add_shopping_cart
Private Equity Chart TemplateVisualize the Valuation multiple of Stock or Index over a period of time.922add_shopping_cart
Scenario Graph TemplateVisualize the different options a stock price can take according to a number of variables3,435add_shopping_cart
Private Equity Band Chart TemplateCompute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index944add_shopping_cart
Football Field GraphRepresenting the spread of key PE ratios in floating columns/bars.433add_shopping_cart
Alibaba IPO Financial ModelA full IPO financial model ready to be adapted and tweaked to any other company1,576add_shopping_cart
Colgate Financial Model (Unsolved & Solved Versions)A full financial model ready to be adapted to any other company + a blank template1,731add_shopping_cart
Free Cash Flow (FCFF) TemplateCompute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)718add_shopping_cart
Any questions on Loan Amortization Schedule In Excel?
The user community and author are here to help. Go ahead!