Geben Sie Ihre Suchbegriffe ein: Suchformular senden deutsche Version

Rating Calculation

Estimates a rating and cost of debt based on the coverage of debt by an organization

see also ROI - Return on Investment - Rate of return Discount: net present value double money in a given time Present value of a future sum Cash accumulation equation newest formulas Acceleration Calculating a weighted average Pregnancy Date Calculator Fill the yellow fields to see the result in the green fields!   A B C D E 1 Inputs for synthetic rating estimation  2           3 Type of firm  large manufacturing firmsmaller or riskier firmfinancial service firm  4 Enter current Earnings before interest and taxes (EBIT) =    dollar  5 Enter current interest expenses =    dollar  6 Enter current long term government bond rate =    %  7           8 Output  9           10 Interest coverage ratio =      11 Estimated Bond Rating =      12 Estimated Default Spread =    %  13 Estimated Cost of Debt =    %  14           15           16 For large manufacturing firms    17 If interest coverage ratio is    18 >  <=  Rating is  Spread is (%)    19 -100000  0.199999  D  10    20 0.2  0.649999  C  7.5    21 0.65  0.799999  CC  6    22 0.8  1.249999  CCC  5    23 1.25  1.499999  B-  4.25    24 1.5  1.749999  B  3.25    25 1.75  1.999999  B+  2.5    26 2  2.499999  BB  2    27 2.5  2.999999  BBB  1.5    28 3  4.249999  A-  1.25    29 4.25  5.499999  A  1    30 5.5  6.499999  A+  0.8    31 6.5  8.499999  AA  0.5    32 8.50  100000  AAA  0.2    33           34 For smaller and riskier firms (If interest coverage ratio is)    35 >  <=  Rating is  Spread is (%)    36 -100000  0.499999  D  10    37 0.5  0.799999  C  7.5    38 0.8  1.249999  CC  6    39 1.25  1.499999  CCC  5    40 1.5  1.999999  B-  4.25    41 2  2.499999  B  3.25    42 2.5  2.999999  B+  2.5    43 3  3.499999  BB  2    44 3.5  4.499999  BBB  1.5    45 4.5  5.999999  A-  1.25    46 6  7.499999  A  1    47 7.5  9.499999  A+  0.8    48 9.5  12.499999  AA  0.5    49 12.5  100000  AAA  0.2    50           51 For financial service firms (If long term interest coverage ratio is)    52 >  <=  Rating is  Spread is (%)    53 -100000  0,499999  D  10    54 0.5  0,799999  C  7.5    55 0.8  1,249999  CC  6    56 1.25  1,499999  CCC  5    57 1.5  1,999999  B-  4.25    58 2  2,499999  B  3.25    59 2.5  2,999999  B+  2.5    60 3  3,499999  BB  2    61 3.5  4,499999  BBB  1.5    62 4.5  5,999999  A-  1.25    63 6  7,499999  A  1    64 7.5  9,499999  A+  0.8    65 9.5  12,499999  AA  0.5    66 12.5  100000  AAA  0.2    was this helpful ? link: http://formularium.org?go=94 (use this link to publish this page) Export:  Excel-Export Script: <script src="http://formularium.org/js.php?go=94"></script> (use this script to include this spreadsheet onto your own webpageExport)   (source: http://www.exinfm.com/free_spreadsheets.html) did you know that you can integrate any formula into your own homepage? try it! insert this code into your page: <script src="http://formularium.org/js.php?go=94"></script>