5-2 Final Project Milestone Two- Analysis of Financial Statements
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
610
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by sherrybabe96
1
Milestone 2
5-2 Final Project Milestone Two: Analysis of Financial Statements
Sherry Gerges
Southern New Hampshire University
ACC 610: Financial Reporting 1
Professor: Dr. Stephen Weiss
January 14
th
, 2024
2
Milestone 2
In this paper, we will discuss the changes in the financial ratios of Costco in the past few years. We will also look at the changes in the financial reports regarding cash and the accounts receivable account balance. We will also touch base on the type of inventory valuation method that Costco uses and explain why it uses this method and what the benefits are. Lastly, we will predict how Costco will perform in the following year compared to its competitors. Financial Ratios
From 2019 to 2023, Costco’s net earnings per share increased significantly. In 2019, their
EPS was $8.26 and as of 2023, it went up to $14.16, which is a $5.90 increase (Costco EPS - Earnings per Share 2010-2023 | COST, n.d.). This indicated a growth in profitability for each share of stock. On the other hand, their gross margin from 2019 was 13.05% and in 2023 it was 12.37% (Costco EPS - Earnings per Share 2010-2023 | COST, n.d.). This decrease implies that there may have been a change in the costs of sales for Costco. Cash
Based on the cash flow statements I have analyzed we can see that there has been an increase in Costco’s net cash flow throughout the years. In 2019, Costco had a net cash flow of $2,329 million and in 2023 they have $3,497 million in cash flow (Costco EPS - Earnings per Share 2010-2023 | COST, n.d.). This shows that they have been able to increase their cash flow through the years which suggests that liquid assets have increased. This means that the company is thriving and based on these trends we can see that Costco will continue to succeed. Account Balance
Although Costco hit one of the lowest amounts in their 2019 accounts receivable, $1.535 billion, Costco hit one of their highest amounts in 2023, $2.542 billion (The Complete Toolbox
3
Milestone 2
for Investors | Finbox.com, n.d.). This increase indicates that more people used credit to pay for their goods which could negatively impact the cash flow for the company. Valuation Method
Costco uses the just-in-time (JIT) inventory valuation method “which minimizes excess inventory and reduces carrying costs. JIT allows the company to keep inventory levels low while
maintaining high product availability” (Haghdadeh, 2023). With this method, Costco can see what the sales trends are and adjust their inventory, accordingly, allowing for the inventory to arrive just in time for the demand of the customers. There are a few benefits to using this method
for Costco including reducing warehouse space requirements, lowering holding costs, and minimizing the risk of inventory uselessness (Haghdadeh, 2023). Also, by using the just-in-time inventory valuation method, Costco can “respond quickly to changing market demands and optimize its inventory turnover rate” (Haghdadeh, 2023). All of this is important to be able to meet the demands of the customers as well as keep the company moving in the right direction.
Predict
Based on the industry trends, plans of Costco, and the information I have gathered, I believe there is a bright future ahead for Costco. Costco has been booming in sales compared to its competitors because of the prices they offer to its customers as well as the many services available to them. This year, 2024, we will continue to see an increase in their cash flow, just as there has been from 2019-2023. The financial statements that I reviewed, shows that the just-in-
time inventory valuation method is the best method for Costco to be using for the market they are working with.
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
4
Milestone 2
References
Costco EPS - Earnings per share 2010-2023 | COST
. (n.d.). MacroTrends.
https://www.macrotrends.net/stocks/charts/COST/costco/eps-earnings-per-
share-diluted#:~:text=Costco%202023%20annual%20EPS%20was,a
%2024.94%25%20increase%20from%202020
.
Haghdadeh, P. (2023, October 11). Costco Supply Chain: Efficiency, and Sustainability 2023.
DFreight
. https://dfreight.org/blog/costco-supply-chain-efficiency-sustainability/
#:~:text=reducing%20lead%20times.-,Just%2Din%2DTime%20Inventory
%20Management,while%20maintaining%20high%20product%20availability.
The complete toolbox for investors | Finbox.com
. (n.d.). https://finbox.com/NASDAQGS:COST/explorer/ar/#:~:text=Costco
%20Wholesale%27s%20accounts%20receivable%2C%20net%20decreased%20in
%202019%20(1.535%20billion,2.285%20billion%2C%20%2B2.0%25).
Related Documents
Related Questions
B ch01 (Fall 2021
w https://education.wiley.
B Present Value Tables (1.
Final Exam (Fall 2020)
- Final Exam (Fall 2020)
-/6
Question 24 of 50
View Policies
Current Attempt in Progress
Sheridan Manufacturing Company expects the following sales in January, February, and March:
Cash
Credit
Sales
Sales
$50900
$250500
January
February
$45900
$240500
March
$85000
$325000
The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month
after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from
customers in March?
O $352150
O $364675
O $410000
O $279675
Save for Later
Attempts: 0 of 1 used
Submit Answer
MacBook Air
esc
888
FT
F2
F3
F4
F5
F6
F7
F8
@
#
2$
4
&
*
6.
7
8.
Q
W
arrow_forward
Question 8 of 8
-/ 20
View Policies
Current Attempt in Progress
Select financial information from Marshall Inc. is shown below:
2022
2021
Receivables
$423,018
$376,089
less allowance for doubtful accounts
45,890
32,236
Receivables, net
377,128
343,853
Credit sales
5,245,000
4,846,300
Calculate the receivables turnover and the collection period for 2022. (Round answers to 1 decimal place, e.g. 12.3.)
Receivables Turnover Ratio
times
Average Collection Period
days
Save for Later
Attempts: 0 of 1 used
Submit Answer
II
arrow_forward
2
arrow_forward
Financial accounting question
arrow_forward
Part 2 please
arrow_forward
Net sales
Cost of goods sold
Gross profit
Expenses:
Operating expenses
Depreciation expense
Loss on sale of land.
Interest expense
VIRTUAL GAMING SYSTEMS
Income Statements
For the Years Ended December 31
Income tax expense
Total expenses
Net income.
Assets
Current assets:
Cash
Accounts receivable
Inventory
Prepaid rent
Long-term assets:
Investment in bonds
Land
Equipment
Less: Accumulated depreciation
Total assets
Liabilities and Stockholders' Equity
Current liabilities:
Accounts payable
Interest payable
Income tax payable
Long-term liabilities:
Notes payable
2025
$3,495,000
2,477,000
1,018,000
952,000
27,000
Stockholders' equity:
Common stock
Retained earnings
Total liabilities and stockholders' equity
16,500
7,700
1,003, 200
14,800
2024
$3,021,000
1,947,000
1,074,000
VIRTUAL GAMING SYSTEMS
Balance Sheets
December 31
855,000
25,500
7,700
13,500
46,500
948,200
125,800
2025
$199,500
73,500
123,500
13,700
102,000
297,000
297,000
(91,500)
$1,014,700
$213,600
8,100
11,700
370,000
297,000…
arrow_forward
Pls General Accounting Question Solution
arrow_forward
please answer and explain with all workings
arrow_forward
Problem #1
The following balance sheet and income statement data is given:
31-Dec
Yr 2021
Yr 2020
Cash
$4,300
$3,700
Accounts receivable (net)
22,000
23,400
Inventories
10,000
7,000
Plant assets (net)
75,000
86,000
Total assets
111,300
120,100
Accounts payable
12,370
11,100
Bonds payable
70,000
70,000
Total liabilities
82,370
81,100
Common stock, $10 par
65,000
59,000
Paid-in capital
10,000
10,000
Retained earnings
24,300
20,600
Total stockholders’ equity
99,300
89,600
Net credit sales
100,000
Cost of goods sold
60,350
Gross profit
39,650
Net income
14,000
REQUIRED:
Compute the following ratios for 2021.
NOTE: Copy and paste the information below into the answer box first and then show your calculation steps for this problem to receive credits.
(1) Accounts receivable turnover=____________________
(2) Inventory turnover=__________________
(3) Accounts payable…
arrow_forward
How do I calculate:
Sales per day
Accounts receivable new policy
Freed-up cash
arrow_forward
1
nts
eBook
→
Print
5
eferences
Mc
Graw
Hill
Sales
Cost of goods sold
Accounts receivable
2021:
2020:
2019:
Numerator:
Base year cost of goods sold
2021
$ 719,206
376,387
34,953
Numerator:
Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the
situation as revealed by the trend percents appears to be favorable or unfavorable.
Numerator:
2018:
2017:
Is the trend percent for Net Sales favorable or unfavorable?
2020
$ 467,017
244,349
27,274
Trend Percent for Net Sales:
1
Denominator:
/Base year accounts receivable
1
1
7
/
1
1
1
1
1
Trend Percent for Cost of Goods Sold:
1
Denominator:
2021:
2020:
2019:
2018:
2017:
Is the trend percent for Cost of Goods Sold favorable or unfavorable?
2019
$ 379,689
200,588
26,085
1
1
7
1
Trend Percent for Accounts Receivable:
Denominator:
2021:
2020:
2019:
2018:
2017:
1
Is the trend percent for Accounts Receivable favorable or unfavorable?
1
2018
$ 253,126
132,876
14,808
=
=
=
=
=
=
=
=…
arrow_forward
Hi expert please give me answer general accounting question
arrow_forward
Hello-
Is there a way to get Times inteset earned using the attached data.
Please advise.
Thanks,
Ityla Lungu
773.780.7930
arrow_forward
Do fast answer of this question solution general accounting
arrow_forward
Need help with this question solution general accounting
arrow_forward
I want to correct answer general accounting question
arrow_forward
ACC 122 Fall 2020Comprehensive ProjectBestValue Corporation's Trial Balance at December 31, 20XX is presented below.All 20XX transactions have been recorded except for the items described on the next page.Debit CreditCash $ 109,890Accounts Receivable 28,789Inventory 25,540Debt Investments 0Land 55,674Buildings 215,850Equipment 75,120Allowance for Doubtful Accounts $ 1,027Accumulated Depreciation-Buildings 63,306Accumulated Depreciation-Equipment 16,048Accounts Payable 35,278Interest Payable 0Unearned Rent Revenue 48,900Dividends Payable 0Income Tax Payable 0Bonds Payable 0Discount on Bonds Payable 0Common Stock ($2 par) 29,200Paid in Capital in Excess of Par-Common Stock 44,580Preferred Stock ($60 par) 0Paid in Capital in Excess of Par-Preferred Stock 0Retained Earnings 107,904Treasury Stock 0Cash Dividends 0Sales Revenue 776,068Rent Revenue 0Gain on Sale of Land 0Bad Debt Expense 0Interest Expense 0Cost of Goods Sold 478,542Depreciation Expense 0Other Operating Expenses 53,274Salaries…
arrow_forward
Domestic
arrow_forward
plzz answer it properly
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- B ch01 (Fall 2021 w https://education.wiley. B Present Value Tables (1. Final Exam (Fall 2020) - Final Exam (Fall 2020) -/6 Question 24 of 50 View Policies Current Attempt in Progress Sheridan Manufacturing Company expects the following sales in January, February, and March: Cash Credit Sales Sales $50900 $250500 January February $45900 $240500 March $85000 $325000 The controller has determined that the company collects credit sales as follows: 60% in the month of sale, 30% in the first month after sale, 5% in the second month after sale, and 5% is expected to be uncollectible. How much cash will be collected from customers in March? O $352150 O $364675 O $410000 O $279675 Save for Later Attempts: 0 of 1 used Submit Answer MacBook Air esc 888 FT F2 F3 F4 F5 F6 F7 F8 @ # 2$ 4 & * 6. 7 8. Q Warrow_forwardQuestion 8 of 8 -/ 20 View Policies Current Attempt in Progress Select financial information from Marshall Inc. is shown below: 2022 2021 Receivables $423,018 $376,089 less allowance for doubtful accounts 45,890 32,236 Receivables, net 377,128 343,853 Credit sales 5,245,000 4,846,300 Calculate the receivables turnover and the collection period for 2022. (Round answers to 1 decimal place, e.g. 12.3.) Receivables Turnover Ratio times Average Collection Period days Save for Later Attempts: 0 of 1 used Submit Answer IIarrow_forward2arrow_forward
- Financial accounting questionarrow_forwardPart 2 pleasearrow_forwardNet sales Cost of goods sold Gross profit Expenses: Operating expenses Depreciation expense Loss on sale of land. Interest expense VIRTUAL GAMING SYSTEMS Income Statements For the Years Ended December 31 Income tax expense Total expenses Net income. Assets Current assets: Cash Accounts receivable Inventory Prepaid rent Long-term assets: Investment in bonds Land Equipment Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Current liabilities: Accounts payable Interest payable Income tax payable Long-term liabilities: Notes payable 2025 $3,495,000 2,477,000 1,018,000 952,000 27,000 Stockholders' equity: Common stock Retained earnings Total liabilities and stockholders' equity 16,500 7,700 1,003, 200 14,800 2024 $3,021,000 1,947,000 1,074,000 VIRTUAL GAMING SYSTEMS Balance Sheets December 31 855,000 25,500 7,700 13,500 46,500 948,200 125,800 2025 $199,500 73,500 123,500 13,700 102,000 297,000 297,000 (91,500) $1,014,700 $213,600 8,100 11,700 370,000 297,000…arrow_forward
- Pls General Accounting Question Solutionarrow_forwardplease answer and explain with all workingsarrow_forwardProblem #1 The following balance sheet and income statement data is given: 31-Dec Yr 2021 Yr 2020 Cash $4,300 $3,700 Accounts receivable (net) 22,000 23,400 Inventories 10,000 7,000 Plant assets (net) 75,000 86,000 Total assets 111,300 120,100 Accounts payable 12,370 11,100 Bonds payable 70,000 70,000 Total liabilities 82,370 81,100 Common stock, $10 par 65,000 59,000 Paid-in capital 10,000 10,000 Retained earnings 24,300 20,600 Total stockholders’ equity 99,300 89,600 Net credit sales 100,000 Cost of goods sold 60,350 Gross profit 39,650 Net income 14,000 REQUIRED: Compute the following ratios for 2021. NOTE: Copy and paste the information below into the answer box first and then show your calculation steps for this problem to receive credits. (1) Accounts receivable turnover=____________________ (2) Inventory turnover=__________________ (3) Accounts payable…arrow_forward
- How do I calculate: Sales per day Accounts receivable new policy Freed-up casharrow_forward1 nts eBook → Print 5 eferences Mc Graw Hill Sales Cost of goods sold Accounts receivable 2021: 2020: 2019: Numerator: Base year cost of goods sold 2021 $ 719,206 376,387 34,953 Numerator: Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Numerator: 2018: 2017: Is the trend percent for Net Sales favorable or unfavorable? 2020 $ 467,017 244,349 27,274 Trend Percent for Net Sales: 1 Denominator: /Base year accounts receivable 1 1 7 / 1 1 1 1 1 Trend Percent for Cost of Goods Sold: 1 Denominator: 2021: 2020: 2019: 2018: 2017: Is the trend percent for Cost of Goods Sold favorable or unfavorable? 2019 $ 379,689 200,588 26,085 1 1 7 1 Trend Percent for Accounts Receivable: Denominator: 2021: 2020: 2019: 2018: 2017: 1 Is the trend percent for Accounts Receivable favorable or unfavorable? 1 2018 $ 253,126 132,876 14,808 = = = = = = = =…arrow_forwardHi expert please give me answer general accounting questionarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you