Excel Basics for Finance - Boston College

The Excel function that allows us to solve for this interest rate is: =RATE(nper,pmt,pv,fv,type,guess*) *For this example, we will not use type or guess. Solving the Excel function, we find that your deposit must earn an interest rate of 10.138% for it to be worth $4,000 in five years, as shown in Figure 10.5 =RATE(5,0,-2468.11,4000) = 10.138% ................
................