Need a help related to Financial Functions in excel

[syamspecial]

Which formula can be used to solve my following query in excel

After 10 years I need a amount of 2500000, for this I'm saving a particular amount on each month and that amount I'm getting a annual interest of 8%. Then what is the exact amount should I save each month.  

Thanks in advance.. 

[#2 · Accepted solution]

@syamspecial 

See screenshot. The formula in B5 is =PMT(B3/12,B4*12,B1,B2)

The result is negative because amounts that you receive are positive, amounts that you pay are negative.

 

[#3]

Thank You @Hans Vogelaar

[#4]

what do they mean apply the Slice Theme to the workbook

[#5]

Sorry.. I didn't get you ..

[#6]

@RMendez8412 

Your question has nothing to do with the subject of this thread. Please start a new topic for it.

---

@RMendez8412 wrote:
what do they mean apply the Slice Theme to the workbook

---