Solve for return needed for one more period to equal a required APY

Back on September 8, 2015 I had a post call Chained Returns  with an Excel spreadsheet. It was a calculator for chaining together periodic rates of return and calculating the annual yield (APY) and the periodic equivalent rate of return (APR). The data inputs (yellow cells) looked like this: After you entered the periods (fractions […]