This intro problem practices NPER. NPER calculates the number of periods needed to repay a loan or reach a savings goal, assuming a fixed interest rate and equal periodic payments. Update the output cells to calculate the number of periods in each row. Rate is the interest rate per period. Payment is the fixed amount paid or received each period. Start Amt is the amount received or paid out now. End Amt is the amount available or owed at the end of the final period. Money received or available is positive. Money paid out or owed is negative. Timing is 0 for end-of-period payments or 1 for beginning-of-period payments.
See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
Need help with NPER details and syntax? Review the NPER function guide first.
This cell cannot be edited