Function Type: Financial
Description:
Returns the interest rate for a fully invested security.
Function Structure:
=INTRATE(settlement, maturity, investment, redemption, [basis]).
Argument Breakdown:
settlement – Settlement date of the security.
maturity – Maturity date of the security.
investment – The amount originally invested.
redemption – The amount received at maturity.
basis – Day count basis.
Example:

If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.