Prepare a Word document paper about your company.  Include an APA formatted cover page and introduction to the company.  Then, using excerpts from your spreadsheets developed in the course, prepare a paper that addresses the employees, the financial condition of the firm, the company’s sales, and other information or data/graphics that you choose.   While text and discussion is needed, much of the paper should be portions of spreadsheets from Excel, graphics, tables, etc. BUSINESS REPORTING PAPER

BUSINESS REPORTING PAPER

Prepare a Word document paper about your company.  Include an APA formatted cover page and introduction to the company.  Then, using excerpts from your spreadsheets developed in the course, prepare a paper that addresses the employees, the financial condition of the firm, the company’s sales, and other information or data/graphics that you choose.   While text and discussion is needed, much of the paper should be portions of spreadsheets from Excel, graphics, tables, etc.

Side note: Please see previous attachment from past assignments  for your reference to complete paper. 

Executive Compensation

Nora Mollie Estate
$ 25,000,000
Position Last Name First Name # Shares Annual Salary Bonus Retirement Contribution Car & Housing Allowance Total Annual Compensation
President and CEO Carter Derrek 22.7 $ 227,000 $ 250,000 $ 18,160 $ 50,000.00 $ 545,160
Chief Financial Officer (CFO) Robinson Robert 18.2 $ 182,000 $ 125,000 $ 14,560 $ 50,000.00 $ 371,560
Chief Information Officer (CIO) Frazier Wanda 17.5 $ 175,000 $ 125,000 $ 14,000 $ 50,000.00 $ 364,000
VP of Marketing Woodson Tonya 12.5 $ 125,000 $ 87,500 $ 7,500 $ 32,500.00 $ 252,500
VP of Product Development Walton Wayne 12.5 $ 125,000 $ 87,500 $ 7,500 $ 32,500.00 $ 252,500
Controller Hudson Marsha 8.5 $ 85,000 $ 50,000 $ 4,250 $ 4,250.00 $ 143,500
VP of International Operations Marshall Nora 12.5 $ 125,000 $ 87,500 $ 7,500 $ 32,500.00 $ 252,500
VP of Sales Moore Darryl 12 $ 120,000 $ 87,500 $ 7,200 $ 32,200.00 $ 246,900
Director of US Operations Johnson Thomas 9.2 $ 92,000 $ 50,000 $ 4,600 $ 4,600.00 $ 151,200
Director of South Africa Operations Patrick Ashley 9.2 $ 92,000 $ 50,000 $ 4,600 $ 4,600.00 $ 151,200
Director of Mexico Operations Ragland Frank 9.2 $ 92,000 $ 50,000 $ 4,600 $ 4,600.00 $ 151,200
Director of South America Operation Briggs Clifton 9.2 $ 92,000 $ 50,000 $ 4,600 $ 4,600.00 $ 151,200
Total Per Catergory 153.2 $ 1,532,000.00 $ 1,100,000.00 $ 99,070.00 $ 302,350.00 $ 3,033,420.00
Prepared By: Derrek Carter

2020 Financials

Nora Mollie Estate Nora Mollie Estate Nora Mollie Estate
Income Statement Balance Sheet Cash Flow Statement
For the year ended December 31, 2020 December 31, 2020 Decemeber 31, 2020
Revenue Assests Liabilities Operating Cash Flow
Sales Revenue $ 15,650,000 Cash $ 31,000,000 Accounts Payable $ 45,000 Net Earning $ 6,943,373
Cost of Goods Sold (COGS) $ 2,700,000 Accounts Receiveable $ 94,000 Debt $ 9,800,000 Plus: Depreciation & Amortization $ 120,000
Gross Profit $ 12,950,000 Inventory $ 13,000,000 Total Liabilities $ 9,845,000 Less: Change in Working Capital $ 450,000
Expenses Property & Equipment $ 560,000 Cash from Operations $ 6,493,373
Salaries and Benefits $ 3,033,420 Shareholder Equity
Rent & Overhead $ 1,000,500 Equity Capital $ 27,000,000 Investing Cash Flow
Depreciation & Amortization $ 120,000 Retained Earnings $ 22,000,000 Investments in Property & Equipment $ 220,000
Interest $ 7,000 $ 44,654,000 Total Liabilities and Shareholder Equity $ 58,845,000 Cash from Investing $ 220,000
Total Expenses $ 4,160,920
Earnings Before Tax $ 8,789,080
Taxes $ 1,845,707
Net Earnings $ 6,943,373

Rev Executive Compensation

Nora Mollie Estate
$ 15,650,000
Position Last Name First Name # Shares Annual Salary Bonus Retirement Contribution Car & Housing Allowance Total Annual Compensation
President and CEO Carter Derrek 22.7 $ 227,000 $ 156,500 $ 18,160 $ 50,000.00 $ 451,660
Chief Financial Officer (CFO) Robinson Robert 18.2 $ 182,000 $ 78,250 $ 14,560 $ 50,000.00 $ 324,810
Chief Information Officer (CIO) Frazier Wanda 17.5 $ 175,000 $ 78,250 $ 14,000 $ 50,000.00 $ 317,250
VP of Marketing Woodson Tonya 12.5 $ 125,000 $ 54,775 $ 7,500 $ 32,500.00 $ 219,775
VP of Product Development Walton Wayne 12.5 $ 125,000 $ 54,775 $ 7,500 $ 32,500.00 $ 219,775
Controller Hudson Marsha 8.5 $ 85,000 $ 31,300 $ 4,250 $ 4,250.00 $ 124,800
VP of International Operations Marshall Nora 12.5 $ 125,000 $ 54,775 $ 7,500 $ 32,500.00 $ 219,775
VP of Sales Moore Darryl 12 $ 120,000 $ 54,775 $ 7,200 $ 32,200.00 $ 214,175
Director of US Operations Johnson Thomas 9.2 $ 92,000 $ 31,300 $ 4,600 $ 4,600.00 $ 132,500
Director of South Africa Operations Patrick Ashley 9.2 $ 92,000 $ 31,300 $ 4,600 $ 4,600.00 $ 132,500
Director of Mexico Operations Ragland Frank 9.2 $ 92,000 $ 31,300 $ 4,600 $ 4,600.00 $ 132,500
Director of South America Operation Briggs Clifton 9.2 $ 92,000 $ 31,300 $ 4,600 $ 4,600.00 $ 132,500
Total Per Catergory 153.2 $ 1,532,000.00 $ 688,600.00 $ 99,070.00 $ 302,350.00 $ 2,622,020.00
Prepared By: Derrek Carter

Financial Statements 5 Years

Revenue
Sales Revenue
Cost of Goods Sold (COGS)
Gross Profit
Expenses
Salaries and Benefits
Rent & Overhead
Depreciation & Amortization
Interest
Total Expenses
Earnings Before Tax
Taxes
Net Earnings