{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Estimated UBIT Calculator","UBIT Example"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Estimated UBIT Calculator","index":0,"n_rows":77,"n_cols":4,"rows_kept":77,"cut":false,"hidden":false,"merged":[[49,1,49,2],[51,0,51,3],[53,0,57,3],[59,0,60,3],[1,0,1,3],[2,0,2,3],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2]]}
[]
["Calculating UBIT for Real Estate Investments in Tax-Advantaged Accounts*"]
[" All light orange boxes require an entry. Hover over the red arrows for definitions and tips on getting the most accurate results from this tool. \nThe second Excel tab below shows an example."]
[]
[null,"Beginning Principal Balance Owed"]
[]
[null,"Monthly Principal Payments"]
[]
[null,"How Many Months Was the Property Held"]
[]
[null,"Ending Principal Balance Owed",{"$f":"C5-(C7*C9)","v":0}]
[]
[null,"Average Debt",{"$f":"(C5+C11)/2","v":0}]
[]
[null,"Cost of Real Estate (or Cost Basis*)"]
[null,"Initial Improvements and Closing Costs*"]
[null,"Initial Cost Basis",{"$f":"C15+C16","v":0}]
[null,"Further Increases to Cost Basis "]
[null,"Reductions to Cost Basis "]
[null,"Ending Cost Basis",{"$f":"C17+(C18-C19)","v":0}]
[]
[null,"Average Cost Basis",{"$f":"(C17+C20)/2","v":0}]
[null,null,{"$f":"C13/C22","v":{"$error":"#DIV/0!"}}]
[null,"Debt-Financed Ratio",{"$f":"ROUNDUP(C23,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Debt-Financed Amount"]
[null,"Rental Income",null,{"$f":"C24*C26","v":{"$error":"#DIV/0!"}}]
[null,"Operating Expenses and Other Deductions",null,{"$f":"C24*C27","v":{"$error":"#DIV/0!"}}]
[null,"Depreciation",null,{"$f":"C24*C28","v":{"$error":"#DIV/0!"}}]
[]
[null,"Taxable Amount",{"$f":"(D26-(D27+D28))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Allowable Exemption",1000]
[null,"Net Taxable Income Subject to UBIT",{"$f":"C30-C32","v":{"$error":"#DIV/0!"}}]
[]
["If Net Taxable Income Subject to UBIT (Cell C33) is:","Choose Appropriate Range Below","Estimated UBIT"]
[]
["Between $0 - $2,600",null,{"$f":"IF(A74=1,SUM(C33*D47), \"N/A\")","v":"N/A"}]
[]
["Between $2,601 - $9,300",null,{"$f":"IF(A75=1,SUM((C33-2600)*0.24)+260,\"N/A\")","v":"N/A"}]
[]
[" Between $9,301 - $12,750",null,{"$f":"IF(A76=1,SUM((C33-9300)*0.35)+1868,\"N/A\")","v":"N/A"}]
[]
["More Than $12,750",null,{"$f":"IF(A77=1,SUM((C33-12750)*0.37)+3075.5,\"N/A\")","v":"N/A"}]
[]
[]
[null,"Net Taxable Income Subject to UBIT",null,"Tax Rate"]
[null,"$0 - $2,600",null,0.1]
[null,"Between $2,601 - $9,300",null,"$260 + 24% of amount over $2,600"]
[null,"Between $9,301 - $12,750",null,"$1,868 + 35% of amount over $9,300"]
[null,"More Than  $12,750",null,"$3,075.50 + 37% of amount over $12,750"]
[]
["Thank you for downloading the IRA Tax Services UBIT Calculator! Hopefully you found this helpful in estimating your potential UBIT tax liability for your real estate investments in tax-advantaged accounts. \n\nIf you have any questions about calculating or reporting UBIT, please contact IRA Tax Services at 303-604-6466 or www.irataxservices.com. If you would like to learn more about self-directed alternative investments or using your tax-advantage accounts with real estate investments, please visit New Direction Trust Company at www.ndtco.com. "]
[]
["* Tax-advantaged accounts subject to Unrelated Business Income Tax (UBIT) or Unrelated Debt Financed Income (UDFI) may include Individual Retirement Accounts (Traditional, Roth, SIMPLE, and SEP IRAs), Health Savings Accounts (HSAs), CESAs (Educational IRAs), or qualified state tuition plans, such as 529s. \n\nSolo 401(k)s may be subject to UBIT as well, but the rules governing them are complex. Please contact a qualified tax professional, such as IRA Tax Services, with specific questions. "]
[]
[]
[]
[]
[]
["DISCLAIMER:  This calculator is meant for educational purposes only and should not be relied upon to complete tax forms or determine your potential UBIT tax liability to the Internal Revenue Service. Furthermore, this calculator is provided for your convenience and is neither tax advice nor intended to replace expert tax advice from a qualified advisor. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2]
[2]
[2]
[2]

{"sheet":"UBIT Example","index":1,"n_rows":75,"n_cols":4,"rows_kept":75,"cut":false,"hidden":false,"merged":[[49,1,49,2],[51,0,55,3],[57,0,58,3],[1,0,1,3],[2,0,2,3],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2]]}
[]
["Calculating UBIT for Real Estate Investments in Tax-Advantaged Accounts*"]
[" All light orange boxes require an entry. Hover over the red arrows for definitions and tips on getting the most accurate results from this tool. \nThe second Excel tab below shows the calculations for Anna's real estate investment from the \"How to Calculate UBIT for Real Estate\" video as an additional reference. Visit https://ndtco.com/content/ubit-calculator for more information on UBIT calculations."]
[]
[null,"Beginning Principal Balance Owed",175000]
[]
[null,"Monthly Principal Payments",200]
[]
[null,"How Many Months Was the Property Held",6]
[]
[null,"Ending Principal Balance Owed",{"$f":"C5-(C7*C9)","v":173800}]
[]
[null,"Average Debt",{"$f":"(C5+C11)/2","v":174400}]
[]
[null,"Cost of Real Estate (or Cost Basis*)",250000]
[null,"Initial Improvements and Closing Costs*",10000]
[null,"Initial Cost Basis",{"$f":"C15+C16","v":260000}]
[null,"Further Increases to Cost Basis ",0]
[null,"Reductions to Cost Basis ",5000]
[null,"Ending Cost Basis",{"$f":"C17+(C18-C19)","v":255000}]
[]
[null,"Average Cost Basis",{"$f":"(C17+C20)/2","v":257500}]
[null,null,{"$f":"C13/C22","v":0.67728155339805829}]
[null,"Debt-Financed Ratio",{"$f":"ROUNDUP(C23,2)","v":0.68}]
[null,null,null,"Debt-Financed Amount"]
[null,"Rental Income",17000,{"$f":"C24*C26","v":11560}]
[null,"Operating Expenses and Other Deductions",10000,{"$f":"C24*C27","v":6800.0000000000009}]
[null,"Depreciation",5000,{"$f":"C24*C28","v":3400.0000000000005}]
[]
[null,"Taxable Amount",{"$f":"D26-D27-D28","v":1359.9999999999986}]
[]
[null,"Allowable Exemption",1000]
[null,"Net Taxable Income Subject to UBIT",46233]
[]
["If Net Taxable Income Subject to UBIT (Cell C33) is:","Choose Appropriate Range Below","Estimated UBIT"]
[]
["Between $0 - $2,650",null,{"$f":"IF(A72=1,SUM(C33*D47), \"N/A\")","v":"N/A"}]
[]
["Between $2,651 - $9,550",null,{"$f":"IF(A73=1,SUM((C33-2651)*0.24)+265,\"N/A\")","v":"N/A"}]
[]
[" Between $9,551 - $13,050",null,{"$f":"IF(A74=1,SUM((C33-9551)*0.35)+1921,\"N/A\")","v":"N/A"}]
[]
["More Than $13,051",null,{"$f":"IF(A75=1,SUM((C33-13051)*0.37)+3146,\"N/A\")","v":15423.34}]
[]
[]
[null,"Net Taxable Income Subject to UBIT",null,"Tax Rate"]
[null,"$0 - $2,650",null,0.1]
[null,"Between $2,651 - $9,550",null,"$265 + 24% of amount over $2,650"]
[null,"Between $9,551 - $13,050",null,"$1,921 + 35% of amount over $9,550"]
[null,"More Than  $13,051",null,"$3,146 + 37% of amount over $13050"]
[]
["* Tax-advantaged accounts subject to Unrelated Business Income Tax (UBIT) or Unrelated Debt Financed Income (UDFI) may include Individual Retirement Accounts (Traditional, Roth, SIMPLE, and SEP IRAs), Health Savings Accounts (HSAs), CESAs (Educational IRAs), or qualified state tuition plans, such as 529s. \n\nSolo 401(k)s may be subject to UBIT as well, but the rules governing them are complex. Please contact a qualified tax professional, such as IRA Tax Services, with specific questions. "]
[]
[]
[]
[]
[]
["DISCLAIMER:  This calculator is meant for educational purposes only and should not be relied upon to complete tax forms or determine your potential UBIT tax liability to the Internal Revenue Service. Furthermore, this calculator is provided for your convenience and is neither tax advice nor intended to replace expert tax advice from a qualified advisor. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2]
[2]
[2]
[1]