Tag Archives: spreadsheet

loan amortization spreadsheet

Credit is the one thing in the United States that a person can’t live comfortably without. More and more lenders, landlords, as well as anything that you would purchase on credit are tallying those credit scores. It is harder to obtain a loan as well however recently some options have emerged that are helping those … Continue reading

Where I can I find an advanced loan amortization calculator?

I need a loan amortization calculator or spreadsheet that will allow me to input graduated payments (ex. 12 months @ followed by 36 months @ 0 etc). I’m trying to chart and graph a payment schedule for my student loans. The online calculators I’ve found only let you input one set of payments. Related Blogs … Continue reading

How does mortgage prepayment affect future amortization? I'd like a spreadsheet?

I’m about halfway through a 15-year, fixed-rate mortgage. I have an amortization schedule from when the loan was originated. I would like to see how irregular prepayments to principal affect the amortization going forward. About 0 of my monthly payment goes to interest right now, and declines slightly by month. If I pay down the … Continue reading