amortization schedule

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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!!

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

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