XL calculation formula
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.
--
Socrates said: I only know, I don''''t know nothing.
I say : I don''''t even know, I don''''t
know nothing.
|