Question

which. function used to calculate Loan amount? ​

Answer 1

ɴᴩᴇʀ ꜰᴜɴᴄᴛɪᴏɴ ɪꜱ ᴜꜱᴇᴅ ᴛᴏ ᴄᴀʟᴄᴜʟᴀᴛᴇ ʟᴏᴀɴ ᴀᴍᴏᴜɴᴛ .

ᴛʜᴇ ᴇxᴄᴇʟ ᴩᴍᴛ ꜰᴜɴᴄᴛɪᴏɴ ɪꜱ ᴀ ꜰɪɴᴀɴᴄɪᴀʟ ꜰᴜɴᴄᴛɪᴏɴ ᴛʜᴀᴛ ʀᴇᴛᴜʀɴꜱ ᴛʜᴇ ᴩᴇʀɪᴏᴅɪᴄ ᴩᴀyᴍᴇɴᴛ ꜰᴏʀ ᴀ ʟᴏᴀɴ. yᴏᴜ ᴄᴀɴ ᴜꜱᴇ ᴛʜᴇ ɴᴩᴇʀ ꜰᴜɴᴄᴛɪᴏɴ ᴛᴏ ꜰɪɢᴜʀᴇ ᴏᴜᴛ ᴩᴀyᴍᴇɴᴛꜱ ꜰᴏʀ ᴀ ʟᴏᴀɴ, ɢɪᴠᴇɴ ᴛʜᴇ ʟᴏᴀɴ ᴀᴍᴏᴜɴᴛ, ɴᴜᴍʙᴇʀ ᴏꜰ ᴩᴇʀɪᴏᴅꜱ, ᴀɴᴅ ɪɴᴛᴇʀᴇꜱᴛ ʀᴀᴛᴇ.

Answer 2

Answer:

PMT function.

PMT function. PMT is one of the financial functions which calculates the payment for a loan based on constant payments and a constant interest rate.