ACC 345 Project Workbook 3-1 Milestone Two

.xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

430

Subject

Finance

Date

Feb 20, 2024

Type

xlsx

Pages

29

Uploaded by EpsylonGere

Report
2018 2019 Assets Current Assets Cash and Cash Equivalents $ 4,150.00 $ 5,418.00 Accounts Receivable Net $ 9,334.00 $ 15,481.00 Inventory $ 1,392.00 $ 1,649.00 Other Current Assets $ 1,949.00 $ 5,576.00 Total Current Assets $ 16,825.00 $ 28,124.00 Non-Current Assets Property, Plant, and Equipment Net $ 29,540.00 $ 31,603.00 Intangibles $ 6,812.00 $ 23,215.00 Other Assets $ 45,421.00 $ 111,042.00 Total Non-Current/Fixed Assets $ 81,773.00 $ 165,860.00 Total Assets $ 98,598.00 $ 193,984.00 Liabilities and Owners' Equity Current Liabilities Accounts Payable $ 9,479.00 $ 17,762.00 Accrued Expenses and Other Current Liabilities $ 3,790.00 $ 8,857.00 Current Portion of Debt and Leases $ 4,591.00 $ 4,722.00 Total Current Liabilities $ 17,860.00 $ 31,341.00 Long-Term Liabilities Long-Term Debt and Lease Obligations $ 17,084.00 $ 38,129.00 Other Long-Term Liabilities $ 10,822.00 $ 30,625.00 Total Long-Term Liabilities $ 27,906.00 $ 68,754.00 Total Liabilities $ 45,766.00 $ 100,095.00 Owners' Equity Common Stock, Less Treasury $ (30,809.00) $ 53,000.00 Additional Paid in Capital $ - $ - Retained Earnings $ 82,679.00 $ 42,494.00 Other Equity $ 962.00 $ (1,605.00) Total Equity $ 52,832.00 $ 93,889.00
Total Liabilities & Equity $ 98,598.00 $ 193,984.00 $ - $ - Check Digit: This should be 0 or the balance sheet is out of balance. Check your work.
Walt Disney Company Balance Sheet For the Period October 1, 2018 - October 1, 2022 in millions Financial Statements 2020 2021 2022 2018 $ 17,914.00 $ 15,959.00 $ 11,615.00 4.21% $ 12,708.00 $ 13,367.00 $ 12,652.00 9.47% $ 1,583.00 $ 1,331.00 $ 1,742.00 1.41% $ 3,046.00 $ 3,000.00 $ 3,089.00 1.98% $ 35,251.00 $ 33,657.00 $ 29,098.00 17.06% $ 32,078.00 $ 32,624.00 $ 33,596.00 29.96% $ 19,173.00 $ 17,115.00 $ 14,837.00 6.91% $ 115,047.00 $ 120,213.00 $ 126,100.00 46.07% $ 166,298.00 $ 169,952.00 $ 174,533.00 82.94% $ 201,549.00 $ 203,609.00 $ 203,631.00 100.00% $ 16,801.00 $ 20,894.00 $ 20,213.00 9.61% $ 5,711.00 $ 5,866.00 $ 3,070.00 3.84% $ 4,116.00 $ 4,317.00 $ 5,790.00 4.66% $ 26,628.00 $ 31,077.00 $ 29,073.00 18.11% $ 52,917.00 $ 48,540.00 $ 45,299.00 17.33% $ 33,741.00 $ 30,981.00 $ 30,380.00 10.98% $ 86,658.00 $ 79,521.00 $ 75,679.00 28.30% $ 113,286.00 $ 110,598.00 $ 104,752.00 46.42% $ 53,590.00 $ 54,564.00 $ 55,491.00 -31.25% $ - $ - $ - 0.00% $ 38,315.00 $ 40,429.00 $ 43,636.00 83.85% $ (3,642.00) $ (1,982.00) $ (248.00) 0.98% $ 88,263.00 $ 93,011.00 $ 98,879.00 53.58%
$ 201,549.00 $ 203,609.00 $ 203,631.00 100.00% $ - $ - $ -
Vertical Analysis, Common Size Statements 2019 2020 2021 2022 2.79% 8.89% 7.84% 5.70% 7.98% 6.31% 6.57% 6.21% 0.85% 0.79% 0.65% 0.86% 2.87% 1.51% 1.47% 1.52% 14.50% 17.49% 16.53% 14.29% 16.29% 15.92% 16.02% 16.50% 11.97% 9.51% 8.41% 7.29% 57.24% 57.08% 59.04% 61.93% 85.50% 82.51% 83.47% 85.71% 100.00% 100.00% 100.00% 100.00% 9.16% 8.34% 10.26% 9.93% 4.57% 2.83% 2.88% 1.51% 2.43% 2.04% 2.12% 2.84% 16.16% 13.21% 15.26% 14.28% 19.66% 26.26% 23.84% 22.25% 15.79% 16.74% 15.22% 14.92% 35.44% 43.00% 39.06% 37.16% 51.60% 56.21% 54.32% 51.44% 27.32% 26.59% 26.80% 27.25% 0.00% 0.00% 0.00% 0.00% 21.91% 19.01% 19.86% 21.43% -0.83% -1.81% -0.97% -0.12% 48.40% 43.79% 45.68% 48.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