amortization

  1. C

    Prepaid expenses amortization [automated]

    Good morning all! I need your help/ assistance. I am working on automated prepaid expenses allocation among of all month the service run through. To be specific, it is related to software products we manually expense at the end of the month. Ideally services run from the beginning of the...
  2. B

    VBA IRR on Amortization Tabl

    I'm looking for a way to use VBA to calculate the IRR of the cashflows of an amortization table without actually needing an amortization table in my workbook, but rather just the loan attributes. I currently use the following function to calculate the cumulative interest paid given the...
  3. A

    Select from Drop down list in Internet Page

    ı am new vba and here. I am working on stocks and ı need your helps. so firstly as you can see on tittle, ı want to choose automaticly in down list what i write on my excel. So ı need amortization information from this web site website in "MALİ TABLOLAR"page amortization in turkish is amortisman...
  4. 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...
  5. D

    How to account for irregular mortgage payments regarding date paid?

    The function PMT is very helpful in creating an amortization table. The problem with PMT is that it assumes that payments are made at the same time every month. I am trying to create an amortization table that accounts for early or late payments and adjusts the interest amount accordingly...
  6. N

    Need Formula for Monthly Calculation

    Dear Friends I need a formula to amortize my expenses in below sheet. I want in Column L monthly amortization on the basis, if full month is used then it should calculate for 30 days, if not full month then calculate based on day used in that month. Days in year base should be 30 days. Kindly...
  7. N

    Calculating Interest Rate and Expense Calculation: Amortization Schedule

    My company has a loan taken out on 8/25/17 for $122,100.00 with a purchase amount of $170,940 (this is the total payment amount). The payments of $1,187.09 start on 8/28/17 and are Monday through Friday, except for holidays. The number of payments is 144 (with the last payment being $1,186.13. I...
  8. J

    date formula

    I need to calculate the whole number of months between below dates and current date - with one formula for all. Current date = 1/15/2018 So in column B, I'd like to see how many months are between Dates in Column A and the Current Date above. B2 should be 2, B3 should be 2, B4 should be 1, B5...
  9. T

    Help with Lease Amortization Schedule

    I am trying to amortize a lease liability schedule to zero using an assumed rate of 5%. I realize the implicit rate is different but I've discounted the cash flows at 5% and would like the amortization to zero out starting with the current lease liability derived using XNPV. I get close to...
  10. K

    Direct Financing Lease Interest Calculation

    Hello, I'm using a calculation example from accounting guidance related to direct financing leases. There is a monthly rent payment that is fixed for 9 years (10,000 per year) and an initial net investment amount of $65,100. At the end of the 9 years, the lease will have a residual value of...
  11. L

    Loan Amortization Table with Extra Loan Payment Calculation

    I designed a amortization table (see link below). The top portion provides a summary of the loan, where the green color cells are hard coded input cells (except cell B8, because I do not know how to calculate the last year of a loan when a fixed extra amount is paid monthly). Once the input...
  12. M

    Amortization Table with Refinancing

    I was looking to see if excel had a template of an amortization schedule which included refinancing every 10 years at a new interest rate. I haven't found anything. Anyone know of a free template anywhere that could do this?
  13. A

    Self Amortizing Loan with Varying Interest and Cash Flow

    Hi, First time poster. I'm trying to back into the principal amount of a self amortizing loan with varying interest and cash flow. The interest rate will be 5% for the first year and 2% for years 2 - 6. There is no payment in year 1 and let's use $100 for payments in years 2 - 6. Any...
  14. A

    How to pull data based on today's date from a monthly payment schedule in excel?

    I am new to this forum so hopefully I am going about this the right way. In excel I have a payment schedule for a loan with several vertical columns. The far left column is a list of payment dates that are arranged one month apart, ex: 03/01/2016, 04/01/2016, 05/01/2016, and so on down the...
  15. M

    Amortizing prepaid insurance monthly - also prorates first and last month!

    I am trying to create a formula that will automatically amortize prepaid insurance out every month based on an effective date and termination date. The problem I'm encountering is getting the formula to auto-calculate the # of days in each month, and to prorate the 1st and last month of the...
  16. N

    Amortization Template - How to Stop at Zero

    I've created an amortization table for a loan, that feeds into some pro forma financial statements. I made it to allow me to change the number of payments, but as it stands now, if the number of payments is less than the number of rows in the amortization schedule, it keeps calculating past...
  17. A

    calculate interest on a biweekly arm that was converted to a fixed rate

    Does anyone know how to calculate interest on a biweekly arm that was converted to a fixed rate? HELP!!!!
  18. 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...
  19. F

    Advanced VBA: Amortization Table Project

    Hello, I was doing some work the other day and it involved building a lengthy amortization table with variables rates and I thought to myself man this would be so much easier if there was a formula or some sort of module that could do this work for me. So I went scouring the internet trying to...

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.
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 "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
Back
Top