excel morgage payment formula 
...for different senerios ie different payment amounts different interest rates etc
so all columms are formulaised...or captial and interest mortgage...ie the monthly payments have a component of interest which is I and...column J. There is a formula for calculating this which we think is based on the interest charging balance 
11 
Data Processing, Accounting, Excel 
Jul 15, 2008 
Jul 15, 2008Ended 
$45 
Excel formula to calculate loan payment  ADJUSTABLE interest rate 
Very simple, need one formula to complete online calculator project, using Excel. I just need the correct...correct, working formula. Winning bidder will not be required to edit any documents or post anything online...online. Provide the correct formula, and the job is complete. This should take minimal to no time for 
8 
Data Processing, Data Entry, Excel 
Apr 23, 2015 
Apr 23, 2015Ended 
$23 
Excel sheet Formula 
?
Looking for a mortgage payment calculator in an excel sheet. I need it to be part on an PP presentation...Deliverables
Looking for a mortgage payment calculator in an excel sheet.
1. **Loan Amount**
2. **Term...**Lifetime Cap** **(%)** **
**? **
**Home Equity Payment Calculator**
**What will your monthly home equity 
23 
PHP, Windows Desktop, Project Management, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, Microsoft, MySQL 
May 9, 2009 
May 9, 2009Ended 
$47 
Excel Power Pivot DAX formula for interest payable on partial loan prepayment 
...calculated column of the data model behind the attached Excel file that will reproduce the calculation of the...please.
This result is needed to calculate the interest that becomes payable when the principal of a loan...is partially repaid, where:
Payable interest = (Total interest accrued to date  Any amount already 
3 
Excel 
Nov 21, 2014 
Nov 21, 2014Ended 
$50 
excel sheet with formula for calculations 
need excel sheet with formulas for calculating loan at a set interest rate with compound interest, I have 
67 
Data Processing, Data Entry, Excel, Mathematics 
Sep 29, 2015 
Sep 29, 2015Ended 
$21 
255316 Need Calculator Formula Built 
...willing to work with them also. This is a simple excel spreadsheet I need to have formulated. This can...calculator if it can be inexpensivly designed.
Interest Rate= Editable 4.24%
Divided x 100
Divided x...trying to do... This payment is broken down by three
people making interest as well as principal payments 
0 
XML, Data Entry, Wordpress, Microsoft Access, MySQL, Anything Goes 
Oct 1, 2008 
Oct 1, 2008Ended 
 
325377 IMACROS and excel formula 
...exported to excel. The Macro will have to do this.
When the reports are downloaded to excel it would...they could be in seperate tabs.
Then an excel formula will need to be written that: It can be an index/match/vlookup...index/match/vlookup that goes and pulls interest rates for a particular city and state from the downloaded 
1 
PHP, Anything Goes 
Jun 4, 2009 
Jun 4, 2009Ended 
$135 
Excel formula required 
I need a formula that will search the cells in a column (text search) and based on the result, populate...contractors of interest. Very simple project for an Excel expert. I just need the formula is all. 
6 
Excel 
Aug 22, 2013 
Aug 22, 2013Ended 
$10 
Excel Formula Max Borrow 
Hi
I need to create a formula to give me the max borrowing capacity by considering the surplus remaining...get a surplus of just above 100
I wanted a formula to present a surplus of 500 left over and alternate...sample file to demo this
I have the formula that uses interest rate and term however as there is going 
20 
Excel 
Jan 26, 2014 
Jan 26, 2014Ended 
$20 
Excel formula & calculation Work 
...Microsoft Excel.
Please review the file attached.
We require 5 separate cells to have a formula calculated...calculated.
Must be good communicator.
Payment made upon checking the formula are working. 
30 
Data Processing, Data Entry, Excel 
Jan 13, 2015 
Jan 13, 2015Ended 
$17 
simple excel formula 
...who knows excel. I have added a screen shot of the excel page and this is the following formula I like to...line 18 shows % target reached
where I need a formula is for line 20 and 21. I like line 20/21 to calculate...knows how to formulate excel. need it asap please let me know if your interest 
13 
Excel 
Oct 14, 2014 
Oct 14, 2014Ended 
$25 
Excel formula & calculation Work 
...Microsoft Excel.
Please review the file attached.
We require 5 separate cells to have a formula calculated...calculated.
Must be good communicator.
Payment made upon checking the formula are working. 
20 
Data Processing, Data Entry, Excel 
Jan 13, 2015 
Jan 13, 2015Ended 
$20 
MS Excel Workbook: Judgment Interest 
...I need a quick, inexpensive Excel Workbook.
Excel noob needs an MS Excel Workbook (template) created...to be able to determine past and future money interest (i.e. prejudgment and postjudgment) with ability...future dates along with changeable percent of interest. Would like the ability to figure multiple past 
1 
Accounting, Excel, 
Feb 20, 2013 
Feb 20, 2013Ended 
$2 
Power Pivot DAX formula for interest payable when loan is partially repaid 
In the Excel data model I need to calculate the interest that becomes payable when the principal of a...is partially repaid, where:
Payable interest = (Total interest accrued to date  Any amount already...payable. I have the repayment number, the total interest accrued to date and the ratio of the repaid amount 
12 
Excel 
Nov 21, 2014 
Nov 21, 2014Ended 
$28 
Excel file with formula needed 
...need this attached file to be created on a blank excel so every month we can just add the job name and...should have a section if customer pays a partial payment then it will give the balance. Any question feel 
41 
Excel 
Apr 10, 2011 
Apr 10, 2011Ended 
$46 
mortgage excel capital repayments formula 
Hi
What we want is a formula put in column F to automatically calculate the capital repayments figures...a mortgage account put on an excel spreadsheet
column C is the interest rate charged, D is the capital...is the interest charged and column F is the capital payments.
Of course in a repayment (interest and capital) 
22 
Data Processing, Accounting, Excel 
Jul 20, 2008 
Jul 20, 2008Ended 
$93 
VBA interest calculator accounting for variable interest rates 
I want a sheet created which can be opened by Excel 2010. There will be two tables and a named range...Folio)
Table 2 is a table of interest rates, showing yearly interest rates and the dates from which...calculate the interest due, taking account of payments received and changing interest rates. Interest is only 
28 
Excel, VB.NET 
Aug 17, 2015 
Aug 17, 2015Ended 
$63 
178236 EXCEL SPREADSHEET GURU FORMULA 
...FOR EXCEL SPREADSHEET GURU:
THE SPREADSHEET:
The left column should be a declining interest formula 
0 
Microsoft Access, Anything Goes 
Nov 8, 2007 
Nov 8, 2007Ended 
 
Very small Microsoft Excel formula 
...iphone are the same
No VB if possible
Payment terms:
Payment will be in the following milestones:

15 
Visual Basic, Data Processing, Data Entry, Excel 
Nov 4, 2014 
Nov 4, 2014Ended 
$21 
Excel Formula Project  Custom Quote 
I need an excel expert to create me a custom formula workbook.
The project is to create a "custom...hardware related products.
I want to create an excel workbook application. The purpose is to give my...be the same thing except in excel, infopath or access. i would prefer excel since i have a little more 
18 
XML, Script Install, Windows Desktop 
May 27, 2006 
May 27, 2006Ended 
$79 