In: Finance
Larry’s best friend, Garfield, owns a lasagna factory. Garfield’s financial skills are not very strong, so he asked Larry to take a look at his financials. Here is the information Garfield provided to Larry for 2019.
- Sales were $23,730
- COGS were $16,780
- Depreciation was $2,840
- Interest paid was $414
- Tax rate was 35%
- The paid dividends were $616
Garfield also gathered some balance sheet information for 2018 and 2019. The numbers are presented in the following table. December 31, 2018 December 31, 2019 Current Assets $2,940 $3,528 Net Fixed Assets $16,560 $18,840 Current Liabilities $2,592 $2,484
| December 31, 2018 | December 31, 2019 | |
| Current Assets | $2,940 | $3,528 |
| Net Fixed Assets | $16,560 | $18,840 |
| Current Liabilities | $2,592 | $2,484 |
Because Larry is very busy following the current market developments, he asked you to help him. You must
a) Compute the net income
b) Compute the operating cash flow
c) Compute the free cash flow
d) Explain and interpret the positive or negative sign of your answer in part c.
Check point: OCF = $5,511.50
| a] | Sales | $ 23,730.00 |
| COGS | $ 16,780.00 | |
| Depreciation | $ 2,840.00 | |
| EBIT | $ 4,110.00 | |
| Interest | $ 414.00 | |
| EBT | $ 3,696.00 | |
| Tax at 35% | $ 1,293.60 | |
| NI | $ 2,402.40 | |
| b] | OCF = EBIT*(1-t)+Depreciation = 4110*(1-35%)+2840 = | $ 5,511.50 |
| c] | FCF = OCF-Capital expenditure-Change in NWC | |
| Capital expenditure = Ending NFA-Beginning NFA+Depreciation = 18840-16560+2840 = | $ 5,120.00 | |
| Change in NWC = Ending NWC-Beginning NWC = (3528-2484)-(2940-2592) = | $ 696.00 | |
| FCF = 5511.50-5120-696 = | $ -304.50 | |
| d] | The negative FCF means that the net investment | |
| in assets [fixed and current] is more than the | ||
| cash generated by operations. The deficit should | ||
| have been made up by cash sourced from | ||
| creditors/stockholders. |