Hello,
I want to make a cash flow statement of Mfg company (out of India) with the available projected data of Purchase / CAPEX Requirement / Expenses / Sales / (Recurring Expenses Each month)
I have 5 scenario -
A. 1. 45 Days Credit from Supplier - PURCHASE
2. WIP - 60 Days
3. Credit Sales - 90 Days
B. 1. CASH Payment to Supplier
2. WIP - 60 Days
3. Credit Sales - 90 Days
C. 1. Cash Payment to Supplier
2. WIP - 60 Days
3. Credit Sales - 90 Days
D. 1. Cash Payment to Supplier
2. WIP - 60 Days
3. 25% Advance from Customer
4. 75% Credit for 60 Days from Customer
E. 1. 60 Days Credit to Supplier
2. WIP - 60 Days
3. FULL CASH SALE
Can Anyone help me to make all this in EXCEL File. I can do it... but no guidance.... Please Help.4
Thank You.
CAclubindia
