SELECT val month, ROUND(pr,3) principal, ROUND(fval,3) "GROWTH_5%_APR" FROM DUAL MODEL RETURN ALL ROWS DIMENSION BY ( 0 d ) MEASURES (0 fval, 0 val, 0 pr) RULES ITERATE (12) (fval[iteration_number] = DECODE(iteration_number, 0,1000+1000*0.05/12, fval[iteration_number-1]+fval[iteration_number-1]*0.05/12), pr[iteration_number] = DECODE(iteration_number, 0,1000, pr[iteration_number-1]+pr[iteration_number-1]*0.05/12), val[iteration_number] = iteration_number+1) ;
74068