{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Rental","Instructions","Trusted Document Instructions","_HYPER_LKP_NEW_","NOTES","LOOKUPS","_HYPER_LKP_","Rental (2)"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":144,"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":"Rental","index":0,"n_rows":730,"n_cols":13,"rows_kept":730,"cut":false,"hidden":false,"merged":[[78,2,79,2],[79,3,79,7],[79,9,79,10],[73,3,73,7],[74,3,74,7],[73,9,73,10],[74,9,74,10],[71,2,72,2],[64,2,65,2],[72,9,72,10],[65,3,65,7],[66,3,66,7],[67,3,67,7],[65,9,65,10],[66,9,66,10],[67,9,67,10],[69,4,69,11],[72,3,72,7],[121,9,121,10],[112,3,112,7],[113,3,113,7],[108,2,109,2],[109,3,109,7],[110,3,110,7],[114,3,114,7],[111,3,111,6],[115,3,115,7],[116,4,116,6],[31,2,32,2],[27,9,27,10],[46,2,47,2],[60,3,60,7],[62,4,62,11],[29,4,29,11],[32,3,32,7],[33,3,33,7],[37,3,37,7],[44,4,44,11],[47,3,47,7],[38,3,38,7],[34,3,34,6],[39,4,39,6],[42,9,42,10],[35,3,35,7],[36,3,36,7],[48,3,48,7],[49,3,49,6],[50,3,50,7],[51,3,51,7],[52,3,52,7],[53,3,53,7],[54,4,54,6],[2,12,2,13],[24,4,24,6],[17,3,17,7],[18,3,18,7],[20,3,20,7],[21,3,21,7],[22,3,22,7],[23,3,23,7],[14,4,14,11],[2,1,2,4],[5,2,5,13],[4,2,4,13],[12,3,12,7],[16,2,17,2],[10,1,10,8],[7,12,7,13],[2,5,2,8],[6,4,6,5],[6,1,6,3],[6,6,6,7],[6,8,6,9],[8,1,8,14],[229,3,229,7],[184,4,184,6],[172,9,172,10],[191,4,191,11],[97,3,97,7],[85,1,85,8],[98,3,98,7],[99,4,99,6],[104,9,104,10],[87,3,87,7],[89,4,89,11],[91,2,92,2],[92,3,92,7],[93,3,93,7],[95,3,95,7],[96,3,96,7],[94,3,94,6],[106,4,106,11],[123,4,123,11],[125,2,126,2],[126,3,126,7],[140,4,140,11],[142,2,143,2],[143,3,143,7],[155,9,155,10],[127,3,127,7],[128,3,128,6],[129,3,129,7],[130,3,130,7],[131,3,131,7],[132,3,132,7],[133,4,133,6],[181,3,181,7],[138,9,138,10],[179,3,179,6],[180,3,180,7],[144,3,144,7],[145,3,145,6],[146,3,146,7],[147,3,147,7],[148,3,148,7],[149,3,149,7],[150,4,150,6],[182,3,182,7],[183,3,183,7],[218,4,218,6],[167,4,167,6],[157,4,157,11],[159,2,160,2],[160,3,160,7],[174,4,174,11],[176,2,177,2],[177,3,177,7],[178,3,178,7],[161,3,161,7],[162,3,162,6],[163,3,163,7],[164,3,164,7],[165,3,165,7],[166,3,166,7],[215,3,215,7],[216,3,216,7],[214,3,214,7],[206,9,206,10],[225,4,225,11],[227,2,228,2],[228,3,228,7],[213,3,213,6],[217,3,217,7],[201,4,201,6],[189,9,189,10],[208,4,208,11],[210,2,211,2],[211,3,211,7],[212,3,212,7],[196,3,196,6],[197,3,197,7],[198,3,198,7],[199,3,199,7],[200,3,200,7],[223,9,223,10],[193,2,194,2],[194,3,194,7],[195,3,195,7],[242,4,242,11],[244,2,245,2],[245,3,245,7],[230,3,230,6],[231,3,231,7],[232,3,232,7],[233,3,233,7],[234,3,234,7],[294,3,294,7],[246,3,246,7],[247,3,247,6],[248,3,248,7],[249,3,249,7],[250,3,250,7],[251,3,251,7],[252,4,252,6],[257,9,257,10],[240,9,240,10],[266,3,266,7],[267,3,267,7],[282,3,282,7],[296,4,296,11],[276,4,276,11],[278,2,279,2],[279,3,279,7],[259,4,259,11],[261,2,262,2],[262,3,262,7],[235,4,235,6],[298,2,299,2],[299,3,299,7],[299,9,299,10],[280,3,280,7],[281,3,281,6],[283,3,283,7],[284,3,284,7],[285,3,285,7],[286,4,286,6],[291,9,291,10],[263,3,263,7],[264,3,264,6],[265,3,265,7],[268,3,268,7],[269,4,269,6],[274,9,274,10],[303,3,303,7],[303,9,303,10],[305,4,305,11],[307,2,308,2],[308,3,308,7],[308,9,308,10],[300,3,300,7],[300,9,300,10],[301,3,301,7],[301,9,301,10],[302,3,302,7],[302,9,302,10],[312,3,312,7],[312,9,312,10],[314,4,314,11],[316,2,317,2],[317,3,317,7],[317,9,317,10],[309,3,309,7],[309,9,309,10],[310,3,310,7],[310,9,310,10],[311,3,311,7],[311,9,311,10],[321,3,321,7],[321,9,321,10],[323,4,323,11],[325,2,326,2],[326,3,326,7],[326,9,326,10],[318,3,318,7],[318,9,318,10],[319,3,319,7],[319,9,319,10],[320,3,320,7],[320,9,320,10],[330,3,330,7],[330,9,330,10],[332,4,332,11],[334,2,335,2],[335,3,335,7],[335,9,335,10],[327,3,327,7],[327,9,327,10],[328,3,328,7],[328,9,328,10],[329,3,329,7],[329,9,329,10],[339,3,339,7],[339,9,339,10],[341,4,341,11],[343,2,344,2],[344,3,344,7],[344,9,344,10],[336,3,336,7],[336,9,336,10],[337,3,337,7],[337,9,337,10],[338,3,338,7],[338,9,338,10],[348,3,348,7],[348,9,348,10],[350,4,350,11],[352,2,353,2],[353,3,353,7],[353,9,353,10],[345,3,345,7],[345,9,345,10],[346,3,346,7],[346,9,346,10],[347,3,347,7],[347,9,347,10],[357,3,357,7],[357,9,357,10],[359,4,359,11],[361,2,362,2],[362,3,362,7],[362,9,362,10],[354,3,354,7],[354,9,354,10],[355,3,355,7],[355,9,355,10],[356,3,356,7],[356,9,356,10],[366,3,366,7],[366,9,366,10],[368,4,368,11],[370,2,371,2],[371,3,371,7],[371,9,371,10],[363,3,363,7],[363,9,363,10],[364,3,364,7],[364,9,364,10],[365,3,365,7],[365,9,365,10],[375,3,375,7],[375,9,375,10],[377,4,377,11],[379,2,380,2],[380,3,380,7],[380,9,380,10],[372,3,372,7],[372,9,372,10],[373,3,373,7],[373,9,373,10],[374,3,374,7],[374,9,374,10],[384,3,384,7],[384,9,384,10],[386,4,386,11],[388,2,389,2],[389,3,389,7],[389,9,389,10],[381,3,381,7],[381,9,381,10],[382,3,382,7],[382,9,382,10],[383,3,383,7],[383,9,383,10],[399,9,399,10],[400,3,400,7],[390,3,390,7],[390,9,390,10],[391,3,391,7],[391,9,391,10],[392,3,392,7],[392,9,392,10],[400,9,400,10],[471,4,471,6],[478,4,478,11],[429,2,430,2],[430,3,430,7],[393,3,393,7],[393,9,393,10],[395,4,395,11],[397,2,398,2],[398,3,398,7],[398,9,398,10],[420,4,420,6],[425,9,425,10],[406,1,406,8],[408,3,408,7],[410,4,410,11],[412,2,413,2],[413,3,413,7],[414,3,414,7],[416,3,416,7],[417,3,417,7],[418,3,418,7],[402,3,402,7],[402,9,402,10],[399,3,399,7],[401,3,401,7],[401,9,401,10],[419,3,419,7],[431,3,431,7],[433,3,433,7],[415,3,415,6],[517,3,517,6],[518,3,518,7],[510,9,510,10],[432,3,432,6],[434,3,434,7],[435,3,435,7],[436,3,436,7],[437,4,437,6],[442,9,442,10],[427,4,427,11],[444,4,444,11],[465,3,465,7],[466,3,466,6],[467,3,467,7],[468,3,468,7],[500,3,500,6],[501,3,501,7],[470,3,470,7],[519,3,519,7],[520,3,520,7],[521,3,521,7],[482,3,482,7],[483,3,483,6],[487,3,487,7],[505,4,505,6],[502,3,502,7],[503,3,503,7],[504,3,504,7],[486,3,486,7],[499,3,499,7],[498,3,498,7],[516,3,516,7],[615,3,615,7],[617,4,617,11],[484,3,484,7],[485,3,485,7],[488,4,488,6],[493,9,493,10],[461,4,461,11],[587,3,587,7],[588,3,588,7],[601,3,601,7],[495,4,495,11],[529,4,529,11],[532,3,532,7],[597,4,597,11],[600,3,600,7],[512,4,512,11],[602,3,602,6],[603,3,603,7],[604,3,604,7],[605,3,605,7],[606,3,606,7],[607,4,607,6],[612,9,612,10],[584,3,584,7],[619,2,620,2],[620,3,620,7],[620,9,620,10],[621,3,621,7],[621,9,621,10],[622,3,622,7],[622,9,622,10],[623,3,623,7],[623,9,623,10],[624,3,624,7],[624,9,624,10],[626,4,626,11],[628,2,629,2],[629,3,629,7],[629,9,629,10],[630,3,630,7],[630,9,630,10],[631,3,631,7],[631,9,631,10],[632,3,632,7],[632,9,632,10],[633,3,633,7],[633,9,633,10],[635,4,635,11],[637,2,638,2],[638,3,638,7],[638,9,638,10],[639,3,639,7],[639,9,639,10],[640,3,640,7],[640,9,640,10],[641,3,641,7],[641,9,641,10],[642,3,642,7],[642,9,642,10],[644,4,644,11],[646,2,647,2],[647,3,647,7],[647,9,647,10],[648,3,648,7],[648,9,648,10],[649,3,649,7],[649,9,649,10],[650,3,650,7],[650,9,650,10],[651,3,651,7],[651,9,651,10],[653,4,653,11],[665,9,665,10],[666,3,666,7],[666,9,666,10],[667,3,667,7],[667,9,667,10],[655,2,656,2],[656,3,656,7],[656,9,656,10],[657,3,657,7],[657,9,657,10],[658,3,658,7],[658,9,658,10],[659,3,659,7],[659,9,659,10],[662,4,662,11],[660,3,660,7],[660,9,660,10],[693,3,693,7],[693,9,693,10],[694,3,694,7],[694,9,694,10],[695,3,695,7],[695,9,695,10],[676,9,676,10],[677,3,677,7],[677,9,677,10],[678,3,678,7],[678,9,678,10],[680,4,680,11],[683,3,683,7],[683,9,683,10],[676,3,676,7],[687,3,687,7],[687,9,687,10],[689,4,689,11],[692,3,692,7],[692,9,692,10],[730,2,737,13],[712,3,712,7],[712,9,712,10],[713,3,713,7],[713,9,713,10],[714,3,714,7],[714,9,714,10],[716,4,716,11],[718,2,719,2],[719,3,719,7],[719,9,719,10],[720,3,720,7],[720,9,720,10],[721,3,721,7],[721,9,721,10],[722,3,722,7],[722,9,722,10],[723,3,723,7],[723,9,723,10],[709,2,710,2],[710,3,710,7],[710,9,710,10],[711,3,711,7],[711,9,711,10],[696,3,696,7],[696,9,696,10],[698,4,698,11],[700,2,701,2],[701,3,701,7],[701,9,701,10],[702,3,702,7],[704,3,704,7],[704,9,704,10],[705,3,705,7],[705,9,705,10],[707,4,707,11],[702,9,702,10],[703,3,703,7],[703,9,703,10],[691,2,692,2],[531,2,532,2],[546,4,546,11],[548,2,549,2],[549,3,549,7],[684,3,684,7],[684,9,684,10],[685,3,685,7],[685,9,685,10],[686,3,686,7],[686,9,686,10],[682,2,683,2],[668,3,668,7],[668,9,668,10],[669,3,669,7],[669,9,669,10],[671,4,671,11],[673,2,674,2],[674,3,674,7],[674,9,674,10],[675,3,675,7],[675,9,675,10],[664,2,665,2],[665,3,665,7],[514,2,515,2],[515,3,515,7],[550,3,550,7],[551,3,551,6],[599,2,600,2],[580,4,580,11],[582,2,583,2],[563,4,563,11],[565,2,566,2],[566,3,566,7],[583,3,583,7],[567,3,567,7],[568,3,568,6],[569,3,569,7],[570,3,570,7],[571,3,571,7],[572,3,572,7],[573,4,573,6],[578,9,578,10],[552,3,552,7],[595,9,595,10],[539,4,539,6],[544,9,544,10],[522,4,522,6],[527,9,527,10],[585,3,585,6],[586,3,586,7],[589,3,589,7],[590,4,590,6],[554,3,554,7],[555,3,555,7],[556,4,556,6],[561,9,561,10],[553,3,553,7],[533,3,533,7],[534,3,534,6],[535,3,535,7],[536,3,536,7],[537,3,537,7],[538,3,538,7],[57,9,57,10],[80,3,80,7],[80,9,80,10],[81,3,81,7],[81,9,81,10],[76,4,76,11],[19,3,19,6],[497,2,498,2],[446,2,447,2],[447,3,447,7],[463,2,464,2],[464,3,464,7],[480,2,481,2],[481,3,481,7],[476,9,476,10],[448,3,448,7],[449,3,449,6],[450,3,450,7],[451,3,451,7],[452,3,452,7],[453,3,453,7],[454,4,454,6],[459,9,459,10],[469,3,469,7]]}
[null," Rental Income Worksheet"]
[]
[null,"  BORROWER AND/OR CO-BORROWER NAME:",null,null,null,null,null,null,null,null,"  DATE: ",null,"Annualization date: "]
[]
[null,null,"Based on the usage of the property(ies), complete your rental analysis using Schedule E, \nLease Agreement (or alternate), or Form 8825, as required by your investor. \n(For Schedule E – Traditional Method complete rows 15-18 & 22)."]
[null,null,"In general, investors require analysis of the most recent tax year for net rental income (loss).\nFor your convenience, average monthly rental figures are provided."]
[null,"        BORROWER NAME:",null,null,null,null,"COMPLETED BY:",null,null,null,"DATE: "]
[null,null,null,null,null,null,"Input Year(s):"]
[null,"Before you can use the worksheet, you must make it a Trusted Document.  Click here for instructions. "]
[]
[null,"Primary Residence (2 - 4 unit)"]
[]
[null,null,null,"Schedule E"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,1]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,2,"Rents Received:  Schedule E Line 3"]
[null,null,3,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,4,"Depreciation:  Schedule E Line 18"]
[null,null,5,"Taxes:  Schedule E Line 16"]
[null,null,6,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,7,"Insurance:  Schedule E Line 9"]
[null,null,8,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,9,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I19-I20+SUM(I21:I25)","v":0},null,null,{"$f":"L19-L20+SUM(L21:L25)","v":0}]
[null,null,10,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I26/I18,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L26/L18,\"N/A\")","v":"N/A"}]
[null,null,11,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I18),ISNUMBER(L18)),I18+L18,IF(ISNUMBER(I18),I18,IF(ISNUMBER(L18),L18,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I18),ISNUMBER(L18),ISNUMBER(I26),ISNUMBER(L26)),(I26+L26)/(I18+L18),IF(AND(OR(NOT(ISNUMBER(L18)),NOT(ISNUMBER(L26))),ISNUMBER(I18),ISNUMBER(I26)),I26/I18,IF(AND(OR(NOT(ISNUMBER(I18)),NOT(ISNUMBER(I26))),ISNUMBER(L18),ISNUMBER(L26)),L26/L18,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,1]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,2,"Rents Received:  Schedule E Line 3"]
[null,null,3,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,4,"Depreciation:  Schedule E Line 18"]
[null,null,5,"Taxes:  Schedule E Line 16"]
[null,null,6,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,7,"Insurance:  Schedule E Line 9"]
[null,null,8,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,9,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I34-I35+SUM(I36:I40)","v":0},null,null,{"$f":"L34-L35+SUM(L36:L40)","v":0}]
[null,null,10,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I41/I33,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L41/L33,\"N/A\")","v":"N/A"}]
[null,null,11,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I33),ISNUMBER(L33)),I33+L33,IF(ISNUMBER(I33),I33,IF(ISNUMBER(L33),L33,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I33),ISNUMBER(L33),ISNUMBER(I41),ISNUMBER(L41)),(I41+L41)/(I33+L33),IF(AND(OR(NOT(ISNUMBER(L33)),NOT(ISNUMBER(L41))),ISNUMBER(I33),ISNUMBER(I41)),I41/I33,IF(AND(OR(NOT(ISNUMBER(I33)),NOT(ISNUMBER(I41))),ISNUMBER(L33),ISNUMBER(L41)),L41/L33,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,1]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,2,"Rents Received:  Schedule E Line 3"]
[null,null,3,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,4,"Depreciation:  Schedule E Line 18"]
[null,null,5,"Taxes:  Schedule E Line 16"]
[null,null,6,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,7,"Insurance:  Schedule E Line 9"]
[null,null,8,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,9,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I49-I50+SUM(I51:I55)","v":0},null,null,{"$f":"L49-L50+SUM(L51:L55)","v":0}]
[null,null,10,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I56/I48,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L56/L48,\"N/A\")","v":"N/A"}]
[null,null,11,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I48),ISNUMBER(L48)),I48+L48,IF(ISNUMBER(I48),I48,IF(ISNUMBER(L48),L48,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I48),ISNUMBER(L48),ISNUMBER(I56),ISNUMBER(L56)),(I56+L56)/(I48+L48),IF(AND(OR(NOT(ISNUMBER(L48)),NOT(ISNUMBER(L56))),ISNUMBER(I48),ISNUMBER(I56)),I56/I48,IF(AND(OR(NOT(ISNUMBER(I48)),NOT(ISNUMBER(I56))),ISNUMBER(L48),ISNUMBER(L56)),L56/L48,\"N/A\")))","v":"N/A"}]
[]
[]
[null,null,null,"Lease Agreement (or alternate)"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,12]
[null,null,null,"Gross Monthly Rent"]
[null,null,13,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J66","v":0}]
[null,null,14,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J66+J67","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,12]
[null,null,null,"Gross Monthly Rent"]
[null,null,13,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J73","v":0}]
[null,null,14,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J73+J74","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,12]
[null,null,null,"Gross Monthly Rent"]
[null,null,13,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J80","v":0}]
[null,null,14,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J80+J81","v":0}]
[]
[]
[]
[null,"Investment Property"]
[]
[null,null,null,"Schedule E"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I94-I95+SUM(I96:I100)","v":0},null,null,{"$f":"L94-L95+SUM(L96:L100)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I101/I93,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L101/L93,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I102-I103,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L102-L103,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I93),ISNUMBER(L93)),I93+L93,IF(ISNUMBER(I93),I93,IF(ISNUMBER(L93),L93,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I93),ISNUMBER(L93),ISNUMBER(I104),ISNUMBER(L104)),((I93*I104)+(L93*L104))/(I93+L93),IF(AND(OR(NOT(ISNUMBER(L93)),NOT(ISNUMBER(L104))),ISNUMBER(I93),ISNUMBER(I104)),I104,IF(AND(OR(NOT(ISNUMBER(I93)),NOT(ISNUMBER(I104))),ISNUMBER(L93),ISNUMBER(L104)),L104,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I111-I112+SUM(I113:I117)","v":0},null,null,{"$f":"L111-L112+SUM(L113:L117)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I118/I110,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L118/L110,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I119-I120,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L119-L120,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I110),ISNUMBER(L110)),I110+L110,IF(ISNUMBER(I110),I110,IF(ISNUMBER(L110),L110,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I110),ISNUMBER(L110),ISNUMBER(I121),ISNUMBER(L121)),((I110*I121)+(L110*L121))/(I110+L110),IF(AND(OR(NOT(ISNUMBER(L110)),NOT(ISNUMBER(L121))),ISNUMBER(I110),ISNUMBER(I121)),I121,IF(AND(OR(NOT(ISNUMBER(I110)),NOT(ISNUMBER(I121))),ISNUMBER(L110),ISNUMBER(L121)),L121,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I128-I129+SUM(I130:I134)","v":0},null,null,{"$f":"L128-L129+SUM(L130:L134)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I135/I127,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L135/L127,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I136-I137,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L136-L137,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I127),ISNUMBER(L127)),I127+L127,IF(ISNUMBER(I127),I127,IF(ISNUMBER(L127),L127,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I127),ISNUMBER(L127),ISNUMBER(I138),ISNUMBER(L138)),((I127*I138)+(L127*L138))/(I127+L127),IF(AND(OR(NOT(ISNUMBER(L127)),NOT(ISNUMBER(L138))),ISNUMBER(I127),ISNUMBER(I138)),I138,IF(AND(OR(NOT(ISNUMBER(I127)),NOT(ISNUMBER(I138))),ISNUMBER(L127),ISNUMBER(L138)),L138,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I145-I146+SUM(I147:I151)","v":0},null,null,{"$f":"L145-L146+SUM(L147:L151)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I152/I144,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L152/L144,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I153-I154,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L153-L154,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I144),ISNUMBER(L144)),I144+L144,IF(ISNUMBER(I144),I144,IF(ISNUMBER(L144),L144,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I144),ISNUMBER(L144),ISNUMBER(I155),ISNUMBER(L155)),((I144*I155)+(L144*L155))/(I144+L144),IF(AND(OR(NOT(ISNUMBER(L144)),NOT(ISNUMBER(L155))),ISNUMBER(I144),ISNUMBER(I155)),I155,IF(AND(OR(NOT(ISNUMBER(I144)),NOT(ISNUMBER(I155))),ISNUMBER(L144),ISNUMBER(L155)),L155,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I162-I163+SUM(I164:I168)","v":0},null,null,{"$f":"L162-L163+SUM(L164:L168)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I169/I161,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L169/L161,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I170-I171,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L170-L171,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I161),ISNUMBER(L161)),I161+L161,IF(ISNUMBER(I161),I161,IF(ISNUMBER(L161),L161,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I161),ISNUMBER(L161),ISNUMBER(I172),ISNUMBER(L172)),((I161*I172)+(L161*L172))/(I161+L161),IF(AND(OR(NOT(ISNUMBER(L161)),NOT(ISNUMBER(L172))),ISNUMBER(I161),ISNUMBER(I172)),I172,IF(AND(OR(NOT(ISNUMBER(I161)),NOT(ISNUMBER(I172))),ISNUMBER(L161),ISNUMBER(L172)),L172,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I179-I180+SUM(I181:I185)","v":0},null,null,{"$f":"L179-L180+SUM(L181:L185)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I186/I178,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L186/L178,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I187-I188,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L187-L188,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I178),ISNUMBER(L178)),I178+L178,IF(ISNUMBER(I178),I178,IF(ISNUMBER(L178),L178,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I178),ISNUMBER(L178),ISNUMBER(I189),ISNUMBER(L189)),((I178*I189)+(L178*L189))/(I178+L178),IF(AND(OR(NOT(ISNUMBER(L178)),NOT(ISNUMBER(L189))),ISNUMBER(I178),ISNUMBER(I189)),I189,IF(AND(OR(NOT(ISNUMBER(I178)),NOT(ISNUMBER(I189))),ISNUMBER(L178),ISNUMBER(L189)),L189,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I196-I197+SUM(I198:I202)","v":0},null,null,{"$f":"L196-L197+SUM(L198:L202)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I203/I195,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L203/L195,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I204-I205,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L204-L205,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I195),ISNUMBER(L195)),I195+L195,IF(ISNUMBER(I195),I195,IF(ISNUMBER(L195),L195,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I195),ISNUMBER(L195),ISNUMBER(I206),ISNUMBER(L206)),((I195*I206)+(L195*L206))/(I195+L195),IF(AND(OR(NOT(ISNUMBER(L195)),NOT(ISNUMBER(L206))),ISNUMBER(I195),ISNUMBER(I206)),I206,IF(AND(OR(NOT(ISNUMBER(I195)),NOT(ISNUMBER(I206))),ISNUMBER(L195),ISNUMBER(L206)),L206,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I213-I214+SUM(I215:I219)","v":0},null,null,{"$f":"L213-L214+SUM(L215:L219)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I220/I212,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L220/L212,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I221-I222,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L221-L222,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I212),ISNUMBER(L212)),I212+L212,IF(ISNUMBER(I212),I212,IF(ISNUMBER(L212),L212,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I212),ISNUMBER(L212),ISNUMBER(I223),ISNUMBER(L223)),((I212*I223)+(L212*L223))/(I212+L212),IF(AND(OR(NOT(ISNUMBER(L212)),NOT(ISNUMBER(L223))),ISNUMBER(I212),ISNUMBER(I223)),I223,IF(AND(OR(NOT(ISNUMBER(I212)),NOT(ISNUMBER(I223))),ISNUMBER(L212),ISNUMBER(L223)),L223,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I230-I231+SUM(I232:I236)","v":0},null,null,{"$f":"L230-L231+SUM(L232:L236)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I237/I229,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L237/L229,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I238-I239,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L238-L239,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I229),ISNUMBER(L229)),I229+L229,IF(ISNUMBER(I229),I229,IF(ISNUMBER(L229),L229,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I229),ISNUMBER(L229),ISNUMBER(I240),ISNUMBER(L240)),((I229*I240)+(L229*L240))/(I229+L229),IF(AND(OR(NOT(ISNUMBER(L229)),NOT(ISNUMBER(L240))),ISNUMBER(I229),ISNUMBER(I240)),I240,IF(AND(OR(NOT(ISNUMBER(I229)),NOT(ISNUMBER(I240))),ISNUMBER(L229),ISNUMBER(L240)),L240,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I247-I248+SUM(I249:I253)","v":0},null,null,{"$f":"L247-L248+SUM(L249:L253)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I254/I246,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L254/L246,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I255-I256,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L255-L256,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I246),ISNUMBER(L246)),I246+L246,IF(ISNUMBER(I246),I246,IF(ISNUMBER(L246),L246,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I246),ISNUMBER(L246),ISNUMBER(I257),ISNUMBER(L257)),((I246*I257)+(L246*L257))/(I246+L246),IF(AND(OR(NOT(ISNUMBER(L246)),NOT(ISNUMBER(L257))),ISNUMBER(I246),ISNUMBER(I257)),I257,IF(AND(OR(NOT(ISNUMBER(I246)),NOT(ISNUMBER(I257))),ISNUMBER(L246),ISNUMBER(L257)),L257,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I264-I265+SUM(I266:I270)","v":0},null,null,{"$f":"L264-L265+SUM(L266:L270)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I271/I263,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L271/L263,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I272-I273,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L272-L273,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I263),ISNUMBER(L263)),I263+L263,IF(ISNUMBER(I263),I263,IF(ISNUMBER(L263),L263,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I263),ISNUMBER(L263),ISNUMBER(I274),ISNUMBER(L274)),((I263*I274)+(L263*L274))/(I263+L263),IF(AND(OR(NOT(ISNUMBER(L263)),NOT(ISNUMBER(L274))),ISNUMBER(I263),ISNUMBER(I274)),I274,IF(AND(OR(NOT(ISNUMBER(I263)),NOT(ISNUMBER(I274))),ISNUMBER(L263),ISNUMBER(L274)),L274,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,15]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,16,"Rents Received:  Schedule E Line 3"]
[null,null,17,"Total Expenses:  Schedule E Line 20",null,null,null,"( ",null," )","( ",null," )"]
[null,null,18,"Depreciation:  Schedule E Line 18"]
[null,null,19,"Taxes:  Schedule E Line 16"]
[null,null,20,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,21,"Insurance:  Schedule E Line 9"]
[null,null,22,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,23,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I281-I282+SUM(I283:I287)","v":0},null,null,{"$f":"L281-L282+SUM(L283:L287)","v":0}]
[null,null,24,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I288/I280,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L288/L280,\"N/A\")","v":"N/A"}]
[null,null,25,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,26,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I289-I290,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L289-L290,\"N/A\")","v":"N/A"}]
[null,null,27,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I280),ISNUMBER(L280)),I280+L280,IF(ISNUMBER(I280),I280,IF(ISNUMBER(L280),L280,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I280),ISNUMBER(L280),ISNUMBER(I291),ISNUMBER(L291)),((I280*I291)+(L280*L291))/(I280+L280),IF(AND(OR(NOT(ISNUMBER(L280)),NOT(ISNUMBER(L291))),ISNUMBER(I280),ISNUMBER(I291)),I291,IF(AND(OR(NOT(ISNUMBER(I280)),NOT(ISNUMBER(I291))),ISNUMBER(L280),ISNUMBER(L291)),L291,\"N/A\")))","v":"N/A"}]
[]
[]
[null,null,null,"Lease Agreement (or alternate)"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J300","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J300+J301","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J302-J303","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J309","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J309+J310","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J311-J312","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J318","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J318+J319","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J320-J321","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J327","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J327+J328","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J329-J330","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J336","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J336+J337","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J338-J339","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J345","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J345+J346","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J347-J348","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J354","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J354+J355","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J356-J357","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J363","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J363+J364","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J365-J366","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J372","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J372+J373","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J374-J375","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J381","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J381+J382","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J383-J384","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J390","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J390+J391","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J392-J393","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,28]
[null,null,null,"Gross Monthly Rent"]
[null,null,29,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J399","v":0}]
[null,null,30,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J399+J400","v":0}]
[null,null,31,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,32,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J401-J402","v":0}]
[]
[]
[]
[null,"Business Rental"]
[]
[null,null,null,"Form 8825"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I415-I416+SUM(I417:I421)","v":0},null,null,{"$f":"L415-L416+SUM(L417:L421)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I422/I414,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L422/L414,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I423-I424,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L423-L424,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I414),ISNUMBER(L414)),I414+L414,IF(ISNUMBER(I414),I414,IF(ISNUMBER(L414),L414,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I414),ISNUMBER(L414),ISNUMBER(I425),ISNUMBER(L425)),((I414*I425)+(L414*L425))/(I414+L414),IF(AND(OR(NOT(ISNUMBER(L414)),NOT(ISNUMBER(L425))),ISNUMBER(I414),ISNUMBER(I425)),I425,IF(AND(OR(NOT(ISNUMBER(I414)),NOT(ISNUMBER(I425))),ISNUMBER(L414),ISNUMBER(L425)),L425,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I432-I433+SUM(I434:I438)","v":0},null,null,{"$f":"L432-L433+SUM(L434:L438)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I439/I431,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L439/L431,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I440-I441,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L440-L441,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I431),ISNUMBER(L431)),I431+L431,IF(ISNUMBER(I431),I431,IF(ISNUMBER(L431),L431,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I431),ISNUMBER(L431),ISNUMBER(I442),ISNUMBER(L442)),((I431*I442)+(L431*L442))/(I431+L431),IF(AND(OR(NOT(ISNUMBER(L431)),NOT(ISNUMBER(L442))),ISNUMBER(I431),ISNUMBER(I442)),I442,IF(AND(OR(NOT(ISNUMBER(I431)),NOT(ISNUMBER(I442))),ISNUMBER(L431),ISNUMBER(L442)),L442,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I449-I450+SUM(I451:I455)","v":0},null,null,{"$f":"L449-L450+SUM(L451:L455)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I456/I448,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L456/L448,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I457-I458,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L457-L458,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I448),ISNUMBER(L448)),I448+L448,IF(ISNUMBER(I448),I448,IF(ISNUMBER(L448),L448,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I448),ISNUMBER(L448),ISNUMBER(I459),ISNUMBER(L459)),((I448*I459)+(L448*L459))/(I448+L448),IF(AND(OR(NOT(ISNUMBER(L448)),NOT(ISNUMBER(L459))),ISNUMBER(I448),ISNUMBER(I459)),I459,IF(AND(OR(NOT(ISNUMBER(I448)),NOT(ISNUMBER(I459))),ISNUMBER(L448),ISNUMBER(L459)),L459,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I466-I467+SUM(I468:I472)","v":0},null,null,{"$f":"L466-L467+SUM(L468:L472)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I473/I465,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L473/L465,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I474-I475,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L474-L475,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I465),ISNUMBER(L465)),I465+L465,IF(ISNUMBER(I465),I465,IF(ISNUMBER(L465),L465,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I465),ISNUMBER(L465),ISNUMBER(I476),ISNUMBER(L476)),((I465*I476)+(L465*L476))/(I465+L465),IF(AND(OR(NOT(ISNUMBER(L465)),NOT(ISNUMBER(L476))),ISNUMBER(I465),ISNUMBER(I476)),I476,IF(AND(OR(NOT(ISNUMBER(I465)),NOT(ISNUMBER(I476))),ISNUMBER(L465),ISNUMBER(L476)),L476,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I483-I484+SUM(I485:I489)","v":0},null,null,{"$f":"L483-L484+SUM(L485:L489)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I490/I482,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L490/L482,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I491-I492,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L491-L492,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I482),ISNUMBER(L482)),I482+L482,IF(ISNUMBER(I482),I482,IF(ISNUMBER(L482),L482,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I482),ISNUMBER(L482),ISNUMBER(I493),ISNUMBER(L493)),((I482*I493)+(L482*L493))/(I482+L482),IF(AND(OR(NOT(ISNUMBER(L482)),NOT(ISNUMBER(L493))),ISNUMBER(I482),ISNUMBER(I493)),I493,IF(AND(OR(NOT(ISNUMBER(I482)),NOT(ISNUMBER(I493))),ISNUMBER(L482),ISNUMBER(L493)),L493,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I500-I501+SUM(I502:I506)","v":0},null,null,{"$f":"L500-L501+SUM(L502:L506)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I507/I499,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L507/L499,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I508-I509,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L508-L509,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I499),ISNUMBER(L499)),I499+L499,IF(ISNUMBER(I499),I499,IF(ISNUMBER(L499),L499,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I499),ISNUMBER(L499),ISNUMBER(I510),ISNUMBER(L510)),((I499*I510)+(L499*L510))/(I499+L499),IF(AND(OR(NOT(ISNUMBER(L499)),NOT(ISNUMBER(L510))),ISNUMBER(I499),ISNUMBER(I510)),I510,IF(AND(OR(NOT(ISNUMBER(I499)),NOT(ISNUMBER(I510))),ISNUMBER(L499),ISNUMBER(L510)),L510,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I517-I518+SUM(I519:I523)","v":0},null,null,{"$f":"L517-L518+SUM(L519:L523)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I524/I516,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L524/L516,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I525-I526,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L525-L526,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I516),ISNUMBER(L516)),I516+L516,IF(ISNUMBER(I516),I516,IF(ISNUMBER(L516),L516,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I516),ISNUMBER(L516),ISNUMBER(I527),ISNUMBER(L527)),((I516*I527)+(L516*L527))/(I516+L516),IF(AND(OR(NOT(ISNUMBER(L516)),NOT(ISNUMBER(L527))),ISNUMBER(I516),ISNUMBER(I527)),I527,IF(AND(OR(NOT(ISNUMBER(I516)),NOT(ISNUMBER(I527))),ISNUMBER(L516),ISNUMBER(L527)),L527,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I534-I535+SUM(I536:I540)","v":0},null,null,{"$f":"L534-L535+SUM(L536:L540)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I541/I533,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L541/L533,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I542-I543,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L542-L543,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I533),ISNUMBER(L533)),I533+L533,IF(ISNUMBER(I533),I533,IF(ISNUMBER(L533),L533,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I533),ISNUMBER(L533),ISNUMBER(I544),ISNUMBER(L544)),((I533*I544)+(L533*L544))/(I533+L533),IF(AND(OR(NOT(ISNUMBER(L533)),NOT(ISNUMBER(L544))),ISNUMBER(I533),ISNUMBER(I544)),I544,IF(AND(OR(NOT(ISNUMBER(I533)),NOT(ISNUMBER(I544))),ISNUMBER(L533),ISNUMBER(L544)),L544,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I551-I552+SUM(I553:I557)","v":0},null,null,{"$f":"L551-L552+SUM(L553:L557)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I558/I550,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L558/L550,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I559-I560,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L559-L560,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I550),ISNUMBER(L550)),I550+L550,IF(ISNUMBER(I550),I550,IF(ISNUMBER(L550),L550,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I550),ISNUMBER(L550),ISNUMBER(I561),ISNUMBER(L561)),((I550*I561)+(L550*L561))/(I550+L550),IF(AND(OR(NOT(ISNUMBER(L550)),NOT(ISNUMBER(L561))),ISNUMBER(I550),ISNUMBER(I561)),I561,IF(AND(OR(NOT(ISNUMBER(I550)),NOT(ISNUMBER(I561))),ISNUMBER(L550),ISNUMBER(L561)),L561,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I568-I569+SUM(I570:I574)","v":0},null,null,{"$f":"L568-L569+SUM(L570:L574)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I575/I567,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L575/L567,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I576-I577,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L576-L577,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I567),ISNUMBER(L567)),I567+L567,IF(ISNUMBER(I567),I567,IF(ISNUMBER(L567),L567,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I567),ISNUMBER(L567),ISNUMBER(I578),ISNUMBER(L578)),((I567*I578)+(L567*L578))/(I567+L567),IF(AND(OR(NOT(ISNUMBER(L567)),NOT(ISNUMBER(L578))),ISNUMBER(I567),ISNUMBER(I578)),I578,IF(AND(OR(NOT(ISNUMBER(I567)),NOT(ISNUMBER(I578))),ISNUMBER(L567),ISNUMBER(L578)),L578,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I585-I586+SUM(I587:I591)","v":0},null,null,{"$f":"L585-L586+SUM(L587:L591)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I592/I584,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L592/L584,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I593-I594,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L593-L594,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I584),ISNUMBER(L584)),I584+L584,IF(ISNUMBER(I584),I584,IF(ISNUMBER(L584),L584,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I584),ISNUMBER(L584),ISNUMBER(I595),ISNUMBER(L595)),((I584*I595)+(L584*L595))/(I584+L584),IF(AND(OR(NOT(ISNUMBER(L584)),NOT(ISNUMBER(L595))),ISNUMBER(I584),ISNUMBER(I595)),I595,IF(AND(OR(NOT(ISNUMBER(I584)),NOT(ISNUMBER(I595))),ISNUMBER(L584),ISNUMBER(L595)),L595,\"N/A\")))","v":"N/A"}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation",null,null,null,null,null,{"$f":"IF(ISNUMBER($I$8),$I$8,\"\")","v":""},null,null,{"$f":"IF(ISNUMBER($L$8),$L$8,\"\")","v":""}]
[null,null,33]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,34,"Gross Rents:  Form 8825 Line 2"]
[null,null,35,"Total Expenses:  Form 8825 Line 16",null,null,null,"( ",null," )","( ",null," )"]
[null,null,36,"Depreciation:  Form 8825 Line 14"]
[null,null,37,"Taxes:  Form 8825 Line 11"]
[null,null,38,"Interest:  Form 8825 Line 9"]
[null,null,39,"Insurance:  Form 8825 Line 7"]
[null,null,40,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,41,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"I602-I603+SUM(I604:I608)","v":0},null,null,{"$f":"L602-L603+SUM(L604:L608)","v":0}]
[null,null,42,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I609/I601,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L609/L601,\"N/A\")","v":"N/A"}]
[null,null,43,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,44,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I610-I611,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L610-L611,\"N/A\")","v":"N/A"}]
[null,null,45,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I601),ISNUMBER(L601)),I601+L601,IF(ISNUMBER(I601),I601,IF(ISNUMBER(L601),L601,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I601),ISNUMBER(L601),ISNUMBER(I612),ISNUMBER(L612)),((I601*I612)+(L601*L612))/(I601+L601),IF(AND(OR(NOT(ISNUMBER(L601)),NOT(ISNUMBER(L612))),ISNUMBER(I601),ISNUMBER(I612)),I612,IF(AND(OR(NOT(ISNUMBER(I601)),NOT(ISNUMBER(I612))),ISNUMBER(L601),ISNUMBER(L612)),L612,\"N/A\")))","v":"N/A"}]
[]
[]
[null,null,null,"Lease Agreement (or alternate)"]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J621","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J621+J622","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J623-J624","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J630","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J630+J631","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J632-J633","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J639","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J639+J640","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J641-J642","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J648","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J648+J649","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J650-J651","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J657","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J657+J658","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J659-J660","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J666","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J666+J667","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J668-J669","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J675","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J675+J676","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J677-J678","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J684","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J684+J685","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J686-J687","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J693","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J693+J694","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J695-J696","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J702","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J702+J703","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J704-J705","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J711","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J711+J712","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J713-J714","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,46]
[null,null,null,"Gross Monthly Rent"]
[null,null,47,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J720","v":0}]
[null,null,48,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J720+J721","v":0}]
[null,null,49,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,50,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J722-J723","v":0}]
[]
[]
[]
[]
[]
[null,null,"Comments / Notes  (For a new line, hold Alt and press Enter)"]

{"sheet":"Instructions","index":1,"n_rows":117,"n_cols":2,"rows_kept":117,"cut":false,"hidden":false,"merged":[[19,1,19,6],[20,1,20,6],[21,1,21,6],[37,1,37,4],[39,1,39,6],[58,1,58,6],[43,1,43,6],[44,1,44,6],[50,1,50,6],[51,1,51,6],[41,1,41,6],[78,1,78,6],[64,1,64,6],[66,1,66,6],[70,1,70,6],[74,1,74,6],[76,1,76,6],[77,1,77,6],[68,1,68,6],[72,1,72,6],[62,1,62,6],[46,1,46,5],[48,1,48,6],[52,1,52,6],[3,1,3,43],[27,1,27,6],[34,1,34,6],[28,1,28,6],[35,1,35,6],[30,1,30,3],[32,1,32,6],[25,1,25,6],[5,1,5,6],[7,1,7,6],[11,1,11,6],[13,1,13,6],[9,1,9,6],[14,1,14,6],[15,1,15,6],[17,1,17,6],[80,1,80,2],[53,1,53,6],[54,1,54,6],[60,1,60,6],[61,1,61,6],[91,1,91,6],[92,1,92,6],[82,1,82,6],[84,1,84,6],[85,1,85,6],[116,1,116,6],[94,1,94,3],[87,1,87,3],[23,1,23,3],[109,1,109,6],[106,1,106,4],[113,1,113,6],[115,1,115,6],[103,1,103,6],[104,1,104,6],[108,1,108,6],[96,1,96,6],[98,1,98,6],[100,1,100,6],[101,1,101,6],[89,1,89,6]]}
[]
[null,"Rental Income Worksheet – Instructions"]
[]
[null,"Schedule E – Income or Loss from Rental Real Estate"]
[null," "]
[null,"If your borrower earns rental income, look for the following line items."]
[null," "]
[null,"Note: Be sure to check each property listed on Schedule E against the borrower’s Schedule of Real Estate Owned on the Loan Application. If the borrower no longer owns the property, exclude the income (loss) from that property from your analysis."]
[null," "]
[null,"In general, you only need to analyze the most recent tax year for net rental income."]
[]
[null,"Schedule E – PITIA Calculation "]
[null," "]
[null,"Use the current PITIA (Principal, Interest, Taxes, Insurance and All other) for each rental property. Review Schedule E for numerous line item add-backs."]
[]
[null,"Follow investor guidelines."]
[null," "]
[null,"Schedule E – Traditional Calculation "]
[null," "]
[null,"Do not use the current PITIA for each rental property. Review Schedule E for limited line item add-backs."]
[]
[null,"Follow investor guidelines."]
[null," "]
[null,"Line 3: Rents Received"]
[null," "]
[null,"The amount the borrower reports on this line is income generated from rental real estate."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA or Traditional Calculation – Add recurring rental income"]
[null," "]
[null,"Line 20: Total Expenses"]
[null," "]
[null,"The borrower reports total expenses associated with rental real estate."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA or Traditional Calculation – Deduct recurring expenses"]
[null," "]
[null,"Line 18: Depreciation Expense or Depletion"]
[null," "]
[null,"Depreciation is a noncash expense allocated over the useful life of a declared asset. Depletion, a noncash expense, is the exhaustion of a natural resource over a given period of time."]
[null," "]
[null,"In general, the borrower calculates the total depreciation deduction on Form 4562 and transfers the amount to Schedule E."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA or Traditional Calculation – Add back the amount"]
[null," "]
[null,"Lines 9, 12, 13 and 16: Insurance, Mortgage Interest, Other Interest and Taxes"]
[null," "]
[null,"The borrower reports insurance, mortgage interest and tax expenses on these lines."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add back the amounts, regardless of whether the items are escrowed"]
[null,"•    Traditional Calculation:"]
[null,"–  If Investment Property; make no adjustment"]
[null,"–  If Primary Residence (2-4 unit); add back the amounts"]
[null," "]
[null,"Line 19: Other"]
[null," "]
[null,"The borrower may list certain expenses that are either noncash expenses (e.g., amortization) or nonrecurring in nature (e.g., casualty loss). In addition, homeowners association dues, which are recurring, may be listed here."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add back the amount already included in the current PITIA payment (i.e.: HOA fees), any amortization and/or any casualty loss that can be documented as a one-time expense"]
[null,"•    Traditional Calculation – Add back only amortization and/or casualty loss"]
[]
[null,"Form 8825: Rental Real Estate Income and Expenses of a Partnership or an S Corporation"]
[]
[null,"Partnerships and S Corporations use Form 8825 to report income and deductible expenses from rental real estate activities, including taxable income (loss), which flow to the partner/shareholder through Schedule K-1."]
[null," "]
[null,"To calculate income, use the Cash Flow Analysis Worksheet to add back depreciation the borrower reported."]
[null," "]
[null,"When the borrower is personally obligated for related mortgage debt – as evidenced on a credit report – analyze Form 8825 using the Principal, Interest, Taxes, Insurance and All other (PITIA) method on the Rental Income Worksheet to offset the mortgage debt. Follow investor guidelines."]
[null," "]
[null,"Use our Rental Income Worksheet to analyze which portion, if any, of the mortgage obligation needs to be included in the monthly DTI ratio."]
[null," "]
[null,"Determining the qualifying impact of the mortgaged investment property PITIA expense"]
[null," "]
[null,"After cash flowing the property using the Rental Income Worksheet:"]
[null,"•    If the result is negative, include this loss, not to exceed the monthly PITIA expense, in the DTI ratio"]
[null,"•    If the result is positive, the full amount of the PITIA expense has been offset. Do not include it in the DTI ratio"]
[]
[null,"Line 2: Gross Rents"]
[null," "]
[null,"The amount the business reports on this line is income generated from rental real estate."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add recurring rental income"]
[]
[null,"Line 16: Total Expenses"]
[null," "]
[null,"The business reports total expenses associated with rental real estate."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Deduct recurring expenses"]
[]
[null,"Line 14: Depreciation"]
[null," "]
[null,"Depreciation is a noncash expense allocated over the useful life of a declared asset."]
[null," "]
[null,"In general, the borrower calculates the total depreciation deduction on Form 4562 and transfers the amount to Form 8825."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add back the amount"]
[]
[null,"Effect on Cash Flow Analysis Worksheet"]
[null,"•    Add back the amount"]
[]
[null,"Lines 7, 9, 11: Insurance, Interest and Taxes"]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add back the amounts, regardless of whether items are escrowed or not"]
[]
[null,"Line 15: Other"]
[null," "]
[null,"The borrower may report certain expenses that are either noncash expenses (e.g., amortization) or nonrecurring in nature (e.g., casualty loss). In addition, homeowners association dues, which are recurring, may be reported here."]
[null," "]
[null,"Effect on Rental Income Worksheet"]
[null,"•    PITIA Calculation – Add back the amount included in the current PITIA and any amortization and/or casualty loss"]

{"sheet":"Trusted Document Instructions","index":2,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions for using MGIC income calculators:","Go Back to Rental Income Worksheet"]
[]
[null,"Upon initial download of the calculator, you may see the following Microsoft warning:"]
[]
[]
[]
[null,"Please make sure that you have followed the bulleted steps below in order to obtain the calculator"]
[null,"·         Go to mgic.com/seb"]
[null,"·         Fill out the form to request access to the worksheets"]
[null,"·         Download the worksheet "]
[null,"·         Open the worksheet and save it to your computer using a different name (before editing)"]
[null,"·         Close the download/worksheet"]
[null,"·         Re-open the worksheet from the saved location"]
[null,"·         If there is a yellow bar at the top, click “Enable Content”"]
[]
[]
[null,"If these steps do not work, please do the following:"]
[null,"·         Close the workbook"]
[null,"·         Navigate to the location where the workbook is saved"]
[null,"·         Right-click on the file and select Properties from the menu"]
[null,"·         At the bottom of the General tab, check the unblock box then click OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"If you receive the following pop-up, click on “Yes”"]

{"sheet":"_HYPER_LKP_NEW_","index":3,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["NUM","SECTION","COL_REF","ROW_NUM","LINE_TEXT","PAGE_LINK","BASE_PATH","FILE_NAME","ADDTL","EXAMPLE_URL"]
[1,"Primary Residence Schedule E","C",2,"Rents Received","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/22-25001_rental_income_worksheet-2021.pdf"]
[2,null,"C",3,"Total Expenses","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=21&view=fit"]
[3,null,"C",4,"Depreciation","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[4,null,"C",5,"Taxes","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[5,null,"C",6,"Mortgage Interest","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[6,null,"C",7,"Insurance","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[7,null,"C",8,"Other","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[8,"Investment Property Schedule E","C",16,"Rents received","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[9,null,"C",17,"Total expenses","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[10,null,"C",18,"Depreciation","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[11,null,"C",19,"Taxes","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[12,null,"C",20,"Mortgage Interest","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[13,null,"C",21,"Insurance","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[14,null,"C",22,"Other","#page1","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[15,"Business Rental Form 8825","C",34,"Gross Rents","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[16,null,"C",35,"Total Expenses","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[17,null,"C",36,"Depreciation","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[18,null,"C",37,"Taxes","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[19,null,"C",38,"Mortgage Interest","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[20,null,"C",39,"Insurance","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]
[21,null,"C",40,"Other","#page2","https://www.mgic.com/-/media/value-adds/seb/","22-25001-rental-worksheet-help-doc.pdf","view=fit"]

{"sheet":"NOTES","index":4,"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 Rental worksheet, open the '_HYPER_LKP_NEW_' worksheet and update the document, page numbers and links.  This updates the links throughout the Rental page.  After hyperlinks have been fixed, run the 'URLSetScreenTips' macro to update the screentips."]

{"sheet":"LOOKUPS","index":5,"n_rows":13,"n_cols":8,"rows_kept":13,"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.26,12,true,true]
[null,2021,0.27,11]
[null,2022,0.26,10]
[null,null,null,9]
[null,null,null,8]
[null,null,null,7]
[null,null,null,6]
[null,null,null,5]
[null,null,null,4]
[null,null,null,3]
[null,null,null,2]
[null,null,null,1]

{"sheet":"_HYPER_LKP_","index":6,"n_rows":224,"n_cols":13,"rows_kept":224,"cut":false,"hidden":true,"merged":[]}
["NUM","REF_CELL","REF_ROW","TEXT_DISP","WINDOW_STATE","BASE_PATH","FILE_NAME","HAS_PAGE","LDG_ZERO","PAGE","HAS_ADDTL","ADDTL","EXAMPLE_URL"]
[1,"C9",9,"Recurring Interest Income: LINE 1 or 1040 LINE 2b (2019 and 2018), LINE 8a (2017)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,21,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=21&view=fit"]
[2,"C10",10,"Recurring Dividend Income: LINE 5 or 1040 LINE 3b (2019 and 2018), LINE 9a (2017)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,21,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=21&view=fit"]
[3,"C19",19,"Net Profit (Loss): LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[4,"C20",20,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[5,"C21",21,"Depletion: LINE 12","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[6,"C22",22,"Depreciation: LINE 13","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[7,"C23",23,"Meals or Meals and Entertainment Exclusion: LINE 24b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[8,"C24",24,"Business Use of Home: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[9,"C25",25,"Business Miles: page 2, part IV, LINE 44a","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[10,"C26",26,"x Depreciation Rate 2019: $0.26, 2018: $0.25, 2017: $0.25","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[11,"C27",27,"= Total Mileage Depreciation","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[12,"C28",28,"Amortization/Casualty Loss (only if noted): page 2, part V","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[13,"C34",34,"Net Profit (Loss): LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[14,"C35",35,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[15,"C36",36,"Depletion: LINE 12","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[16,"C37",37,"Depreciation: LINE 13","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[17,"C38",38,"Meals or Meals and Entertainment Exclusion: LINE 24b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[18,"C39",39,"Business Use of Home: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[19,"C40",40,"Business Miles: page 2, part IV, LINE 44a","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[20,"C41",41,"x Depreciation Rate 2019: $0.26, 2018: $0.25, 2017: $0.25","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[21,"C42",42,"= Total Mileage Depreciation","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[22,"C43",43,"Amortization/Casualty Loss (only if noted): page 2, part V","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[23,"C49",49,"Net Profit (Loss): LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[24,"C50",50,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[25,"C51",51,"Depletion: LINE 12","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[26,"C52",52,"Depreciation: LINE 13","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[27,"C53",53,"Meals or Meals and Entertainment Exclusion: LINE 24b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[28,"C54",54,"Business Use of Home: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[29,"C55",55,"Business Miles: page 2, part IV, LINE 44a","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[30,"C56",56,"x Depreciation Rate 2019: $0.26, 2018: $0.25, 2017: $0.25","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[31,"C57",57,"= Total Mileage Depreciation","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[32,"C58",58,"Amortization/Casualty Loss (only if noted): page 2, part V","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[33,"C64",64,"Net Profit (Loss): LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[34,"C65",65,"Deduct nonrecurring income/add nonrecurring loss or expense: LINE 6","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,23,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=23&view=fit"]
[35,"C66",66,"Depletion: LINE 12","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[36,"C67",67,"Depreciation: LINE 13","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[37,"C68",68,"Meals or Meals and Entertainment Exclusion: LINE 24b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[38,"C69",69,"Business Use of Home: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,25,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=25&view=fit"]
[39,"C70",70,"Business Miles: page 2, part IV, LINE 44a","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[40,"C71",71,"x Depreciation Rate 2019: $0.26, 2018: $0.25, 2017: $0.25","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[41,"C72",72,"= Total Mileage Depreciation","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[42,"C73",73,"Amortization/Casualty Loss (only if noted): page 2, part V","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,27,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=27&view=fit"]
[43,"C80",80,"Recurring Capital Gains (Loss): page 2, LINE 16 (details on FORM 8949)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,33,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=33&view=fit"]
[44,"C87",87,"Royalty Income (Loss): LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,37,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=37&view=fit"]
[45,"C88",88,"Total Expenses: LINE 20","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,37,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=37&view=fit"]
[46,"C89",89,"Depletion: LINE 18","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,37,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=37&view=fit"]
[47,"C96",96,"Net Profit (Loss): LINE 34","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[48,"C97",97,"Non-Tax Portion Ongoing Co-op & CCC Pmts: LINES 3a minus b through 6a minus b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[49,"C98",98,"Deduct nonrecurring income/add nonrecurring loss: LINE 8 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[50,"C99",99,"Depreciation: LINE 14 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[51,"C100",100,"Amortization/Casualty Loss/Depletion (only if noted): LINE 32","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[52,"C101",101,"Business Use of Home (only if noted): LINE 32","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,45,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=45&view=fit"]
[53,"C112",112,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[54,"C113",113,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[55,"C114",114,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[56,"C120",120,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[57,"C124",124,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[58,"C125",125,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[59,"C126",126,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[60,"C127",127,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[61,"C128",128,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[62,"C129",129,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[63,"C130",130,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[64,"C131",131,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[65,"C144",144,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[66,"C145",145,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[67,"C146",146,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[68,"C152",152,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[69,"C156",156,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[70,"C157",157,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[71,"C158",158,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[72,"C159",159,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[73,"C160",160,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[74,"C161",161,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[75,"C162",162,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[76,"C163",163,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[77,"C176",176,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[78,"C177",177,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[79,"C178",178,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[80,"C184",184,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[81,"C188",188,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[82,"C189",189,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[83,"C190",190,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[84,"C191",191,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[85,"C192",192,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[86,"C193",193,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[87,"C194",194,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[88,"C195",195,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[89,"C208",208,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[90,"C209",209,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[91,"C210",210,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[92,"C216",216,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[93,"C220",220,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[94,"C221",221,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[95,"C222",222,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[96,"C223",223,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[97,"C224",224,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[98,"C225",225,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[99,"C226",226,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[100,"C227",227,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[101,"C240",240,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[102,"C241",241,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[103,"C242",242,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[104,"C248",248,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[105,"C252",252,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[106,"C253",253,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[107,"C254",254,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[108,"C255",255,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[109,"C256",256,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[110,"C257",257,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[111,"C258",258,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[112,"C259",259,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[113,"C272",272,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[114,"C273",273,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[115,"C274",274,"Guaranteed Payments to Partner: LINE 4","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,55,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=55&view=fit"]
[116,"C280",280,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[117,"C284",284,"Passthrough (Income) Loss from Other Partnerships: LINE 4 ","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[118,"C285",285,"Deduct nonrecurring income/add nonrecurring loss: LINES 5, 6 & 7","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[119,"C286",286,"Depreciation: LINE 16c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[120,"C287",287,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[121,"C288",288,"Depletion: LINE 17","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[122,"C289",289,"Amortization/Casualty Loss (only if noted): LINE 20 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,59,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=59&view=fit"]
[123,"C290",290,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 16, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[124,"C291",291,"Travel and Entertainment Exclusion: Schedule M-1, LINE 4b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,63,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=63&view=fit"]
[125,"C306",306,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[126,"C307",307,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[127,"C313",313,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[128,"C317",317,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[129,"C318",318,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[130,"C319",319,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[131,"C320",320,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[132,"C321",321,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[133,"C322",322,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[134,"C323",323,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[135,"C336",336,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[136,"C337",337,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[137,"C343",343,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[138,"C347",347,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[139,"C348",348,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[140,"C349",349,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[141,"C350",350,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[142,"C351",351,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[143,"C352",352,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[144,"C353",353,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[145,"C366",366,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[146,"C367",367,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[147,"C373",373,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[148,"C377",377,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[149,"C378",378,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[150,"C379",379,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[151,"C380",380,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[152,"C381",381,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[153,"C382",382,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[154,"C383",383,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[155,"C396",396,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[156,"C397",397,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[157,"C403",403,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[158,"C407",407,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[159,"C408",408,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[160,"C409",409,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[161,"C410",410,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[162,"C411",411,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[163,"C412",412,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[164,"C413",413,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[165,"C426",426,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[166,"C427",427,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[167,"C433",433,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[168,"C437",437,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[169,"C438",438,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[170,"C439",439,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[171,"C440",440,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[172,"C441",441,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[173,"C442",442,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[174,"C443",443,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[175,"C456",456,"Ordinary Income (Loss): LINE 1  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,65,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=65&view=fit"]
[176,"C457",457,"Net Rental Income (Loss): LINES 2 & 3  If > Distributions see additional requirements.","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,67,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=67&view=fit"]
[177,"C463",463,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[178,"C467",467,"Deduct nonrecurring income/add nonrecurring loss: LINES 4 & 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[179,"C468",468,"Depreciation: LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[180,"C469",469,"Depreciation (FORM 8825): LINE 14","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,77,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=77&view=fit"]
[181,"C470",470,"Depletion: LINE 15","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[182,"C471",471,"Amortization/Casualty Loss (only if noted): LINE 19 from attached statement","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,69,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=69&view=fit"]
[183,"C472",472,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,73,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=73&view=fit"]
[184,"C473",473,"Travel and Entertainment Exclusion: Schedule M-1, LINE 3b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,75,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=75&view=fit"]
[185,"C488",488,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[186,"C492",492,"Taxable Income: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[187,"C493",493,"Total Tax: LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[188,"C494",494,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[189,"C495",495,"Deduct nonrecurring income/add nonrecurring loss: LINE 10","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[190,"C496",496,"Depreciation: LINE 20","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[191,"C497",497,"Depletion: LINE 21","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[192,"C498",498,"Domestic Production Activities Deduction: LINE 25 (2017)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[193,"C499",499,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[194,"C500",500,"Net Operating Loss and Special Deductions: LINES 29a & b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[195,"C501",501,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[196,"C502",502,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[197,"C507",507,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[198,"C516",516,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[199,"C520",520,"Taxable Income: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[200,"C521",521,"Total Tax: LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[201,"C522",522,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[202,"C523",523,"Deduct nonrecurring income/add nonrecurring loss: LINE 10","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[203,"C524",524,"Depreciation: LINE 20","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[204,"C525",525,"Depletion: LINE 21","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[205,"C526",526,"Domestic Production Activities Deduction: LINE 25 (2017)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[206,"C527",527,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[207,"C528",528,"Net Operating Loss and Special Deductions: LINES 29a & b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[208,"C529",529,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[209,"C530",530,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[210,"C535",535,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[211,"C544",544,"Wages: W-2, Box 5 (in general)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,13,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=13&view=fit"]
[212,"C548",548,"Taxable Income: LINE 30","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[213,"C549",549,"Total Tax: LINE 31","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[214,"C550",550,"Deduct nonrecurring gains/add nonrecurring losses: LINES 8 & 9","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[215,"C551",551,"Deduct nonrecurring income/add nonrecurring loss: LINE 10","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[216,"C552",552,"Depreciation: LINE 20","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[217,"C553",553,"Depletion: LINE 21","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,79,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=79&view=fit"]
[218,"C554",554,"Domestic Production Activities Deduction: LINE 25 (2017)","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[219,"C555",555,"Amortization/Casualty Loss (only if noted): LINE 26 from attached schedule","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[220,"C556",556,"Net Operating Loss and Special Deductions: LINES 29a & b","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,81,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=81&view=fit"]
[221,"C557",557,"Mortgages or Notes Payable in Less Than 1 Year: Schedule L, LINE 17, Column d","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[222,"C558",558,"Travel and Entertainment Exclusion: Schedule M-1, LINE 5c","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]
[223,"C563",563,"Dividends Paid to Borrower: Form 1040, Schedule B, LINE 5","Show_Maximized","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2018.pdf",true,false,85,true,"view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=85&view=fit"]

{"sheet":"Rental (2)","index":7,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["Row #","Line Text","Link"]
["Primary Residence Schedule E"]
[2,"Income (loss)","#page39"]
[3,"Depreciation","#page39"]
[4,"Taxes","#page39"]
[5,"Mortgage Interest","#page39"]
[6,"Insurance","#page39"]
[7,"Other","#page39"]
[]
["Investment Property Schedule E"]
[15,"Income (loss)","#page39"]
[16,"Depreciation","#page39"]
[17,"Taxes","#page39"]
[18,"Mortgage Interest","#page39"]
[19,"Insurance","#page39"]
[20,"Other","#page39"]
[]
["Business Rental Form 8825"]
[32,"Income (loss)","#page77"]
[33,"Depreciation","#page77"]
[34,"Taxes","#page77"]
[35,"Mortgage Interest","#page77"]
[36,"Insurance","#page77"]
[37,"Other","#page77"]