{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["SAM","P&L Statement","_SUMM_ROWS_LKP_YTD_","_SUMM_ROWS_LKP_","_HYPER_LKP_NEW_","__NOTES__","LOOKUPS","SANDBOX","_PROC_EXTRAS_LKP_"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":5,"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":652,"n_cols":14,"rows_kept":652,"cut":false,"hidden":false,"merged":[[587,2,587,3],[587,9,587,10],[587,11,587,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],[514,2,514,3],[518,2,518,6],[519,2,519,5],[520,2,520,6],[521,2,521,6],[552,2,552,6],[548,2,548,6],[549,2,549,6],[550,2,550,6],[497,2,497,6],[498,2,498,6],[499,2,499,5],[500,2,500,5],[628,2,628,3],[628,9,628,10],[628,11,628,12],[629,2,629,3],[629,9,629,10],[629,11,629,12],[625,2,625,3],[625,9,625,10],[625,11,625,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],[623,2,623,3],[623,9,623,10],[623,11,623,12],[624,2,624,3],[624,9,624,10],[624,11,624,12],[607,2,607,3],[607,9,607,10],[607,11,607,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],[622,2,622,3],[622,9,622,10],[622,11,622,12],[620,2,620,3],[620,9,620,10],[620,11,620,12],[621,2,621,3],[621,9,621,10],[621,11,621,12],[614,2,614,3],[614,9,614,10],[614,11,614,12],[615,2,615,3],[615,9,615,10],[615,11,615,12],[616,2,616,3],[616,9,616,10],[616,11,616,12],[604,2,604,3],[604,9,604,10],[604,11,604,12],[605,2,605,3],[605,9,605,10],[609,11,609,12],[605,11,605,12],[609,2,609,3],[613,2,613,3],[613,9,613,10],[613,11,613,12],[603,2,603,3],[603,9,603,10],[603,11,603,12],[598,2,598,3],[598,9,598,10],[598,11,598,12],[600,2,600,3],[600,9,600,10],[600,11,600,12],[602,2,602,3],[602,9,602,10],[602,11,602,12],[504,2,504,6],[505,2,505,5],[510,2,510,3],[510,4,510,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],[551,2,551,6],[523,2,523,6],[524,2,524,6],[525,2,525,6],[526,2,526,5],[527,2,527,5],[522,2,522,6],[531,2,531,6],[532,2,532,5],[537,2,537,3],[537,4,537,6],[541,2,541,3],[545,2,545,6],[546,2,546,5],[547,2,547,6],[575,2,575,3],[575,9,575,10],[575,11,575,12],[573,2,573,3],[573,9,573,10],[573,11,573,12],[569,2,569,11],[571,11,572,12],[571,4,571,5],[571,7,571,8],[571,9,572,10],[553,2,553,5],[554,2,554,5],[558,2,558,6],[559,2,559,5],[571,1,571,3],[581,1,581,5],[579,2,579,3],[579,9,579,10],[579,11,579,12],[580,2,580,3],[580,9,580,10],[580,11,580,12],[576,2,576,3],[576,9,576,10],[576,11,576,12],[577,2,577,3],[577,9,577,10],[577,11,577,12],[578,2,578,3],[578,9,578,10],[578,11,578,12],[574,2,574,3],[574,9,574,10],[574,11,574,12],[582,2,582,3],[582,9,582,10],[582,11,582,12],[584,2,584,3],[584,9,584,10],[584,11,584,12],[586,2,586,3],[586,9,586,10],[586,11,586,12],[585,9,585,10],[585,11,585,12],[585,2,585,3],[583,2,583,3],[583,9,583,10],[583,11,583,12],[588,2,588,3],[588,9,588,10],[588,11,588,12],[590,2,590,3],[590,9,590,10],[590,11,590,12],[592,2,592,3],[592,9,592,10],[592,11,592,12],[589,2,589,3],[589,9,589,10],[589,11,589,12],[591,2,591,3],[591,9,591,10],[591,11,591,12],[595,2,595,3],[595,9,595,10],[595,11,595,12],[599,2,599,3],[599,9,599,10],[599,11,599,12],[637,9,637,10],[637,11,637,12],[638,2,638,3],[638,9,638,10],[638,11,638,12],[631,2,631,3],[631,9,631,10],[631,11,631,12],[632,2,632,3],[635,2,635,3],[635,9,635,10],[635,11,635,12],[636,2,636,3],[636,9,636,10],[636,11,636,12],[637,2,637,3],[611,11,611,12],[612,2,612,3],[644,2,651,11],[632,9,632,10],[632,11,632,12],[633,2,633,3],[633,9,633,10],[633,11,633,12],[610,2,610,3],[610,9,610,10],[610,11,610,12],[611,2,611,3],[611,9,611,10],[640,2,640,3],[640,9,640,10],[634,2,634,3],[634,9,634,10],[634,11,634,12],[639,2,639,3],[639,9,639,10],[639,11,639,12],[612,9,612,10],[612,11,612,12],[617,2,617,3],[617,9,617,10],[617,11,617,12],[1,2,1,10],[609,9,609,10],[606,9,606,10],[606,11,606,12],[608,2,608,3],[608,9,608,10],[608,11,608,12],[606,2,606,3],[630,1,630,5],[593,2,593,3],[593,9,593,10],[593,11,593,12],[597,2,597,3],[597,9,597,10],[597,11,597,12],[601,2,601,3],[601,9,601,10],[601,11,601,12],[594,2,594,3],[594,9,594,10],[594,11,594,12],[596,2,596,3],[596,9,596,10],[596,11,596,12]]}
[null," SAM Cash Flow Analysis Worksheet with P&L"]
[null,null,"User Tips:\n    • Add borrower information in blue-shaded fields\n    • Select the tax year(s) being reviewed\n    • Click the \"O\" button to expand income source section\n    • Use Summary section to analyze income trends\n    • Click the tax form line (shown in green) to access the searchable SEB manual\n    • Select the Reset Workbook button on top to clear all information"]
[null,null,"BORROWER NAME:",null,null,null,null,null,null,"DATE:  "]
[]
[null,null,null,null,null,"Select the Year(s):"]
[]
[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"]
[null,2,"Recurring Dividend Income: LINE 5 or 1040 LINE 3b"]
[]
[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 2022: $0.26, 2021: $0.26, 2020: $0.27",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 2022: $0.26, 2021: $0.26, 2020: $0.27",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 2022: $0.26, 2021: $0.26, 2020: $0.27",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 2022: $0.26, 2021: $0.26, 2020: $0.27",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,"Depreciation Expense or 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 business income as required by your investor."]
[null,"X","PARTNERSHIP                                                                 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: LINE 4c"]
[]
[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":""},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: LINE 4c"]
[]
[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":""},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: LINE 4c"]
[]
[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":""},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: LINE 4c"]
[]
[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":""},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: LINE 4c"]
[]
[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":""},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: LINE 4c"]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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":""},null,null,{"$f":"IF(ISNUMBER($K$5),$K$5,\"\")","v":""}]
[]
[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,"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(H494:H499)+H492-H493-H500-H501,0)","v":0},null,null,{"$f":"IFERROR(SUM(K494:K499)+K492-K493-K500-K501,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((H503*H505)-H506,0)","v":0},null,null,{"$f":"IFERROR((K503*K505)-K506,0)","v":0}]
[]
[]
[null,"X","CORPORATION                                                               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,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,"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(H521:H526)+H519-H520-H527-H528,0)","v":0},null,null,{"$f":"IFERROR(SUM(K521:K526)+K519-K520-K527-K528,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((H530*H532)-H533,0)","v":0},null,null,{"$f":"IFERROR((K530*K532)-K533,0)","v":0}]
[]
[]
[null,"X","CORPORATION                                                               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,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,"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(H548:H553)+H546-H547-H554-H555,0)","v":0},null,null,{"$f":"IFERROR(SUM(K548:K553)+K546-K547-K554-K555,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((H557*H559)-H560,0)","v":0},null,null,{"$f":"IFERROR((K557*K559)-K560,0)","v":0}]
[]
[]
[null,null,"Cash Flow Analysis Summary"]
[]
[]
[]
[]
[null,null,"• To modify the Total No. of Months select the applicable number from the # mo. drop-down box. \n• 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":""},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,null,"Schedule B",null,{"$f":"H12","v":0},12,null,{"$f":"K12","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,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(F583=0,0,E583)+IF(I583=0,0,H583))/L583,0)","v":0},null,{"$f":"IF(ISNUMBER(F583),F583,0)+IF(ISNUMBER(I583),I583,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(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,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(F583>0,E583,0)+IF(F584>0,E584,0)+IF(F585>0,E585,0)","v":0},null,null,{"$f":"IF(I583>0,H583,0)+IF(I584>0,H584,0)+IF(I585>0,H585,0)","v":0},null,{"$f":"J583+J584+J585","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(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,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(F587>0,E587,0)+IF(F588>0,E588,0)+IF(F589>0,E589,0)","v":0},null,null,{"$f":"IF(I587>0,H587,0)+IF(I588>0,H588,0)+IF(I589>0,H589,0)","v":0},null,{"$f":"J587+J588+J589","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},12,null,{"$f":"$K$184","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,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(F591>0,E591,0)+IF(F592>0,E592,0)+IF(F593>0,E593,0)","v":0},null,null,{"$f":"IF(I591>0,H591,0)+IF(I592>0,H592,0)+IF(I593>0,H593,0)","v":0},null,{"$f":"J591+J592+J593","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(F595>0,E595,0)+IF(F596>0,E596,0)+IF(F597>0,E597,0)","v":0},null,null,{"$f":"IF(I595>0,H595,0)+IF(I596>0,H596,0)+IF(I597>0,H597,0)","v":0},null,{"$f":"J595+J596+J597","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(F599=0,0,E599)+IF(I599=0,0,H599))/L599,0)","v":0},null,{"$f":"IF(ISNUMBER(F599),F599,0)+IF(ISNUMBER(I599),I599,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(F599>0,E599,0)+IF(F600>0,E600,0)+IF(F601>0,E601,0)","v":0},null,null,{"$f":"IF(I599>0,H599,0)+IF(I600>0,H600,0)+IF(I601>0,H601,0)","v":0},null,{"$f":"J599+J600+J601","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(F604=0,0,E604)+IF(I604=0,0,H604))/L604,0)","v":0},null,{"$f":"IF(ISNUMBER(F604),F604,0)+IF(ISNUMBER(I604),I604,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(F603>0,E603,0)+IF(F604>0,E604,0)+IF(F605>0,E605,0)","v":0},null,null,{"$f":"IF(I603>0,H603,0)+IF(I604>0,H604,0)+IF(I605>0,H605,0)","v":0},null,{"$f":"J603+J604+J605","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(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":"\"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(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,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(F607>0,E607,0)+IF(F608>0,E608,0)+IF(F609>0,E609,0)","v":0},null,null,{"$f":"IF(I607>0,H607,0)+IF(I608>0,H608,0)+IF(I609>0,H609,0)","v":0},null,{"$f":"ROUND(J607,2)+ROUND(J608,2)+ROUND(J609,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(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":"\"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(F611>0,E611,0)+IF(F612>0,E612,0)+IF(F613>0,E613,0)","v":0},null,null,{"$f":"IF(I611>0,H611,0)+IF(I612>0,H612,0)+IF(I613>0,H613,0)","v":0},null,{"$f":"ROUND(J611,2)+ROUND(J612,2)+ROUND(J613,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(F615=0,0,E615)+IF(I615=0,0,H615))/L615,0)","v":0},null,{"$f":"IF(ISNUMBER(F615),F615,0)+IF(ISNUMBER(I615),I615,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(F615>0,E615,0)+IF(F616>0,E616,0)+IF(F617>0,E617,0)","v":0},null,null,{"$f":"IF(I615>0,H615,0)+IF(I616>0,H616,0)+IF(I617>0,H617,0)","v":0},null,{"$f":"ROUND(J615,2)+ROUND(J616,2)+ROUND(J617,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(F619=0,0,E619)+IF(I619=0,0,H619))/L619,0)","v":0},null,{"$f":"IF(ISNUMBER(F619),F619,0)+IF(ISNUMBER(I619),I619,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(F619>0,E619,0)+IF(F620>0,E620,0)+IF(F621>0,E621,0)","v":0},null,null,{"$f":"IF(I619>0,H619,0)+IF(I620>0,H620,0)+IF(I621>0,H621,0)","v":0},null,{"$f":"ROUND(J619,2)+ROUND(J620,2)+ROUND(J621,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(F623=0,0,E623)+IF(I623=0,0,H623))/L623,0)","v":0},null,{"$f":"IF(ISNUMBER(F623),F623,0)+IF(ISNUMBER(I623),I623,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(F623>0,E623,0)+IF(F624>0,E624,0)+IF(F625>0,E625,0)","v":0},null,null,{"$f":"IF(I623>0,H623,0)+IF(I624>0,H624,0)+IF(I625>0,H625,0)","v":0},null,{"$f":"ROUND(J623,2)+ROUND(J624,2)+ROUND(J625,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(F627=0,0,E627)+IF(I627=0,0,H627))/L627,0)","v":0},null,{"$f":"IF(ISNUMBER(F627),F627,0)+IF(ISNUMBER(I627),I627,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(F627>0,E627,0)+IF(F628>0,E628,0)+IF(F629>0,E629,0)","v":0},null,null,{"$f":"IF(I627>0,H627,0)+IF(I628>0,H628,0)+IF(I629>0,H629,0)","v":0},null,{"$f":"ROUND(J627,2)+ROUND(J628,2)+ROUND(J629,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(F632=0,0,E632)+IF(I632=0,0,H632))/L632,0)","v":0},null,{"$f":"IF(ISNUMBER(F632),F632,0)+IF(ISNUMBER(I632),I632,0)","v":24}]
[null,null,{"$f":"\"Form 1120   \"&$E$484","v":"Form 1120   "},null,{"$f":"$H$508","v":0},12,null,{"$f":"$K$508","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$484&\"  Subtotal\"","v":"Corporation    Subtotal"},null,{"$f":"IF(F632>0,E632,0)+IF(F633>0,E633,0)","v":0},null,null,{"$f":"IF(I632>0,H632,0)+IF(I633>0,H633,0)","v":0},null,{"$f":"J632+J633","v":0}]
[null,null,{"$f":"\"W-2 Wages   \"&$E$511","v":"W-2 Wages   "},null,{"$f":"$H$515","v":0},12,null,{"$f":"$K$515","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$511","v":"Form 1120   "},null,{"$f":"$H$535","v":0},12,null,{"$f":"$K$535","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$511&\"  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$538","v":"W-2 Wages   "},null,{"$f":"$H$542","v":0},12,null,{"$f":"$K$542","v":0},12,{"$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":24}]
[null,null,{"$f":"\"Form 1120   \"&$E$538","v":"Form 1120   "},null,{"$f":"$H$562","v":0},12,null,{"$f":"$K$562","v":0},12,0,null,24]
[null,null,{"$f":"\"Corporation  \"&$E$538&\"  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,"Average Monthly Cash Flow (Total)",null,null,null,null,null,null,{"$f":"SUMIF(I574:I640,\">=0\",J574:J640)","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":"P&L Statement","index":1,"n_rows":482,"n_cols":26,"rows_kept":482,"cut":false,"hidden":false,"merged":[[110,6,110,11],[6,6,6,11],[25,6,25,11],[44,6,44,11],[63,6,63,11],[84,6,84,11],[1,2,1,10],[474,2,481,23],[136,6,136,11],[162,6,162,11],[188,6,188,11],[214,6,214,11],[317,6,317,11],[342,6,342,11],[367,6,367,11],[394,6,394,11],[420,6,420,11],[446,6,446,11],[2,7,2,21],[242,6,242,11],[267,6,267,11],[292,6,292,11]]}
[null,"Profit and Loss Statement Analysis"]
[null,null,"User Tips:\n    • Add borrower information in blue-shaded fields\n    • Click the \"O\" button to expand income source section\n    • Click \"+\" to add additional columns within business section\n    • Select the Reset Workbook button on top to clear all information"]
[null,null,null,"BORROWER NAME:"]
[]
[null,"Sole Proprietorship Cash Flow"]
[null,null,"Use of this information is discretionary.  FOLLOW INVESTOR GUIDELINES."]
[null,"X","SOLE PROPRIETORSHIP",null,null,null,{"$f":"IF(OR(SAM!D17=0,SAM!D17=\"\"),\"\",SAM!D17)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Profit (Loss):",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W11)=MONTH(W12),((YEAR(W12)-YEAR(W11))*12)-12+(12-MONTH(W11))+MONTH(W12)-1+(EOMONTH(W11,0)-W11+1)/DAY(EOMONTH(W11,0))+(1-(EOMONTH(W12,0)-W12)/DAY(EOMONTH(W12,0))),((YEAR(W12)-YEAR(W11))*12)-12+(12-MONTH(W11))+MONTH(W12)-1+(EOMONTH(W11,0)-W11+1)/DAY(EOMONTH(W11,0))+(1-(EOMONTH(W12,0)-W12)/DAY(EOMONTH(W12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W11<>\"\",W12<>\"\"),IF(E16<=1,1,E16),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(T11)=MONTH(T12),((YEAR(T12)-YEAR(T11))*12)-12+(12-MONTH(T11))+MONTH(T12)-1+(EOMONTH(T11,0)-T11+1)/DAY(EOMONTH(T11,0))+(1-(EOMONTH(T12,0)-T12)/DAY(EOMONTH(T12,0))),((YEAR(T12)-YEAR(T11))*12)-12+(12-MONTH(T11))+MONTH(T12)-1+(EOMONTH(T11,0)-T11+1)/DAY(EOMONTH(T11,0))+(1-(EOMONTH(T12,0)-T12)/DAY(EOMONTH(T12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T11<>\"\",T12<>\"\"),IF(E17<=1,1,E17),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(Q11)=MONTH(Q12),((YEAR(Q12)-YEAR(Q11))*12)-12+(12-MONTH(Q11))+MONTH(Q12)-1+(EOMONTH(Q11,0)-Q11+1)/DAY(EOMONTH(Q11,0))+(1-(EOMONTH(Q12,0)-Q12)/DAY(EOMONTH(Q12,0))),((YEAR(Q12)-YEAR(Q11))*12)-12+(12-MONTH(Q11))+MONTH(Q12)-1+(EOMONTH(Q11,0)-Q11+1)/DAY(EOMONTH(Q11,0))+(1-(EOMONTH(Q12,0)-Q12)/DAY(EOMONTH(Q12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q11<>\"\",Q12<>\"\"),IF(E18<=1,1,E18),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N11)=MONTH(N12),((YEAR(N12)-YEAR(N11))*12)-12+(12-MONTH(N11))+MONTH(N12)-1+(EOMONTH(N11,0)-N11+1)/DAY(EOMONTH(N11,0))+(1-(EOMONTH(N12,0)-N12)/DAY(EOMONTH(N12,0))),((YEAR(N12)-YEAR(N11))*12)-12+(12-MONTH(N11))+MONTH(N12)-1+(EOMONTH(N11,0)-N11+1)/DAY(EOMONTH(N11,0))+(1-(EOMONTH(N12,0)-N12)/DAY(EOMONTH(N12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N11<>\"\",N12<>\"\"),IF(E19<=1,1,E19),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K11)=MONTH(K12),((YEAR(K12)-YEAR(K11))*12)-12+(12-MONTH(K11))+MONTH(K12)-1+(EOMONTH(K11,0)-K11+1)/DAY(EOMONTH(K11,0))+(1-(EOMONTH(K12,0)-K12)/DAY(EOMONTH(K12,0))),((YEAR(K12)-YEAR(K11))*12)-12+(12-MONTH(K11))+MONTH(K12)-1+(EOMONTH(K11,0)-K11+1)/DAY(EOMONTH(K11,0))+(1-(EOMONTH(K12,0)-K12)/DAY(EOMONTH(K12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K11<>\"\",K12<>\"\"),IF(E20<=1,1,E20),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(SUM(H16:H20)-H15+H14,0)","v":0},null,null,{"$f":"IFERROR(SUM(K16:K20)-K15+K14,0)","v":0},null,null,{"$f":"IFERROR(SUM(N16:N20)-N15+N14,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q16:Q20)-Q15+Q14,0)","v":0},null,null,{"$f":"IFERROR(SUM(T16:T20)-T15+T14,0)","v":0},null,null,{"$f":"IFERROR(SUM(W16:W20)-W15+W14,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H11)=MONTH(H12),((YEAR(H12)-YEAR(H11))*12)-12+(12-MONTH(H11))+MONTH(H12)-1+(EOMONTH(H11,0)-H11+1)/DAY(EOMONTH(H11,0))+(1-(EOMONTH(H12,0)-H12)/DAY(EOMONTH(H12,0))),((YEAR(H12)-YEAR(H11))*12)-12+(12-MONTH(H11))+MONTH(H12)-1+(EOMONTH(H11,0)-H11+1)/DAY(EOMONTH(H11,0))+(1-(EOMONTH(H12,0)-H12)/DAY(EOMONTH(H12,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H11<>\"\",H12<>\"\"),IF(E23<=1,1,E23),0),2)","v":0},null,{"$f":"IFERROR(H22/F23,0)","v":0},null,null,{"$f":"IFERROR(K22/F20,0)","v":0},null,null,{"$f":"IFERROR(N22/F19,0)","v":0},null,null,{"$f":"IFERROR(Q22/F18,0)","v":0},null,null,{"$f":"IFERROR(T22/F17,0)","v":0},null,null,{"$f":"IFERROR(W22/F16,0)","v":0}]
[]
[]
[null,"X","SOLE PROPRIETORSHIP",null,null,null,{"$f":"IF(OR(SAM!D32=0,SAM!D32=\"\"),\"\",SAM!D32)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Profit (Loss):",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W30)=MONTH(W31),((YEAR(W31)-YEAR(W30))*12)-12+(12-MONTH(W30))+MONTH(W31)-1+(EOMONTH(W30,0)-W30+1)/DAY(EOMONTH(W30,0))+(1-(EOMONTH(W31,0)-W31)/DAY(EOMONTH(W31,0))),((YEAR(W31)-YEAR(W30))*12)-12+(12-MONTH(W30))+MONTH(W31)-1+(EOMONTH(W30,0)-W30+1)/DAY(EOMONTH(W30,0))+(1-(EOMONTH(W31,0)-W31)/DAY(EOMONTH(W31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W30<>\"\",W31<>\"\"),IF(E35<=1,1,E35),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(T30)=MONTH(T31),((YEAR(T31)-YEAR(T30))*12)-12+(12-MONTH(T30))+MONTH(T31)-1+(EOMONTH(T30,0)-T30+1)/DAY(EOMONTH(T30,0))+(1-(EOMONTH(T31,0)-T31)/DAY(EOMONTH(T31,0))),((YEAR(T31)-YEAR(T30))*12)-12+(12-MONTH(T30))+MONTH(T31)-1+(EOMONTH(T30,0)-T30+1)/DAY(EOMONTH(T30,0))+(1-(EOMONTH(T31,0)-T31)/DAY(EOMONTH(T31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T30<>\"\",T31<>\"\"),IF(E36<=1,1,E36),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(Q30)=MONTH(Q31),((YEAR(Q31)-YEAR(Q30))*12)-12+(12-MONTH(Q30))+MONTH(Q31)-1+(EOMONTH(Q30,0)-Q30+1)/DAY(EOMONTH(Q30,0))+(1-(EOMONTH(Q31,0)-Q31)/DAY(EOMONTH(Q31,0))),((YEAR(Q31)-YEAR(Q30))*12)-12+(12-MONTH(Q30))+MONTH(Q31)-1+(EOMONTH(Q30,0)-Q30+1)/DAY(EOMONTH(Q30,0))+(1-(EOMONTH(Q31,0)-Q31)/DAY(EOMONTH(Q31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q30<>\"\",Q31<>\"\"),IF(E37<=1,1,E37),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N30)=MONTH(N31),((YEAR(N31)-YEAR(N30))*12)-12+(12-MONTH(N30))+MONTH(N31)-1+(EOMONTH(N30,0)-N30+1)/DAY(EOMONTH(N30,0))+(1-(EOMONTH(N31,0)-N31)/DAY(EOMONTH(N31,0))),((YEAR(N31)-YEAR(N30))*12)-12+(12-MONTH(N30))+MONTH(N31)-1+(EOMONTH(N30,0)-N30+1)/DAY(EOMONTH(N30,0))+(1-(EOMONTH(N31,0)-N31)/DAY(EOMONTH(N31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N30<>\"\",N31<>\"\"),IF(E38<=1,1,E38),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K30)=MONTH(K31),((YEAR(K31)-YEAR(K30))*12)-12+(12-MONTH(K30))+MONTH(K31)-1+(EOMONTH(K30,0)-K30+1)/DAY(EOMONTH(K30,0))+(1-(EOMONTH(K31,0)-K31)/DAY(EOMONTH(K31,0))),((YEAR(K31)-YEAR(K30))*12)-12+(12-MONTH(K30))+MONTH(K31)-1+(EOMONTH(K30,0)-K30+1)/DAY(EOMONTH(K30,0))+(1-(EOMONTH(K31,0)-K31)/DAY(EOMONTH(K31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K30<>\"\",K31<>\"\"),IF(E39<=1,1,E39),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(SUM(H35:H39)-H34+H33,0)","v":0},null,null,{"$f":"IFERROR(SUM(K35:K39)-K34+K33,0)","v":0},null,null,{"$f":"IFERROR(SUM(N35:N39)-N34+N33,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q35:Q39)-Q34+Q33,0)","v":0},null,null,{"$f":"IFERROR(SUM(T35:T39)-T34+T33,0)","v":0},null,null,{"$f":"IFERROR(SUM(W35:W39)-W34+W33,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H30)=MONTH(H31),((YEAR(H31)-YEAR(H30))*12)-12+(12-MONTH(H30))+MONTH(H31)-1+(EOMONTH(H30,0)-H30+1)/DAY(EOMONTH(H30,0))+(1-(EOMONTH(H31,0)-H31)/DAY(EOMONTH(H31,0))),((YEAR(H31)-YEAR(H30))*12)-12+(12-MONTH(H30))+MONTH(H31)-1+(EOMONTH(H30,0)-H30+1)/DAY(EOMONTH(H30,0))+(1-(EOMONTH(H31,0)-H31)/DAY(EOMONTH(H31,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H30<>\"\",H31<>\"\"),IF(E42<=1,1,E42),0),2)","v":0},null,{"$f":"IFERROR(H41/F42,0)","v":0},null,null,{"$f":"IFERROR(K41/F39,0)","v":0},null,null,{"$f":"IFERROR(N41/F38,0)","v":0},null,null,{"$f":"IFERROR(Q41/F37,0)","v":0},null,null,{"$f":"IFERROR(T41/F36,0)","v":0},null,null,{"$f":"IFERROR(W41/F35,0)","v":0}]
[]
[]
[null,"X","SOLE PROPRIETORSHIP",null,null,null,{"$f":"IF(OR(SAM!D47=0,SAM!D47=\"\"),\"\",SAM!D47)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Profit (Loss):",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W49)=MONTH(W50),((YEAR(W50)-YEAR(W49))*12)-12+(12-MONTH(W49))+MONTH(W50)-1+(EOMONTH(W49,0)-W49+1)/DAY(EOMONTH(W49,0))+(1-(EOMONTH(W50,0)-W50)/DAY(EOMONTH(W50,0))),((YEAR(W50)-YEAR(W49))*12)-12+(12-MONTH(W49))+MONTH(W50)-1+(EOMONTH(W49,0)-W49+1)/DAY(EOMONTH(W49,0))+(1-(EOMONTH(W50,0)-W50)/DAY(EOMONTH(W50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W49<>\"\",W50<>\"\"),IF(E54<=1,1,E54),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(T49)=MONTH(T50),((YEAR(T50)-YEAR(T49))*12)-12+(12-MONTH(T49))+MONTH(T50)-1+(EOMONTH(T49,0)-T49+1)/DAY(EOMONTH(T49,0))+(1-(EOMONTH(T50,0)-T50)/DAY(EOMONTH(T50,0))),((YEAR(T50)-YEAR(T49))*12)-12+(12-MONTH(T49))+MONTH(T50)-1+(EOMONTH(T49,0)-T49+1)/DAY(EOMONTH(T49,0))+(1-(EOMONTH(T50,0)-T50)/DAY(EOMONTH(T50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T49<>\"\",T50<>\"\"),IF(E55<=1,1,E55),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(Q49)=MONTH(Q50),((YEAR(Q50)-YEAR(Q49))*12)-12+(12-MONTH(Q49))+MONTH(Q50)-1+(EOMONTH(Q49,0)-Q49+1)/DAY(EOMONTH(Q49,0))+(1-(EOMONTH(Q50,0)-Q50)/DAY(EOMONTH(Q50,0))),((YEAR(Q50)-YEAR(Q49))*12)-12+(12-MONTH(Q49))+MONTH(Q50)-1+(EOMONTH(Q49,0)-Q49+1)/DAY(EOMONTH(Q49,0))+(1-(EOMONTH(Q50,0)-Q50)/DAY(EOMONTH(Q50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q49<>\"\",Q50<>\"\"),IF(E56<=1,1,E56),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N49)=MONTH(N50),((YEAR(N50)-YEAR(N49))*12)-12+(12-MONTH(N49))+MONTH(N50)-1+(EOMONTH(N49,0)-N49+1)/DAY(EOMONTH(N49,0))+(1-(EOMONTH(N50,0)-N50)/DAY(EOMONTH(N50,0))),((YEAR(N50)-YEAR(N49))*12)-12+(12-MONTH(N49))+MONTH(N50)-1+(EOMONTH(N49,0)-N49+1)/DAY(EOMONTH(N49,0))+(1-(EOMONTH(N50,0)-N50)/DAY(EOMONTH(N50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N49<>\"\",N50<>\"\"),IF(E57<=1,1,E57),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K49)=MONTH(K50),((YEAR(K50)-YEAR(K49))*12)-12+(12-MONTH(K49))+MONTH(K50)-1+(EOMONTH(K49,0)-K49+1)/DAY(EOMONTH(K49,0))+(1-(EOMONTH(K50,0)-K50)/DAY(EOMONTH(K50,0))),((YEAR(K50)-YEAR(K49))*12)-12+(12-MONTH(K49))+MONTH(K50)-1+(EOMONTH(K49,0)-K49+1)/DAY(EOMONTH(K49,0))+(1-(EOMONTH(K50,0)-K50)/DAY(EOMONTH(K50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K49<>\"\",K50<>\"\"),IF(E58<=1,1,E58),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(SUM(H54:H58)-H53+H52,0)","v":0},null,null,{"$f":"IFERROR(SUM(K54:K58)-K53+K52,0)","v":0},null,null,{"$f":"IFERROR(SUM(N54:N58)-N53+N52,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q54:Q58)-Q53+Q52,0)","v":0},null,null,{"$f":"IFERROR(SUM(T54:T58)-T53+T52,0)","v":0},null,null,{"$f":"IFERROR(SUM(W54:W58)-W53+W52,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H49)=MONTH(H50),((YEAR(H50)-YEAR(H49))*12)-12+(12-MONTH(H49))+MONTH(H50)-1+(EOMONTH(H49,0)-H49+1)/DAY(EOMONTH(H49,0))+(1-(EOMONTH(H50,0)-H50)/DAY(EOMONTH(H50,0))),((YEAR(H50)-YEAR(H49))*12)-12+(12-MONTH(H49))+MONTH(H50)-1+(EOMONTH(H49,0)-H49+1)/DAY(EOMONTH(H49,0))+(1-(EOMONTH(H50,0)-H50)/DAY(EOMONTH(H50,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H49<>\"\",H50<>\"\"),IF(E61<=1,1,E61),0),2)","v":0},null,{"$f":"IFERROR(H60/F61,0)","v":0},null,null,{"$f":"IFERROR(K60/F58,0)","v":0},null,null,{"$f":"IFERROR(N60/F57,0)","v":0},null,null,{"$f":"IFERROR(Q60/F56,0)","v":0},null,null,{"$f":"IFERROR(T60/F55,0)","v":0},null,null,{"$f":"IFERROR(W60/F54,0)","v":0}]
[]
[]
[null,"X","SOLE PROPRIETORSHIP",null,null,null,{"$f":"IF(OR(SAM!D62=0,SAM!D62=\"\"),\"\",SAM!D62)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Profit (Loss):",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W68)=MONTH(W69),((YEAR(W69)-YEAR(W68))*12)-12+(12-MONTH(W68))+MONTH(W69)-1+(EOMONTH(W68,0)-W68+1)/DAY(EOMONTH(W68,0))+(1-(EOMONTH(W69,0)-W69)/DAY(EOMONTH(W69,0))),((YEAR(W69)-YEAR(W68))*12)-12+(12-MONTH(W68))+MONTH(W69)-1+(EOMONTH(W68,0)-W68+1)/DAY(EOMONTH(W68,0))+(1-(EOMONTH(W69,0)-W69)/DAY(EOMONTH(W69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W68<>\"\",W69<>\"\"),IF(E73<=1,1,E73),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(T68)=MONTH(T69),((YEAR(T69)-YEAR(T68))*12)-12+(12-MONTH(T68))+MONTH(T69)-1+(EOMONTH(T68,0)-T68+1)/DAY(EOMONTH(T68,0))+(1-(EOMONTH(T69,0)-T69)/DAY(EOMONTH(T69,0))),((YEAR(T69)-YEAR(T68))*12)-12+(12-MONTH(T68))+MONTH(T69)-1+(EOMONTH(T68,0)-T68+1)/DAY(EOMONTH(T68,0))+(1-(EOMONTH(T69,0)-T69)/DAY(EOMONTH(T69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T68<>\"\",T69<>\"\"),IF(E74<=1,1,E74),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(Q68)=MONTH(Q69),((YEAR(Q69)-YEAR(Q68))*12)-12+(12-MONTH(Q68))+MONTH(Q69)-1+(EOMONTH(Q68,0)-Q68+1)/DAY(EOMONTH(Q68,0))+(1-(EOMONTH(Q69,0)-Q69)/DAY(EOMONTH(Q69,0))),((YEAR(Q69)-YEAR(Q68))*12)-12+(12-MONTH(Q68))+MONTH(Q69)-1+(EOMONTH(Q68,0)-Q68+1)/DAY(EOMONTH(Q68,0))+(1-(EOMONTH(Q69,0)-Q69)/DAY(EOMONTH(Q69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q68<>\"\",Q69<>\"\"),IF(E75<=1,1,E75),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N68)=MONTH(N69),((YEAR(N69)-YEAR(N68))*12)-12+(12-MONTH(N68))+MONTH(N69)-1+(EOMONTH(N68,0)-N68+1)/DAY(EOMONTH(N68,0))+(1-(EOMONTH(N69,0)-N69)/DAY(EOMONTH(N69,0))),((YEAR(N69)-YEAR(N68))*12)-12+(12-MONTH(N68))+MONTH(N69)-1+(EOMONTH(N68,0)-N68+1)/DAY(EOMONTH(N68,0))+(1-(EOMONTH(N69,0)-N69)/DAY(EOMONTH(N69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N68<>\"\",N69<>\"\"),IF(E76<=1,1,E76),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K68)=MONTH(K69),((YEAR(K69)-YEAR(K68))*12)-12+(12-MONTH(K68))+MONTH(K69)-1+(EOMONTH(K68,0)-K68+1)/DAY(EOMONTH(K68,0))+(1-(EOMONTH(K69,0)-K69)/DAY(EOMONTH(K69,0))),((YEAR(K69)-YEAR(K68))*12)-12+(12-MONTH(K68))+MONTH(K69)-1+(EOMONTH(K68,0)-K68+1)/DAY(EOMONTH(K68,0))+(1-(EOMONTH(K69,0)-K69)/DAY(EOMONTH(K69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K68<>\"\",K69<>\"\"),IF(E77<=1,1,E77),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(SUM(H73:H77)-H72+H71,0)","v":0},null,null,{"$f":"IFERROR(SUM(K73:K77)-K72+K71,0)","v":0},null,null,{"$f":"IFERROR(SUM(N73:N77)-N72+N71,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q73:Q77)-Q72+Q71,0)","v":0},null,null,{"$f":"IFERROR(SUM(T73:T77)-T72+T71,0)","v":0},null,null,{"$f":"IFERROR(SUM(W73:W77)-W72+W71,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H68)=MONTH(H69),((YEAR(H69)-YEAR(H68))*12)-12+(12-MONTH(H68))+MONTH(H69)-1+(EOMONTH(H68,0)-H68+1)/DAY(EOMONTH(H68,0))+(1-(EOMONTH(H69,0)-H69)/DAY(EOMONTH(H69,0))),((YEAR(H69)-YEAR(H68))*12)-12+(12-MONTH(H68))+MONTH(H69)-1+(EOMONTH(H68,0)-H68+1)/DAY(EOMONTH(H68,0))+(1-(EOMONTH(H69,0)-H69)/DAY(EOMONTH(H69,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H68<>\"\",H69<>\"\"),IF(E80<=1,1,E80),0),2)","v":0},null,{"$f":"IFERROR(H79/F80,0)","v":0},null,null,{"$f":"IFERROR(K79/F77,0)","v":0},null,null,{"$f":"IFERROR(N79/F76,0)","v":0},null,null,{"$f":"IFERROR(Q79/F75,0)","v":0},null,null,{"$f":"IFERROR(T79/F74,0)","v":0},null,null,{"$f":"IFERROR(W79/F73,0)","v":0}]
[]
[]
[null,"Partnership Cash Flow"]
[null,null,"Use of this information is discretionary.  FOLLOW INVESTOR GUIDELINES."]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E108=0,SAM!E108=\"\"),\"\",SAM!E108)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W89)=MONTH(W90),((YEAR(W90)-YEAR(W89))*12)-12+(12-MONTH(W89))+MONTH(W90)-1+(EOMONTH(W89,0)-W89+1)/DAY(EOMONTH(W89,0))+(1-(EOMONTH(W90,0)-W90)/DAY(EOMONTH(W90,0))),((YEAR(W90)-YEAR(W89))*12)-12+(12-MONTH(W89))+MONTH(W90)-1+(EOMONTH(W89,0)-W89+1)/DAY(EOMONTH(W89,0))+(1-(EOMONTH(W90,0)-W90)/DAY(EOMONTH(W90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W89<>\"\",W90<>\"\"),IF(E94<=1,1,E94),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T89)=MONTH(T90),((YEAR(T90)-YEAR(T89))*12)-12+(12-MONTH(T89))+MONTH(T90)-1+(EOMONTH(T89,0)-T89+1)/DAY(EOMONTH(T89,0))+(1-(EOMONTH(T90,0)-T90)/DAY(EOMONTH(T90,0))),((YEAR(T90)-YEAR(T89))*12)-12+(12-MONTH(T89))+MONTH(T90)-1+(EOMONTH(T89,0)-T89+1)/DAY(EOMONTH(T89,0))+(1-(EOMONTH(T90,0)-T90)/DAY(EOMONTH(T90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T89<>\"\",T90<>\"\"),IF(E95<=1,1,E95),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q89)=MONTH(Q90),((YEAR(Q90)-YEAR(Q89))*12)-12+(12-MONTH(Q89))+MONTH(Q90)-1+(EOMONTH(Q89,0)-Q89+1)/DAY(EOMONTH(Q89,0))+(1-(EOMONTH(Q90,0)-Q90)/DAY(EOMONTH(Q90,0))),((YEAR(Q90)-YEAR(Q89))*12)-12+(12-MONTH(Q89))+MONTH(Q90)-1+(EOMONTH(Q89,0)-Q89+1)/DAY(EOMONTH(Q89,0))+(1-(EOMONTH(Q90,0)-Q90)/DAY(EOMONTH(Q90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q89<>\"\",Q90<>\"\"),IF(E96<=1,1,E96),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N89)=MONTH(N90),((YEAR(N90)-YEAR(N89))*12)-12+(12-MONTH(N89))+MONTH(N90)-1+(EOMONTH(N89,0)-N89+1)/DAY(EOMONTH(N89,0))+(1-(EOMONTH(N90,0)-N90)/DAY(EOMONTH(N90,0))),((YEAR(N90)-YEAR(N89))*12)-12+(12-MONTH(N89))+MONTH(N90)-1+(EOMONTH(N89,0)-N89+1)/DAY(EOMONTH(N89,0))+(1-(EOMONTH(N90,0)-N90)/DAY(EOMONTH(N90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N89<>\"\",N90<>\"\"),IF(E97<=1,1,E97),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K89)=MONTH(K90),((YEAR(K90)-YEAR(K89))*12)-12+(12-MONTH(K89))+MONTH(K90)-1+(EOMONTH(K89,0)-K89+1)/DAY(EOMONTH(K89,0))+(1-(EOMONTH(K90,0)-K90)/DAY(EOMONTH(K90,0))),((YEAR(K90)-YEAR(K89))*12)-12+(12-MONTH(K89))+MONTH(K90)-1+(EOMONTH(K89,0)-K89+1)/DAY(EOMONTH(K89,0))+(1-(EOMONTH(K90,0)-K90)/DAY(EOMONTH(K90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K89<>\"\",K90<>\"\"),IF(E98<=1,1,E98),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H94:H98)-H93+H92,0)","v":0},null,null,{"$f":"IFERROR(SUM(K94:K98)-K93+K92,0)","v":0},null,null,{"$f":"IFERROR(SUM(N94:N98)-N93+N92,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q94:Q98)-Q93+Q92,0)","v":0},null,null,{"$f":"IFERROR(SUM(T94:T98)-T93+T92,0)","v":0},null,null,{"$f":"IFERROR(SUM(W94:W98)-W93+W92,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H100*H101,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K100*K101,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N100*N101,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q100*Q101,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T100*T101,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W100*W101,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H102+H104+H105,0)","v":0},null,null,{"$f":"IFERROR(K102+K104+K105,0)","v":0},null,null,{"$f":"IFERROR(N102+N104+N105,0)","v":0},null,null,{"$f":"IFERROR(Q102+Q104+Q105,0)","v":0},null,null,{"$f":"IFERROR(T102+T104+T105,0)","v":0},null,null,{"$f":"IFERROR(W102+W104+W105,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H89)=MONTH(H90),((YEAR(H90)-YEAR(H89))*12)-12+(12-MONTH(H89))+MONTH(H90)-1+(EOMONTH(H89,0)-H89+1)/DAY(EOMONTH(H89,0))+(1-(EOMONTH(H90,0)-H90)/DAY(EOMONTH(H90,0))),((YEAR(H90)-YEAR(H89))*12)-12+(12-MONTH(H89))+MONTH(H90)-1+(EOMONTH(H89,0)-H89+1)/DAY(EOMONTH(H89,0))+(1-(EOMONTH(H90,0)-H90)/DAY(EOMONTH(H90,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H89<>\"\",H90<>\"\"),IF(E108<=1,1,E108),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H107/F108,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K107/F98,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N107/F97,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q107/F96,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T107/F95,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W107/F94,0),2)","v":0}]
[]
[]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E140=0,SAM!E140=\"\"),\"\",SAM!E140)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W115)=MONTH(W116),((YEAR(W116)-YEAR(W115))*12)-12+(12-MONTH(W115))+MONTH(W116)-1+(EOMONTH(W115,0)-W115+1)/DAY(EOMONTH(W115,0))+(1-(EOMONTH(W116,0)-W116)/DAY(EOMONTH(W116,0))),((YEAR(W116)-YEAR(W115))*12)-12+(12-MONTH(W115))+MONTH(W116)-1+(EOMONTH(W115,0)-W115+1)/DAY(EOMONTH(W115,0))+(1-(EOMONTH(W116,0)-W116)/DAY(EOMONTH(W116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W115<>\"\",W116<>\"\"),IF(E120<=1,1,E120),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T115)=MONTH(T116),((YEAR(T116)-YEAR(T115))*12)-12+(12-MONTH(T115))+MONTH(T116)-1+(EOMONTH(T115,0)-T115+1)/DAY(EOMONTH(T115,0))+(1-(EOMONTH(T116,0)-T116)/DAY(EOMONTH(T116,0))),((YEAR(T116)-YEAR(T115))*12)-12+(12-MONTH(T115))+MONTH(T116)-1+(EOMONTH(T115,0)-T115+1)/DAY(EOMONTH(T115,0))+(1-(EOMONTH(T116,0)-T116)/DAY(EOMONTH(T116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T115<>\"\",T116<>\"\"),IF(E121<=1,1,E121),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q115)=MONTH(Q116),((YEAR(Q116)-YEAR(Q115))*12)-12+(12-MONTH(Q115))+MONTH(Q116)-1+(EOMONTH(Q115,0)-Q115+1)/DAY(EOMONTH(Q115,0))+(1-(EOMONTH(Q116,0)-Q116)/DAY(EOMONTH(Q116,0))),((YEAR(Q116)-YEAR(Q115))*12)-12+(12-MONTH(Q115))+MONTH(Q116)-1+(EOMONTH(Q115,0)-Q115+1)/DAY(EOMONTH(Q115,0))+(1-(EOMONTH(Q116,0)-Q116)/DAY(EOMONTH(Q116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q115<>\"\",Q116<>\"\"),IF(E122<=1,1,E122),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N115)=MONTH(N116),((YEAR(N116)-YEAR(N115))*12)-12+(12-MONTH(N115))+MONTH(N116)-1+(EOMONTH(N115,0)-N115+1)/DAY(EOMONTH(N115,0))+(1-(EOMONTH(N116,0)-N116)/DAY(EOMONTH(N116,0))),((YEAR(N116)-YEAR(N115))*12)-12+(12-MONTH(N115))+MONTH(N116)-1+(EOMONTH(N115,0)-N115+1)/DAY(EOMONTH(N115,0))+(1-(EOMONTH(N116,0)-N116)/DAY(EOMONTH(N116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N115<>\"\",N116<>\"\"),IF(E123<=1,1,E123),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K115)=MONTH(K116),((YEAR(K116)-YEAR(K115))*12)-12+(12-MONTH(K115))+MONTH(K116)-1+(EOMONTH(K115,0)-K115+1)/DAY(EOMONTH(K115,0))+(1-(EOMONTH(K116,0)-K116)/DAY(EOMONTH(K116,0))),((YEAR(K116)-YEAR(K115))*12)-12+(12-MONTH(K115))+MONTH(K116)-1+(EOMONTH(K115,0)-K115+1)/DAY(EOMONTH(K115,0))+(1-(EOMONTH(K116,0)-K116)/DAY(EOMONTH(K116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K115<>\"\",K116<>\"\"),IF(E124<=1,1,E124),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H120:H124)-H119+H118,0)","v":0},null,null,{"$f":"IFERROR(SUM(K120:K124)-K119+K118,0)","v":0},null,null,{"$f":"IFERROR(SUM(N120:N124)-N119+N118,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q120:Q124)-Q119+Q118,0)","v":0},null,null,{"$f":"IFERROR(SUM(T120:T124)-T119+T118,0)","v":0},null,null,{"$f":"IFERROR(SUM(W120:W124)-W119+W118,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H126*H127,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K126*K127,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N126*N127,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q126*Q127,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T126*T127,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W126*W127,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H128+H130+H131,0)","v":0},null,null,{"$f":"IFERROR(K128+K130+K131,0)","v":0},null,null,{"$f":"IFERROR(N128+N130+N131,0)","v":0},null,null,{"$f":"IFERROR(Q128+Q130+Q131,0)","v":0},null,null,{"$f":"IFERROR(T128+T130+T131,0)","v":0},null,null,{"$f":"IFERROR(W128+W130+W131,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H115)=MONTH(H116),((YEAR(H116)-YEAR(H115))*12)-12+(12-MONTH(H115))+MONTH(H116)-1+(EOMONTH(H115,0)-H115+1)/DAY(EOMONTH(H115,0))+(1-(EOMONTH(H116,0)-H116)/DAY(EOMONTH(H116,0))),((YEAR(H116)-YEAR(H115))*12)-12+(12-MONTH(H115))+MONTH(H116)-1+(EOMONTH(H115,0)-H115+1)/DAY(EOMONTH(H115,0))+(1-(EOMONTH(H116,0)-H116)/DAY(EOMONTH(H116,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H115<>\"\",H116<>\"\"),IF(E134<=1,1,E134),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H133/F134,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K133/F124,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N133/F123,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q133/F122,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T133/F121,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W133/F120,0),2)","v":0}]
[]
[]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E172=0,SAM!E172=\"\"),\"\",SAM!E172)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W141)=MONTH(W142),((YEAR(W142)-YEAR(W141))*12)-12+(12-MONTH(W141))+MONTH(W142)-1+(EOMONTH(W141,0)-W141+1)/DAY(EOMONTH(W141,0))+(1-(EOMONTH(W142,0)-W142)/DAY(EOMONTH(W142,0))),((YEAR(W142)-YEAR(W141))*12)-12+(12-MONTH(W141))+MONTH(W142)-1+(EOMONTH(W141,0)-W141+1)/DAY(EOMONTH(W141,0))+(1-(EOMONTH(W142,0)-W142)/DAY(EOMONTH(W142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W141<>\"\",W142<>\"\"),IF(E146<=1,1,E146),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T141)=MONTH(T142),((YEAR(T142)-YEAR(T141))*12)-12+(12-MONTH(T141))+MONTH(T142)-1+(EOMONTH(T141,0)-T141+1)/DAY(EOMONTH(T141,0))+(1-(EOMONTH(T142,0)-T142)/DAY(EOMONTH(T142,0))),((YEAR(T142)-YEAR(T141))*12)-12+(12-MONTH(T141))+MONTH(T142)-1+(EOMONTH(T141,0)-T141+1)/DAY(EOMONTH(T141,0))+(1-(EOMONTH(T142,0)-T142)/DAY(EOMONTH(T142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T141<>\"\",T142<>\"\"),IF(E147<=1,1,E147),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q141)=MONTH(Q142),((YEAR(Q142)-YEAR(Q141))*12)-12+(12-MONTH(Q141))+MONTH(Q142)-1+(EOMONTH(Q141,0)-Q141+1)/DAY(EOMONTH(Q141,0))+(1-(EOMONTH(Q142,0)-Q142)/DAY(EOMONTH(Q142,0))),((YEAR(Q142)-YEAR(Q141))*12)-12+(12-MONTH(Q141))+MONTH(Q142)-1+(EOMONTH(Q141,0)-Q141+1)/DAY(EOMONTH(Q141,0))+(1-(EOMONTH(Q142,0)-Q142)/DAY(EOMONTH(Q142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q141<>\"\",Q142<>\"\"),IF(E148<=1,1,E148),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N141)=MONTH(N142),((YEAR(N142)-YEAR(N141))*12)-12+(12-MONTH(N141))+MONTH(N142)-1+(EOMONTH(N141,0)-N141+1)/DAY(EOMONTH(N141,0))+(1-(EOMONTH(N142,0)-N142)/DAY(EOMONTH(N142,0))),((YEAR(N142)-YEAR(N141))*12)-12+(12-MONTH(N141))+MONTH(N142)-1+(EOMONTH(N141,0)-N141+1)/DAY(EOMONTH(N141,0))+(1-(EOMONTH(N142,0)-N142)/DAY(EOMONTH(N142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N141<>\"\",N142<>\"\"),IF(E149<=1,1,E149),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K141)=MONTH(K142),((YEAR(K142)-YEAR(K141))*12)-12+(12-MONTH(K141))+MONTH(K142)-1+(EOMONTH(K141,0)-K141+1)/DAY(EOMONTH(K141,0))+(1-(EOMONTH(K142,0)-K142)/DAY(EOMONTH(K142,0))),((YEAR(K142)-YEAR(K141))*12)-12+(12-MONTH(K141))+MONTH(K142)-1+(EOMONTH(K141,0)-K141+1)/DAY(EOMONTH(K141,0))+(1-(EOMONTH(K142,0)-K142)/DAY(EOMONTH(K142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K141<>\"\",K142<>\"\"),IF(E150<=1,1,E150),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H146:H150)-H145+H144,0)","v":0},null,null,{"$f":"IFERROR(SUM(K146:K150)-K145+K144,0)","v":0},null,null,{"$f":"IFERROR(SUM(N146:N150)-N145+N144,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q146:Q150)-Q145+Q144,0)","v":0},null,null,{"$f":"IFERROR(SUM(T146:T150)-T145+T144,0)","v":0},null,null,{"$f":"IFERROR(SUM(W146:W150)-W145+W144,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H152*H153,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K152*K153,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N152*N153,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q152*Q153,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T152*T153,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W152*W153,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H154+H156+H157,0)","v":0},null,null,{"$f":"IFERROR(K154+K156+K157,0)","v":0},null,null,{"$f":"IFERROR(N154+N156+N157,0)","v":0},null,null,{"$f":"IFERROR(Q154+Q156+Q157,0)","v":0},null,null,{"$f":"IFERROR(T154+T156+T157,0)","v":0},null,null,{"$f":"IFERROR(W154+W156+W157,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H141)=MONTH(H142),((YEAR(H142)-YEAR(H141))*12)-12+(12-MONTH(H141))+MONTH(H142)-1+(EOMONTH(H141,0)-H141+1)/DAY(EOMONTH(H141,0))+(1-(EOMONTH(H142,0)-H142)/DAY(EOMONTH(H142,0))),((YEAR(H142)-YEAR(H141))*12)-12+(12-MONTH(H141))+MONTH(H142)-1+(EOMONTH(H141,0)-H141+1)/DAY(EOMONTH(H141,0))+(1-(EOMONTH(H142,0)-H142)/DAY(EOMONTH(H142,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H141<>\"\",H142<>\"\"),IF(E160<=1,1,E160),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H159/F160,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K159/F150,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N159/F149,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q159/F148,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T159/F147,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W159/F146,0),2)","v":0}]
[]
[]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E204=0,SAM!E204=\"\"),\"\",SAM!E204)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W167)=MONTH(W168),((YEAR(W168)-YEAR(W167))*12)-12+(12-MONTH(W167))+MONTH(W168)-1+(EOMONTH(W167,0)-W167+1)/DAY(EOMONTH(W167,0))+(1-(EOMONTH(W168,0)-W168)/DAY(EOMONTH(W168,0))),((YEAR(W168)-YEAR(W167))*12)-12+(12-MONTH(W167))+MONTH(W168)-1+(EOMONTH(W167,0)-W167+1)/DAY(EOMONTH(W167,0))+(1-(EOMONTH(W168,0)-W168)/DAY(EOMONTH(W168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W167<>\"\",W168<>\"\"),IF(E172<=1,1,E172),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T167)=MONTH(T168),((YEAR(T168)-YEAR(T167))*12)-12+(12-MONTH(T167))+MONTH(T168)-1+(EOMONTH(T167,0)-T167+1)/DAY(EOMONTH(T167,0))+(1-(EOMONTH(T168,0)-T168)/DAY(EOMONTH(T168,0))),((YEAR(T168)-YEAR(T167))*12)-12+(12-MONTH(T167))+MONTH(T168)-1+(EOMONTH(T167,0)-T167+1)/DAY(EOMONTH(T167,0))+(1-(EOMONTH(T168,0)-T168)/DAY(EOMONTH(T168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T167<>\"\",T168<>\"\"),IF(E173<=1,1,E173),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q167)=MONTH(Q168),((YEAR(Q168)-YEAR(Q167))*12)-12+(12-MONTH(Q167))+MONTH(Q168)-1+(EOMONTH(Q167,0)-Q167+1)/DAY(EOMONTH(Q167,0))+(1-(EOMONTH(Q168,0)-Q168)/DAY(EOMONTH(Q168,0))),((YEAR(Q168)-YEAR(Q167))*12)-12+(12-MONTH(Q167))+MONTH(Q168)-1+(EOMONTH(Q167,0)-Q167+1)/DAY(EOMONTH(Q167,0))+(1-(EOMONTH(Q168,0)-Q168)/DAY(EOMONTH(Q168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q167<>\"\",Q168<>\"\"),IF(E174<=1,1,E174),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N167)=MONTH(N168),((YEAR(N168)-YEAR(N167))*12)-12+(12-MONTH(N167))+MONTH(N168)-1+(EOMONTH(N167,0)-N167+1)/DAY(EOMONTH(N167,0))+(1-(EOMONTH(N168,0)-N168)/DAY(EOMONTH(N168,0))),((YEAR(N168)-YEAR(N167))*12)-12+(12-MONTH(N167))+MONTH(N168)-1+(EOMONTH(N167,0)-N167+1)/DAY(EOMONTH(N167,0))+(1-(EOMONTH(N168,0)-N168)/DAY(EOMONTH(N168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N167<>\"\",N168<>\"\"),IF(E175<=1,1,E175),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K167)=MONTH(K168),((YEAR(K168)-YEAR(K167))*12)-12+(12-MONTH(K167))+MONTH(K168)-1+(EOMONTH(K167,0)-K167+1)/DAY(EOMONTH(K167,0))+(1-(EOMONTH(K168,0)-K168)/DAY(EOMONTH(K168,0))),((YEAR(K168)-YEAR(K167))*12)-12+(12-MONTH(K167))+MONTH(K168)-1+(EOMONTH(K167,0)-K167+1)/DAY(EOMONTH(K167,0))+(1-(EOMONTH(K168,0)-K168)/DAY(EOMONTH(K168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K167<>\"\",K168<>\"\"),IF(E176<=1,1,E176),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H172:H176)-H171+H170,0)","v":0},null,null,{"$f":"IFERROR(SUM(K172:K176)-K171+K170,0)","v":0},null,null,{"$f":"IFERROR(SUM(N172:N176)-N171+N170,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q172:Q176)-Q171+Q170,0)","v":0},null,null,{"$f":"IFERROR(SUM(T172:T176)-T171+T170,0)","v":0},null,null,{"$f":"IFERROR(SUM(W172:W176)-W171+W170,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H178*H179,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K178*K179,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N178*N179,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q178*Q179,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T178*T179,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W178*W179,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H180+H182+H183,0)","v":0},null,null,{"$f":"IFERROR(K180+K182+K183,0)","v":0},null,null,{"$f":"IFERROR(N180+N182+N183,0)","v":0},null,null,{"$f":"IFERROR(Q180+Q182+Q183,0)","v":0},null,null,{"$f":"IFERROR(T180+T182+T183,0)","v":0},null,null,{"$f":"IFERROR(W180+W182+W183,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H167)=MONTH(H168),((YEAR(H168)-YEAR(H167))*12)-12+(12-MONTH(H167))+MONTH(H168)-1+(EOMONTH(H167,0)-H167+1)/DAY(EOMONTH(H167,0))+(1-(EOMONTH(H168,0)-H168)/DAY(EOMONTH(H168,0))),((YEAR(H168)-YEAR(H167))*12)-12+(12-MONTH(H167))+MONTH(H168)-1+(EOMONTH(H167,0)-H167+1)/DAY(EOMONTH(H167,0))+(1-(EOMONTH(H168,0)-H168)/DAY(EOMONTH(H168,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H167<>\"\",H168<>\"\"),IF(E186<=1,1,E186),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H185/F186,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K185/F176,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N185/F175,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q185/F174,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T185/F173,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W185/F172,0),2)","v":0}]
[]
[]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E236=0,SAM!E236=\"\"),\"\",SAM!E236)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W193)=MONTH(W194),((YEAR(W194)-YEAR(W193))*12)-12+(12-MONTH(W193))+MONTH(W194)-1+(EOMONTH(W193,0)-W193+1)/DAY(EOMONTH(W193,0))+(1-(EOMONTH(W194,0)-W194)/DAY(EOMONTH(W194,0))),((YEAR(W194)-YEAR(W193))*12)-12+(12-MONTH(W193))+MONTH(W194)-1+(EOMONTH(W193,0)-W193+1)/DAY(EOMONTH(W193,0))+(1-(EOMONTH(W194,0)-W194)/DAY(EOMONTH(W194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W193<>\"\",W194<>\"\"),IF(E198<=1,1,E198),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T193)=MONTH(T194),((YEAR(T194)-YEAR(T193))*12)-12+(12-MONTH(T193))+MONTH(T194)-1+(EOMONTH(T193,0)-T193+1)/DAY(EOMONTH(T193,0))+(1-(EOMONTH(T194,0)-T194)/DAY(EOMONTH(T194,0))),((YEAR(T194)-YEAR(T193))*12)-12+(12-MONTH(T193))+MONTH(T194)-1+(EOMONTH(T193,0)-T193+1)/DAY(EOMONTH(T193,0))+(1-(EOMONTH(T194,0)-T194)/DAY(EOMONTH(T194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T193<>\"\",T194<>\"\"),IF(E199<=1,1,E199),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q193)=MONTH(Q194),((YEAR(Q194)-YEAR(Q193))*12)-12+(12-MONTH(Q193))+MONTH(Q194)-1+(EOMONTH(Q193,0)-Q193+1)/DAY(EOMONTH(Q193,0))+(1-(EOMONTH(Q194,0)-Q194)/DAY(EOMONTH(Q194,0))),((YEAR(Q194)-YEAR(Q193))*12)-12+(12-MONTH(Q193))+MONTH(Q194)-1+(EOMONTH(Q193,0)-Q193+1)/DAY(EOMONTH(Q193,0))+(1-(EOMONTH(Q194,0)-Q194)/DAY(EOMONTH(Q194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q193<>\"\",Q194<>\"\"),IF(E200<=1,1,E200),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N193)=MONTH(N194),((YEAR(N194)-YEAR(N193))*12)-12+(12-MONTH(N193))+MONTH(N194)-1+(EOMONTH(N193,0)-N193+1)/DAY(EOMONTH(N193,0))+(1-(EOMONTH(N194,0)-N194)/DAY(EOMONTH(N194,0))),((YEAR(N194)-YEAR(N193))*12)-12+(12-MONTH(N193))+MONTH(N194)-1+(EOMONTH(N193,0)-N193+1)/DAY(EOMONTH(N193,0))+(1-(EOMONTH(N194,0)-N194)/DAY(EOMONTH(N194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N193<>\"\",N194<>\"\"),IF(E201<=1,1,E201),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K193)=MONTH(K194),((YEAR(K194)-YEAR(K193))*12)-12+(12-MONTH(K193))+MONTH(K194)-1+(EOMONTH(K193,0)-K193+1)/DAY(EOMONTH(K193,0))+(1-(EOMONTH(K194,0)-K194)/DAY(EOMONTH(K194,0))),((YEAR(K194)-YEAR(K193))*12)-12+(12-MONTH(K193))+MONTH(K194)-1+(EOMONTH(K193,0)-K193+1)/DAY(EOMONTH(K193,0))+(1-(EOMONTH(K194,0)-K194)/DAY(EOMONTH(K194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K193<>\"\",K194<>\"\"),IF(E202<=1,1,E202),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H198:H202)-H197+H196,0)","v":0},null,null,{"$f":"IFERROR(SUM(K198:K202)-K197+K196,0)","v":0},null,null,{"$f":"IFERROR(SUM(N198:N202)-N197+N196,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q198:Q202)-Q197+Q196,0)","v":0},null,null,{"$f":"IFERROR(SUM(T198:T202)-T197+T196,0)","v":0},null,null,{"$f":"IFERROR(SUM(W198:W202)-W197+W196,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H204*H205,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K204*K205,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N204*N205,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q204*Q205,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T204*T205,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W204*W205,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H206+H208+H209,0)","v":0},null,null,{"$f":"IFERROR(K206+K208+K209,0)","v":0},null,null,{"$f":"IFERROR(N206+N208+N209,0)","v":0},null,null,{"$f":"IFERROR(Q206+Q208+Q209,0)","v":0},null,null,{"$f":"IFERROR(T206+T208+T209,0)","v":0},null,null,{"$f":"IFERROR(W206+W208+W209,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H193)=MONTH(H194),((YEAR(H194)-YEAR(H193))*12)-12+(12-MONTH(H193))+MONTH(H194)-1+(EOMONTH(H193,0)-H193+1)/DAY(EOMONTH(H193,0))+(1-(EOMONTH(H194,0)-H194)/DAY(EOMONTH(H194,0))),((YEAR(H194)-YEAR(H193))*12)-12+(12-MONTH(H193))+MONTH(H194)-1+(EOMONTH(H193,0)-H193+1)/DAY(EOMONTH(H193,0))+(1-(EOMONTH(H194,0)-H194)/DAY(EOMONTH(H194,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H193<>\"\",H194<>\"\"),IF(E212<=1,1,E212),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H211/F212,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K211/F202,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N211/F201,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q211/F200,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T211/F199,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W211/F198,0),2)","v":0}]
[]
[]
[null,"X","PARTNERSHIP",null,null,null,{"$f":"IF(OR(SAM!E268=0,SAM!E268=\"\"),\"\",SAM!E268)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W219)=MONTH(W220),((YEAR(W220)-YEAR(W219))*12)-12+(12-MONTH(W219))+MONTH(W220)-1+(EOMONTH(W219,0)-W219+1)/DAY(EOMONTH(W219,0))+(1-(EOMONTH(W220,0)-W220)/DAY(EOMONTH(W220,0))),((YEAR(W220)-YEAR(W219))*12)-12+(12-MONTH(W219))+MONTH(W220)-1+(EOMONTH(W219,0)-W219+1)/DAY(EOMONTH(W219,0))+(1-(EOMONTH(W220,0)-W220)/DAY(EOMONTH(W220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W219<>\"\",W220<>\"\"),IF(E224<=1,1,E224),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T219)=MONTH(T220),((YEAR(T220)-YEAR(T219))*12)-12+(12-MONTH(T219))+MONTH(T220)-1+(EOMONTH(T219,0)-T219+1)/DAY(EOMONTH(T219,0))+(1-(EOMONTH(T220,0)-T220)/DAY(EOMONTH(T220,0))),((YEAR(T220)-YEAR(T219))*12)-12+(12-MONTH(T219))+MONTH(T220)-1+(EOMONTH(T219,0)-T219+1)/DAY(EOMONTH(T219,0))+(1-(EOMONTH(T220,0)-T220)/DAY(EOMONTH(T220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T219<>\"\",T220<>\"\"),IF(E225<=1,1,E225),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q219)=MONTH(Q220),((YEAR(Q220)-YEAR(Q219))*12)-12+(12-MONTH(Q219))+MONTH(Q220)-1+(EOMONTH(Q219,0)-Q219+1)/DAY(EOMONTH(Q219,0))+(1-(EOMONTH(Q220,0)-Q220)/DAY(EOMONTH(Q220,0))),((YEAR(Q220)-YEAR(Q219))*12)-12+(12-MONTH(Q219))+MONTH(Q220)-1+(EOMONTH(Q219,0)-Q219+1)/DAY(EOMONTH(Q219,0))+(1-(EOMONTH(Q220,0)-Q220)/DAY(EOMONTH(Q220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q219<>\"\",Q220<>\"\"),IF(E226<=1,1,E226),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N219)=MONTH(N220),((YEAR(N220)-YEAR(N219))*12)-12+(12-MONTH(N219))+MONTH(N220)-1+(EOMONTH(N219,0)-N219+1)/DAY(EOMONTH(N219,0))+(1-(EOMONTH(N220,0)-N220)/DAY(EOMONTH(N220,0))),((YEAR(N220)-YEAR(N219))*12)-12+(12-MONTH(N219))+MONTH(N220)-1+(EOMONTH(N219,0)-N219+1)/DAY(EOMONTH(N219,0))+(1-(EOMONTH(N220,0)-N220)/DAY(EOMONTH(N220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N219<>\"\",N220<>\"\"),IF(E227<=1,1,E227),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K219)=MONTH(K220),((YEAR(K220)-YEAR(K219))*12)-12+(12-MONTH(K219))+MONTH(K220)-1+(EOMONTH(K219,0)-K219+1)/DAY(EOMONTH(K219,0))+(1-(EOMONTH(K220,0)-K220)/DAY(EOMONTH(K220,0))),((YEAR(K220)-YEAR(K219))*12)-12+(12-MONTH(K219))+MONTH(K220)-1+(EOMONTH(K219,0)-K219+1)/DAY(EOMONTH(K219,0))+(1-(EOMONTH(K220,0)-K220)/DAY(EOMONTH(K220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K219<>\"\",K220<>\"\"),IF(E228<=1,1,E228),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H224:H228)-H223+H222,0)","v":0},null,null,{"$f":"IFERROR(SUM(K224:K228)-K223+K222,0)","v":0},null,null,{"$f":"IFERROR(SUM(N224:N228)-N223+N222,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q224:Q228)-Q223+Q222,0)","v":0},null,null,{"$f":"IFERROR(SUM(T224:T228)-T223+T222,0)","v":0},null,null,{"$f":"IFERROR(SUM(W224:W228)-W223+W222,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Partner's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H230*H231,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K230*K231,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N230*N231,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q230*Q231,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T230*T231,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W230*W231,0),2)","v":0}]
[]
[null,"Wages:"]
[null,"Guaranteed Payments:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H232+H234+H235,0)","v":0},null,null,{"$f":"IFERROR(K232+K234+K235,0)","v":0},null,null,{"$f":"IFERROR(N232+N234+N235,0)","v":0},null,null,{"$f":"IFERROR(Q232+Q234+Q235,0)","v":0},null,null,{"$f":"IFERROR(T232+T234+T235,0)","v":0},null,null,{"$f":"IFERROR(W232+W234+W235,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H219)=MONTH(H220),((YEAR(H220)-YEAR(H219))*12)-12+(12-MONTH(H219))+MONTH(H220)-1+(EOMONTH(H219,0)-H219+1)/DAY(EOMONTH(H219,0))+(1-(EOMONTH(H220,0)-H220)/DAY(EOMONTH(H220,0))),((YEAR(H220)-YEAR(H219))*12)-12+(12-MONTH(H219))+MONTH(H220)-1+(EOMONTH(H219,0)-H219+1)/DAY(EOMONTH(H219,0))+(1-(EOMONTH(H220,0)-H220)/DAY(EOMONTH(H220,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H219<>\"\",H220<>\"\"),IF(E238<=1,1,E238),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H237/F238,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K237/F228,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N237/F227,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q237/F226,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T237/F225,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W237/F224,0),2)","v":0}]
[]
[]
[null,"S Corporation Cash Flow"]
[null,null,"Use of this information is discretionary.  FOLLOW INVESTOR GUIDELINES."]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E302=0,SAM!E302=\"\"),\"\",SAM!E302)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W247)=MONTH(W248),((YEAR(W248)-YEAR(W247))*12)-12+(12-MONTH(W247))+MONTH(W248)-1+(EOMONTH(W247,0)-W247+1)/DAY(EOMONTH(W247,0))+(1-(EOMONTH(W248,0)-W248)/DAY(EOMONTH(W248,0))),((YEAR(W248)-YEAR(W247))*12)-12+(12-MONTH(W247))+MONTH(W248)-1+(EOMONTH(W247,0)-W247+1)/DAY(EOMONTH(W247,0))+(1-(EOMONTH(W248,0)-W248)/DAY(EOMONTH(W248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W247<>\"\",W248<>\"\"),IF(E252<=1,1,E252),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T247)=MONTH(T248),((YEAR(T248)-YEAR(T247))*12)-12+(12-MONTH(T247))+MONTH(T248)-1+(EOMONTH(T247,0)-T247+1)/DAY(EOMONTH(T247,0))+(1-(EOMONTH(T248,0)-T248)/DAY(EOMONTH(T248,0))),((YEAR(T248)-YEAR(T247))*12)-12+(12-MONTH(T247))+MONTH(T248)-1+(EOMONTH(T247,0)-T247+1)/DAY(EOMONTH(T247,0))+(1-(EOMONTH(T248,0)-T248)/DAY(EOMONTH(T248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T247<>\"\",T248<>\"\"),IF(E253<=1,1,E253),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q247)=MONTH(Q248),((YEAR(Q248)-YEAR(Q247))*12)-12+(12-MONTH(Q247))+MONTH(Q248)-1+(EOMONTH(Q247,0)-Q247+1)/DAY(EOMONTH(Q247,0))+(1-(EOMONTH(Q248,0)-Q248)/DAY(EOMONTH(Q248,0))),((YEAR(Q248)-YEAR(Q247))*12)-12+(12-MONTH(Q247))+MONTH(Q248)-1+(EOMONTH(Q247,0)-Q247+1)/DAY(EOMONTH(Q247,0))+(1-(EOMONTH(Q248,0)-Q248)/DAY(EOMONTH(Q248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q247<>\"\",Q248<>\"\"),IF(E254<=1,1,E254),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N247)=MONTH(N248),((YEAR(N248)-YEAR(N247))*12)-12+(12-MONTH(N247))+MONTH(N248)-1+(EOMONTH(N247,0)-N247+1)/DAY(EOMONTH(N247,0))+(1-(EOMONTH(N248,0)-N248)/DAY(EOMONTH(N248,0))),((YEAR(N248)-YEAR(N247))*12)-12+(12-MONTH(N247))+MONTH(N248)-1+(EOMONTH(N247,0)-N247+1)/DAY(EOMONTH(N247,0))+(1-(EOMONTH(N248,0)-N248)/DAY(EOMONTH(N248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N247<>\"\",N248<>\"\"),IF(E255<=1,1,E255),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K247)=MONTH(K248),((YEAR(K248)-YEAR(K247))*12)-12+(12-MONTH(K247))+MONTH(K248)-1+(EOMONTH(K247,0)-K247+1)/DAY(EOMONTH(K247,0))+(1-(EOMONTH(K248,0)-K248)/DAY(EOMONTH(K248,0))),((YEAR(K248)-YEAR(K247))*12)-12+(12-MONTH(K247))+MONTH(K248)-1+(EOMONTH(K247,0)-K247+1)/DAY(EOMONTH(K247,0))+(1-(EOMONTH(K248,0)-K248)/DAY(EOMONTH(K248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K247<>\"\",K248<>\"\"),IF(E256<=1,1,E256),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H252:H256)-H251+H250,0)","v":0},null,null,{"$f":"IFERROR(SUM(K252:K256)-K251+K250,0)","v":0},null,null,{"$f":"IFERROR(SUM(N252:N256)-N251+N250,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q252:Q256)-Q251+Q250,0)","v":0},null,null,{"$f":"IFERROR(SUM(T252:T256)-T251+T250,0)","v":0},null,null,{"$f":"IFERROR(SUM(W252:W256)-W251+W250,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H258*H259,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K258*K259,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N258*N259,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q258*Q259,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T258*T259,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W258*W259,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H260+H262,0)","v":0},null,null,{"$f":"IFERROR(K260+K262,0)","v":0},null,null,{"$f":"IFERROR(N260+N262,0)","v":0},null,null,{"$f":"IFERROR(Q260+Q262,0)","v":0},null,null,{"$f":"IFERROR(T260+T262,0)","v":0},null,null,{"$f":"IFERROR(W260+W262,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H247)=MONTH(H248),((YEAR(H248)-YEAR(H247))*12)-12+(12-MONTH(H247))+MONTH(H248)-1+(EOMONTH(H247,0)-H247+1)/DAY(EOMONTH(H247,0))+(1-(EOMONTH(H248,0)-H248)/DAY(EOMONTH(H248,0))),((YEAR(H248)-YEAR(H247))*12)-12+(12-MONTH(H247))+MONTH(H248)-1+(EOMONTH(H247,0)-H247+1)/DAY(EOMONTH(H247,0))+(1-(EOMONTH(H248,0)-H248)/DAY(EOMONTH(H248,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H247<>\"\",H248<>\"\"),IF(E265<=1,1,E265),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H264/F265,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K264/F256,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N264/F255,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q264/F254,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T264/F253,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W264/F252,0),2)","v":0}]
[]
[]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E332=0,SAM!E332=\"\"),\"\",SAM!E332)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W272)=MONTH(W273),((YEAR(W273)-YEAR(W272))*12)-12+(12-MONTH(W272))+MONTH(W273)-1+(EOMONTH(W272,0)-W272+1)/DAY(EOMONTH(W272,0))+(1-(EOMONTH(W273,0)-W273)/DAY(EOMONTH(W273,0))),((YEAR(W273)-YEAR(W272))*12)-12+(12-MONTH(W272))+MONTH(W273)-1+(EOMONTH(W272,0)-W272+1)/DAY(EOMONTH(W272,0))+(1-(EOMONTH(W273,0)-W273)/DAY(EOMONTH(W273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W272<>\"\",W273<>\"\"),IF(E277<=1,1,E277),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T272)=MONTH(T273),((YEAR(T273)-YEAR(T272))*12)-12+(12-MONTH(T272))+MONTH(T273)-1+(EOMONTH(T272,0)-T272+1)/DAY(EOMONTH(T272,0))+(1-(EOMONTH(T273,0)-T273)/DAY(EOMONTH(T273,0))),((YEAR(T273)-YEAR(T272))*12)-12+(12-MONTH(T272))+MONTH(T273)-1+(EOMONTH(T272,0)-T272+1)/DAY(EOMONTH(T272,0))+(1-(EOMONTH(T273,0)-T273)/DAY(EOMONTH(T273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T272<>\"\",T273<>\"\"),IF(E278<=1,1,E278),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q272)=MONTH(Q273),((YEAR(Q273)-YEAR(Q272))*12)-12+(12-MONTH(Q272))+MONTH(Q273)-1+(EOMONTH(Q272,0)-Q272+1)/DAY(EOMONTH(Q272,0))+(1-(EOMONTH(Q273,0)-Q273)/DAY(EOMONTH(Q273,0))),((YEAR(Q273)-YEAR(Q272))*12)-12+(12-MONTH(Q272))+MONTH(Q273)-1+(EOMONTH(Q272,0)-Q272+1)/DAY(EOMONTH(Q272,0))+(1-(EOMONTH(Q273,0)-Q273)/DAY(EOMONTH(Q273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q272<>\"\",Q273<>\"\"),IF(E279<=1,1,E279),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N272)=MONTH(N273),((YEAR(N273)-YEAR(N272))*12)-12+(12-MONTH(N272))+MONTH(N273)-1+(EOMONTH(N272,0)-N272+1)/DAY(EOMONTH(N272,0))+(1-(EOMONTH(N273,0)-N273)/DAY(EOMONTH(N273,0))),((YEAR(N273)-YEAR(N272))*12)-12+(12-MONTH(N272))+MONTH(N273)-1+(EOMONTH(N272,0)-N272+1)/DAY(EOMONTH(N272,0))+(1-(EOMONTH(N273,0)-N273)/DAY(EOMONTH(N273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N272<>\"\",N273<>\"\"),IF(E280<=1,1,E280),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K272)=MONTH(K273),((YEAR(K273)-YEAR(K272))*12)-12+(12-MONTH(K272))+MONTH(K273)-1+(EOMONTH(K272,0)-K272+1)/DAY(EOMONTH(K272,0))+(1-(EOMONTH(K273,0)-K273)/DAY(EOMONTH(K273,0))),((YEAR(K273)-YEAR(K272))*12)-12+(12-MONTH(K272))+MONTH(K273)-1+(EOMONTH(K272,0)-K272+1)/DAY(EOMONTH(K272,0))+(1-(EOMONTH(K273,0)-K273)/DAY(EOMONTH(K273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K272<>\"\",K273<>\"\"),IF(E281<=1,1,E281),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H277:H281)-H276+H275,0)","v":0},null,null,{"$f":"IFERROR(SUM(K277:K281)-K276+K275,0)","v":0},null,null,{"$f":"IFERROR(SUM(N277:N281)-N276+N275,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q277:Q281)-Q276+Q275,0)","v":0},null,null,{"$f":"IFERROR(SUM(T277:T281)-T276+T275,0)","v":0},null,null,{"$f":"IFERROR(SUM(W277:W281)-W276+W275,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H283*H284,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K283*K284,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N283*N284,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q283*Q284,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T283*T284,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W283*W284,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H285+H287,0)","v":0},null,null,{"$f":"IFERROR(K285+K287,0)","v":0},null,null,{"$f":"IFERROR(N285+N287,0)","v":0},null,null,{"$f":"IFERROR(Q285+Q287,0)","v":0},null,null,{"$f":"IFERROR(T285+T287,0)","v":0},null,null,{"$f":"IFERROR(W285+W287,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H272)=MONTH(H273),((YEAR(H273)-YEAR(H272))*12)-12+(12-MONTH(H272))+MONTH(H273)-1+(EOMONTH(H272,0)-H272+1)/DAY(EOMONTH(H272,0))+(1-(EOMONTH(H273,0)-H273)/DAY(EOMONTH(H273,0))),((YEAR(H273)-YEAR(H272))*12)-12+(12-MONTH(H272))+MONTH(H273)-1+(EOMONTH(H272,0)-H272+1)/DAY(EOMONTH(H272,0))+(1-(EOMONTH(H273,0)-H273)/DAY(EOMONTH(H273,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H272<>\"\",H273<>\"\"),IF(E290<=1,1,E290),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H289/F290,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K289/F281,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N289/F280,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q289/F279,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T289/F278,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W289/F277,0),2)","v":0}]
[]
[]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E362=0,SAM!E362=\"\"),\"\",SAM!E362)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W297)=MONTH(W298),((YEAR(W298)-YEAR(W297))*12)-12+(12-MONTH(W297))+MONTH(W298)-1+(EOMONTH(W297,0)-W297+1)/DAY(EOMONTH(W297,0))+(1-(EOMONTH(W298,0)-W298)/DAY(EOMONTH(W298,0))),((YEAR(W298)-YEAR(W297))*12)-12+(12-MONTH(W297))+MONTH(W298)-1+(EOMONTH(W297,0)-W297+1)/DAY(EOMONTH(W297,0))+(1-(EOMONTH(W298,0)-W298)/DAY(EOMONTH(W298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W297<>\"\",W298<>\"\"),IF(E302<=1,1,E302),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T297)=MONTH(T298),((YEAR(T298)-YEAR(T297))*12)-12+(12-MONTH(T297))+MONTH(T298)-1+(EOMONTH(T297,0)-T297+1)/DAY(EOMONTH(T297,0))+(1-(EOMONTH(T298,0)-T298)/DAY(EOMONTH(T298,0))),((YEAR(T298)-YEAR(T297))*12)-12+(12-MONTH(T297))+MONTH(T298)-1+(EOMONTH(T297,0)-T297+1)/DAY(EOMONTH(T297,0))+(1-(EOMONTH(T298,0)-T298)/DAY(EOMONTH(T298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T297<>\"\",T298<>\"\"),IF(E303<=1,1,E303),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q297)=MONTH(Q298),((YEAR(Q298)-YEAR(Q297))*12)-12+(12-MONTH(Q297))+MONTH(Q298)-1+(EOMONTH(Q297,0)-Q297+1)/DAY(EOMONTH(Q297,0))+(1-(EOMONTH(Q298,0)-Q298)/DAY(EOMONTH(Q298,0))),((YEAR(Q298)-YEAR(Q297))*12)-12+(12-MONTH(Q297))+MONTH(Q298)-1+(EOMONTH(Q297,0)-Q297+1)/DAY(EOMONTH(Q297,0))+(1-(EOMONTH(Q298,0)-Q298)/DAY(EOMONTH(Q298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q297<>\"\",Q298<>\"\"),IF(E304<=1,1,E304),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N297)=MONTH(N298),((YEAR(N298)-YEAR(N297))*12)-12+(12-MONTH(N297))+MONTH(N298)-1+(EOMONTH(N297,0)-N297+1)/DAY(EOMONTH(N297,0))+(1-(EOMONTH(N298,0)-N298)/DAY(EOMONTH(N298,0))),((YEAR(N298)-YEAR(N297))*12)-12+(12-MONTH(N297))+MONTH(N298)-1+(EOMONTH(N297,0)-N297+1)/DAY(EOMONTH(N297,0))+(1-(EOMONTH(N298,0)-N298)/DAY(EOMONTH(N298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N297<>\"\",N298<>\"\"),IF(E305<=1,1,E305),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K297)=MONTH(K298),((YEAR(K298)-YEAR(K297))*12)-12+(12-MONTH(K297))+MONTH(K298)-1+(EOMONTH(K297,0)-K297+1)/DAY(EOMONTH(K297,0))+(1-(EOMONTH(K298,0)-K298)/DAY(EOMONTH(K298,0))),((YEAR(K298)-YEAR(K297))*12)-12+(12-MONTH(K297))+MONTH(K298)-1+(EOMONTH(K297,0)-K297+1)/DAY(EOMONTH(K297,0))+(1-(EOMONTH(K298,0)-K298)/DAY(EOMONTH(K298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K297<>\"\",K298<>\"\"),IF(E306<=1,1,E306),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H302:H306)-H301+H300,0)","v":0},null,null,{"$f":"IFERROR(SUM(K302:K306)-K301+K300,0)","v":0},null,null,{"$f":"IFERROR(SUM(N302:N306)-N301+N300,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q302:Q306)-Q301+Q300,0)","v":0},null,null,{"$f":"IFERROR(SUM(T302:T306)-T301+T300,0)","v":0},null,null,{"$f":"IFERROR(SUM(W302:W306)-W301+W300,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H308*H309,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K308*K309,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N308*N309,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q308*Q309,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T308*T309,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W308*W309,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H310+H312,0)","v":0},null,null,{"$f":"IFERROR(K310+K312,0)","v":0},null,null,{"$f":"IFERROR(N310+N312,0)","v":0},null,null,{"$f":"IFERROR(Q310+Q312,0)","v":0},null,null,{"$f":"IFERROR(T310+T312,0)","v":0},null,null,{"$f":"IFERROR(W310+W312,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H297)=MONTH(H298),((YEAR(H298)-YEAR(H297))*12)-12+(12-MONTH(H297))+MONTH(H298)-1+(EOMONTH(H297,0)-H297+1)/DAY(EOMONTH(H297,0))+(1-(EOMONTH(H298,0)-H298)/DAY(EOMONTH(H298,0))),((YEAR(H298)-YEAR(H297))*12)-12+(12-MONTH(H297))+MONTH(H298)-1+(EOMONTH(H297,0)-H297+1)/DAY(EOMONTH(H297,0))+(1-(EOMONTH(H298,0)-H298)/DAY(EOMONTH(H298,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H297<>\"\",H298<>\"\"),IF(E315<=1,1,E315),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H314/F315,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K314/F306,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N314/F305,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q314/F304,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T314/F303,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W314/F302,0),2)","v":0}]
[]
[]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E392=0,SAM!E392=\"\"),\"\",SAM!E392)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W322)=MONTH(W323),((YEAR(W323)-YEAR(W322))*12)-12+(12-MONTH(W322))+MONTH(W323)-1+(EOMONTH(W322,0)-W322+1)/DAY(EOMONTH(W322,0))+(1-(EOMONTH(W323,0)-W323)/DAY(EOMONTH(W323,0))),((YEAR(W323)-YEAR(W322))*12)-12+(12-MONTH(W322))+MONTH(W323)-1+(EOMONTH(W322,0)-W322+1)/DAY(EOMONTH(W322,0))+(1-(EOMONTH(W323,0)-W323)/DAY(EOMONTH(W323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W322<>\"\",W323<>\"\"),IF(E327<=1,1,E327),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T322)=MONTH(T323),((YEAR(T323)-YEAR(T322))*12)-12+(12-MONTH(T322))+MONTH(T323)-1+(EOMONTH(T322,0)-T322+1)/DAY(EOMONTH(T322,0))+(1-(EOMONTH(T323,0)-T323)/DAY(EOMONTH(T323,0))),((YEAR(T323)-YEAR(T322))*12)-12+(12-MONTH(T322))+MONTH(T323)-1+(EOMONTH(T322,0)-T322+1)/DAY(EOMONTH(T322,0))+(1-(EOMONTH(T323,0)-T323)/DAY(EOMONTH(T323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T322<>\"\",T323<>\"\"),IF(E328<=1,1,E328),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q322)=MONTH(Q323),((YEAR(Q323)-YEAR(Q322))*12)-12+(12-MONTH(Q322))+MONTH(Q323)-1+(EOMONTH(Q322,0)-Q322+1)/DAY(EOMONTH(Q322,0))+(1-(EOMONTH(Q323,0)-Q323)/DAY(EOMONTH(Q323,0))),((YEAR(Q323)-YEAR(Q322))*12)-12+(12-MONTH(Q322))+MONTH(Q323)-1+(EOMONTH(Q322,0)-Q322+1)/DAY(EOMONTH(Q322,0))+(1-(EOMONTH(Q323,0)-Q323)/DAY(EOMONTH(Q323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q322<>\"\",Q323<>\"\"),IF(E329<=1,1,E329),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N322)=MONTH(N323),((YEAR(N323)-YEAR(N322))*12)-12+(12-MONTH(N322))+MONTH(N323)-1+(EOMONTH(N322,0)-N322+1)/DAY(EOMONTH(N322,0))+(1-(EOMONTH(N323,0)-N323)/DAY(EOMONTH(N323,0))),((YEAR(N323)-YEAR(N322))*12)-12+(12-MONTH(N322))+MONTH(N323)-1+(EOMONTH(N322,0)-N322+1)/DAY(EOMONTH(N322,0))+(1-(EOMONTH(N323,0)-N323)/DAY(EOMONTH(N323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N322<>\"\",N323<>\"\"),IF(E330<=1,1,E330),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K322)=MONTH(K323),((YEAR(K323)-YEAR(K322))*12)-12+(12-MONTH(K322))+MONTH(K323)-1+(EOMONTH(K322,0)-K322+1)/DAY(EOMONTH(K322,0))+(1-(EOMONTH(K323,0)-K323)/DAY(EOMONTH(K323,0))),((YEAR(K323)-YEAR(K322))*12)-12+(12-MONTH(K322))+MONTH(K323)-1+(EOMONTH(K322,0)-K322+1)/DAY(EOMONTH(K322,0))+(1-(EOMONTH(K323,0)-K323)/DAY(EOMONTH(K323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K322<>\"\",K323<>\"\"),IF(E331<=1,1,E331),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H327:H331)-H326+H325,0)","v":0},null,null,{"$f":"IFERROR(SUM(K327:K331)-K326+K325,0)","v":0},null,null,{"$f":"IFERROR(SUM(N327:N331)-N326+N325,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q327:Q331)-Q326+Q325,0)","v":0},null,null,{"$f":"IFERROR(SUM(T327:T331)-T326+T325,0)","v":0},null,null,{"$f":"IFERROR(SUM(W327:W331)-W326+W325,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H333*H334,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K333*K334,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N333*N334,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q333*Q334,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T333*T334,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W333*W334,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H335+H337,0)","v":0},null,null,{"$f":"IFERROR(K335+K337,0)","v":0},null,null,{"$f":"IFERROR(N335+N337,0)","v":0},null,null,{"$f":"IFERROR(Q335+Q337,0)","v":0},null,null,{"$f":"IFERROR(T335+T337,0)","v":0},null,null,{"$f":"IFERROR(W335+W337,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H322)=MONTH(H323),((YEAR(H323)-YEAR(H322))*12)-12+(12-MONTH(H322))+MONTH(H323)-1+(EOMONTH(H322,0)-H322+1)/DAY(EOMONTH(H322,0))+(1-(EOMONTH(H323,0)-H323)/DAY(EOMONTH(H323,0))),((YEAR(H323)-YEAR(H322))*12)-12+(12-MONTH(H322))+MONTH(H323)-1+(EOMONTH(H322,0)-H322+1)/DAY(EOMONTH(H322,0))+(1-(EOMONTH(H323,0)-H323)/DAY(EOMONTH(H323,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H322<>\"\",H323<>\"\"),IF(E340<=1,1,E340),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H339/F340,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K339/F331,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N339/F330,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q339/F329,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T339/F328,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W339/F327,0),2)","v":0}]
[]
[]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E422=0,SAM!E422=\"\"),\"\",SAM!E422)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W347)=MONTH(W348),((YEAR(W348)-YEAR(W347))*12)-12+(12-MONTH(W347))+MONTH(W348)-1+(EOMONTH(W347,0)-W347+1)/DAY(EOMONTH(W347,0))+(1-(EOMONTH(W348,0)-W348)/DAY(EOMONTH(W348,0))),((YEAR(W348)-YEAR(W347))*12)-12+(12-MONTH(W347))+MONTH(W348)-1+(EOMONTH(W347,0)-W347+1)/DAY(EOMONTH(W347,0))+(1-(EOMONTH(W348,0)-W348)/DAY(EOMONTH(W348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W347<>\"\",W348<>\"\"),IF(E352<=1,1,E352),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T347)=MONTH(T348),((YEAR(T348)-YEAR(T347))*12)-12+(12-MONTH(T347))+MONTH(T348)-1+(EOMONTH(T347,0)-T347+1)/DAY(EOMONTH(T347,0))+(1-(EOMONTH(T348,0)-T348)/DAY(EOMONTH(T348,0))),((YEAR(T348)-YEAR(T347))*12)-12+(12-MONTH(T347))+MONTH(T348)-1+(EOMONTH(T347,0)-T347+1)/DAY(EOMONTH(T347,0))+(1-(EOMONTH(T348,0)-T348)/DAY(EOMONTH(T348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T347<>\"\",T348<>\"\"),IF(E353<=1,1,E353),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q347)=MONTH(Q348),((YEAR(Q348)-YEAR(Q347))*12)-12+(12-MONTH(Q347))+MONTH(Q348)-1+(EOMONTH(Q347,0)-Q347+1)/DAY(EOMONTH(Q347,0))+(1-(EOMONTH(Q348,0)-Q348)/DAY(EOMONTH(Q348,0))),((YEAR(Q348)-YEAR(Q347))*12)-12+(12-MONTH(Q347))+MONTH(Q348)-1+(EOMONTH(Q347,0)-Q347+1)/DAY(EOMONTH(Q347,0))+(1-(EOMONTH(Q348,0)-Q348)/DAY(EOMONTH(Q348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q347<>\"\",Q348<>\"\"),IF(E354<=1,1,E354),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N347)=MONTH(N348),((YEAR(N348)-YEAR(N347))*12)-12+(12-MONTH(N347))+MONTH(N348)-1+(EOMONTH(N347,0)-N347+1)/DAY(EOMONTH(N347,0))+(1-(EOMONTH(N348,0)-N348)/DAY(EOMONTH(N348,0))),((YEAR(N348)-YEAR(N347))*12)-12+(12-MONTH(N347))+MONTH(N348)-1+(EOMONTH(N347,0)-N347+1)/DAY(EOMONTH(N347,0))+(1-(EOMONTH(N348,0)-N348)/DAY(EOMONTH(N348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N347<>\"\",N348<>\"\"),IF(E355<=1,1,E355),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K347)=MONTH(K348),((YEAR(K348)-YEAR(K347))*12)-12+(12-MONTH(K347))+MONTH(K348)-1+(EOMONTH(K347,0)-K347+1)/DAY(EOMONTH(K347,0))+(1-(EOMONTH(K348,0)-K348)/DAY(EOMONTH(K348,0))),((YEAR(K348)-YEAR(K347))*12)-12+(12-MONTH(K347))+MONTH(K348)-1+(EOMONTH(K347,0)-K347+1)/DAY(EOMONTH(K347,0))+(1-(EOMONTH(K348,0)-K348)/DAY(EOMONTH(K348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K347<>\"\",K348<>\"\"),IF(E356<=1,1,E356),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H352:H356)-H351+H350,0)","v":0},null,null,{"$f":"IFERROR(SUM(K352:K356)-K351+K350,0)","v":0},null,null,{"$f":"IFERROR(SUM(N352:N356)-N351+N350,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q352:Q356)-Q351+Q350,0)","v":0},null,null,{"$f":"IFERROR(SUM(T352:T356)-T351+T350,0)","v":0},null,null,{"$f":"IFERROR(SUM(W352:W356)-W351+W350,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H358*H359,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K358*K359,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N358*N359,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q358*Q359,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T358*T359,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W358*W359,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H360+H362,0)","v":0},null,null,{"$f":"IFERROR(K360+K362,0)","v":0},null,null,{"$f":"IFERROR(N360+N362,0)","v":0},null,null,{"$f":"IFERROR(Q360+Q362,0)","v":0},null,null,{"$f":"IFERROR(T360+T362,0)","v":0},null,null,{"$f":"IFERROR(W360+W362,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H347)=MONTH(H348),((YEAR(H348)-YEAR(H347))*12)-12+(12-MONTH(H347))+MONTH(H348)-1+(EOMONTH(H347,0)-H347+1)/DAY(EOMONTH(H347,0))+(1-(EOMONTH(H348,0)-H348)/DAY(EOMONTH(H348,0))),((YEAR(H348)-YEAR(H347))*12)-12+(12-MONTH(H347))+MONTH(H348)-1+(EOMONTH(H347,0)-H347+1)/DAY(EOMONTH(H347,0))+(1-(EOMONTH(H348,0)-H348)/DAY(EOMONTH(H348,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H347<>\"\",H348<>\"\"),IF(E365<=1,1,E365),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H364/F365,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K364/F356,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N364/F355,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q364/F354,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T364/F353,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W364/F352,0),2)","v":0}]
[]
[]
[null,"X","S CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E452=0,SAM!E452=\"\"),\"\",SAM!E452)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Net Income:",null,null,"HIDE","HIDE"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W372)=MONTH(W373),((YEAR(W373)-YEAR(W372))*12)-12+(12-MONTH(W372))+MONTH(W373)-1+(EOMONTH(W372,0)-W372+1)/DAY(EOMONTH(W372,0))+(1-(EOMONTH(W373,0)-W373)/DAY(EOMONTH(W373,0))),((YEAR(W373)-YEAR(W372))*12)-12+(12-MONTH(W372))+MONTH(W373)-1+(EOMONTH(W372,0)-W372+1)/DAY(EOMONTH(W372,0))+(1-(EOMONTH(W373,0)-W373)/DAY(EOMONTH(W373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W372<>\"\",W373<>\"\"),IF(E377<=1,1,E377),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T372)=MONTH(T373),((YEAR(T373)-YEAR(T372))*12)-12+(12-MONTH(T372))+MONTH(T373)-1+(EOMONTH(T372,0)-T372+1)/DAY(EOMONTH(T372,0))+(1-(EOMONTH(T373,0)-T373)/DAY(EOMONTH(T373,0))),((YEAR(T373)-YEAR(T372))*12)-12+(12-MONTH(T372))+MONTH(T373)-1+(EOMONTH(T372,0)-T372+1)/DAY(EOMONTH(T372,0))+(1-(EOMONTH(T373,0)-T373)/DAY(EOMONTH(T373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T372<>\"\",T373<>\"\"),IF(E378<=1,1,E378),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q372)=MONTH(Q373),((YEAR(Q373)-YEAR(Q372))*12)-12+(12-MONTH(Q372))+MONTH(Q373)-1+(EOMONTH(Q372,0)-Q372+1)/DAY(EOMONTH(Q372,0))+(1-(EOMONTH(Q373,0)-Q373)/DAY(EOMONTH(Q373,0))),((YEAR(Q373)-YEAR(Q372))*12)-12+(12-MONTH(Q372))+MONTH(Q373)-1+(EOMONTH(Q372,0)-Q372+1)/DAY(EOMONTH(Q372,0))+(1-(EOMONTH(Q373,0)-Q373)/DAY(EOMONTH(Q373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q372<>\"\",Q373<>\"\"),IF(E379<=1,1,E379),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N372)=MONTH(N373),((YEAR(N373)-YEAR(N372))*12)-12+(12-MONTH(N372))+MONTH(N373)-1+(EOMONTH(N372,0)-N372+1)/DAY(EOMONTH(N372,0))+(1-(EOMONTH(N373,0)-N373)/DAY(EOMONTH(N373,0))),((YEAR(N373)-YEAR(N372))*12)-12+(12-MONTH(N372))+MONTH(N373)-1+(EOMONTH(N372,0)-N372+1)/DAY(EOMONTH(N372,0))+(1-(EOMONTH(N373,0)-N373)/DAY(EOMONTH(N373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N372<>\"\",N373<>\"\"),IF(E380<=1,1,E380),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K372)=MONTH(K373),((YEAR(K373)-YEAR(K372))*12)-12+(12-MONTH(K372))+MONTH(K373)-1+(EOMONTH(K372,0)-K372+1)/DAY(EOMONTH(K372,0))+(1-(EOMONTH(K373,0)-K373)/DAY(EOMONTH(K373,0))),((YEAR(K373)-YEAR(K372))*12)-12+(12-MONTH(K372))+MONTH(K373)-1+(EOMONTH(K372,0)-K372+1)/DAY(EOMONTH(K372,0))+(1-(EOMONTH(K373,0)-K373)/DAY(EOMONTH(K373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K372<>\"\",K373<>\"\"),IF(E381<=1,1,E381),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H377:H381)-H376+H375,0)","v":0},null,null,{"$f":"IFERROR(SUM(K377:K381)-K376+K375,0)","v":0},null,null,{"$f":"IFERROR(SUM(N377:N381)-N376+N375,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q377:Q381)-Q376+Q375,0)","v":0},null,null,{"$f":"IFERROR(SUM(T377:T381)-T376+T375,0)","v":0},null,null,{"$f":"IFERROR(SUM(W377:W381)-W376+W375,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Shareholder's Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H383*H384,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K383*K384,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N383*N384,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q383*Q384,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T383*T384,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W383*W384,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H385+H387,0)","v":0},null,null,{"$f":"IFERROR(K385+K387,0)","v":0},null,null,{"$f":"IFERROR(N385+N387,0)","v":0},null,null,{"$f":"IFERROR(Q385+Q387,0)","v":0},null,null,{"$f":"IFERROR(T385+T387,0)","v":0},null,null,{"$f":"IFERROR(W385+W387,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H372)=MONTH(H373),((YEAR(H373)-YEAR(H372))*12)-12+(12-MONTH(H372))+MONTH(H373)-1+(EOMONTH(H372,0)-H372+1)/DAY(EOMONTH(H372,0))+(1-(EOMONTH(H373,0)-H373)/DAY(EOMONTH(H373,0))),((YEAR(H373)-YEAR(H372))*12)-12+(12-MONTH(H372))+MONTH(H373)-1+(EOMONTH(H372,0)-H372+1)/DAY(EOMONTH(H372,0))+(1-(EOMONTH(H373,0)-H373)/DAY(EOMONTH(H373,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H372<>\"\",H373<>\"\"),IF(E390<=1,1,E390),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H389/F390,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K389/F381,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N389/F380,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q389/F379,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T389/F378,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W389/F377,0),2)","v":0}]
[]
[]
[null,"Corporation Cash Flow"]
[null,null,"Use of this information is discretionary.  FOLLOW INVESTOR GUIDELINES."]
[null,"X","CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E484=0,SAM!E484=\"\"),\"\",SAM!E484)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Taxable Income:",null,null,"HIDE","HIDE"]
[null,"Total Tax:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W399)=MONTH(W400),((YEAR(W400)-YEAR(W399))*12)-12+(12-MONTH(W399))+MONTH(W400)-1+(EOMONTH(W399,0)-W399+1)/DAY(EOMONTH(W399,0))+(1-(EOMONTH(W400,0)-W400)/DAY(EOMONTH(W400,0))),((YEAR(W400)-YEAR(W399))*12)-12+(12-MONTH(W399))+MONTH(W400)-1+(EOMONTH(W399,0)-W399+1)/DAY(EOMONTH(W399,0))+(1-(EOMONTH(W400,0)-W400)/DAY(EOMONTH(W400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W399<>\"\",W400<>\"\"),IF(E405<=1,1,E405),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T399)=MONTH(T400),((YEAR(T400)-YEAR(T399))*12)-12+(12-MONTH(T399))+MONTH(T400)-1+(EOMONTH(T399,0)-T399+1)/DAY(EOMONTH(T399,0))+(1-(EOMONTH(T400,0)-T400)/DAY(EOMONTH(T400,0))),((YEAR(T400)-YEAR(T399))*12)-12+(12-MONTH(T399))+MONTH(T400)-1+(EOMONTH(T399,0)-T399+1)/DAY(EOMONTH(T399,0))+(1-(EOMONTH(T400,0)-T400)/DAY(EOMONTH(T400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T399<>\"\",T400<>\"\"),IF(E406<=1,1,E406),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q399)=MONTH(Q400),((YEAR(Q400)-YEAR(Q399))*12)-12+(12-MONTH(Q399))+MONTH(Q400)-1+(EOMONTH(Q399,0)-Q399+1)/DAY(EOMONTH(Q399,0))+(1-(EOMONTH(Q400,0)-Q400)/DAY(EOMONTH(Q400,0))),((YEAR(Q400)-YEAR(Q399))*12)-12+(12-MONTH(Q399))+MONTH(Q400)-1+(EOMONTH(Q399,0)-Q399+1)/DAY(EOMONTH(Q399,0))+(1-(EOMONTH(Q400,0)-Q400)/DAY(EOMONTH(Q400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q399<>\"\",Q400<>\"\"),IF(E407<=1,1,E407),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N399)=MONTH(N400),((YEAR(N400)-YEAR(N399))*12)-12+(12-MONTH(N399))+MONTH(N400)-1+(EOMONTH(N399,0)-N399+1)/DAY(EOMONTH(N399,0))+(1-(EOMONTH(N400,0)-N400)/DAY(EOMONTH(N400,0))),((YEAR(N400)-YEAR(N399))*12)-12+(12-MONTH(N399))+MONTH(N400)-1+(EOMONTH(N399,0)-N399+1)/DAY(EOMONTH(N399,0))+(1-(EOMONTH(N400,0)-N400)/DAY(EOMONTH(N400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N399<>\"\",N400<>\"\"),IF(E408<=1,1,E408),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K399)=MONTH(K400),((YEAR(K400)-YEAR(K399))*12)-12+(12-MONTH(K399))+MONTH(K400)-1+(EOMONTH(K399,0)-K399+1)/DAY(EOMONTH(K399,0))+(1-(EOMONTH(K400,0)-K400)/DAY(EOMONTH(K400,0))),((YEAR(K400)-YEAR(K399))*12)-12+(12-MONTH(K399))+MONTH(K400)-1+(EOMONTH(K399,0)-K399+1)/DAY(EOMONTH(K399,0))+(1-(EOMONTH(K400,0)-K400)/DAY(EOMONTH(K400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K399<>\"\",K400<>\"\"),IF(E409<=1,1,E409),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H405:H409)-H403-H404+H402,0)","v":0},null,null,{"$f":"IFERROR(SUM(K405:K409)-K403-K404+K402,0)","v":0},null,null,{"$f":"IFERROR(SUM(N405:N409)-N403-N404+N402,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q405:Q409)-Q403-Q404+Q402,0)","v":0},null,null,{"$f":"IFERROR(SUM(T405:T409)-T403-T404+T402,0)","v":0},null,null,{"$f":"IFERROR(SUM(W405:W409)-W403-W404+W402,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Corporation's Total Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H411*H412,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K411*K412,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N411*N412,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q411*Q412,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T411*T412,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W411*W412,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H413+H415,0)","v":0},null,null,{"$f":"IFERROR(K413+K415,0)","v":0},null,null,{"$f":"IFERROR(N413+N415,0)","v":0},null,null,{"$f":"IFERROR(Q413+Q415,0)","v":0},null,null,{"$f":"IFERROR(T413+T415,0)","v":0},null,null,{"$f":"IFERROR(W413+W415,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H399)=MONTH(H400),((YEAR(H400)-YEAR(H399))*12)-12+(12-MONTH(H399))+MONTH(H400)-1+(EOMONTH(H399,0)-H399+1)/DAY(EOMONTH(H399,0))+(1-(EOMONTH(H400,0)-H400)/DAY(EOMONTH(H400,0))),((YEAR(H400)-YEAR(H399))*12)-12+(12-MONTH(H399))+MONTH(H400)-1+(EOMONTH(H399,0)-H399+1)/DAY(EOMONTH(H399,0))+(1-(EOMONTH(H400,0)-H400)/DAY(EOMONTH(H400,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H399<>\"\",H400<>\"\"),IF(E418<=1,1,E418),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H417/F418,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K417/F409,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N417/F408,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q417/F407,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T417/F406,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W417/F405,0),2)","v":0}]
[]
[]
[null,"X","CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E511=0,SAM!E511=\"\"),\"\",SAM!E511)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Taxable Income:",null,null,"HIDE","HIDE"]
[null,"Total Tax:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W425)=MONTH(W426),((YEAR(W426)-YEAR(W425))*12)-12+(12-MONTH(W425))+MONTH(W426)-1+(EOMONTH(W425,0)-W425+1)/DAY(EOMONTH(W425,0))+(1-(EOMONTH(W426,0)-W426)/DAY(EOMONTH(W426,0))),((YEAR(W426)-YEAR(W425))*12)-12+(12-MONTH(W425))+MONTH(W426)-1+(EOMONTH(W425,0)-W425+1)/DAY(EOMONTH(W425,0))+(1-(EOMONTH(W426,0)-W426)/DAY(EOMONTH(W426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W425<>\"\",W426<>\"\"),IF(E431<=1,1,E431),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T425)=MONTH(T426),((YEAR(T426)-YEAR(T425))*12)-12+(12-MONTH(T425))+MONTH(T426)-1+(EOMONTH(T425,0)-T425+1)/DAY(EOMONTH(T425,0))+(1-(EOMONTH(T426,0)-T426)/DAY(EOMONTH(T426,0))),((YEAR(T426)-YEAR(T425))*12)-12+(12-MONTH(T425))+MONTH(T426)-1+(EOMONTH(T425,0)-T425+1)/DAY(EOMONTH(T425,0))+(1-(EOMONTH(T426,0)-T426)/DAY(EOMONTH(T426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T425<>\"\",T426<>\"\"),IF(E432<=1,1,E432),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q425)=MONTH(Q426),((YEAR(Q426)-YEAR(Q425))*12)-12+(12-MONTH(Q425))+MONTH(Q426)-1+(EOMONTH(Q425,0)-Q425+1)/DAY(EOMONTH(Q425,0))+(1-(EOMONTH(Q426,0)-Q426)/DAY(EOMONTH(Q426,0))),((YEAR(Q426)-YEAR(Q425))*12)-12+(12-MONTH(Q425))+MONTH(Q426)-1+(EOMONTH(Q425,0)-Q425+1)/DAY(EOMONTH(Q425,0))+(1-(EOMONTH(Q426,0)-Q426)/DAY(EOMONTH(Q426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q425<>\"\",Q426<>\"\"),IF(E433<=1,1,E433),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N425)=MONTH(N426),((YEAR(N426)-YEAR(N425))*12)-12+(12-MONTH(N425))+MONTH(N426)-1+(EOMONTH(N425,0)-N425+1)/DAY(EOMONTH(N425,0))+(1-(EOMONTH(N426,0)-N426)/DAY(EOMONTH(N426,0))),((YEAR(N426)-YEAR(N425))*12)-12+(12-MONTH(N425))+MONTH(N426)-1+(EOMONTH(N425,0)-N425+1)/DAY(EOMONTH(N425,0))+(1-(EOMONTH(N426,0)-N426)/DAY(EOMONTH(N426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N425<>\"\",N426<>\"\"),IF(E434<=1,1,E434),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K425)=MONTH(K426),((YEAR(K426)-YEAR(K425))*12)-12+(12-MONTH(K425))+MONTH(K426)-1+(EOMONTH(K425,0)-K425+1)/DAY(EOMONTH(K425,0))+(1-(EOMONTH(K426,0)-K426)/DAY(EOMONTH(K426,0))),((YEAR(K426)-YEAR(K425))*12)-12+(12-MONTH(K425))+MONTH(K426)-1+(EOMONTH(K425,0)-K425+1)/DAY(EOMONTH(K425,0))+(1-(EOMONTH(K426,0)-K426)/DAY(EOMONTH(K426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K425<>\"\",K426<>\"\"),IF(E435<=1,1,E435),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H431:H435)-H429-H430+H428,0)","v":0},null,null,{"$f":"IFERROR(SUM(K431:K435)-K429-K430+K428,0)","v":0},null,null,{"$f":"IFERROR(SUM(N431:N435)-N429-N430+N428,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q431:Q435)-Q429-Q430+Q428,0)","v":0},null,null,{"$f":"IFERROR(SUM(T431:T435)-T429-T430+T428,0)","v":0},null,null,{"$f":"IFERROR(SUM(W431:W435)-W429-W430+W428,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Corporation's Total Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H437*H438,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K437*K438,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N437*N438,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q437*Q438,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T437*T438,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W437*W438,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H439+H441,0)","v":0},null,null,{"$f":"IFERROR(K439+K441,0)","v":0},null,null,{"$f":"IFERROR(N439+N441,0)","v":0},null,null,{"$f":"IFERROR(Q439+Q441,0)","v":0},null,null,{"$f":"IFERROR(T439+T441,0)","v":0},null,null,{"$f":"IFERROR(W439+W441,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H425)=MONTH(H426),((YEAR(H426)-YEAR(H425))*12)-12+(12-MONTH(H425))+MONTH(H426)-1+(EOMONTH(H425,0)-H425+1)/DAY(EOMONTH(H425,0))+(1-(EOMONTH(H426,0)-H426)/DAY(EOMONTH(H426,0))),((YEAR(H426)-YEAR(H425))*12)-12+(12-MONTH(H425))+MONTH(H426)-1+(EOMONTH(H425,0)-H425+1)/DAY(EOMONTH(H425,0))+(1-(EOMONTH(H426,0)-H426)/DAY(EOMONTH(H426,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H425<>\"\",H426<>\"\"),IF(E444<=1,1,E444),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H443/F444,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K443/F435,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N443/F434,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q443/F433,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T443/F432,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W443/F431,0),2)","v":0}]
[]
[]
[null,"X","CORPORATION",null,null,null,{"$f":"IF(OR(SAM!E538=0,SAM!E538=\"\"),\"\",SAM!E538)","v":""}]
[]
[null,null,null,"Time Frame (i.e., YTD, quarterly):",null,null,"M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M","M",null,"M"]
[]
[null,null,null,"Date From:","HIDE","HIDE"]
[null,null,null,"Date Paid Through:","HIDE","HIDE"]
[null,null,null,null,"HIDE","HIDE"]
[null,"Taxable Income:",null,null,"HIDE","HIDE"]
[null,"Total Tax:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Deduct nonrecurring income:",null,null,"HIDE","HIDE","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")","(",null,")"]
[null,"Add nonrecurring loss:",null,null,{"$f":"IF(MONTH(W451)=MONTH(W452),((YEAR(W452)-YEAR(W451))*12)-12+(12-MONTH(W451))+MONTH(W452)-1+(EOMONTH(W451,0)-W451+1)/DAY(EOMONTH(W451,0))+(1-(EOMONTH(W452,0)-W452)/DAY(EOMONTH(W452,0))),((YEAR(W452)-YEAR(W451))*12)-12+(12-MONTH(W451))+MONTH(W452)-1+(EOMONTH(W451,0)-W451+1)/DAY(EOMONTH(W451,0))+(1-(EOMONTH(W452,0)-W452)/DAY(EOMONTH(W452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(W451<>\"\",W452<>\"\"),IF(E457<=1,1,E457),0),2)","v":0}]
[null,"Depreciation:",null,null,{"$f":"IF(MONTH(T451)=MONTH(T452),((YEAR(T452)-YEAR(T451))*12)-12+(12-MONTH(T451))+MONTH(T452)-1+(EOMONTH(T451,0)-T451+1)/DAY(EOMONTH(T451,0))+(1-(EOMONTH(T452,0)-T452)/DAY(EOMONTH(T452,0))),((YEAR(T452)-YEAR(T451))*12)-12+(12-MONTH(T451))+MONTH(T452)-1+(EOMONTH(T451,0)-T451+1)/DAY(EOMONTH(T451,0))+(1-(EOMONTH(T452,0)-T452)/DAY(EOMONTH(T452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(T451<>\"\",T452<>\"\"),IF(E458<=1,1,E458),0),2)","v":0}]
[null,"Depletion:",null,null,{"$f":"IF(MONTH(Q451)=MONTH(Q452),((YEAR(Q452)-YEAR(Q451))*12)-12+(12-MONTH(Q451))+MONTH(Q452)-1+(EOMONTH(Q451,0)-Q451+1)/DAY(EOMONTH(Q451,0))+(1-(EOMONTH(Q452,0)-Q452)/DAY(EOMONTH(Q452,0))),((YEAR(Q452)-YEAR(Q451))*12)-12+(12-MONTH(Q451))+MONTH(Q452)-1+(EOMONTH(Q451,0)-Q451+1)/DAY(EOMONTH(Q451,0))+(1-(EOMONTH(Q452,0)-Q452)/DAY(EOMONTH(Q452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(Q451<>\"\",Q452<>\"\"),IF(E459<=1,1,E459),0),2)","v":0}]
[null,"Amortization/Casualty Loss:",null,null,{"$f":"IF(MONTH(N451)=MONTH(N452),((YEAR(N452)-YEAR(N451))*12)-12+(12-MONTH(N451))+MONTH(N452)-1+(EOMONTH(N451,0)-N451+1)/DAY(EOMONTH(N451,0))+(1-(EOMONTH(N452,0)-N452)/DAY(EOMONTH(N452,0))),((YEAR(N452)-YEAR(N451))*12)-12+(12-MONTH(N451))+MONTH(N452)-1+(EOMONTH(N451,0)-N451+1)/DAY(EOMONTH(N451,0))+(1-(EOMONTH(N452,0)-N452)/DAY(EOMONTH(N452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(N451<>\"\",N452<>\"\"),IF(E460<=1,1,E460),0),2)","v":0}]
[null,"Other:",null,null,{"$f":"IF(MONTH(K451)=MONTH(K452),((YEAR(K452)-YEAR(K451))*12)-12+(12-MONTH(K451))+MONTH(K452)-1+(EOMONTH(K451,0)-K451+1)/DAY(EOMONTH(K451,0))+(1-(EOMONTH(K452,0)-K452)/DAY(EOMONTH(K452,0))),((YEAR(K452)-YEAR(K451))*12)-12+(12-MONTH(K451))+MONTH(K452)-1+(EOMONTH(K451,0)-K451+1)/DAY(EOMONTH(K451,0))+(1-(EOMONTH(K452,0)-K452)/DAY(EOMONTH(K452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(K451<>\"\",K452<>\"\"),IF(E461<=1,1,E461),0),2)","v":0},"M"]
[null,null,null,null,"HIDE","HIDE"]
[null,"SUBTOTAL",null,null,null,null,null,{"$f":"IFERROR(SUM(H457:H461)-H455-H456+H454,0)","v":0},null,null,{"$f":"IFERROR(SUM(K457:K461)-K455-K456+K454,0)","v":0},null,null,{"$f":"IFERROR(SUM(N457:N461)-N455-N456+N454,0)","v":0},null,null,{"$f":"IFERROR(SUM(Q457:Q461)-Q455-Q456+Q454,0)","v":0},null,null,{"$f":"IFERROR(SUM(T457:T461)-T455-T456+T454,0)","v":0},null,null,{"$f":"IFERROR(SUM(W457:W461)-W455-W456+W454,0)","v":0}]
[null,"Multiplied by Ownership Percentage:"]
[null,"Corporation's Total Share of Income (Loss):",null,null,null,null,null,{"$f":"ROUND(IFERROR(H463*H464,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K463*K464,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N463*N464,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q463*Q464,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T463*T464,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W463*W464,0),2)","v":0}]
[]
[null,"Wages:"]
[]
[null,null,null,"Total Income:","HIDE","HIDE",null,{"$f":"IFERROR(H465+H467,0)","v":0},null,null,{"$f":"IFERROR(K465+K467,0)","v":0},null,null,{"$f":"IFERROR(N465+N467,0)","v":0},null,null,{"$f":"IFERROR(Q465+Q467,0)","v":0},null,null,{"$f":"IFERROR(T465+T467,0)","v":0},null,null,{"$f":"IFERROR(W465+W467,0)","v":0}]
[null,null,null,"Monthly Income:",{"$f":"IF(MONTH(H451)=MONTH(H452),((YEAR(H452)-YEAR(H451))*12)-12+(12-MONTH(H451))+MONTH(H452)-1+(EOMONTH(H451,0)-H451+1)/DAY(EOMONTH(H451,0))+(1-(EOMONTH(H452,0)-H452)/DAY(EOMONTH(H452,0))),((YEAR(H452)-YEAR(H451))*12)-12+(12-MONTH(H451))+MONTH(H452)-1+(EOMONTH(H451,0)-H451+1)/DAY(EOMONTH(H451,0))+(1-(EOMONTH(H452,0)-H452)/DAY(EOMONTH(H452,0))))","v":3.2258064516129004E-2},{"$f":"ROUND(IF(AND(H451<>\"\",H452<>\"\"),IF(E470<=1,1,E470),0),2)","v":0},null,{"$f":"ROUND(IFERROR(H469/F470,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(K469/F461,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(N469/F460,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(Q469/F459,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(T469/F458,0),2)","v":0},null,null,{"$f":"ROUND(IFERROR(W469/F457,0),2)","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,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,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,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,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,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,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,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,null,null,null,null,null,null,null,null,null,null,null,null,"M","M"]

{"sheet":"_SUMM_ROWS_LKP_YTD_","index":2,"n_rows":21,"n_cols":13,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["SUMM_ROW","DATA_ROW","L","TITLE","SECTION","iMyRefRow","iSummRefRow","strMyDataCols","iThisRow","strMyDataRows","strMyExtra","strDefFormRef","strDefFormula"]
[1,false,"p.1","PERSONAL CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA","NA","NA"]
[2,true,"IV","Sole Proprietorship",1,7,7,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13","D13","G0","=IF(OR(SAM!D17=0,SAM!D17=\"\"),\"\",SAM!D17)"]
[3,true,"IV","Sole Proprietorship",1,26,26,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13","D13","G0","=IF(OR(SAM!D32=0,SAM!D32=\"\"),\"\",SAM!D32)"]
[4,true,"IV","Sole Proprietorship",1,45,45,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13","D13","G0","=IF(OR(SAM!D47=0,SAM!D47=\"\"),\"\",SAM!D47)"]
[5,true,"IV","Sole Proprietorship",1,64,64,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13","D13","G0","=IF(OR(SAM!D62=0,SAM!D62=\"\"),\"\",SAM!D62)"]
[6,true,"IV","Partnership",1,85,85,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E108=0,SAM!E108=\"\"),\"\",SAM!E108)"]
[7,true,"IV","Partnership",1,111,111,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E140=0,SAM!E140=\"\"),\"\",SAM!E140)"]
[8,true,"IV","Partnership",1,137,137,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E172=0,SAM!E172=\"\"),\"\",SAM!E172)"]
[9,true,"IV","Partnership",1,163,163,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E204=0,SAM!E204=\"\"),\"\",SAM!E204)"]
[10,true,"IV","Partnership",1,189,189,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E236=0,SAM!E236=\"\"),\"\",SAM!E236)"]
[11,true,"IV","Partnership",1,215,215,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19,20","D13","G0","=IF(OR(SAM!E268=0,SAM!E268=\"\"),\"\",SAM!E268)"]
[12,true,"IV","S Corporation",1,243,243,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E302=0,SAM!E302=\"\"),\"\",SAM!E302)"]
[13,true,"IV","S Corporation",1,268,268,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E332=0,SAM!E332=\"\"),\"\",SAM!E332)"]
[14,true,"IV","S Corporation",1,293,293,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E362=0,SAM!E362=\"\"),\"\",SAM!E362)"]
[15,true,"IV","S Corporation",1,318,318,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E392=0,SAM!E392=\"\"),\"\",SAM!E392)"]
[16,true,"IV","S Corporation",1,343,343,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E422=0,SAM!E422=\"\"),\"\",SAM!E422)"]
[17,true,"IV","S Corporation",1,368,368,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,16,19","D13","G0","=IF(OR(SAM!E452=0,SAM!E452=\"\"),\"\",SAM!E452)"]
[18,true,"IV","Corporation",1,395,395,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,14,17,20","D13","G0","=IF(OR(SAM!E484=0,SAM!E484=\"\"),\"\",SAM!E484)"]
[19,true,"IV","Corporation",1,421,421,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,14,17,20","D13","G0","=IF(OR(SAM!E511=0,SAM!E511=\"\"),\"\",SAM!E511)"]
[20,true,"IV","Corporation",1,447,447,"H,K,N,Q,T,W","NONE","2,4,5,7,8,9,10,11,12,13,14,17,20","D13","G0","=IF(OR(SAM!E538=0,SAM!E538=\"\"),\"\",SAM!E538)"]

{"sheet":"_SUMM_ROWS_LKP_","index":3,"n_rows":70,"n_cols":15,"rows_kept":70,"cut":false,"hidden":true,"merged":[]}
["SUMM_ROW","DATA_ROW","L","TITLE","SECTION","iMyRefRow","iSummRefRow","strMyDataCols","iThisRow","strMyDataRows","strMyExtra","colsElements","dataElements","plus","total"]
[572,false,"p.1","PERSONAL CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA",0,0,0,0]
[{"$f":"A2+2","v":574},true,"IV","Schedule B",1,7,{"$f":"F3","v":7},"H,K","NONE","2,3","NONE",{"$f":"NumElements(H3,\",\")","v":2},{"$f":"NumElements(J3,\",\")","v":2},{"$f":"IF(NOT(OR(K3=\"NONE\",K3=\"NA\")),1,0)","v":0},{"$f":"(L3*M3)+N3","v":4}]
[{"$f":"A3+1","v":575},true,"V","Schedule C   ",1,15,{"$f":"F4+2","v":17},"H,K","NONE","2,3,4,5,6,7,8,11","D0",{"$f":"NumElements(H4,\",\")","v":2},{"$f":"NumElements(J4,\",\")","v":8},{"$f":"IF(NOT(OR(K4=\"NONE\",K4=\"NA\")),1,0)","v":1},{"$f":"(L4*M4)+N4","v":17}]
[576,true,"V","Schedule C   ",2,15,{"$f":"F5+17","v":32},"H,K","NONE","2,3,4,5,6,7,8,11","D0",2,8,1,17]
[577,true,"V","Schedule C   ",3,15,{"$f":"F6+32","v":47},"H,K","NONE","2,3,4,5,6,7,8,11","D0",2,8,1,17]
[578,true,"V","Schedule C   ",4,15,{"$f":"F7+47","v":62},"H,K","NONE","2,3,4,5,6,7,8,11","D0",2,8,1,17]
[579,true,"VI","Schedule D",1,78,{"$f":"F8","v":78},"H,K","NONE",2,"NONE",2,1,0,2]
[580,true,"VIII","Schedule E",1,85,{"$f":"F9","v":85},"H,K","NONE","2,3,4","NONE",2,3,0,6]
[581,true,"IX","Schedule F",1,94,{"$f":"F10","v":94},"H,K","NONE","2,3,4,5,6,7","NONE",2,6,0,12]
[582,false,"p.2","PARTNERSHIP & S CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA",1,1,0,1]
[583,true,"X","K-1 (Form 1065)   ",1,108,{"$f":"F12","v":108},"H,K","NONE","4,5,6","E0",2,3,1,7]
[584,true,"X","W-2 Wages",1,108,108,"H,K","NONE",12,"E0",2,1,1,3]
[585,true,"XI","Form 1065   ",1,108,{"$f":"F14","v":108},"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[586,true,"NA","Partnership Subtotal",1,108,108,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[587,true,"X","K-1 (Form 1065)   ",1,140,140,"H,K","NONE","4,5,6","E0",2,3,1,7]
[588,true,"X","W-2 Wages",1,140,140,"H,K","NONE",12,"E0",2,1,1,3]
[589,true,"XI","Form 1065   ",1,140,140,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[590,true,"NA","Partnership Subtotal",1,140,140,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[591,true,"X","K-1 (Form 1065)   ",1,172,172,"H,K","NONE","4,5,6","E0",2,3,1,7]
[592,true,"X","W-2 Wages",1,172,172,"H,K","NONE",12,"E0",2,1,1,3]
[593,true,"XI","Form 1065   ",1,172,172,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[594,true,"NA","Partnership Subtotal",1,172,172,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[595,true,"X","K-1 (Form 1065)   ",1,204,204,"H,K","NONE","4,5,6","E0",2,3,1,7]
[596,true,"X","W-2 Wages",1,204,204,"H,K","NONE",12,"E0",2,1,1,3]
[597,true,"XI","Form 1065   ",1,204,204,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[598,true,"NA","Partnership Subtotal",1,204,204,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[599,true,"X","K-1 (Form 1065)   ",1,236,236,"H,K","NONE","4,5,6","E0",2,3,1,7]
[600,true,"X","W-2 Wages",1,236,236,"H,K","NONE",12,"E0",2,1,1,3]
[601,true,"XI","Form 1065   ",1,236,236,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[602,true,"NA","Partnership Subtotal",1,236,236,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[603,true,"X","K-1 (Form 1065)   ",1,268,268,"H,K","NONE","4,5,6","E0",2,3,1,7]
[604,true,"X","W-2 Wages",1,268,268,"H,K","NONE",12,"E0",2,1,1,3]
[605,true,"XI","Form 1065   ",1,268,268,"H,K","NONE","16,17,18,19,20,21,22,23,27","E0",2,9,1,19]
[606,true,"NA","Partnership Subtotal",1,268,268,"H,K","NONE","4,5,6,12,16,17,18,19,20,21,22,23,27","NONE",2,13,0,26]
[607,true,"X","K-1",1,302,302,"H,K","NONE","4,5","E0",2,2,1,5]
[608,true,"XI","W2 Wages",1,302,302,"H,K","NONE",11,"E0",2,1,1,3]
[609,true,"XI","Form 1120S",1,302,302,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[610,true,"NA","S Corporation Subtotal",1,302,302,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[611,true,"X","K-1",1,332,332,"H,K","NONE","4,5","E0",2,2,1,5]
[612,true,"XI","W2 Wages",1,332,332,"H,K","NONE",11,"E0",2,1,1,3]
[613,true,"XI","Form 1120S",1,332,332,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[614,true,"NA","S Corporation Subtotal",1,332,332,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[615,true,"X","K-1",1,362,362,"H,K","NONE","4,5","E0",2,2,1,5]
[616,true,"XI","W2 Wages",1,362,362,"H,K","NONE",11,"E0",2,1,1,3]
[617,true,"XI","Form 1120S",1,362,362,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[618,true,"NA","S Corporation Subtotal",1,362,362,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[619,true,"X","K-1",1,392,392,"H,K","NONE","4,5","E0",2,2,1,5]
[620,true,"XI","W2 Wages",1,392,392,"H,K","NONE",11,"E0",2,1,1,3]
[621,true,"XI","Form 1120S",1,392,392,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[622,true,"NA","S Corporation Subtotal",1,392,392,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[623,true,"X","K-1",1,422,422,"H,K","NONE","4,5","E0",2,2,1,5]
[624,true,"XI","W2 Wages",1,422,422,"H,K","NONE",11,"E0",2,1,1,3]
[625,true,"XI","Form 1120S",1,422,422,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[626,true,"NA","S Corporation Subtotal",1,422,422,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[627,true,"X","K-1",1,452,452,"H,K","NONE","4,5","E0",2,2,1,5]
[628,true,"XI","W2 Wages",1,452,452,"H,K","NONE",11,"E0",2,1,1,3]
[629,true,"XI","Form 1120S",1,452,452,"H,K","NONE","15,16,17,18,19,20,21,25","E0",2,8,1,17]
[630,true,"NA","S Corporation Subtotal",1,452,452,"H,K","NONE","4,5,11,15,16,17,18,19,20,21,25","E0",2,11,1,23]
[631,false,"p.3","CORPORATION CASH FLOW SUBTOTALS:","NA","NA","NA","NA","NA","NA","NA",1,1,0,1]
[632,true,"XIV","W2 Wages",1,484,{"$f":"F61","v":484},"H,K","NONE",4,"E0",2,1,1,3]
[633,true,"XIV","Form 1120S",1,484,{"$f":"F62","v":484},"H,K","NONE","8,9,10,11,12,13,14,15,16,17,21,22","E0",2,12,1,25]
[634,true,"XIV","S Corporation Subtotal",1,484,484,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,21,22","E0",2,13,1,27]
[635,true,"XIV","W2 Wages",1,511,511,"H,K","NONE",4,"E0",2,1,1,3]
[636,true,"XIV","Form 1120S",1,511,511,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,21,22","E0",2,12,1,25]
[637,true,"XIV","S Corporation Subtotal",1,511,511,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,21,22","E0",2,13,1,27]
[638,true,"XIV","W2 Wages",1,538,538,"H,K","NONE",4,"E0",2,1,1,3]
[639,true,"XIV","Form 1120S",1,538,538,"H,K","NONE","8,9,10,11,12,13,14,15,16,17,21,22","E0",{"$f":"NumElements(H68,\",\")","v":2},{"$f":"NumElements(J68,\",\")","v":12},{"$f":"IF(NOT(OR(K68=\"NONE\",K68=\"NA\")),1,0)","v":1},{"$f":"(L68*M68)+N68","v":25}]
[640,true,"XIV","S Corporation Subtotal",1,538,538,"H,K","NONE","4,8,9,10,11,12,13,14,15,16,17,21,22","E0",2,13,1,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O2:O69)","v":877}]

{"sheet":"_HYPER_LKP_NEW_","index":4,"n_rows":57,"n_cols":10,"rows_kept":57,"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","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/22-25000_sam_worksheet_help_doc-2021.pdf"]
[2,null,"B",2,"Recurring Dividend Income","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[3,"Schedule C","B",3,"Net Profit","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit",{"$f":"G4&H4&LEFT(F4,5)&\"=\"&RIGHT(F4,LEN(F4)-5)&\"&\"&I4","v":"https://www.mgic.com/-/media/value-adds/seb/22-25000-sam-worksheet-help-doc.pdf#page=3&view=fit"}]
[4,null,"B",4,"Deduct nonrecurring income","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[5,null,"B",5,"Depletion","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[6,null,"B",6,"Depreciation","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[7,null,"B",7,"Meals or Meals and Entertainment","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[8,null,"B",8,"Business Use of Home","#page3","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[9,null,"B",9,"Business Miles","#page4","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[10,null,"B","10a","x Depreciation Rate","#page4","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[11,null,"B","10b","Total Mileage Depreciation","#page4","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[12,null,"B",11,"Amortization/Casualty Loss","#page4","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[13,"Schedule D","B",12,"Recurring Capital Gains (Loss)","#page5","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[14,"Schedule E","B",13,"Royalty Income (Loss)","#page6","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[15,null,"B",14,"Total Expenses","#page6","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[16,null,"B",15,"Depletion","#page6","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[17,"Schedule F","B",16,"Net Profit (Loss)","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[18,null,"B",17,"Non-Tax Portion","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[19,null,"B",18,"Deduct nonrecurring income","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[20,null,"B",19,"Depreciation","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[21,null,"B",20,"Amortization/Casualty Loss","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[22,null,"B",21,"Business Use of Home","#page7","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[23,"Partnership","B",22,"Ordinary Income (Loss)","#page8","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[24,null,"B",23,"Net Rental Income (Loss)","#page8","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[25,null,"B",24,"Guaranteed Payments","#page8","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[26,null,"B",25,"Wages","#page8","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[27,null,"B",26,"Passthrough","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[28,null,"B",27,"Deduct nonrecurring income","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[29,null,"B",28,"Depreciation: LINE 16c ","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[30,null,"B",29,"Depreciation (Form 8825)","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[31,null,"B",30,"Depletion","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[32,null,"B",31,"Amortization/Casualty Loss","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[33,null,"B",32,"Mortgages or Notes Payable","#page9","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[34,null,"B",33,"Travel and Entertainment","#page10","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[35,"S Corporation","B",35,"Ordinary Income (Loss)","#page11","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[36,null,"B",36,"Net Rental Income (Loss)","#page11","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[37,null,"B",37,"Wages","#page11","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[38,null,"B",38,"Deduct nonrecurring income","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[39,null,"B",39,"Depreciation: LINE 14","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[40,null,"B",40,"Depreciation (FORM 8825): LINE 14","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[41,null,"B",41,"Depletion","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[42,null,"B",42,"Amortization/Casualty Loss","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[43,null,"B",43,"Mortgages or Notes Payable","#page12","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[44,null,"B",44,"Travel and Entertainment","#page13","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[45,"Corporation","B",46,"Wages","#page14","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[46,null,"B",47,"Taxable Income","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[47,null,"B",48,"Total Tax","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[48,null,"B",49,"Deduct nonrecurring income","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[49,null,"B",50,"Deduct nonrecurring income","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[50,null,"B",51,"Depreciation ","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[51,null,"B",52,"Depletion","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[52,null,"B",53,"Amortization/Casualty Loss","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[53,null,"B",54,"Net Operating Loss and Special Deductions","#page15","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[54,null,"B",55,"Mortgages or Notes Payable","#page16","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]
[55,null,"B",56,"Travel and Entertainment","#page16","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit",{"$f":"G56&H56&LEFT(F56,5)&\"=\"&RIGHT(F56,LEN(F56)-5)&\"&\"&I56","v":"https://www.mgic.com/-/media/value-adds/seb/22-25000-sam-worksheet-help-doc.pdf#page=16&view=fit"}]
[56,null,"B",58,"Dividends Paid to Borrower","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25000-sam-worksheet-help-doc.pdf","view=fit"]

{"sheet":"__NOTES__","index":5,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[null,"DATE","NOTES_BY","NOTE"]
[1,"20220206_1955","Brian J. Torreano (BT)","For updates to hyperlinks on the SAM worksheet, open the '_HYPER_LKP_NEW_' worksheet and update the document, page numbers and links.  This updates the links throughout the SAM page.  After hyperlinks have been fixed, run the 'URLSetScreenTips' macro to update the screentips."]

{"sheet":"LOOKUPS","index":6,"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,2020,0.27,0,true,true]
[null,2021,0.26,1]
[null,2022,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":"SANDBOX","index":7,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,"1/1/2021",null,{"$f":"IF(IFERROR(SEARCH(\"/\",G5),-1)=-1,\"FALSE\",\"TRUE\")","v":"TRUE"},null,{"$f":"IF(IFERROR(SEARCH(\"-\",G5),-1)=-1,\"FALSE\",\"TRUE\")","v":"FALSE"},null,{"$f":"IF(OR(NOT(IFERROR(SEARCH(\"/\",G5),-1)=-1),NOT(IFERROR(SEARCH(\"-\",G5),-1)=-1)),\"TRUE\",\"FALSE\")","v":"TRUE"}]
[null,null,null,null,null,null,"1-1-2021",null,{"$f":"IF(IFERROR(SEARCH(\"/\",G6),-1)=-1,\"FALSE\",\"TRUE\")","v":"FALSE"},null,{"$f":"IF(IFERROR(SEARCH(\"-\",G6),-1)=-1,\"FALSE\",\"TRUE\")","v":"TRUE"},null,{"$f":"IF(OR(NOT(IFERROR(SEARCH(\"/\",G6),-1)=-1),NOT(IFERROR(SEARCH(\"-\",G6),-1)=-1)),\"TRUE\",\"FALSE\")","v":"TRUE"}]
[null,null,null,null,null,null,"1.1.2021",null,"FALSE",null,"FALSE",null,"FALSE"]
[null,null,null,null,null,null,"1/1-2021",null,{"$f":"IF(IFERROR(SEARCH(\"/\",G8),-1)=-1,\"FALSE\",\"TRUE\")","v":"TRUE"},null,{"$f":"IF(IFERROR(SEARCH(\"-\",G8),-1)=-1,\"FALSE\",\"TRUE\")","v":"TRUE"},null,{"$f":"IF(OR(NOT(IFERROR(SEARCH(\"/\",G8),-1)=-1),NOT(IFERROR(SEARCH(\"-\",G8),-1)=-1)),\"TRUE\",\"FALSE\")","v":"TRUE"}]
[]
[]
[null,null,null,null,null,null,"2021-01-01"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8,9,10,11,12,13,14,15,16,17,18,22,23"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4,8,9,10,11,12,13,14,15,16,17,18,22,23"]

{"sheet":"_PROC_EXTRAS_LKP_","index":8,"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}]