The client has made the following changes to the job.
Bidding period ended early.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
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
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