Create a minimum of five visuals in Excel to show how the Laurentian University is performing against the other given Universities. In particular, compare all of the financial indicators $($shown in Appendix III, attached$)$ across the universities and Laurentian University. The case also provides you additional information $($faculty salaries, student counts etc.$)$ that you are welcome to use should you believe that the information is important and applicable to your determination of whether or not Laurentian University might be in financial distress.

Appendix III Benchmarks Defined:

Net income$/$loss ratio $=$ Net Income$/$Total revenue

Net operating revenue ratio $=$ Cash flow from operations$/$Total revenue

Primary reserve $($days$)=($Expendable net assets$/$Total expenses$)$ X $365$ days$\backslash$

Interest burden ratio $=$ Interest expense$/($Total expenses $-$ amortization$)$

Viability ratio $=$ Expendable net assets$/$Long$-$term debt

In year surplus as a percent of revenue $=$ Total revenues $-$ Total expenses

Expendable net assets $=$ Net assets $-$ investments in capital assets $-$ future employee benefits $($asset$)+$ future employee benefits $($liability$)-$ endowment fund