If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
What is the formula payment for $48,800 for 30 years at 8% Interes
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!!!!!!!!!!!!!!!!!! |
#2
|
|||
|
|||
What is the formula payment for $48,800 for 30 years at 8% Interes
"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!!!!!!!!!!!!!!!!!! |
#3
|
|||
|
|||
What is the formula payment for $48,800 for 30 years at 8% Interes
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!!!!!!!!!!!!!!!!!! |
#4
|
|||
|
|||
What is the formula payment for $48,800 for 30 years at 8% Interes
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!!!!!!!!!!!!!!!!!! |
Thread Tools | |
Display Modes | |
|
|