Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAYMENT CALCULATIONS
Hi Mark!
Please don't shout. Using all upper case is considered shouting and is more difficult to read especially for those whose first language isn't the language used. Try: =PMT(8%/12,12,10000*((1+(1+8%/12)^(12/365)-1)^45),0,1) Returns: 872.66 I've assumed an APR compounded monthly with the repayment break being charged interest at the daily effective equivalent of that rate. The amount of loan 10000 gets accumulated for 45 days and thereafter there are 12 payments due with the first being made at the beginning of the first month. -- Regards Norman Harker MVP (Excel) Sydney, Australia Holidays and Observances Monday 21st July: Belgium (National Day), Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam (Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru (Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher Day). Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "MARK AKKERMAN" wrote in message ... HOW WOULD YOU CALCULATE A PAYMENT WITH THE PAYMENTS STARTING ON AN ODD DAY, IE: 45 DAYS TO FIRST PAYMENT? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAYMENT CALCULATIONS
Hello Sir,
Sorry for the yelling, it was only a caps lock I assure you. Thank you for giving me the answer I have been looking for. I have only one problem, when I calculate it on my excel program, it comes out the same as yours to the penny, but in a negative number. Thanks again, Mark. -----Original Message----- Hi Mark! Please don't shout. Using all upper case is considered shouting and is more difficult to read especially for those whose first language isn't the language used. Try: =PMT(8%/12,12,10000*((1+(1+8%/12)^(12/365)-1)^45),0,1) Returns: 872.66 I've assumed an APR compounded monthly with the repayment break being charged interest at the daily effective equivalent of that rate. The amount of loan 10000 gets accumulated for 45 days and thereafter there are 12 payments due with the first being made at the beginning of the first month. -- Regards Norman Harker MVP (Excel) Sydney, Australia Holidays and Observances Monday 21st July: Belgium (National Day), Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam (Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru (Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher Day). Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "MARK AKKERMAN" wrote in message ... HOW WOULD YOU CALCULATE A PAYMENT WITH THE PAYMENTS STARTING ON AN ODD DAY, IE: 45 DAYS TO FIRST PAYMENT? . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAYMENT CALCULATIONS
I am certainly no expert so I am not sure if this would
meet your needs, but what if you just put ABS(PMT (8%/12,12,10000*((1+(1+8%/12)^(12/365)-1)^45),0,1)) The ABS being a formula to return absolute value... -----Original Message----- Hello Sir, Sorry for the yelling, it was only a caps lock I assure you. Thank you for giving me the answer I have been looking for. I have only one problem, when I calculate it on my excel program, it comes out the same as yours to the penny, but in a negative number. Thanks again, Mark. -----Original Message----- Hi Mark! Please don't shout. Using all upper case is considered shouting and is more difficult to read especially for those whose first language isn't the language used. Try: =PMT(8%/12,12,10000*((1+(1+8%/12)^(12/365)-1)^45),0,1) Returns: 872.66 I've assumed an APR compounded monthly with the repayment break being charged interest at the daily effective equivalent of that rate. The amount of loan 10000 gets accumulated for 45 days and thereafter there are 12 payments due with the first being made at the beginning of the first month. -- Regards Norman Harker MVP (Excel) Sydney, Australia Holidays and Observances Monday 21st July: Belgium (National Day), Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam (Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru (Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher Day). Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "MARK AKKERMAN" wrote in message ... HOW WOULD YOU CALCULATE A PAYMENT WITH THE PAYMENTS STARTING ON AN ODD DAY, IE: 45 DAYS TO FIRST PAYMENT? . . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAYMENT CALCULATIONS
Try this addendum to Mr. Harker's correct answer, Mark:
Enter the amount as a negative figure and see how it works. -- Greeting from the Gulf Coast! http://myweb.cableone.net/twodays "MARK AKKERMAN" wrote in message ... Hello Sir, Sorry for the yelling, it was only a caps lock I assure you. Thank you for giving me the answer I have been looking for. I have only one problem, when I calculate it on my excel program, it comes out the same as yours to the penny, but in a negative number. Thanks again, Mark. -----Original Message----- Hi Mark! Please don't shout. Using all upper case is considered shouting and is more difficult to read especially for those whose first language isn't the language used. Try: =PMT(8%/12,12,10000*((1+(1+8%/12)^(12/365)-1)^45),0,1) Returns: 872.66 I've assumed an APR compounded monthly with the repayment break being charged interest at the daily effective equivalent of that rate. The amount of loan 10000 gets accumulated for 45 days and thereafter there are 12 payments due with the first being made at the beginning of the first month. -- Regards Norman Harker MVP (Excel) Sydney, Australia Holidays and Observances Monday 21st July: Belgium (National Day), Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam (Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru (Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher Day). Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "MARK AKKERMAN" wrote in message ... HOW WOULD YOU CALCULATE A PAYMENT WITH THE PAYMENTS STARTING ON AN ODD DAY, IE: 45 DAYS TO FIRST PAYMENT? . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
PAYMENT CALCULATIONS
Hi Mark,
Put a minus sign like so =-PMT That will make it positive 2rrs "MARK AKKERMAN" wrote in message ... Hello Sir, Sorry for the yelling, it was only a caps lock I assure you. Thank you for giving me the answer I have been looking for. I have only one problem, when I calculate it on my excel program, it comes out the same as yours to the penny, but in a negative number. Thanks again, Mark. -----Original Message----- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
360-day Year Based Payment & Amortization Calculations? | Excel Worksheet Functions | |||
Interest and Payment Calculations | Excel Worksheet Functions | |||
Starting payment when increase rate is known & total payment is kn | Excel Worksheet Functions | |||
Car loan payment calculations | Excel Discussion (Misc queries) | |||
Why are cumulative interest payment calculations different? | Excel Worksheet Functions |