karikounkel

Members

6

1. Loan Payment Calculations

I couldn't add "Notify me of replies" by editing, so I'm adding a post. Sorry.
2. Loan Payment Calculations

The formula that's in Excel uses the PMT function and it looks like this: PMT(AnnualInterestRate/PaymentsPerYear,Years*PaymentsPerYear,Amount). Then it uses the PPMT function to get the principle total: PPMT(AnnualInterestRate/PaymentsPerYear,A7,Years*PaymentsPerYear,Amount) A7 = which payment number you're on. Then it closes with IPMT function to get the interest total: IPMT(AnnualInterestRate/PaymentsPerYear,A7,Years*PaymentsPerYear,Amount) A7 = which payment number you're on. Those last two look the same, but they aren't. The initial information in the process is: ANNUAL INTEREST RATE, YEARS TO PAY, PAYMENTS PER YEAR, TOTAL AMOUNT. The goal looks like what's found here: https://www.excel-easy.com/examples/loan-amortization-schedule.html What I did so far is create a table that's linked by a one-to-many relationship with the vehicle table. In my child table, I have changed the initial information to: PRINCPLE AMOUNT (LOAN OR LEASE AMOUNT) NUMBER OF MONTHS TO PAY (replaces years to pay and payments per year) ANNUAL INTEREST RATE START DATE What I plan to do is calculate the Payment Amount using this calculation in my table: 1. Calculate monthly interest rate = (1+annual interest rate)*(1/12-1). 2. Calculuate monthly payment = (principle*monthly interest rate from #1/1)-1+(monthly interest rate from #1). 3. Calculate principle =monthly payment amount from #2 - (remaining balance which is different after the first month*monthly interest rate from #1) 4. Calculate declining balance due = remaning balance-princple from line #3. I'm trying to put it all in the table rather than in a datasheet. Then I'll add a field for payment date, but haven't figured out how to make it just advance monthly just yet.
3. Slide Show

Thank you; I'll try that.
4. Slide Show

Is it the case that you need to reference each image separately? I have hundreds and the client wants to be able to add more. If I have to continue to add the images anyway, there's no point in making it possible for her to add. I wasy trying to ask this question based on this article: How To Create Image Slideshow In Html
5. JS Signature

I am using WordPress Panoramic theme and trying to insert a digital signature box using the JS Script found at First, the link is broken to get a java script file to upload to my site, which I also don't know what to do with. Second, I cannot figure out where to do this part of the instruction: a. Copy the code below and paste inside the <head> section of your web page: <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
6. parameters Display values instead of numbers for multi-select listbox

I do not actually see an answer to this question, and I am having the same problem. I don't even get the list of numbers though; my two list box fields are just not included as an option to add to my email reports.
×
×
• Create New...