Future value vs total amortized cost of a loan

VivekOct 07, 2018

My goal is to determine the total cost of a mortgage loan (principle + interest for 30 years) I assumed that the future value(FV) of a loan is the total amortized cost...

What is payment period, and why is it equal 100 in this mortgage table?

user67265Oct 07, 2018

Here’s the table: I think the payment period is a month, but I don’t understand why it’s 100. The image is taken from this Excel exercise:...

How to calculate someone's true net worth?

MuzeOct 07, 2018

Is there a way I can look up or calculate another person’s net worth through math? Is a person who is making credit card, car, house, etc payments owe more that...

What are some motivating ways to track performance of paying back a loan?

DaveOct 07, 2018

I have a mortgage right now and I am motivated to pay it off as fast as possible. I have thought of a few key performance indicators that I store in a spreadsheet and...