On 2023/05/02 16:22:10 Czesław Wolański wrote:
> It follows that the function
> RECEIVED(settlementdate; maturitydate; purchasevalue; discountrate; basis)
> should return the same value as the formula
> = purchasevalue * ( 1 - discountrate *
> YEARFRAC(settlementdate;maturitydate;basis) )
My
Hi,
On 2023/05/02 15:59:01 Vijay Vardhan wrote:
> Correct formula is as follows:
> RECEIVED = PurchaseValue*(1/( 1 -
> (DiscountRate*days_difference/days_in_year))).
You're right. For a zero coupon bond [1]:
received = purchasevalue + received * discountrate * ( days_to_maturity /
days_in_year
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 wrote:
>
> I think tha
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 wrote:
The formula of function RECEIVED for calculating received value
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'
