Jump to content

karikounkel

Members
  • Posts

    6
  • Joined

  • Last visited

Posts posted by karikounkel

  1. 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.

  2. 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

  3. 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>
×
×
  • Create New...