Step Instruction Value Point 5 Type Periodic Rate: in cell A15. 5 6 Calculate the periodic rate of the loan in cell B15. 5 7 Generate the loan payment in cell B16. 10 Determine Rate You will create a working list of all existing accounts that provides the number of days remaining on their loan and an overall look at all accounts maturity dates. 8 Display the Existing Accounts worksheet and calculate the number of days remaining for each existing account. 15 9 Calculate the maximum number of Days Remaining for all existing accounts in cell C17. 10