{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["SAM","LOOKUPS","_SUMM_ROWS_LKP_","_PROC_EXTRAS_LKP_","_HYPER_LKP_NEW_"],"not_rendered":{"charts":0,"images":3,"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":"SAM","index":0,"n_rows":655,"n_cols":14,"rows_kept":655,"cut":false,"hidden":false,"merged":[[590,2,590,3],[590,9,590,10],[590,11,590,12],[466,2,466,6],[467,2,467,6],[468,2,468,6],[469,2,469,6],[470,2,470,6],[471,2,471,5],[472,2,472,5],[476,2,476,6],[515,2,515,3],[519,2,519,6],[520,2,520,5],[521,2,521,6],[522,2,522,6],[555,2,555,6],[550,2,550,6],[551,2,551,6],[552,2,552,6],[553,2,553,6],[497,2,497,6],[498,2,498,6],[499,2,499,6],[631,2,631,3],[631,9,631,10],[631,11,631,12],[632,2,632,3],[632,9,632,10],[632,11,632,12],[628,2,628,3],[628,9,628,10],[628,11,628,12],[629,2,629,3],[629,9,629,10],[629,11,629,12],[630,2,630,3],[630,9,630,10],[630,11,630,12],[626,2,626,3],[626,9,626,10],[626,11,626,12],[627,2,627,3],[627,9,627,10],[627,11,627,12],[610,2,610,3],[610,9,610,10],[610,11,610,12],[621,2,621,3],[621,9,621,10],[621,11,621,12],[622,2,622,3],[622,9,622,10],[622,11,622,12],[625,2,625,3],[625,9,625,10],[625,11,625,12],[623,2,623,3],[623,9,623,10],[623,11,623,12],[624,2,624,3],[624,9,624,10],[624,11,624,12],[616,2,616,3],[616,9,616,10],[616,11,616,12],[620,2,620,3],[620,9,620,10],[620,11,620,12],[617,2,617,3],[617,9,617,10],[617,11,617,12],[618,2,618,3],[618,9,618,10],[618,11,618,12],[619,2,619,3],[619,9,619,10],[619,11,619,12],[614,11,614,12],[615,2,615,3],[615,9,615,10],[615,11,615,12],[606,2,606,3],[606,9,606,10],[606,11,606,12],[601,2,601,3],[601,9,601,10],[601,11,601,12],[603,2,603,3],[603,9,603,10],[603,11,603,12],[605,2,605,3],[605,9,605,10],[605,11,605,12],[607,2,607,3],[607,9,607,10],[607,11,607,12],[608,2,608,3],[608,9,608,10],[612,11,612,12],[608,11,608,12],[612,2,612,3],[500,2,500,5],[501,2,501,5],[505,2,505,6],[506,2,506,5],[511,2,511,3],[511,4,511,6],[491,2,491,6],[492,2,492,5],[493,2,493,6],[494,2,494,6],[495,2,495,6],[496,2,496,6],[483,4,483,6],[483,2,483,3],[487,2,487,3],[456,2,456,6],[462,2,462,3],[421,2,421,3],[421,4,421,6],[425,2,425,6],[426,2,426,6],[432,2,432,3],[436,2,436,6],[437,2,437,6],[438,2,438,6],[439,2,439,6],[440,2,440,6],[441,2,441,5],[442,2,442,5],[446,2,446,6],[451,2,451,3],[451,4,451,6],[455,2,455,6],[402,2,402,3],[406,2,406,6],[407,2,407,6],[408,2,408,6],[409,2,409,6],[410,2,410,6],[411,2,411,5],[412,2,412,5],[416,2,416,6],[379,2,379,6],[380,2,380,6],[381,2,381,5],[382,2,382,5],[386,2,386,6],[391,2,391,3],[391,4,391,6],[395,2,395,6],[396,2,396,6],[356,2,356,6],[361,2,361,3],[361,4,361,6],[365,2,365,6],[366,2,366,6],[372,2,372,3],[376,2,376,6],[377,2,377,6],[378,2,378,6],[312,2,312,3],[342,2,342,3],[346,2,346,6],[347,2,347,6],[348,2,348,6],[349,2,349,6],[350,2,350,6],[351,2,351,5],[352,2,352,5],[321,2,321,5],[326,2,326,6],[331,2,331,3],[331,4,331,6],[335,2,335,6],[336,2,336,6],[316,2,316,6],[317,2,317,6],[318,2,318,6],[319,2,319,6],[320,2,320,6],[322,2,322,5],[289,2,289,5],[290,2,290,5],[294,2,294,6],[271,2,271,6],[272,2,272,6],[273,2,273,6],[283,2,283,6],[284,2,284,6],[285,2,285,6],[286,2,286,6],[287,2,287,6],[288,2,288,6],[279,2,279,3],[252,2,252,6],[253,2,253,6],[254,2,254,6],[255,2,255,6],[256,2,256,6],[257,2,257,5],[258,2,258,5],[262,2,262,6],[267,2,267,3],[267,4,267,6],[225,2,225,5],[226,2,226,5],[230,2,230,6],[235,2,235,3],[235,4,235,6],[239,2,239,6],[240,2,240,6],[241,2,241,6],[251,2,251,6],[247,2,247,3],[207,2,207,6],[208,2,208,6],[209,2,209,6],[219,2,219,6],[220,2,220,6],[221,2,221,6],[222,2,222,6],[223,2,223,6],[224,2,224,6],[215,2,215,3],[188,2,188,6],[189,2,189,6],[190,2,190,6],[191,2,191,6],[192,2,192,6],[193,2,193,5],[194,2,194,5],[198,2,198,6],[203,2,203,3],[203,4,203,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],[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],[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],[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],[183,2,183,3],[151,2,151,3],[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],[119,2,119,3],[123,2,123,6],[124,2,124,6],[125,2,125,6],[126,2,126,6],[127,2,127,6],[128,2,128,6],[129,2,129,5],[130,2,130,5],[134,2,134,6],[301,2,301,3],[301,4,301,6],[305,2,305,6],[306,2,306,6],[161,2,161,5],[162,2,162,5],[160,2,160,6],[139,2,139,3],[139,4,139,6],[143,2,143,6],[144,2,144,6],[145,2,145,6],[155,2,155,6],[156,2,156,6],[157,2,157,6],[158,2,158,6],[159,2,159,6],[166,2,166,6],[171,2,171,3],[171,4,171,6],[175,2,175,6],[176,2,176,6],[177,2,177,6],[187,2,187,6],[554,2,554,6],[524,2,524,6],[526,2,526,6],[527,2,527,6],[528,2,528,5],[525,2,525,6],[529,2,529,5],[523,2,523,6],[533,2,533,6],[534,2,534,5],[539,2,539,3],[539,4,539,6],[543,2,543,3],[547,2,547,6],[548,2,548,5],[549,2,549,6],[578,2,578,3],[578,9,578,10],[578,11,578,12],[576,2,576,3],[576,9,576,10],[576,11,576,12],[572,2,572,11],[574,11,575,12],[574,4,574,5],[574,7,574,8],[574,9,575,10],[556,2,556,5],[557,2,557,5],[561,2,561,6],[562,2,562,5],[574,1,574,3],[584,1,584,5],[582,2,582,3],[582,9,582,10],[582,11,582,12],[583,2,583,3],[583,9,583,10],[583,11,583,12],[579,2,579,3],[579,9,579,10],[579,11,579,12],[580,2,580,3],[580,9,580,10],[580,11,580,12],[581,2,581,3],[581,9,581,10],[581,11,581,12],[577,2,577,3],[577,9,577,10],[577,11,577,12],[585,2,585,3],[585,9,585,10],[585,11,585,12],[587,2,587,3],[587,9,587,10],[587,11,587,12],[589,2,589,3],[589,9,589,10],[589,11,589,12],[588,9,588,10],[588,11,588,12],[588,2,588,3],[586,2,586,3],[586,9,586,10],[586,11,586,12],[591,2,591,3],[591,9,591,10],[591,11,591,12],[593,2,593,3],[593,9,593,10],[593,11,593,12],[595,2,595,3],[595,9,595,10],[595,11,595,12],[592,2,592,3],[592,9,592,10],[592,11,592,12],[594,2,594,3],[594,9,594,10],[594,11,594,12],[640,9,640,10],[640,11,640,12],[641,2,641,3],[641,9,641,10],[641,11,641,12],[642,2,642,3],[642,9,642,10],[642,11,642,12],[634,2,634,3],[634,9,634,10],[634,11,634,12],[635,2,635,3],[638,2,638,3],[638,9,638,10],[638,11,638,12],[639,2,639,3],[639,9,639,10],[639,11,639,12],[640,2,640,3],[596,2,596,3],[596,9,596,10],[596,11,596,12],[600,2,600,3],[600,9,600,10],[600,11,600,12],[604,2,604,3],[604,9,604,10],[604,11,604,12],[597,2,597,3],[597,9,597,10],[597,11,597,12],[599,2,599,3],[599,9,599,10],[599,11,599,12],[598,2,598,3],[598,9,598,10],[598,11,598,12],[602,2,602,3],[602,9,602,10],[602,11,602,12],[612,9,612,10],[609,9,609,10],[609,11,609,12],[611,2,611,3],[611,9,611,10],[611,11,611,12],[609,2,609,3],[633,1,633,5],[647,2,654,11],[635,9,635,10],[635,11,635,12],[636,2,636,3],[636,9,636,10],[636,11,636,12],[613,2,613,3],[613,9,613,10],[613,11,613,12],[614,2,614,3],[614,9,614,10],[643,2,643,3],[643,9,643,10],[637,2,637,3],[637,9,637,10],[637,11,637,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:  ",2019,null,"YEAR 2:  ",2018]
[]
[null,"X","SCHEDULE B - INTEREST AND DIVIDENDS FROM SELF-EMPLOYMENT",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,1,"Recurring Interest Income: LINE 1 or 1040 LINE 2b (2019 and 2018), LINE 8a (2017)"]
[null,2,"Recurring Dividend Income: LINE 5 or 1040 LINE 3b (2019 and 2018), LINE 9a (2017)"]
[]
[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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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 2019: $0.26, 2018: $0.25, 2017: $0.25",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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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 2019: $0.26, 2018: $0.25, 2017: $0.25",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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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 2019: $0.26, 2018: $0.25, 2017: $0.25",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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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 2019: $0.26, 2018: $0.25, 2017: $0.25",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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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 business income as required by your investor."]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[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 W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H124:H129)-H130-H131,0)","v":0},null,null,{"$f":"IFERROR(SUM(K124:K129)-K130-K131,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H133*H135,0)","v":0},null,null,{"$f":"IFERROR(K133*K135,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H144:H146),0)","v":0},null,null,{"$f":"IFERROR(SUM(K144:K146),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H156:H161)-H162-H163,0)","v":0},null,null,{"$f":"IFERROR(SUM(K156:K161)-K162-K163,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H165*H167,0)","v":0},null,null,{"$f":"IFERROR(K165*K167,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H176:H178),0)","v":0},null,null,{"$f":"IFERROR(SUM(K176:K178),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H188:H193)-H194-H195,0)","v":0},null,null,{"$f":"IFERROR(SUM(K188:K193)-K194-K195,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H197*H199,0)","v":0},null,null,{"$f":"IFERROR(K197*K199,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H208:H210),0)","v":0},null,null,{"$f":"IFERROR(SUM(K208:K210),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H220:H225)-H226-H227,0)","v":0},null,null,{"$f":"IFERROR(SUM(K220:K225)-K226-K227,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H229*H231,0)","v":0},null,null,{"$f":"IFERROR(K229*K231,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H240:H242),0)","v":0},null,null,{"$f":"IFERROR(SUM(K240:K242),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H252:H257)-H258-H259,0)","v":0},null,null,{"$f":"IFERROR(SUM(K252:K257)-K258-K259,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H261*H263,0)","v":0},null,null,{"$f":"IFERROR(K261*K263,0)","v":0}]
[]
[]
[null,"X","PARTNERSHIP                                                                 Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[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: LINE 4c (2019), LINE 4 (2018 and 2017)"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H272:H274),0)","v":0},null,null,{"$f":"IFERROR(SUM(K272:K274),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,25,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1065"]
[]
[null,26,"Passthrough (Income) Loss from Other Partnerships: LINE 4 "]
[null,27,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7"]
[null,28,"Depreciation: LINE 16c"]
[null,29,"Depreciation (FORM 8825): LINE 14"]
[null,30,"Depletion: LINE 17"]
[null,31,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement"]
[null,32,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d",null,null,null,"(",null,")","(",null,")"]
[null,33,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H284:H289)-H290-H291,0)","v":0},null,null,{"$f":"IFERROR(SUM(K284:K289)-K290-K291,0)","v":0}]
[]
[null,34,"Multiplied by Ownership Percentage"]
[]
[null,null,"Partner's Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H293*H295,0)","v":0},null,null,{"$f":"IFERROR(K293*K295,0)","v":0}]
[]
[]
[null,null,"S Corporation Cash Flow"]
[null,null,"Evaluate business income as required by your investor."]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H306:H307),0)","v":0},null,null,{"$f":"IFERROR(SUM(K306:K307),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H317:H321)-H322-H323,0)","v":0},null,null,{"$f":"IFERROR(SUM(K317:K321)-K322-K323,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H325*H327,0)","v":0},null,null,{"$f":"IFERROR(K325*K327,0)","v":0}]
[]
[]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H336:H337),0)","v":0},null,null,{"$f":"IFERROR(SUM(K336:K337),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H347:H351)-H352-H353,0)","v":0},null,null,{"$f":"IFERROR(SUM(K347:K351)-K352-K353,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H355*H357,0)","v":0},null,null,{"$f":"IFERROR(K355*K357,0)","v":0}]
[]
[]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H366:H367),0)","v":0},null,null,{"$f":"IFERROR(SUM(K366:K367),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H377:H381)-H382-H383,0)","v":0},null,null,{"$f":"IFERROR(SUM(K377:K381)-K382-K383,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H385*H387,0)","v":0},null,null,{"$f":"IFERROR(K385*K387,0)","v":0}]
[]
[]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H396:H397),0)","v":0},null,null,{"$f":"IFERROR(SUM(K396:K397),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H407:H411)-H412-H413,0)","v":0},null,null,{"$f":"IFERROR(SUM(K407:K411)-K412-K413,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H415*H417,0)","v":0},null,null,{"$f":"IFERROR(K415*K417,0)","v":0}]
[]
[]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H426:H427),0)","v":0},null,null,{"$f":"IFERROR(SUM(K426:K427),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H437:H441)-H442-H443,0)","v":0},null,null,{"$f":"IFERROR(SUM(K437:K441)-K442-K443,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H445*H447,0)","v":0},null,null,{"$f":"IFERROR(K445*K447,0)","v":0}]
[]
[]
[null,"X","S CORPORATION                                                            Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"SCHEDULE K-1"]
[]
[null,35,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements."]
[null,36,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements."]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H456:H457),0)","v":0},null,null,{"$f":"IFERROR(SUM(K456:K457),0)","v":0}]
[]
[null,null,"FORM W-2"]
[]
[null,37,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120S"]
[]
[null,38,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5"]
[null,39,"Depreciation: LINE 14"]
[null,40,"Depreciation (FORM 8825): LINE 14"]
[null,41,"Depletion: LINE 15"]
[null,42,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement"]
[null,43,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,44,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H467:H471)-H472-H473,0)","v":0},null,null,{"$f":"IFERROR(SUM(K467:K471)-K472-K473,0)","v":0}]
[]
[null,45,"Multiplied by Ownership Percentage"]
[]
[null,null,"Shareholder’s Total Share of Income (Loss)",null,null,null,null,{"$f":"IFERROR(H475*H477,0)","v":0},null,null,{"$f":"IFERROR(K475*K477,0)","v":0}]
[]
[]
[null,null,"Corporation Cash Flow"]
[null,null,"Evaluate business income as required by your investor."]
[null,"X","CORPORATION                                                               Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"FORM W-2"]
[]
[null,46,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,47,"Taxable Income: LINE 30"]
[null,48,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,49,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,50,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,51,"Depreciation: LINE 20"]
[null,52,"Depletion: LINE 21"]
[null,53,"Domestic Production Activities Deduction: LINE 25 (2017)"]
[null,54,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,55,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,56,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,57,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H494:H500)+H492-H493-H501-H502,0)","v":0},null,null,{"$f":"IFERROR(SUM(K494:K500)+K492-K493-K501-K502,0)","v":0}]
[]
[null,58,"Multiplied by Ownership Percentage"]
[null,59,"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((H504*H506)-H507,0)","v":0},null,null,{"$f":"IFERROR((K504*K506)-K507,0)","v":0}]
[]
[]
[null,"X","CORPORATION                                                               Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"FORM W-2"]
[]
[null,46,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,47,"Taxable Income: LINE 30"]
[null,48,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,49,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,50,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,51,"Depreciation: LINE 20"]
[null,52,"Depletion: LINE 21"]
[null,53,"Domestic Production Activities Deduction: LINE 25 (2017)"]
[null,54,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,55,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,56,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,57,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H522:H528)+H520-H521-H529-H530,0)","v":0},null,null,{"$f":"IFERROR(SUM(K522:K528)+K520-K521-K529-K530,0)","v":0}]
[]
[null,58,"Multiplied by Ownership Percentage"]
[null,59,"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((H532*H534)-H535,0)","v":0},null,null,{"$f":"IFERROR((K532*K534)-K535,0)","v":0}]
[]
[]
[null,"X","CORPORATION                                                               Name:",null,null,null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018}]
[]
[null,null,"FORM W-2"]
[]
[null,46,"Wages: W-2, Box 5 (in general)"]
[]
[null,null,"FORM 1120"]
[]
[null,47,"Taxable Income: LINE 30"]
[null,48,"Total Tax: LINE 31",null,null,null,"(",null,")","(",null,")"]
[null,49,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9"]
[null,50,"Deduct nonrecurring income/add nonrecurring loss: LINE 10"]
[null,51,"Depreciation: LINE 20"]
[null,52,"Depletion: LINE 21"]
[null,53,"Domestic Production Activities Deduction: LINE 25 (2017)"]
[null,54,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule"]
[null,55,"Net Operating Loss and Special Deductions: LINES 29a & b"]
[null,56,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d",null,null,null,"(",null,")","(",null,")"]
[null,57,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c",null,null,null,"(",null,")","(",null,")"]
[]
[null,null,"SUBTOTAL",null,null,null,null,{"$f":"IFERROR(SUM(H550:H556)+H548-H549-H557-H558,0)","v":0},null,null,{"$f":"IFERROR(SUM(K550:K556)+K548-K549-K557-K558,0)","v":0}]
[]
[null,58,"Multiplied by Ownership Percentage"]
[null,59,"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((H560*H562)-H563,0)","v":0},null,null,{"$f":"IFERROR((K560*K562)-K563,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,"PERSONAL CASH FLOW SUBTOTALS:",null,null,{"$f":"IF(ISNUMBER($H$5),$H$5,\"\")","v":2019},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":2018},null,"Qualifying Income",null,"Total\nNo. of\nMonths"]
[null,null,null,null,"Subtotal","# mo.",null,"Subtotal","# mo."]
[null,null,"Schedule B",null,{"$f":"H12","v":0},12,null,{"$f":"K12","v":0},12,{"$f":"IFERROR((IF(F577=0,0,E577)+IF(I577=0,0,H577))/L577,0)","v":0},null,{"$f":"IF(ISNUMBER(F577),F577,0)+IF(ISNUMBER(I577),I577,0)","v":24}]
[null,null,{"$f":"\"Schedule C   \"&D17","v":"Schedule C   "},null,{"$f":"H30","v":0},12,null,{"$f":"K30","v":0},12,0,null,24]
[null,null,{"$f":"\"Schedule C   \"&D32","v":"Schedule C   "},null,{"$f":"H45","v":0},12,null,{"$f":"K45","v":0},12,0,null,24]
[null,null,{"$f":"\"Schedule C   \"&D47","v":"Schedule C   "},null,{"$f":"H60","v":0},12,null,{"$f":"K60","v":0},12,0,null,24]
[null,null,{"$f":"\"Schedule C   \"&D62","v":"Schedule C   "},null,{"$f":"H75","v":0},12,null,{"$f":"K75","v":0},12,0,null,24]
[null,null,"Schedule D",null,{"$f":"H82","v":0},12,null,{"$f":"K82","v":0},12,0,null,24]
[null,null,"Schedule E",null,{"$f":"H91","v":0},12,null,{"$f":"K91","v":0},12,0,null,24]
[null,null,"Schedule F",null,{"$f":"H103","v":0},12,null,{"$f":"K103","v":0},12,0,null,24]
[null,"PARTNERSHIP & S CORPORATION CASH FLOW SUBTOTALS:"]
[null,null,{"$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(F586=0,0,E586)+IF(I586=0,0,H586))/L586,0)","v":0},null,{"$f":"IF(ISNUMBER(F586),F586,0)+IF(ISNUMBER(I586),I586,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$108","v":"W-2 Wages   "},null,{"$f":"$H$120","v":0},12,null,{"$f":"$K$120","v":0},12,{"$f":"IFERROR((IF(F587=0,0,E587)+IF(I587=0,0,H587))/L587,0)","v":0},null,{"$f":"IF(ISNUMBER(F587),F587,0)+IF(ISNUMBER(I587),I587,0)","v":24}]
[null,null,{"$f":"\"Form 1065   \"&$E$108","v":"Form 1065   "},null,{"$f":"$H$137","v":0},12,null,{"$f":"$K$137","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$108&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F586>0,E586,0)+IF(F587>0,E587,0)+IF(F588>0,E588,0)","v":0},null,null,{"$f":"IF(I586>0,H586,0)+IF(I587>0,H587,0)+IF(I588>0,H588,0)","v":0},null,{"$f":"J586+J587+J588","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$140","v":"Schedule K-1   "},null,{"$f":"$H$148","v":0},12,null,{"$f":"$K$148","v":0},12,0,null,24]
[null,null,{"$f":"\"W-2 Wages   \"&$E$140","v":"W-2 Wages   "},null,{"$f":"$H$152","v":0},12,null,{"$f":"$K$152","v":0},12,{"$f":"IFERROR((IF(F591=0,0,E591)+IF(I591=0,0,H591))/L591,0)","v":0},null,{"$f":"IF(ISNUMBER(F591),F591,0)+IF(ISNUMBER(I591),I591,0)","v":24}]
[null,null,{"$f":"\"Form 1065   \"&$E$140","v":"Form 1065   "},null,{"$f":"$H$169","v":0},12,null,{"$f":"$K$169","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$140&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F590>0,E590,0)+IF(F591>0,E591,0)+IF(F592>0,E592,0)","v":0},null,null,{"$f":"IF(I590>0,H590,0)+IF(I591>0,H591,0)+IF(I592>0,H592,0)","v":0},null,{"$f":"J590+J591+J592","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$172","v":"Schedule K-1   "},null,{"$f":"$H$180","v":0},12,null,{"$f":"$K$180","v":0},12,0,null,24]
[null,null,{"$f":"\"W-2 Wages   \"&$E$172","v":"W-2 Wages   "},null,{"$f":"$H$184","v":0},8,null,{"$f":"$K$184","v":0},12,{"$f":"IFERROR((IF(F595=0,0,E595)+IF(I595=0,0,H595))/L595,0)","v":0},null,{"$f":"IF(ISNUMBER(F595),F595,0)+IF(ISNUMBER(I595),I595,0)","v":20}]
[null,null,{"$f":"\"Form 1065   \"&$E$172","v":"Form 1065   "},null,{"$f":"$H$201","v":0},12,null,{"$f":"$K$201","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$172&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F594>0,E594,0)+IF(F595>0,E595,0)+IF(F596>0,E596,0)","v":0},null,null,{"$f":"IF(I594>0,H594,0)+IF(I595>0,H595,0)+IF(I596>0,H596,0)","v":0},null,{"$f":"J594+J595+J596","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$204","v":"Schedule K-1   "},null,{"$f":"$H$212","v":0},12,null,{"$f":"$K$212","v":0},12,0,null,24]
[null,null,{"$f":"\"W-2 Wages   \"&$E$204","v":"W-2 Wages   "},null,{"$f":"$H$216","v":0},12,null,{"$f":"$K$216","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1065   \"&$E$204","v":"Form 1065   "},null,{"$f":"$H$233","v":0},12,null,{"$f":"$K$233","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$204&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F598>0,E598,0)+IF(F599>0,E599,0)+IF(F600>0,E600,0)","v":0},null,null,{"$f":"IF(I598>0,H598,0)+IF(I599>0,H599,0)+IF(I600>0,H600,0)","v":0},null,{"$f":"J598+J599+J600","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$236","v":"Schedule K-1   "},null,{"$f":"$H$244","v":0},12,null,{"$f":"$K$244","v":0},12,{"$f":"IFERROR((IF(F602=0,0,E602)+IF(I602=0,0,H602))/L602,0)","v":0},null,{"$f":"IF(ISNUMBER(F602),F602,0)+IF(ISNUMBER(I602),I602,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$236","v":"W-2 Wages   "},null,{"$f":"$H$248","v":0},12,null,{"$f":"$K$248","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1065   \"&$E$236","v":"Form 1065   "},null,{"$f":"$H$265","v":0},12,null,{"$f":"$K$265","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$236&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F602>0,E602,0)+IF(F603>0,E603,0)+IF(F604>0,E604,0)","v":0},null,null,{"$f":"IF(I602>0,H602,0)+IF(I603>0,H603,0)+IF(I604>0,H604,0)","v":0},null,{"$f":"J602+J603+J604","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$268","v":"Schedule K-1   "},null,{"$f":"$H$276","v":0},12,null,{"$f":"$K$276","v":0},12,0,null,24]
[null,null,{"$f":"\"W-2 Wages   \"&$E$268","v":"W-2 Wages   "},null,{"$f":"$H$280","v":0},12,null,{"$f":"$K$280","v":0},12,{"$f":"IFERROR((IF(F607=0,0,E607)+IF(I607=0,0,H607))/L607,0)","v":0},null,{"$f":"IF(ISNUMBER(F607),F607,0)+IF(ISNUMBER(I607),I607,0)","v":24}]
[null,null,{"$f":"\"Form 1065   \"&$E$268","v":"Form 1065   "},null,{"$f":"$H$297","v":0},12,null,{"$f":"$K$297","v":0},12,0,null,24]
[null,null,{"$f":"\"Partnership  \"&$E$268&\"  Subtotal\"","v":"Partnership    Subtotal"},null,{"$f":"IF(F606>0,E606,0)+IF(F607>0,E607,0)+IF(F608>0,E608,0)","v":0},null,null,{"$f":"IF(I606>0,H606,0)+IF(I607>0,H607,0)+IF(I608>0,H608,0)","v":0},null,{"$f":"J606+J607+J608","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$302","v":"Schedule K-1   "},null,{"$f":"$H$309","v":0},12,null,{"$f":"$K$309","v":0},12,{"$f":"IFERROR((IF(F610=0,0,E610)+IF(I610=0,0,H610))/L610,0)","v":0},null,{"$f":"IF(ISNUMBER(F610),F610,0)+IF(ISNUMBER(I610),I610,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$302","v":"W-2 Wages   "},null,{"$f":"$H$313","v":0},12,null,{"$f":"$K$313","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,null,{"$f":"\"Form 1120S   \"&$E$302","v":"Form 1120S   "},null,{"$f":"$H$329","v":0},12,null,{"$f":"$K$329","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$302&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F610>0,E610,0)+IF(F611>0,E611,0)+IF(F612>0,E612,0)","v":0},null,null,{"$f":"IF(I610>0,H610,0)+IF(I611>0,H611,0)+IF(I612>0,H612,0)","v":0},null,{"$f":"ROUND(J610,2)+ROUND(J611,2)+ROUND(J612,2)","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$332","v":"Schedule K-1   "},null,{"$f":"$H$339","v":0},12,null,{"$f":"$K$339","v":0},12,{"$f":"IFERROR((IF(F614=0,0,E614)+IF(I614=0,0,H614))/L614,0)","v":0},null,{"$f":"IF(ISNUMBER(F614),F614,0)+IF(ISNUMBER(I614),I614,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$332","v":"W-2 Wages   "},null,{"$f":"$H$343","v":0},12,null,{"$f":"$K$343","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1120S   \"&$E$332","v":"Form 1120S   "},null,{"$f":"$H$359","v":0},12,null,{"$f":"$K$359","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$332&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F614>0,E614,0)+IF(F615>0,E615,0)+IF(F616>0,E616,0)","v":0},null,null,{"$f":"IF(I614>0,H614,0)+IF(I615>0,H615,0)+IF(I616>0,H616,0)","v":0},null,{"$f":"ROUND(J614,2)+ROUND(J615,2)+ROUND(J616,2)","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$362","v":"Schedule K-1   "},null,{"$f":"$H$369","v":0},12,null,{"$f":"$K$369","v":0},12,{"$f":"IFERROR((IF(F618=0,0,E618)+IF(I618=0,0,H618))/L618,0)","v":0},null,{"$f":"IF(ISNUMBER(F618),F618,0)+IF(ISNUMBER(I618),I618,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$362","v":"W-2 Wages   "},null,{"$f":"$H$373","v":0},12,null,{"$f":"$K$373","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1120S   \"&$E$362","v":"Form 1120S   "},null,{"$f":"$H$389","v":0},12,null,{"$f":"$K$389","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$362&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F618>0,E618,0)+IF(F619>0,E619,0)+IF(F620>0,E620,0)","v":0},null,null,{"$f":"IF(I618>0,H618,0)+IF(I619>0,H619,0)+IF(I620>0,H620,0)","v":0},null,{"$f":"ROUND(J618,2)+ROUND(J619,2)+ROUND(J620,2)","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$392","v":"Schedule K-1   "},null,{"$f":"$H$399","v":0},12,null,{"$f":"$K$399","v":0},12,{"$f":"IFERROR((IF(F622=0,0,E622)+IF(I622=0,0,H622))/L622,0)","v":0},null,{"$f":"IF(ISNUMBER(F622),F622,0)+IF(ISNUMBER(I622),I622,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$392","v":"W-2 Wages   "},null,{"$f":"$H$403","v":0},12,null,{"$f":"$K$403","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1120S   \"&$E$392","v":"Form 1120S   "},null,{"$f":"$H$419","v":0},12,null,{"$f":"$K$419","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$392&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F622>0,E622,0)+IF(F623>0,E623,0)+IF(F624>0,E624,0)","v":0},null,null,{"$f":"IF(I622>0,H622,0)+IF(I623>0,H623,0)+IF(I624>0,H624,0)","v":0},null,{"$f":"ROUND(J622,2)+ROUND(J623,2)+ROUND(J624,2)","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$422","v":"Schedule K-1   "},null,{"$f":"$H$429","v":0},12,null,{"$f":"$K$429","v":0},12,{"$f":"IFERROR((IF(F626=0,0,E626)+IF(I626=0,0,H626))/L626,0)","v":0},null,{"$f":"IF(ISNUMBER(F626),F626,0)+IF(ISNUMBER(I626),I626,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$422","v":"W-2 Wages   "},null,{"$f":"$H$433","v":0},12,null,{"$f":"$K$433","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1120S   \"&$E$422","v":"Form 1120S   "},null,{"$f":"$H$449","v":0},12,null,{"$f":"$K$449","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$422&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F626>0,E626,0)+IF(F627>0,E627,0)+IF(F628>0,E628,0)","v":0},null,null,{"$f":"IF(I626>0,H626,0)+IF(I627>0,H627,0)+IF(I628>0,H628,0)","v":0},null,{"$f":"ROUND(J626,2)+ROUND(J627,2)+ROUND(J628,2)","v":0}]
[null,null,{"$f":"\"Schedule K-1   \"&$E$452","v":"Schedule K-1   "},null,{"$f":"$H$459","v":0},12,null,{"$f":"$K$459","v":0},12,{"$f":"IFERROR((IF(F630=0,0,E630)+IF(I630=0,0,H630))/L630,0)","v":0},null,{"$f":"IF(ISNUMBER(F630),F630,0)+IF(ISNUMBER(I630),I630,0)","v":24}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$452","v":"W-2 Wages   "},null,{"$f":"$H$463","v":0},12,null,{"$f":"$K$463","v":0},12,0,null,24]
[null,null,{"$f":"\"Form 1120S   \"&$E$452","v":"Form 1120S   "},null,{"$f":"$H$479","v":0},12,null,{"$f":"$K$479","v":0},12,0,null,24]
[null,null,{"$f":"\"S Corporation  \"&$E$452&\"  Subtotal\"","v":"S Corporation    Subtotal"},null,{"$f":"IF(F630>0,E630,0)+IF(F631>0,E631,0)+IF(F632>0,E632,0)","v":0},null,null,{"$f":"IF(I630>0,H630,0)+IF(I631>0,H631,0)+IF(I632>0,H632,0)","v":0},null,{"$f":"ROUND(J630,2)+ROUND(J631,2)+ROUND(J632,2)","v":0}]
[null,"CORPORATION CASH FLOW SUBTOTALS:"]
[null,null,{"$f":"\"W-2 Wages   \"&$E$484","v":"W-2 Wages   "},null,{"$f":"$H$488","v":0},12,null,{"$f":"$K$488","v":0},12,{"$f":"IFERROR((IF(F635=0,0,E635)+IF(I635=0,0,H635))/L635,0)","v":0},null,{"$f":"IF(ISNUMBER(F635),F635,0)+IF(ISNUMBER(I635),I635,0)","v":24}]
[null,null,{"$f":"\"Form 1120   \"&$E$484","v":"Form 1120   "},null,{"$f":"$H$509","v":0},12,null,{"$f":"$K$509","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$484&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F635>0,E635,0)+IF(F636>0,E636,0)","v":0},null,null,{"$f":"IF(I635>0,H635,0)+IF(I636>0,H636,0)","v":0},null,{"$f":"J635+J636","v":0}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$512","v":"W-2 Wages   "},null,{"$f":"$H$516","v":0},12,null,{"$f":"$K$516","v":0},7,{"$f":"IFERROR((IF(F638=0,0,E638)+IF(I638=0,0,H638))/L638,0)","v":0},null,{"$f":"IF(ISNUMBER(F638),F638,0)+IF(ISNUMBER(I638),I638,0)","v":19}]
[null,null,{"$f":"\"Form 1120   \"&$E$512","v":"Form 1120   "},null,{"$f":"$H$537","v":0},12,null,{"$f":"$K$537","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$512&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F638>0,E638,0)+IF(F639>0,E639,0)","v":0},null,null,{"$f":"IF(I638>0,H638,0)+IF(I639>0,H639,0)","v":0},null,{"$f":"J638+J639","v":0}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$540","v":"W-2 Wages   "},null,{"$f":"$H$544","v":0},12,null,{"$f":"$K$544","v":0},12,{"$f":"IFERROR((IF(F641=0,0,E641)+IF(I641=0,0,H641))/L641,0)","v":0},null,{"$f":"IF(ISNUMBER(F641),F641,0)+IF(ISNUMBER(I641),I641,0)","v":24}]
[null,null,{"$f":"\"Form 1120   \"&$E$540","v":"Form 1120   "},null,{"$f":"$H$565","v":0},12,null,{"$f":"$K$565","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$540&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F641>0,E641,0)+IF(F642>0,E642,0)","v":0},null,null,{"$f":"IF(I641>0,H641,0)+IF(I642>0,H642,0)","v":0},null,{"$f":"J641+J642","v":0}]
[null,null,"Average Monthly Cash Flow (Total)",null,null,null,null,null,null,{"$f":"SUMIF(I577:I643,\">=0\",J577:J643)","v":0}]
[]
[]
[null,null,"Comments / Notes  (For a new line, hold Alt and press Enter)"]
[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,2017,0.25,0,true,true]
[null,2018,0.25,1]
[null,2019,0.26,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":69,"n_cols":11,"rows_kept":69,"cut":false,"hidden":true,"merged":[]}
["SUMM_ROW","DATA_ROW","L","TITLE","SECTION","iMyRefRow","iSummRefRow","strMyDataCols","iThisRow","strMyDataRows","strMyExtra"]
[575,false,"p.1","PERSONAL CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[{"$f":"A2+2","v":577},true,"IV","Schedule B",1,7,{"$f":"F3","v":7},"H,K","NONE","2,3","NONE"]
[{"$f":"A3+1","v":578},true,"V","Schedule C   ",1,15,{"$f":"F4+2","v":17},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[579,true,"V","Schedule C   ",2,15,{"$f":"F5+17","v":32},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[580,true,"V","Schedule C   ",3,15,{"$f":"F6+32","v":47},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[581,true,"V","Schedule C   ",4,15,{"$f":"F7+47","v":62},"H,K","NONE","2,3,4,5,6,7,8,11","D0"]
[582,true,"VI","Schedule D",1,78,{"$f":"F8","v":78},"H,K","NONE",2,"NONE"]
[583,true,"VIII","Schedule E",1,85,{"$f":"F9","v":85},"H,K","NONE","2,3,4","NONE"]
[584,true,"IX","Schedule F",1,94,{"$f":"F10","v":94},"H,K","NONE","2,3,4,5,6,7","NONE"]
[585,false,"p.2","PARTNERSHIP & S CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[586,true,"X","K-1 (Form 1065)   ",1,108,{"$f":"F12","v":108},"H,K","NONE","4,5,6","E0"]
[587,true,"X","W-2 Wages",1,108,108,"H,K","NONE",12,"E0"]
[588,true,"XI","Form 1065   ",1,108,{"$f":"F14","v":108},"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[589,true,"NA","Partnership Subtotal",1,108,108,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[590,true,"X","K-1 (Form 1065)   ",1,140,140,"H,K","NONE","4,5,6","E0"]
[591,true,"X","W-2 Wages",1,140,140,"H,K","NONE",12,"E0"]
[592,true,"XI","Form 1065   ",1,140,140,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[593,true,"NA","Partnership Subtotal",1,140,140,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[594,true,"X","K-1 (Form 1065)   ",1,172,172,"H,K","NONE","4,5,6","E0"]
[595,true,"X","W-2 Wages",1,172,172,"H,K","NONE",12,"E0"]
[596,true,"XI","Form 1065   ",1,172,172,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[597,true,"NA","Partnership Subtotal",1,172,172,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[598,true,"X","K-1 (Form 1065)   ",1,204,204,"H,K","NONE","4,5,6","E0"]
[599,true,"X","W-2 Wages",1,204,204,"H,K","NONE",12,"E0"]
[600,true,"XI","Form 1065   ",1,204,204,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[601,true,"NA","Partnership Subtotal",1,204,204,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[602,true,"X","K-1 (Form 1065)   ",1,236,236,"H,K","NONE","4,5,6","E0"]
[603,true,"X","W-2 Wages",1,236,236,"H,K","NONE",12,"E0"]
[604,true,"XI","Form 1065   ",1,236,236,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[605,true,"NA","Partnership Subtotal",1,236,236,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[606,true,"X","K-1 (Form 1065)   ",1,268,268,"H,K","NONE","4,5,6","E0"]
[607,true,"X","W-2 Wages",1,268,268,"H,K","NONE",12,"E0"]
[608,true,"XI","Form 1065   ",1,268,268,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0"]
[609,true,"NA","Partnership Subtotal",1,268,268,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE"]
[610,true,"X","K-1",1,302,302,"H,K","NONE","4,5","E0"]
[611,true,"XI","W2 Wages",1,302,302,"H,K","NONE",11,"E0"]
[612,true,"XI","Form 1120S",1,302,302,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[613,true,"NA","S Corporation Subtotal",1,302,302,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[614,true,"X","K-1",1,332,332,"H,K","NONE","4,5","E0"]
[615,true,"XI","W2 Wages",1,332,332,"H,K","NONE",11,"E0"]
[616,true,"XI","Form 1120S",1,332,332,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[617,true,"NA","S Corporation Subtotal",1,332,332,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[618,true,"X","K-1",1,362,362,"H,K","NONE","4,5","E0"]
[619,true,"XI","W2 Wages",1,362,362,"H,K","NONE",11,"E0"]
[620,true,"XI","Form 1120S",1,362,362,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[621,true,"NA","S Corporation Subtotal",1,362,362,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[622,true,"X","K-1",1,392,392,"H,K","NONE","4,5","E0"]
[623,true,"XI","W2 Wages",1,392,392,"H,K","NONE",11,"E0"]
[624,true,"XI","Form 1120S",1,392,392,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[625,true,"NA","S Corporation Subtotal",1,392,392,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[626,true,"X","K-1",1,422,422,"H,K","NONE","4,5","E0"]
[627,true,"XI","W2 Wages",1,422,422,"H,K","NONE",11,"E0"]
[628,true,"XI","Form 1120S",1,422,422,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[629,true,"NA","S Corporation Subtotal",1,422,422,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[630,true,"X","K-1",1,452,452,"H,K","NONE","4,5","E0"]
[631,true,"XI","W2 Wages",1,452,452,"H,K","NONE",11,"E0"]
[632,true,"XI","Form 1120S",1,452,452,"H,K","NONE","15,16,17,18,19,20,21,25","E0"]
[633,true,"NA","S Corporation Subtotal",1,452,452,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0"]
[634,false,"p.3","CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA"]
[635,true,"XIV","W2 Wages",1,484,{"$f":"F61","v":484},"H,K","NONE",4,"E0"]
[636,true,"XIV","Form 1120S",1,484,{"$f":"F62","v":484},"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[637,true,"XIV","S Corporation Subtotal",1,484,484,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[638,true,"XIV","W2 Wages",1,512,512,"H,K","NONE",4,"E0"]
[639,true,"XIV","Form 1120S",1,512,512,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[640,true,"XIV","S Corporation Subtotal",1,512,512,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[641,true,"XIV","W2 Wages",1,540,540,"H,K","NONE",4,"E0"]
[642,true,"XIV","Form 1120S",1,540,540,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,18,22,23","E0"]
[643,true,"XIV","S Corporation Subtotal",1,540,540,"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}]

{"sheet":"_HYPER_LKP_NEW_","index":4,"n_rows":58,"n_cols":10,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["NUM","SECTION","COL_REF","ROW_NUM","LINE_TEXT","PAGE_LINK","BASE_PATH","FILE_NAME","ADDTL","EXAMPLE_URL"]
[1,"Schedule B","B",1,"Recurring Interest Income","#page21","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2019.pdf"]
[2,null,"B",2,"Recurring Dividend Income","#page21","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=21&view=fit"]
[3,"Schedule C","B",3,"Net Profit","#page23","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[4,null,"B",4,"Deduct nonrecurring income","#page23","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[5,null,"B",5,"Depletion","#page25","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[6,null,"B",6,"Depreciation","#page25","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[7,null,"B",7,"Meals or Meals and Entertainment","#page25","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[8,null,"B",8,"Business Use of Home","#page25","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[9,null,"B",9,"Business Miles","#page27","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[10,null,"B","10a","x Depreciation Rate","#page27","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[11,null,"B","10b","Total Mileage Depreciation","#page27","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[12,null,"B",11,"Amortization/Casualty Loss","#page27","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[13,"Schedule D","B",12,"Recurring Capital Gains (Loss)","#page33","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[14,"Schedule E","B",13,"Royalty Income (Loss)","#page37","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[15,null,"B",14,"Total Expenses","#page37","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[16,null,"B",15,"Depletion","#page37","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[17,"Schedule F","B",16,"Net Profit (Loss)","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[18,null,"B",17,"Non-Tax Portion","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[19,null,"B",18,"Deduct nonrecurring income","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[20,null,"B",19,"Depreciation","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[21,null,"B",20,"Amortization/Casualty Loss","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[22,null,"B",21,"Business Use of Home","#page45","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[23,"Partnership","B",22,"Ordinary Income (Loss)","#page55","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[24,null,"B",23,"Net Rental Income (Loss)","#page55","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[25,null,"B",24,"Guaranteed Payments","#page55","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[26,null,"B",25,"Wages","#page13","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[27,null,"B",26,"Passthrough","#page59","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[28,null,"B",27,"Deduct nonrecurring income","#page59","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[29,null,"B",28,"Depreciation: LINE 16c ","#page59","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[30,null,"B",29,"Depreciation (Form 8825)","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[31,null,"B",30,"Depletion","#page59","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[32,null,"B",31,"Amortization/Casualty Loss","#page59","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[33,null,"B",32,"Mortgages or Notes Payable","#page63","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[34,null,"B",33,"Travel and Entertainment","#page63","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[35,"S Corporation","B",35,"Ordinary Income (Loss)","#page65","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[36,null,"B",36,"Net Rental Income (Loss)","#page67","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[37,null,"B",37,"Wages","#page13","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[38,null,"B",38,"Deduct nonrecurring income","#page69","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[39,null,"B",39,"Depreciation: LINE 14","#page69","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[40,null,"B",40,"Depreciation (FORM 8825): LINE 14","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[41,null,"B",41,"Depletion","#page69","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[42,null,"B",42,"Amortization/Casualty Loss","#page69","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[43,null,"B",43,"Mortgages or Notes Payable","#page73","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[44,null,"B",44,"Travel and Entertainment","#page75","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[45,"Corporation","B",46,"Wages","#page13","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[46,null,"B",47,"Taxable Income","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[47,null,"B",48,"Total Tax","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[48,null,"B",49,"Deduct nonrecurring income","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[49,null,"B",50,"Deduct nonrecurring income","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[50,null,"B",51,"Depreciation ","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[51,null,"B",52,"Depletion","#page79","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[52,null,"B",53,"Domestic Production Activities","#page81","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[53,null,"B",54,"Amortization/Casualty Loss","#page81","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[54,null,"B",55,"Net Operating Loss and Special Deductions","#page81","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[55,null,"B",56,"Mortgages or Notes Payable","#page85","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[56,null,"B",57,"Travel and Entertainment","#page85","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[57,null,"B",59,"Dividends Paid to Borrower","#page85","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]