Fill This Form To Receive Instant Help
Homework answers / question archive / Final Use the above information to calculate Cilca's: a
Final
+sales $450,000
+increase a/p $160,000
-decrease A/R $80,000
= $690,000 cash used by operating activities
+real estate $440,000
+Issued shares of common stock $200,000
-Dividends paid $480,000
-bank loan $360,000
= - $200,000 cash used from financial activities
Cash Flow from Operating = Net Income including deprec + Decrease in inventory + Increase in Inventory + depletion expense - Decrease in Acct Payable + tax - increase A/R = 40,000 +10,000 +(21,000 + 18,000) - 5,000 +7,000 - 10,000 = $81,000
Average AR =(518+562)/2=$540
Average Inventory =(535+564)/2=$549.50
Average AP =(203+192)/2=$197.50
Average days in receivables=Receivables/Credit sales*365
=(540/3636)*365 days=54.21 days
Average inventory days=(Inventory/COGS)*365 days
=(549.5/2294)*365 days=87.43 days
Average payables=(Average AP/Average cost )*365 days
=197.5/(2294+564-535)*365 days=31.03 days
WC financing=(54.21+87.43-31.03)=110.61 days
$1,847,712/$2,928,965= 63.1%
$1,847,712/$1,081,253 = 170.9%
($45,000 + $450,000)/($1,081,253 + $450,000 + $45,000) = 31.4%
($45,000 + $450,000)/$1,081,253 = 45.8%
11.35