Last version published: 02/03/2018 15:28
Publication number: ELQ-53060-2
View all versions & Certificate
How to Create a Financial Model for an Advanced Debt Schedule
This video will help you through the complex process of creating a model debt schedule in Microsoft Excel.
With this detailed tutorial, Ezra guides you through the process of building an in-depth Excel financial model to schedule your debt. This video will give you the tools to schedule for three different types of debt; namely bank loans, note debt and revolver debt.
By following this video and executing this financial model, your business will be able to be flexible, yet secure with your debt. You will be able to build a detailed model to schedule how much debt your business will take on.
This video demonstrates an incredibly efficient way of using Excel to schedule your debt. Giving you automated calculations based on your input figures, Ezra shows how you can document and schedule your bank loan debts quickly and efficiently.
This video simply shows how to construct your debt schedule to give you automated closing balance, average balance, interest expense and cash remaining predictions based on your debt. This is then replicated and adapted to show you how to schedule for your business' note debt as well as revolver debt.
This will then allow you to use all three types of debt in unison and calculate yopur overall total debt, your cash available and your interest expense. Therefore, this video tool will give you the means to easily calculate and schedule all of your different kinds of debt.
15 mins Video.
This Best Practice includes
15 min Video File
Add to bookmarks
- Rate this Video File
Write a review
- Hafizal Aziz(last updated: 30/04/2019 08:18)
- Bolortseren Boldtseren(last updated: 16/02/2019 11:31)
- Mostafa Ramdan(last updated: 25/10/2018 08:17)
People using this Best Practice also downloaded
Real Estate Excel Financial Model TemplateA detailed Real Estate Financial Model brought to you by CFI to help you successfully model your development project.investmentprojectreal estatemodelingfinancial model2,510add_shopping_cart$100.00by CFI
Real Estate - Financial Model for an Industrial Warehouse Development ProjectCase study PDF and Excel File for the Financial Model.financereal estatecase studyfinancial modelexcel791add_shopping_cart$50.00by Padmashri V
Integrated Financial StatementsExcel financial model for integrated financial statements.income statementcash flowfinancial modelbalance sheetdebt schedule2,048add_shopping_cart$49.00by Mahender K. Punhani
Online Shop Financial ModelOnline Shop Financial Model presents the business case of a brand new start up Online Shop with an upfront investment inirrdcffinancial modelexcelexcel model1,759add_shopping_cart
Customizable Carried Interest Waterfall Excel TemplateCustomizable and powerful template for carried interest calculations for private equity projectsirrhurdle rateprivate equitypefinancial model6,306add_shopping_cart$49.00by Alex Martyanov
Telecoms Financial ModelTelecom Financial Model presents the case of an already operating business in the telecom sector (mobile communications,financial modelfinancial modelinginternetexcelmobile735add_shopping_cart$149.00by Big4WallStreet
Start Up Car Park Excel Model and Valuation TemplateA full & detailed Excel Model of a Car park business with 3 statements & investment metrics - to download and use.business planmodelvaluationfinancial modelexcel1,167add_shopping_cart
Blockchain/ICO Forecasting and Analysis Financial Excel Model TemplateThis ICO model allows you to analyse and create financial projections for cryptocurrencies and blockchains.investmentsforecastfinancial modelinvestorsexcel2,837add_shopping_cart$99.00by Alex Martyanov
10 Years Financial Forecast and Valuation Excel ModelThis unique generic financial model allows the user to forecast a Company's profit and loss account, balance sheet, CFincome statementvaluationcash flowfinancial modelbalance sheet2,913add_shopping_cart$60.00by Jair Almeida
Subscription E-Commerce Fundraising Financial ModelCombining an e-commerce product sales model & a subscription model to make one subscription e-commerce fundraising modelplanningfinancial modelstartupfundraisingsubscription2,306add_shopping_cart$369.00by Alexander Jarvis
Any questions on How To Create A Financial Model For An Advanced Debt Schedule?
The user community and author are here to help. Go ahead!