Reference no: EM132653402

Question - Natalie and Curtis are thinking about borrowing an additional $20,000 to buy more equipment. The loan would be repaid over a 4-year period. The terms of the loan provide for equal semi-annual installment payments of $2,500 on May 1 and November 1 of each year, plus interest of 5% on the outstanding balance. Dividends on preferred stock were $1,400. Since this is the first year of operations and the beginning balances are zero, use the ending balance as the average balance where appropriate.

Complete the tasks listed below.

1. Calculate the following ratios:

2. Current ratio,

3. Accounts receivable turnover,

4. Inventory turnover,

5. Debt to assets ratio,

6. Times interest earned,

7. Gross profit rate,

8. Profit margin,

9. Asset turnover,

10. Return on assets, and

11. Return on common stockholders' equity.

12. Comment on your findings from item "a."

13. Based on your analysis in items "a" and "b", do you think a bank would lend Cookie & Coffee Creations Inc. $20,000 to buy the additional equipment? Explain your reasoning.

14. What alternatives could Cookie & Coffee Creations Inc. consider instead of bank financing?

Complete your calculations for item "a" in either an Excel spreadsheet or a Word document. If you complete item "a" in an Excel spreadsheet, complete items "b-d" in a Word document, and submit the Excel spreadsheet and the Word document in Blackboard. If you complete items "a-d" in a Word document, submit your calculations to item "a" and your responses for items "b-d" in a single Word document in Blackboard. Your total submission should be a minimum of two pages in length, including your calculations. Include at least two references. Adhere to APA Style when creating citations and references for this assignment.