Two Year Average
This workbook includes the automatic calculation of 2 year (24 month) averaging. The workbook compares the Current Year (CY) income to Prior Year (PY) and computes more conservative value based on the trend i.e. if CY is lower than PY, then it will choose CY and if CY is greater than PY, then it will use the 24 month average as a ‘default’ value. However, the default value can be overridden using the drop down. See below:
LoanBeam’s Repeatable Group approach means that no matter how many entities are in the tax returns files, LoanBeam will dynamically create as many repeatable groups as required to present all of the entities. Whether there are two Schedule C entities or nine, the one worksheet will present them all. The totals from individual entities appear at the top, which flow back to the “Main Sheet”.
In the Main worksheet, Schedule C income will be included in corresponding Current and Prior Year columns and QI (Qualifying Income) columns as applicable.
Exclude from Calculation
Manual override columns are provided on all sheets. These may be used to amend or remove numbers. The figures entered in the Manual Override column will show up in the column for Annual Figures adjusting the Monthly Figures (wherever applicable) accordingly.
There are three ways to use the Manual Override:
1. Input a specified dollar amount
2. Input $ 0 to force a zero dollar amount
3. Delete an override to return to the original amount
Never change the data in the CY and PY columns. When a user changes a number in the current year or prior year columns, the formulas in those cells will be corrupted, creating a potential disconnect with the rest of the calculation.
Red Formatted Cells
Overriding a cell calculated by LoanBeam results in Red Formatted cells. This creates a potential disconnect with the rest of the calculation and the relating cells are also formatted in red.
Please use the Manual Override feature to change amount in cells.
Source Document Referencing
Each cell populated from a tax return provides details about the source, indicated by a red triangle in the cell’s upper right corner. Hovering over the cell shows the dollar amount and exact location of the data that was pulled from the tax return.
Profit and Loss Statement
The P&L feature for each multi-instance work paper allows you to enter the monthly amounts from the profit and loss statements manually. If you opt to enter the profit and loss amounts manually, then the amounts that flow from the borrower’s tax returns are not considered in the QI calculations.
The monthly qualifying income calculations are done on the basis of these manually input amounts from the profit and loss statements.
If the amounts that flow from the borrower’s tax returns are to be considered do the following:
- Select “No” from the “Profit-And-Loss Statement Available” drop down.
- The manually input fields are grayed.
- The monthly income calculations are done on the basis of the amounts populated from the tax returns.
Year-to-Year Percentage Change Alert
Recurring and Non-recurring
There are Recurring/Non-recurring indicators that are set by default. The user can change the setting by clicking on the cell and changing the selection from the drop down. Typically, Recurring numbers are included in the cash flow. Non-recurring numbers are excluded and grayed out.