• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hi, what's the formula to find up-to-current month"Outstanding Balances"

Y

Yvonneyeong

New Member
Hi, what's the formula to find up-to-current month"Outstanding Balances" if:

Total Payable sum = $168,600.00
Monthly Installment = $5,620.00
Interest Rate = 4.31% p.a.
Tenure = 30 months
Contract from 16/06/2018 ~ 16/11/2020
 

Attachments

  • HP Listing test.xlsx
    41.9 KB · Views: 4
You must log in or register to reply here.
Back
Top