In Progress

Simple Excel P&L, BS, Cashflow Template 36 mths projectionn

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

Skills: Accounting, PHP, Software Architecture

See more: template basic, cashflow template, basic template, monthly excel template, cashflow, structure template, structure excel, goodwill excel template, excel template debtor days, simple cashflow, ebitda template excel, basic excel, template simple, simple excel template, template standard, standard template, key bank, costs template, capital sales, level accounting, excel template simple, excel template ebitda, structure simple, ebitda excel template, basic format

About the Employer:
( 2 reviews ) moreton in marsh, United Kingdom

Project ID: #1283578

Awarded to:

SaraHailes

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.

£175 GBP in 2 days
(5 Reviews)
4.2

11 freelancers are bidding on average £165 for this job

waqar21081974

I have necessary resources and skills to execute this task. Kindly check your inbox for further details.

£150 GBP in 7 days
(27 Reviews)
5.0
mike25

If you want to work with me, drop me a message.

£190 GBP in 20 days
(24 Reviews)
4.7
WebDesignall

Hi I'm finance graduated,master degree in finance work with a economics and accounting graduated partners,master degree in economics and accounting respectively,i was working as a teacher in finance for almost 20 year More

£150 GBP in 4 days
(3 Reviews)
4.1
muhammadandco

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 automatical More

£56 GBP in 3 days
(4 Reviews)
3.1
jahangirnism

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 ( More

£300 GBP in 7 days
(1 Review)
1.4
MuzamilShah

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, o More

£200 GBP in 1 day
(0 Reviews)
0.0
KELEMEWORK

I'm interested sir

£140 GBP in 10 days
(0 Reviews)
0.0
acountcc

Hi, We are a professional firm at India. We can understand your requirements better and can serve you in the way you require. Thanks & Regards,

£150 GBP in 3 days
(0 Reviews)
0.0
Shiyasha

I ll do my best.

£100 GBP in 10 days
(0 Reviews)
0.0
Najibafzal

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.

£199 GBP in 4 days
(0 Reviews)
0.0