YEARLY Payment Formula??

[Sherbear1223]

I need to know how to do a formula for when you are calculating the yearly
payment of a loan. Im taking a computer science class and the book we use, as
well as the simulator program we have to use for tests and assignments is
horrible. The book and the practice ex. show how to calculate monthly pays
but I cant figure out how to change the formula to multiply that answer times
12. There is even a cell showing the monthly pay and I tried =PMT(B18*12) but
that didnt work either. What am I supposed to do

 

[Tom [Pepper] Willett]

This is not a FrontPage related question.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I need to know how to do a formula for when you are calculating the yearly
: payment of a loan. Im taking a computer science class and the book we use,
as
: well as the simulator program we have to use for tests and assignments is
: horrible. The book and the practice ex. show how to calculate monthly pays
: but I cant figure out how to change the formula to multiply that answer
times
: 12. There is even a cell showing the monthly pay and I tried =PMT(B18*12)
but
: that didnt work either. What am I supposed to do