Debt Rating Costs Schedule - Excel Model Template
Originally published: 26/06/2019 14:34
Last version published: 04/02/2020 14:57
Publication number: ELQ-64023-2
View all versions & Certificate
certified

Debt Rating Costs Schedule - Excel Model Template

This is an Excel template of a Debt Rating Costs Schedule

Description
This tool allows you to generate a schedule that compares debt ratings of multiple companies and later translates them into costs.

Credit rating is an essential element for potential investors to study the debt securities of a given company, such as the bonds. Credit rating agency such as Moody's, Standard & Poor's usually accredit these by providing corresponding letters (e.g. AAA, B C) that characterise the bonds in terms of their quality.

The model consists of an Excel table with multiple tabs including:
- Costs of Debt;
- Unlevering Betas;
- Stock;
- Stock Rating;
- Comp 1, 2, 3, 4, Rating;
- a Raw Data table.

Finally, in this model, you can also find additional Financial Models such as:
- Forecast Drivers,
- Balance Sheet,
- Income Statement,
- Statement of Cash Flows,
- FCF Statement,
- APV Valuation,
- Sensitivity Table,
- Responsibility Check,
- Retained Earnings Schedule,
- Revenue Sensitivity,
- Fixed Asset Schedule,
- Income Taxes,
- Regional Data for Income Taxes.

If you have any comments and/or questions regarding the tool, please do not hesitate to start a discussion below or connect with the Author via their Eloquens Channel.

Finally, don't hesitate to visit the Eloquens page of Wall Street Oasis for more financial models, Resumes and Cover Letter Templates, as well as Financial Cases.

This Best Practice includes
1 Excel file

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.5 / 5 (10 votes)

please wait...