Financial Formula - Annuity Professional-1

Đã Hủy Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã Hủy Thanh toán khi bàn giao

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…

Kế toán Excel Tài chính Phân tích tài chính Nghiên cứu tài chính

ID dự án: #16316535

Về dự án

6 đề xuất Dự án từ xa 6 năm trước đang mở

6 freelancer chào giá trung bình$21 cho công việc này

prasannjeetp

My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently.

$15 USD trong 1 ngày
(4 Nhận xét)
0.0
PhDWriter12

Hello Sir/Ma’am, I am Ph.D writer having 5+ years of experience in Academic writing,Content writing,Powerpoint,Article writing,Report writing,Research writing,Technical writing,Business plans etc Thank you!

$25 USD trong 1 ngày
(4 Nhận xét)
0.0
Bharat247

I am very interested in your project and also ready to start work immediately. Please give me opportunity to work for you. Thank you!!!!

$10 USD trong 2 ngày
(4 Nhận xét)
0.0
MMalabaguio

Hi! Just let me know what exactly you need, is it a loan monitoring form? some kind of ledger? I did similar forms/formula in excel for my project in a microfinance NGO before. You can try my excel service.

$30 USD trong 1 ngày
(0 Nhận xét)
0.0