Please some give me the formular

48,400
8 %
30 years
=SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I need
the correct formula to get the monthly payment? I have a computer class

THIS IS URGENT!!!!!!!!!!!!!!!!!!

"Help I need the answer asap!!!" <Help I need the answer
wrote:
THIS IS URGENT!!!!!!!!!!!!!!!!!!

You are more likely to get the answer you need quickly if you take the time
to form your question clearly and without typos.


48,400
8 %
30 years
=SUM(48,800*8/12) ???
The payment is 358.08

Who says? And what does =48400*8%/12 (which I presume you meant) have to do
with it?


but how can figure it I need
the correct formula to get the monthly payment?

If you are trying to describe a typical amortizing loan of 48400 at 8% with
monthly payments over 30 years, typically the formula would be:

=PMT(8%/12, 30*12, -48400)

which should be rounded or truncated according to the lender's policy, your
class assignment or the coin of the realm (e.g. cents in the US).

But I get 355.14, not 358.08.

Note: That formula is applicable to the US and much of the world. But
Canada and, I've read, the UK compute the payment differently because of the
different way in which they treat the annual interest rate.

However, I don't think that explains the discrepancy my result above. For a
Canada loan with that structure, I get a payment of 349.96. And for a UK
loan with that structure, I get 345.77, based on the formula at
http://support.microsoft.com/kb/294396/en-us .


----- original message -----

"Help I need the answer asap!!!" <Help I need the answer
wrote in message
...
Please some give me the formular

48,400
8 %
30 years
=SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I need
the correct formula to get the monthly payment? I have a computer class

THIS IS URGENT!!!!!!!!!!!!!!!!!!

Errata....

I wrote:
wrote:
48,400
8 %
30 years
=SUM(48,800*8/12) ???
The payment is 358.08

Who says? And what does =48400*8%/12
(which I presume you meant) have to do with it?
[....]
But I get 355.14, not 358.08.

Aha! I didn't pick the right typo to work with ;-).

"48,400" should be 48,800.

=PMT(8%/12, 30*12, -48800)

is indeed 358.08.


----- original message -----

"JoeU2004" wrote in message
...
"Help I need the answer asap!!!" <Help I need the answer
wrote:
THIS IS URGENT!!!!!!!!!!!!!!!!!!

You are more likely to get the answer you need quickly if you take the
time to form your question clearly and without typos.


48,400
8 %
30 years
=SUM(48,800*8/12) ???
The payment is 358.08

Who says? And what does =48400*8%/12 (which I presume you meant) have to
do with it?


but how can figure it I need
the correct formula to get the monthly payment?

If you are trying to describe a typical amortizing loan of 48400 at 8%
with monthly payments over 30 years, typically the formula would be:

=PMT(8%/12, 30*12, -48400)

which should be rounded or truncated according to the lender's policy,
your class assignment or the coin of the realm (e.g. cents in the US).

But I get 355.14, not 358.08.

Note: That formula is applicable to the US and much of the world. But
Canada and, I've read, the UK compute the payment differently because of
the different way in which they treat the annual interest rate.

However, I don't think that explains the discrepancy my result above. For
a Canada loan with that structure, I get a payment of 349.96. And for a
UK loan with that structure, I get 345.77, based on the formula at
http://support.microsoft.com/kb/294396/en-us .


----- original message -----

"Help I need the answer asap!!!" <Help I need the answer
wrote in message
...
Please some give me the formular

48,400
8 %
30 years
=SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I
need
the correct formula to get the monthly payment? I have a computer class

THIS IS URGENT!!!!!!!!!!!!!!!!!!

I have just put a file up for you at:-

www.pierrefondes.com

It is the first file at the top of the home page.

Look at PMT Worksheet.

All you have to plug in is:-

48,400 cell E8

8% cell E4

360 (months) cell E6

Result will be found in C11 (355.14).

You can change the inputs at will and the output will change accordingly.

Please hit Yes if my comments have been helpful to you.

Thanks!




"Help I need the answer asap!!!" wrote:

Please some give me the formular

48,400
8 %
30 years
=SUM(48,800*8/12) ??? The payment is 358.08 but how can figure it I need
the correct formula to get the monthly payment? I have a computer class

THIS IS URGENT!!!!!!!!!!!!!!!!!!