Financial Formula - Annuity Professional

Looking for the financial formula for a multiple loan paydown with a beginning lump sump payment that cascades extra balances onto the next loan to be paid off until the group of loans are complete. Please read the project details before bid. I will check proposals not the ratings. Write few about your plan and tools that you use to complete the project.

ie - 300 loan @ 125/mth @ 0% onto 524 loan @ 10/mth @ 19.8% onto 1404 loan @ 17/mth @ 7.1% onto 3536 loan @ 200/mth @ 19.8% with an additional mthly payment to start out at 645/mth and cascading onto each of the following debts.

Described: The extra monthly payment in the example provided is 645 each month. The formula would then show the original loan of 300 with the monthly payment of 125. With the extra payment, 175 would complete that loan in month 1 and the extra would have to be applied the second loan of 523.95 and a monthly payment of 10 dollars at 19.8 percent interest. As such the payment in month one for the second loan would be the (645 - 175) = 470 + 10 the current payment for that loan totaling 480. This would leave a balance of 43.95 plus a small amount of interest for the beginning of month 2. Month 2 would have the extra payment of 645 + the payment from the original loan of 125 totaling 770 applied to the second loan balance of 43.95 less the 10 dollars already there for that monthly payment. That means there would then be (770 + 10) - 43.95 = 736.05 that would be applied to the third loan of 1404.48 at the beginning of the second month and so on…

Accounting Excel Finance Financial Analysis Financial Research

Project ID: #16312671

About the project