Revisit the portfolio allocation spreadsheet submitted in the previous week. Determine the amount of long-term debt carried by each of the company from the portfolio. Then, make a determination as to the level of risk posed by the long-term debt for each company. Lastly, reorder the list of companies in the portfolio by the amount of risk posed by each company’s long-term debt load.
Your spreadsheet should contain 3 columns: company name, long-term debt load (the actual amount of long-term debt for each company), and risk assessment. In the risk assessment column, include a brief narrative evaluation of the risk posed by the respective company’s debt.