Lender’s Online Tools and Training

Congratulations on your choice to use our Excel-based eWorksheets for Tax Return Analysis. If you plan to put it on your company network, be sure you have purchased sufficient copies for all users or call us now at 360 455 1569 to be invoiced for a license for all users.

• • Choose the AGI or Schedule Analysis Method. This worksheet is designed for lenders using either method. If your company uses only one method, I recommend you customize it before first use. (See the eCourse on 1040 AGI versus Schedule Analysis Method.)
• • This file is ‘read-only’ so that every time you prepare an analysis you are starting with the original file. If you customize it, you’ll save your ‘template’ as ‘read-only’ for the same reason. That way if you accidentally revise a formula or make a change, that change won’t carry forward to all your cashflow files in the future.
• • Once you have opened it ‘read-only’ you can ‘save as’ with your borrower’s name and the year.

Open the worksheet read-only, customize for your use, then ‘Save As’ with your own read-only name to preserve the integrity of the template. Items you can customize:

• • Add desired information to the Borrower Info tab.
• • Delete the 1040 Pg 1 worksheet that you will not be using (Unprotect workbook to do so and immediately Reprotect the Workbook when done.)
• • On the 1040 Pg 1 worksheet, use the lines at the bottom to add routine entries for your company. For example, some lenders subtract federal/state tax, family living expenses or personal debt on the cashflow worksheet.
• • Create formulas to enter years into subsequent worksheets once the years are entered on 1040PG1. (I did not because could not be sure which 1040PG1 you would keep.)
• • On the ‘Other’ worksheet consider listing guidelines, documentation requirements and other quick look-up items you want at your fingertips.
• • CAUTION: You may not delete the ‘Intro & License’ Tab from your template. That tab must be the opening tab for all users. (Thank you for honoring my license/copyright.)

Wherever you see a red triangle in the upper right corner of a cell, there is a comment box with extra help. Just position your cursor over the cell (mouse-over) and the box will pop up.

If you would like the comment box to stay open when you move the mouse away, right-click on the cell and select ‘Show Comment’. When you are done with the comment, right-click on the cell and select ‘Hide Comment’.

You may select any cell and add your own comment box as well.

On the second tab in the worksheet you’ll find:

• • Historical or recurring cashflow
• • Making changes to the worksheets
• • Customizing by lender
• • How to use comment boxes at bottom of each worksheet
• • Use of minus signs
• • Why to save often
• • Getting ready for printing
• • What to do if you goof