MBA620CompanyAFinancials6.xlsx

COMPANY A Three Year Data

A_CO_FIN Learner Copy Rev 3/14/21

COMPANY A

Illlustrative Data for Educational Purposes

All values shown are in thousands.

2017 2018 2019

Income Statement

Revenue 27,981 28,784 29,610

Cost of Goods Sold (COGS) 15,389 18,997 16,285

Gross Profit 12,591 9,786 13,324

Expenses

Salaries and Benefits 4,510 4,510 4,510

Rent and Overhead 1,804 1,804 1,804

Depreciation and Amortization 2,814 2,806 2,806

Interest 900 900 900

Total Expenses 10,028 10,020 10,020

Earnings Before Tax 2,563 (234) 3,305

Taxes 718 (65) 925

Net Earnings 1,845 (168) 2,379

2017 2018 2019

Balance Sheet

Assets

Cash 62,265 61,708 44,319

Accounts Receivable 1,380 1,419 1,460

Inventory 3,078 3,799 3,257

Property and Equipment 37,413 37,407 37,402

Total Assets 104,136 104,334 86,438

Liabilities

Accounts Payable 1,560 1,926 1,651

Debt 30,000 30,000 10,000

Total Liabilities 31,560 31,926 11,651

Shareholders’ Equity

Equity Capital 33,685 33,685 33,685

Retained Earnings 38,892 38,723 41,103

Shareholders’ Equity 72,577 72,408 74,788

Total Liabilities and Shareholders’ Equity 104,137 104,334 86,439

2017 2018 2019

Cash Flow Statement

Operating Cash Flow

Net Earnings 1,845 (168) 2,379

Plus: Depreciation and Amortization 2,814 2,806 2,806

Less: Changes in Working Capital (10,312) 395 (227)

Cash from Operations 14,971 2,242 5,412

Investing Cash Flow

Investments in Property and Equipment 2,706 2,800 2,800

Cash from Investing 2,706 2,800 2,800

Financing Cash Flow

Issuance (repayment) of Debt – – (20,000)

Issuance (repayment) of Equity – – –

Cash from Financing – – (20,000)

Net Increase (decrease) in Cash 12,265 (558) (17,388)

Opening Cash Balance 50,000 62,265 61,708

Closing Cash Balance 62,265 61,708 44,319

Supporting Schedules

Working Capital Schedule

Accounts Receivable 1,380 1,419 1,460

Inventory 3,078 3,799 3,257

Accounts Payable 1,560 1,926 1,651

Net Working Capital (NWC) 2,898 3,293 3,066

Change in NWC (10,312) 395 (227)

Depreciation Schedule

PPE Opening 37,521 37,413 37,407

Plus Capex 2,706 2,800 2,800

Less Depreciation 2,814 2,806 2,806

PPE Closing 37,413 37,407 37,402

Debt and Interest Schedule

Debt Opening 30,000 30,000 30,000

Issuance (repayment) – – (20,000)

Debt Closing 30,000 30,000 10,000

Interest Expense 900 900 900

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
Open chat
1
You can contact our live agent via WhatsApp! Via + 1 929 473-0077

Feel free to ask questions, clarifications, or discounts available when placing an order.

Order your essay today and save 20% with the discount code GURUH