Not sure if this would be able to be solved using solver, having trouble, help greatlyy appreciated
97.5=100e^(-x(1/4))
How would I solve for this using excel. Answer= 0.10127
97.5=100e^(-x(1/4))
(divided by 100 both sides, mult by -4)
-4* ln(97.5/100)=-x(1/4) *-4
This is for determing continuously compounded zero rates
Bond price= Bond principle (e)^r(t)
Bookmarks