You are an analyst for Winds of Fortune Bank. Paul's Manufacturing, Inc. has come to you for a loan. Compute the following ratios from the excel sheet below: Current Ratio, Quick Ratio, Inventory Turnover, Average Collection Period, Debt Ratio, Times Interest Earned, Net Profit Margin, Return on Assets, Return on Equity & Earnings per Share. Then, indicate if each ratio has improved or declined from 2018 to 2019. Make sure that you show your work. Finish the assignment by determining if you will authorize the loan. Paul's Manufacturing, Inc. Assets Cash Accounts Receivable Inventory Total Current Assets Net Fixed Assets Total Assets 2019 40,000.00 260,000.00 500,000.00 800,000.00 400,000.00 1,200,000.00 2018 50,000.00 200,000.00 450,000.00 700,000.00 300,000.00 1,000,000.00 Liabilities Accounts Payable Bank Loan Accruals Total Current Liabilities Long-term debt Owners Equity Common Stock, par Paid-in capital Retained Earnings Total Liabilities $ Equity 170,000.00 90,000.00 70,000.00 330,000.00 400,000.00 130,000.00 90,000.00 50,000.00 270,000.00 300,000.00 300,000.00 50,000.00 120,000.00 1,200,000.00 300,000.00 50,000.00 80,000.00 1,000,000.00 1,500,000.00 900,000.00 600,000.00 1,300,000.00 780,000.00 520,000.00 Income Statement Net Sales Cost of Goods Sold Gross Profit Expenses General & Admin Selling Depriciation Interest Earnings Before Taxes Income Taxes Net Income 150,000.00 150,000.00 53,000.00 57,000.00 190,000.00 76,000.00 114,000.00 150,000.00 130,000.00 40,000.00 45,000.00 155,000.00 62,000.00 93,000.00 Assumptions Credit sales are 50% of net sales 30,000 shares of common stock outstanding market price $45/share $2 annual dividend/share