Nope. You gotta do it the long, painful way.
Lo siento, mijo. 
1 Like
Prediction? Pain.
I wouldn’t even bother using the TVM functions. Just hack at it using first principles:
1- year spot is 5% (no math required)
2- year spot
100 = 6/1.05 + 106/(1 + 2 yr spot)^2
algebra happens here
2 yr spot = 6.03%
3- year spot
100 = 7/1.05 + 7/(1.0603^2)+ 107/(1 + 3 yr spot)^3
some more algebra happens here
3 yr spot = 7.09%
1 Like
I like the plan.
On the BAII:
P/Y=C/Y=1
2ND CLR TVM
2 N FV 106 PV -94.28571 CPT I 6.03031
-94.228571 = 100 - 6/1.05
I think it’s more work than just doing it from first principles.
1 Like
From your examples, I was able to create a hybrid of first principles and BAII Plus calculation. Your work is excelente.
1 Like
And PMT = 0, correct?
Yup.
1 Like