
Originally published: 25/04/2018 13:51
Publication number: ELQ-21740-1
View all versions & Certificate
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
Reviews
Write a review
People using this Best Practice also downloaded
More Best Practices from Dheeraj Vaidya CFA FRM
Loan Amortization Schedule Calculator
Simple and effective tool for debt scheduling and loan amortization427Discussadd_shopping_cartBox IPO (Initial Public Offering)
Indepth analysis of BOX IPO with DCF and relative valuation590Discussadd_shopping_cartComparable Company Analysis
Arrive at the right multiple (EV/Sales, P/E etc.) to prepare the comparable comps.1,666Discussadd_shopping_cartValuation Waterfall Graph
Show your audience how the share price of a target company can be broken up in its sub-components1,284Discussadd_shopping_cartBeta Calculation Worksheet
Compute the Beta needed for your CAPM as to calculate the expected return of a company's share1,005Discussadd_shopping_cartPrivate Equity Chart Template
Visualize the Valuation multiple of Stock or Index over a period of time.819Discussadd_shopping_cartScenario Graph Template
Visualize the different options a stock price can take according to a number of variables3,2452add_shopping_cartPrivate Equity Band Chart Template
Compute the Price to Earnings (or other PE ratios) Band Chart for your target stock or index827Discussadd_shopping_cartFootball Field Graph
Representing the spread of key PE ratios in floating columns/bars.395Discussadd_shopping_cartAlibaba IPO Financial Model
A full IPO financial model ready to be adapted and tweaked to any other company1,380Discussadd_shopping_cartColgate Financial Model (Unsolved & Solved Versions)
A full financial model ready to be adapted to any other company + a blank template1,506Discussadd_shopping_cartFree Cash Flow (FCFF) Template
Compute the FCFF for a firm through three different methods (EBIT, EBITDA and Net Income)636Discussadd_shopping_cart
Any questions on Loan Amortization Schedule In Excel?
The user community and author are here to help. Go ahead!