{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Calculator","LOOKUPS","_SUMM_ROWS_LKP_","_PROC_EXTRAS_LKP_"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"Calculator","index":0,"n_rows":625,"n_cols":14,"rows_kept":625,"cut":false,"hidden":false,"merged":[[605,9,605,10],[605,11,605,12],[606,2,606,3],[606,9,606,10],[606,11,606,12],[583,2,583,3],[583,9,583,10],[583,11,583,12],[577,2,577,3],[577,9,577,10],[577,11,577,12],[578,2,578,3],[578,9,578,10],[582,11,582,12],[578,11,578,12],[582,2,582,3],[582,9,582,10],[579,9,579,10],[579,11,579,12],[581,2,581,3],[581,9,581,10],[581,11,581,12],[584,2,584,3],[584,9,584,10],[624,2,624,11],[613,2,613,3],[613,9,613,10],[617,2,617,11],[569,2,569,3],[569,9,569,10],[569,11,569,12],[572,2,572,3],[572,9,572,10],[572,11,572,12],[575,2,575,3],[575,9,575,10],[575,11,575,12],[570,2,570,3],[570,9,570,10],[570,11,570,12],[571,2,571,3],[571,9,571,10],[571,11,571,12],[607,2,607,3],[607,9,607,10],[618,2,618,11],[619,2,619,11],[620,2,620,11],[621,2,621,11],[622,2,622,11],[623,2,623,11],[603,2,603,5],[607,11,607,12],[608,2,608,3],[608,9,608,10],[608,11,608,12],[609,2,609,3],[609,9,609,10],[609,11,609,12],[610,2,610,3],[610,9,610,10],[610,11,610,12],[611,2,611,3],[611,9,611,10],[611,11,611,12],[612,2,612,3],[612,9,612,10],[612,11,612,12],[604,2,604,3],[604,9,604,10],[604,11,604,12],[605,2,605,3],[573,2,573,3],[573,9,573,10],[573,11,573,12],[574,2,574,3],[574,9,574,10],[574,11,574,12],[576,2,576,3],[576,9,576,10],[576,11,576,12],[565,2,565,3],[565,9,565,10],[565,11,565,12],[567,2,567,3],[567,9,567,10],[567,11,567,12],[568,2,568,3],[568,9,568,10],[568,11,568,12],[566,2,566,3],[566,9,566,10],[566,11,566,12],[560,2,560,5],[561,2,561,3],[561,9,561,10],[561,11,561,12],[562,2,562,3],[562,9,562,10],[562,11,562,12],[564,2,564,3],[564,9,564,10],[564,11,564,12],[563,9,563,10],[563,11,563,12],[563,2,563,3],[558,2,558,3],[558,9,558,10],[558,11,558,12],[559,2,559,3],[559,9,559,10],[559,11,559,12],[555,2,555,3],[555,9,555,10],[555,11,555,12],[556,2,556,3],[556,9,556,10],[556,11,556,12],[557,2,557,3],[557,9,557,10],[557,11,557,12],[503,2,503,6],[504,2,504,5],[553,2,553,3],[553,9,553,10],[553,11,553,12],[554,2,554,3],[554,9,554,10],[554,11,554,12],[552,2,552,3],[552,9,552,10],[552,11,552,12],[531,2,531,6],[532,2,532,5],[533,2,533,5],[537,2,537,6],[538,2,538,5],[496,2,496,5],[497,2,497,6],[550,2,550,3],[548,2,548,11],[550,11,551,12],[550,1,551,1],[550,4,550,5],[550,7,550,8],[550,9,551,10],[499,2,499,6],[509,2,509,6],[510,2,510,5],[515,2,515,3],[515,4,515,6],[519,2,519,3],[523,2,523,6],[524,2,524,5],[525,2,525,6],[526,2,526,6],[527,2,527,6],[528,2,528,6],[529,2,529,6],[530,2,530,6],[502,2,502,6],[475,2,475,6],[476,2,476,5],[477,2,477,5],[481,2,481,6],[482,2,482,5],[487,2,487,3],[487,4,487,6],[491,2,491,3],[495,2,495,6],[277,2,277,3],[277,4,277,6],[281,2,281,6],[282,2,282,6],[153,2,153,5],[154,2,154,5],[152,2,152,6],[135,2,135,3],[135,4,135,6],[139,2,139,6],[140,2,140,6],[141,2,141,6],[147,2,147,6],[148,2,148,6],[149,2,149,6],[150,2,150,6],[151,2,151,6],[158,2,158,6],[163,2,163,3],[163,4,163,6],[167,2,167,6],[168,2,168,6],[169,2,169,6],[175,2,175,6],[119,2,119,6],[120,2,120,6],[121,2,121,6],[122,2,122,6],[123,2,123,6],[124,2,124,6],[125,2,125,5],[126,2,126,5],[130,2,130,6],[98,2,98,6],[99,2,99,6],[100,2,100,6],[87,2,87,5],[88,2,88,6],[93,2,93,6],[95,2,95,6],[96,2,96,6],[113,2,113,6],[107,2,107,3],[107,4,107,6],[86,2,86,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[77,2,77,6],[79,2,79,6],[97,2,97,6],[84,2,84,4],[66,2,66,6],[67,2,67,5],[68,2,68,6],[69,2,69,5],[57,2,57,6],[63,2,63,6],[64,2,64,6],[61,3,61,6],[53,2,53,6],[54,2,54,5],[55,2,55,6],[42,2,42,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[46,3,46,6],[40,2,40,6],[41,2,41,6],[33,2,33,6],[34,2,34,6],[35,2,35,6],[36,2,36,6],[51,2,51,6],[52,2,52,5],[56,2,56,6],[2,2,2,3],[2,4,2,7],[111,2,111,6],[112,2,112,6],[6,2,6,6],[8,2,8,6],[9,2,9,6],[14,2,14,6],[18,2,18,6],[16,3,16,6],[31,3,31,6],[24,2,24,5],[25,2,25,6],[26,2,26,6],[27,2,27,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,5],[23,2,23,6],[37,2,37,5],[38,2,38,6],[65,2,65,6],[39,2,39,5],[176,2,176,6],[177,2,177,6],[178,2,178,6],[179,2,179,6],[180,2,180,6],[181,2,181,5],[182,2,182,5],[186,2,186,6],[191,2,191,3],[191,4,191,6],[195,2,195,6],[196,2,196,6],[197,2,197,6],[203,2,203,6],[204,2,204,6],[205,2,205,6],[206,2,206,6],[207,2,207,6],[208,2,208,6],[209,2,209,5],[210,2,210,5],[214,2,214,6],[219,2,219,3],[219,4,219,6],[223,2,223,6],[224,2,224,6],[225,2,225,6],[231,2,231,6],[232,2,232,6],[233,2,233,6],[234,2,234,6],[235,2,235,6],[236,2,236,6],[237,2,237,5],[238,2,238,5],[242,2,242,6],[247,2,247,3],[247,4,247,6],[265,2,265,5],[266,2,266,5],[270,2,270,6],[251,2,251,6],[252,2,252,6],[253,2,253,6],[259,2,259,6],[260,2,260,6],[261,2,261,6],[262,2,262,6],[263,2,263,6],[264,2,264,6],[288,2,288,3],[318,2,318,3],[322,2,322,6],[323,2,323,6],[324,2,324,6],[325,2,325,6],[326,2,326,6],[327,2,327,5],[328,2,328,5],[297,2,297,5],[302,2,302,6],[307,2,307,3],[307,4,307,6],[311,2,311,6],[312,2,312,6],[292,2,292,6],[293,2,293,6],[294,2,294,6],[295,2,295,6],[296,2,296,6],[298,2,298,5],[332,2,332,6],[337,2,337,3],[337,4,337,6],[341,2,341,6],[342,2,342,6],[348,2,348,3],[352,2,352,6],[353,2,353,6],[354,2,354,6],[355,2,355,6],[356,2,356,6],[357,2,357,5],[358,2,358,5],[362,2,362,6],[367,2,367,3],[367,4,367,6],[371,2,371,6],[372,2,372,6],[378,2,378,3],[382,2,382,6],[383,2,383,6],[384,2,384,6],[385,2,385,6],[386,2,386,6],[387,2,387,5],[388,2,388,5],[392,2,392,6],[397,2,397,3],[397,4,397,6],[401,2,401,6],[402,2,402,6],[408,2,408,3],[412,2,412,6],[413,2,413,6],[414,2,414,6],[415,2,415,6],[416,2,416,6],[417,2,417,5],[418,2,418,5],[422,2,422,6],[427,2,427,3],[427,4,427,6],[431,2,431,6],[432,2,432,6],[438,2,438,3],[442,2,442,6],[443,2,443,6],[444,2,444,6],[445,2,445,6],[446,2,446,6],[447,2,447,5],[448,2,448,5],[452,2,452,6],[579,2,579,3],[467,2,467,6],[468,2,468,5],[469,2,469,6],[470,2,470,6],[471,2,471,6],[472,2,472,6],[459,4,459,6],[459,2,459,3],[463,2,463,3],[498,2,498,6],[500,2,500,6],[501,2,501,6],[505,2,505,5],[473,2,473,6],[474,2,474,6],[584,11,584,12],[585,2,585,3],[585,9,585,10],[585,11,585,12],[586,2,586,3],[586,9,586,10],[586,11,586,12],[590,2,590,3],[590,9,590,10],[590,11,590,12],[587,2,587,3],[587,9,587,10],[587,11,587,12],[588,2,588,3],[588,9,588,10],[588,11,588,12],[589,2,589,3],[589,9,589,10],[589,11,589,12],[596,2,596,3],[596,9,596,10],[596,11,596,12],[597,2,597,3],[597,9,597,10],[597,11,597,12],[580,2,580,3],[580,9,580,10],[580,11,580,12],[591,2,591,3],[591,9,591,10],[591,11,591,12],[592,2,592,3],[592,9,592,10],[592,11,592,12],[595,2,595,3],[595,9,595,10],[595,11,595,12],[593,2,593,3],[593,9,593,10],[593,11,593,12],[594,2,594,3],[594,9,594,10],[594,11,594,12],[601,2,601,3],[601,9,601,10],[601,11,601,12],[602,2,602,3],[602,9,602,10],[602,11,602,12],[598,2,598,3],[598,9,598,10],[598,11,598,12],[599,2,599,3],[599,9,599,10],[599,11,599,12],[600,2,600,3],[600,9,600,10],[600,11,600,12]]}
[null,"SAM Method",null,null,null,null,"Cash Flow Analysis Worksheet"]
[]
[null,null,"BORROWER AND/OR CO-BORROWER NAME:",null,null,null,null,null,null,"DATE:  "]
[]
[null,null,null,null,null,null,"YEAR 1:  ",null,null,"YEAR 2:  "]
[]
[null,"X","SCHEDULE B - INTEREST AND DIVIDENDS FROM SELF-EMPLOYMENT",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,1,"Recurring Interest Income: LINE 1 or 1040 LINE 2b (2018), LINE 8a (2017 and 2016)"]
[null,2,"Recurring Dividend Income: LINE 5 or 1040 LINE 3b (2018), LINE 9a (2017 and 2016)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"SUM(H9:H10)","v":0},null,null,{"$f":"SUM(K9:K10)","v":0}]
[]
[]
[null,"X","SCHEDULE C - SOLE PROPRIETORSHIP",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,3,"Net Profit (Loss): LINE 31"]
[null,4,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6"]
[null,5,"Depletion: LINE 12"]
[null,6,"Depreciation: LINE 13"]
[null,7,"Meals or Meals and Entertainment Exclusion: LINE 24b",null,null,null,"(",null,")","(",null,")"]
[null,8,"Business Use of Home: LINE 30"]
[null,9,"Business Miles: page 2, part IV, LINE 44a",null,null,null,"*Miles",null,null,"*Miles"]
[null,"10a","x Depreciation Rate 2018: $0.25, 2017: $0.25, 2016: $0.24",null,null,null,null,{"$f":"IFERROR(IF(AND(H25>0,$H$5>0),VLOOKUP($H$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(K25>0,$K$5>0),VLOOKUP($K$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""}]
[null,"10b","= Total Mileage Depreciation",null,null,null,null,{"$f":"IFERROR(IF(H26>0,H25*H26,\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(K26>0,K25*K26,\"\"),\"\")","v":""}]
[null,11,"Amortization/Casualty Loss (only if noted): page 2, part V"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H19:H22)-H23+H24+IF(ISNUMBER(H27),H27,0)+H28,0)","v":0},null,null,{"$f":"IFERROR(SUM(K19:K22)-K23+K24+IF(ISNUMBER(K27),K27,0)+K28,0)","v":0}]
[]
[null,null,"Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,3,"Net Profit (Loss): LINE 31"]
[null,4,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6"]
[null,5,"Depletion: LINE 12"]
[null,6,"Depreciation: LINE 13"]
[null,7,"Meals or Meals and Entertainment Exclusion: LINE 24b",null,null,null,"(",null,")","(",null,")"]
[null,8,"Business Use of Home: LINE 30"]
[null,9,"Business Miles: page 2, part IV, LINE 44a",null,null,null,"*Miles",null,null,"*Miles"]
[null,"10a","x Depreciation Rate 2018: $0.25, 2017: $0.25, 2016: $0.24",null,null,null,null,{"$f":"IFERROR(IF(AND(H40>0,$H$5>0),VLOOKUP($H$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(K40>0,$K$5>0),VLOOKUP($K$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""}]
[null,"10b","= Total Mileage Depreciation",null,null,null,null,{"$f":"IFERROR(IF(H41>0,H40*H41,\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(K41>0,K40*K41,\"\"),\"\")","v":""}]
[null,11,"Amortization/Casualty Loss (only if noted): page 2, part V"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H34:H37)-H38+H39+IF(ISNUMBER(H42),H42,0)+H43,0)","v":0},null,null,{"$f":"IFERROR(SUM(K34:K37)-K38+K39+IF(ISNUMBER(K42),K42,0)+K43,0)","v":0}]
[]
[null,null,"Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,3,"Net Profit (Loss): LINE 31"]
[null,4,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6"]
[null,5,"Depletion: LINE 12"]
[null,6,"Depreciation: LINE 13"]
[null,7,"Meals or Meals and Entertainment Exclusion: LINE 24b",null,null,null,"(",null,")","(",null,")"]
[null,8,"Business Use of Home: LINE 30"]
[null,9,"Business Miles: page 2, part IV, LINE 44a",null,null,null,"*Miles",null,null,"*Miles"]
[null,"10a","x Depreciation Rate 2018: $0.25, 2017: $0.25, 2016: $0.24",null,null,null,null,{"$f":"IFERROR(IF(AND(H55>0,$H$5>0),VLOOKUP($H$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(K55>0,$K$5>0),VLOOKUP($K$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""}]
[null,"10b","= Total Mileage Depreciation",null,null,null,null,{"$f":"IFERROR(IF(H56>0,H55*H56,\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(K56>0,K55*K56,\"\"),\"\")","v":""}]
[null,11,"Amortization/Casualty Loss (only if noted): page 2, part V"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H49:H52)-H53+H54+IF(ISNUMBER(H57),H57,0)+H58,0)","v":0},null,null,{"$f":"IFERROR(SUM(K49:K52)-K53+K54+IF(ISNUMBER(K57),K57,0)+K58,0)","v":0}]
[]
[null,null,"Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,3,"Net Profit (Loss): LINE 31"]
[null,4,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6"]
[null,5,"Depletion: LINE 12"]
[null,6,"Depreciation: LINE 13"]
[null,7,"Meals or Meals and Entertainment Exclusion: LINE 24b",null,null,null,"(",null,")","(",null,")"]
[null,8,"Business Use of Home: LINE 30"]
[null,9,"Business Miles: page 2, part IV, LINE 44a",null,null,null,"*Miles",null,null,"*Miles"]
[null,"10a","x Depreciation Rate 2018: $0.25, 2017: $0.25, 2016: $0.24",null,null,null,null,{"$f":"IFERROR(IF(AND(H70>0,$H$5>0),VLOOKUP($H$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(AND(K70>0,$K$5>0),VLOOKUP($K$5,LKP_MILEAGE,2,FALSE),\"\"),\"\")","v":""}]
[null,"10b","= Total Mileage Depreciation",null,null,null,null,{"$f":"IFERROR(IF(H71>0,H70*H71,\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(K71>0,K70*K71,\"\"),\"\")","v":""}]
[null,11,"Amortization/Casualty Loss (only if noted): page 2, part V"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H64:H67)-H68+H69+IF(ISNUMBER(H72),H72,0)+H73,0)","v":0},null,null,{"$f":"IFERROR(SUM(K64:K67)-K68+K69+IF(ISNUMBER(K72),K72,0)+K73,0)","v":0}]
[]
[]
[null,"X","SCHEDULE D - CAPITAL GAINS AND LOSSES",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,12,"Recurring Capital Gains (Loss): page 2, LINE 16 (details on FORM 8949)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"SUM(H80:H80)","v":0},null,null,{"$f":"SUM(K80:K80)","v":0}]
[]
[]
[null,"X","SCHEDULE E - SUPPLEMENTAL INCOME AND LOSS",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,13,"Royalty Income (Loss): LINE 4"]
[null,14,"Total Expenses: LINE 20",null,null,null,"(",null,")","(",null,")"]
[null,15,"Depletion: LINE 18"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"H87-H88+H89","v":0},null,null,{"$f":"K87-K88+K89","v":0}]
[]
[]
[null,"X","SCHEDULE F - FARM INCOME",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,16,"Net Profit (Loss): LINE 34"]
[null,17,"Non-Tax Portion Ongoing Co-op & CCC Pmts: LINES 3a minus b through 6a minus b"]
[null,18,"Deduct nonrecurring income/add nonrecurring loss: LINE 8 "]
[null,19,"Depreciation: LINE 14 "]
[null,20,"Amortization/Casualty Loss/Depletion (only if noted): LINE 32"]
[null,21,"Business Use of Home (only if noted): LINE 32"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"SUM(H96:H101)","v":0},null,null,{"$f":"SUM(K96:K101)","v":0}]
[]
[]
[null,null,"Partnership Cash Flow"]
[null,null,"Evaluate K-1 income and business income as required by your investor."]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H112:H114),0)","v":0},null,null,{"$f":"IFERROR(SUM(K112:K114),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H120:H125)-H126-H127,0)","v":0},null,null,{"$f":"IFERROR(SUM(K120:K125)-K126-K127,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H129*H131,0)","v":0},null,null,{"$f":"IFERROR(K129*K131,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H140:H142),0)","v":0},null,null,{"$f":"IFERROR(SUM(K140:K142),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H148:H153)-H154-H155,0)","v":0},null,null,{"$f":"IFERROR(SUM(K148:K153)-K154-K155,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H157*H159,0)","v":0},null,null,{"$f":"IFERROR(K157*K159,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H168:H170),0)","v":0},null,null,{"$f":"IFERROR(SUM(K168:K170),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H176:H181)-H182-H183,0)","v":0},null,null,{"$f":"IFERROR(SUM(K176:K181)-K182-K183,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H185*H187,0)","v":0},null,null,{"$f":"IFERROR(K185*K187,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H196:H198),0)","v":0},null,null,{"$f":"IFERROR(SUM(K196:K198),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H204:H209)-H210-H211,0)","v":0},null,null,{"$f":"IFERROR(SUM(K204:K209)-K210-K211,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H213*H215,0)","v":0},null,null,{"$f":"IFERROR(K213*K215,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H224:H226),0)","v":0},null,null,{"$f":"IFERROR(SUM(K224:K226),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H232:H237)-H238-H239,0)","v":0},null,null,{"$f":"IFERROR(SUM(K232:K237)-K238-K239,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H241*H243,0)","v":0},null,null,{"$f":"IFERROR(K241*K243,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP SCHEDULE K-1 and FORM 1065       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,22,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,23,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[null,24,"Guaranteed Payments to Partner: LINE 4"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H252:H254),0)","v":0},null,null,{"$f":"IFERROR(SUM(K252:K254),0)","v":0}]
[]
[null,null,"FORM 1065"]
[]
[null,25,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,26,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,27,"Depreciation: LINE 16c"]
[null,28,"Depreciation (FORM 8825): LINE 14"]
[null,29,"Depletion: LINE 17"]
[null,30,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,31,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,32,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H260:H265)-H266-H267,0)","v":0},null,null,{"$f":"IFERROR(SUM(K260:K265)-K266-K267,0)","v":0}]
[]
[null,33,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H269*H271,0)","v":0},null,null,{"$f":"IFERROR(K269*K271,0)","v":0}]
[]
[]
[null,null,"S Corporation Cash Flow"]
[null,null,"Evaluate K-1 income, W-2 wages and business income as required by your investor."]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H282:H283),0)","v":0},null,null,{"$f":"IFERROR(SUM(K282:K283),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H293:H297)-H298-H299,0)","v":0},null,null,{"$f":"IFERROR(SUM(K293:K297)-K298-K299,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H301*H303,0)","v":0},null,null,{"$f":"IFERROR(K301*K303,0)","v":0}]
[]
[]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H312:H313),0)","v":0},null,null,{"$f":"IFERROR(SUM(K312:K313),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H323:H327)-H328-H329,0)","v":0},null,null,{"$f":"IFERROR(SUM(K323:K327)-K328-K329,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H331*H333,0)","v":0},null,null,{"$f":"IFERROR(K331*K333,0)","v":0}]
[]
[]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H342:H343),0)","v":0},null,null,{"$f":"IFERROR(SUM(K342:K343),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H353:H357)-H358-H359,0)","v":0},null,null,{"$f":"IFERROR(SUM(K353:K357)-K358-K359,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H361*H363,0)","v":0},null,null,{"$f":"IFERROR(K361*K363,0)","v":0}]
[]
[]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H372:H373),0)","v":0},null,null,{"$f":"IFERROR(SUM(K372:K373),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H383:H387)-H388-H389,0)","v":0},null,null,{"$f":"IFERROR(SUM(K383:K387)-K388-K389,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H391*H393,0)","v":0},null,null,{"$f":"IFERROR(K391*K393,0)","v":0}]
[]
[]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H402:H403),0)","v":0},null,null,{"$f":"IFERROR(SUM(K402:K403),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H413:H417)-H418-H419,0)","v":0},null,null,{"$f":"IFERROR(SUM(K413:K417)-K418-K419,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H421*H423,0)","v":0},null,null,{"$f":"IFERROR(K421*K423,0)","v":0}]
[]
[]
[null,"X","S CORPORATION SCHEDULE K-1, W-2 WAGES and FORM 1120S       Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,34,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,35,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H432:H433),0)","v":0},null,null,{"$f":"IFERROR(SUM(K432:K433),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,36,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,37,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,38,"Depreciation: LINE 14"]
[null,39,"Depreciation (FORM 8825): LINE 14"]
[null,40,"Depletion: LINE 15"]
[null,41,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,42,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,43,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H443:H447)-H448-H449,0)","v":0},null,null,{"$f":"IFERROR(SUM(K443:K447)-K448-K449,0)","v":0}]
[]
[null,44,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H451*H453,0)","v":0},null,null,{"$f":"IFERROR(K451*K453,0)","v":0}]
[]
[]
[null,null,"Corporation Cash Flow"]
[null,null,"Evaluate W-2 wages and business income as required by your investor."]
[null,"X","W-2 WAGES and FORM 1120                             Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"FORM W-2"]
[]
[null,45,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,46,"Taxable Income: LINE 30"]
[null,47,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,48,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,49,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,50,"Depreciation: LINE 20"]
[null,51,"Depletion: LINE 21"]
[null,52,"Domestic Production Activities Deduction: LINE 25 (2017 and 2016)"]
[null,53,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,54,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,55,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,56,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H470:H476)+H468-H469-H477-H478,0)","v":0},null,null,{"$f":"IFERROR(SUM(K470:K476)+K468-K469-K477-K478,0)","v":0}]
[]
[null,57,"Multiplied by Ownership Percentage"]
[null,58,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"Corporation’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR((H480*H482)-H483,0)","v":0},null,null,{"$f":"IFERROR((K480*K482)-K483,0)","v":0}]
[]
[]
[null,"X","W-2 WAGES and FORM 1120                             Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"FORM W-2"]
[]
[null,45,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,46,"Taxable Income: LINE 30"]
[null,47,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,48,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,49,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,50,"Depreciation: LINE 20"]
[null,51,"Depletion: LINE 21"]
[null,52,"Domestic Production Activities Deduction: LINE 25 (2017 and 2016)"]
[null,53,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,54,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,55,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,56,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H498:H504)+H496-H497-H505-H506,0)","v":0},null,null,{"$f":"IFERROR(SUM(K498:K504)+K496-K497-K505-K506,0)","v":0}]
[]
[null,57,"Multiplied by Ownership Percentage"]
[null,58,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"Corporation’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR((H508*H510)-H511,0)","v":0},null,null,{"$f":"IFERROR((K508*K510)-K511,0)","v":0}]
[]
[]
[null,"X","W-2 WAGES and FORM 1120                             Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[null,null,"FORM W-2"]
[]
[null,45,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,46,"Taxable Income: LINE 30"]
[null,47,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,48,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,49,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,50,"Depreciation: LINE 20"]
[null,51,"Depletion: LINE 21"]
[null,52,"Domestic Production Activities Deduction: LINE 25 (2017 and 2016)"]
[null,53,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,54,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,55,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,56,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H526:H532)+H524-H525-H533-H534,0)","v":0},null,null,{"$f":"IFERROR(SUM(K526:K532)+K524-K525-K533-K534,0)","v":0}]
[]
[null,57,"Multiplied by Ownership Percentage"]
[null,58,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"Corporation’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR((H536*H538)-H539,0)","v":0},null,null,{"$f":"IFERROR((K536*K538)-K539,0)","v":0}]
[]
[]
[null,"SAM Method",null,null,null,null,"Cash Flow Analysis Worksheet"]
[]
[null,null,"Cash Flow Analysis Summary"]
[]
[]
[null,null,"A. To modify the Total No. of Months select the applicable number from the # mo. drop-down box. \nB. To exclude a Subtotal from Qualifying Income, select the box to the left of the dollar amount. "]
[]
[null,"p.1","PERSONAL CASH FLOW SUBTOTALS:",null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""},null,"Qualifying Income",null,"Total\nNo. of\nMonths"]
[null,null,null,null,"Subtotal","# mo.",null,"Subtotal","# mo."]
[null,"I","Schedule B",null,{"$f":"H12","v":0},12,null,{"$f":"K12","v":0},12,{"$f":"IFERROR((IF(F553=0,0,E553)+IF(I553=0,0,H553))/L553,0)","v":0},null,{"$f":"IF(ISNUMBER(F553),F553,0)+IF(ISNUMBER(I553),I553,0)","v":24}]
[null,"II",{"$f":"\"Schedule C   \"&D17","v":"Schedule C   "},null,{"$f":"H30","v":0},12,null,{"$f":"K30","v":0},12,0,null,24]
[null,"II",{"$f":"\"Schedule C   \"&D32","v":"Schedule C   "},null,{"$f":"H45","v":0},12,null,{"$f":"K45","v":0},12,0,null,24]
[null,"II",{"$f":"\"Schedule C   \"&D47","v":"Schedule C   "},null,{"$f":"H60","v":0},12,null,{"$f":"K60","v":0},12,0,null,24]
[null,"II",{"$f":"\"Schedule C   \"&D62","v":"Schedule C   "},null,{"$f":"H75","v":0},12,null,{"$f":"K75","v":0},12,0,null,24]
[null,"III","Schedule D",null,{"$f":"H82","v":0},12,null,{"$f":"K82","v":0},12,0,null,24]
[null,"IV","Schedule E",null,{"$f":"H91","v":0},12,null,{"$f":"K91","v":0},12,0,null,24]
[null,"V","Schedule F",null,{"$f":"H103","v":0},12,null,{"$f":"K103","v":0},12,0,null,24]
[null,"p.2","PARTNERSHIP & S CORPORATION CASH FLOW SUBTOTALS:"]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$108","v":"Schedule K-1   "},null,{"$f":"$H$116","v":0},12,null,{"$f":"$K$116","v":0},12,{"$f":"IFERROR((IF(F562=0,0,E562)+IF(I562=0,0,H562))/L562,0)","v":0},null,{"$f":"IF(ISNUMBER(F562),F562,0)+IF(ISNUMBER(I562),I562,0)","v":24}]
[null,"VII",{"$f":"\"Form 1065   \"&$E$108","v":"Form 1065   "},null,{"$f":"$H$133","v":0},12,null,{"$f":"$K$133","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$108&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F562>0,E562,0)+IF(F563>0,E563,0)","v":0},null,null,{"$f":"IF(I562>0,H562,0)+IF(I563>0,H563,0)","v":0},null,{"$f":"J562+J563","v":0}]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$136","v":"Schedule K-1   "},null,{"$f":"$H$144","v":0},12,null,{"$f":"$K$144","v":0},12,0,null,24]
[null,"VII",{"$f":"\"Form 1065   \"&$E$136","v":"Form 1065   "},null,{"$f":"$H$161","v":0},12,null,{"$f":"$K$161","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$136&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F565>0,E565,0)+IF(F566>0,E566,0)","v":0},null,null,{"$f":"IF(I565>0,H565,0)+IF(I566>0,H566,0)","v":0},null,{"$f":"J565+J566","v":0}]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$164","v":"Schedule K-1   "},null,{"$f":"$H$172","v":0},12,null,{"$f":"$K$172","v":0},12,0,null,24]
[null,"VII",{"$f":"\"Form 1065   \"&$E$164","v":"Form 1065   "},null,{"$f":"$H$189","v":0},12,null,{"$f":"$K$189","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$164&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F568>0,E568,0)+IF(F569>0,E569,0)","v":0},null,null,{"$f":"IF(I568>0,H568,0)+IF(I569>0,H569,0)","v":0},null,{"$f":"J568+J569","v":0}]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$192","v":"Schedule K-1   "},null,{"$f":"$H$200","v":0},12,null,{"$f":"$K$200","v":0},12,0,null,24]
[null,"VII",{"$f":"\"Form 1065   \"&$E$192","v":"Form 1065   "},null,{"$f":"$H$217","v":0},12,null,{"$f":"$K$217","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$192&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F571>0,E571,0)+IF(F572>0,E572,0)","v":0},null,null,{"$f":"IF(I571>0,H571,0)+IF(I572>0,H572,0)","v":0},null,{"$f":"J571+J572","v":0}]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$220","v":"Schedule K-1   "},null,{"$f":"$H$228","v":0},12,null,{"$f":"$K$228","v":0},12,{"$f":"IFERROR((IF(F574=0,0,E574)+IF(I574=0,0,H574))/L574,0)","v":0},null,{"$f":"IF(ISNUMBER(F574),F574,0)+IF(ISNUMBER(I574),I574,0)","v":24}]
[null,"VII",{"$f":"\"Form 1065   \"&$E$220","v":"Form 1065   "},null,{"$f":"$H$245","v":0},12,null,{"$f":"$K$245","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$220&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F574>0,E574,0)+IF(F575>0,E575,0)","v":0},null,null,{"$f":"IF(I574>0,H574,0)+IF(I575>0,H575,0)","v":0},null,{"$f":"J574+J575","v":0}]
[null,"VI",{"$f":"\"Schedule K-1   \"&$E$248","v":"Schedule K-1   "},null,{"$f":"$H$256","v":0},12,null,{"$f":"$K$256","v":0},12,0,null,24]
[null,"VII",{"$f":"\"Form 1065   \"&$E$248","v":"Form 1065   "},null,{"$f":"$H$273","v":0},12,null,{"$f":"$K$273","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$248&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F577>0,E577,0)+IF(F578>0,E578,0)","v":0},null,null,{"$f":"IF(I577>0,H577,0)+IF(I578>0,H578,0)","v":0},null,{"$f":"J577+J578","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$278","v":"Schedule K-1   "},null,{"$f":"$H$285","v":0},12,null,{"$f":"$K$285","v":0},12,{"$f":"IFERROR((IF(F580=0,0,E580)+IF(I580=0,0,H580))/L580,0)","v":0},null,{"$f":"IF(ISNUMBER(F580),F580,0)+IF(ISNUMBER(I580),I580,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$278","v":"W-2 Wages   "},null,{"$f":"$H$289","v":0},12,null,{"$f":"$K$289","v":0},12,{"$f":"IFERROR((IF(F581=0,0,E581)+IF(I581=0,0,H581))/L581,0)","v":0},null,{"$f":"IF(ISNUMBER(F581),F581,0)+IF(ISNUMBER(I581),I581,0)","v":24}]
[null,"X",{"$f":"\"Form 1120S   \"&$E$278","v":"Form 1120S   "},null,{"$f":"$H$305","v":0},12,null,{"$f":"$K$305","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$278&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F580>0,E580,0)+IF(F581>0,E581,0)+IF(F582>0,E582,0)","v":0},null,null,{"$f":"IF(I580>0,H580,0)+IF(I581>0,H581,0)+IF(I582>0,H582,0)","v":0},null,{"$f":"ROUND(J580,2)+ROUND(J581,2)+ROUND(J582,2)","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$308","v":"Schedule K-1   "},null,{"$f":"$H$315","v":0},12,null,{"$f":"$K$315","v":0},12,{"$f":"IFERROR((IF(F584=0,0,E584)+IF(I584=0,0,H584))/L584,0)","v":0},null,{"$f":"IF(ISNUMBER(F584),F584,0)+IF(ISNUMBER(I584),I584,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$308","v":"W-2 Wages   "},null,{"$f":"$H$319","v":0},12,null,{"$f":"$K$319","v":0},12,0,null,24]
[null,"X",{"$f":"\"Form 1120S   \"&$E$308","v":"Form 1120S   "},null,{"$f":"$H$335","v":0},12,null,{"$f":"$K$335","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$308&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F584>0,E584,0)+IF(F585>0,E585,0)+IF(F586>0,E586,0)","v":0},null,null,{"$f":"IF(I584>0,H584,0)+IF(I585>0,H585,0)+IF(I586>0,H586,0)","v":0},null,{"$f":"ROUND(J584,2)+ROUND(J585,2)+ROUND(J586,2)","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$338","v":"Schedule K-1   "},null,{"$f":"$H$345","v":0},12,null,{"$f":"$K$345","v":0},12,{"$f":"IFERROR((IF(F588=0,0,E588)+IF(I588=0,0,H588))/L588,0)","v":0},null,{"$f":"IF(ISNUMBER(F588),F588,0)+IF(ISNUMBER(I588),I588,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$338","v":"W-2 Wages   "},null,{"$f":"$H$349","v":0},12,null,{"$f":"$K$349","v":0},12,0,null,24]
[null,"X",{"$f":"\"Form 1120S   \"&$E$338","v":"Form 1120S   "},null,{"$f":"$H$365","v":0},12,null,{"$f":"$K$365","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$338&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F588>0,E588,0)+IF(F589>0,E589,0)+IF(F590>0,E590,0)","v":0},null,null,{"$f":"IF(I588>0,H588,0)+IF(I589>0,H589,0)+IF(I590>0,H590,0)","v":0},null,{"$f":"ROUND(J588,2)+ROUND(J589,2)+ROUND(J590,2)","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$368","v":"Schedule K-1   "},null,{"$f":"$H$375","v":0},12,null,{"$f":"$K$375","v":0},12,{"$f":"IFERROR((IF(F592=0,0,E592)+IF(I592=0,0,H592))/L592,0)","v":0},null,{"$f":"IF(ISNUMBER(F592),F592,0)+IF(ISNUMBER(I592),I592,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$368","v":"W-2 Wages   "},null,{"$f":"$H$379","v":0},12,null,{"$f":"$K$379","v":0},12,0,null,24]
[null,"X",{"$f":"\"Form 1120S   \"&$E$368","v":"Form 1120S   "},null,{"$f":"$H$395","v":0},12,null,{"$f":"$K$395","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$368&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F592>0,E592,0)+IF(F593>0,E593,0)+IF(F594>0,E594,0)","v":0},null,null,{"$f":"IF(I592>0,H592,0)+IF(I593>0,H593,0)+IF(I594>0,H594,0)","v":0},null,{"$f":"ROUND(J592,2)+ROUND(J593,2)+ROUND(J594,2)","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$398","v":"Schedule K-1   "},null,{"$f":"$H$405","v":0},12,null,{"$f":"$K$405","v":0},12,{"$f":"IFERROR((IF(F596=0,0,E596)+IF(I596=0,0,H596))/L596,0)","v":0},null,{"$f":"IF(ISNUMBER(F596),F596,0)+IF(ISNUMBER(I596),I596,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$398","v":"W-2 Wages   "},null,{"$f":"$H$409","v":0},12,null,{"$f":"$K$409","v":0},12,0,null,24]
[null,"X",{"$f":"\"Form 1120S   \"&$E$398","v":"Form 1120S   "},null,{"$f":"$H$425","v":0},12,null,{"$f":"$K$425","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$398&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F596>0,E596,0)+IF(F597>0,E597,0)+IF(F598>0,E598,0)","v":0},null,null,{"$f":"IF(I596>0,H596,0)+IF(I597>0,H597,0)+IF(I598>0,H598,0)","v":0},null,{"$f":"ROUND(J596,2)+ROUND(J597,2)+ROUND(J598,2)","v":0}]
[null,"VIII",{"$f":"\"Schedule K-1   \"&$E$428","v":"Schedule K-1   "},null,{"$f":"$H$435","v":0},12,null,{"$f":"$K$435","v":0},12,{"$f":"IFERROR((IF(F600=0,0,E600)+IF(I600=0,0,H600))/L600,0)","v":0},null,{"$f":"IF(ISNUMBER(F600),F600,0)+IF(ISNUMBER(I600),I600,0)","v":24}]
[null,"IX",{"$f":"\"W-2 Wages   \"&$E$428","v":"W-2 Wages   "},null,{"$f":"$H$439","v":0},12,null,{"$f":"$K$439","v":0},12,0,null,24]
[null,"X",{"$f":"\"Form 1120S   \"&$E$428","v":"Form 1120S   "},null,{"$f":"$H$455","v":0},12,null,{"$f":"$K$455","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$428&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F600>0,E600,0)+IF(F601>0,E601,0)+IF(F602>0,E602,0)","v":0},null,null,{"$f":"IF(I600>0,H600,0)+IF(I601>0,H601,0)+IF(I602>0,H602,0)","v":0},null,{"$f":"ROUND(J600,2)+ROUND(J601,2)+ROUND(J602,2)","v":0}]
[null,"p.3","CORPORATION CASH FLOW SUBTOTALS:"]
[null,"XI",{"$f":"\"W-2 Wages   \"&$E$460","v":"W-2 Wages   "},null,{"$f":"$H$464","v":0},12,null,{"$f":"$K$464","v":0},12,{"$f":"IFERROR((IF(F605=0,0,E605)+IF(I605=0,0,H605))/L605,0)","v":0},null,{"$f":"IF(ISNUMBER(F605),F605,0)+IF(ISNUMBER(I605),I605,0)","v":24}]
[null,"XII",{"$f":"\"Form 1120   \"&$E$460","v":"Form 1120   "},null,{"$f":"$H$485","v":0},12,null,{"$f":"$K$485","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$460&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F605>0,E605,0)+IF(F606>0,E606,0)","v":0},null,null,{"$f":"IF(I605>0,H605,0)+IF(I606>0,H606,0)","v":0},null,{"$f":"J605+J606","v":0}]
[null,"XI",{"$f":"\"W-2 Wages   \"&$E$488","v":"W-2 Wages   "},null,{"$f":"$H$492","v":0},12,null,{"$f":"$K$492","v":0},12,{"$f":"IFERROR((IF(F608=0,0,E608)+IF(I608=0,0,H608))/L608,0)","v":0},null,{"$f":"IF(ISNUMBER(F608),F608,0)+IF(ISNUMBER(I608),I608,0)","v":24}]
[null,"XII",{"$f":"\"Form 1120   \"&$E$488","v":"Form 1120   "},null,{"$f":"$H$513","v":0},12,null,{"$f":"$K$513","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$488&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F608>0,E608,0)+IF(F609>0,E609,0)","v":0},null,null,{"$f":"IF(I608>0,H608,0)+IF(I609>0,H609,0)","v":0},null,{"$f":"J608+J609","v":0}]
[null,"XI",{"$f":"\"W-2 Wages   \"&$E$516","v":"W-2 Wages   "},null,{"$f":"$H$520","v":0},12,null,{"$f":"$K$520","v":0},12,{"$f":"IFERROR((IF(F611=0,0,E611)+IF(I611=0,0,H611))/L611,0)","v":0},null,{"$f":"IF(ISNUMBER(F611),F611,0)+IF(ISNUMBER(I611),I611,0)","v":24}]
[null,"XII",{"$f":"\"Form 1120   \"&$E$516","v":"Form 1120   "},null,{"$f":"$H$541","v":0},12,null,{"$f":"$K$541","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$516&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F611>0,E611,0)+IF(F612>0,E612,0)","v":0},null,null,{"$f":"IF(I611>0,H611,0)+IF(I612>0,H612,0)","v":0},null,{"$f":"J611+J612","v":0}]
[null,null,"Average Monthly Cash Flow (Total)",null,null,null,null,null,null,{"$f":"SUMIF(I553:I613,\">=0\",J553:J613)","v":0}]
[]
[]
[null,null,"Comments / Notes"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]
[null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]

{"sheet":"LOOKUPS","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["VIRGIN_WBK","LKP_YEAR","MILEAGE_RATE","LKP_MONTHS","HAS_DATA_PROMPT","HAS_DATA_DEL",null,"SUMM_DATA_VALIDATION"]
[true,2016,0.24,0,true,true]
[null,2017,0.25,1]
[null,2018,0.25,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]

{"sheet":"_SUMM_ROWS_LKP_","index":2,"n_rows":63,"n_cols":11,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
["SUMM_ROW","DATA_ROW","L","TITLE","SECTION","iMyRefRow","iSummRefRow","strMyDataCols","iThisRow","strMyDataRows","strMyExtra"]
[551,false,"p.1","PERSONAL CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[{"$f":"A2+2","v":553},true,"IV","Schedule B",1,7,{"$f":"F3","v":7},"H,K","NONE","2,3","NONE"]
[{"$f":"A3+1","v":554},true,"V","Schedule C   ",1,15,{"$f":"F4+2","v":17},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[555,true,"V","Schedule C   ",2,15,{"$f":"F5+17","v":32},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[556,true,"V","Schedule C   ",3,15,{"$f":"F6+32","v":47},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[557,true,"V","Schedule C   ",4,15,{"$f":"F7+47","v":62},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[558,true,"VI","Schedule D",1,78,{"$f":"F8","v":78},"H,K","NONE",2,"NONE"]
[559,true,"VIII","Schedule E",1,85,{"$f":"F9","v":85},"H,K","NONE","2,3,4","NONE"]
[560,true,"IX","Schedule F",1,94,{"$f":"F10","v":94},"H,K","NONE","2,3,4,5,6,7","NONE"]
[561,false,"p.2","PARTNERSHIP & S CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[562,true,"X","K-1 (Form 1065)   ",1,108,{"$f":"F12","v":108},"H,K","NONE","4,5,6","E0"]
[563,true,"XI","Form 1065   ",1,108,{"$f":"F13","v":108},"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[564,true,"NA","Partnership Subtotal",1,108,108,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[565,true,"X","K-1 (Form 1065)   ",1,136,136,"H,K","NONE","4,5,6","E0"]
[566,true,"XI","Form 1065   ",1,136,136,"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[567,true,"NA","Partnership Subtotal",1,136,136,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[568,true,"X","K-1 (Form 1065)   ",1,164,164,"H,K","NONE","4,5,6","E0"]
[569,true,"XI","Form 1065   ",1,164,164,"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[570,true,"NA","Partnership Subtotal",1,164,164,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[571,true,"X","K-1 (Form 1065)   ",1,192,192,"H,K","NONE","4,5,6","E0"]
[572,true,"XI","Form 1065   ",1,192,192,"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[573,true,"NA","Partnership Subtotal",1,192,192,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[574,true,"X","K-1 (Form 1065)   ",1,220,220,"H,K","NONE","4,5,6","E0"]
[575,true,"XI","Form 1065   ",1,220,220,"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[576,true,"NA","Partnership Subtotal",1,220,220,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[577,true,"X","K-1 (Form 1065)   ",1,248,248,"H,K","NONE","4,5,6","E0"]
[578,true,"XI","Form 1065   ",1,248,248,"H,K","NONE","12,13,14,15,16,17,18,19,23","E0"]
[579,true,"NA","Partnership Subtotal",1,248,248,"H,K","NONE","4,5,6,12,13,14,15,16,17,18,19,23","NONE"]
[580,true,"X","K-1",1,278,278,"H,K","NONE","4,5","E0"]
[581,true,"XI","W2 Wages",1,278,278,"H,K","NONE",11,"E0"]
[582,true,"XI","Form 1120S",1,278,278,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[583,true,"NA","S Corporation Subtotal",1,278,278,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[584,true,"X","K-1",1,308,308,"H,K","NONE","4,5","E0"]
[585,true,"XI","W2 Wages",1,308,308,"H,K","NONE",11,"E0"]
[586,true,"XI","Form 1120S",1,308,308,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[587,true,"NA","S Corporation Subtotal",1,308,308,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[588,true,"X","K-1",1,338,338,"H,K","NONE","4,5","E0"]
[589,true,"XI","W2 Wages",1,338,338,"H,K","NONE",11,"E0"]
[590,true,"XI","Form 1120S",1,338,338,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[591,true,"NA","S Corporation Subtotal",1,338,338,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[592,true,"X","K-1",1,368,368,"H,K","NONE","4,5","E0"]
[593,true,"XI","W2 Wages",1,368,368,"H,K","NONE",11,"E0"]
[594,true,"XI","Form 1120S",1,368,368,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[595,true,"NA","S Corporation Subtotal",1,368,368,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[596,true,"X","K-1",1,398,398,"H,K","NONE","4,5","E0"]
[597,true,"XI","W2 Wages",1,398,398,"H,K","NONE",11,"E0"]
[598,true,"XI","Form 1120S",1,398,398,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[599,true,"NA","S Corporation Subtotal",1,398,398,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[600,true,"X","K-1",1,428,428,"H,K","NONE","4,5","E0"]
[601,true,"XI","W2 Wages",1,428,428,"H,K","NONE",11,"E0"]
[602,true,"XI","Form 1120S",1,428,428,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[603,true,"NA","S Corporation Subtotal",1,428,428,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[604,false,"p.3","CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[605,true,"XIV","W2 Wages",1,460,{"$f":"F55","v":460},"H,K","NONE",4,"E0"]
[606,true,"XIV","Form 1120S",1,460,{"$f":"F56","v":460},"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[607,true,"XIV","S Corporation Subtotal",1,460,460,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[608,true,"XIV","W2 Wages",1,488,488,"H,K","NONE",4,"E0"]
[609,true,"XIV","Form 1120S",1,488,488,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[610,true,"XIV","S Corporation Subtotal",1,488,488,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[611,true,"XIV","W2 Wages",1,516,516,"H,K","NONE",4,"E0"]
[612,true,"XIV","Form 1120S",1,516,516,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[613,true,"XIV","S Corporation Subtotal",1,516,516,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]

{"sheet":"_PROC_EXTRAS_LKP_","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["PROC_ADDR","PROC_FORMULA","TRUE_MSG"]
["H685","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
["K685","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
["H716","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
["K716","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
["H747","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
["K747","=IF(AND(ISNUMBER(_MY_VAL_),_MY_VAL_<>1,_MY_VAL_<>100),TRUE,FALSE)","For corporate earnings to be included in cash flow, investors generally require the borrower is a 100% owner."]
[]
[]
[]
[]
[null,{"$f":"IF(AND(ISNUMBER(A12),A12<>1,A12<>100),TRUE,FALSE)","v":false}]