Type the Excel formula for the nominal annual rate, compounded semi-annually, that turns 2,500 into 4,000 in 10 years.

Answer

=RATE(10*2,0,-2500,4000)*2

RATE returns the half-year rate 0.023778; × 2 annualises it to the nominal 0.047557. Without the × 2 you would report a semi-annual rate as an annual one.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.4 (eyeballing) — shape only; Excel five-function family authored fresh; original scenarios