{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Rental","_HYPER_LKP_NEW_","Rental (2)","LOOKUPS","_HYPER_LKP_"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":10,"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":702,"n_cols":13,"rows_kept":702,"cut":false,"hidden":false,"merged":[[584,9,584,10],[492,2,493,2],[493,3,493,7],[494,3,494,7],[495,3,495,7],[496,3,496,7],[497,3,497,7],[498,3,498,7],[499,4,499,6],[504,9,504,10],[572,2,573,2],[578,3,578,7],[579,4,579,6],[552,9,552,10],[554,4,554,11],[556,2,557,2],[538,4,538,11],[540,2,541,2],[541,3,541,7],[561,3,561,7],[562,3,562,7],[456,9,456,10],[458,4,458,11],[563,4,563,6],[536,9,536,10],[545,3,545,7],[546,3,546,7],[547,4,547,6],[508,2,509,2],[511,3,511,7],[512,3,512,7],[513,3,513,7],[514,3,514,7],[515,4,515,6],[542,3,542,7],[543,3,543,7],[544,3,544,7],[559,3,559,7],[560,3,560,7],[520,9,520,10],[522,4,522,11],[524,2,525,2],[525,3,525,7],[528,3,528,7],[529,3,529,7],[530,3,530,7],[531,4,531,6],[557,3,557,7],[558,3,558,7],[692,3,692,7],[692,9,692,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],[702,2,709,13],[684,3,684,7],[684,9,684,10],[685,3,685,7],[685,9,685,10],[686,3,686,7],[686,9,686,10],[688,4,688,11],[690,2,691,2],[691,3,691,7],[691,9,691,10],[676,3,676,7],[676,9,676,10],[677,3,677,7],[677,9,677,10],[679,4,679,11],[681,2,682,2],[682,3,682,7],[682,9,682,10],[683,3,683,7],[683,9,683,10],[668,3,668,7],[668,9,668,10],[670,4,670,11],[672,2,673,2],[673,3,673,7],[673,9,673,10],[674,3,674,7],[674,9,674,10],[675,3,675,7],[675,9,675,10],[663,2,664,2],[664,3,664,7],[664,9,664,10],[665,3,665,7],[665,9,665,10],[666,3,666,7],[666,9,666,10],[667,3,667,7],[667,9,667,10],[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],[661,4,661,11],[648,3,648,7],[648,9,648,10],[649,3,649,7],[649,9,649,10],[650,3,650,7],[650,9,650,10],[652,4,652,11],[654,2,655,2],[655,3,655,7],[655,9,655,10],[640,3,640,7],[640,9,640,10],[641,3,641,7],[641,9,641,10],[643,4,643,11],[645,2,646,2],[646,3,646,7],[646,9,646,10],[647,3,647,7],[647,9,647,10],[632,3,632,7],[632,9,632,10],[634,4,634,11],[636,2,637,2],[637,3,637,7],[637,9,637,10],[638,3,638,7],[638,9,638,10],[639,3,639,7],[639,9,639,10],[627,2,628,2],[628,3,628,7],[628,9,628,10],[629,3,629,7],[629,9,629,10],[630,3,630,7],[630,9,630,10],[631,3,631,7],[631,9,631,10],[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],[625,4,625,11],[612,3,612,7],[612,9,612,10],[613,3,613,7],[613,9,613,10],[614,3,614,7],[614,9,614,10],[616,4,616,11],[618,2,619,2],[619,3,619,7],[619,9,619,10],[604,3,604,7],[604,9,604,10],[605,3,605,7],[605,9,605,10],[607,4,607,11],[609,2,610,2],[610,3,610,7],[610,9,610,10],[611,3,611,7],[611,9,611,10],[596,3,596,7],[596,9,596,10],[598,4,598,11],[600,2,601,2],[601,3,601,7],[601,9,601,10],[602,3,602,7],[602,9,602,10],[603,3,603,7],[603,9,603,10],[591,2,592,2],[592,3,592,7],[592,9,592,10],[593,3,593,7],[593,9,593,10],[594,3,594,7],[594,9,594,10],[595,3,595,7],[595,9,595,10],[587,3,587,7],[589,4,589,11],[430,3,430,7],[431,3,431,7],[432,3,432,7],[435,4,435,6],[440,9,440,10],[442,4,442,11],[462,3,462,7],[463,3,463,7],[464,3,464,7],[467,4,467,6],[472,9,472,10],[474,4,474,11],[506,4,506,11],[509,3,509,7],[510,3,510,7],[568,9,568,10],[570,4,570,11],[573,3,573,7],[574,3,574,7],[575,3,575,7],[576,3,576,7],[577,3,577,7],[476,2,477,2],[424,9,424,10],[418,3,418,7],[419,4,419,6],[483,4,483,6],[433,3,433,7],[434,3,434,7],[526,3,526,7],[527,3,527,7],[426,4,426,11],[428,2,429,2],[429,3,429,7],[444,2,445,2],[445,3,445,7],[446,3,446,7],[447,3,447,7],[448,3,448,7],[451,4,451,6],[460,2,461,2],[461,3,461,7],[449,3,449,7],[450,3,450,7],[488,9,488,10],[490,4,490,11],[414,3,414,7],[415,3,415,7],[416,3,416,7],[482,3,482,7],[465,3,465,7],[466,3,466,7],[479,3,479,7],[480,3,480,7],[481,3,481,7],[477,3,477,7],[478,3,478,7],[386,3,386,7],[386,9,386,10],[383,3,383,7],[383,9,383,10],[384,3,384,7],[384,9,384,10],[385,3,385,7],[385,9,385,10],[417,3,417,7],[402,3,402,7],[403,4,403,6],[408,9,408,10],[390,1,390,8],[392,3,392,7],[394,4,394,11],[396,2,397,2],[397,3,397,7],[398,3,398,7],[399,3,399,7],[400,3,400,7],[401,3,401,7],[410,4,410,11],[412,2,413,2],[413,3,413,7],[377,3,377,7],[377,9,377,10],[379,4,379,11],[381,2,382,2],[382,3,382,7],[382,9,382,10],[374,3,374,7],[374,9,374,10],[375,3,375,7],[375,9,375,10],[376,3,376,7],[376,9,376,10],[368,3,368,7],[368,9,368,10],[370,4,370,11],[372,2,373,2],[373,3,373,7],[373,9,373,10],[365,3,365,7],[365,9,365,10],[366,3,366,7],[366,9,366,10],[367,3,367,7],[367,9,367,10],[359,3,359,7],[359,9,359,10],[361,4,361,11],[363,2,364,2],[364,3,364,7],[364,9,364,10],[356,3,356,7],[356,9,356,10],[357,3,357,7],[357,9,357,10],[358,3,358,7],[358,9,358,10],[350,3,350,7],[350,9,350,10],[352,4,352,11],[354,2,355,2],[355,3,355,7],[355,9,355,10],[347,3,347,7],[347,9,347,10],[348,3,348,7],[348,9,348,10],[349,3,349,7],[349,9,349,10],[341,3,341,7],[341,9,341,10],[343,4,343,11],[345,2,346,2],[346,3,346,7],[346,9,346,10],[338,3,338,7],[338,9,338,10],[339,3,339,7],[339,9,339,10],[340,3,340,7],[340,9,340,10],[332,3,332,7],[332,9,332,10],[334,4,334,11],[336,2,337,2],[337,3,337,7],[337,9,337,10],[329,3,329,7],[329,9,329,10],[330,3,330,7],[330,9,330,10],[331,3,331,7],[331,9,331,10],[323,3,323,7],[323,9,323,10],[325,4,325,11],[327,2,328,2],[328,3,328,7],[328,9,328,10],[320,3,320,7],[320,9,320,10],[321,3,321,7],[321,9,321,10],[322,3,322,7],[322,9,322,10],[314,3,314,7],[314,9,314,10],[316,4,316,11],[318,2,319,2],[319,3,319,7],[319,9,319,10],[311,3,311,7],[311,9,311,10],[312,3,312,7],[312,9,312,10],[313,3,313,7],[313,9,313,10],[305,3,305,7],[305,9,305,10],[307,4,307,11],[309,2,310,2],[310,3,310,7],[310,9,310,10],[302,3,302,7],[302,9,302,10],[303,3,303,7],[303,9,303,10],[304,3,304,7],[304,9,304,10],[296,3,296,7],[296,9,296,10],[298,4,298,11],[300,2,301,2],[301,3,301,7],[301,9,301,10],[293,3,293,7],[293,9,293,10],[294,3,294,7],[294,9,294,10],[295,3,295,7],[295,9,295,10],[282,2,283,2],[283,3,283,7],[283,9,283,10],[287,3,287,7],[287,9,287,10],[289,4,289,11],[291,2,292,2],[292,3,292,7],[292,9,292,10],[284,3,284,7],[284,9,284,10],[285,3,285,7],[285,9,285,10],[286,3,286,7],[286,9,286,10],[265,3,265,7],[266,3,266,7],[267,3,267,7],[268,3,268,7],[269,3,269,7],[270,4,270,6],[275,9,275,10],[278,3,278,7],[280,4,280,11],[250,3,250,7],[251,3,251,7],[252,3,252,7],[253,3,253,7],[254,4,254,6],[259,9,259,10],[261,4,261,11],[263,2,264,2],[264,3,264,7],[235,3,235,7],[236,3,236,7],[237,3,237,7],[238,4,238,6],[243,9,243,10],[245,4,245,11],[247,2,248,2],[248,3,248,7],[249,3,249,7],[220,3,220,7],[221,3,221,7],[222,4,222,6],[227,9,227,10],[229,4,229,11],[231,2,232,2],[232,3,232,7],[233,3,233,7],[234,3,234,7],[205,3,205,7],[206,4,206,6],[211,9,211,10],[213,4,213,11],[215,2,216,2],[216,3,216,7],[217,3,217,7],[218,3,218,7],[219,3,219,7],[190,4,190,6],[195,9,195,10],[197,4,197,11],[199,2,200,2],[200,3,200,7],[201,3,201,7],[202,3,202,7],[203,3,203,7],[204,3,204,7],[189,3,189,7],[174,4,174,6],[179,9,179,10],[181,4,181,11],[183,2,184,2],[184,3,184,7],[185,3,185,7],[186,3,186,7],[187,3,187,7],[188,3,188,7],[147,9,147,10],[149,4,149,11],[151,2,152,2],[152,3,152,7],[153,3,153,7],[154,3,154,7],[172,3,172,7],[173,3,173,7],[157,3,157,7],[158,4,158,6],[163,9,163,10],[165,4,165,11],[167,2,168,2],[168,3,168,7],[169,3,169,7],[170,3,170,7],[171,3,171,7],[138,3,138,7],[139,3,139,7],[123,3,123,7],[124,3,124,7],[125,3,125,7],[137,3,137,7],[155,3,155,7],[156,3,156,7],[140,3,140,7],[141,3,141,7],[142,4,142,6],[93,3,93,7],[94,4,94,6],[99,9,99,10],[83,3,83,7],[85,4,85,11],[87,2,88,2],[88,3,88,7],[89,3,89,7],[90,3,90,7],[91,3,91,7],[76,3,76,7],[76,9,76,10],[77,3,77,7],[77,9,77,10],[72,4,72,11],[74,2,75,2],[75,3,75,7],[75,9,75,10],[92,3,92,7],[69,3,69,7],[2,12,2,13],[22,4,22,6],[6,2,6,13],[16,3,16,7],[17,3,17,7],[18,3,18,7],[19,3,19,7],[20,3,20,7],[21,3,21,7],[13,4,13,11],[2,1,2,4],[5,2,5,13],[4,2,4,13],[11,3,11,7],[15,2,16,2],[53,9,53,10],[9,1,9,8],[7,12,7,13],[2,5,2,8],[29,2,30,2],[43,2,44,2],[56,3,56,7],[58,4,58,11],[60,2,61,2],[61,3,61,7],[62,3,62,7],[63,3,63,7],[61,9,61,10],[62,9,62,10],[63,9,63,10],[65,4,65,11],[67,2,68,2],[33,3,33,7],[34,3,34,7],[68,3,68,7],[81,1,81,8],[25,9,25,10],[27,4,27,11],[30,3,30,7],[31,3,31,7],[32,3,32,7],[35,3,35,7],[36,4,36,6],[39,9,39,10],[41,4,41,11],[44,3,44,7],[45,3,45,7],[46,3,46,7],[70,3,70,7],[68,9,68,10],[69,9,69,10],[70,9,70,10],[47,3,47,7],[48,3,48,7],[49,3,49,7],[50,4,50,6],[101,4,101,11],[115,9,115,10],[117,4,117,11],[119,2,120,2],[120,3,120,7],[126,4,126,6],[131,9,131,10],[133,4,133,11],[135,2,136,2],[136,3,136,7],[121,3,121,7],[122,3,122,7],[107,3,107,7],[108,3,108,7],[103,2,104,2],[104,3,104,7],[105,3,105,7],[106,3,106,7],[109,3,109,7],[110,4,110,6]]}
[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 14-16 & 20)."]
[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,null,null,null,null,null,null,"YEAR 1: ",null,null,"YEAR 2: "]
[]
[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,"Income (Loss):  Schedule E Line 21"]
[null,null,3,"Depreciation:  Schedule E Line 18"]
[null,null,4,"Taxes:  Schedule E Line 16"]
[null,null,5,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,6,"Insurance:  Schedule E Line 9"]
[null,null,7,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,8,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I18:I23)","v":0},null,null,{"$f":"SUM(L18:L23)","v":0}]
[null,null,9,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I24/I17,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L24/L17,\"N/A\")","v":"N/A"}]
[null,null,10,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I17),ISNUMBER(L17)),I17+L17,IF(ISNUMBER(I17),I17,IF(ISNUMBER(L17),L17,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I17),ISNUMBER(L17),ISNUMBER(I24),ISNUMBER(L24)),(I24+L24)/(I17+L17),IF(AND(OR(NOT(ISNUMBER(L17)),NOT(ISNUMBER(L24))),ISNUMBER(I17),ISNUMBER(I24)),I24/I17,IF(AND(OR(NOT(ISNUMBER(I17)),NOT(ISNUMBER(I24))),ISNUMBER(L17),ISNUMBER(L24)),L24/L17,\"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,"Income (Loss):  Schedule E Line 21"]
[null,null,3,"Depreciation:  Schedule E Line 18"]
[null,null,4,"Taxes:  Schedule E Line 16"]
[null,null,5,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,6,"Insurance:  Schedule E Line 9"]
[null,null,7,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,8,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I32:I37)","v":0},null,null,{"$f":"SUM(L32:L37)","v":0}]
[null,null,9,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I38/I31,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L38/L31,\"N/A\")","v":"N/A"}]
[null,null,10,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I31),ISNUMBER(L31)),I31+L31,IF(ISNUMBER(I31),I31,IF(ISNUMBER(L31),L31,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I31),ISNUMBER(L31),ISNUMBER(I38),ISNUMBER(L38)),(I38+L38)/(I31+L31),IF(AND(OR(NOT(ISNUMBER(L31)),NOT(ISNUMBER(L38))),ISNUMBER(I31),ISNUMBER(I38)),I38/I31,IF(AND(OR(NOT(ISNUMBER(I31)),NOT(ISNUMBER(I38))),ISNUMBER(L31),ISNUMBER(L38)),L38/L31,\"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,"Income (Loss):  Schedule E Line 21"]
[null,null,3,"Depreciation:  Schedule E Line 18"]
[null,null,4,"Taxes:  Schedule E Line 16"]
[null,null,5,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,6,"Insurance:  Schedule E Line 9"]
[null,null,7,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,8,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I46:I51)","v":0},null,null,{"$f":"SUM(L46:L51)","v":0}]
[null,null,9,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I52/I45,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L52/L45,\"N/A\")","v":"N/A"}]
[null,null,10,{"$f":"\"Average Monthly Gross Rental Income (Loss) \"&IF(AND(ISNUMBER(I45),ISNUMBER(L45)),I45+L45,IF(ISNUMBER(I45),I45,IF(ISNUMBER(L45),L45,\"____\")))&\" months\"","v":"Average Monthly Gross Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I45),ISNUMBER(L45),ISNUMBER(I52),ISNUMBER(L52)),(I52+L52)/(I45+L45),IF(AND(OR(NOT(ISNUMBER(L45)),NOT(ISNUMBER(L52))),ISNUMBER(I45),ISNUMBER(I52)),I52/I45,IF(AND(OR(NOT(ISNUMBER(I45)),NOT(ISNUMBER(I52))),ISNUMBER(L45),ISNUMBER(L52)),L52/L45,\"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,11]
[null,null,null,"Gross Monthly Rent"]
[null,null,12,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J62","v":0}]
[null,null,13,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J62+J63","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,11]
[null,null,null,"Gross Monthly Rent"]
[null,null,12,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J69","v":0}]
[null,null,13,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J69+J70","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,11]
[null,null,null,"Gross Monthly Rent"]
[null,null,12,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J76","v":0}]
[null,null,13,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J76+J77","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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I90:I95)","v":0},null,null,{"$f":"SUM(L90:L95)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I96/I89,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L96/L89,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I97-I98,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L97-L98,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I89),ISNUMBER(L89)),I89+L89,IF(ISNUMBER(I89),I89,IF(ISNUMBER(L89),L89,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I89),ISNUMBER(L89),ISNUMBER(I99),ISNUMBER(L99)),((I89*I99)+(L89*L99))/(I89+L89),IF(AND(OR(NOT(ISNUMBER(L89)),NOT(ISNUMBER(L99))),ISNUMBER(I89),ISNUMBER(I99)),I99,IF(AND(OR(NOT(ISNUMBER(I89)),NOT(ISNUMBER(I99))),ISNUMBER(L89),ISNUMBER(L99)),L99,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I106:I111)","v":0},null,null,{"$f":"SUM(L106:L111)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I112/I105,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L112/L105,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I113-I114,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L113-L114,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I105),ISNUMBER(L105)),I105+L105,IF(ISNUMBER(I105),I105,IF(ISNUMBER(L105),L105,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I105),ISNUMBER(L105),ISNUMBER(I115),ISNUMBER(L115)),((I105*I115)+(L105*L115))/(I105+L105),IF(AND(OR(NOT(ISNUMBER(L105)),NOT(ISNUMBER(L115))),ISNUMBER(I105),ISNUMBER(I115)),I115,IF(AND(OR(NOT(ISNUMBER(I105)),NOT(ISNUMBER(I115))),ISNUMBER(L105),ISNUMBER(L115)),L115,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I122:I127)","v":0},null,null,{"$f":"SUM(L122:L127)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I128/I121,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L128/L121,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I129-I130,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L129-L130,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I121),ISNUMBER(L121)),I121+L121,IF(ISNUMBER(I121),I121,IF(ISNUMBER(L121),L121,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I121),ISNUMBER(L121),ISNUMBER(I131),ISNUMBER(L131)),((I121*I131)+(L121*L131))/(I121+L121),IF(AND(OR(NOT(ISNUMBER(L121)),NOT(ISNUMBER(L131))),ISNUMBER(I121),ISNUMBER(I131)),I131,IF(AND(OR(NOT(ISNUMBER(I121)),NOT(ISNUMBER(I131))),ISNUMBER(L121),ISNUMBER(L131)),L131,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I138:I143)","v":0},null,null,{"$f":"SUM(L138:L143)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I144/I137,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L144/L137,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I145-I146,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L145-L146,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I137),ISNUMBER(L137)),I137+L137,IF(ISNUMBER(I137),I137,IF(ISNUMBER(L137),L137,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I137),ISNUMBER(L137),ISNUMBER(I147),ISNUMBER(L147)),((I137*I147)+(L137*L147))/(I137+L137),IF(AND(OR(NOT(ISNUMBER(L137)),NOT(ISNUMBER(L147))),ISNUMBER(I137),ISNUMBER(I147)),I147,IF(AND(OR(NOT(ISNUMBER(I137)),NOT(ISNUMBER(I147))),ISNUMBER(L137),ISNUMBER(L147)),L147,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I154:I159)","v":0},null,null,{"$f":"SUM(L154:L159)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I160/I153,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L160/L153,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I161-I162,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L161-L162,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I153),ISNUMBER(L153)),I153+L153,IF(ISNUMBER(I153),I153,IF(ISNUMBER(L153),L153,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I153),ISNUMBER(L153),ISNUMBER(I163),ISNUMBER(L163)),((I153*I163)+(L153*L163))/(I153+L153),IF(AND(OR(NOT(ISNUMBER(L153)),NOT(ISNUMBER(L163))),ISNUMBER(I153),ISNUMBER(I163)),I163,IF(AND(OR(NOT(ISNUMBER(I153)),NOT(ISNUMBER(I163))),ISNUMBER(L153),ISNUMBER(L163)),L163,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I170:I175)","v":0},null,null,{"$f":"SUM(L170:L175)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I176/I169,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L176/L169,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I177-I178,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L177-L178,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I169),ISNUMBER(L169)),I169+L169,IF(ISNUMBER(I169),I169,IF(ISNUMBER(L169),L169,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I169),ISNUMBER(L169),ISNUMBER(I179),ISNUMBER(L179)),((I169*I179)+(L169*L179))/(I169+L169),IF(AND(OR(NOT(ISNUMBER(L169)),NOT(ISNUMBER(L179))),ISNUMBER(I169),ISNUMBER(I179)),I179,IF(AND(OR(NOT(ISNUMBER(I169)),NOT(ISNUMBER(I179))),ISNUMBER(L169),ISNUMBER(L179)),L179,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I186:I191)","v":0},null,null,{"$f":"SUM(L186:L191)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I192/I185,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L192/L185,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I193-I194,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L193-L194,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I185),ISNUMBER(L185)),I185+L185,IF(ISNUMBER(I185),I185,IF(ISNUMBER(L185),L185,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I185),ISNUMBER(L185),ISNUMBER(I195),ISNUMBER(L195)),((I185*I195)+(L185*L195))/(I185+L185),IF(AND(OR(NOT(ISNUMBER(L185)),NOT(ISNUMBER(L195))),ISNUMBER(I185),ISNUMBER(I195)),I195,IF(AND(OR(NOT(ISNUMBER(I185)),NOT(ISNUMBER(I195))),ISNUMBER(L185),ISNUMBER(L195)),L195,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I202:I207)","v":0},null,null,{"$f":"SUM(L202:L207)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I208/I201,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L208/L201,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I209-I210,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L209-L210,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I201),ISNUMBER(L201)),I201+L201,IF(ISNUMBER(I201),I201,IF(ISNUMBER(L201),L201,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I201),ISNUMBER(L201),ISNUMBER(I211),ISNUMBER(L211)),((I201*I211)+(L201*L211))/(I201+L201),IF(AND(OR(NOT(ISNUMBER(L201)),NOT(ISNUMBER(L211))),ISNUMBER(I201),ISNUMBER(I211)),I211,IF(AND(OR(NOT(ISNUMBER(I201)),NOT(ISNUMBER(I211))),ISNUMBER(L201),ISNUMBER(L211)),L211,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I218:I223)","v":0},null,null,{"$f":"SUM(L218:L223)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I224/I217,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L224/L217,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I225-I226,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L225-L226,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I217),ISNUMBER(L217)),I217+L217,IF(ISNUMBER(I217),I217,IF(ISNUMBER(L217),L217,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I217),ISNUMBER(L217),ISNUMBER(I227),ISNUMBER(L227)),((I217*I227)+(L217*L227))/(I217+L217),IF(AND(OR(NOT(ISNUMBER(L217)),NOT(ISNUMBER(L227))),ISNUMBER(I217),ISNUMBER(I227)),I227,IF(AND(OR(NOT(ISNUMBER(I217)),NOT(ISNUMBER(I227))),ISNUMBER(L217),ISNUMBER(L227)),L227,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I234:I239)","v":0},null,null,{"$f":"SUM(L234:L239)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I240/I233,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L240/L233,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I241-I242,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L241-L242,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I233),ISNUMBER(L233)),I233+L233,IF(ISNUMBER(I233),I233,IF(ISNUMBER(L233),L233,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I233),ISNUMBER(L233),ISNUMBER(I243),ISNUMBER(L243)),((I233*I243)+(L233*L243))/(I233+L233),IF(AND(OR(NOT(ISNUMBER(L233)),NOT(ISNUMBER(L243))),ISNUMBER(I233),ISNUMBER(I243)),I243,IF(AND(OR(NOT(ISNUMBER(I233)),NOT(ISNUMBER(I243))),ISNUMBER(L233),ISNUMBER(L243)),L243,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I250:I255)","v":0},null,null,{"$f":"SUM(L250:L255)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I256/I249,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L256/L249,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I257-I258,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L257-L258,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I249),ISNUMBER(L249)),I249+L249,IF(ISNUMBER(I249),I249,IF(ISNUMBER(L249),L249,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I249),ISNUMBER(L249),ISNUMBER(I259),ISNUMBER(L259)),((I249*I259)+(L249*L259))/(I249+L249),IF(AND(OR(NOT(ISNUMBER(L249)),NOT(ISNUMBER(L259))),ISNUMBER(I249),ISNUMBER(I259)),I259,IF(AND(OR(NOT(ISNUMBER(I249)),NOT(ISNUMBER(I259))),ISNUMBER(L249),ISNUMBER(L259)),L259,\"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,14]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,15,"Income (Loss):  Schedule E Line 21"]
[null,null,16,"Depreciation:  Schedule E Line 18"]
[null,null,17,"Taxes:  Schedule E Line 16"]
[null,null,18,"Mortgage Interest:  Schedule E Lines 12 & 13"]
[null,null,19,"Insurance:  Schedule E Line 9"]
[null,null,20,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Schedule E Line 19"]
[null,null,21,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I266:I271)","v":0},null,null,{"$f":"SUM(L266:L271)","v":0}]
[null,null,22,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I272/I265,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L272/L265,\"N/A\")","v":"N/A"}]
[null,null,23,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,24,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I273-I274,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L273-L274,\"N/A\")","v":"N/A"}]
[null,null,25,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I265),ISNUMBER(L265)),I265+L265,IF(ISNUMBER(I265),I265,IF(ISNUMBER(L265),L265,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I265),ISNUMBER(L265),ISNUMBER(I275),ISNUMBER(L275)),((I265*I275)+(L265*L275))/(I265+L265),IF(AND(OR(NOT(ISNUMBER(L265)),NOT(ISNUMBER(L275))),ISNUMBER(I265),ISNUMBER(I275)),I275,IF(AND(OR(NOT(ISNUMBER(I265)),NOT(ISNUMBER(I275))),ISNUMBER(L265),ISNUMBER(L275)),L275,\"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,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J284","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J284+J285","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J286-J287","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J293","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J293+J294","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J295-J296","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J302","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J302+J303","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J304-J305","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J311","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J311+J312","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J313-J314","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J320","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J320+J321","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J322-J323","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J329","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J329+J330","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J331-J332","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J338","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J338+J339","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J340-J341","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J347","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J347+J348","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J349-J350","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J356","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J356+J357","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J358-J359","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J365","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J365+J366","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J367-J368","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J374","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J374+J375","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J376-J377","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,26]
[null,null,null,"Gross Monthly Rent"]
[null,null,27,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J383","v":0}]
[null,null,28,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J383+J384","v":0}]
[null,null,29,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,30,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J385-J386","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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I399:I404)","v":0},null,null,{"$f":"SUM(L399:L404)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I405/I398,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L405/L398,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I406-I407,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L406-L407,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I398),ISNUMBER(L398)),I398+L398,IF(ISNUMBER(I398),I398,IF(ISNUMBER(L398),L398,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I398),ISNUMBER(L398),ISNUMBER(I408),ISNUMBER(L408)),((I398*I408)+(L398*L408))/(I398+L398),IF(AND(OR(NOT(ISNUMBER(L398)),NOT(ISNUMBER(L408))),ISNUMBER(I398),ISNUMBER(I408)),I408,IF(AND(OR(NOT(ISNUMBER(I398)),NOT(ISNUMBER(I408))),ISNUMBER(L398),ISNUMBER(L408)),L408,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I415:I420)","v":0},null,null,{"$f":"SUM(L415:L420)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I421/I414,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L421/L414,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I422-I423,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L422-L423,\"N/A\")","v":"N/A"}]
[null,null,42,{"$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(I424),ISNUMBER(L424)),((I414*I424)+(L414*L424))/(I414+L414),IF(AND(OR(NOT(ISNUMBER(L414)),NOT(ISNUMBER(L424))),ISNUMBER(I414),ISNUMBER(I424)),I424,IF(AND(OR(NOT(ISNUMBER(I414)),NOT(ISNUMBER(I424))),ISNUMBER(L414),ISNUMBER(L424)),L424,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I431:I436)","v":0},null,null,{"$f":"SUM(L431:L436)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I437/I430,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L437/L430,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I438-I439,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L438-L439,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I430),ISNUMBER(L430)),I430+L430,IF(ISNUMBER(I430),I430,IF(ISNUMBER(L430),L430,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I430),ISNUMBER(L430),ISNUMBER(I440),ISNUMBER(L440)),((I430*I440)+(L430*L440))/(I430+L430),IF(AND(OR(NOT(ISNUMBER(L430)),NOT(ISNUMBER(L440))),ISNUMBER(I430),ISNUMBER(I440)),I440,IF(AND(OR(NOT(ISNUMBER(I430)),NOT(ISNUMBER(I440))),ISNUMBER(L430),ISNUMBER(L440)),L440,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I447:I452)","v":0},null,null,{"$f":"SUM(L447:L452)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I453/I446,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L453/L446,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I454-I455,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L454-L455,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I446),ISNUMBER(L446)),I446+L446,IF(ISNUMBER(I446),I446,IF(ISNUMBER(L446),L446,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I446),ISNUMBER(L446),ISNUMBER(I456),ISNUMBER(L456)),((I446*I456)+(L446*L456))/(I446+L446),IF(AND(OR(NOT(ISNUMBER(L446)),NOT(ISNUMBER(L456))),ISNUMBER(I446),ISNUMBER(I456)),I456,IF(AND(OR(NOT(ISNUMBER(I446)),NOT(ISNUMBER(I456))),ISNUMBER(L446),ISNUMBER(L456)),L456,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I463:I468)","v":0},null,null,{"$f":"SUM(L463:L468)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I469/I462,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L469/L462,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I470-I471,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L470-L471,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I462),ISNUMBER(L462)),I462+L462,IF(ISNUMBER(I462),I462,IF(ISNUMBER(L462),L462,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I462),ISNUMBER(L462),ISNUMBER(I472),ISNUMBER(L472)),((I462*I472)+(L462*L472))/(I462+L462),IF(AND(OR(NOT(ISNUMBER(L462)),NOT(ISNUMBER(L472))),ISNUMBER(I462),ISNUMBER(I472)),I472,IF(AND(OR(NOT(ISNUMBER(I462)),NOT(ISNUMBER(I472))),ISNUMBER(L462),ISNUMBER(L472)),L472,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I479:I484)","v":0},null,null,{"$f":"SUM(L479:L484)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I485/I478,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L485/L478,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I486-I487,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L486-L487,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I478),ISNUMBER(L478)),I478+L478,IF(ISNUMBER(I478),I478,IF(ISNUMBER(L478),L478,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I478),ISNUMBER(L478),ISNUMBER(I488),ISNUMBER(L488)),((I478*I488)+(L478*L488))/(I478+L478),IF(AND(OR(NOT(ISNUMBER(L478)),NOT(ISNUMBER(L488))),ISNUMBER(I478),ISNUMBER(I488)),I488,IF(AND(OR(NOT(ISNUMBER(I478)),NOT(ISNUMBER(I488))),ISNUMBER(L478),ISNUMBER(L488)),L488,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I495:I500)","v":0},null,null,{"$f":"SUM(L495:L500)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I501/I494,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L501/L494,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I502-I503,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L502-L503,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I494),ISNUMBER(L494)),I494+L494,IF(ISNUMBER(I494),I494,IF(ISNUMBER(L494),L494,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I494),ISNUMBER(L494),ISNUMBER(I504),ISNUMBER(L504)),((I494*I504)+(L494*L504))/(I494+L494),IF(AND(OR(NOT(ISNUMBER(L494)),NOT(ISNUMBER(L504))),ISNUMBER(I494),ISNUMBER(I504)),I504,IF(AND(OR(NOT(ISNUMBER(I494)),NOT(ISNUMBER(I504))),ISNUMBER(L494),ISNUMBER(L504)),L504,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I511:I516)","v":0},null,null,{"$f":"SUM(L511:L516)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I517/I510,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L517/L510,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I518-I519,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L518-L519,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I510),ISNUMBER(L510)),I510+L510,IF(ISNUMBER(I510),I510,IF(ISNUMBER(L510),L510,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I510),ISNUMBER(L510),ISNUMBER(I520),ISNUMBER(L520)),((I510*I520)+(L510*L520))/(I510+L510),IF(AND(OR(NOT(ISNUMBER(L510)),NOT(ISNUMBER(L520))),ISNUMBER(I510),ISNUMBER(I520)),I520,IF(AND(OR(NOT(ISNUMBER(I510)),NOT(ISNUMBER(I520))),ISNUMBER(L510),ISNUMBER(L520)),L520,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I527:I532)","v":0},null,null,{"$f":"SUM(L527:L532)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I533/I526,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L533/L526,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I534-I535,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L534-L535,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I526),ISNUMBER(L526)),I526+L526,IF(ISNUMBER(I526),I526,IF(ISNUMBER(L526),L526,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I526),ISNUMBER(L526),ISNUMBER(I536),ISNUMBER(L536)),((I526*I536)+(L526*L536))/(I526+L526),IF(AND(OR(NOT(ISNUMBER(L526)),NOT(ISNUMBER(L536))),ISNUMBER(I526),ISNUMBER(I536)),I536,IF(AND(OR(NOT(ISNUMBER(I526)),NOT(ISNUMBER(I536))),ISNUMBER(L526),ISNUMBER(L536)),L536,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I543:I548)","v":0},null,null,{"$f":"SUM(L543:L548)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I549/I542,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L549/L542,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I550-I551,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L550-L551,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I542),ISNUMBER(L542)),I542+L542,IF(ISNUMBER(I542),I542,IF(ISNUMBER(L542),L542,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I542),ISNUMBER(L542),ISNUMBER(I552),ISNUMBER(L552)),((I542*I552)+(L542*L552))/(I542+L542),IF(AND(OR(NOT(ISNUMBER(L542)),NOT(ISNUMBER(L552))),ISNUMBER(I542),ISNUMBER(I552)),I552,IF(AND(OR(NOT(ISNUMBER(I542)),NOT(ISNUMBER(I552))),ISNUMBER(L542),ISNUMBER(L552)),L552,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I559:I564)","v":0},null,null,{"$f":"SUM(L559:L564)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I565/I558,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L565/L558,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I566-I567,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L566-L567,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I558),ISNUMBER(L558)),I558+L558,IF(ISNUMBER(I558),I558,IF(ISNUMBER(L558),L558,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I558),ISNUMBER(L558),ISNUMBER(I568),ISNUMBER(L568)),((I558*I568)+(L558*L568))/(I558+L558),IF(AND(OR(NOT(ISNUMBER(L558)),NOT(ISNUMBER(L568))),ISNUMBER(I558),ISNUMBER(I568)),I568,IF(AND(OR(NOT(ISNUMBER(I558)),NOT(ISNUMBER(I568))),ISNUMBER(L558),ISNUMBER(L568)),L568,\"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,31]
[null,null,null,"Number of Months:  Maximum 12"]
[null,null,32,"Income (Loss):  Form 8825 Line 17"]
[null,null,33,"Depreciation:  Form 8825 Line 14"]
[null,null,34,"Taxes:  Form 8825 Line 11"]
[null,null,35,"Mortgage Interest:  Form 8825 Line 9"]
[null,null,36,"Insurance:  Form 8825 Line 7"]
[null,null,37,"Other:","Amortization/Casualty Loss/HOA Dues, if applicable:  Form 8825 Line 15"]
[null,null,38,"Annual Gross Rental Income (Loss)",null,null,null,null,{"$f":"SUM(I575:I580)","v":0},null,null,{"$f":"SUM(L575:L580)","v":0}]
[null,null,39,"Monthly Gross Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I581/I574,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L581/L574,\"N/A\")","v":"N/A"}]
[null,null,40,"Monthly PITIA",null,null,null,"( ",null," )","( ",null," )"]
[null,null,41,"NET Monthly Rental Income (Loss)",null,null,null,null,{"$f":"IFERROR(I582-I583,\"N/A\")","v":"N/A"},null,null,{"$f":"IFERROR(L582-L583,\"N/A\")","v":"N/A"}]
[null,null,42,{"$f":"\"Average NET Monthly Rental Income (Loss) \"&IF(AND(ISNUMBER(I574),ISNUMBER(L574)),I574+L574,IF(ISNUMBER(I574),I574,IF(ISNUMBER(L574),L574,\"____\")))&\" months\"","v":"Average NET Monthly Rental Income (Loss) ____ months"},null,null,null,null,null,{"$f":"IF(AND(ISNUMBER(I574),ISNUMBER(L574),ISNUMBER(I584),ISNUMBER(L584)),((I574*I584)+(L574*L584))/(I574+L574),IF(AND(OR(NOT(ISNUMBER(L574)),NOT(ISNUMBER(L584))),ISNUMBER(I574),ISNUMBER(I584)),I584,IF(AND(OR(NOT(ISNUMBER(I574)),NOT(ISNUMBER(I584))),ISNUMBER(L574),ISNUMBER(L584)),L584,\"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,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J593","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J593+J594","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J595-J596","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J602","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J602+J603","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J604-J605","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J611","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J611+J612","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J613-J614","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J620","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J620+J621","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J622-J623","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J629","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J629+J630","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J631-J632","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J638","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J638+J639","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J640-J641","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J647","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J647+J648","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J649-J650","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J656","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J656+J657","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J658-J659","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J665","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J665+J666","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J667-J668","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J674","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J674+J675","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J676-J677","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J683","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J683+J684","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J685-J686","v":0}]
[]
[null,null,null,"Property:",null,null,null,null,null,null,null,null,"Annualization date: "]
[null,null,"Rental Income (Loss) Calculation"]
[null,null,43]
[null,null,null,"Gross Monthly Rent"]
[null,null,44,"Vacancy Factor (25%)",null,null,null,null,null,{"$f":"-0.25*J692","v":0}]
[null,null,45,"Adjusted Monthly Rent",null,null,null,null,null,{"$f":"J692+J693","v":0}]
[null,null,46,"Monthly PITIA",null,null,null,null,"( ",null,null," )"]
[null,null,47,"NET Monthly Rental Income (Loss)",null,null,null,null,null,{"$f":"J694-J695","v":0}]
[]
[]
[]
[]
[]
[null,null,"Comments / Notes  (For a new line, hold Alt and press Enter)"]

{"sheet":"_HYPER_LKP_NEW_","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"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,"Income (loss)","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2019.pdf"]
[2,null,"C",3,"Depreciation","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit","https://www.mgic.com/-/media/MGIC/seb/71-8847_seb_manual_2018.pdf#page=21&view=fit"]
[3,null,"C",4,"Taxes","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[4,null,"C",5,"Mortgage Interest","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[5,null,"C",6,"Insurance","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[6,null,"C",7,"Other","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[7,"Investment Property Schedule E","C",15,"Income (loss)","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[8,null,"C",16,"Depreciation","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[9,null,"C",17,"Taxes","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[10,null,"C",18,"Mortgage Interest","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[11,null,"C",19,"Insurance","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[12,null,"C",20,"Other","#page39","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[13,"Business Rental Form 8825","C",32,"Income (loss)","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[14,null,"C",33,"Depreciation","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[15,null,"C",34,"Taxes","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[16,null,"C",35,"Mortgage Interest","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[17,null,"C",36,"Insurance","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]
[18,null,"C",37,"Other","#page77","https://www.mgic.com/-/media/MGIC/seb/","71-8847_seb_manual_2019.pdf","view=fit"]

{"sheet":"Rental (2)","index":2,"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"]

{"sheet":"LOOKUPS","index":3,"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,2017,0.25,1,true,true]
[null,2018,0.25,2]
[null,2019,0.26,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,10]
[null,null,null,11]
[null,null,null,12]

{"sheet":"_HYPER_LKP_","index":4,"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"]