Looking for a simple excel template to drive a simple monthly cashflow out of a monthly P&L projection up to 36 months with basic what ifs (ie variable debtor/creditor days, variable margin etc)
Key inputs P&L
Sales, COGS, margin,Labour, Distribution etc to Operating contribution
Fixed Costs to EBITDA level
Interest, Depn, goodwill etc
Key inputs for cashflow
Trade Debtor days calculation and what if cells
Trade Creditor days calculation and what if cells
Standard opening BS format
Base P&L structure attached
UK qualified accountant with over twenty years financial and Excel experience. I have already created a model that does everything you list in your project description. Please see PMB for further details of bid.
11 freelancers are bidding on average £165 for this job
Hi, I am experience Cost & Management Accountant,Presently I am preparing financial statement for large electricity distribution company. I am in better position to complete your project. Thanks and regards.