Formulas > =PRICE()
How to Use PRICE() in Google Sheets
Description
How To Actually Use PRICE() in Sheets
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Try PRICE yourself
Use the PRICE() function to calculate the price of a bond in cell D1. The settlement date is in A1, maturity date in B1, annual coupon rate in C1, yield in E1, redemption value in F1, and frequency in G1.
Hints (3)
-
Make sure to input the correct cell references for each argument.
-
Remember that frequency can be 1, 2, or 4 depending on the bond.
-
Check that your dates in A1 and B1 are formatted correctly.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the PRICE() formula:
Generate a PRICE() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses PRICE(). 2 free AI generations, no signup. Members get unlimited use.
Generate a PRICE() formula