In: Finance
The Lakeside Inn had an operating cash flow of $48,450. Depreciation was $6,700 and interest paid was $2,480. A net total of $2,620 was paid on long-term debt. The firm spent $24,000 on fixed assets and decreased net working capital by $1,330. What was the amount of the cash flow to stockholders?
Solve using Excel Formulas
Steps | ||||||||||||
1 | Calculating the cash flow from assets:- | Operating Cash Flow - Net Capital spending - Change in net working Capital | ||||||||||
Operating Cash Flow | $ 48,450.00 | |||||||||||
Net Capital Spending | $ 24,000.00 | |||||||||||
Change in Net Working Capital | $ (1,330.00) | |||||||||||
Cash flow from Assets:- | $ 25,780.00 | |||||||||||
2 | Calculating the cashflow to creditors:- | Interest paid + Amount paid on long term debt | ||||||||||
Interest Paid | $ 2,480.00 | |||||||||||
Amount paid on long term debt | $ 2,620.00 | |||||||||||
Cash Flow to creditors:- | $ 5,100.00 | |||||||||||
3 | Calculating the cashflow to stock holders as follows:- | Cashflow from assets + cashflow to creditors | ||||||||||
Cash flow from Assets | $ 25,780.00 | |||||||||||
Cash Flow to creditors | $ 5,100.00 | |||||||||||
Cashflow to stockholders:- | $ 30,880.00 | |||||||||||