Use the Data for Case Study 1Links to an external site. file, 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.

• 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

1. Based on your analysis of the 3 years of information, describe the condition of the company. Is it healthy? Why or why not?
2. What are your concerns about the company? Would you approve the loan? Why or why not?

Please make sure you submit this assignment. It should be submitted as a single Word document. Along with a narrative, you should include tables with the ratios shown.