amortization schedule

  1. W

    Sum in a matrix

    Hi I am having trouble solving this problem. I have a matrix of an amortization schedule and need to sum the scheduled payments per period. Disbursements 1 2 3 4 5 6 1/31/2023 33,570,352 (4,997,900) (5,222,805) (5,457,832) (5,703,434) (5,960,089) (6,228,293) 2/28/2023 36,321,284...
  2. K

    Amortized revenue/expense based on start and stop dates

    Hello all, I am trying to create an amortization stream based on a daily rate. So for example start date may be 01/01/2022 and end date may be 12/31/2022. The contract amount is 12,000. That would derive a daily rate. Then I want a formula that places the monthly amount based on the daily...
  3. R

    how to create a lease amortization schedule in excel with option to buy

    Hi. My boss is asking me if I can create a lease amortization schedule in excel with option to buy out. Example - the cost is $350,000. He wants that broken down into 60 payments with interest. Lets say 3%. But he also wants to tell them he will take a certain amount from each payment to...
  4. G

    Solving for Rate with deferred payments

    How would I determine the interest rate on a loan with an initial deferral period? Example: PV: $105,905 N: 24 (maybe 27?) Pmt: Months 1-3 at $0, Months 4-27 $4,626 FV: $0 Using T-Value, I get a rate of 3.67%, but I can't mimic it in Excel.
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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!!
  17. 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!!
  18. 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...
  19. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back