Kimmel_Accounting_8e_CCC_Ch13_Financial-Analysis-The-Big-Picture (1)
docx
keyboard_arrow_up
School
Purdue Global University *
*We aren’t endorsed by this school
Course
518
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by SuperHumanNeutronQuetzal29
Continuing Case: Cookie Creations
(Note: This is a continuation of the Cookie Creations from Chapters 1 through 12.)
CCC13 The comparative balance sheet of Cookie & Coffee Creations Inc. at October
31, 2026 for the years 2026 and 2025, and the income statements for the years ended
October 31, 2025 and 2026, are presented below.
COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31
Assets
2026
2025
Cash
$ 29,074
$ 11,550
Accounts receivable
3,250
2,710
Inventory
7,897
7,450
Prepaid expenses
5,800
6,050
Equipment
102,000
75,500
Accumulated depreciation
(25,200)
(9,100)
Total assets
$122,821
$94,160
Liabilities and Stockholders’ Equity
Accounts payable
$ 1,150
$ 2,450
Income taxes payable
9,251
7,200
Dividends payable
27,000
27,000
Salaries and wages payable
7,250
1,280
Interest payable
188
0
Note payable—current portion
4,000
0
Note payable—long-term portion
6,000
0
Preferred stock, no par, $6 cumulative—
3,000 and 2,800 shares issued,
respectively
15,000
14,000
Common stock, $1 par—25,930
shares issued
25,930
25,930
Additional paid in capital—treasury stock
250
0
Retained earnings
26,802
16,800
Less treasury stock
0
(500)
Total liabilities and stockholders’ equity
$122,821
$94,160
COOKIE & COFFEE CREATIONS INC.
Income Statement
Year Ended October 31
2026
2025
Sales
$485,625
$462,500
Cost of goods sold
222,694
208,125
Gross profit
262,931
254,375
Operating expenses
Salaries and wages expense
147,979
146,350
Depreciation expense
17,600
9,100
Other operating expenses
48,186
42,925
Total operating expenses
213,765
198,375
Income from operations
49,166
56,000
Other expenses
Interest expense
413
0
Loss on disposal of plant assets
2,500
0
Total other expenses
2,913
0
Income before income tax
46,253
56,000
Income tax expense
9,251
14,000
Net income
$ 37,002
$ 42,000
Additional information:
Natalie and Curtis are thinking about borrowing an additional $20,000 to buy more
kitchen equipment. The loan would be repaid over a 4-year period. The terms of the
loan provide for equal semi-annual payments of $2,500 on May 1 and November 1 of
each year, plus interest of 5% on the outstanding balance.
Instructions
(a) Calculate the following ratios for 2025 and 2026.
1.
Current ratio
2.
Debt to assets
3.
Gross profit rate
4.
Profit margin
5.
Return on assets (Total assets at November 1, 2024, were $35,180.)
6.
Return on common stockholders’ equity (Total common stockholders’ equity at November 1, 2024, was $25,180. Dividends on preferred stock were $16,800 in 2025 and $18,000 in 2026).
(b) Prepare a horizontal analysis of the income statement for Cookie & Coffee
Creations Inc. using 2025 as a base year.
(c) Prepare a vertical analysis of the income statement for Cookie & Coffee
Creations Inc. for 2026 and 2025.
(d) Comment on your findings from parts (a) to (c).
(e) What impact would borrowing an additional $20,000 to buy more equipment have
on each of the ratios in (a) above, assuming that no changes are expected on the
income statement and balance sheet? Comment on your findings.
(f)
What would justify a decision by Cookie & Coffee Creations Inc. to buy the
additional equipment? What alternatives are there instead of bank financing?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Garnet Company, Inc.
Comparative Statements of Financial Position
As of the year ended December 31, 2022
Assets
Cash
2022
2021
P
94,190.00
P
Accounts receivable
Inventory
Prepaid expenses
55,400.00
131,000.00
62,700.00
70,400.00
154,000.00
34,152.00
19,860.00
Total current assets
314,742.00
306,960.00
Land
157,500.00
157,500.00
Equipment
225,750.00
192,500.00
Accumulated depreciation - Equipment
75,125.00
48,125.00
Buildings
275,000.00
275,000.00
Accumulated depreciation - Buildings
82,550.00
68,750.00
Total
815,317.00 P
815,085.00
Liabilities and Equity
Accounts payable
Long-term notes payable
Ordinary shares, P5 par value
Share Premium
Accumulated Profits and Losses
Treasury shares
Total
41,800.00
47,250.00
270,000.00
360,000.00
?
150,000.00
?
56,415.00
?
250,500.00
?
49,080.00
?
815,085.00
Sales for 2022 were P503,950 and cost of goods sold was 60% of sales.
Furthermore, depreciation for the year was P48,400 and other expenses was P73,100.
During the year, equipment costing P19,000…
arrow_forward
Calculate net profit margin of the year 2019 and 2020
arrow_forward
Brief Exercise 170
Using these data from the comparative balance sheet of Banner Company, perform vertical analysis. (Round answers to 1 decimal place, e.g. 15.2.)
December 31, 2020
December 31, 2019
Amount
Percentage
Amount
Percentage
Accounts Receivable
$ 480,000
%
$ 336,000
%
Inventory
720,000
%
504,000
%
Total Assets
4,000,000
%
2,800,000
%
arrow_forward
view Policies
Current Attempt in Progress
Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal
place, e.g. 12.5%.)
Dec. 31, 2022
Dec. 31, 2021
Amount
Percentage
Amount
Percentage
Accounts receivable
$ 467,400
$ 410,000
Inventory
$ 785,400
%
$ 660,000
%
Total assets
$3,197,900
%
$2,830,000
%
eTextbook and Media
Save for Later
Attempts: 0 of 3 used
Submit Answer
arrow_forward
ect Assignment
The preliminary 2024 income statement of Alexian Systems, Incorporated, is presented below:
ALEXIAN SYSTEMS, INCORPORATED
Income Statement.
For the Year Ended December 31, 2024
($ in millions, except earnings per share)
Revenues and gains:
Sales revenue
Interest revenue
Other income
Total revenues and gains.
Expenses:
Cost of goods sold
Selling and administrative expense
Income tax expense
Total expenses
Net Income
Earnings per share
$ 435
6
128
569
247
158
41
446
$123
$ 12.30
Saved
Help
Additional information:
1. Selling and administrative expense includes $28 million in restructuring costs.
2. Included in other income is $120 million in income from a discontinued operation. This consists of $90 million in operating
income and a $30 million gain on disposal. The remaining $8 million is from the gain on sale of investments.
3. Cost of Goods Sold in 2024 includes an increase of $10 million to correct an understatement of Cost of Goods Sold in 2023. The
amount is material.…
arrow_forward
Carla Vista Co. has these comparative balance sheet data:
CARLA VISTA CO.Balance SheetsDecember 31
2022
2021
Cash
$ 16,140
$ 32,280
Accounts receivable (net)
75,320
64,560
Inventory
64,560
53,800
Plant assets (net)
215,200
193,680
$371,220
$344,320
Accounts payable
$ 53,800
$ 64,560
Mortgage payable (15%)
107,600
107,600
Common stock, $10 par
150,640
129,120
Retained earnings
59,180
43,040
$371,220
$344,320
Additional information for 2022:
1.
Net income was $32,500.
2.
Sales on account were $392,900. Sales returns and allowances amounted to $27,300.
3.
Cost of goods sold was $217,300.
4.
Net cash provided by operating activities was $57,200.
5.
Capital expenditures were $30,000, and cash dividends were $19,000.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
Answer the following requirements on these financial accounting question
arrow_forward
React Corporation
Comparative Statements of Financial Position
December 31, 2025 and 2024
2025
2024
Assets
Current Assets
Cash & Cash Equivalent
106,789
102,375
Trade & Other Receivables
327,611
277,467
Inventory
331,863
297,654
Prepaid Expenses
101,565
114,813
Total Current Assets
870,828
792,309
Noncurrent Assets
Property, Plant & Equipment
Intangibles
135,754
166,481
Total Noncurrent Assets
7,500
7,500
TOTAL ASSETS
143,254
173,981
1,014,082
966,290
Liabilities and Shareholders’ Equity
Current Liabilities
Trade & Other Payables
Unearned Revenues
238,000
208,703
Notes Payables - current
107,508
82,456
Total Current Liabilities
45,000
45,000…
arrow_forward
sa
arrow_forward
Prepare a ratio analysis ( Conclusion only) on each statement
arrow_forward
Need help provide correct answer general accounting
arrow_forward
wbwne not use ai
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Compute the following ratios at December 31, 2020. (Round current ratio and inventory turnover to 2 decimal places, e.g. 1.83…
arrow_forward
Sandhill Co. has these comparative balance sheet data:
SANDHILL CO.Balance SheetsDecember 31
2020
2019
Cash
$ 29,205
$ 58,410
Accounts receivable (net)
136,290
116,820
Inventory
116,820
97,350
Plant assets (net)
389,400
350,460
$671,715
$623,040
Accounts payable
$ 97,350
$ 116,820
Mortgage payable (15%)
194,700
194,700
Common stock, $10 par
272,580
233,640
Retained earnings
107,085
77,880
$671,715
$623,040
Additional information for 2020:
1.
Net income was $34,900.
2.
Sales on account were $378,200. Sales returns and allowances amounted to $29,600.
3.
Cost of goods sold was $204,700.
4.
Net cash provided by operating activities was $57,300.
5.
Capital expenditures were $28,200, and cash dividends were $13,800.
Only the first 3 were answered the last time, I need all of these answered now.
Compute the following ratios at December 31,…
arrow_forward
Provide a Conclusion and Recommendation for the company.
arrow_forward
Subject: financial accounting
arrow_forward
Calculate gross profit ratio for the year 2018 and 2019
arrow_forward
A7
arrow_forward
Kindly help me with general accounting question
arrow_forward
Assets
Current assets
Net fixed assets
INCOME STATEMENT, 2022
(Figures in $ millions)
Revenue
Cost of goods sold
Depreciation
Interest expense
2021
$ 101
2022
$ 195
910 1,010
$ 2,005
1,085
405
251
Req A and B Req C and D
BALANCE SHEET AT END OF YEAR
(Figures in $ millions)
Liabilities and Shareholders' Equity
Current liabilities
Long-term debt
Req E
Complete this question by entering your answers in the tabs below.
a&b. What is shareholders' equity in 2021 and 2022?
c&d. What is net working capital in 2021 and 2022?
e. What are taxes paid in 2022? Assume the firm pays taxes equal to 21% of taxable income.
f. What is cash provided by operations during 2022?
g.Net fixed assets increased from $910 million to $1,010 million during 2022. What must have been South Sea's gross investment in
fixed assets during 2022?
Answer is complete but not entirely correct.
h. If South Sea reduced its outstanding accounts payable by $46 million during the year, what must have happened to its other current…
arrow_forward
Cullumber Company has these comparative balance sheet data:
CULLUMBER COMPANYBalance SheetsDecember 31
2022
2021
Cash
$ 16,350
$ 32,700
Accounts receivable (net)
76,300
65,400
Inventory
65,400
54,500
Plant assets (net)
218,000
196,200
$376,050
$348,800
Accounts payable
$ 54,500
$ 65,400
Mortgage payable (15%)
109,000
109,000
Common stock, $10 par
152,600
130,800
Retained earnings
59,950
43,600
$376,050
$348,800
Additional information for 2022:
1.
Net income was $34,000.
2.
Sales on account were $383,300. Sales returns and allowances amounted to $26,600.
3.
Cost of goods sold was $200,600.
4.
Net cash provided by operating activities was $59,000.
5.
Capital expenditures were $26,400, and cash dividends were $16,500.
Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…
arrow_forward
Cullumber Company has these comparative balance sheet data:
CULLUMBER COMPANYBalance SheetsDecember 31
2022
2021
Cash
$ 16,350
$ 32,700
Accounts receivable (net)
76,300
65,400
Inventory
65,400
54,500
Plant assets (net)
218,000
196,200
$376,050
$348,800
Accounts payable
$ 54,500
$ 65,400
Mortgage payable (15%)
109,000
109,000
Common stock, $10 par
152,600
130,800
Retained earnings
59,950
43,600
$376,050
$348,800
Additional information for 2022:
1.
Net income was $34,000.
2.
Sales on account were $383,300. Sales returns and allowances amounted to $26,600.
3.
Cost of goods sold was $200,600.
4.
Net cash provided by operating activities was $59,000.
5.
Capital expenditures were $26,400, and cash dividends were $16,500.
(d)
Inventory turnover.
enter inventory turnover in times rounded to 2 decimal places
times
(e)…
arrow_forward
can you help me fill out my journal
arrow_forward
General Account
arrow_forward
Need help with this question
arrow_forward
return on Assets Sue Company reports the following information in its financial statements. Numbers are in thousands. 2019 2018Net Sales $42,075 $44,100Net Income 12,780 15,732Total Assets 63,900 87,400
There were 5,000 outstanding shares at December 31, 2019.Required
a. What was Sue's return on assets for 2019 and 2019? (Round to one decimal point)
arrow_forward
Photo from shiyalsuresh901
arrow_forward
Alpesh
arrow_forward
General accounting question
arrow_forward
Calculate the Horizontal (Trend) Analysis and horizontal analysis % change for the year 2020, 2019, 2020
Please use excel to calculate the formula
Thank you!
Toyota Motor Corporation
Consolidated Balance Sheet
2020
2019
2018
Assets
Current Assets
Cash and Cash equivalents
4190518
3574704
3,052,269
Time Deposits
828220
1126352
901244
Marketable securities
678731
1127160
1768360
Trade accounts and notes recievables
2094894
2372734
2219562
less A.F.D.A.
Finance receivables, net
6614171
6647771
6438306
Other recievables
564854
568156
489338
Inventories
2434918
2656396
2539789
Prepaid expenses and other current assets
1236225
805964
833788
Total current assets
18642531
18879237
18,242,656
Noncurrent finance recievables, net
10423858
10281118
9481618
Investments and other assets:
Marketable…
arrow_forward
Har
Please give me correct answer with explanation
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Garnet Company, Inc. Comparative Statements of Financial Position As of the year ended December 31, 2022 Assets Cash 2022 2021 P 94,190.00 P Accounts receivable Inventory Prepaid expenses 55,400.00 131,000.00 62,700.00 70,400.00 154,000.00 34,152.00 19,860.00 Total current assets 314,742.00 306,960.00 Land 157,500.00 157,500.00 Equipment 225,750.00 192,500.00 Accumulated depreciation - Equipment 75,125.00 48,125.00 Buildings 275,000.00 275,000.00 Accumulated depreciation - Buildings 82,550.00 68,750.00 Total 815,317.00 P 815,085.00 Liabilities and Equity Accounts payable Long-term notes payable Ordinary shares, P5 par value Share Premium Accumulated Profits and Losses Treasury shares Total 41,800.00 47,250.00 270,000.00 360,000.00 ? 150,000.00 ? 56,415.00 ? 250,500.00 ? 49,080.00 ? 815,085.00 Sales for 2022 were P503,950 and cost of goods sold was 60% of sales. Furthermore, depreciation for the year was P48,400 and other expenses was P73,100. During the year, equipment costing P19,000…arrow_forwardCalculate net profit margin of the year 2019 and 2020arrow_forwardBrief Exercise 170 Using these data from the comparative balance sheet of Banner Company, perform vertical analysis. (Round answers to 1 decimal place, e.g. 15.2.) December 31, 2020 December 31, 2019 Amount Percentage Amount Percentage Accounts Receivable $ 480,000 % $ 336,000 % Inventory 720,000 % 504,000 % Total Assets 4,000,000 % 2,800,000 %arrow_forward
- view Policies Current Attempt in Progress Using these data from the comparative balance sheet of Cullumber Company, perform vertical analysis. (Round percentages to 1 decimal place, e.g. 12.5%.) Dec. 31, 2022 Dec. 31, 2021 Amount Percentage Amount Percentage Accounts receivable $ 467,400 $ 410,000 Inventory $ 785,400 % $ 660,000 % Total assets $3,197,900 % $2,830,000 % eTextbook and Media Save for Later Attempts: 0 of 3 used Submit Answerarrow_forwardect Assignment The preliminary 2024 income statement of Alexian Systems, Incorporated, is presented below: ALEXIAN SYSTEMS, INCORPORATED Income Statement. For the Year Ended December 31, 2024 ($ in millions, except earnings per share) Revenues and gains: Sales revenue Interest revenue Other income Total revenues and gains. Expenses: Cost of goods sold Selling and administrative expense Income tax expense Total expenses Net Income Earnings per share $ 435 6 128 569 247 158 41 446 $123 $ 12.30 Saved Help Additional information: 1. Selling and administrative expense includes $28 million in restructuring costs. 2. Included in other income is $120 million in income from a discontinued operation. This consists of $90 million in operating income and a $30 million gain on disposal. The remaining $8 million is from the gain on sale of investments. 3. Cost of Goods Sold in 2024 includes an increase of $10 million to correct an understatement of Cost of Goods Sold in 2023. The amount is material.…arrow_forwardCarla Vista Co. has these comparative balance sheet data: CARLA VISTA CO.Balance SheetsDecember 31 2022 2021 Cash $ 16,140 $ 32,280 Accounts receivable (net) 75,320 64,560 Inventory 64,560 53,800 Plant assets (net) 215,200 193,680 $371,220 $344,320 Accounts payable $ 53,800 $ 64,560 Mortgage payable (15%) 107,600 107,600 Common stock, $10 par 150,640 129,120 Retained earnings 59,180 43,040 $371,220 $344,320 Additional information for 2022: 1. Net income was $32,500. 2. Sales on account were $392,900. Sales returns and allowances amounted to $27,300. 3. Cost of goods sold was $217,300. 4. Net cash provided by operating activities was $57,200. 5. Capital expenditures were $30,000, and cash dividends were $19,000. Compute the following ratios at December 31, 2022. (Round current ratio and inventory turnover to 2 decimal…arrow_forward
- Answer the following requirements on these financial accounting questionarrow_forwardReact Corporation Comparative Statements of Financial Position December 31, 2025 and 2024 2025 2024 Assets Current Assets Cash & Cash Equivalent 106,789 102,375 Trade & Other Receivables 327,611 277,467 Inventory 331,863 297,654 Prepaid Expenses 101,565 114,813 Total Current Assets 870,828 792,309 Noncurrent Assets Property, Plant & Equipment Intangibles 135,754 166,481 Total Noncurrent Assets 7,500 7,500 TOTAL ASSETS 143,254 173,981 1,014,082 966,290 Liabilities and Shareholders’ Equity Current Liabilities Trade & Other Payables Unearned Revenues 238,000 208,703 Notes Payables - current 107,508 82,456 Total Current Liabilities 45,000 45,000…arrow_forwardsaarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning