BBA 2201 Columbia Southern University Cookie Creations Case Study

Instructions

Cookie Creations (Chapter 18)

This assignment is a continuation of the Cookie Creations case study.

For this assignment, you will apply what you have learned from Chapter 18
as an introduction to the financial analysis. This assignment will allow you
to practice what you have learned so far.

Natalie and Curtis have comparative balance sheets and income statements
for Cookie & Coffee Creations, Inc. They have been told that they can use
these financial statements to prepare horizontal and vertical analyses, to
calculate financial ratios, to analyze how their business is doing, and to
make some decisions they have been considering. Below, you are provided with
the balance sheet and income statement of Cookie & Coffee Creations
Inc. for its first year of operations; the year ended October 31, 2021.
Review the calculations below, and then review the additional case
information to calculate the ratios.

Review the additional case information below.

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:
   1. current ratio,
   2. accounts receivable turnover,
   3. inventory turnover,
   4. debt to assets ratio,
   5. times interest earned,
   6. gross profit rate,
   7. profit margin,
   8. asset turnover,
   9. return on assets, and
   10. return on common stockholders’ equity.

1. Comment on your findings from item “a.”
2. 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.
3. 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.

Resources

The following resource(s) may help you with this assignment.

• Submit Math Center Request
• Submit Writing Center Request