In the “Jones ex-ante handout 1” excel file(see below), you will observe the first sheet titled 1. Historical Ratios. The top area (in yellow) contains Jones’ historical financial statements, while the lower area (in brown) contains a list of several ratios that I am asking you to calculate. Please do the following:
Your assignment is as follows:
1. Use the ratios in the handout to provide your assessment of Jones Electrical Distribution’s financial health. You will note that the excel sheet compares years 2004 and 2006. Because of this, you are free to simply use each year's balance items instead of trying to find an average value for them.
2. If you were the banker, would you lend Jones the funds? Please explain why.
contains the completed version of the “Jones ex-ante handout 1” excel file.