{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Claim 15% Deemed Expenses","Claim Actual Expenses","Sheet1"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":2,"comments":2,"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":"Claim 15% Deemed Expenses","index":0,"n_rows":344,"n_cols":30,"rows_kept":344,"cut":false,"hidden":false,"merged":[[15,7,15,8],[17,9,17,10],[39,4,39,7],[39,8,39,11],[40,4,40,7],[40,8,40,11],[41,4,41,7],[41,8,41,11],[0,1,0,13],[1,1,1,13],[2,1,2,13],[3,1,3,13],[4,1,4,13],[5,1,5,13],[8,5,8,10],[10,7,10,8],[13,7,13,8],[17,2,17,8],[42,4,42,7],[42,8,42,11],[43,4,43,7],[43,8,43,11],[45,4,46,14],[49,5,49,10],[51,7,51,8],[54,7,54,8],[56,7,56,8],[58,7,58,8],[58,9,58,10],[60,7,60,8],[81,4,81,7],[81,8,81,11],[82,4,82,7],[82,8,82,11],[83,4,83,7],[83,8,83,11],[84,4,84,7],[84,8,84,11],[85,4,85,7],[85,8,85,11],[87,4,88,14],[91,5,91,10],[93,7,93,8],[96,7,96,8],[98,7,98,8],[100,7,100,8],[100,9,100,10],[102,7,102,8],[123,4,123,7],[123,8,123,11],[124,4,124,7],[124,8,124,11],[125,4,125,7],[125,8,125,11],[126,4,126,7],[126,8,126,11],[127,4,127,7],[127,8,127,11],[129,4,130,14],[133,5,133,10],[135,7,135,8],[138,7,138,8],[140,7,140,8],[142,7,142,8],[142,9,142,10],[144,7,144,8],[165,4,165,7],[165,8,165,11],[166,4,166,7],[166,8,166,11],[167,4,167,7],[167,8,167,11],[252,8,252,11],[168,4,168,7],[168,8,168,11],[169,4,169,7],[169,8,169,11],[171,4,172,14],[175,5,175,10],[177,7,177,8],[180,7,180,8],[182,7,182,8],[224,7,224,8],[226,7,226,8],[226,9,226,10],[228,7,228,8],[249,4,249,7],[249,8,249,11],[250,4,250,7],[250,8,250,11],[251,4,251,7],[251,8,251,11],[306,7,306,8],[294,8,294,11],[310,9,310,10],[294,4,294,7],[293,4,293,7],[293,8,293,11],[184,7,184,8],[184,9,184,10],[186,7,186,8],[207,4,207,7],[207,8,207,11],[208,4,208,7],[208,8,208,11],[209,4,209,7],[209,8,209,11],[252,4,252,7],[210,4,210,7],[210,8,210,11],[211,4,211,7],[211,8,211,11],[213,4,214,14],[217,5,217,10],[219,7,219,8],[222,7,222,8],[266,7,266,8],[268,7,268,8],[268,9,268,10],[270,7,270,8],[291,4,291,7],[291,8,291,11],[292,4,292,7],[292,8,292,11],[303,7,303,8],[253,4,253,7],[253,8,253,11],[255,4,256,14],[259,5,259,10],[343,2,343,13],[335,4,335,7],[335,8,335,11],[336,4,336,7],[336,8,336,11],[295,4,295,7],[295,8,295,11],[297,4,298,14],[301,5,301,10],[308,7,308,8],[337,4,337,7],[337,8,337,11],[312,7,312,8],[334,4,334,7],[334,8,334,11],[333,4,333,7],[261,7,261,8],[333,8,333,11],[310,7,310,8],[264,7,264,8]]}
[null,"Rental Calculator for Individuals (With Simplified Claim for Rental Expenses) From YA2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For date field"]
[null,"For Residential Properties Only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,37256]
[null,"What to do: Enter details in the grey boxes. If a box is not applicable, leave it blank.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,37621]
[null,"Tips:  For more information, mouse over the grey boxes or click on the field name in blue. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,37986]
[null,"Disclaimer:This rental calculator is for the purpose of computing your net rental income. It is not an official declaration of your rental income.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,38352]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,38717]
[null,null,"Property 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,39082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,39447]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F9)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,39813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,40178]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H11)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field",null,null,null,null,null,null,null,null,null,2010,40543]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,null,null,null,null,null,2011,40908]
[null,null,"Period of Rental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,41274]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H14)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H14)=0,\"*required field\",H14)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H14)=0,0,YEAR(H14))","v":0},null,null,null,null,null,null,null,null,null,null,2013,41639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,42004]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H16)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H16)=0,\"*required field\",H16)","v":"*required field"},null,null,null,null,null,"Vlookup field",null,null,null,null,null,null,null,null,null,2015,42369]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H14)=0,0,VLOOKUP(R14,$AC$2:$AD$24,2))","v":0},null,null,null,null,null,null,null,null,null,2016,42735]
[null,null,"From Year of Assessment 2022, any expenditure incurred by a landlord for the repair, insurance, maintenance or upkeep of a property when it is vacant in any part of a basis period, and any property tax paid on that property for that vacancy period can be deducted against rental income. This is subject to the condition that reasonable efforts have been made to find a new tenant during the vacancy period(s) in between leases."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,43465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,43830]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K21)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,44196]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,44561]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,44926]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K21","v":0},".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,44927]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,44928]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,44929]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,44930]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,44931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028,44932]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K24+K26","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K21-K30","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H11=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K35)>0,\" \",IF(K34=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H11=\"yes\",100,K35)","v":0}]
[null,null,{"$f":"IF(COUNTA(K35)>0,X36,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H11=\"yes\",100,K35)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T36","v":100},"% share of the property.",{"$f":"S36&\" \"&T36&U36&\" \"&V36&W36","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K32*S35/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[null,null,null,null,"Please click on the options button (below the toolbar) to enable macros before adding the details for Property 2"]
[]
[null,null,"Property 2"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F50)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H52)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H55)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H55)=0,\"*required field\",H55)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H55)=0,0,YEAR(H55))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H57)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H57)=0,\"*required field\",H57)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H55)=0,0,VLOOKUP(R55,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K63)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K63","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K66+K68","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K63-K72","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H52=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K77)>0,\" \",IF(K76=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H52=\"yes\",100,K77)","v":0}]
[null,null,{"$f":"IF(COUNTA(K77)>0,X78,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H52=\"yes\",100,K77)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T78","v":100},"% share of the property.",{"$f":"S78&\" \"&T78&U78&\" \"&V78&W78","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K74*S77/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 3"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F92)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H94)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H97)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H97)=0,\"*required field\",H97)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H97)=0,0,YEAR(H97))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H99)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H99)=0,\"*required field\",H99)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H97)=0,0,VLOOKUP(R97,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K105)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K105","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K108+K110","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K105-K114","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H94=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K119)>0,\" \",IF(K118=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H94=\"yes\",100,K119)","v":0}]
[null,null,{"$f":"IF(COUNTA(K119)>0,X120,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H94=\"yes\",100,K119)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T120","v":100},"% share of the property.",{"$f":"S120&\" \"&T120&U120&\" \"&V120&W120","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K116*S119/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 4"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F134)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H136)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H139)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H139)=0,\"*required field\",H139)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H139)=0,0,YEAR(H139))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H141)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H141)=0,\"*required field\",H141)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H139)=0,0,VLOOKUP(R139,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K147)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K147","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K150+K152","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K147-K156","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H136=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K161)>0,\" \",IF(K160=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H136=\"yes\",100,K161)","v":0}]
[null,null,{"$f":"IF(COUNTA(K161)>0,X162,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H136=\"yes\",100,K161)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T162","v":100},"% share of the property.",{"$f":"S162&\" \"&T162&U162&\" \"&V162&W162","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K158*S161/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 5"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F176)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H178)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H181)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H181)=0,\"*required field\",H181)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H181)=0,0,YEAR(H181))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H183)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H183)=0,\"*required field\",H183)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H181)=0,0,VLOOKUP(R181,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K189)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K189","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K192+K194","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K189-K198","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H178=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K203)>0,\" \",IF(K202=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H178=\"yes\",100,K203)","v":0}]
[null,null,{"$f":"IF(COUNTA(K203)>0,X204,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H178=\"yes\",100,K203)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T204","v":100},"% share of the property.",{"$f":"S204&\" \"&T204&U204&\" \"&V204&W204","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K200*S203/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 6"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F218)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H220)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H223)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H223)=0,\"*required field\",H223)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H223)=0,0,YEAR(H223))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H225)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H225)=0,\"*required field\",H225)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H223)=0,0,VLOOKUP(R223,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K231)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K231","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K234+K236","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K231-K240","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H220=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K245)>0,\" \",IF(K244=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H220=\"yes\",100,K245)","v":0}]
[null,null,{"$f":"IF(COUNTA(K245)>0,X246,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H220=\"yes\",100,K245)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T246","v":100},"% share of the property.",{"$f":"S246&\" \"&T246&U246&\" \"&V246&W246","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K242*S245/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 7"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F260)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H262)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H265)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H265)=0,\"*required field\",H265)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H265)=0,0,YEAR(H265))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H267)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H267)=0,\"*required field\",H267)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H265)=0,0,VLOOKUP(R265,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K273)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K273","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K276+K278","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K273-K282","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H262=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K287)>0,\" \",IF(K286=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H262=\"yes\",100,K287)","v":0}]
[null,null,{"$f":"IF(COUNTA(K287)>0,X288,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H262=\"yes\",100,K287)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T288","v":100},"% share of the property.",{"$f":"S288&\" \"&T288&U288&\" \"&V288&W288","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K284*S287/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 8"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F302)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H304)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H307)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H307)=0,\"*required field\",H307)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H307)=0,0,YEAR(H307))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H309)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H309)=0,\"*required field\",H309)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H307)=0,0,VLOOKUP(R307,$AC$2:$AD$22,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K315)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: 15% Deemed Rental Expenses",null,null,null,null,null,null,"S$",{"$f":"15%*K315","v":0},".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K318+K320","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K315-K324","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H304=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K329)>0,\" \",IF(K328=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H304=\"yes\",100,K329)","v":0}]
[null,null,{"$f":"IF(COUNTA(K329)>0,X330,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H304=\"yes\",100,K329)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T330","v":100},"% share of the property.",{"$f":"S330&\" \"&T330&U330&\" \"&V330&W330","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K326*S329/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Net Rent",null,null,null,null,null,null,"S$",{"$f":"IF(Q342<0,0,Q342)","v":0},".00",null,null,null,null,{"$f":"K38+K80+K122+K164+K206+K248+K290+K332","v":0}]
[]
[null,null,"You have to keep complete and proper records of all expenses claimed for 5 years. Receipts/vouchers etc. should be kept by you and may be required for verification.  Estimates are not acceptable for income tax purposes"]

{"sheet":"Claim Actual Expenses","index":1,"n_rows":537,"n_cols":30,"rows_kept":537,"cut":false,"hidden":false,"merged":[[64,8,64,11],[65,8,65,11],[8,5,8,10],[10,7,10,8],[13,7,13,8],[15,7,15,8],[17,7,17,8],[76,7,76,8],[22,2,22,4],[30,2,30,4],[25,2,25,7],[17,9,17,10],[0,1,0,13],[1,1,1,13],[2,1,2,13],[3,1,3,13],[5,1,5,13],[4,1,4,13],[136,4,137,14],[45,2,45,4],[47,2,47,4],[49,2,49,4],[51,2,51,4],[70,4,71,14],[132,4,132,7],[132,8,132,11],[79,7,79,8],[81,7,81,8],[83,7,83,8],[66,8,66,11],[67,8,67,11],[68,8,68,11],[64,4,64,7],[65,4,65,7],[66,4,66,7],[111,2,111,4],[113,2,113,4],[134,8,134,11],[88,2,88,4],[96,2,96,4],[74,5,74,10],[67,4,67,7],[83,9,83,10],[131,4,131,7],[131,8,131,11],[68,4,68,7],[115,2,115,4],[117,2,117,4],[147,7,147,8],[145,7,145,8],[142,7,142,8],[177,2,177,4],[133,4,133,7],[133,8,133,11],[134,4,134,7],[149,7,149,8],[130,4,130,7],[130,8,130,11],[140,5,140,10],[406,7,406,8],[409,7,409,8],[411,7,411,8],[418,2,418,4],[426,2,426,4],[475,7,475,8],[477,7,477,8],[215,7,215,8],[215,9,215,10],[243,2,243,4],[340,7,340,8],[328,4,328,7],[328,8,328,11],[329,4,329,7],[329,8,329,11],[277,7,277,8],[279,7,279,8],[281,7,281,8],[281,9,281,10],[274,7,274,8],[264,4,264,7],[264,8,264,11],[245,2,245,4],[247,2,247,4],[200,4,200,7],[200,8,200,11],[197,4,197,7],[197,8,197,11],[149,9,149,10],[263,4,263,7],[263,8,263,11],[206,5,206,10],[208,7,208,8],[249,2,249,4],[262,4,262,7],[262,8,262,11],[213,7,213,8],[211,7,211,8],[181,2,181,4],[179,2,179,4],[202,4,203,14],[183,2,183,4],[196,4,196,7],[196,8,196,11],[198,4,198,7],[198,8,198,11],[199,4,199,7],[199,8,199,11],[343,7,343,8],[265,4,265,7],[265,8,265,11],[266,4,266,7],[266,8,266,11],[330,4,330,7],[330,8,330,11],[309,2,309,4],[268,4,269,14],[272,5,272,10],[311,2,311,4],[313,2,313,4],[315,2,315,4],[334,4,335,14],[338,5,338,10],[331,4,331,7],[331,8,331,11],[332,4,332,7],[332,8,332,11],[345,7,345,8],[347,7,347,8],[347,9,347,10],[375,2,375,4],[397,4,397,7],[397,8,397,11],[398,4,398,7],[398,8,398,11],[462,4,462,7],[462,8,462,11],[396,4,396,7],[396,8,396,11],[377,2,377,4],[379,2,379,4],[381,2,381,4],[394,4,394,7],[394,8,394,11],[395,4,395,7],[395,8,395,11],[460,4,460,7],[460,8,460,11],[461,8,461,11],[400,4,401,14],[404,5,404,10],[413,7,413,8],[413,9,413,10],[415,7,415,8],[441,2,441,4],[481,7,481,8],[507,2,507,4],[509,2,509,4],[511,2,511,4],[443,2,443,4],[445,2,445,4],[447,2,447,4],[466,4,467,14],[470,5,470,10],[461,4,461,7],[479,7,479,8],[463,4,463,7],[463,8,463,11],[464,4,464,7],[479,9,479,10],[536,2,536,13],[528,8,528,11],[464,8,464,11],[529,4,529,7],[529,8,529,11],[530,4,530,7],[530,8,530,11],[526,4,526,7],[526,8,526,11],[527,4,527,7],[527,8,527,11],[528,4,528,7],[472,7,472,8],[513,2,513,4]]}
[null,"Rental Calculator for Individuals (From YA2022)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"For date field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,37256]
[null,"What to do: Enter details in the grey boxes. If a box is not applicable, leave it blank.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,37621]
[null,"Tips:  For more information, mouse over the grey boxes or click on the field name in blue. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,37986]
[null,"Disclaimer:This rental calculator is for the purpose of computing your net rental income. It is not an official declaration of your rental income.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,38352]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,38717]
[null,null,"Property 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,39082]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,39447]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F9)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,39813]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,40178]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H11)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field",null,null,null,null,null,null,null,null,null,2010,40543]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No",null,null,null,null,null,null,null,null,2011,40908]
[null,null,"Period of Rental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,41274]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H14)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H14)=0,\"*required field\",H14)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H14)=0,0,YEAR(H14))","v":0},null,null,null,null,null,null,null,null,null,null,2013,41639]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,42004]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H16)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H16)=0,\"*required field\",H16)","v":"*required field"},null,null,null,null,null,"Vlookup field",null,null,null,null,null,null,null,null,null,2015,42369]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H14)=0,0,VLOOKUP(R14,$AC$2:$AD$36,2))","v":0},null,null,null,null,null,null,null,null,null,2016,42735]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,43465]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,43830]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,44196]
[null,null,"Gross Rent",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K22)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,44561]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,44926]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,44927]
[null,null,"Less: Expenses Incurred",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,44928]
[null,null,"From Year of Assessment 2022, any expenditure incurred by a landlord for the repair, insurance, maintenance or upkeep of a property when it is vacant in any part of a basis period, and any property tax paid on that property for that vacancy period can be deducted against rental income. This is subject to the condition that reasonable efforts have been made to find a new tenant during the vacancy period(s) in between leases.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,44929]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2026,44930]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2027,44931]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2028,44932]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2029,44933]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2030,44934]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2031,44935]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2032,44936]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2033,44937]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2034,44938]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11No",null,null,null,2035,44939]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Property",null,null,"1st time?","Day","Month","Sum1","Sum2","Same as min start?","Yes or no?","Min of all of property start date"]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00",null,null,null,1,{"$f":"IF(COUNTA(H14)=0,\"NA\",H14)","v":"NA"},{"$f":"IF(Q39=\"NA\",100000,Q39)","v":"2173-10-14"},{"$f":"Sheet1!#REF!","v":{"$error":"#REF!"}},{"$f":"DAY(Q39)","v":{"$error":"#VALUE!"}},{"$f":"MONTH(Q39:Q46)","v":{"$error":"#VALUE!"}},{"$f":"T39&U39","v":{"$error":"#VALUE!"}},{"$f":"T39&U39&S39","v":{"$error":"#VALUE!"}},{"$f":"IF(R39=$Z$39,\"Y\",0)","v":"Y"},{"$f":"IF(X39=\"Y\",W39,\"0\")","v":{"$error":"#VALUE!"}},{"$f":"MIN(R39:R46)","v":"2173-10-14"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(COUNTA(H80)=0,\"NA\",H80)","v":"NA"},{"$f":"IF(Q40=\"NA\",100000,Q40)","v":"2173-10-14"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"DAY(Q40)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"T40&U40","v":{"$error":"#VALUE!"}},{"$f":"T40&U40&S40","v":{"$error":"#VALUE!"}},{"$f":"IF(R40=$Z$39,\"Y\",0)","v":"Y"},{"$f":"IF(X40=\"Y\",W40,\"0\")","v":{"$error":"#VALUE!"}},{"$f":"DAY(Z39)","v":14},"Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"IF(COUNTA(H146)=0,\"NA\",H146)","v":"NA"},"2173-10-14",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"},{"$f":"MONTH(Z39)","v":10},"Month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"IF(COUNTA(H212)=0,\"NA\",H212)","v":"NA"},"2173-10-14",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"},{"$f":"Z40&Z41","v":"1410"},"sum1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"IF(COUNTA(H278)=0,\"NA\",H278)","v":"NA"},"2173-10-14",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"}]
[null,null,"Others, please specify:",null,null,null,null,null,null,null,null,null,null,null,null,6,{"$f":"IF(COUNTA(H344)=0,\"NA\",H344)","v":"NA"},"2173-10-14",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"},{"$f":"COUNTIF(Y38:Y46,Y36)","v":0},"countif same min"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,{"$f":"IF(COUNTA(H410)=0,\"NA\",H410)","v":"NA"},"2173-10-14",{"$f":"H416","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,"S$",null,".00",null,null,null,8,{"$f":"IF(COUNTA(H476)=0,\"NA\",H476)","v":"NA"},"2173-10-14",{"$f":"H482","v":0},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"Y",{"$error":"#VALUE!"}]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K28+K30+K33+K35+K37+K39+K46+K48+K50+K52","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K22-K55","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H11=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K60)>0,\" \",IF(K59=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H11=\"yes\",100,K60)","v":0}]
[null,null,{"$f":"IF(COUNTA(K60)>0,X61,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H11=\"yes\",100,K60)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T61","v":100},"% share of the property.",{"$f":"S61&\" \"&T61&U61&\" \"&V61&W61","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K57*S60/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[null,null,null,null,null,null,null,null,"."]
[]
[]
[null,null,null,null,"Please click on the options button (below the toolbar) to enable macros before adding the details for Property 2"]
[]
[null,null,"Property 2"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F75)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H77)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H80)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H80)=0,\"*required field\",H80)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H80)=0,0,YEAR(H80))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H82)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H82)=0,\"*required field\",H82)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H80)=0,0,VLOOKUP(R80,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K88)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H84)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K94+K96+K99+K101+K103+K105+K112+K114+K116+K118","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K88-K121","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H77=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K126)>0,\" \",IF(K125=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H77=\"yes\",100,K126)","v":0}]
[null,null,{"$f":"IF(COUNTA(K126)>0,X127,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H77=\"yes\",100,K126)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T127","v":100},"% share of the property.",{"$f":"S127&\" \"&T127&U127&\" \"&V127&W127","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K123*S126/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 3"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F141)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H143)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H146)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H146)=0,\"*required field\",H146)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H146)=0,0,YEAR(H146))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H148)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H148)=0,\"*required field\",H148)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H146)=0,0,VLOOKUP(R146,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K154)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H150)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K160+K162+K165+K167+K169+K171+K178+K180+K182+K184","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K154-K187","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H143=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K192)>0,\" \",IF(K191=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H143=\"yes\",100,K192)","v":0}]
[null,null,{"$f":"IF(COUNTA(K192)>0,X193,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H143=\"yes\",100,K192)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T193","v":100},"% share of the property.",{"$f":"S193&\" \"&T193&U193&\" \"&V193&W193","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K189*S192/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 4"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F207)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H209)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H212)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H212)=0,\"*required field\",H212)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H212)=0,0,YEAR(H212))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H214)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H214)=0,\"*required field\",H214)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H212)=0,0,VLOOKUP(R212,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K220)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H216)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K226+K228+K231+K233+K235+K237+K244+K246+K248+K250","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K220-K253","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H209=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K258)>0,\" \",IF(K257=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H209=\"yes\",100,K258)","v":0}]
[null,null,{"$f":"IF(COUNTA(K258)>0,X259,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H209=\"yes\",100,K258)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T259","v":100},"% share of the property.",{"$f":"S259&\" \"&T259&U259&\" \"&V259&W259","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K255*S258/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 5"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F273)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H275)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H278)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H278)=0,\"*required field\",H278)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H278)=0,0,YEAR(H278))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H280)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H280)=0,\"*required field\",H280)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H278)=0,0,VLOOKUP(R278,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K286)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H282)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K292+K294+K297+K299+K301+K303+K310+K312+K314+K316","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K286-K319","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H275=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K324)>0,\" \",IF(K323=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H275=\"yes\",100,K324)","v":0}]
[null,null,{"$f":"IF(COUNTA(K324)>0,X325,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H275=\"yes\",100,K324)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T325","v":100},"% share of the property.",{"$f":"S325&\" \"&T325&U325&\" \"&V325&W325","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K321*S324/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 6"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F339)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H341)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H344)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H344)=0,\"*required field\",H344)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H344)=0,0,YEAR(H344))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H346)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H346)=0,\"*required field\",H346)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H344)=0,0,VLOOKUP(R344,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K352)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H348)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K358+K360+K363+K365+K367+K369+K376+K378+K380+K382","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K352-K385","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H341=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K390)>0,\" \",IF(K389=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H341=\"yes\",100,K390)","v":0}]
[null,null,{"$f":"IF(COUNTA(K390)>0,X391,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H341=\"yes\",100,K390)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T391","v":100},"% share of the property.",{"$f":"S391&\" \"&T391&U391&\" \"&V391&W391","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K387*S390/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 7"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F405)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H407)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H410)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H410)=0,\"*required field\",H410)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H410)=0,0,YEAR(H410))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H412)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H412)=0,\"*required field\",H412)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H410)=0,0,VLOOKUP(R410,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K418)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K424+K426+K429+K431+K433+K436+K442+K444+K446+K448","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K418-K451","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H407=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K456)>0,\" \",IF(K455=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H407=\"yes\",100,K456)","v":0}]
[null,null,{"$f":"IF(COUNTA(K456)>0,X457,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H407=\"yes\",100,K456)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T457","v":100},"% share of the property.",{"$f":"S457&\" \"&T457&U457&\" \"&V457&W457","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K453*S456/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Property 8"]
[]
[null,null,"Address of Property:",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(F471)=0,\"*required field\",\" \")","v":"*required field"}]
[]
[null,null,"Are you the sole owner of the abovementioned property",null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H473)=0,\"*required field\",\" \")","v":"*required field"},null,null,null,null,null,"Data validation field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes","No"]
[null,null,"Period of Rental"]
[null,null,"Period from",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H476)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H476)=0,\"*required field\",H476)","v":"*required field"},null,null,null,null,{"$f":"IF(COUNTA(H476)=0,0,YEAR(H476))","v":0}]
[]
[null,null,"Period to  ",null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H478)=0,\" \", \"You have entered the date as\")","v":" "},null,{"$f":"IF(COUNTA(H478)=0,\"*required field\",H478)","v":"*required field"},null,null,null,null,null,"Vlookup field"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTA(H476)=0,0,VLOOKUP(R476,$AC$2:$AD$23,2))","v":0}]
[]
[]
[]
[]
[null,null,"Gross Rent ",null,null,null,null,null,null,"S$",null,".00",{"$f":"IF(COUNTA(K484)=0,\"*required field\",\" \")","v":"*required field"}]
[null,null,"Includes rental of premises, furniture and fittings, maintenance and others, as per your tenancy agreement."]
[]
[null,null,"Less: Expenses Incurred"]
[null,null,{"$f":"IF(COUNTA(H480)=0,\" \",\"You may only claim for expenses incurred during the rental period. Any expenses incurred before and after the rental period are not allowable.\")","v":" "}]
[]
[null,null,"Property Tax",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Mortgage Loan Interest ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,"This refers to interest incurred on the mortgage loan. Do not include the instalment payment on the principal loan."]
[]
[null,null,"Fire Insurance ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Maintenance Fee ",null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,"Repairs",null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Agent's Commission ",null,null,null,null,null,null,"S$",null,".00"]
[null,null,{"$f":"IF(H482=\"yes\",\"Agent's commission, advertising, legal costs for getting subsequent tenants is deductible against the rental income.\",\" \")","v":" "}]
[]
[]
[null,null,"Others, please specify:"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[null,null,null,null,null,null,null,null,null,"S$",null,".00"]
[]
[]
[null,null,"Total Expenses Incurred ",null,null,null,null,null,null,"S$",{"$f":"K490+K492+K495+K497+K499+K502+K508+K510+K512+K514","v":0},".00"]
[]
[null,null,"Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K484-K517","v":0},".00"]
[]
[null,null,"Legal Share (%) of your property ",null,null,null,null,null,null,null,{"$f":"IF(H473=\"Yes\",100,\" \")","v":" "},"%",null,null,null,null,null,null,"Share of net rent"]
[null,null,"Legal Share (%) of your property (eg. 50%, 33.33%)",null,null,null,null,null,null,null,null,"%",{"$f":"IF(COUNTA(K522)>0,\" \",IF(K521=100,\" \",\"*required field\"))","v":"*required field"},null,null,null,null,null,{"$f":"IF(H473=\"yes\",100,K522)","v":0}]
[null,null,{"$f":"IF(COUNTA(K522)>0,X523,\" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You have indicated that you own",{"$f":"IF(H473=\"yes\",100,K522)","v":0},"% share of property and your co-owner(s) owns",{"$f":"100-T523","v":100},"% share of the property.",{"$f":"S523&\" \"&T523&U523&\" \"&V523&W523","v":"You have indicated that you own 0% share of property and your co-owner(s) owns 100% share of the property."}]
[]
[null,null,"Your Share of Net Rent ",null,null,null,null,null,null,"S$",{"$f":"K519*S522/100","v":0},".00"]
[]
[null,null,"Identification No.",null,"Full Name of Owner(s):",null,null,null,"Ownership (%)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total Net Rent",null,null,null,null,null,null,"S$",{"$f":"IF(Q535<0,0,Q535)","v":0},".00",null,null,null,null,{"$f":"K63+K129+K195+K261+K327+K393+K459+K525","v":0}]
[]
[null,null,"You have to keep complete and proper records of all expenses claimed for 5 years. Receipts/vouchers etc. should be kept by you and may be required for verification.  Estimates are not acceptable for income tax purposes"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}