I would like to figure out the total payout figure for a loan.
I have the initial amount in column b
Date of loan in column c
Interest rate in column d
I need the total amount of the loan today with compounding interest without having made any payments.
For instance:
$10k loan from 6th July 2013
No payments made
10% interest - compounding.
What do I owe today?
I would also like to be able to change whether the interest was calculated daily, weekly, monthly etc
Thank you!
I have the initial amount in column b
Date of loan in column c
Interest rate in column d
I need the total amount of the loan today with compounding interest without having made any payments.
For instance:
$10k loan from 6th July 2013
No payments made
10% interest - compounding.
What do I owe today?
I would also like to be able to change whether the interest was calculated daily, weekly, monthly etc
Thank you!
Last edited: