| FINANCIAL STATEMENT EXCEL TEMPLATE |
|
|
| | | | | | | GIVEN DATA: |
| Income statement |
| | 2016 | | 2017 | | | | 2016 | 2017 |
| | | | | | | Cost of Goods Sold | 201,943 | 252,768 |
| | | | | | | Cash | 30,629 | 32,567 |
| | | | | | | Depreciation | 56,876 | 64,826 |
| | | | | | | Interest expense | 13,130 | 14,925 |
| | | | | | | Selling & Administrative Expenses | 43,130 | 53,753 |
| | | | | | | Accounts Payable | 52,910 | 58,998 |
| | | | | | | Net Fixed Assets | 262,617 | 314,625 |
| | | | | | | Sales | 403,456 | 485,832 |
| | | | | | | Accounts Receivable | 21,524 | 27,652 |
| | | | | | | Notes Payable | 24,308 | 26,915 |
| | | | | | | Long-term Debt | 129,342 | 144,570 |
| | | | | | | Inventory | 45,785 | 58,425 |
| | | | | | | Tax Rate | 35% | 35% |
| | | | | | | Dividend Payout % | 50% | 50% |
| | Balance Sheet |
| | 2016 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| | 2017 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Operating Cash Flow for 2016 = |
|
|
| Operating Cash Flow for 2017 = |
marlon0510
excell2020.xls
