You have just been hired by the Bank of Nova Scotia & your manager, Ms. DeVille has come to you with a task. She has 2 customers asking for a 5 year $50,000 loan and she does not know which customer to give the loan to. Ms. Deville has completed the ratio analysis on the first company, Ursula's Wishes Limited but has not had a chance to complete the ratio analysis of the second company, Gaston's Tavern Limited. Ms. Deville is requesting that you prepare the ratio analysis on Gaston's & then provide a recommendation on which company you would lend the money to. She has provided you with the comparative balance sheet & income statement for the year ended May 31, 2022 as well as the ratio analysis of Ursula's Wishes Limited for the year ended May 31, 2022 and selected industry averages. REQUIRED: 1. Calculate 12 ratios, from the ones we covered, to help you analyze Gaston's Tavern Limited. (You can pick which ratios) 2. Based on your answers from Part 1 prepare a memo to Ms. Deville outlining your recommendation as to which company the bank should lend the money to. Make sure to include analysis of 4 of the ratios prepared in Part 1 to support your answer. Industry averages-2021 Ursula's Wishes Limited 2022 Ratios 55.00% 56% Gross profit margin ratio Net profit margin ratio 4.50% 4.95% Rate of return on assets 20.00% 25.00% Current ratio 1.75 1.50 Quick ratios 1.10 1.00 Debt ratio 60.00% 61% 25.00 Times Interest Earned Earnings per Share Dividend Yield 10.00 $ 14:1 $ 22.00 8.00 15:1 GASTON'S TAVERN LIMITED INCOME STATEMENT FOR THE YEAR ENDED MAY 31, 2022 Sales Cost of goods sold Selling expenses Administrative expenses Rent expense Depreciation Income from operations Interest expense Income before tax Income tax expense Net income 2 $ $ 2022 2021 1,205,675 $1,143,140 485,600 479,120 720,075 664,020 330,150 315,740 274,869 264,580 22,500 20,100 5,500 3,500 633,019 603,920 87,056 60,100 3,400 2,400 83,656 57,700 12,550 8,650 71,106 $ 49,050