amortization schedule

  1. DRSteele

    Loan Amortisation Scedule with new Spiller functions

    The revised calculation engine for Excel365 includes new functions that spill and allow for dynamic arrays. Using this new technology, it's easy to create a loan amortisation schedule that omits the need to create the correct number of rows or complex formulas to account for the correct number...
  2. I

    Amortization Schedule Formula Problems

    Hello, We just signed on an equipment note for 5 years with 8 payments each year followed by a 4 month sabbatical. I made a change to the amortization schedule excel template we always use which only allowed for 12 consecutive months of payments. I think I have all but the date functions...
  3. S

    Excel Variable Loan Amortisation

    Hi there I cannot seem to get the mortgage/loan bank statement replicated in excel. Can someone please help? I think it has something to do with when they change rates based on the number of day. I think they use exact days. You can see at the top of the statement the rates and the date...
  4. R

    loan Amortization table with inconsistent payments

    I am not the fastest at excel but generally know how to set up an amort table. However this one is a little different then what I'm used to: How would I set up an amort table with an extra column to be able to show the random payments made. They are not made on the same day/period. The...
  5. S

    Amortisation Calculator

    Hi Guys, I am looking to do a presentation where I present the costs differences between 2 home loans. 1. Example one is a loan at 5% pa 2. Example two is a loan at 4% pa There are two graphs that i am trying to build. 1. the cost savings between example 2 and 1 over a 30 year period...
  6. B

    365/360 Interest Type Amortization Table

    Long story short, I am trying to back into an amortization table using the following variables: Original Loan Amount = $575,000 Loan Start Date = 10/24/2011 Payment Date = The 24th day of each month (first payment 11/24/2011) Interest Type = 365/360 Interest Rate (before adjusting because of...
  7. N

    Amortization schedule for multiple loans

    Hello, I need to create an amortization table for several thousand loans. I could create a seperate amortization schedule for each loan, but as you can imagine, doing so would take a long time. These loans have varying interest rates, loan periods, and beginning balances, so it is not as if I...
  8. R

    Need Help with Excel IF stmt within an Amortization Schedule ASAP!

    Hello All, I need help to perform the following which I have included as an excel paste. Hope its legible. Please see towards bottom on what I need help with. Thanks!! <tbody> Company Start Date End Date Commitment Threshold Term in Months Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12...
  9. J

    More Complex Amortization Schedule?

    I am trying to find a loan amortization schedule that contemplates a changing interest rate as well as changing principal every month. I need this for a real estate loan that is tied to 3-month LIBOR, and also has an increasing loan balance due to leasing costs being funded as they occur. So...
  10. F

    Amort Schedule with Varying Dates & Partial First Payment

    I am analyzing a portfolio of loans. I set up my spreadsheet to run an amortization schedule for a sample loan, but what I am finding is that the loans have varying dates of when they were issued - 6/3/10; 3/18/09, etc, at all times of the month. I am trying to create a spreadsheet that...
  11. T

    Error:You've entered too many arguments

    Error:You've entered too many arguments Yea, I know this is a common problem, but I'm stumped. Doing it in VBA is not an option because I need it to run at work and we are still using Excel 03 with no macros enabled Formula...
  12. M

    Decreasing loan principle over a term

    I am having trouble with the formula to reduce a loan pay off (balance) over a term. HELP!!
  13. M

    Decreasing loan principle over a term

    I am having trouble with the formula to reduce a loans principle pay off over a 7 year term. Can someone smarter than me please help!!
  14. G

    **GENIUS NEEDED!!** Amortization sheet help

    Hi All, I need a lot of help. I've looked all over the Internet for a template for what I am looking for, but I can't find anything. I've been close but not really. Let me explain. I am looking for an amortization formula sheet for a boat loan that I have. That is easy enough, and I found...
  15. A

    Amortization schedule problem

    I was wondering if someone can help me. I've just started at a new bank and they have an unusual way to pay mortgages, which is completely different to the usual way that each payment is split into principal and interest. The total mortgage payment goes to the principal and the interest is...

Some videos you may like

This Week's Hot Topics

Top