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
PBT
Key inputs for cashflow
Trade Debtor days calculation and what if cells
Trade Creditor days calculation and what if cells
VAT input/output
Capex
Capital repayments
Interest
Opening/closing bank
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.
I am professional excel expert can provide you the auto excel spread sheet of financial statements (P&L, Balance sheet & cash flow) integrated with each other and with input sheet. This financial statements automatically change as per your requirement when you change the data in input sheet. Please contact for further discussion.
HI,
My name is Md Jahangir, and am a CFA, I have worked on various financial model of diffren cos. from diffrent industries.
I am keen to take this project.
Looking forward to you. !
Regards
Md Jahangir
(CFA-CRO0237889)
Hi,
I am an experienced accountant with good command on Cash Flow and Financial Statements. I am well versed with several excel formulas and formating. I am honest, committed and hard worker. I assure you accuracy, on time delivery of completed work and confidentiality of data.
Kindly give me a chance to prove myself.
Regards,
Muzamil
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.