Cash Flow Analysis Borrower Name:
The following self-employed income analysis worksheet and accompanying guidelines generally apply to individuals:
Who have 25% or greater Who are employed by Who are paid Who own rental
p
ro
p
ert
y
interest in a business family members commissions
Who receive variable income, have earnings reported on IRS Form 1099, or income that cannot otherwise be verified by an
independent and knowable source.
Form 1040 - Individual Income Tax Return Yr. Yr.
1. Total Income
2. Wages, salaries considered elsewhere (-) (-)
3. Tax-Exempt Interest Income (+) (+)
4. State and Local Tax Refunds (-) (-)
5. Nonrecurring Alimony Received (-) (-)
6. Negate Schedule D (Income) Loss (+/-) (+/-)
7. Pension and/or IRA Distributions (+) (+)
8. Negate Schedule E (Income) Loss (+/-) (+/-)
9. Nonrecurring Unemployment Compensation (-) (-)
10. Social Security Benefit (+) (+)
11. Nonrecurring Other (Income) Loss (+/-) (+/-)
12. Other
Form 2106 - Employee Business Expenses
13. Total Expenses (-) (-)
14. Depreciation (+) (+)
Schedule B - Interest and Dividend Income
15. Nonrecurring Interest Income (-) (-)
16. Nonrecurring Dividend Income (-) (-)
Schedule C - Profit or Loss from Business: Sole Proprietorship
17. Nonrecurring Other (Income) Loss/Expenses (+/-) (+/-)
18. Depletion (+) (+)
19. Depreciation (+) (+)
20. Meals and Entertainment Exclusion (-) (-)
21. Business Use of Home (+) (+)
22. Amortization/Casualty Loss (+) (+)
Schedule D - Capital Gains and Losses
23. Recurring Capital Gains/(Loss) (+/-) (+/-)
Form 4797 - Sales of Business Property
24. Recurring Capital Gains/(Loss) (+/-) (+/-)
Form 6252 - Installment Sale Income
25. Principal Payments Received (+) (+)
Schedule E - Supplemental Income and Loss
26. Gross Rents and Royalties Received (+) (+)
27. Total Expenses Before Depreciation (-) (-)
28. Amortization/Casualty Loss/Non-recurring Expenses (+) (+)
29. Insurance, Mortgage Interest, and Taxes included in PITI payment
(Only if using the property's full PITI payment in qualifying ratios) (+) (+)
Schedule F - Profit or Loss from Farming
30. Non-Tax Portion Ongoing Coop and CCC Payments (+) (+)
31. Nonrecurring Other (Income) Loss (+/-) (+/-)
32. Depreciation (+) (+)
33. Amortization/Casualty Loss/Depletion (+) (+)
34. Business Use of Home (+) (+)
(Consider K-1 income only if the borrower can document ownership and access to income, the business has adequate liquidity to support withdrawal,
and the business has positive sales and earnings trends.)
Partnership Schedule K-1 (Form 1065)
35. Ordinary Income (Loss) (+/-) (+/-)
36. Net Income (Loss) (+/-) (+/-)
37. Guaranteed Payments to Partner (+) (+)
S Corporation Schedule K-1 (Form 1120s)
38. Ordinary Income (Loss) (+/-) (+/-)
39. Net Income (Loss) (+/-) (+/-)
1040 Total
Revised 1084-10/01
Partnerships, S Corporations, and Corporations
Whether or not additional income from a Partnership, S Corporation, or regular corporation is used to qualify an
applicant, lenders must still conduct an analysis of the business tax returns to ensure a consistent pattern of
p
rofitablit
y
.
A
n
y
loss resultin
g
from this anal
y
sis must be deducted from cash flow as it re
p
resents a drain on
the borrower's income.
The following sources of income may be considered for qualification provided:
The borrower can document The business has adequate The business has positive sales
ownership and access to liquidity to support withdrawal and earnings trends
income; of earnings; and
Partnership - Form 1065 Yr. Yr.
40. Passthrough (Income) Loss from Other Partnerships (+/-) (+/-)
41. Nonrecurring Other (Income) Loss (+/-) (+/-)
42. Depreciation (+) (+)
43. Depletion (+) (+)
44. Amortization/Casualty Loss (+) (+)
45. Mortgage or Notes Payable in Less than 1 Year (-) (-)
46. Meals and Entertainment Exclusion (-) (-)
47. Subtotal
48. Partnership Total (subtotal multiplied by % ownership)
S Corporation - Form 1120S
49. Nonrecurring Other (Income) Loss (+/-) (+/-)
50. Depreciation (+) (+)
51. Depletion (+) (+)
52. Amortization/Casualty Loss (+) (+)
53. Mortgage or Notes Payable in Less than 1 Year (-) (-)
54. Meals and Entertainment Exclusion (-) (-)
55. Subtotal
56. S Corporation Total (subtotal multiplied by % ownership)
Regular Corporation - Form 1120
57. Taxable Income
58. Total Tax (-) (-)
59. Nonrecurring (Gains) Losses (+/-) (+/-)
60. Nonrecurring Other (Income) Loss (+/-) (+/-)
61. Depreciation (+) (+)
62. Depletion (+) (+)
63. Amortization/Casualty Loss (+) (+)
64. Net Operating Loss and Special Deductions (+) (+)
65. Mortgage or Notes Payable in Less than 1 Year (-) (-)
66. Meals and Entertainment Exclusion (-) (-)
67. Subtotal
68. Subtotal Multipied by Ownership Percentage
69. Less: Dividends Paid to Borrower (-) (-)
70. Corporation Total
Totals
1040 total
Partnership, S Corporation, and Corporation totals
Grand Total
Year-to-Date income from profit and loss statements may only be considered if it is consistent with the previous years' earnings.
Allowable addbacks include depreciation, depletion, and other non-cash expenses as identified above.
Year-to-Date Profit and Loss Statement
Salary/Draw to Individual
Net Profit
X
%Ownership =
Total Allowable Addbacks
X
%Ownership =
Year-to-Date Total
Revised 1084-10/01