Use the Data for Case Study 1 file(attached), which includes 3 years of income s

Use the Data for Case Study 1 file(attached), which includes 3 years of income statements and 3 years of balance sheet information.
Scenario: You are a banker. The CFO of The Best Used Book Store is asking for a $100,000 loan. He explains that the company has successfully grown its inventory and has a current year return on equity of 15.1%. Sales grew 6% last year, and they are in need of additional working capital. Calculate the following financial ratios for the prior 3 years. (Go to Files for data.)
Net profit margin
Gross profit margin
Operating expense as a percent of sales
Return on assets
Current ratio
Quick ratio
Return on equity
Debt to equity
Debt to assets
Based on your analysis of the 3 years of information, describe the condition of the company. Is it healthy? Why or why not?
What are your concerns about the company? Would you approve the loan? Why or why not?
It should be submitted as a single Word document. Along with a narrative, you should include tables with the ratios shown.