ACC 345 Project Workbook Ashley Ohlsen

.xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

345

Subject

Statistics

Date

Jan 9, 2024

Type

xlsx

Pages

29

Uploaded by DrLobsterPerson324 on coursehero.com

2018 2019 Assets Current Assets Cash and Cash Equivalents $ 31,750.00 $ 36,092.00 Accounts Receivable Net $ 16,677.00 $ 20,816.00 Inventory $ 17,174.00 $ 20,497.00 Other Current Assets $ 9,500.00 $ 18,929.00 Total Current Assets $ 75,101.00 $ 96,334.00 Non-Current Assets Property, Plant, and Equipment Net $ 61,797.00 $ 72,705.00 Intangibles $ 14,548.00 $ 14,754.00 Other Assets $ 11,202.00 $ 41,455.00 Total Non-Current/Fixed Assets $ 87,547.00 $ 128,914.00 Total Assets $ 162,648.00 $ 225,248.00 Liabilities and Owners' Equity Current Liabilities Accounts Payable $ 38,192.00 $ 47,183.00 Accrued Expenses and Other Current Liabilities $ 23,663.00 $ 32,439.00 Current Portion of Debt and Leases $ 6,536.00 $ 8,190.00 Total Current Liabilities $ 68,391.00 $ 87,812.00 Long-Term Liabilities Long-Term Debt and Lease Obligations $ 23,495.00 $ 23,414.00 Other Long-Term Liabilities $ 27,213.00 $ 51,962.00 Total Long-Term Liabilities $ 50,708.00 $ 75,376.00 Total Liabilities $ 119,099.00 $ 163,188.00 Owners' Equity Common Stock, Less Treasury $ (1,832.00) $ (1,832.00) Additional Paid in Capital $ 26,791.00 $ 33,658.00 Retained Earnings $ 19,625.00 $ 31,220.00 Other Equity $ (1,035.00) $ (986.00) Total Equity $ 43,549.00 $ 62,060.00
Total Liabilities & Equity $ 162,648.00 $ 225,248.00 $ - $ - Check Digit: This should be 0 or the balance sheet is out of balance. Check your work.
Amazon Balance Sheet 2018-2022 in millions Financial Statements 2020 2021 2022 2018 $ 42,122.00 $ 36,220.00 $ 53,888.00 19.52% $ 24,542.00 $ 32,891.00 $ 42,360.00 10.25% $ 23,795.00 $ 32,640.00 $ 34,405.00 10.56% $ 42,274.00 $ 59,829.00 $ 16,138.00 5.84% $ 132,733.00 $ 161,580.00 $ 146,791.00 46.17% $ 113,114.00 $ 160,281.00 $ 186,715.00 37.99% $ 15,017.00 $ 15,371.00 $ 20,288.00 8.94% $ 60,331.00 $ 83,317.00 $ 108,881.00 6.89% $ 188,462.00 $ 258,969.00 $ 315,884.00 53.83% $ 321,195.00 $ 420,549.00 $ 462,675.00 100.00% $ 72,539.00 $ 78,664.00 $ 79,600.00 23.48% $ 44,138.00 $ 51,775.00 $ 62,566.00 14.55% $ 9,708.00 $ 11,827.00 $ 13,227.00 4.02% $ 126,385.00 $ 142,266.00 $ 155,393.00 42.05% $ 52,573.00 $ 67,651.00 $ 72,968.00 14.45% $ 48,833.00 $ 72,387.00 $ 88,271.00 16.73% $ 101,406.00 $ 140,038.00 $ 161,239.00 31.18% $ 227,791.00 $ 282,304.00 $ 316,632.00 73.23% $ (1,832.00) $ (1,731.00) $ (7,729.00) -1.13% $ 42,865.00 $ 55,437.00 $ 75,066.00 16.47% $ 52,551.00 $ 85,915.00 $ 83,193.00 12.07% $ (180.00) $ (1,376.00) $ (4,487.00) -0.64% $ 93,404.00 $ 138,245.00 $ 146,043.00 26.77%
$ 321,195.00 $ 420,549.00 $ 462,675.00 100.00% $ - $ - $ -
Vertical Analysis, Common Size Statements 2019 2020 2021 2022 16.02% 13.11% 8.61% 11.65% 9.24% 7.64% 7.82% 9.16% 9.10% 7.41% 7.76% 7.44% 8.40% 13.16% 14.23% 3.49% 42.77% 41.32% 38.42% 31.73% 32.28% 35.22% 38.11% 40.36% 6.55% 4.68% 3.65% 4.38% 18.40% 18.78% 19.81% 23.53% 57.23% 58.68% 61.58% 68.27% 100.00% 100.00% 100.00% 100.00% 20.95% 22.58% 18.71% 17.20% 14.40% 13.74% 12.31% 13.52% 3.64% 3.02% 2.81% 2.86% 38.98% 39.35% 33.83% 33.59% 10.39% 16.37% 16.09% 15.77% 23.07% 15.20% 17.21% 19.08% 33.46% 31.57% 33.30% 34.85% 72.45% 70.92% 67.13% 68.44% -0.81% -0.57% -0.41% -1.67% 14.94% 13.35% 13.18% 16.22% 13.86% 16.36% 20.43% 17.98% -0.44% -0.06% -0.33% -0.97% 27.55% 29.08% 32.87% 31.56%
100.00% 100.00% 100.00% 100.00%
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