Question Solved1 Answer Additional information: 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 semiannual 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. Instructions (a) Calculate the following ratios. 1. Current ratio 6. Gross profit rate 2. Accounts receivable turnover 7. Profit margin 3. Inventory turnover 8. Asset turnover 4. Debt to assets ratio 9. Return on assets 5. Times interest earned 10. Return on common stockholders' equity (b) Comment on your findings from part (a). (c) Based on your analysis in parts (a) and (b), do you think a bank would lend Cookie & Coffee Creations Inc. $20,000 to buy the additional equipment? Explain your reasoning. (d) What alternatives could Cookie & Coffee Creations consider instead of bank financing? COOKIE & COFFEE CREATIONS INC. Balance Sheet October 31, 2021 Assets Current assets Cash Accounts receivable Inventory Prepaid Rent Property, plant, and equipment Equipment Accumulated depreciation equipment Total assets $32,219 3,250 17,897 6,300 $59,666 $99,700 (9,850) 89,850 $149.516 $5,786 18,500 700 2,250 250 4,000 $31,486 Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Dividends payable Salaries and wages payable Interest payable Notes payable current portion Long-term liabilities Notes payable-long-term portion Total liabilities Stockholders' equity Paid-in capital Preferred stock, 2,800 shares issued and outstanding Common stock, 25,930 shares issued, 25,180 outstanding Retained earnings Total paid-in capital and retained earnings Less: Treasury stock-common (750 shares), at cost Total stockholders' equity Total liabilities and stockholders' equity 6,000 37,486 $14,000 25,930 39,930 72,600 112,530 500 112.030 $149,516 O COOKIE & COFFEE CREATIONS INC. Income Statement Year Ended October 31, 2021 $462,500 231,250 231,250 Sales Revenue Cost of goods sold Gross profit Operating expenses Salaries and wages expense Depreciation expense Other operating expenses Income from operations Other expenses Interest expense Income before income tax Income tax expense Net income $92,500 9,850 35,850 138,200 93,050 550 92,500 18,500 _$74.000

ZJW22G The Asker · Accounting

Additional information:

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 semiannual 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.

Instructions

(a) Calculate the following ratios.

1. Current ratio 6. Gross profit rate

2. Accounts receivable turnover 7. Profit margin

3. Inventory turnover 8. Asset turnover

4. Debt to assets ratio 9. Return on assets

5. Times interest earned 10. Return on common stockholders' equity

(b) Comment on your findings from part (a).

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

(d) What alternatives could Cookie & Coffee Creations consider instead of bank financing?

Transcribed Image Text: COOKIE & COFFEE CREATIONS INC. Balance Sheet October 31, 2021 Assets Current assets Cash Accounts receivable Inventory Prepaid Rent Property, plant, and equipment Equipment Accumulated depreciation equipment Total assets $32,219 3,250 17,897 6,300 $59,666 $99,700 (9,850) 89,850 $149.516 $5,786 18,500 700 2,250 250 4,000 $31,486 Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Dividends payable Salaries and wages payable Interest payable Notes payable current portion Long-term liabilities Notes payable-long-term portion Total liabilities Stockholders' equity Paid-in capital Preferred stock, 2,800 shares issued and outstanding Common stock, 25,930 shares issued, 25,180 outstanding Retained earnings Total paid-in capital and retained earnings Less: Treasury stock-common (750 shares), at cost Total stockholders' equity Total liabilities and stockholders' equity 6,000 37,486 $14,000 25,930 39,930 72,600 112,530 500 112.030 $149,516 O COOKIE & COFFEE CREATIONS INC. Income Statement Year Ended October 31, 2021 $462,500 231,250 231,250 Sales Revenue Cost of goods sold Gross profit Operating expenses Salaries and wages expense Depreciation expense Other operating expenses Income from operations Other expenses Interest expense Income before income tax Income tax expense Net income $92,500 9,850 35,850 138,200 93,050 550 92,500 18,500 _$74.000
More
Transcribed Image Text: COOKIE & COFFEE CREATIONS INC. Balance Sheet October 31, 2021 Assets Current assets Cash Accounts receivable Inventory Prepaid Rent Property, plant, and equipment Equipment Accumulated depreciation equipment Total assets $32,219 3,250 17,897 6,300 $59,666 $99,700 (9,850) 89,850 $149.516 $5,786 18,500 700 2,250 250 4,000 $31,486 Liabilities and Stockholders' Equity Current liabilities Accounts payable Income taxes payable Dividends payable Salaries and wages payable Interest payable Notes payable current portion Long-term liabilities Notes payable-long-term portion Total liabilities Stockholders' equity Paid-in capital Preferred stock, 2,800 shares issued and outstanding Common stock, 25,930 shares issued, 25,180 outstanding Retained earnings Total paid-in capital and retained earnings Less: Treasury stock-common (750 shares), at cost Total stockholders' equity Total liabilities and stockholders' equity 6,000 37,486 $14,000 25,930 39,930 72,600 112,530 500 112.030 $149,516 O COOKIE & COFFEE CREATIONS INC. Income Statement Year Ended October 31, 2021 $462,500 231,250 231,250 Sales Revenue Cost of goods sold Gross profit Operating expenses Salaries and wages expense Depreciation expense Other operating expenses Income from operations Other expenses Interest expense Income before income tax Income tax expense Net income $92,500 9,850 35,850 138,200 93,050 550 92,500 18,500 _$74.000
See Answer
Add Answer +20 Points
Community Answer
FR73DU The First Answerer
See all the answers with 1 Unlock
Get 4 Free Unlocks by registration

​​​​​​" {a} 1. current Ratio "=(" current Assets ")/(" current liabilities ")=(59666)/(31486)=1.895Accounts Receivable Turnover Ratio =(" sales ")/(" sebtors ")=(462500)/(3250)=142.308Inventory Turnover =(COGS)/(" Inventory ")=(231250)/(17897)=12.921 4. Debt to Assets Ratio =(" Debt (LTB) ")/(10000)=0.04Debt to Assets Ratio =(" Debt (LTB) ")/(" Total Assets ")=(17897)/(149516)=0.04Times interest Earned =(EB1T)/(" Interest ")=(93050)/(550)=169.182Gross Profit Ratio =(" GP ")/(" sales ")xx100=(231250)/(462500)=50%Profit Margin =(NP)/(" sales ")xx100=(74000)/(462500)=16%Assets turnover =(" sales ")/(" Assets ")=(46 ... See the full answer