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

Report
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%
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
$ 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
F 2018 2019 Total Revenue (or Sales) $ 232,887.00 $ 280,522.00 Cost of Sales $ 215,834.00 $ 260,577.00 Gross Profit $ 17,053.00 $ 19,945.00 Sales, General, and Administrative Expenses $ 4,632.00 $ 5,404.00 Operating Income $ 12,421.00 $ 14,541.00 Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) $ (977.00) $ (768.00) Other Income (Expense) $ (183.00) $ 203.00 Net Income (Loss), Before Tax $ 11,261.00 $ 13,976.00 Vertical Analysis on Revenue only 20.45%
Amazon Income Statement 2018-2022 in millions Financial Statements Vertical Analys 2020 2021 2022 2018 2019 $ 386,064.00 $ 469,822.00 $ 513,983.00 100.00% 100.00% $ 356,572.00 $ 436,058.00 $ 488,581.00 92.68% 92.89% $ 29,492.00 $ 33,764.00 $ 25,402.00 7.32% 7.11% $ 6,593.00 $ 8,885.00 $ 13,154.00 1.99% 1.93% $ 22,899.00 $ 24,879.00 $ 12,248.00 5.33% 5.18% $ (1,092.00) $ (1,361.00) $ (1,378.00) -0.42% -0.27% $ 2,371.00 $ 14,633.00 $ (16,806.00) -0.08% 0.07% $ 24,178.00 $ 38,151.00 $ (5,936.00) 4.84% 4.98% 37.62% 21.70% 9.40%
sis, Common Size Statements 2020 2021 2022 100.00% 100.00% 100.00% 92.36% 92.81% 95.06% 7.64% 7.19% 4.94% 1.71% 1.89% 2.56% 5.93% 5.30% 2.38% -0.28% -0.29% -0.27% 0.61% 3.11% -3.27% 6.26% 8.12% -1.15%
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
Amazon Ratio Analysis 2018-2022 2018 2019 2020 2021 Liquidity Ratios Current Ratio 1.10 1.10 1.05 1.14 Quick Ratio 0.71 0.65 0.53 0.49 Working Capital $ 6,710.00 $ 8,522.00 $ 6,348.00 $ 19,314.00 Activity Ratios Receivable Turns 13.96 13.48 15.73 14.28 Days in Receivables 26.14 27.08 23.20 25.55 Revenues/Working Capital 34.71 32.92 60.82 24.33 Revenues/Fixed Assets 3.77 3.86 3.41 2.93 Revenues/Total Assets 1.43 1.25 1.20 1.12 Inventory Turns 12.57 12.71 14.99 13.36 Days in Inventory 29.04 28.71 24.36 27.32 Payables Turns 5.65 5.52 4.92 5.54 Days in Payables 64.59 66.09 74.25 65.85 Coverage/Leverage Ratios Fixed Assets/Equity 1.42 1.17 1.21 1.16 Profitability Ratios Return on Equity 25.86% 22.52% 25.89% 27.60% Return on Total Assets 6.92% 6.20% 7.53% 9.07% Net Profit on Revenues 4.84% 4.98% 6.26% 8.12%
2022 0.94 0.62 $ (8,602.00) 12.13 30.08 -59.75 2.75 1.11 14.20 25.70 6.14 59.47 1.28 -4.06% -1.28% -1.15%
[ #VALUE! #VALUE! Assets Current Assets Cash and Cash Equivalents [insert value] [insert value] Accounts Receivable, Net [insert value] [insert value] Inventory [insert value] [insert value] Other Current Assets [insert value] [insert value] Total Current Assets $ - $ - Non-Current Assets Property, Plant and Equipment Net [insert value] [insert value] Intangibles [insert value] [insert value] Other Assets [insert value] [insert value] Total Non-Current/Fixed Assets $ - $ - Total Assets $ - $ - Liabilities and Owners' Equity Current Liabilities Accounts Payable [insert value] [insert value] Accrued Expenses and Other Current Liabilities [insert value] [insert value] Current Portion of Debt and Leases [insert value] [insert value] Total Current Liabilities $ - $ - Long-Term Liabilities Long-Term Debt and Lease Obligations [insert value] [insert value] Other Long-Term Liabilities [insert value] [insert value] Total Long-Term Liabilities $ - $ - Total Liabilities $ - $ - Owners' Equity Common Stock, Less Treasury [insert value] [insert value] Additional Paid in Capital [insert value] [insert value] Retained Earnings [insert value] [insert value] Other Equity [insert value] [insert value] Total Equity $ - $ -
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
Total Liabilities & Equity $ - $ - $ - $ - Milestone Two Perfect Score: Correct Milestone Two: Check Digit: This should be 0 or the balance sheet is out of balance. Check your work. *If you received a perfect score on the Milestone Two, please place an "X" next to Miestone Two Perfect S have to complete this tab because all entries on the Milestone Corrected Balance Sheet tab are correct. If you need to correct answers from Milestone Two, place an "X" next to Corrected Milestone Two. Then e answers on this tab. Please highlight your corrected answers in green or note with an asterisk.
[Insert company name] Balance Sheet [Insert period covered] [Insert how data is recorded. (i.e. thousands or millions)] Financial Statements #VALUE! #VALUE! [insert most current year] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! $ - $ - $ - #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! $ - $ - $ - #VALUE! $ - $ - $ - #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! $ - $ - $ - #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! $ - $ - $ - #VALUE! $ - $ - $ - #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! [insert value] [insert value] [insert value] #VALUE! $ - $ - $ - #VALUE!
$ - $ - $ - #VALUE! $ - $ - $ - Score. Then you do not enter in your corrected
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
Vertical Analysis, Common Size Statements #VALUE! #VALUE! #VALUE! sert most current year] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
#VALUE! #VALUE! #VALUE! #VALUE!
[Insert F #VALUE! #VALUE! Total Revenue (or Sales) [insert value] [insert value] Cost of Sales [insert value] [insert value] Gross Profit #VALUE! #VALUE! Sales, General, and Administrative Expenses [insert value] [insert value] Operating Income #VALUE! #VALUE! Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) [insert value] [insert value] Other Income (Expense) [insert value] [insert value] Net Income (Loss), Before Tax #VALUE! #VALUE! Vertical Analysis on Revenue Only #VALUE! Milestone Two Perfect Score: Correct Milestone Two: *If you received a perfect score on the Milestone Two, please place an "X" next to Miestone Two Per do not have to complete this tab because all entries on the Milestone Corrected Balance Sheet tab ar If you need to correct answers from Milestone Two, place an "X" next to Corrected Milestone Two. Th corrected answers on this tab. Please highlight your corrected answers in green or note with an aster
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
[Insert company name] Income Statement [Insert period covered] t how data is recorded. (i.e. thousands or millions)] Financial Statements Vertical Analys #VALUE! #VALUE! nsert most current year] #VALUE! #VALUE! [insert value] [insert value] [insert value] #VALUE! #VALUE! [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] #VALUE! #VALUE! [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! rfect Score. Then you re correct. hen enter in your risk.
sis, Common Size Statements #VALUE! #VALUE! rt most current year] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
[Insert company name] Ratio Analysis [Insert period covered] #VALUE! #VALUE! #VALUE! Liquidity Ratios Current Ratio #DIV/0! #DIV/0! #DIV/0! Quick Ratio #VALUE! #VALUE! #VALUE! Working Capital $ - $ - $ - Activity Ratios Receivable Turns #VALUE! #VALUE! #VALUE! Days in Receivables #VALUE! #VALUE! #VALUE! Revenues/Working Capital #VALUE! #VALUE! #VALUE! Revenues/Fixed Assets #VALUE! #VALUE! #VALUE! Revenues/Total Assets #VALUE! #VALUE! #VALUE! Inventory Turns #VALUE! #VALUE! #VALUE! Days in Inventory #VALUE! #VALUE! #VALUE! Payables Turns #VALUE! #VALUE! #VALUE! Days in Payables #VALUE! #VALUE! #VALUE! Coverage/Leverage Ratios Fixed Assets/Equity #VALUE! #VALUE! #VALUE! Profitability Ratios Return on Equity #VALUE! #VALUE! #VALUE! Return on Total Assets #VALUE! #VALUE! #VALUE! Net Profit on Revenues #VALUE! #VALUE! #VALUE! Milestone Two Perfect Score: Correct Milestone Two: *If you received a perfect score on the Milestone Two, please place an "X" next to Miestone Two Perfect Score. Then you do not have to complete this tab because all entries on the Milestone Corrected Balance Sheet tab are correct. If you need to correct answers from Milestone Two, place an "X" next to Corrected Milestone Two. Then enter in your corrected answers on this tab. Please highlight your corrected answers in green or note with an asterisk.
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
#VALUE! ert most current year] #DIV/0! #DIV/0! #VALUE! #VALUE! $ - $ - #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
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
Amazon Project Income Sta 2023-2027 Iinsert how data is recorded. (i.e. 2023 2024 Total Revenue (or Sales) $ 565,381.30 $ 621,919.43 Estimated Annual Revenue Growth Rate 10.00% 10.00% Gross Profit $ 231,806.33 $ 254,986.97 Estimated Annual Gross Profit Margin 41.00% 41.00% Sales, General, and Administrative Expenses (SG&A) $ 16,961.44 $ 18,657.58 Estimated Annual SG&A (% of Sales) 3.00% 3.00% Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) $ (1,998.10) $ (3,296.87) Other Income (Expense) $ (12,604.50) $ (9,453.38) Net Income (Loss) $ 202,240.39 $ 226,876.01
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
atements 7 . thousands or millions)] Financial Statements 2025 2026 2027 Terminal $ 684,111.37 $ 752,522.51 $ 827,774.76 $ 910,552.24 10.00% 10.00% 10.00% 10.00% $ 280,485.66 $ 308,534.23 $ 339,387.65 $ 373,326.42 41.00% 41.00% 41.00% 41.00% $ 20,523.34 $ 22,575.68 $ 24,833.24 $ 27,316.57 3.00% 3.00% 3.00% 3.00% $ (5,439.83) $ (8,975.71) $ (14,809.93) $ (24,436.38) $ (7,090.03) $ (5,317.52) $ (3,988.14) $ (2,991.11) $ 252,872.29 $ 280,641.03 $ 310,566.27 $ 343,018.74
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
Amazon Development of Discount Rate and Capitalization Risk-free long term U.S. Government bond rate Equity risk premium Industry premium estimate Cost of equity (Discount Rate) Less: Long-term sustainable growth rate Capitalization Rate NOTES (A) Yield on the twenty-year U.S. Treasury bond as of December 31, 20XX, per the U.S. Treasury (B) Long-horizon expected return of large stocks over risk free securities, U.S. Equity Risk Premium (6.0%) (C) SIC code XX, 1.5% (D) Appraiser's judgement concerning company-specific risk (E) Estimated long-term growth rate based on inflation, Federal Reserve Bank of Philadelphia
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
2022 Rate Note 2.60% A 6.00% B 1.50% C 3.00% D 13.10% Sum of A - D above -2.50% E 10.60%
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
Amazon Discounted Cash Flow 2023-2027 P 2023 2024 Forecasted Net Income $ 202,240.39 $ 226,876.01 Plus Depreciation $ 33,844.67 $ 35,536.90 *Less Cash Used for Investments $ (30,080.80) $ (24,064.64) Cash Used for Financing $ (10,203.90) $ (10,714.10) Net Cash Flow $ 195,800.36 $ 227,634.17 Present Value of Cash Flows $173,121.00 $177,956.00 13.10% Net Present Value of Future Cash Flows $882,663.00 Net Present Value of Terminal Cash Flow $2,059,500.00 10.60% Total Indication of Value $ 2,942,163.00 1.00 2.00 2020 2021 Depreciation (in millions) 25180 34433 Cash investments $ 59,611.00 58154 Cash financing $ 1,104.00 6291 * NOTE: Cash USED must be entered as negative numbers.
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
w Method Projected for Years Ending December 31, 2025 2026 2027 Terminal $ 252,872.29 $ 280,641.03 $ 310,566.27 $ 343,018.74 $ 35,536.90 $ 37,313.75 $ 39,179.44 $ 41,138.41 $ (19,251.71) $ (15,401.37) $ (12,321.10) $ (9,856.88) $ (11,249.80) $ (11,812.29) $ (12,402.90) $ (13,023.05) $ 257,907.68 $ 290,741.12 $ 325,021.70 $ 361,277.23 $178,269.00 $177,687.00 $175,630.00 $3,408,276.00 3.00 4.00 5.00 2022 41921 33844.6666666667 33844.6666666667 37601 9718
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
Amazon Final Computation of Value As of 2022 Indicated Value of Equity $ 2,942,163.00 Weight 100.00% Weighted Value $ 2,942,163.00 Indicated Value with Voting Rights $ 2,942,163.00 *Less: DLOC (Discount for Lack of Control) 15% $ (441,324.45) Marketable, Minority Value $ 2,500,838.55 **Less: DLOM (Discount for Lack of Marketability) 25% $ (625,209.64) Nonmarketable, Minority Value $ 1,875,628.91 Value of a 1% Interest $ 18,756.29 Income Approach: Discounted Cash Flow Method *Let this default to the rate applied here for the DLOC. It is possible to override this rate with your own. However, an explanation must be provided why it was changed. **Let this default to the rate applied here for DLOM. It is possible to override this rate with your own. However, an explantation must be provided on why it was changed.
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