This is not my formula. It's your formula on the webpage of function RECEIVED and is incorrect formula.
Correct formula is as follows: RECEIVED = PurchaseValue*(1/( 1 - (DiscountRate*days_difference/days_in_year))). On Tue, May 2, 2023, 1:07 AM Andrew Pitonyak <and...@pitonyak.org> wrote: > > I think that your formula is missing the "discount" or percentage. I have > seen the formula published on the Microsoft help pages and it too does not > show any derivation. > > > On Monday, May 01, 2023 12:24 EDT, Vijay Vardhan <vjyvard...@gmail.com> > wrote: > The formula of function RECEIVED for calculating received value on > maturity > is incorrect on the webpage of function RECEIVED. > > RECEIVED = purchasevalue / ( 1 - days_difference/days_in_year). This is an > incorrect formula. There is no formula on the webpage of 'Derivation Of > Financial Formulas' either for this function. > > >
