Mar 26 2021 06:31 AM
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..
Mar 26 2021 06:44 AM
SolutionSee 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.
Mar 27 2021 09:44 PM
Mar 27 2021 10:01 PM
Mar 27 2021 10:38 PM
Mar 28 2021 01:02 AM
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
Mar 26 2021 06:44 AM
SolutionSee 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.