View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Learning Excel Learning Excel is offline
external usenet poster
 
Posts: 98
Default 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.