{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["CashFlowAnalysisCalculator"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CashFlowAnalysisCalculator","index":0,"n_rows":281,"n_cols":12,"rows_kept":281,"cut":false,"hidden":false,"merged":[[44,11,56,12],[59,11,72,12],[43,4,43,9],[58,4,58,9],[99,4,99,9],[105,4,105,9],[111,4,111,9],[128,4,128,9],[100,11,104,12],[106,11,110,12],[124,11,127,12],[117,4,117,9],[123,4,123,9],[112,11,116,12],[118,11,122,12],[158,11,158,12],[146,11,146,12],[144,11,145,12],[90,11,90,12],[58,11,58,12],[133,4,133,9],[138,4,138,9],[146,4,146,9],[158,4,158,9],[139,11,142,12],[134,11,137,12],[129,11,132,12],[78,11,89,12],[91,11,98,12],[124,2,124,3],[119,2,119,3],[120,2,120,3],[121,2,121,3],[170,4,170,9],[182,4,182,9],[193,4,193,9],[249,4,249,9],[111,11,111,12],[123,11,123,12],[117,11,117,12],[228,11,230,12],[216,11,226,12],[249,11,249,12],[138,11,138,12],[128,11,128,12],[133,11,133,12],[147,11,156,12],[159,11,168,12],[171,11,180,12],[183,11,191,12],[194,11,202,12],[193,11,193,12],[170,11,170,12],[173,2,173,3],[162,2,162,3],[163,2,163,3],[126,2,126,3],[129,2,129,3],[130,2,130,3],[131,2,131,3],[2,13,2,19],[2,7,2,8],[3,7,3,8],[2,9,2,11],[3,9,3,11],[13,2,13,3],[7,11,7,12],[31,2,31,3],[87,2,87,3],[88,2,88,3],[29,2,29,3],[60,2,60,3],[73,11,73,12],[86,2,86,3],[71,2,71,3],[50,2,50,3],[65,2,65,3],[102,2,102,3],[91,2,91,3],[143,11,143,12],[99,11,99,12],[105,11,105,12],[103,2,103,3],[109,2,109,3],[125,2,125,3],[106,2,106,3],[92,2,92,3],[139,2,139,3],[140,2,140,3],[134,2,134,3],[135,2,135,3],[136,2,136,3],[141,2,141,3],[115,2,115,3],[118,2,118,3],[101,2,101,3],[107,2,107,3],[108,2,108,3],[112,2,112,3],[113,2,113,3],[114,2,114,3],[28,11,28,12],[34,11,36,12],[29,11,32,12],[37,11,37,12],[38,11,41,12],[74,11,76,12],[28,4,28,9],[59,2,59,3],[77,11,77,12],[32,2,32,3],[33,2,33,3],[33,11,33,12],[34,2,34,3],[40,2,40,3],[41,2,41,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[47,2,47,3],[48,2,48,3],[35,2,35,3],[56,2,56,3],[63,2,63,3],[43,11,43,12],[0,1,0,12],[5,1,5,12],[21,2,21,3],[26,2,26,3],[16,2,16,3],[19,2,19,3],[25,2,25,3],[23,11,23,12],[20,2,20,3],[24,2,24,3],[14,2,14,3],[8,11,17,12],[19,11,21,12],[24,11,27,12],[18,11,18,12],[100,2,100,3],[94,2,94,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[12,2,12,3],[11,2,11,3],[78,2,78,3],[64,2,64,3],[70,2,70,3],[74,2,74,3],[15,2,15,3],[61,2,61,3],[62,2,62,3],[30,2,30,3],[75,2,75,3],[49,2,49,3],[55,2,55,3],[79,2,79,3],[93,2,93,3],[97,2,97,3],[95,2,95,3],[96,2,96,3],[280,3,282,12],[280,2,282,2],[269,2,269,3],[270,2,270,3],[274,2,274,3],[275,2,275,3],[274,11,274,12],[259,2,259,3],[261,2,261,3],[260,2,260,3],[262,2,262,3],[263,2,263,3],[267,2,267,3],[273,11,273,12],[266,11,266,12],[268,2,268,3],[276,2,276,3],[264,2,264,3],[271,2,271,3],[250,11,265,12],[267,11,271,12],[275,11,279,12],[250,2,250,3],[255,2,255,3],[256,2,256,3],[257,2,257,3],[258,2,258,3],[251,2,251,3],[252,2,252,3],[253,2,253,3],[254,2,254,3],[177,2,177,3],[187,2,187,3],[178,2,178,3],[179,2,179,3],[180,2,180,3],[226,2,226,3],[195,2,195,3],[196,2,196,3],[197,2,197,3],[198,2,198,3],[199,2,199,3],[225,2,225,3],[230,2,230,3],[233,2,233,3],[237,2,237,3],[242,2,242,3],[247,2,247,3],[167,2,167,3],[144,2,144,3],[171,2,171,3],[172,2,172,3],[150,2,150,3],[151,2,151,3],[152,2,152,3],[156,2,156,3],[160,2,160,3],[168,2,168,3],[147,2,147,3],[148,2,148,3],[164,2,164,3],[165,2,165,3],[166,2,166,3],[161,2,161,3],[149,2,149,3],[153,2,153,3],[154,2,154,3],[155,2,155,3],[159,2,159,3],[174,2,174,3],[175,2,175,3],[176,2,176,3],[205,2,205,3],[210,2,210,3],[218,2,218,3],[219,2,219,3],[220,2,220,3],[221,2,221,3],[202,2,202,3],[213,2,213,3],[206,2,206,3],[207,2,207,3],[208,2,208,3],[209,2,209,3],[201,2,201,3],[212,2,212,3],[216,2,216,3],[204,4,204,9],[215,4,215,9],[232,4,232,9],[227,11,227,12],[232,11,232,12],[205,11,213,12],[222,2,222,3],[223,2,223,3],[228,2,228,3],[229,2,229,3],[204,11,204,12],[246,2,246,3],[182,11,182,12],[183,2,183,3],[184,2,184,3],[185,2,185,3],[186,2,186,3],[188,2,188,3],[190,2,190,3],[191,2,191,3],[194,2,194,3],[239,2,239,3],[244,2,244,3],[234,2,234,3],[235,2,235,3],[236,2,236,3],[238,2,238,3],[245,2,245,3],[240,2,240,3],[241,2,241,3],[243,2,243,3],[233,11,247,12],[227,2,227,3],[224,2,224,3],[215,11,215,12]]}
[null,"\nSelf Employment Calculator\nCash Flow Analysis"]
[]
[null,null,"Borrower's Name",null,null,null,null,"Loan Number"]
[null,null,"Completed By",null,null,null,null,"Date"]
[]
[null,"Complete all \"White\" colored fields.  For additional documentation and calculation information hold your cursor over the red triangle located in the uper right hand corner of the \"Yellow\" colored fields.  This information is not all inclusive, refer to P&P Section 704.C for all guidelines regarding self-employed borrowers."]
[]
[null,null,"Form 1040 - Individual Income Tax Return",null,"YTD P&L as of:",null,null,"Select Year",null,"Select Year",null,"Comments"]
[null,null,"W2 Income From Self Employment(line 7)",null,0,null,null,0,null,0]
[null,null,"Tax-Exempt Interest(line 8b)",null,0,null,null,0,null,0]
[null,null,"Alimony(line 11)",null,0,null,null,0,null,0]
[null,null,"IRA Distributions(line 15a & 15b)"," ",0,null,null,0," ",0]
[null,null,"Pension(line 16a & 16b)  "," ",0,null,null,0," ",0]
[null,null,"Unemployment(line 19)",null,0,null,null,0,null,0]
[null,null,"Social Security(line 20a & 20b)  ",null,0,null,null,0,null,0]
[null,null,"Other Income(line 21)",null,0,null,null,0,null,0]
[null,null,"Total Individual Income Tax Return",null,{"$f":"SUM(E9:E16)","v":0},null,null,{"$f":"SUM(H9:H16)","v":0},null,{"$f":"SUM(J9:J16)","v":0}]
[]
[null,null,"Form 2106 - Employee Business Expenses",null,null,null,null,null,null,0,null,"Comments"]
[null,null,"Total Unreimbursed Expenses",null,0,null,null,0,null,0]
[null,null,"Depreciation ",null,0,null,null,0,null,0]
[null,null,"Total Employee Business Expenses",null,{"$f":"SUM(E21-E20)","v":0},null,null,{"$f":"SUM(H21-H20)","v":0},null,{"$f":"SUM(J21-J20)","v":0}]
[]
[null,null,"Schedule B - Interest and Dividends",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Interest Income"," ",0,null,null,0," ",0]
[null,null,"Dividend Income"," ",0,null,null,0," ",0]
[null,null,"Total Interest and Dividends",null,{"$f":"SUM(E25:E26)","v":0},null,null,{"$f":"SUM(H25:H26)","v":0},null,{"$f":"SUM(J25:J26)","v":0}]
[]
[null,null,"Schedule C - Sole Proprietorship",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Net Profit or (Loss)",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Depreciation"," ",0,null,null,0," ",0]
[null,null,"Meals and Entertainment Exclusion",null,0,null,null,0,null,0,null,"Notes"]
[null,null,"Business Use of Home",null,0,null,null,0,null,0]
[null,null,"Business Miles - Form 2106",null,{"$f":"+A37*A38","v":0},null,null,{"$f":"+D37*D38","v":0},null,{"$f":"+D39*D40","v":0}]
[null,null," - Business Miles - Column 1"]
[null,null,"        - Depreciation Rate",null,null,null,null,null,null,null,null,"Comments"]
[null,null," - Business Miles - Column 2"]
[null,null,"        - Depreciation Rate"]
[null,null,"Amortization/Casualty Loss/One Time Expense",null,0,null,null,0,null,0]
[null,null,"Total Sole Proprietorship",null,{"$f":"(E30+E31+E32+E33-E34+ E35+E36+E41)","v":0},null,null,{"$f":"(H30+H31+H32+H33-H34+ H35+H36+H41)","v":0},null,{"$f":"(J30+J31+J32+J33-J34+ J35+J36+J41)","v":0}]
[]
[null,null,"Schedule C - Sole Proprietorship",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Net Profit or (Loss)",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Depreciation"," ",0,null,null,0," ",0]
[null,null,"Meals and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Business Use of Home",null,0,null,null,0,null,0]
[null,null,"Business Miles - Form 2106",null,{"$f":"+A52*A53","v":0},null,null,{"$f":"+D52*D53","v":0},null,{"$f":"+D54*D55","v":0}]
[null,null," - Business Miles - Column 1"]
[null,null,"        - Depreciation Rate"]
[null,null," - Business Miles - Column 2"]
[null,null,"        - Depreciation Rate"]
[null,null,"Amortization/Casualty Loss/One Time Expense",null,0,null,null,0,null,0]
[null,null,"Total Sole Proprietorship",null,{"$f":"(E45+E46+E47+E48-E49+ E50+E51+E56)","v":0},null,null,{"$f":"(H45+H46+H47+H48-H49+ H50+H51+H56)","v":0},null,{"$f":"(J45+J46+J47+J48-J49+ J50+J51+J56)","v":0}]
[]
[null,null,"Schedule C - Sole Proprietorship",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Net Profit or (Loss)",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Depreciation"," ",0,null,null,0," ",0]
[null,null,"Meals and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Business Use of Home",null,0,null,null,0,null,0]
[null,null,"Business Miles - Form 2106",null,{"$f":"+A67*A68","v":0},null,null,{"$f":"+D67*D68","v":0},null,{"$f":"+D69*D70","v":0}]
[null,null," - Business Miles - Column 1"]
[null,null,"        - Depreciation Rate"]
[null,null," - Business Miles - Column 2"]
[null,null,"        - Depreciation Rate"]
[null,null,"Amortization/Casualty Loss/One Time Expense",null,0,null,null,0,null,0]
[null,null,"Total Sole Proprietorship",null,{"$f":"(E60+E61+E62+E63-E64+ E65+E66+E71)","v":0},null,null,{"$f":"(H60+H61+H62+H63-H64+ H65+H66+H71)","v":0},null,{"$f":"(J60+J61+J62+J63-J64+ J65+J66+J71)","v":0}]
[]
[null,null,"Schedule D - Capital Gains and Losses",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Capital Gains (Losses)",null,0,null,null,0,null,0]
[null,null,"Total Capital Gains and Losses",null,{"$f":"SUM(E75)","v":0},null,null,{"$f":"SUM(H75)","v":0},null,{"$f":"SUM(J75)","v":0}]
[]
[null,null,"Schedule E - Rent and Royalty Income, Investment Properties",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Gross Rents and Royalties",null,0,null,null,0,null,0]
[null,null,"Total Expenses  ",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Total Expenses without Depreciation",null,{"$f":"+E79-E80+E81","v":0},null,null,{"$f":"+H79-H80+H81","v":0},null,{"$f":"+J79-J80+J81","v":0}]
[null,null,"Amort/Casualty Loss/Non Recurring Expenses",null,0,null,null,0,null,0]
[null,null,"Insurance",null,0,null,null,0,null,0]
[null,null,"Mortgage Interest",null,0,null,null,0,null,0]
[null,null,"Taxes",null,0,null,null,0,null,0]
[null,null,"Insurance, Mortgage Interest, & Taxes included in PITI",null,0,null,null,0,null,0]
[null,null,"(only if using ppty's full PITI in qualifying ratio-lines  9,12,16)",null,{"$f":"+E87*12","v":0},null,null,{"$f":"+H87*12","v":0},null,{"$f":"+J87*12","v":0}]
[null,null,"Total Rent, Royalty Income, Investment Prop",null,{"$f":"+E82+E83+E84+E85+E86-E88","v":0},null,null,{"$f":"+H82+H83+H84+H85+H86-H88","v":0},null,{"$f":"+J82+J83+J84+J85+J86-J88","v":0}]
[]
[null,null,"Schedule F - Profit or Loss for Farming",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Net Profit or (Loss)",null,0,null,null,0,null,0]
[null,null,"Non-Tax Portion of Coop & CCC",null,0,null,null,0,null,0]
[null,null,"Other Income or Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Other Expenses",null,0,null,null,0,null,0]
[null,null,"Business Use of Home",null,0,null,null,0,null,0]
[null,null,"Total Farming Profit or Loss",null,{"$f":"SUM(E92:E97)","v":0},null,null,{"$f":"SUM(H92:H97)","v":0},null,{"$f":"SUM(J92:J97)","v":0}]
[]
[null,null,"Partners Share of Income - Schedule K-1 (Form 1065)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Guaranteed Payments to Partner",null,0,null,null,0,null,0]
[null,null,"subtotal Section VIII",null,{"$f":"SUM(E101:E103)","v":0},null,null,{"$f":"SUM(H101:H103)","v":0},null,{"$f":"SUM(J101:J103)","v":0}]
[]
[null,null,"Partners Share of Income - Schedule K-1 (Form 1065)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Guaranteed Payments to Partner",null,0,null,null,0,null,0]
[null,null,"subtotal Section VIII",null,{"$f":"SUM(E107:E109)","v":0},null,null,{"$f":"SUM(H107:H109)","v":0},null,{"$f":"SUM(J107:J109)","v":0}]
[]
[null,null,"Partners Share of Income - Schedule K-1 (Form 1065)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Guaranteed Payments to Partner",null,0,null,null,0,null,0]
[null,null,"subtotal Section VIII",null,{"$f":"SUM(E113:E115)","v":0},null,null,{"$f":"SUM(H113:H115)","v":0},null,{"$f":"SUM(J113:J115)","v":0}]
[]
[null,null,"Partners Share of Income - Schedule K-1 (Form 1065)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Guaranteed Payments to Partner",null,0,null,null,0,null,0]
[null,null,"subtotal Section VIII",null,{"$f":"SUM(E119:E121)","v":0},null,null,{"$f":"SUM(H119:H121)","v":0},null,{"$f":"SUM(J119:J121)","v":0}]
[]
[null,null,"Shareholders Share of Income-Sched. K-1 (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"subtotal Section IX",null,{"$f":"SUM(E125:E126)","v":0},null,null,{"$f":"SUM(H125:H126)","v":0},null,{"$f":"SUM(J125:J126)","v":0}]
[]
[null,null,"Shareholders Share of Income-Sched. K-1 (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"subtotal Section IX",null,{"$f":"SUM(E130:E131)","v":0},null,null,{"$f":"SUM(H130:H131)","v":0},null,{"$f":"SUM(J130:J131)","v":0}]
[]
[null,null,"Shareholders Share of Income-Sched. K-1 (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"subtotal Section IX",null,{"$f":"SUM(E135:E136)","v":0},null,null,{"$f":"SUM(H135:H136)","v":0},null,{"$f":"SUM(J135:J136)","v":0}]
[]
[null,null,"Shareholders Share of Income-Sched. K-1 (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Ordinary Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Net Income (Loss)",null,0,null,null,0,null,0]
[null,null,"subtotal Section IX",null,{"$f":"SUM(E140:E141)","v":0},null,null,{"$f":"SUM(H140:H141)","v":0},null,{"$f":"SUM(J140:J141)","v":0}]
[]
[null,null,"TOTALS",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Total Personal Income",null,{"$f":"SUM(E17,E22,E27,E42,E57,E72,E76,E89,E98,E104,E110,E116,E122,E127,E132,E137,E142,)","v":0},null,null,{"$f":"SUM(H17,H22,H27,H42,H57,H72,H76,H89,H98,H104,H110,H116,H122,H127,H132,H137,H142,)","v":0},null,{"$f":"SUM(J17,J22,J27,J42,J57,J72,J76,J89,J98,J104,J110,J116,J122,J127,J132,J137,J142,)","v":0}]
[]
[null,null,"Partnership (Form 1065) ",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Pass-Through (Income) Loss ",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other (Income) or Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E148+E149+E150+E151+E152-E153-E154)","v":0},null,null,{"$f":"(H148+H149+H150+H151+H152-H153-H154)","v":0},null,{"$f":"(J148+J149+J150+J151+J152-J153-J154)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total Partnership Income",null,{"$f":"E155*E156","v":0},null,null,{"$f":"H155*H156","v":0},"  ",{"$f":"J155*J156","v":0}]
[]
[null,null,"Partnership (Form 1065) ",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Pass-Through (Income) Loss ",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other (Income) or Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E160+E161+E162+E163+E164-E165-E166)","v":0},null,null,{"$f":"(H160+H161+H162+H163+H164-H165-H166)","v":0},null,{"$f":"(J160+J161+J162+J163+J164-J165-J166)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total Partnership Income",null,{"$f":"E167*E168","v":0},null,null,{"$f":"H167*H168","v":0},"  ",{"$f":"J167*J168","v":0}]
[]
[null,null,"Partnership (Form 1065) ",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Pass-Through (Income) Loss ",null,0,null,null,0,null,0]
[null,null,"Nonrecurring Other (Income) or Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E172+E173+E174+E175+E176-E177-E178)","v":0},null,null,{"$f":"(H172+H173+H174+H175+H176-H177-H178)","v":0},null,{"$f":"(J172+J173+J174+J175+J176-J177-J178)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total Partnership Income",null,{"$f":"E179*E180","v":0},null,null,{"$f":"H179*H180","v":0},"  ",{"$f":"J179*J180","v":0}]
[]
[null,null,"S-Corporation (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E184+E185+E186+E187-E188-E189)","v":0},null,null,{"$f":"(H184+H185+H186+H187-H188-H189)","v":0},null,{"$f":"(J184+J185+J186+J187-J188-J189)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total S-Corporation Income",null,{"$f":"(E190*E191)","v":0},null,null,{"$f":"(H190*H191)","v":0}," ",{"$f":"(J190*J191)","v":0}]
[]
[null,null,"S-Corporation (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E195+E196+E197+E198-E199-E200)","v":0},null,null,{"$f":"(H195+H196+H197+H198-H199-H200)","v":0},null,{"$f":"(J195+J196+J197+J198-J199-J200)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total S-Corporation Income",null,{"$f":"(E201*E202)","v":0},null,null,{"$f":"(H201*H202)","v":0}," ",{"$f":"(J201*J202)","v":0}]
[]
[null,null,"S-Corporation (Form 1120s)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Nonrecurring Other Income (Loss)",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgage/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E206+E207+E208+E209-E210-E211)","v":0},null,null,{"$f":"(H206+H207+H208+H209-H210-H211)","v":0},null,{"$f":"(J206+J207+J208+J209-J210-J211)","v":0}]
[null,null,"Ownership Percentage Listed on Schedule K-1",null,0,null,null,0,null,0]
[null,null,"Total S-Corporation Income",null,{"$f":"(E212*E213)","v":0},null,null,{"$f":"(H212*H213)","v":0}," ",{"$f":"(J212*J213)","v":0}]
[]
[null,null,"Corporation (Form 1120)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Taxable Income*",null,0,null,null,0,null,0]
[null,null,"Total Tax"," ",0,null,null,0," ",0]
[null,null,"(Gains) Loss",null,0,null,null,0,null,0]
[null,null,"Other (Income) Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Net Operating Loss and Special Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgages/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E217+E218+E219+E220+E221+E222+E223+E224-E225-E226)","v":0},null,null,{"$f":"(H217+H218+H219+H220+H221+H222+H223+H224-H225-H226)","v":0}," ",{"$f":"(J217+J218+J219+J220+J221+J222+J223+J224-J225-J226)","v":0}]
[null,null,"Ownership Percentage Listed on 1120 Schedule E ",null,0,null,null,0," ",0,null,"Notes"]
[null,null,"Modified Subtotal",null,{"$f":"(E227*E228)","v":0},null,null,{"$f":"(H227*H228)","v":0},null,{"$f":"(J227*J228)","v":0},null,"*Fannie Mae allows the use of corporate earnings to qualify only when the borrower can document 100% ownership of the business."]
[null,null,"Dividends Paid to Borrower",null,0,null,null,0,null,0]
[null,null,"Total Corporation Income",null,{"$f":"SUM(E229:E230)","v":0},null,null,{"$f":"SUM(H229:H230)","v":0},null,{"$f":"SUM(J229:J230)","v":0}]
[]
[null,null,"Corporation (Form 1120)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Taxable Income",null,0,null,null,0,null,0]
[null,null,"Total Tax"," ",0,null,null,0," ",0]
[null,null,"(Gains) Loss",null,0,null,null,0,null,0]
[null,null,"Other (Income) Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Net Operating Loss and Special Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgages/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E234+E235+E236+E237+E238+E239+E240+E241-E242-E243)","v":0},null,null,{"$f":"(H234+H235+H236+H237+H238+H239+H240+H241-H242-H243)","v":0}," ",{"$f":"(J234+J235+J236+J237+J238+J239+J240+J241-J242-J243)","v":0}]
[null,null,"Ownership Percentage Listed on 1120 Schedule E ",null,0,null,null,0," ",0]
[null,null,"Modified Subtotal",null,{"$f":"(E244*E245)","v":0},null,null,{"$f":"(H244*H245)","v":0},null,{"$f":"(J244*J245)","v":0}]
[null,null,"Dividends Paid to Borrower",null,0,null,null,0,null,0]
[null,null,"Total Corporation Income",null,{"$f":"SUM(E246:E247)","v":0},null,null,{"$f":"SUM(H246:H247)","v":0},null,{"$f":"SUM(J246:J247)","v":0}]
[]
[null,null,"Corporation (Form 1120)",null,"Business name:",null,null,null,null,null,null,"Comments"]
[null,null,"Taxable Income",null,0,null,null,0,null,0]
[null,null,"Total Tax"," ",0,null,null,0," ",0]
[null,null,"(Gains) Loss",null,0,null,null,0,null,0]
[null,null,"Other (Income) Loss",null,0,null,null,0,null,0]
[null,null,"Depreciation",null,0,null,null,0,null,0]
[null,null,"Depletion",null,0,null,null,0,null,0]
[null,null,"Amortization and Other Deductions",null,0,null,null,0,null,0]
[null,null,"Net Operating Loss and Special Deductions",null,0,null,null,0,null,0]
[null,null,"Mortgages/Notes Payable in Less than 1 Year",null,0,null,null,0,null,0]
[null,null,"Travel and Entertainment Exclusion",null,0,null,null,0,null,0]
[null,null,"Subtotal",null,{"$f":"(E251+E252+E253+E254+E255+E256+E257+E258-E259-E260)","v":0},null,null,{"$f":"(H251+H252+H253+H254+H255+H256+H257+H258-H259-H260)","v":0}," ",{"$f":"(J251+J252+J253+J254+J255+J256+J257+J258-J259-J260)","v":0}]
[null,null,"Ownership Percentage Listed on 1120 Schedule E ",null,0,null,null,0,null,0]
[null,null,"Modified Subtotal",null,{"$f":"(E261*E262)","v":0},null,null,{"$f":"(H261*H262)","v":0},null,{"$f":"(J261*J262)","v":0}]
[null,null,"Dividends Paid to Borrower",null,0,null,null,0,null,0]
[null,null,"Total Corporation Income",null,{"$f":"SUM(E263:E264)","v":0},null,null,{"$f":"SUM(H263:H264)","v":0},null,{"$f":"SUM(J263:J264)","v":0}]
[]
[null,null,"Totals",null,null,null,null,null,null,null,null,"Comments"]
[null,null,"Personal Tax Returns",null,{"$f":"E145","v":0},null,null,{"$f":"H145","v":0}," ",{"$f":"J145","v":0}]
[null,null,"Partnership Return",null,{"$f":"SUM(E157,E169,E181,)","v":0},null,null,{"$f":"SUM(H157,H169,H181,)","v":0}," ",{"$f":"SUM(J157,J169,J181,)","v":0}]
[null,null,"S-Corporation Return",null,{"$f":"SUM(E214,E203,E192,)","v":0},null,null,{"$f":"SUM(H214,H203,H192,)","v":0}," ",{"$f":"SUM(J214,J203,J192,)","v":0}]
[null,null,"Corporation Return",null,{"$f":"SUM(E248,E231,E265)","v":0},null,null,{"$f":"SUM(H248,H231,H265)","v":0}," ",{"$f":"SUM(J248,J231,J265)","v":0}]
[null,null,"Total income from Tax Returns",null,{"$f":"E268+E269+E270+E271","v":0},null,null,{"$f":"H268+H269+H270+H271","v":0}," ",{"$f":"J268+J269+J270+J271","v":0}]
[]
[null,null,"Review Period"]
[null,null,"Number of Months In Review Period 12 or 24",null,null,null,null,24,null,"AVERAGES",null,"Comments"]
[null,null,"Income Total Year One",null,null,null,null,{"$f":"(H272)","v":0},null,{"$f":"+H276/12","v":0}]
[null,null,"Income Total Year Two",null,null,null,null,{"$f":"J272","v":0},null,{"$f":"+H277/12","v":0}]
[null,null,"YTD P&L","NUMBER OF MOS COVERED BY P&L",null,null,null,{"$f":"+E272","v":0},null,{"$f":"+H278/E278","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Monthly Income",null,null,null,{"$f":"IF(H275>0,(H276+H277)/H275,0)","v":0}]
[]
[null,null,"Overall Comments and Analysis"]