You currently work for the major bank in the city where you live. The President has just informed you that 2 different companies (Corona and Virus) from the same industry have applied for a significant loan. It would be impossible to provide the amount of money requested to both companies. He has asked for your recommendation on which company would be the best to loan such a large amount of money (it may be that the bank should NOT loan to either). Required: You will prepare the final report to submit to the President of the bank and the senior management of the bank showing your recommendation on which company to loan money. Your research should include vertical and horizontal analysis as well as a minimum of 5 key relevant rations for each company. Himes New Roman 12 A A 22 Paste 40 BIUD aA A1 fx D G H 1 E F The Virus Company 2012 2018 $41,900 544,300 $16,500 $17,500 $25,400 $26,800 SI5,800 $16,500 $9,600 $10,300 (5733) (5856) 5642 5613 $9,509 $10,057 $1,586 $1,900 $7,923 $8,157 $12,606 $9,595 $3,856 $2,675 $2,481 $31,213 $11,578 $8,322 $3,941 $2,902 $2.752 $29,495 + B 1 I The Corona Company 2 2019 2018 3 Net Revenue $62,800 $63,000 4 COGS $28,200 $28,700 5 Gross Profit $34,600 $34,300 6 Expenses $24,700 $24,500 7 Operating Profit $9,900 $9,800 8 Interest Expense ($1,342) (5970) 9 Interest Income $110 $59 10 Income before taxes $8,668 $8,889 11 Taxes $2,174 $1,941 12 Net Income $6,494 $6,948 13 14 Current Assets 15 Cash $9,158 $9,096 16 Short-term Investments $6,967 $2,913 17 Accounts Receivable $6,694 $6,437 18 Inventory $2,723 $2,720 19. Prepaid Expenses $1,547 $1,865 20 Total Current Assets $27,089 $23,031 21 22 Plant and Equipment $16,591 $16,317 23 Intangible Assets $1,237 $1,270 24 Goodwill $14,430 $14,177 25 Other Assets $12,196 $11,811 26 Total Assets $71,543 $66,606 27 28 Current Liabilities 29 Short-term debt $6,892 $4,071 30 Accounts Payable $14,243 $13,507 31 Total Current Liabilitie $21.135 $17,578 32 33 Long-term debt $30,053 $29,213 34 Other Liabilities $6,669 $5,887 35 Total Liabilities $57,857 $52,678 36 37 Common Stock 5.001 Par $24 $24 38 Capital in excess of par $4,091 $4,076 39 Retained Earnings 59.571 59,828 40 Total Equity 513,686 $13,928 41 42 Total Liability & Equity $71,543 $66.606 43 44 Sheet1 + $10,635 $3,676 $10,629 $6,097 $62,250 $12,571 $6,000 $11,289 $5,989 $65,344 57,900 $9.490 $17,390 $6,900 59,660 $16,560 $29,684 $4,08! $51.155 $28.311 $4,301 $49,172 $1,760 S6,200 $3,135 $11,095 $1.760 $5,700 58.712 $16,172 $62,250 565,344