Module 3 - Homework Help

profilebdav10111
CompanyBFinancials.xlsx
Home>Business & Finance homework help>Module 3 - Homework Help

COMPANY B Three-Year Data

B_CO_FINANCE Learner Copy Rev 3/14/21
COMPANY B
Illlustrative Data for Educational Purposes
All values shown are in thousands.
2017 2018 2019
Income Statement
Revenue 27,981 26,302 27,091
Cost of Goods Sold (COGS) 15,389 18,411 18,151
Gross Profit 12,591 7,891 8,940
Expenses
Salaries and Benefits 2,910 2,600 2,910
Rent and Overhead 1,354 1,354 1,354
Depreciation and Amortization 2,814 2,806 2,776
Interest 2,700 1,800 1,800
Total Expenses 9,778 8,560 8,840
Earnings Before Tax 2,813 (669) 100
Taxes 788 (141) 21
Net Earnings 2,025 (529) 79
2017 2018 2019
Balance Sheet
Assets
Cash 82,445 82,914 72,944
Accounts Receivable 1,380 1,297 1,336
Inventory 3,078 2,018 1,989
Property and Equipment 37,413 37,007 37,032
Total Assets 124,316 123,236 113,301
Liabilities
Accounts Payable 1,560 1,009 995
Debt 90,000 90,000 80,000
Total Liabilities 91,560 91,009 80,995
Shareholders' Equity
Equity Capital 33,685 33,685 33,685
Retained Earnings (929) (1,458) (1,379)
Shareholders' Equity 32,756 32,227 32,306
Total Liabilities and Shareholders' Equity 124,316 123,236 113,301
2017 2018 2019
Cash Flow Statement
Operating Cash Flow
Net Earnings 2,025 (529) 79
Plus: Depreciation and Amortization 2,814 2,806 2,776
Less: Changes in Working Capital (10,312) (592) 25
Cash from Operations 15,151 2,869 2,830
Investing Cash Flow
Investments in Property and Equipment (2,706) (2,400) (2,800)
Cash from Investing (2,706) (2,400) (2,800)
Financing Cash Flow
Issuance (repayment) of Debt - - (10,000)
Issuance (repayment) of Equity - - -
Cash from Financing - - (10,000)
Net Increase (decrease) in Cash 12,445 469 (9,970)
Opening Cash Balance 70,000 82,445 82,914
Closing Cash Balance 82,445 82,914 72,944
Supporting Schedules
Working Capital Schedule
Accounts Receivable 1,380 1,297 1,336
Inventory 3,078 2,018 1,989
Accounts Payable 1,560 1,009 995
Net Working Capital (NWC) 2,898 2,306 2,331
Change in NWC (10,312) (592) 25
Depreciation Schedule
PPE Opening 37,521 37,413 37,007
Plus Capex 2,706 2,400 2,800
Less Depreciation 2,814 2,806 2,776
PPE Closing 37,413 37,007 37,032
Debt and Interest Schedule
Debt Opening 90,000 90,000 90,000
Issuance (repayment) - - (10,000)
Debt Closing 90,000 90,000 80,000
Interest Expense 2,700 1,800 1,800