176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Create a formula to determing present value of a lease
Sign in to Add to Watch List

Finance & Management > Accounting

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Jun 26, 2012

Bidding period ended early.

Jun 11, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Jun 01, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    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
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I need to create a formula that can be inputted into a Microsoft 2010 excel spreadsheet that can calculate complex present value calculations.

You must be very confident with financial calculations and excel formulas. The goal of the formula is to determined the profit in a loan or lease.

Below is a sample transaction.
_______________________________________________________________
One months Deposit applied to the last billing period. (since this lease is billed quarterly that means that their last payment will actually only be two months payments since we are collecting 1 month up front.)

Term: 36 Months

Payment: $6,908

Cost of funds: 4.5%

Residual (aka future value): $25,000.00

Lease commencement: 7/15/2012

Billing frequency: Quarterly (payments will be quoted as monthly but billed quarterly. So for this example the lessee will be billed quarter for $20,725.00)

Lease commencement: The lease will start at on the 1st quarter that follows that date the lease funds. So for...

Sign in or Register to see more

Job ID: 30947477
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
Focused on equity research and financial consulting.
3
  |  
 4.1   |  Private   |  1 Jobs
Bid ID: 31156453  |  Submitted: Jun 11, 2012 13:55 ET 
Proposal SEALED

 Australia  |  
Qualified chartered accountant with a vast experience in financial modelling for large corporates as well as smaller businesses. Excel power...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 31087775  |  Submitted: Jun 8, 2012 00:57 ET 
Proposal SEALED

 United States  |  
expert on financial databases, Financial Modeling
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30969189  |  Submitted: Jun 3, 2012 11:34 ET 
Proposal SEALED

 United States  |  
MS word, MS Excel, PDF, SQL PL/SQL
Skills: SQL PL/SQL, Perl, Java
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30968863  |  Submitted: Jun 3, 2012 11:11 ET 
Proposal SEALED

 United States
We Strive for local impact. We are a consulting firm. Our mission is remove the barriers that impede growth in business. We work with...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30961310  |  Submitted: Jun 2, 2012 20:15 ET 
Proposal SEALED

 Saudi Arabia  |  
I am a qualified accountant with more than 8 years’ experience. I had been working in India as a portfolio analyst and accountant. Now I am in...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30959056  |  Submitted: Jun 2, 2012 15:39 ET 
Proposal SEALED

 Trinidad And Tobago  |  
I am a Finance Professional with 6 years experience. This includes experience with the Big 4 auditing firms and management of a financial...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30957855  |  Submitted: Jun 2, 2012 14:07 ET 
Proposal SEALED

Zenon H.      
Zenon H.'s identity has been verified.  Learn More
 Canada  |  
Over ten years financial modelling, business application development experience as an Excel VBA coder, I have developed automated spreadsheet and...
3
  |  
 4.7   |  $160 Earnings   |  3 Jobs
Bid ID: 30957784  |  Submitted: Jun 2, 2012 14:02 ET 
Proposal SEALED

 United Arab Emirates
CFA ...Charted Financial Analyst with over than 8 years experience in corporate finance, business valuation analysis and commercial real estate and...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30957372  |  Submitted: Jun 2, 2012 13:31 ET 
Proposal SEALED

Ian M.      
Ian M.'s identity has been verified.  Learn More
 South Africa  |  
I can add value to any business seeking independent financial valuations of their proposed investment in a new project, machinery, acquisition or...
2
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 30955759  |  Submitted: Jun 2, 2012 11:18 ET 
Proposal SEALED

 Philippines
We provide freelance estimating services
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 30955258  |  Submitted: Jun 2, 2012 10:36 ET 
Proposal SEALED

 United States  |  
I have worked in the energy sector for over 30 years, primarily power in the financial areas and business development in M&A and greenfield...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30955204  |  Submitted: Jun 2, 2012 10:31 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »