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