I need to calculate the ratios in the last photo of all 3 years but I dont know how to go about any of it and my instructor hasn't been much help. Any help would be so greatly appreciated.

You are the commercial lender for NAIT Bank. Your longtime client Saxenda Inc Industries is a longstanding client of 3 years. Saxenda Inc is an incorporated company with their President on owner being Marvin O'Brien and has been in business for the last 4 years. Saxenda Inc develops gas-fitting devices for the Oil field industry. The company is in Ardrossan just east of Edmonton. They offer their customer 60 Days to settle accounts. Saxenda Inc is looking to secure $750,000 in additional capital as they are looking to expand their current premises to accommodate a new client that they have recently secured. These funds would be used to buy a new machine with the most current level of technology to make the required fittings the client is seeking. They are expecting with this one new account to provide an increase of sales of 25% over the next 4 years. Marvin asked his new CFO Bill, to send you the financial statements that you requested. Bill sent over the un-audited financial statements to you. The audited financials are still with the accountant and will be available in a week or so, but Marvin is pushing to get this loan in place to buy the equipment. Your assistant has collected the industry ratios for you. Bill the CFO has noted that sales have increased in the last three years due to Saxenda Inc's more aggressive selling approach. Marvin is a good client, is eager, and wants to know your response quickly to their request of $750,000. Of course, you must do a complete analysis noting any ratios that are cause for concern or required further explanation. *Copy these financials into your excel file where you will complete your case. Once you have calculated your ratios return to Mobius to input your ratios.* SAXENDA INC BALANCE SHEET PERIOD ENDING DEC 25TH 2020 (Thousands of Dollars Except Share Data) 2020 2013 2018 $814,180 $1,075,658 $762,684 938,568 343,011 275,162 743,409 448,537 348.862 979,561 347.000 263,867 ASSETS Current assets Cash and cash equivalents Accounts receivable, less allowance for doubtful accounts of 577,901 in 2020 $72,854 in 2019, and 594,037 in 2018 Inventories Prepaid expenses and other current assets Total current assets Property, plant and equipment, net Other assets Goodwin Other Total other assets Total assets LIABILITIES AND SHAREHOLDERS EQUITY Current abilities Short-term borrowings Accounts payable 52 370,921 $297.778 $2.616.466 5407,008 $2.353,115 $292784 350,549 750,105 1.398.432 $3.769.353 3945 735,105 1.535,657 $4,153,123 368.691 600,029 1.261,504 $3,614,619 $456,843 $497,554 433,475 $469,900 459,056 Notes Payable Total current liabilities Long-term debt Other liabilities Total liabilities 188,467 $1,119,496 $806,641 331,703 $2.257,840 506,681 269.952 51.233.478 $1 233,477 332.249 52.799 202 249.408 $1,178,384 $824.133 325,315 $2.327,812 Shareholders' equity Preference stock of $2.50 par value. Authorized 5,000.000 shares; none issued 256,855 235,573 233,062 Common stock of $1.74 par value. Authorized and 2020 300,000 shares; issued 147.618 shares in 2020 Additional paid-in capital Retained earnings Accumulated other comprehensive (loss) earnings 202,786 927,615 124.276 288.266 688,100 141.981 386.750 462,197 224.788 Total shareholders' equity 1,511,513 1.353.921 1.286,807 Total liabilities and shareholders equity $3.769,353 $4.153.125 3.614,619 2020 2019 2018 SAXENDA INC CONSOLIDATED STATEMENTS OF OPERATIONS Net revenues 3,681.009 3,688,386 3,882,512 1.630,266 324 894 375,000 Costs and expenses Cost of good sold Royalties Product development Advertising Amortization of intangibles Program production cost amortization Selling, distribution and administration Depreciation 1,627,005 495,596 206,250 360,739 49,559 31,074 1,374.409 223,870 300,000 337.779 22,387 21,976 372,527 32.489 25,392 680.986 575,388 768,737 312,856 361,321 292.784 Total expenses 3,451,209 3,335,956 3,049,158 Operating profit 431,303 352,430 631,851 Non-operating (income) expense Interest expense Interest income Other (income) expense, not $74,112 -29,310 12,065 $71.770 -50,555 -5,299 $76,940 -15,253 16,280 Total non-operating expense, net $56,867 $15.916 $77,967 Earnings before income taxes Income taxes 374,436 92,111 336.514 69,994 553,884 127,393 $282,325 $266,520 $426,491 Net earnings Per common share outstanding Not earnings Por Share 147.618 135 387 $1.91 $1.91 $1.97 $1.88 133.944 $3.18 $3.17 Basic Diluted $1.51 $1.17 $1.76 Cash dividends declared $0.29 $0.3 S0.48 1. CALCULATE THE FOLLOWING RATIOS BE SURE TO SET YOUR BALIPLUS TO TWO DECIMAL POINTS: YOU ARE REQUIRED TO DETERMINE THE TREND OF HOW SAXENDA INC IS PERFORMING COMPARED TO THE INDUSTRY STANDARD. NOTE-ONLY ENTER NUMERIC ANSWERS. FOR EXAMPLE IF THE INDUSTRY RATIO IS IN PERCENTAGE ENTER YOUR ANSWER AS PERCENTAGE. IF THE INDUSTRY RATIO IS IN TIMES(X) ENTER YOUR ANSWER AS WHOLE NUMBER AND SAME FOR DAYS. Ratios Industry Standard Profit on Sales 4.85% Gross Margin 39.5% Return on Assets 10.75% Return on Investment 25% A/R Days of Sales Outstanding 57.1 Days A/P Days Outstanding 42.6 Days Inventory Turnover 5.6 X Sales to Fixed Asset Ratio 10 X Sales to Net Worth Ratio 2.5 X Current Ratio 1.68 X Acid Test Ratio 1.13 X Debt to Net Worth 65.5% Current Liabilities to Net Worth 74% Fixed Assets to Net Worth 13.5% Longterm Liabilities to Net Worth 75% Sales to Working Captial 3.92 X Fixed Assets to LIT Liabilities 29.5% 2020 Number Number Number Number Number Number Number Number Number 2019 Number Number Number Number Number Number Number Number Number 2018 Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number