Formula to calculate loan payment in Excel?
How can I calculate monthly loan payment in Microsoft Excel?
I want to create a spreadsheet so I can just enter the values and it automatically calculates the monthly loan payment. Is there any formula to do this? or do I need to create a macro?
I have the following fields:
Term (months or years)