Closed

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

This project was awarded to SaraHailes for £175 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
£20 - £250 GBP
Total Bids
11
Project Description

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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online