| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function for fixed amounts spread over 12 payments
I need a functions that will change the remaining payments when the original
amount is either increased or decreased. We have contracts that are paid in 12 equal payments each month, but when the amount is either increased or decreased, I need the remaining payments to reflect the change. Does any one know a formula that will work for this? Thanks. -- Marilyn |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for fixed amounts spread over 12 payments
=(New Contract amount - payments-to-date)/number-of-payments-remaining
As you didn't give any info on how your data is organised, I can only generalise as above. You may need to adjust payments (last one?) if the outstanding balance does not divide exactly by the number of payments remaining. "mloveridge" wrote: I need a functions that will change the remaining payments when the original amount is either increased or decreased. We have contracts that are paid in 12 equal payments each month, but when the amount is either increased or decreased, I need the remaining payments to reflect the change. Does any one know a formula that will work for this? Thanks. -- Marilyn |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for fixed amounts spread over 12 payments
Sorry, I did not give you enough information. This information will look
like this. Original Contract 120,000 Increase/Decrease 9,000 Amended Contract 129,000 July Payment 10,000 Aug Payment 10,000 Sep Payment 10,000 Oct Payment 10,000 Nov Payment Dec Paymnet Jan Payment Feb Payment Mar Payment Apr Payment May Payment Jun Payment Total Payment 40,000 Balance of Contract 89,000 Remaining Payment Amount 11,120 What I would like is the remaining payment amount to always show the next payment amount. -- Marilyn "Toppers" wrote: =(New Contract amount - payments-to-date)/number-of-payments-remaining As you didn't give any info on how your data is organised, I can only generalise as above. You may need to adjust payments (last one?) if the outstanding balance does not divide exactly by the number of payments remaining. "mloveridge" wrote: I need a functions that will change the remaining payments when the original amount is either increased or decreased. We have contracts that are paid in 12 equal payments each month, but when the amount is either increased or decreased, I need the remaining payments to reflect the change. Does any one know a formula that will work for this? Thanks. -- Marilyn |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Function for fixed amounts spread over 12 payments
OK. Given this additional information, what's wrong with Topper's formula? Why
won't it work for you? -- Regards, Fred "mloveridge" wrote in message ... Sorry, I did not give you enough information. This information will look like this. Original Contract 120,000 Increase/Decrease 9,000 Amended Contract 129,000 July Payment 10,000 Aug Payment 10,000 Sep Payment 10,000 Oct Payment 10,000 Nov Payment Dec Paymnet Jan Payment Feb Payment Mar Payment Apr Payment May Payment Jun Payment Total Payment 40,000 Balance of Contract 89,000 Remaining Payment Amount 11,120 What I would like is the remaining payment amount to always show the next payment amount. -- Marilyn "Toppers" wrote: =(New Contract amount - payments-to-date)/number-of-payments-remaining As you didn't give any info on how your data is organised, I can only generalise as above. You may need to adjust payments (last one?) if the outstanding balance does not divide exactly by the number of payments remaining. "mloveridge" wrote: I need a functions that will change the remaining payments when the original amount is either increased or decreased. We have contracts that are paid in 12 equal payments each month, but when the amount is either increased or decreased, I need the remaining payments to reflect the change. Does any one know a formula that will work for this? Thanks. -- Marilyn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 11 $ amounts, 6 of the amounts must equal $3854.12, which 6? | Excel Discussion (Misc queries) | |||
| biweekly payments on a loan using Pmt function | Excel Discussion (Misc queries) | |||
| Trying to total payments for months, need help with my function | Excel Worksheet Functions | |||
| how do I include advance payments in the PMT function | Excel Worksheet Functions | |||
| How do I forecast future payments by analyzing past payments? | Excel Worksheet Functions | |||
Hybrid Mode
