Notes Receivable Rollforward WPNE

This workbook walks the notes receivable balance forward from the prior year and provides analytical measures.

Entering Data

Although not required, this workbook allows for documenting the original term of the note, the due date, and the stated interest rate. This information may be hidden or displayed by selecting the respective "Hide/Show note terms" button near the top of the Loan Inputs worksheet.
Also, this workbook includes automatic rollforward, clear workbook, and hide/show empty rows functionality. This functionality is simultaneously applied to both worksheets. The Note Inputs worksheet also utilizes conditional formatting and data validation to assist the user with proper data input. All of this functionality is also described in the “General Workpaper Functionality and Tips for Entering Data” section.
No data entry is required on the Analyticals worksheet. However, data entry is required for the Collectibility worksheet in order for the Note Status Summary to calculate.