L
Learning Excel
I've been looking, without luck, for formulas in Excel to calculate
interest, let's say for buying a house, car...
Basically it could be a FORMULA, TEMPLATE or WEBSITE (on how to set it)
and something simple for starters like me.
Lets say I give this information :
price of house ( $ )
interest ( 5% fixed)
amount of years of ref. ( ej. 30)
Then the expected outcome in other cell will be The monthly payments coming
from equal division of those 30 years after applying the 5% to the loan.
Calculation will vary depending on the amount, years and percent rate for
each case.
If someone have formulas just throw it in, I can manage to work it out with
the
cells.
A downloadable template or website also will be appreciate it.
THANKS in advance.
interest, let's say for buying a house, car...
Basically it could be a FORMULA, TEMPLATE or WEBSITE (on how to set it)
and something simple for starters like me.
Lets say I give this information :
price of house ( $ )
interest ( 5% fixed)
amount of years of ref. ( ej. 30)
Then the expected outcome in other cell will be The monthly payments coming
from equal division of those 30 years after applying the 5% to the loan.
Calculation will vary depending on the amount, years and percent rate for
each case.
If someone have formulas just throw it in, I can manage to work it out with
the
cells.
A downloadable template or website also will be appreciate it.
THANKS in advance.