loan schedule

  1. 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?
  2. G

    Savings made by making a fix extra payment every moth to a loan

    I have the fallowing loan: Principal: $72 222.22 Rate: 10.5% Year: 15 Payments are made monthly. The first payment will be made on January 2016 For 15 cells that correspond to each year of the loan; I need the formula that will determine how much interest will be save if a $10 fix...
    • Guilder
    • Thread
    • extra payments loan analysis loan payoff loan schedule loans
    • Replies: 3
    • Forum: Excel Questions
  3. L

    Is that possible I can have a fomular in one cell that shows principal paid up to date?

    Can someone help me with this one? Thanks!
  4. F

    Loan Payment Amounts

    I am trying to calculate the payments on a loan, where the interest is calculated daily and the first payment period is not equal with the remaining periods. For example on a short term loan of 4 weeks, with weekly payments but the period form the start of the loan until the first payment is...
  5. V

    Excel Solution for MIC/Investment Manager

    We have looked at several mortgage software solutions for our company, but none have one essential ability that we need. We are currently running on a manual spreadsheet solution, and are wondering if we can automate certain aspects of it. We are a financier that lends out money to commercial...

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