In: Finance
What is the Cash flow from Assets?
What is the OCF?
What are the changes in NWC?
What are the Net New Borrowing from Creditors and from Owners?
BALANCE SHEET - 2017 & 2018 |
||||||||||
ASSETS |
LIABILITIES and OWNERS EQUITY |
|||||||||
2017 |
2018 |
2017 |
2018 |
|||||||
Current Assets |
Current Liabilities |
|||||||||
Cash |
200 |
210 |
Accounts Payable |
180 |
185 |
|||||
A/R |
300 |
290 |
Notes Payable |
230 |
195 |
|||||
Inventory |
250 |
300 |
Total Current Liabilities |
410 |
380 |
|||||
Total Current Assets |
750 |
800 |
||||||||
Long-Term Debt |
245 |
255 |
||||||||
Fixed Assets |
||||||||||
Fixed Assets |
500 |
550 |
Owner's Equity |
595 |
715 |
|||||
Common Stock |
295 |
335 |
||||||||
Retained Earnings |
300 |
380 |
||||||||
TOTAL ASSETS |
1250 |
1350 |
TOTAL LIABILITIES and OWNERS EQUITY |
1250 |
1350 |
INCOME STATEMENT - 2018 |
||
Sales |
4500 |
|
Cost |
2950 |
|
Depreciation |
300 |
|
Earnings before Interest and Tax (EBIT) |
1250 |
|
Interest |
350 |
|
Earnings before Tax (EBT) - Taxable Income |
900 |
|
Tax (30%) |
270 |
|
Net Income |
630 |
|
Dividend |
550 |
|
Add. To Retained Earnings |
80 |
1) | Cash flow from assets = OCF-Net Capital expenditure-Change in NWC | |
OCF = EBIT+Depreciation-Taxes = 1250+300-270 = | $ 1,280 | |
Net capital expenditure = Ending net fixed assets-Beginning net fixed assets+Depreciation = 550-500+300 = | $ 350 | |
Change in NWC = (800-380)-(750-410) = | $ 80 | |
CFFA = 1175-350-80 = | $ 850 | |
2) | Cash flow to stockholders = Dividend+Beginning common stock-Ending common stock = 550+295-335 = | $ 510 |
3) | Cash flow to creditors = Interest expense+Beginning long term loan-Ending long term loan = 350+245-255 = | $ 340 |
Cash flow to creditors and stockholders | $ 850 | |
4) | Net new borrowing from creditors = 255-245 = | $ 10.00 |
Net new borrowing from stockholders= 335-295 = | $ 40.00 | |
Net new borrowing from creditors and owners | $ 50.00 |