Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Build & maintain a financial model for energy retail company
Sign in to Add to Watch List

Finance & Management > Other - Finance & Mgmt

View Change History

The client has made the following changes to the job.


Job awarded.

Aug 31, 2011

Job Description

  |  Change History >>


  • Posted: Sun, Aug 28, 2011
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Hourly Rate: Not Sure
  • Hrs/wk: 40 | Duration: 14255 hrs
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

We are a small -growing- energy retail company, selling electricity and gas to consumers and small businesses.

We require a detailed financial model for the next 2-3 years:
- cash flow (liquidity on day-basis)
- income statement (month-basis and roll-up to year)
- balance (month-basis and roll-up to year)

Cash flow modelling for our business is relatively complex. Among other things, we need to keep track of:

- customer advance invoices based on estimated yearly consumption (fixed amount per month);
- customer invoices after meter readings come in;
- purchasing of gas & electricity based on estimated aggregate monthly consumption (severe seasonal swings, esp. for gas);
- payments to various electricity & gas transport (grid) operators;
- tax payments (energy tax and VAT);
- deposits (security) required for various suppliers;

For a cash flow / liquidity model, a granularity of a day or at least a week is required; month-basis is too unprecise.

So far, we have been using Excel. H...

Sign in or Register to see more

Job ID: 25879500
Hourly Rate: Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Nav Analytics is a business analytics firm with extensive experience in a variety of industries developing financial, business development, and...
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 25913791  |  Submitted: Aug 30, 2011 19:36 ET 
Proposal SEALED

 India  |  
6+ years of experience in Financial Modeling, Report Writing, Writing Business Plan, Financial Analysis, Business Presentation and Feasibility...
 5.0   |  Private   |  0 Jobs
Bid ID: 25911103  |  Submitted: Aug 30, 2011 15:20 ET 
Proposal SEALED

 United States  |  
Bakley Smith, CFA is an analyst and financial expert. He was an equity research analyst for ten years and the CFO of a startup for four years. He...
 5.0   |  $20 Earnings   |  1 Jobs
Bid ID: 25895127  |  Submitted: Aug 29, 2011 16:33 ET 
Proposal SEALED

Benish Akram      
Benish Akram's identity has been verified.  Learn More
 Pakistan  |  
I am a qualified CFA and passed all three levels in my first attempt, after doing MPA with major in Finance and received two Gold Medals. I have...
 5.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 25884894  |  Submitted: Aug 29, 2011 04:00 ET 
Proposal SEALED

Dipesh Jain      
Dipesh Jain's identity has been verified.  Learn More
 India  |  
I am an MBA (Finance) graduate with experience in working with an admired company's KPO.
 5.0   |  $848 Earnings   |  17 Jobs
Bid ID: 25881650  |  Submitted: Aug 28, 2011 22:20 ET 
Proposal SEALED

 United States
 0.0   |  Private   |  0 Jobs
Bid ID: 25880501  |  Submitted: Aug 28, 2011 18:56 ET 
Proposal SEALED

JaZaa Financial Advisory Pvt....      
One or more team members at  are verified.  Learn More
 India  |  
JaZaa Consultancy Services, a unit of Jazaa Financial Advisory Pvt. Ltd. provides exhaustive financial consultancy including Project Appraisal,...
 5.0   |  Private   |  46 Jobs   |  7 verified credential(s)
Bid ID: 25879833  |  Submitted: Aug 28, 2011 17:06 ET 
Proposal SEALED
Elance is now an Upwork company.
Upwork is the choice of 4M+ clients. Get started working on Upwork today.
Are you ready to post a job like this one?
Post a Similar Job »