Select a blank cell for instance the Cell C2 type this formula B2-A2ABS A2 the Cell A2 indicates the original price B2 stands the sales price you can change. With these inputs the PRICE function returns 9756 which indicates the value of the bond is 9756 of the face value. NPV -1000000 sum_ t 1 60 frac 25000_ 60 1 00064 60 N P V 1000000t160.
Finally divide the gross price by the sales tax rate plus one.
111 which amended HEA Title I Part C. The second step is to calculate the net price per good unit. Net Price List Price Additional. The PRICE Formula in Excel has 7 segments.