Analysis5
docx
keyboard_arrow_up
School
Central Washington University *
*We aren’t endorsed by this school
Course
201
Subject
Accounting
Date
Jul 2, 2024
Type
docx
Pages
1
Uploaded by DukeGiraffePerson709
Colten Reed
October 29 2023
Analysis 5
Analysis
Introduction
In this assignment I was ordered to look over the Balance Sheet for both Apple and Microsoft from the year 2019. We collected the data from the areas Cash, Accounts
Receivable, Inventory, Current Assets, and Current Liabilities. In the other section we calculated the Working Capital, Current Ratio, and Quick Ratio. The results were pretty surprising and they included very high numbers in the 100 millions. Comparison
After finding the results of each of these companies I found that Apple held 48,844 in cash while Microsoft only had 11,356 in cash. It is important to note that these
numbers represent millions. Apple had 162,819 in Current Assets and held 105,718 in Current Liabilities. I was surprised to see that Microsoft had 175,552 in Current Assets while only having 69,420 in Current Liabilities and still having less cash than Apple. Working Capital
Working Capital is your Current assets subtracted by your Current Liabilities. Microsoft's Working Capital would be 175,552 - 69,420 which equals 106,132. Apple's Working Capital was 162,819 - 105,718 which equals 57,101. From the results you can see Microsoft had much more money in their Working Capital than Apple did. Current Ratio
The Current Ratio is your Current Assets divided by your Current Liabilities. Apple's Current Ratio would be 162,819 divided by 105,718 which equals to 1.54. Microsoft has a current ratio of 2.53 and they would divide 175,552 by 69,420 to get that
calculation. Microsoft's Current Ratio is much better than Apples. Quick Ratio
The Quick Ratio is your Quick Assets divided by your Current Liabilities. Microsoft would calculate 175,552 - 2,063.00 divided by 69,420 to get a ratio of 2.50. Apple would take 162,819 - 4,106 and divide it by 105,718 to get the ratio of 1.50. This seems to by the Current Ratio rounded down to the nearest thousandth. Conclusion
Overall this assignment taught me new equations to get answers from the Balance Sheets. Though Apple has more cash Microsoft held much more assets and had substantially less liabilities than Apple. I learned how to find Working Capital and Current and Quick Ratios which are great to understand because they are important parts of the Balance Sheet.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Calculate the average life, average age, and asset turnover ratios for Exxon Mobil. Discuss what each ratio tells you in the context of your chosen company. Calculate the accounts receivable turnover ratio and convert that ratio into days. Discuss what each ratio tells you in the context of your chosen company.
Assets
Fiscal year is January-December. All values USD millions.
2018
2019
Cash & Short Term Investments
3.04B
3.09B
Cash Only
3.04B
3.09B
Short-Term Investments
-
-
Total Accounts Receivable
24.7B
26.97B
Accounts Receivables, Net
19.64B
21.1B
Accounts Receivables, Gross
20.04B
21.51B
Bad Debt/Doubtful Accounts
(400M)
(405M)
Other Receivables
5.06B
5.87B
Inventories
18.96B
18.53B
Finished Goods
14.8B
14.01B
Work in Progress
-
-
Raw Materials
4.16B
4.52B
Progress Payments & Other
-
-
Other Current Assets
1.27B
1.47B…
arrow_forward
question 9
arrow_forward
Adobe PDF
Signatures
Files
cont
Paragraph
Styles
Adobe Acrobat
Voice
Sensitivity
Reuse Files
oblems
1. Danka Corporation collected a $200,000 accounts receivable. What impact will this transaction
have on working capital? (Hint: Think of the horizontal equation entry for the collection of
accounts receivable and what accounts that will impact)
O Focus
203%
1:19 AM
search
50°F
10/28/2021
arrow_forward
Section 5: Problem for solving
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
Hello Tutor,
I have completed the following question. Can you verify if it is correct? Thank you.
[2] Using comparative analysis on Balance sheet
ABC Inc., Balance Sheet
Assets
2020
2019
Difference
% changed
Cash
$ 70,000
$ 51,000
Account Receivable
55,000
30,000
Inventory
75,000
61,000
Prepaid Insurance
12,000
12,000
Short term investment
65,000
50,000
Note Receivable
23,000
38,000
Investments
55,000
85,000
Equipment
70,000
48,000
Building
145,000
145,000
Land
40,000
25,000
Total Assets
$610,000
$545,000
Liabilities…
arrow_forward
11
arrow_forward
i need the answer quickly
arrow_forward
View Policies
Current Attempt in Progress
On June 1, 2022, Pharoah Company was started with an initial investment in the company of $21,250 cash. Here are the assets,
liabilities, and common stock of the company at June 30, 2022, and the revenues and expenses for the month of June, its first month of
operations:
Cash
Accounts receivable
Service revenue
Supplies
Advertising expense
Equipment
Common stock
$ 5,600
4,400
8,500
2,342
(a1)
400
26,800
21,250
Notes payable
Accounts payable
Supplies expense
Maintenance and repairs expense
Utilities expense
Salaries and wages expense
Prepare an income statement for the month of June.
PHAROAH COMPANY
Income Statement
During June, the company issued no additional stock but paid dividends of $1,683.
LA
$14,000
पी
900
1,125
690
210
1,400
$
arrow_forward
Hello tutor provide answer this financial 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
Task 2:
Evaluate the company's efficiency in collecting its accounts receivable during the fiscal year ended 31
December 2021. Use the company's information from its annual reports:
Receivables as of 31 December 2020
$4,468,392
$4,972,722
$45,349,943
Receivables as of 31 December 2021
Sales revenue for year ended 31 December 2021
1. Calculate the company's number of days of sales outstanding (DSO) for the fiscal year ended 31
December 2021. (Use the average receivables to calculate the ratio).
Not
Accounting receivable
Average
Day's sales in receivable = 154;
2. Interpret the calculated ratio.
3. Assume that the industry average DSO ratio is 60 days. Based on this information and the subject
company's DSO ratio, critically evaluate the company's credit policy and its implications.
arrow_forward
Provide correct answer financial accounting question
arrow_forward
Kindly help me with accounting questions
arrow_forward
Get correct answer general accounting
arrow_forward
Vishnu
arrow_forward
Use the table for the questions below.
Consider the following balance sheets:
PharmPic
DosageDoc
Reported Dec. 31,
2020
2021
2020
2021
Assets
Cash
224,224
200,400
301,540
230,876
Accounts Receivable
129,000
118,125
130,316
110,345
Inventories
154,890
171,147
184,717
186,000
Total Current Assets
508,114
489,672
616,573
527,221
Net Property Plant & Equipt.
421,162
431,795
456,462
460,000
Patents and Trademarks
212,770
210,110
201,348
199,990
Total Assets
1,142,046
1,131,577
1,274,383
1,187,211
Liabilities and Stockholders' Equity:
Short Term Borrowings (Bank)
257,000
264,023
302,453
270,000
Accounts Payable
212,900
209,000
267,004
225,000
Current Portion of LTD (Interest Bearing Debt)
39,532
29,081
32,611
46,048
Total Current Liabilities
509,432
502,104
602,068…
arrow_forward
Please help me with all answers thanku
arrow_forward
Problem 19: Laiho Industries’s 2017 and 2018 balance sheets (in thousands of dollars are shown).
Please show all work, and if using Excel please show the Excel sheet and all work!! All work includes showing formulas and how you got each part of the formula.
a. Sales for 2018 were $455,150,000, and EBITDA was 15% of sales. Furthermore, depreciation and amortization were 11% of net fixed assets, interest was $8,575,000, the corporate tax rate was 40%, and Laiho pays 40% of its net income as dividends. Given this information, construct the firm’s 2018 income statement.
b. Construct the statement of stockholders’ equity for the year ending December 31, 2018, and the 2018 statement of cash flows.
c. Calculate 2017 and 2018 net operating working capital (NWOC) and 2018 free cash flow (FCF). Assume the firm has no excess cash.
d. If Laiho increased its dividend payout ratio, what effect would this have on corporate taxes paid? What effect would this have on taxes paid by the company’s…
arrow_forward
Pls answer the all questions with solutions. Thank you
arrow_forward
financial Accounting question
arrow_forward
Hi this is one question. The excel sheet is the data to answer the question
arrow_forward
Give me true answer financial accounting question
arrow_forward
Hi this is one question. The excel sheet is the data to answer the question
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- Calculate the average life, average age, and asset turnover ratios for Exxon Mobil. Discuss what each ratio tells you in the context of your chosen company. Calculate the accounts receivable turnover ratio and convert that ratio into days. Discuss what each ratio tells you in the context of your chosen company. Assets Fiscal year is January-December. All values USD millions. 2018 2019 Cash & Short Term Investments 3.04B 3.09B Cash Only 3.04B 3.09B Short-Term Investments - - Total Accounts Receivable 24.7B 26.97B Accounts Receivables, Net 19.64B 21.1B Accounts Receivables, Gross 20.04B 21.51B Bad Debt/Doubtful Accounts (400M) (405M) Other Receivables 5.06B 5.87B Inventories 18.96B 18.53B Finished Goods 14.8B 14.01B Work in Progress - - Raw Materials 4.16B 4.52B Progress Payments & Other - - Other Current Assets 1.27B 1.47B…arrow_forwardquestion 9arrow_forwardAdobe PDF Signatures Files cont Paragraph Styles Adobe Acrobat Voice Sensitivity Reuse Files oblems 1. Danka Corporation collected a $200,000 accounts receivable. What impact will this transaction have on working capital? (Hint: Think of the horizontal equation entry for the collection of accounts receivable and what accounts that will impact) O Focus 203% 1:19 AM search 50°F 10/28/2021arrow_forward
- Section 5: Problem for solvingarrow_forwardHello- Is there a way to get Times inteset earned using the attached data. Please advise. Thanks, Ityla Lungu 773.780.7930arrow_forwardHello Tutor, I have completed the following question. Can you verify if it is correct? Thank you. [2] Using comparative analysis on Balance sheet ABC Inc., Balance Sheet Assets 2020 2019 Difference % changed Cash $ 70,000 $ 51,000 Account Receivable 55,000 30,000 Inventory 75,000 61,000 Prepaid Insurance 12,000 12,000 Short term investment 65,000 50,000 Note Receivable 23,000 38,000 Investments 55,000 85,000 Equipment 70,000 48,000 Building 145,000 145,000 Land 40,000 25,000 Total Assets $610,000 $545,000 Liabilities…arrow_forward
- 11arrow_forwardi need the answer quicklyarrow_forwardView Policies Current Attempt in Progress On June 1, 2022, Pharoah Company was started with an initial investment in the company of $21,250 cash. Here are the assets, liabilities, and common stock of the company at June 30, 2022, and the revenues and expenses for the month of June, its first month of operations: Cash Accounts receivable Service revenue Supplies Advertising expense Equipment Common stock $ 5,600 4,400 8,500 2,342 (a1) 400 26,800 21,250 Notes payable Accounts payable Supplies expense Maintenance and repairs expense Utilities expense Salaries and wages expense Prepare an income statement for the month of June. PHAROAH COMPANY Income Statement During June, the company issued no additional stock but paid dividends of $1,683. LA $14,000 पी 900 1,125 690 210 1,400 $arrow_forward
- Hello tutor provide answer this financial accounting questionarrow_forwardCalculate 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_forwardTask 2: Evaluate the company's efficiency in collecting its accounts receivable during the fiscal year ended 31 December 2021. Use the company's information from its annual reports: Receivables as of 31 December 2020 $4,468,392 $4,972,722 $45,349,943 Receivables as of 31 December 2021 Sales revenue for year ended 31 December 2021 1. Calculate the company's number of days of sales outstanding (DSO) for the fiscal year ended 31 December 2021. (Use the average receivables to calculate the ratio). Not Accounting receivable Average Day's sales in receivable = 154; 2. Interpret the calculated ratio. 3. Assume that the industry average DSO ratio is 60 days. Based on this information and the subject company's DSO ratio, critically evaluate the company's credit policy and its implications.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning