+1 (208) 254-6996 [email protected]
  

Need to have a report done based on the attached information. Included drafts, samples and all materials to complete. Will be 8-10 pages on report and 10 slides on the powerpoint.Thanks

Task 1: Paper on Dell using SEC 10-K report (8-10 pages double spaced pages) Include analysis as well as tables.

Don't use plagiarized sources. Get Your Custom Essay on
Accounting Report And PowerPoint
Just from $13/Page
Order Essay

Consider topics from our course and your cumulative knowledge of accounting. Your goal is to tell the story of your company based on what you learn from reading the financial statements and notes to the financial statements.

The only items on the works cited list should be the SEC 10-K document link and Course Resources, Attached. This is not a research report but an opportunity for you to illustrate your mastery of accounting concepts and communication skills.

The link and additional information on Dell (might not need) is included below before the questions.

https://www.sec.gov/ix?doc=/Archives/edgar/data/1571996/000157199621000007/dell-20210129.htm

Dell Information:

Reading the balance sheet, note Dell is using the financial strategy of negative working capital. This does not mean they cannot pay their bills (this must on the internet somewhere about negative working capital). The grocery industry often uses negative working capital as a strategy. For Dell is only noteworthy.

Why the accumulated deficit? With the 3 years presented on the statement of cash flows and the statement of shareholders’ equity, again, you will many areas to present in your SEC 10-K deliverables. A major acquisition or change in ownership often results in issues such as an accumulated deficit. With Dell’s recent profitability you can see how things continue to change. Mention the payment (or non payment) of cash dividends each year. It is not the per share values the overall cost of dividends. How do they compare to net income? With the accumulated deficit Dell may not be provided cash dividends at this time.

Dell Technologies Inc. NYSE: DELL

The SEC 10-K project includes two deliverables for the story you present based on what you learn from reading the financial statements and the notes to the financial statements. Report unusual items. Relate concepts and topics from our course to the disclosure for your SEC 10-K company. Consider

https://www.fasb.org/jsp/FASB/Page/SectionPage&cid=1176168752402

A. Non-GAAP disclosure

How does your SEC 10-K company present non-GAAP information?

B. What financial statement is presented first; why might the company decide to use this order for the financial statements?

What order of financial statements would you expect to see?

C. Critical Audit Matters

Read the auditors’ report. What do you learn beyond the expected ordinary opinion.

List the Critical Audit Matters (CAM) as presented in the auditors’ report (letter) for your SEC 10-K company

D. Other items

Look for differences and changes from year to year

Weekly Questions to help create the paper: Attached

Task 2: PowerPoint Presentation Dell using SEC 10-K report (draft attached) 10 slides

Need this powerpoint created. The draft is attached, but needs created based off of the paper.

Attached will be a sample of another PP.

WEEKLY QUESTIONS FOR SEC 10-K

Week 1:

Category: Revenue and Net Income 1. What were the company’s revenues for the most recent fiscal year?  Comment on the trend in total revenue.  Is it increasing or decreasing during the past two years? 2. Compare net income over the past two years.  How much and by what percentage did Net Income change?  3. Comment on individual revenue or expense items that had significant percentage changes (changes as a percentage of total revenue or total expenses) over the most current three years. Category:  Irregular Items 1.  Identify and describe any irregular items reported on the Income Statement, such as discontinued operation or extraordinary items,?  2.  Did your company change any accounting principles that would have required a retrospective adjustment to the financial statements? 3.  Were there any prior-period adjustments (PPA)?  If so, what caused the PPA’s?  Category:  Analysis 1.  Prepare a horizontal analysis of your company’s Income Statement over the past two years. 2.  Calculate the following ratios for the most recent two years and comment on the results of your ratio analysis.  How do the results for your company compare to industry averages?      a. Accounts receivable turnover      b. Profit margin      c. Return on assets      d. Times interest earned

Week 2:

Category: Stock Market 1.  Describe three facts about the stock exchange on which your corporation’s stock is traded.  2.  Compare the closing price of your corporation’s stock on the first day of the semester to the day before you post a response to this question.  3.  Explain how investors use these indices to make more informed investing decisions:       a. Dow Jones Industrial Average (DOW)       b. NASDAQ Composite Index (NASDAQ)       c. Standard & Poor’s (S&P) 500 Category: Assets and LIabilities 1.  Briefly describe your company’s investments and intangible assets. 2.  Does your company list “Other Assets?” If so, what items are classified in this category? 3.  Comment on any significant changes in individual assets or liabilities. 4.  Does your company have any long-term liabilities?  If so, state  the largest long-term liability and when it is due? Category: Analysis 1. Prepare a vertical analysis of your company’s Balance Sheet for the current year. 2.  Calculate the following ratios for the most recent two years and comment on the results of your ratio analysis.  How do the results for your company compare to industry averages?      a.  Current ratio      b.  Inventory turnover      c.  Asset turnover      d.  Debt to assets

Week 3:

Category: Capital stock 1.  Describe the following details about your corporation’s common stock:      a. Authorized number of shares      b. Par or stated value per share      c. Issued number of shares      d. Outstanding number of shares      e. Treasury stock  2.  Describe the following details about your corporation’s preferred stock:      a. Authorized number of shares      b. Par or stated value per share      c. Issued number of shares      d. Outstanding number of shares      e. Cumulative or non-cumulative      f.  Participating or non-participating    3.  Discuss Treasury Stock transactions over the past three years and explain its affect on total stockholder’s equity and retained earnings. Category: Retained Earnings 1. Use the following equation and show how the Retained Earnings account has changed over the past two years.   Retained earnings, beginning balance   + Prior period adjustments   = Retained earnings, adjusted balance      + Net Income   – Retirement of Treasury stock   – Dividends   = Retained earnings, ending balance Category:  Analysis 1.  Calculate the following ratios for the most recent two years and comment on the results of your ratio analysis.  How do the results for your company compare to industry averages?      a. Return on stockholders’ equity      b. Earnings per share (EPS)      c. Price-earnings (PE) ratio      d. Payout ratio

Week 4:

Category: Operating Activities 1.  State whether your corporation uses the direct or indirect method of preparing the Statement of Cash Flows and describe how the Statement would be different under these two methods. 2.  What are the largest increases and decreases in the operating activities section of your corporation’s Statement of Cash Flows? 3.  Given the industry your corporation operates in and the current economic environment, explain any unexpected operating activities that caused cash flow to decrease.    Category: Investing and Financing Activities 1. Explain similarities and or differences in preparing the Statement of Cash Flows using International Financial Reporting Standards (IFRS). 2.  Describe investments reported on your corporation’s Statement of Cash Flows in the current and most recent past year. 3.  Review your corporation’s Statement of Cash Flows over the past 3 years and explain any financing trends. Category:  Analysis 1.  Calculate the following ratio for the most recent two years and comment on the results of your ratio analysis.   How does the result for your corporation compare to the industry average?      a. Free cash flow

WEEKLY Learning Material

Week 1:

Intro_to_Fcl_Accounting_online_format_TEXT_US_Edition_at_Sept_26_18.pdf (attached)

Introduction to Financial Accounting online text – Chapter 1

In this chapter you will review key concepts in financial accounting. CHAPTER ONE (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 2

This chapter explains the accounting process and serves as foundation material for our course. CHAPTER TWO (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689): The Accounting Process

Week 2:

Intro_to_Fcl_Accounting_online_format_TEXT_US_Edition_at_Sept_26_18.pdf (attached)

Introduction to Financial Accounting online text – Chapter 3

In this chapter you will review the steps to year end adjustments. CHAPTER THREE: Financial Accounting and the Use of Adjusting (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 4

In this chapter you will review the balance sheet and concepts related to disclosure. CHAPTER FOUR: The Classified Balance Sheet and Related Disclosures (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 11

In this chapter the concepts of equity financing we will be reviewed. CHAPTER ELEVEN: Equity Financing (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Week 3:

Intro_to_Fcl_Accounting_online_format_TEXT_US_Edition_at_Sept_26_18.pdf (attached)

Introduction to Financial Accounting online text – Chapter 7

In this chapter you will review the concepts of cash and receivables. CHAPTER SEVEN: Cash and Receivables (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 13

In this chapter you will learn about the concepts of financial analysis. CHAPTER THIRTEEN: Financial Statement Analysis (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 14

In this chapter the results of activity related to the income statement and balance sheet will be used to create the statement of cash flows. CHAPTER FOURTEEN: The Statement of Cash Flows (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Week 4:

Intro_to_Fcl_Accounting_online_format_TEXT_US_Edition_at_Sept_26_18.pdf (attached)

Introduction to Financial Accounting online text – Chapter 9

In this chapter the concept of financing, recorded as current and long term liabilities, will be explored. CHAPTER NINE: Debt Financing: Current and Non-current Liabilities (including end of Introduction to Financial Accounting US Edition

Introduction to Financial Accounting online text – Chapter 10

In this chapter the concepts of long term debt and bond financing will be discussed. CHAPTER TEN: Debt Financing: Bonds (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Week 5:

Introduction to Financial Accounting online text – Chapter 5

In this chapter the concepts of inventory and cost of sales will be presented. CHAPTER FIVE: Accounting for the Sale of Goods (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Introduction to Financial Accounting online text – Chapter 6

In this chapter inventory costing methods will be reviewed. CHAPTER SIX: Assigning Costs to Merchandize (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Week 6;

Introduction to Financial Accounting online text – Chapter 8

In this chapter you will learn about accounting for property, plant, equipment, and depreciation. CHAPTER EIGHT: Long-lived Assets (including end of chapter material with questions; this is a toggled file to the answers that begin at page 689):

Northrop Grumman NYSE: NOC

Introduction

Founded in 1939 as Northrop Aircraft Incorporated

Acquired Grumman Corporation in 1994 and became Northrop Grumman Corporation

Organized into four Operating Sectors:

Aeronautics Systems

Defense Systems

Mission Systems

Space Systems

Corporate Headquarters is in Falls Church and Lebanon, VA.

President and CEO – Kathy Warden

Oversight provided by a Board of Directors

Approximately 97,000 employees

Diversified portfolio across U.S. DoD

Revenue and Net Income

 $ in billions20202019
Product$27.015$23.852
Service$9.784$9.989
Sales$36.799$33.841
COGS$32.734$29.872
Operating income$4.065$3.969
Net earnings$3.189$2.248
Net Profit Margin8.67%6.64%

Revenue was recognized using identifiable performance obligations in contracts

84% of sales was comprised of long-term contracts with the U.S. Government

Sales increased by 9% in 2020

Operating income increased by 5% in 2020

Net Profit Margin exceeded industry average of 6.33% for 2019 and 2020

3

Assets

 $ in billions20202019
Current assets$15.34410.685
Non-Current assets$44.469$41.089
Total assets$44.469$41.089
A/R Turnover24.5225.52
Return on Assets7.17%5.47%

Cash and cash equivalents was 11.03% and 5.46% of total assets in 2020 and 2019 respectively

Unbilled receivables was 11.56% and 12.98% of total assets in 2020 and 2019 respectively. This item made up the largest percentage of current assets for both years

Goodwill accounted for the largest portion of total assets reported for the last two years

2020: 39.39% of total assets reported

2019: 45.53% of total assets reported

Briefly describe your company’s investments and intangible assets.

4

Liabilities

Non-current liabilities equate to 71.73% of total liabilities reported in 2020

In 2020, unsecured notes totaling $2.250 billion were issued

Long-term debt includes several fixed-rate notes and debentures with $10.285 billion maturing after 2025

 $ in billions20202019
Current liabilities9.5809.434
Long-term debt14.26112.770
Total liabilities33.89032.270

Stockholders Equity

 $ in billions20202019
Preferred stock00
Common stock$.167$.168
Paid-in capital.0580
Retained earnings$10.482$8.748
Accumulated other comprehensive loss($.128)($.097)
Total shareholders’ equity$10.579$8.819
20202019
Return on Stockholders equity26.4%32.4%
Common stock repurchased$1.4 million$3.2 million
Dividends declared($951 million)($880 million)
Earnings per share$19.08$13.28
Payout ratio9.8%10.3%

ROE has trended higher than the industry average for the last 10 years.

Pg 25

6

Cash Flow

$ in billions20202019
Net Income$3.189$2.248
Net Cash provided by Operating Activities$4.3054.297
Net Cash used in Investing Activities($1.211)($1.207)
Net Cash used in Financing Activities($.432)($2.424)
Cash and Cash Equivalents at End of Year$4.907$2.245
Adjusted Free Cash Flow (note 1)$3.683$3.128

2020 Operating Activities: Net cash was impacted by higher net earnings, increased working capital, and $630 million in increased discretionary pension contributions as compared to 2019.

2020 Investing Activities: Net cash used was similar to 2019. This amount includes $205 million in proceeds due to sale of equipment to a customer.

2020 Financing Activities: Net cash used decreased due to the issuance of long-term debt in the amount of $2.239 billion.

note 1:

Adjusted Free Cash Flow = net cash provided by operating activities – capital expenditures + proceeds from sale of equipment + after-tax discretionary pension contributions. This is a non-GAAP measure and may be calculated differently by other companies.

7

Non-GAAP Financial Measures

Adjusted Free Cash Flow

May be defined and calculated differently by other companies

Used to make decisions regarding acquisitions, dividend payments, and share repurchases

Market to Market – Adjusted Diluted EPS

Adjusts the diluted EPS by excluding MTM expense and related tax impacts

Useful in evaluating diluted EPS before pension and benefit plan impacts

Segment Operating Income and Segment Operating Margin Rate

Allows analysis of the different operating segments within the company

Critical Audit Matters

Revenue Recognition – Cost and Revenue Estimates for Development Contracts

Reported as a critical audit matter due to challenging, subjective, or complex judgements

Based on the judgment necessary to make estimates regarding revenue and costs associated with the companies contract types

Income Taxes – Uncertain Tax Positions

Based on tax positions not yet sustained

Outcomes are uncertain and subjective, making judgement of outcomes challenging

Conclusion

Will draft after I complete my paper

References

Dell technologies inc.

Introduction

Dell Technologies, Inc : Computer and technology company

Sells computers, software, servers and information services.

Currently ranked 28th on the Fortune 500

Stock Market: NYSE: DELL

Operates a financial strategy of negative working capital

Dell founded on 02/01/1984 and become Dell Technologies with the merger of Dell and EMC on 08/07/2016

CEO and Founder: Michael Dell

Income statement

The income statement is a crucial part of the financial report that companies use to report their financial performance. It is usually found in the organization’s f10-k report and other reports of public interest.

Fiscal Year Ended January 31, 2020

Total Net Revenue: $ 94,224 millions

Cost of net revenue (Products and services): $ 64,807 millions

Gross Margin: $ 29,417 millions

Consolidated statements of cash flows

Work in progress

Statement of stockholder’s equity

Authorized Shares: 472,000,000

assets

Working on this

Conclusion

Dell Technologies is one of the largest computer companies.

Dell has maintained revenue even during the most trying times of 2021

Net revenue and gross margin have continued to increase from 2019 – 2021.

2019: Net – $90,621 millions Gross Margin – $25,053 millions

2020: Net – 92,154 millions Gross Margin – $28,933 millions

2021: Net – $94,224 millions Gross Margin – $29,417 millions

References

Dell. (2021). Our timeline: Dell technologies. Corporate. Retrieved September 29, 2021, from https://corporate.delltechnologies.com/en-us/about-us/who-we-are/timeline.htm.

UNITED STATES SECURITIES AND EXCHANGE COMMISSION. (2021). UNITED STATES SECURITIES AND EXCHANGE COMMISSION. FORM 10-k. Retrieved September 29, 2021, from https://www.sec.gov/ix?doc=%2FArchives%2Fedgar%2Fdata%2F1571996%2F000157199621000007%2Fdell-20210129.htm.

Order your essay today and save 10% with the discount code ESSAYHELP