Formula Required - Reverse of =PMT()

[sudeep]

Hi,

We use =PMT() to find out the value of EMI for given principal, period and rate of Interest.

Principal Months Interest EMI
100000 246 11% 1,025.30 (Formula used for EMI =PMT(C2/12,B2,-A2))


What formula can we use to find out Principal if period, rate of Interest and EMI is given.

I hope I have been able to frame my question clearly and look forward to help from you geniuses. Please feel free for any clarifications required.

Thanks,

Sudeep

 

[MickG]

Try :- PV function

 

[sudeep]

Thanks MickG. I knew I can always bank on this forum.

Works like a dream.