ACC 345 Milestone 2 workbook

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

345

Subject

Finance

Date

Nov 24, 2024

Type

xlsx

Pages

29

Uploaded by Barbara8289

Report
2018 2019 Assets Current Assets Cash and Cash Equivalents $ 4,249.00 $ 4,466.00 Accounts Receivable Net $ 3,498.00 $ 4,272.00 Inventory $ 5,261.00 $ 5,622.00 Other Current Assets $ 2,126.00 $ 2,165.00 Total Current Assets $ 15,134.00 $ 16,525.00 Non-Current Assets Property, Plant, and Equipment Net $ 4,454.00 $ 4,744.00 Intangibles $ 285.00 $ 283.00 Other Assets $ 2,663.00 $ 2,165.00 Total Non-Current/Fixed Assets $ 7,402.00 $ 7,192.00 Total Assets $ 22,536.00 $ 23,717.00 Liabilities and Owners' Equity Current Liabilities Accounts Payable $ 2,279.00 $ 2,612.00 Accrued Expenses and Other Current Liabilities $ 3,761.00 $ 5,254.00 Current Portion of Debt and Leases $ - $ - Total Current Liabilities $ 6,040.00 $ 7,866.00 Long-Term Liabilities Long-Term Debt and Lease Obligations $ 3,468.00 $ 3,464.00 Other Long-Term Liabilities $ 3,216.00 $ 3,347.00 Total Long-Term Liabilities $ 6,684.00 $ 6,811.00 Total Liabilities $ 12,724.00 $ 14,677.00 Owners' Equity Common Stock, Less Treasury $ 3.00 $ 3.00 Additional Paid in Capital $ 6,384.00 $ 7,163.00 Retained Earnings $ 3,517.00 $ 1,643.00 Other Equity $ (92.00) $ 231.00 Total Equity $ 9,812.00 $ 9,040.00
Total Liabilities & Equity $ 22,536.00 $ 23,717.00 $ - $ - Check Digit: This should be 0 or the balance sheet is out of balance. Check your work.
Nike, Inc. Balance Sheet May 31st 2018 - May 31 2022 In millions, expect shares and ration data Financial Statements 2020 2021 2022 2018 $ 8,348.00 $ 9,889.00 $ 8,574.00 18.85% $ 2,749.00 $ 4,463.00 $ 4,667.00 15.52% $ 7,367.00 $ 6,854.00 $ 8,420.00 23.34% $ 2,092.00 $ 5,085.00 $ 6,552.00 9.43% $ 20,556.00 $ 26,291.00 $ 28,213.00 67.15% $ 4,866.00 $ 4,904.00 $ 4,791.00 19.76% $ 274.00 $ 269.00 $ 286.00 1.26% $ 5,646.00 $ 6,276.00 $ 7,031.00 11.82% $ 10,786.00 $ 11,449.00 $ 12,108.00 32.85% $ 31,342.00 $ 37,740.00 $ 40,321.00 100.00% $ 2,248.00 $ 2,836.00 $ 3,358.00 10.11% $ 5,591.00 $ 6,371.00 $ 6,952.00 16.69% $ 445.00 $ 467.00 $ 420.00 0.00% $ 8,284.00 $ 9,674.00 $ 10,730.00 26.80% $ 12,319.00 $ 12,344.00 $ 11,697.00 15.39% $ 2,684.00 $ 2,955.00 $ 2,613.00 14.27% $ 15,003.00 $ 15,299.00 $ 14,310.00 29.66% $ 23,287.00 $ 24,973.00 $ 25,040.00 56.46% $ 3.00 $ 3.00 $ 3.00 0.01% $ 8,299.00 $ 9,965.00 $ 11,484.00 28.33% $ (191.00) $ 3,179.00 $ 3,476.00 15.61% $ (56.00) $ (380.00) $ 318.00 -0.41% $ 8,055.00 $ 12,767.00 $ 15,281.00 43.54%
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
$ 31,342.00 $ 37,740.00 $ 40,321.00 100.00% $ - $ - $ -
Vertical Analysis, Common Size Statements 2019 2020 2021 2022 GoodWill 18.83% 26.64% 26.20% 21.26% 18.01% 8.77% 11.83% 11.57% 23.70% 23.51% 18.16% 20.88% 9.13% 6.67% 13.47% 16.25% 69.68% 65.59% 69.66% 69.97% 20.00% 15.53% 12.99% 11.88% 1.19% 0.87% 0.71% 0.71% 9.13% 18.01% 16.63% 17.44% 30.32% 34.41% 30.34% 30.03% 100.00% 100.00% 100.00% 100.00% 11.01% 7.17% 7.51% 8.33% 22.15% 17.84% 16.88% 17.24% 0.00% 1.42% 1.24% 1.04% 33.17% 26.43% 25.63% 26.61% 14.61% 39.31% 32.71% 29.01% 14.11% 8.56% 7.83% 6.48% 28.72% 47.87% 40.54% 35.49% 61.88% 74.30% 66.17% 62.10% 0.01% 0.01% 0.01% 0.01% 30.20% 26.48% 26.40% 28.48% 6.93% -0.61% 8.42% 8.62% 0.97% -0.18% -1.01% 0.79% 38.12% 25.70% 33.83% 37.90%
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
2018 2019 2020 2021 2022 154 154 223 224 284
F 2018 2019 Total Revenue (or Sales) $ 36,397.00 $ 39,117.00 Cost of Sales $ 20,441.00 $ 21,643.00 Gross Profit $ 15,956.00 $ 17,474.00 Sales, General, and Administrative Expenses $ 11,511.00 $ 12,702.00 Operating Income $ 4,445.00 $ 4,772.00 Other Income (Expense) *If expense is reported, enter as a negative number. Interest Income / (Expense) $ (54.00) $ (49.00) Other Income (Expense) $ (66.00) $ 78.00 Net Income (Loss), Before Tax $ 4,325.00 $ 4,801.00 Vertical Analysis on Revenue only 7.47%
Nike, Inc. Income Statement May 31st 2018 - May 31 2022 In millions, expect shares and ration data Financial Statements Vertical Analys 2020 2021 2022 2018 2019 $ 37,403.00 $ 44,538.00 $ 46,710.00 100.00% 100.00% $ 21,162.00 $ 24,576.00 $ 25,231.00 56.16% 55.33% $ 16,241.00 $ 19,962.00 $ 21,479.00 43.84% 44.67% $ 13,126.00 $ 13,025.00 $ 14,804.00 31.63% 32.47% $ 3,115.00 $ 6,937.00 $ 6,675.00 12.21% 12.20% $ (89.00) $ (262.00) $ (205.00) -0.15% -0.13% $ (139.00) $ (14.00) $ 181.00 -0.18% 0.20% $ 2,887.00 $ 6,661.00 $ 6,651.00 11.88% 12.27% -4.38% 19.08% 4.88%
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
sis, Common Size Statements 2020 2021 2022 100.00% 100.00% 100.00% 56.58% 55.18% 54.02% 43.42% 44.82% 45.98% 35.09% 29.24% 31.69% 8.33% 15.58% 14.29% -0.24% -0.59% -0.44% -0.37% -0.03% 0.39% 7.72% 14.96% 14.24%
Nike, Inc. Ratio Analysis May 31st 2018 - May 31 2022 2018 2019 2020 2021 2022 Liquidity Ratios Current Ratio 2.51 2.10 2.48 2.72 2.63 Quick Ratio 1.28 1.11 1.34 1.48 1.23 Working Capital $ 9,094.00 $ 8,659.00 $ 12,272.00 $ 16,617.00 $ 17,483.00 Activity Ratios Receivable Turns 10.41 9.16 13.61 9.98 10.01 Days in Receivab 35.08 39.86 26.83 36.58 36.47 Revenues/Workin 4.00 4.52 3.05 2.68 2.67 Revenues/Fixed 8.17 8.25 7.69 9.08 9.75 Revenues/Total 1.62 1.65 1.19 1.18 1.16 Inventory Turns 0.26 0.26 0.35 3.59 3.00 Days in Inventor 1418.16 1405.14 1048.48 101.79 121.81 Payables Turns 8.97 8.29 9.41 8.67 7.51 Days in Payables 40.69 44.05 38.77 42.12 48.58 Coverage/Leverage Ratios Fixed Assets/Equ 0.45 0.52 0.60 0.38 0.31 Profitability Ratios Return on Equity 44.08% 53.11% 35.84% 52.17% 43.52% Return on Total 19.19% 20.24% 9.21% 17.65% 16.50% Net Profit on Re 11.88% 12.27% 7.72% 14.96% 14.24%
#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 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 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! ert 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. T 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. Then 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
[Insert company Project Income Sta [Insert dates of perio Iinsert how data is recorded. (i.e. 2023 2024 Total Revenue (or Sales) #VALUE! #VALUE! Estimated Annual Revenue Growth Rate [insert value] [insert value] Gross Profit #VALUE! #VALUE! Estimated Annual Gross Profit Margin [insert value] [insert value] Sales, General, and Administrative Expenses (SG&A) #VALUE! #VALUE! Estimated Annual SG&A (% of Sales) [insert value] [insert 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) #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
name] atements od covered] . thousands or millions)] Financial Statements 2025 2026 2026 Terminal #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert 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
[Insert company name] 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
[Insert company n Discounted Cash Flow [Insert dates of period P 2023 2024 Forecasted Net Income #VALUE! #VALUE! Plus Depreciation [insert value] [insert value] *Less Cash Used for Investments [insert value] [insert value] Cash Used for Financing [insert value] [insert value] Net Cash Flow #VALUE! #VALUE! Present Value of Cash Flows #VALUE! #VALUE! 13.10% Net Present Value of Future Cash Flows #VALUE! Net Present Value of Terminal Cash Flow #VALUE! 10.60% Total Indication of Value #VALUE! 1.00 2.00 * 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
name] w Method d covered] Projected for Years Ending December 31, 2025 2026 2026 Terminal #VALUE! #VALUE! #VALUE! #VALUE! [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] [insert value] #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! 3.00 4.00 5.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
[Insert company name] Final Computation of Value As of [Enter date] Indicated Value of Equity #VALUE! Weight 100.00% Weighted Value #VALUE! Indicated Value with Voting Rights #VALUE! *Less: DLOC (Discount for Lack of Control) 15% #VALUE! Marketable, Minority Value #VALUE! **Less: DLOM (Discount for Lack of Marketability) 25% #VALUE! Nonmarketable, Minority Value #VALUE! Value of a 1% Interest #VALUE! 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