# amortization schedule

1. ### 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.
2. ### 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...
3. ### 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...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...
13. ### Decreasing loan principle over a term

I am having trouble with the formula to reduce a loan pay off (balance) over a term. HELP!!
14. ### 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!!
15. ### **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...
16. ### 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 MrExcel.com.

### Which adblocker are you using?

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

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
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