Week 5 Power BI Executive Summary

profileJaylin001
CompanyB.xlsx
Home>Business & Finance homework help>Management homework help>Week 5 Power BI Executive Summary

MBA620_Module five_Assignment t

B_CO_FINANCE Learners 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 & 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 & 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
Shareholder's Equity
Equity Capital 33,685 33,685 33,685
Retained Earnings -928 -1,457 -1,378
Shareholder's Equity 32,757 32,228 32,307
Total Liabilities & Shareholder's Equity 124,317 123,236 113,301
2017 2018 2019
Cash Flow Statement
Operating Cash Flow
Net Earnings 2,025 -529 79
Plus: Depreciation & 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 & 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 & 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