{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CBD Builder Breakout","S&U - Contingency Calculator","Receipt Totals","Builder Only Budget","Appraisal CBD","Built Import File"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CBD Builder Breakout","index":0,"n_rows":136,"n_cols":16,"rows_kept":136,"cut":false,"hidden":false,"merged":[[122,2,123,9],[10,5,11,5],[10,6,11,6],[102,3,102,5],[105,3,105,5],[108,3,108,5],[99,7,99,9],[102,7,102,9],[105,7,105,9],[108,7,108,9],[113,2,113,5],[114,2,114,4],[115,2,115,4],[116,2,116,4],[117,2,117,4],[118,2,118,4],[119,2,119,4],[120,2,120,4],[113,6,113,9],[114,6,114,8],[115,6,115,8],[116,6,116,8],[117,6,117,8],[118,6,118,8],[119,6,119,8],[120,6,120,8],[110,8,110,9],[9,2,9,9],[10,2,11,2],[10,3,11,4],[10,8,11,8],[10,9,11,9],[59,3,59,4],[87,3,87,4],[94,2,94,4],[94,5,94,9],[96,2,96,9],[95,2,95,4],[95,5,95,9],[97,2,97,9],[91,2,91,4],[92,2,92,4],[92,5,92,9],[93,2,93,4],[93,5,93,9],[90,3,90,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[89,3,89,4],[88,2,88,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[10,7,11,7],[20,3,20,4],[21,3,21,4],[22,3,22,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[131,6,131,9],[132,6,132,9],[133,6,134,9],[41,3,41,4],[42,3,42,4],[99,3,99,5],[17,3,17,4],[18,3,18,4],[19,3,19,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[34,3,34,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[2,6,2,9],[3,6,3,9],[4,6,4,9],[5,6,5,9],[6,6,6,9],[7,6,7,9],[135,6,135,9],[135,2,135,5],[125,2,125,5],[126,2,126,5],[127,2,127,5],[128,2,128,5],[129,2,129,5],[130,2,130,5],[131,2,131,5],[132,2,132,5],[133,2,134,3],[133,4,134,5],[125,6,125,9],[126,6,126,9],[127,6,127,9],[128,6,128,9],[129,6,129,9],[130,6,130,9]]}
[]
[null," "," "]
[null,null,null,null,null,"BORROWER:",null,null,null,null,null,"."]
[null,null,null,null,null,"PROPERTY ADDRESS:"]
[null,null,null,null,null,"EMAIL ADDRES:"]
[null,null,null,null,null,"PHONE NUMBER: "]
[null,null,null,null,null,"LOAN #: "]
[null,null,null,null,null,"Has Foundation been poured (Yes or No)?"]
[]
[null,null,"NOTE:  PLEASE COMPLETE ONLY GREEN FIELDS OF THIS FORM."]
[null,null,"Line Item ","DESCRIPTION OF WORK",null,"HOME OWNER  BUDGET","BUILDER BUDGET","COMBINED BUDGET TOTALS","TOTAL OF \nNON-INCLUDED \nITEMS","FINANCED BUDGET"]
[]
[null,null,1,"Lot Cost - *See Below for Instructions",null,null,null,{"$f":"F13","v":0},null,{"$f":"$F13-$I13","v":0}]
[null,null,5,"Plans & Specs ",null,null,null,{"$f":"$F14+$G14","v":0},{"$f":"'Receipt Totals'!G6","v":0},{"$f":"$F14+G14-I14","v":0}]
[null,null,6,"Permits",null,null,null,{"$f":"$F15+$G15","v":0},{"$f":"'Receipt Totals'!G7","v":0},0]
[null,null,7,"Water Hookup & Shares",null,null,null,0,{"$f":"'Receipt Totals'!G8","v":0},0]
[null,null,8,"Temp Power Hookup ",null,null,null,0,{"$f":"'Receipt Totals'!G9","v":0},0]
[null,null,9,"Excavation/Grade/Fill ",null,null,null,0,{"$f":"'Receipt Totals'!G10","v":0},0]
[null,null,10,"Surveying & Engineering",null,null,null,0,{"$f":"'Receipt Totals'!G11","v":0},0]
[null,null,11,"Foundation Labor",null,null,null,0,{"$f":"'Receipt Totals'!G12","v":0},0]
[null,null,12,"Foundation Concrete",null,null,null,0,{"$f":"'Receipt Totals'!G13","v":0},0]
[null,null,13,"Steps / Walks / Driveway",null,null,null,0,{"$f":"'Receipt Totals'!G14","v":0},0]
[null,null,14,"Garage/Basement Concrete",null,null,null,0,{"$f":"'Receipt Totals'!G15","v":0},0]
[null,null,15,"Chimney / Fireplace",null,null,null,0,{"$f":"'Receipt Totals'!G16","v":0},0]
[null,null,16,"Masonry",null,null,null,0,{"$f":"'Receipt Totals'!G17","v":0},0]
[null,null,17,"Framing Lumber",null,null,null,0,{"$f":"'Receipt Totals'!G18","v":0},0]
[null,null,18,"Siding",null,null,null,0,{"$f":"'Receipt Totals'!G19","v":0},0]
[null,null,19,"Framing Labor",null,null,null,0,{"$f":"'Receipt Totals'!G20","v":0},0]
[null,null,20,"Rough Plumbing",null,null,null,0,{"$f":"'Receipt Totals'!G21","v":0},0]
[null,null,21,"Electrical Wiring ",null,null,null,0,{"$f":"'Receipt Totals'!G22","v":0},0]
[null,null,22,"Finish Plumbing",null,null,null,0,{"$f":"'Receipt Totals'!G23","v":0},0]
[null,null,23,"Sewer / Septic ",null,null,null,0,{"$f":"'Receipt Totals'!G24","v":0},0]
[null,null,24,"Gutters / Downspouts",null,null,null,0,{"$f":"'Receipt Totals'!G25","v":0},0]
[null,null,25,"Water Line Install",null,null,null,0,{"$f":"'Receipt Totals'!G26","v":0},0]
[null,null,26,"Insulation ",null,null,null,0,{"$f":"'Receipt Totals'!G27","v":0},0]
[null,null,27,"Roof Trusses",null,null,null,0,{"$f":"'Receipt Totals'!G28","v":0},0]
[null,null,28,"Roofing",null,null,null,0,{"$f":"'Receipt Totals'!G29","v":0},0]
[null,null,29,"Drywall",null,null,null,0,{"$f":"'Receipt Totals'!G30","v":0},0]
[null,null,31,"Lighting Fixtures",null,null,null,0,{"$f":"'Receipt Totals'!G31","v":0},0]
[null,null,32,"Heating",null,null,null,0,{"$f":"'Receipt Totals'!G32","v":0},0]
[null,null,33,"Windows & Screens",null,null,null,0,{"$f":"'Receipt Totals'!G33","v":0},0]
[null,null,34,"Exterior Doors/Trim ",null,null,null,0,{"$f":"'Receipt Totals'!G34","v":0},0]
[null,null,35,"Interior Doors/Trim",null,null,null,0,{"$f":"'Receipt Totals'!G35","v":0},0]
[null,null,36,"Finish Labor ",null,null,null,0,{"$f":"'Receipt Totals'!G36","v":0},0]
[null,null,37,"Garage Doors/Openers",null,null,null,0,{"$f":"'Receipt Totals'!G37","v":0},0]
[null,null,38,"Cabinets",null,null,null,0,{"$f":"'Receipt Totals'!G38","v":0},{"$f":"$F46+G46-I46","v":0}]
[null,null,39,"Exterior Painting",null,null,null,0,{"$f":"'Receipt Totals'!G39","v":0},0]
[null,null,40,"Staircase",null,null,null,0,{"$f":"'Receipt Totals'!G40","v":0},0]
[null,null,41,"Hardwood Floors/Tile",null,null,null,0,{"$f":"'Receipt Totals'!G41","v":0},0]
[null,null,42,"Carpet / Vinyl / Countertops",null,null,null,0,{"$f":"'Receipt Totals'!G42","v":0},0]
[null,null,43,"Misc. Hardware ",null,null,null,0,{"$f":"'Receipt Totals'!G43","v":0},0]
[null,null,44,"Mirrors / Shower Doors",null,null,null,0,{"$f":"'Receipt Totals'!G44","v":0},0]
[null,null,45,"Appliances",null,null,null,0,{"$f":"'Receipt Totals'!G45","v":0},0]
[null,null,46,"Safety Equipment / Vacuum Stystem ",null,null,null,0,{"$f":"'Receipt Totals'!G46","v":0},0]
[null,null,47,"Insurance / Cleaning",null,null,null,0,{"$f":"'Receipt Totals'!G47","v":0},0]
[null,null,48,"Decks",null,null,null,0,{"$f":"'Receipt Totals'!G48","v":0},0]
[null,null,49,"Landscaping",null,null,null,0,{"$f":"'Receipt Totals'!G49","v":0},0]
[null,null,50,"Required Inspection Costs ",null,2100,null,2100,{"$f":"'Receipt Totals'!G50","v":0},2100]
[null,null,52,"Profit / Overhead",null,null,null,0,{"$f":"'Receipt Totals'!G51","v":0},0]
[null,null,53,"Taxes",null,null,null,0,{"$f":"'Receipt Totals'!G52","v":0},0]
[null,null,54,"Cusion/Contingency (Min. 5%)",{"$f":"SUM(F61/K61)","v":{"$error":"#DIV/0!"}},null,null,0,{"$f":"'Receipt Totals'!G53","v":0},0,{"$f":"SUM(J14:J57,J59:J60,J62:J88)","v":0}]
[null,null,55,"Log Set Up Labor",null,null,null,0,{"$f":"'Receipt Totals'!G54","v":0},0]
[null,null,56,"Log Delivery",null,null,null,0,{"$f":"'Receipt Totals'!G55","v":0},0]
[null,null,57,"Utility Fees",null,null,null,0,{"$f":"'Receipt Totals'!G56","v":0},0]
[null,null,58,"Demolition ",null,null,null,0,{"$f":"'Receipt Totals'!G57","v":0},0]
[null,null,60,"Interior Painting",null,null,null,0,{"$f":"'Receipt Totals'!G58","v":0},0]
[null,null,61,"Portable Toilet ",null,null,null,0,{"$f":"'Receipt Totals'!G59","v":0},0]
[{"$f":"ISBLANK(D68)","v":false},null,{"$f":"IF(A68=TRUE,\"TBD\",\"62\")","v":"62"},"Fire Supression System",null,null,null,0,{"$f":"'Receipt Totals'!G60","v":0},0]
[{"$f":"ISBLANK(D69)","v":true},null,{"$f":"IF(A69=TRUE,\"TBD\",\"63\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G61","v":0},0]
[true,null,{"$f":"IF(A70=TRUE,\"TBD\",\"64\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G62","v":0},0]
[false,null,{"$f":"IF(A71=TRUE,\"TBD\",\"65\")","v":"65"},"Cost for addition",null,null,null,0,{"$f":"'Receipt Totals'!G63","v":0},0]
[true," ",{"$f":"IF(A72=TRUE,\"TBD\",\"66\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G64","v":0},0]
[true,null,{"$f":"IF(A73=TRUE,\"TBD\",\"67\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G65","v":0},0]
[true,null,{"$f":"IF(A74=TRUE,\"TBD\",\"68\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G66","v":0},0]
[true,null,{"$f":"IF(A75=TRUE,\"TBD\",\"69\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G67","v":0},0]
[true," ",{"$f":"IF(A76=TRUE,\"TBD\",\"70\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G68","v":0},0]
[true,null,{"$f":"IF(A77=TRUE,\"TBD\",\"71\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G69","v":0},0]
[true,null,{"$f":"IF(A78=TRUE,\"TBD\",\"72\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G70","v":0},{"$f":"$F78+G78-I78","v":0}]
[true,null,{"$f":"IF(A79=TRUE,\"TBD\",\"73\")","v":"TBD"},null,null,null,null,{"$f":"$F79+$G79","v":0},{"$f":"'Receipt Totals'!G71","v":0},0]
[true,null,{"$f":"IF(A80=TRUE,\"TBD\",\"74\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G72","v":0},0]
[true,null,{"$f":"IF(A81=TRUE,\"TBD\",\"75\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G73","v":0},0]
[true,null,{"$f":"IF(A82=TRUE,\"TBD\",\"76\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G74","v":0},0]
[true,null,{"$f":"IF(A83=TRUE,\"TBD\",\"77\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G75","v":0},0]
[true,null,{"$f":"IF(A84=TRUE,\"TBD\",\"78\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G76","v":0},0]
[true,null,{"$f":"IF(A85=TRUE,\"TBD\",\"79\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G77","v":0},0]
[true,null,{"$f":"IF(A86=TRUE,\"TBD\",\"80\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G78","v":0},0]
[true,null,{"$f":"IF(A87=TRUE,\"TBD\",\"81\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G79","v":0},0,null,null," "]
[true,null,{"$f":"IF(A88=TRUE,\"TBD\",\"82\")","v":"TBD"},null,null,null,null,0,{"$f":"'Receipt Totals'!G80","v":0},0]
[null,null,"SUBTOTAL-COST TO COMPLETE:",null,null,{"$f":"SUM(F13:F88)","v":2100},{"$f":"SUM(G13:G88)","v":0},{"$f":"SUM(H13:H88)","v":2100},{"$f":"SUM(I13:I88)","v":0},{"$f":"SUM(J13:J88)","v":2100}]
[null,null,9998,"INTEREST EXPENSE",null,null,null,null,null,{"$f":"$F90-$G90","v":0}]
[null,null,4,"CLOSING COSTS",null,null,null,null,null,{"$f":"$F91-$G91-$I91","v":0}]
[null,null,"FINAL REQUESTED TOTALS:",null,null,{"$f":"SUM(F89:F91)","v":2100},{"$f":"SUM(G89:G91)","v":0},null,{"$f":"SUM(I89:I91)","v":0},{"$f":"SUM(J89:J91)","v":2100}]
[null,null,"LOAN AMOUNT REQUEST:"]
[null,null,"ESTIMATED CASH NEEDED TO CLOSE:",null,null,{"$f":"J92-F93","v":2100}]
[null,null,"Construction Funds Available (for CDD use only):",null,null,{"$f":"J89-J13+J90","v":2100}]
[null,null,"Loan to Cost of Construction Ratio:",null,null,{"$f":"F93/H89","v":0}]
[null," ","**Lot Cost: \nIf Land is being purchased or owned LESS than one year - Construction Budget will equal purchase price or appraised value, whichever is less. \n\nIf Land has been owned MORE than one year - Construction Budget will reflect the appraised value AND any land payoffs (if applicable) will need to be accounted for in the \"Financed Budget\" column. \n\nRemodel Loans Require a Completed Scope of Work Sheet"]
[null,null,"For Detached Structures - Utilize the Following Letters to indicate what type of building is being constructed: \nA - Additional Dwelling Unit (ADU)          G - Garage          S - Shop"]
[]
[null," ","Borrower:",null,null,null,"Borrower:"]
[null,null,null,"PRINT HERE",null,null,null,"SIGN HERE"]
[]
[null,null,"Borrower:",null,null,null,"Borrower:"]
[null,null,null,"PRINT HERE",null,null,null,"SIGN HERE"]
[]
[null,null,"Contractor:",null,null,null,"Contractor:"]
[null,null,null,"PRINT HERE",null,null,null,"SIGN HERE"]
[]
[null,null,"Loan Officer:",null,null,null,"Loan Officer:"]
[null,null,null,"PRINT HERE",null,null,null,"SIGN HERE"]
[null,null,null,null,null,null,null,null,"Rev. 2/2025"]
[]
[]
[null,null,"Sources",null,null,null,"Uses"]
[null,null,"Loan Amount: ",null,null,{"$f":"F93","v":0},"Land Payoff:",null,null,{"$f":"J13","v":0}]
[null,null,"Cash Down Payment due at Closing:",null,null,{"$f":"F94","v":2100},"Construction Funds Available to Draw:",null,null,{"$f":"SUM(J14:J57,J59:J88)","v":0}]
[null,null,"Construction Cost Pre-Paid Items:",null,null,{"$f":"SUM(I14:I88)","v":0},"Construction Cost Pre-Paid Items:",null,null,{"$f":"SUM(I14:I57,I59:I88)","v":0}]
[null,null,"Loan Cost Pre-Paid Items:",null,null,{"$f":"SUM(I58,I90:I91)","v":0},"Loan Fees / Closing Costs:",null,null,{"$f":"SUM(F90:F91)","v":0},null,null,null,null,null," "]
[null,null,"Land Equity: ",null,null,{"$f":"I13","v":0},"Land Equity:",null,null,{"$f":"I13","v":0}]
[null,null,null,null,null,null,"Inspection Fees: ",null,null,{"$f":"F58","v":2100}]
[null,null,"Total Sources: ",null,null,{"$f":"SUM(F115:F120)","v":2100},"Total Uses:",null,null,{"$f":"SUM(J115:J120)","v":2100}]
[]
[null,null,"Contingency Calculator: "]
[]
[]
[null,null,0.05,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C126)","v":0}]
[null,null,0.06,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C127)","v":0}]
[null,null,7.0000000000000007E-2,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C128)","v":0}]
[null,null,0.08,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C129)","v":0}]
[null,null,0.09,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C130)","v":0}]
[null,null,0.1,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C131)","v":0}]
[null,null,0.15,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C132)","v":0}]
[null,null,0.17499999999999999,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C133)","v":0}]
[null,null,"MANUAL   CALCULATOR %",null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*E134)","v":0}]
[]
[null,null,"Construction Draw Funds:",null,null,null,{"$f":"F95","v":2100}]

{"sheet":"S&U - Contingency Calculator","index":1,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":true,"merged":[[20,2,20,3],[21,2,21,3],[14,6,14,9],[15,6,15,9],[16,6,16,9],[17,6,17,9],[18,6,18,9],[24,2,24,3],[2,2,2,3],[2,6,2,9],[23,2,23,9],[24,6,24,9],[12,4,12,5],[22,6,22,9],[19,6,19,9],[20,6,20,9],[21,6,21,9],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3]]}
[]
[]
[null,null,"Sources",null,null,null,"Uses"]
[null,null,"Loan Amount: ",{"$f":"'Appraisal CBD'!F93","v":0},null,null,"Land Payoff:",null,null,{"$f":"'Appraisal CBD'!H13","v":0}]
[null,null,"Cash Down Payment due at Closing:",{"$f":"'Appraisal CBD'!F94","v":2100},null,null,"Construction Funds Available to Draw:",null,null,{"$f":"SUM('Appraisal CBD'!H14:H57,'Appraisal CBD'!H59:H88)","v":0}]
[null,null,"Construction Cost Pre-Paid Items:",{"$f":"SUM('Appraisal CBD'!G14:G57,'Appraisal CBD'!G59:G88)","v":0},null,null,"Construction Cost Pre-Paid Items:",null,null,{"$f":"SUM('Appraisal CBD'!G14:G57,'Appraisal CBD'!G59:G88)","v":0}]
[null,null,"Loan Cost Pre-Paid Items:",{"$f":"SUM('Appraisal CBD'!G90:G91,'Appraisal CBD'!G58)","v":0},null,null,"Loan Fees / Closing Costs:",null,null,{"$f":"SUM('Appraisal CBD'!F90:F91)","v":0}]
[null,null,"Land Equity: ",{"$f":"'Appraisal CBD'!G13","v":0},null,null,"Land Equity:",null,null,{"$f":"'Appraisal CBD'!G13","v":0}]
[null,null,null,null,null,null,"Inspection Fees: ",null,null,{"$f":"'Appraisal CBD'!F58","v":2100}]
[null,null,"Total Sources: ",{"$f":"SUM(D4:D9)","v":2100},null,null,"Total Uses:",null,null,{"$f":"SUM(J4:J9)","v":2100}]
[]
[]
[null,null,"Contingency Calculator: "]
[]
[null,null,0.05,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C15)","v":0}]
[null,null,0.06,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C16)","v":0}]
[null,null,7.0000000000000007E-2,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C17)","v":0}]
[null,null,0.08,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C18)","v":0}]
[null,null,0.09,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C19)","v":0}]
[null,null,0.1,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C20)","v":0}]
[null,null,0.15,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C21)","v":0}]
[null,null,0.17499999999999999,null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*C22)","v":0}]
[null,null,"MANUAL   CALCULATOR %",null,null,null,{"$f":"SUM('CBD Builder Breakout'!$K$61*D23)","v":0}]
[null,null,"LE/TRID Notes:"]
[null,null,"Construction Draw Funds:",null,null,null,{"$f":"'Appraisal CBD'!F95","v":2100}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"'Appraisal CBD'!I61","v":0}]

{"sheet":"Receipt Totals","index":2,"n_rows":88,"n_cols":40,"rows_kept":88,"cut":false,"hidden":false,"merged":[[87,3,87,6],[2,8,4,39],[83,3,83,6],[84,3,84,6],[85,3,85,6],[86,3,86,6],[2,7,3,7],[82,3,82,6],[81,3,81,4],[80,3,80,4],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]]}
[]
[]
[null,null,null,"LINE ITEM NUMBER","DESCRIPTION OF WORK","COST BREAKDOWN","CONFIRMED RECEIPTS","NOTES","                                     RECEIPT TOTALS"]
[]
[null,null,null,1,"Lot Cost ",{"$f":"'Appraisal CBD'!F13","v":0},{"$f":"'Appraisal CBD'!G13","v":0}]
[null,null,null,5,"Plans & Specs ",{"$f":"'Appraisal CBD'!F14","v":0},{"$f":"SUM(I6:AN6)","v":0}]
[null,null,null,6,"Permits",{"$f":"'Appraisal CBD'!F15","v":0},{"$f":"SUM(I7:AN7)","v":0}]
[null,null,null,7,"Water Hookup & Shares",{"$f":"'Appraisal CBD'!F16","v":0},0]
[null,null,null,8,"Temp Power Hookup ",{"$f":"'Appraisal CBD'!F17","v":0},0]
[null,null,null,9,"Excavation/Grade/Fill ",{"$f":"'Appraisal CBD'!F18","v":0},0]
[null,null,null,10,"Surveying & Engineering",{"$f":"'Appraisal CBD'!F19","v":0},0]
[null,null,null,11,"Foundation Labor",{"$f":"'Appraisal CBD'!F20","v":0},0]
[null,null,null,12,"Foundation Concrete",{"$f":"'Appraisal CBD'!F21","v":0},0]
[null,null,null,13,"Steps / Walks / Driveway",{"$f":"'Appraisal CBD'!F22","v":0},0]
[null,null,null,14,"Garage/Basement Concrete",{"$f":"'Appraisal CBD'!F23","v":0},0]
[null,null,null,15,"Chimney / Fireplace",{"$f":"'Appraisal CBD'!F24","v":0},0]
[null,null,null,16,"Masonry",{"$f":"'Appraisal CBD'!F25","v":0},0]
[null,null,null,17,"Framing Lumber",{"$f":"'Appraisal CBD'!F26","v":0},0]
[null,null,null,18,"Siding",{"$f":"'Appraisal CBD'!F27","v":0},0]
[null,null,null,19,"Framing Labor",{"$f":"'Appraisal CBD'!F28","v":0},0]
[null,null,null,20,"Rough Plumbing",{"$f":"'Appraisal CBD'!F29","v":0},0]
[null,null,null,21,"Electrical Wiring ",{"$f":"'Appraisal CBD'!F30","v":0},0]
[null,null,null,22,"Finish Plumbing",{"$f":"'Appraisal CBD'!F31","v":0},0]
[null,null,null,23,"Sewer / Septic ",{"$f":"'Appraisal CBD'!F32","v":0},0]
[null,null,null,24,"Gutters / Downspouts",{"$f":"'Appraisal CBD'!F33","v":0},0]
[null,null,null,25,"Water Line Install",{"$f":"'Appraisal CBD'!F34","v":0},0]
[null,null,null,26,"Insulation ",{"$f":"'Appraisal CBD'!F35","v":0},0]
[null,null,null,27,"Roof Trusses",{"$f":"'Appraisal CBD'!F36","v":0},0]
[null,null,null,28,"Roofing",{"$f":"'Appraisal CBD'!F37","v":0},0]
[null,null,null,29,"Drywall",{"$f":"'Appraisal CBD'!F38","v":0},0]
[null,null,null,31,"Lighting Fixtures",{"$f":"'Appraisal CBD'!F39","v":0},0]
[null,null,null,32,"Heating",{"$f":"'Appraisal CBD'!F40","v":0},0]
[null,null,null,33,"Windows & Screens",{"$f":"'Appraisal CBD'!F41","v":0},0]
[null,null,null,34,"Exterior Doors/Trim ",{"$f":"'Appraisal CBD'!F42","v":0},0]
[null,null,null,35,"Interior Doors/Trim",{"$f":"'Appraisal CBD'!F43","v":0},0]
[null,null,null,36,"Finish Labor ",{"$f":"'Appraisal CBD'!F44","v":0},0]
[null,null,null,37,"Garage Doors/Openers",{"$f":"'Appraisal CBD'!F45","v":0},0]
[null,null,null,38,"Cabinets",{"$f":"'Appraisal CBD'!F46","v":0},0]
[null,null,null,39,"Exterior Painting",{"$f":"'Appraisal CBD'!F47","v":0},0]
[null,null,null,40,"Staircase",{"$f":"'Appraisal CBD'!F48","v":0},0]
[null,null,null,41,"Hardwood Floors/Tile",{"$f":"'Appraisal CBD'!F49","v":0},0]
[null,null,null,42,"Carpet / Vinyl / Countertops",{"$f":"'Appraisal CBD'!F50","v":0},0]
[null,null,null,43,"Misc. Hardware ",{"$f":"'Appraisal CBD'!F51","v":0},0]
[null,null,null,44,"Mirrors / Shower Doors",{"$f":"'Appraisal CBD'!F52","v":0},0]
[null,null,null,45,"Appliances",{"$f":"'Appraisal CBD'!F53","v":0},0]
[null,null,null,46,"Safety Equipment / Vacuum Stystem ",{"$f":"'Appraisal CBD'!F54","v":0},0]
[null,null,null,47,"Insurance / Cleaning",{"$f":"'Appraisal CBD'!F55","v":0},0]
[null,null,null,48,"Decks",{"$f":"'Appraisal CBD'!F56","v":0},0]
[null,null,null,49,"Landscaping",{"$f":"'Appraisal CBD'!F57","v":0},0]
[null,null,null,50,"Required Inspection Costs ",{"$f":"'Appraisal CBD'!F58","v":2100},0]
[null,null,null,52,"Profit / Overhead",{"$f":"'Appraisal CBD'!F59","v":0},0]
[" ",null,null,53,"Taxes",{"$f":"'Appraisal CBD'!F60","v":0},0]
[null,null,null,54,"Cushion/Contingency (Minimum 3%)",{"$f":"'Appraisal CBD'!F61","v":0},0]
[null,null,null,55,"Log Set Up Labor",{"$f":"'Appraisal CBD'!F62","v":0},0]
[null,null,null,56,"Log Delivery",{"$f":"'Appraisal CBD'!F63","v":0},0]
[null,null,null,57,"Utility Fees",{"$f":"'Appraisal CBD'!F64","v":0},0]
[null,null,null,58,"Demolition ",{"$f":"'Appraisal CBD'!F65","v":0},0]
[null,null,null,60,"Interior Painting",{"$f":"'Appraisal CBD'!F66","v":0},0]
[null,null,null,61,"Portable Toilet ",{"$f":"'Appraisal CBD'!F67","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C68","v":"62"},{"$f":"'CBD Builder Breakout'!D68","v":"Fire Supression System"},{"$f":"'Appraisal CBD'!F68","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C69","v":"TBD"},{"$f":"'CBD Builder Breakout'!D69:E69","v":0},{"$f":"'Appraisal CBD'!F69","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C70","v":"TBD"},{"$f":"'CBD Builder Breakout'!D70:E70","v":0},{"$f":"'Appraisal CBD'!F70","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C71","v":"65"},{"$f":"'CBD Builder Breakout'!D71:E71","v":0},{"$f":"'Appraisal CBD'!F71","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C72","v":"TBD"},{"$f":"'CBD Builder Breakout'!D72:E72","v":0},{"$f":"'Appraisal CBD'!F72","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C73","v":"TBD"},{"$f":"'CBD Builder Breakout'!D73:E73","v":0},{"$f":"'Appraisal CBD'!F73","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C74","v":"TBD"},{"$f":"'CBD Builder Breakout'!D74:E74","v":0},{"$f":"'Appraisal CBD'!F74","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C75","v":"TBD"},{"$f":"'CBD Builder Breakout'!D75:E75","v":0},{"$f":"'Appraisal CBD'!F75","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C76","v":"TBD"},{"$f":"'CBD Builder Breakout'!D76:E76","v":0},{"$f":"'Appraisal CBD'!F76","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C77","v":"TBD"},{"$f":"'CBD Builder Breakout'!D77:E77","v":0},{"$f":"'Appraisal CBD'!F77","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C78","v":"TBD"},{"$f":"'CBD Builder Breakout'!D78:E78","v":0},{"$f":"'Appraisal CBD'!F78","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C79","v":"TBD"},{"$f":"'CBD Builder Breakout'!D79:E79","v":0},{"$f":"'Appraisal CBD'!F79","v":0},{"$f":"SUM(I71:AN71)","v":0}]
[null,null,null,{"$f":"'CBD Builder Breakout'!C80","v":"TBD"},{"$f":"'CBD Builder Breakout'!D80:E80","v":0},{"$f":"'Appraisal CBD'!F80","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C81","v":"TBD"},{"$f":"'CBD Builder Breakout'!D81:E81","v":0},{"$f":"'Appraisal CBD'!F81","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C82","v":"TBD"},{"$f":"'CBD Builder Breakout'!D82:E82","v":0},{"$f":"'Appraisal CBD'!F82","v":0},0," "]
[null,null,null,{"$f":"'CBD Builder Breakout'!C83","v":"TBD"},{"$f":"'CBD Builder Breakout'!D83:E83","v":0},{"$f":"'Appraisal CBD'!F83","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C84","v":"TBD"},{"$f":"'CBD Builder Breakout'!D84:E84","v":0},{"$f":"'Appraisal CBD'!F84","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C85","v":"TBD"},{"$f":"'CBD Builder Breakout'!D85:E85","v":0},{"$f":"'Appraisal CBD'!F85","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C86","v":"TBD"},{"$f":"'CBD Builder Breakout'!D86:E86","v":0},{"$f":"'Appraisal CBD'!F86","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C87","v":"TBD"},{"$f":"'CBD Builder Breakout'!D87:E87","v":0},{"$f":"'Appraisal CBD'!F87","v":0},0]
[null,null,null,{"$f":"'CBD Builder Breakout'!C88","v":"TBD"},{"$f":"'CBD Builder Breakout'!D88:E88","v":0},{"$f":"'Appraisal CBD'!F88","v":0},0]
[null,null,null,"SUBTOTAL-COST TO COMPLETE:",null,{"$f":"SUM(F5:F80)","v":2100},{"$f":"SUM(G5:G80)","v":0},{"$f":"SUM(I81:AN81)","v":0},{"$f":"SUM(I6:I80)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z6:Z80)","v":0},{"$f":"SUM(AA6:AA80)","v":0},0,0,0,0,{"$f":"SUM(AF6:AF80)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,"What Qualifies as a Paid Receipt"]
[null,null,null,"An Invoice with a Zero Balance Due"]
[null,null,null,"Cancelled Checks (Copies of front and back)"]
[null,null,null,"Bank Statements and/or credit card statements matching the payment to the invoice amount",null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Email from the business stating the invoice is paid in full"]
[null,null,null,"Receipts from Home Depot or Lowes"]

{"sheet":"Builder Only Budget","index":3,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[[111,6,111,7],[103,6,103,7],[104,6,104,7],[106,6,106,7],[107,6,107,7],[109,2,110,2],[109,6,109,7],[110,6,110,7],[95,2,95,4],[95,5,95,7],[96,2,96,7],[97,2,97,7],[100,6,100,7],[101,6,101,7],[91,2,91,4],[92,2,92,4],[92,5,92,7],[93,2,93,4],[93,5,93,7],[94,2,94,4],[94,5,94,7],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,2,88,4],[89,3,89,4],[90,3,90,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[9,2,9,7],[10,2,11,2],[10,3,11,4],[10,5,11,5],[10,6,11,6],[10,7,11,7],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[7,5,7,7]]}
[]
[null," "]
[null,null,null,null,"BORROWER:",{"$f":"IF('CBD Builder Breakout'!G3=\"\",\"\",'CBD Builder Breakout'!G3)","v":""}]
[null,null,null,null,"PROPERTY ADDRESS:",{"$f":"IF('CBD Builder Breakout'!G4=\"\",\"\",'CBD Builder Breakout'!G4)","v":""}]
[null,null,null,null,"EMAIL ADDRES:",{"$f":"IF('CBD Builder Breakout'!G5=\"\",\"\",'CBD Builder Breakout'!G5)","v":""}]
[null,null,null,null,"PHONE NUMBER: ",{"$f":"IF('CBD Builder Breakout'!G6=\"\",\"\",'CBD Builder Breakout'!G6)","v":""}]
[null,null,null,null,"LOAN #: ",{"$f":"IF('CBD Builder Breakout'!G7=\"\",\"\",'CBD Builder Breakout'!G7)","v":""}]
[null,null,null,null,"Has Foundation been poured (Yes or No)?",{"$f":"IF('CBD Builder Breakout'!G8=\"\",\"\",'CBD Builder Breakout'!G8)","v":""}]
[]
[null," ","NOTE:  PLEASE COMPLETE ONLY GREEN FIELDS OF THIS FORM."]
[null,null,"Line Item ","DESCRIPTION OF WORK",null,"CONST. BUDGET","MANUAL INPUT FOR BUILDER SPECIFIC RECEIPTS","FINANCED BUDGET"]
[]
[null,null,1,"Lot Cost - *See Below for Instructions",null,{"$f":"'CBD Builder Breakout'!F13","v":0},null,{"$f":"$F13-$G13","v":0},{"$f":"'Receipt Totals'!H5","v":0}]
[null,null,5,"Plans & Specs ",null,{"$f":"IF('CBD Builder Breakout'!G14=\"\",\"\",'CBD Builder Breakout'!G14)","v":""},null,{"$f":"IF(AND(LEN(TRIM(F14&\"\"))=0,LEN(TRIM(G14&\"\"))=0),\"\",N(F14)-N(G14))","v":""},{"$f":"'Receipt Totals'!H6","v":0}]
[null,null,6,"Permits",null,{"$f":"IF('CBD Builder Breakout'!G15=\"\",\"\",'CBD Builder Breakout'!G15)","v":""},null,{"$f":"IF(AND(LEN(TRIM(F15&\"\"))=0,LEN(TRIM(G15&\"\"))=0),\"\",N(F15)-N(G15))","v":""},{"$f":"'Receipt Totals'!H7","v":0}]
[null,null,7,"Water Hookup & Shares",null,{"$f":"IF('CBD Builder Breakout'!G16=\"\",\"\",'CBD Builder Breakout'!G16)","v":""},null,"",{"$f":"'Receipt Totals'!H8","v":0}]
[null,null,8,"Temp Power Hookup ",null,{"$f":"IF('CBD Builder Breakout'!G17=\"\",\"\",'CBD Builder Breakout'!G17)","v":""},null,"",{"$f":"'Receipt Totals'!H9","v":0}]
[null,null,9,"Excavation/Grade/Fill ",null,{"$f":"IF('CBD Builder Breakout'!G18=\"\",\"\",'CBD Builder Breakout'!G18)","v":""},null,"",{"$f":"'Receipt Totals'!H10","v":0}]
[null,null,10,"Surveying & Engineering",null,{"$f":"IF('CBD Builder Breakout'!G19=\"\",\"\",'CBD Builder Breakout'!G19)","v":""},null,"",{"$f":"'Receipt Totals'!H11","v":0},null," "]
[null,null,11,"Foundation Labor",null,{"$f":"IF('CBD Builder Breakout'!G20=\"\",\"\",'CBD Builder Breakout'!G20)","v":""},null,"",{"$f":"'Receipt Totals'!H12","v":0}]
[null,null,12,"Foundation Concrete",null,{"$f":"IF('CBD Builder Breakout'!G21=\"\",\"\",'CBD Builder Breakout'!G21)","v":""},null,"",{"$f":"'Receipt Totals'!H13","v":0}]
[null,null,13,"Steps / Walks / Driveway",null,{"$f":"IF('CBD Builder Breakout'!G22=\"\",\"\",'CBD Builder Breakout'!G22)","v":""},null,"",{"$f":"'Receipt Totals'!H14","v":0}]
[null,null,14,"Garage/Basement Concrete",null,{"$f":"IF('CBD Builder Breakout'!G23=\"\",\"\",'CBD Builder Breakout'!G23)","v":""},null,"",{"$f":"'Receipt Totals'!H15","v":0}]
[null,null,15,"Chimney / Fireplace",null,{"$f":"IF('CBD Builder Breakout'!G24=\"\",\"\",'CBD Builder Breakout'!G24)","v":""},null,"",{"$f":"'Receipt Totals'!H16","v":0}]
[null,null,16,"Masonry",null,{"$f":"IF('CBD Builder Breakout'!G25=\"\",\"\",'CBD Builder Breakout'!G25)","v":""},null,"",{"$f":"'Receipt Totals'!H17","v":0}]
[null,null,17,"Framing Lumber",null,{"$f":"IF('CBD Builder Breakout'!G26=\"\",\"\",'CBD Builder Breakout'!G26)","v":""},null,"",{"$f":"'Receipt Totals'!H18","v":0}]
[null,null,18,"Siding",null,{"$f":"IF('CBD Builder Breakout'!G27=\"\",\"\",'CBD Builder Breakout'!G27)","v":""},null,"",{"$f":"'Receipt Totals'!H19","v":0}]
[null,null,19,"Framing Labor",null,{"$f":"IF('CBD Builder Breakout'!G28=\"\",\"\",'CBD Builder Breakout'!G28)","v":""},null,"",{"$f":"'Receipt Totals'!H20","v":0}]
[null,null,20,"Rough Plumbing",null,{"$f":"IF('CBD Builder Breakout'!G29=\"\",\"\",'CBD Builder Breakout'!G29)","v":""},null,"",{"$f":"'Receipt Totals'!H21","v":0}]
[null,null,21,"Electrical Wiring ",null,{"$f":"IF('CBD Builder Breakout'!G30=\"\",\"\",'CBD Builder Breakout'!G30)","v":""},null,"",{"$f":"'Receipt Totals'!H22","v":0}]
[null,null,22,"Finish Plumbing",null,{"$f":"IF('CBD Builder Breakout'!G31=\"\",\"\",'CBD Builder Breakout'!G31)","v":""},null,"",{"$f":"'Receipt Totals'!H23","v":0}]
[null,null,23,"Sewer / Septic ",null,{"$f":"IF('CBD Builder Breakout'!G32=\"\",\"\",'CBD Builder Breakout'!G32)","v":""},null,"",{"$f":"'Receipt Totals'!H24","v":0}]
[null,null,24,"Gutters / Downspouts",null,{"$f":"IF('CBD Builder Breakout'!G33=\"\",\"\",'CBD Builder Breakout'!G33)","v":""},null,"",{"$f":"'Receipt Totals'!H25","v":0}]
[null,null,25,"Water Line Install",null,{"$f":"IF('CBD Builder Breakout'!G34=\"\",\"\",'CBD Builder Breakout'!G34)","v":""},null,"",{"$f":"'Receipt Totals'!H26","v":0}]
[null,null,26,"Insulation ",null,{"$f":"IF('CBD Builder Breakout'!G35=\"\",\"\",'CBD Builder Breakout'!G35)","v":""},null,"",{"$f":"'Receipt Totals'!H27","v":0}]
[null,null,27,"Roof Trusses",null,{"$f":"IF('CBD Builder Breakout'!G36=\"\",\"\",'CBD Builder Breakout'!G36)","v":""},null,"",{"$f":"'Receipt Totals'!H28","v":0}]
[null,null,28,"Roofing",null,{"$f":"IF('CBD Builder Breakout'!G37=\"\",\"\",'CBD Builder Breakout'!G37)","v":""},null,"",{"$f":"'Receipt Totals'!H29","v":0}]
[null,null,29,"Drywall",null,{"$f":"IF('CBD Builder Breakout'!G38=\"\",\"\",'CBD Builder Breakout'!G38)","v":""},null,"",{"$f":"'Receipt Totals'!H30","v":0}]
[null,null,31,"Lighting Fixtures",null,{"$f":"IF('CBD Builder Breakout'!G39=\"\",\"\",'CBD Builder Breakout'!G39)","v":""},null,"",{"$f":"'Receipt Totals'!H31","v":0}]
[null,null,32,"Heating",null,{"$f":"IF('CBD Builder Breakout'!G40=\"\",\"\",'CBD Builder Breakout'!G40)","v":""},null,"",{"$f":"'Receipt Totals'!H32","v":0}]
[null,null,33,"Windows & Screens",null,{"$f":"IF('CBD Builder Breakout'!G41=\"\",\"\",'CBD Builder Breakout'!G41)","v":""},null,"",{"$f":"'Receipt Totals'!H33","v":0}]
[null,null,34,"Exterior Doors/Trim ",null,{"$f":"IF('CBD Builder Breakout'!G42=\"\",\"\",'CBD Builder Breakout'!G42)","v":""},null,"",{"$f":"'Receipt Totals'!H34","v":0}]
[null,null,35,"Interior Doors/Trim",null,{"$f":"IF('CBD Builder Breakout'!G43=\"\",\"\",'CBD Builder Breakout'!G43)","v":""},null,"",{"$f":"'Receipt Totals'!H35","v":0}]
[null,null,36,"Finish Labor ",null,{"$f":"IF('CBD Builder Breakout'!G44=\"\",\"\",'CBD Builder Breakout'!G44)","v":""},null,"",{"$f":"'Receipt Totals'!H36","v":0}]
[null,null,37,"Garage Doors/Openers",null,{"$f":"IF('CBD Builder Breakout'!G45=\"\",\"\",'CBD Builder Breakout'!G45)","v":""},null,"",{"$f":"'Receipt Totals'!H37","v":0}]
[null,null,38,"Cabinets",null,{"$f":"IF('CBD Builder Breakout'!G46=\"\",\"\",'CBD Builder Breakout'!G46)","v":""},null,"",{"$f":"'Receipt Totals'!H38","v":0}]
[null,null,39,"Exterior Painting",null,{"$f":"IF('CBD Builder Breakout'!G47=\"\",\"\",'CBD Builder Breakout'!G47)","v":""},null,"",{"$f":"'Receipt Totals'!H39","v":0}]
[null,null,40,"Staircase",null,{"$f":"IF('CBD Builder Breakout'!G48=\"\",\"\",'CBD Builder Breakout'!G48)","v":""},null,"",{"$f":"'Receipt Totals'!H40","v":0}]
[null,null,41,"Hardwood Floors/Tile",null,{"$f":"IF('CBD Builder Breakout'!G49=\"\",\"\",'CBD Builder Breakout'!G49)","v":""},null,"",{"$f":"'Receipt Totals'!H41","v":0}]
[null,null,42,"Carpet / Vinyl / Countertops",null,{"$f":"IF('CBD Builder Breakout'!G50=\"\",\"\",'CBD Builder Breakout'!G50)","v":""},null,"",{"$f":"'Receipt Totals'!H42","v":0}]
[null,null,43,"Misc. Hardware ",null,{"$f":"IF('CBD Builder Breakout'!G51=\"\",\"\",'CBD Builder Breakout'!G51)","v":""},null,"",{"$f":"'Receipt Totals'!H43","v":0}]
[" ",null,44,"Mirrors / Shower Doors",null,{"$f":"IF('CBD Builder Breakout'!G52=\"\",\"\",'CBD Builder Breakout'!G52)","v":""},null,"",{"$f":"'Receipt Totals'!H44","v":0}]
[null,null,45,"Appliances",null,{"$f":"IF('CBD Builder Breakout'!G53=\"\",\"\",'CBD Builder Breakout'!G53)","v":""},null,"",{"$f":"'Receipt Totals'!H45","v":0}]
[null,null,46,"Safety Equipment / Vacuum Stystem ",null,{"$f":"IF('CBD Builder Breakout'!G54=\"\",\"\",'CBD Builder Breakout'!G54)","v":""},null,"",{"$f":"'Receipt Totals'!H46","v":0}]
[null,null,47,"Insurance / Cleaning",null,{"$f":"IF('CBD Builder Breakout'!G55=\"\",\"\",'CBD Builder Breakout'!G55)","v":""},null,{"$f":"IF(AND(LEN(TRIM(F55&\"\"))=0,LEN(TRIM(G55&\"\"))=0),\"\",N(F55)-N(G55))","v":""},{"$f":"'Receipt Totals'!H47","v":0}]
[null,null,48,"Decks",null,{"$f":"IF('CBD Builder Breakout'!G56=\"\",\"\",'CBD Builder Breakout'!G56)","v":""},null,"",{"$f":"'Receipt Totals'!H48","v":0}]
[null,null,49,"Landscaping",null,{"$f":"IF('CBD Builder Breakout'!G57=\"\",\"\",'CBD Builder Breakout'!G57)","v":""},null,"",{"$f":"'Receipt Totals'!H49","v":0}]
[null,null,50,"Required Inspection Costs ",null,null,null,"",{"$f":"'Receipt Totals'!H50","v":0}]
[null,null,52,"Profit / Overhead",null,{"$f":"IF('CBD Builder Breakout'!G59=\"\",\"\",'CBD Builder Breakout'!G59)","v":""},null,"",{"$f":"'Receipt Totals'!H51","v":0}]
[null,null,53,"Taxes",null,{"$f":"IF('CBD Builder Breakout'!G60=\"\",\"\",'CBD Builder Breakout'!G60)","v":""},null,"",{"$f":"'Receipt Totals'!H52","v":0}]
[null,null,54,"Cusion/Contingency (Min. 5%)",{"$f":"SUM(F61/I61)","v":{"$error":"#DIV/0!"}},null,null,"",{"$f":"SUM(H14:H57,H59:H60,H62:H88)","v":0}]
[null,null,55,"Log Set Up Labor",null,{"$f":"IF('CBD Builder Breakout'!G62=\"\",\"\",'CBD Builder Breakout'!G62)","v":""},null,"",{"$f":"'Receipt Totals'!H54","v":0}]
[null,null,56,"Log Delivery",null,{"$f":"IF('CBD Builder Breakout'!G63=\"\",\"\",'CBD Builder Breakout'!G63)","v":""},null,"",{"$f":"'Receipt Totals'!H55","v":0}]
[null,null,57,"Utility Fees",null,{"$f":"IF('CBD Builder Breakout'!G64=\"\",\"\",'CBD Builder Breakout'!G64)","v":""},null,"",{"$f":"'Receipt Totals'!H56","v":0}]
[null,null,58,"Demolition ",null,{"$f":"IF('CBD Builder Breakout'!G65=\"\",\"\",'CBD Builder Breakout'!G65)","v":""},null,"",{"$f":"'Receipt Totals'!H57","v":0}]
[null,null,60,"Interior Painting",null,{"$f":"IF('CBD Builder Breakout'!G66=\"\",\"\",'CBD Builder Breakout'!G66)","v":""},null,"",{"$f":"'Receipt Totals'!H58","v":0}]
[null,null,61,"Portable Toilet ",null,{"$f":"IF('CBD Builder Breakout'!G67=\"\",\"\",'CBD Builder Breakout'!G67)","v":""},null,"",{"$f":"'Receipt Totals'!H59","v":0}]
[{"$f":"ISBLANK(D68)","v":false},null,{"$f":"'CBD Builder Breakout'!C68","v":"62"},{"$f":"'CBD Builder Breakout'!D68:E68","v":"Fire Supression System"},null,{"$f":"IF('CBD Builder Breakout'!G68=\"\",\"\",'CBD Builder Breakout'!G68)","v":""},null,"",{"$f":"'Receipt Totals'!H60","v":0}]
[{"$f":"ISBLANK(D69)","v":false},null,{"$f":"'CBD Builder Breakout'!C69","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D69&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E69&\"\"))=0),\"\",'CBD Builder Breakout'!D69:E69)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G69=\"\",\"\",'CBD Builder Breakout'!G69)","v":""},null,"",{"$f":"'Receipt Totals'!H61","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C70","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D70&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E70&\"\"))=0),\"\",'CBD Builder Breakout'!D70:E70)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G70=\"\",\"\",'CBD Builder Breakout'!G70)","v":""},null,"",{"$f":"'Receipt Totals'!H62","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C71","v":"65"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D71&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E71&\"\"))=0),\"\",'CBD Builder Breakout'!D71:E71)","v":"Cost for addition"},null,{"$f":"IF('CBD Builder Breakout'!G71=\"\",\"\",'CBD Builder Breakout'!G71)","v":""},null,"",{"$f":"'Receipt Totals'!H63","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C72","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D72&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E72&\"\"))=0),\"\",'CBD Builder Breakout'!D72:E72)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G72=\"\",\"\",'CBD Builder Breakout'!G72)","v":""},null,"",{"$f":"'Receipt Totals'!H64","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C73","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D73&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E73&\"\"))=0),\"\",'CBD Builder Breakout'!D73:E73)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G73=\"\",\"\",'CBD Builder Breakout'!G73)","v":""},null,"",{"$f":"'Receipt Totals'!H65","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C74","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D74&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E74&\"\"))=0),\"\",'CBD Builder Breakout'!D74:E74)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G74=\"\",\"\",'CBD Builder Breakout'!G74)","v":""},null,"",{"$f":"'Receipt Totals'!H66","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C75","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D75&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E75&\"\"))=0),\"\",'CBD Builder Breakout'!D75:E75)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G75=\"\",\"\",'CBD Builder Breakout'!G75)","v":""},null,"",{"$f":"'Receipt Totals'!H67","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C76","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D76&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E76&\"\"))=0),\"\",'CBD Builder Breakout'!D76:E76)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G76=\"\",\"\",'CBD Builder Breakout'!G76)","v":""},null,{"$f":"IF(AND(LEN(TRIM(F76&\"\"))=0,LEN(TRIM(G76&\"\"))=0),\"\",N(F76)-N(G76))","v":""},{"$f":"'Receipt Totals'!H68","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C77","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D77&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E77&\"\"))=0),\"\",'CBD Builder Breakout'!D77:E77)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G77=\"\",\"\",'CBD Builder Breakout'!G77)","v":""},null,"",{"$f":"'Receipt Totals'!H69","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C78","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D78&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E78&\"\"))=0),\"\",'CBD Builder Breakout'!D78:E78)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G78=\"\",\"\",'CBD Builder Breakout'!G78)","v":""},null,"",{"$f":"'Receipt Totals'!H70","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C79","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D79&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E79&\"\"))=0),\"\",'CBD Builder Breakout'!D79:E79)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G79=\"\",\"\",'CBD Builder Breakout'!G79)","v":""},null,{"$f":"IF(AND(LEN(TRIM(F79&\"\"))=0,LEN(TRIM(G79&\"\"))=0),\"\",N(F79)-N(G79))","v":""},{"$f":"'Receipt Totals'!H71","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C80","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D80&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E80&\"\"))=0),\"\",'CBD Builder Breakout'!D80:E80)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G80=\"\",\"\",'CBD Builder Breakout'!G80)","v":""},null,"",{"$f":"'Receipt Totals'!H72","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C81","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D81&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E81&\"\"))=0),\"\",'CBD Builder Breakout'!D81:E81)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G81=\"\",\"\",'CBD Builder Breakout'!G81)","v":""},null,"",{"$f":"'Receipt Totals'!H73","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C82","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D82&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E82&\"\"))=0),\"\",'CBD Builder Breakout'!D82:E82)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G82=\"\",\"\",'CBD Builder Breakout'!G82)","v":""},null,"",{"$f":"'Receipt Totals'!H74","v":" "}]
[false,null,{"$f":"'CBD Builder Breakout'!C83","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D83&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E83&\"\"))=0),\"\",'CBD Builder Breakout'!D83:E83)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G83=\"\",\"\",'CBD Builder Breakout'!G83)","v":""},null,"",{"$f":"'Receipt Totals'!H75","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C84","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D84&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E84&\"\"))=0),\"\",'CBD Builder Breakout'!D84:E84)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G84=\"\",\"\",'CBD Builder Breakout'!G84)","v":""},null,"",{"$f":"'Receipt Totals'!H76","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C85","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D85&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E85&\"\"))=0),\"\",'CBD Builder Breakout'!D85:E85)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G85=\"\",\"\",'CBD Builder Breakout'!G85)","v":""},null,"",{"$f":"'Receipt Totals'!H77","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C86","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D86&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E86&\"\"))=0),\"\",'CBD Builder Breakout'!D86:E86)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G86=\"\",\"\",'CBD Builder Breakout'!G86)","v":""},null,"",{"$f":"'Receipt Totals'!H78","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C87","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D87&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E87&\"\"))=0),\"\",'CBD Builder Breakout'!D87:E87)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G87=\"\",\"\",'CBD Builder Breakout'!G87)","v":""},null,"",{"$f":"'Receipt Totals'!H79","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C88","v":"TBD"},{"$f":"IF(AND(LEN(TRIM('CBD Builder Breakout'!D88&\"\"))=0,LEN(TRIM('CBD Builder Breakout'!E88&\"\"))=0),\"\",'CBD Builder Breakout'!D88:E88)","v":""},null,{"$f":"IF('CBD Builder Breakout'!G88=\"\",\"\",'CBD Builder Breakout'!G88)","v":""},null,"",{"$f":"'Receipt Totals'!H80","v":0}]
[null,null,"SUBTOTAL-COST TO COMPLETE:",null,null,{"$f":"SUM(F14:F88)-N(F61)-N(F58)","v":0},{"$f":"SUM(G13:G88)","v":0},{"$f":"IF(SUM(H14:H88)=F89-G89, SUM(H14:H88), \"ERROR\")","v":0}]
[null,null,9998,"INTEREST EXPENSE",null,{"$f":"'CBD Builder Breakout'!F90","v":0},null,{"$f":"$F90-$G90","v":0}]
[null,null,4,"CLOSING COSTS",null,{"$f":"'CBD Builder Breakout'!F91","v":0},null,{"$f":"$F91-$G91","v":0}]
[null,null,"FINAL REQUESTED TOTALS:",null,null,{"$f":"SUM(F89:F91)","v":0},{"$f":"SUM(G89:G91)","v":0},{"$f":"SUM(H89:H91)","v":0}]
[null,null,"LOAN AMOUNT REQUEST:",null,null,{"$f":"'CBD Builder Breakout'!F93:J93","v":0}]
[null,null,"ESTIMATED CASH NEEDED TO CLOSE:",null,null,{"$f":"H92-F93","v":0}]
[null,null,"Construction Funds Available (for CDD use only):",null,null,{"$f":"H89-H13+H90","v":0}]
[null,null,"Loan to Cost of Construction Ratio:",null,null,{"$f":"F93/F89","v":{"$error":"#DIV/0!"}}]
[null,null,"**Lot Cost: \nIf Land is being purchased or owned LESS than one year - Construction Budget will equal purchase price or appraised value, whichever is less. \n\nIf Land has been owned MORE than one year - Construction Budget will reflect the appraised value AND any land payoffs (if applicable) will need to be accounted for in the \"Financed Budget\" column. \n\nRemodel Loans Require a Completed Scope of Work Sheet"]
[null," ","For Detached Structures - Utilize the Following Letters to indicate what type of building is being constructed: \nA - Additional Dwelling Unit (ADU)          G - Garage          S - Shop"]
[]
[]
[null,null,"Borrower:",null,null,"Borrower:",null,null,null,null," "]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Borrower:",null,null,"Borrower:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Contractor:",null,null,"Contractor:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Loan Officer and Branch:",null,null,"Loan Officer:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[null,null,null,null,null,null,"Rev. 2/2025"]

{"sheet":"Appraisal CBD","index":4,"n_rows":112,"n_cols":11,"rows_kept":112,"cut":false,"hidden":false,"merged":[[22,3,22,4],[90,3,90,4],[91,2,91,4],[92,2,92,4],[93,2,93,4],[94,2,94,4],[88,2,88,4],[89,3,89,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[58,3,58,4],[59,3,59,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[27,3,27,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[111,6,111,7],[10,7,11,7],[10,6,11,6],[110,6,110,7],[92,5,92,7],[93,5,93,7],[97,2,97,7],[101,6,101,7],[107,6,107,7],[95,5,95,7],[96,2,96,7],[103,6,103,7],[104,6,104,7],[95,2,95,4],[10,5,11,5],[10,2,11,2],[10,3,11,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[12,3,12,4],[13,3,13,4],[109,2,110,2],[100,6,100,7],[106,6,106,7],[109,6,109,7],[94,5,94,7],[2,5,2,7],[3,5,3,7],[4,5,4,7],[5,5,5,7],[6,5,6,7],[7,5,7,7],[9,2,9,7],[14,3,14,4],[15,3,15,4],[16,3,16,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4]]}
[]
[null," "]
[null,null,null,null,"BORROWER:",{"$f":"'CBD Builder Breakout'!G3","v":0}]
[null,null,null,null,"PROPERTY ADDRESS:",{"$f":"'CBD Builder Breakout'!G4","v":0}]
[null,null,null,null,"EMAIL ADDRES:",{"$f":"'CBD Builder Breakout'!G5","v":0}]
[null,null,null,null,"PHONE NUMBER: ",{"$f":"'CBD Builder Breakout'!G6","v":0}]
[null,null,null,null,"LOAN #: ",{"$f":"'CBD Builder Breakout'!G7","v":0}]
[null,null,null,null,"Has Foundation been poured (Yes or No)?",{"$f":"'CBD Builder Breakout'!G8","v":0}]
[]
[null," ","NOTE:  PLEASE COMPLETE ONLY GREEN FIELDS OF THIS FORM."]
[null,null,"Line Item ","DESCRIPTION OF WORK",null,"CONST. BUDGET","TOTAL OF \nNON-INCLUDED \nITEMS","FINANCED BUDGET"]
[]
[null,null,1,"Lot Cost - *See Below for Instructions",null,{"$f":"'CBD Builder Breakout'!F13","v":0},{"$f":"'CBD Builder Breakout'!I13","v":0},{"$f":"$F13-$G13","v":0},{"$f":"'Receipt Totals'!H5","v":0}]
[null,null,5,"Plans & Specs ",null,{"$f":"'CBD Builder Breakout'!F14+'CBD Builder Breakout'!G14","v":0},{"$f":"'Receipt Totals'!G6","v":0},{"$f":"$F14-$G14","v":0},{"$f":"'Receipt Totals'!H6","v":0}]
[null,null,6,"Permits",null,{"$f":"'CBD Builder Breakout'!F15+'CBD Builder Breakout'!G15","v":0},{"$f":"'Receipt Totals'!G7","v":0},{"$f":"$F15-$G15","v":0},{"$f":"'Receipt Totals'!H7","v":0}]
[null,null,7,"Water Hookup & Shares",null,{"$f":"'CBD Builder Breakout'!F16+'CBD Builder Breakout'!G16","v":0},{"$f":"'Receipt Totals'!G8","v":0},{"$f":"$F16-$G16","v":0},{"$f":"'Receipt Totals'!H8","v":0}]
[null,null,8,"Temp Power Hookup ",null,{"$f":"'CBD Builder Breakout'!F17+'CBD Builder Breakout'!G17","v":0},{"$f":"'Receipt Totals'!G9","v":0},{"$f":"$F17-$G17","v":0},{"$f":"'Receipt Totals'!H9","v":0}]
[null,null,9,"Excavation/Grade/Fill ",null,{"$f":"'CBD Builder Breakout'!F18+'CBD Builder Breakout'!G18","v":0},{"$f":"'Receipt Totals'!G10","v":0},{"$f":"$F18-$G18","v":0},{"$f":"'Receipt Totals'!H10","v":0}]
[null,null,10,"Surveying & Engineering",null,{"$f":"'CBD Builder Breakout'!F19+'CBD Builder Breakout'!G19","v":0},{"$f":"'Receipt Totals'!G11","v":0},0,{"$f":"'Receipt Totals'!H11","v":0},null," "]
[null,null,11,"Foundation Labor",null,{"$f":"'CBD Builder Breakout'!F20+'CBD Builder Breakout'!G20","v":0},{"$f":"'Receipt Totals'!G12","v":0},0,{"$f":"'Receipt Totals'!H12","v":0}]
[null,null,12,"Foundation Concrete",null,{"$f":"'CBD Builder Breakout'!F21+'CBD Builder Breakout'!G21","v":0},{"$f":"'Receipt Totals'!G13","v":0},0,{"$f":"'Receipt Totals'!H13","v":0}]
[null,null,13,"Steps / Walks / Driveway",null,{"$f":"'CBD Builder Breakout'!F22+'CBD Builder Breakout'!G22","v":0},{"$f":"'Receipt Totals'!G14","v":0},0,{"$f":"'Receipt Totals'!H14","v":0}]
[null,null,14,"Garage/Basement Concrete",null,{"$f":"'CBD Builder Breakout'!F23+'CBD Builder Breakout'!G23","v":0},{"$f":"'Receipt Totals'!G15","v":0},0,{"$f":"'Receipt Totals'!H15","v":0}]
[null,null,15,"Chimney / Fireplace",null,{"$f":"'CBD Builder Breakout'!F24+'CBD Builder Breakout'!G24","v":0},{"$f":"'Receipt Totals'!G16","v":0},0,{"$f":"'Receipt Totals'!H16","v":0}]
[null,null,16,"Masonry",null,{"$f":"'CBD Builder Breakout'!F25+'CBD Builder Breakout'!G25","v":0},{"$f":"'Receipt Totals'!G17","v":0},0,{"$f":"'Receipt Totals'!H17","v":0}]
[null,null,17,"Framing Lumber",null,{"$f":"'CBD Builder Breakout'!F26+'CBD Builder Breakout'!G26","v":0},{"$f":"'Receipt Totals'!G18","v":0},0,{"$f":"'Receipt Totals'!H18","v":0}]
[null,null,18,"Siding",null,{"$f":"'CBD Builder Breakout'!F27+'CBD Builder Breakout'!G27","v":0},{"$f":"'Receipt Totals'!G19","v":0},0,{"$f":"'Receipt Totals'!H19","v":0}]
[null,null,19,"Framing Labor",null,{"$f":"'CBD Builder Breakout'!F28+'CBD Builder Breakout'!G28","v":0},{"$f":"'Receipt Totals'!G20","v":0},0,{"$f":"'Receipt Totals'!H20","v":0}]
[null,null,20,"Rough Plumbing",null,{"$f":"'CBD Builder Breakout'!F29+'CBD Builder Breakout'!G29","v":0},{"$f":"'Receipt Totals'!G21","v":0},0,{"$f":"'Receipt Totals'!H21","v":0}]
[null,null,21,"Electrical Wiring ",null,{"$f":"'CBD Builder Breakout'!F30+'CBD Builder Breakout'!G30","v":0},{"$f":"'Receipt Totals'!G22","v":0},0,{"$f":"'Receipt Totals'!H22","v":0}]
[null,null,22,"Finish Plumbing",null,{"$f":"'CBD Builder Breakout'!F31+'CBD Builder Breakout'!G31","v":0},{"$f":"'Receipt Totals'!G23","v":0},0,{"$f":"'Receipt Totals'!H23","v":0}]
[null,null,23,"Sewer / Septic ",null,{"$f":"'CBD Builder Breakout'!F32+'CBD Builder Breakout'!G32","v":0},{"$f":"'Receipt Totals'!G24","v":0},0,{"$f":"'Receipt Totals'!H24","v":0}]
[null,null,24,"Gutters / Downspouts",null,{"$f":"'CBD Builder Breakout'!F33+'CBD Builder Breakout'!G33","v":0},{"$f":"'Receipt Totals'!G25","v":0},0,{"$f":"'Receipt Totals'!H25","v":0}]
[null,null,25,"Water Line Install",null,{"$f":"'CBD Builder Breakout'!F34+'CBD Builder Breakout'!G34","v":0},{"$f":"'Receipt Totals'!G26","v":0},0,{"$f":"'Receipt Totals'!H26","v":0}]
[null,null,26,"Insulation ",null,{"$f":"'CBD Builder Breakout'!F35+'CBD Builder Breakout'!G35","v":0},{"$f":"'Receipt Totals'!G27","v":0},0,{"$f":"'Receipt Totals'!H27","v":0}]
[null,null,27,"Roof Trusses",null,{"$f":"'CBD Builder Breakout'!F36+'CBD Builder Breakout'!G36","v":0},{"$f":"'Receipt Totals'!G28","v":0},0,{"$f":"'Receipt Totals'!H28","v":0}]
[null,null,28,"Roofing",null,{"$f":"'CBD Builder Breakout'!F37+'CBD Builder Breakout'!G37","v":0},{"$f":"'Receipt Totals'!G29","v":0},0,{"$f":"'Receipt Totals'!H29","v":0}]
[null,null,29,"Drywall",null,{"$f":"'CBD Builder Breakout'!F38+'CBD Builder Breakout'!G38","v":0},{"$f":"'Receipt Totals'!G30","v":0},0,{"$f":"'Receipt Totals'!H30","v":0}]
[null,null,31,"Lighting Fixtures",null,{"$f":"'CBD Builder Breakout'!F39+'CBD Builder Breakout'!G39","v":0},{"$f":"'Receipt Totals'!G31","v":0},0,{"$f":"'Receipt Totals'!H31","v":0}]
[null,null,32,"Heating",null,{"$f":"'CBD Builder Breakout'!F40+'CBD Builder Breakout'!G40","v":0},{"$f":"'Receipt Totals'!G32","v":0},0,{"$f":"'Receipt Totals'!H32","v":0}]
[null,null,33,"Windows & Screens",null,{"$f":"'CBD Builder Breakout'!F41+'CBD Builder Breakout'!G41","v":0},{"$f":"'Receipt Totals'!G33","v":0},0,{"$f":"'Receipt Totals'!H33","v":0}]
[null,null,34,"Exterior Doors/Trim ",null,{"$f":"'CBD Builder Breakout'!F42+'CBD Builder Breakout'!G42","v":0},{"$f":"'Receipt Totals'!G34","v":0},0,{"$f":"'Receipt Totals'!H34","v":0}]
[null,null,35,"Interior Doors/Trim",null,{"$f":"'CBD Builder Breakout'!F43+'CBD Builder Breakout'!G43","v":0},{"$f":"'Receipt Totals'!G35","v":0},0,{"$f":"'Receipt Totals'!H35","v":0}]
[null,null,36,"Finish Labor ",null,{"$f":"'CBD Builder Breakout'!F44+'CBD Builder Breakout'!G44","v":0},{"$f":"'Receipt Totals'!G36","v":0},0,{"$f":"'Receipt Totals'!H36","v":0}]
[null,null,37,"Garage Doors/Openers",null,{"$f":"'CBD Builder Breakout'!F45+'CBD Builder Breakout'!G45","v":0},{"$f":"'Receipt Totals'!G37","v":0},0,{"$f":"'Receipt Totals'!H37","v":0}]
[null,null,38,"Cabinets",null,{"$f":"'CBD Builder Breakout'!F46+'CBD Builder Breakout'!G46","v":0},{"$f":"'Receipt Totals'!G38","v":0},0,{"$f":"'Receipt Totals'!H38","v":0}]
[null,null,39,"Exterior Painting",null,{"$f":"'CBD Builder Breakout'!F47+'CBD Builder Breakout'!G47","v":0},{"$f":"'Receipt Totals'!G39","v":0},0,{"$f":"'Receipt Totals'!H39","v":0}]
[null,null,40,"Staircase",null,{"$f":"'CBD Builder Breakout'!F48+'CBD Builder Breakout'!G48","v":0},{"$f":"'Receipt Totals'!G40","v":0},0,{"$f":"'Receipt Totals'!H40","v":0}]
[null,null,41,"Hardwood Floors/Tile",null,{"$f":"'CBD Builder Breakout'!F49+'CBD Builder Breakout'!G49","v":0},{"$f":"'Receipt Totals'!G41","v":0},0,{"$f":"'Receipt Totals'!H41","v":0}]
[null,null,42,"Carpet / Vinyl / Countertops",null,{"$f":"'CBD Builder Breakout'!F50+'CBD Builder Breakout'!G50","v":0},{"$f":"'Receipt Totals'!G42","v":0},0,{"$f":"'Receipt Totals'!H42","v":0}]
[null,null,43,"Misc. Hardware ",null,{"$f":"'CBD Builder Breakout'!F51+'CBD Builder Breakout'!G51","v":0},{"$f":"'Receipt Totals'!G43","v":0},0,{"$f":"'Receipt Totals'!H43","v":0}]
[" ",null,44,"Mirrors / Shower Doors",null,{"$f":"'CBD Builder Breakout'!F52+'CBD Builder Breakout'!G52","v":0},{"$f":"'Receipt Totals'!G44","v":0},0,{"$f":"'Receipt Totals'!H44","v":0}]
[null,null,45,"Appliances",null,{"$f":"'CBD Builder Breakout'!F53+'CBD Builder Breakout'!G53","v":0},{"$f":"'Receipt Totals'!G45","v":0},0,{"$f":"'Receipt Totals'!H45","v":0}]
[null,null,46,"Safety Equipment / Vacuum Stystem ",null,{"$f":"'CBD Builder Breakout'!F54+'CBD Builder Breakout'!G54","v":0},{"$f":"'Receipt Totals'!G46","v":0},0,{"$f":"'Receipt Totals'!H46","v":0}]
[null,null,47,"Insurance / Cleaning",null,{"$f":"'CBD Builder Breakout'!F55+'CBD Builder Breakout'!G55","v":0},{"$f":"'Receipt Totals'!G47","v":0},0,{"$f":"'Receipt Totals'!H47","v":0}]
[null,null,48,"Decks",null,{"$f":"'CBD Builder Breakout'!F56+'CBD Builder Breakout'!G56","v":0},{"$f":"'Receipt Totals'!G48","v":0},0,{"$f":"'Receipt Totals'!H48","v":0}]
[null,null,49,"Landscaping",null,{"$f":"'CBD Builder Breakout'!F57+'CBD Builder Breakout'!G57","v":0},{"$f":"'Receipt Totals'!G49","v":0},0,{"$f":"'Receipt Totals'!H49","v":0}]
[null,null,50,"Required Inspection Costs ",null,{"$f":"'CBD Builder Breakout'!F58+'CBD Builder Breakout'!G58","v":2100},{"$f":"'Receipt Totals'!G50","v":0},{"$f":"F58-G58","v":2100},{"$f":"'Receipt Totals'!H50","v":0}]
[null,null,52,"Profit / Overhead",null,{"$f":"'CBD Builder Breakout'!F59+'CBD Builder Breakout'!G59","v":0},{"$f":"'Receipt Totals'!G51","v":0},0,{"$f":"'Receipt Totals'!H51","v":0}]
[null,null,53,"Taxes",null,{"$f":"'CBD Builder Breakout'!F60+'CBD Builder Breakout'!G60","v":0},{"$f":"'Receipt Totals'!G52","v":0},0,{"$f":"'Receipt Totals'!H52","v":0}]
[null,null,54,"Cusion/Contingency (Min. 5%)",{"$f":"SUM(F61/I61)","v":{"$error":"#DIV/0!"}},{"$f":"'CBD Builder Breakout'!F61","v":0},{"$f":"'Receipt Totals'!G53","v":0},{"$f":"F61","v":0},{"$f":"SUM(H14:H57,H59:H60,H62:H88)","v":0}]
[null,null,55,"Log Set Up Labor",null,{"$f":"'CBD Builder Breakout'!F62+'CBD Builder Breakout'!G62","v":0},{"$f":"'Receipt Totals'!G54","v":0},0,{"$f":"'Receipt Totals'!H54","v":0}]
[null,null,56,"Log Delivery",null,{"$f":"'CBD Builder Breakout'!F63+'CBD Builder Breakout'!G63","v":0},{"$f":"'Receipt Totals'!G55","v":0},0,{"$f":"'Receipt Totals'!H55","v":0}]
[null,null,57,"Utility Fees",null,{"$f":"'CBD Builder Breakout'!F64+'CBD Builder Breakout'!G64","v":0},{"$f":"'Receipt Totals'!G56","v":0},0,{"$f":"'Receipt Totals'!H56","v":0}]
[null,null,58,"Demolition ",null,{"$f":"'CBD Builder Breakout'!F65+'CBD Builder Breakout'!G65","v":0},{"$f":"'Receipt Totals'!G57","v":0},0,{"$f":"'Receipt Totals'!H57","v":0}]
[null,null,60,"Interior Painting",null,{"$f":"'CBD Builder Breakout'!F66+'CBD Builder Breakout'!G66","v":0},{"$f":"'Receipt Totals'!G58","v":0},0,{"$f":"'Receipt Totals'!H58","v":0}]
[null,null,61,"Portable Toilet ",null,{"$f":"'CBD Builder Breakout'!F67+'CBD Builder Breakout'!G67","v":0},{"$f":"'Receipt Totals'!G59","v":0},0,{"$f":"'Receipt Totals'!H59","v":0}]
[{"$f":"ISBLANK(D68)","v":false},null,{"$f":"'CBD Builder Breakout'!C68","v":"62"},{"$f":"'CBD Builder Breakout'!D68:E68","v":"Fire Supression System"},null,{"$f":"'CBD Builder Breakout'!F68+'CBD Builder Breakout'!G68","v":0},{"$f":"'Receipt Totals'!G60","v":0},0,{"$f":"'Receipt Totals'!H60","v":0}]
[{"$f":"ISBLANK(D69)","v":false},null,{"$f":"'CBD Builder Breakout'!C69","v":"TBD"},{"$f":"'CBD Builder Breakout'!D69:E69","v":0},null,{"$f":"'CBD Builder Breakout'!F69+'CBD Builder Breakout'!G69","v":0},{"$f":"'Receipt Totals'!G61","v":0},0,{"$f":"'Receipt Totals'!H61","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C70","v":"TBD"},{"$f":"'CBD Builder Breakout'!D70:E70","v":0},null,{"$f":"'CBD Builder Breakout'!F70+'CBD Builder Breakout'!G70","v":0},{"$f":"'Receipt Totals'!G62","v":0},0,{"$f":"'Receipt Totals'!H62","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C71","v":"65"},{"$f":"'CBD Builder Breakout'!D71:E71","v":"Cost for addition"},null,{"$f":"'CBD Builder Breakout'!F71+'CBD Builder Breakout'!G71","v":0},{"$f":"'Receipt Totals'!G63","v":0},0,{"$f":"'Receipt Totals'!H63","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C72","v":"TBD"},{"$f":"'CBD Builder Breakout'!D72:E72","v":0},null,{"$f":"'CBD Builder Breakout'!F72+'CBD Builder Breakout'!G72","v":0},{"$f":"'Receipt Totals'!G64","v":0},0,{"$f":"'Receipt Totals'!H64","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C73","v":"TBD"},{"$f":"'CBD Builder Breakout'!D73:E73","v":0},null,{"$f":"'CBD Builder Breakout'!F73+'CBD Builder Breakout'!G73","v":0},{"$f":"'Receipt Totals'!G65","v":0},0,{"$f":"'Receipt Totals'!H65","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C74","v":"TBD"},{"$f":"'CBD Builder Breakout'!D74:E74","v":0},null,{"$f":"'CBD Builder Breakout'!F74+'CBD Builder Breakout'!G74","v":0},{"$f":"'Receipt Totals'!G66","v":0},0,{"$f":"'Receipt Totals'!H66","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C75","v":"TBD"},{"$f":"'CBD Builder Breakout'!D75:E75","v":0},null,{"$f":"'CBD Builder Breakout'!F75+'CBD Builder Breakout'!G75","v":0},{"$f":"'Receipt Totals'!G67","v":0},0,{"$f":"'Receipt Totals'!H67","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C76","v":"TBD"},{"$f":"'CBD Builder Breakout'!D76:E76","v":0},null,{"$f":"'CBD Builder Breakout'!F76+'CBD Builder Breakout'!G76","v":0},{"$f":"'Receipt Totals'!G68","v":0},0,{"$f":"'Receipt Totals'!H68","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C77","v":"TBD"},{"$f":"'CBD Builder Breakout'!D77:E77","v":0},null,{"$f":"'CBD Builder Breakout'!F77+'CBD Builder Breakout'!G77","v":0},{"$f":"'Receipt Totals'!G69","v":0},0,{"$f":"'Receipt Totals'!H69","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C78","v":"TBD"},{"$f":"'CBD Builder Breakout'!D78:E78","v":0},null,{"$f":"'CBD Builder Breakout'!F78+'CBD Builder Breakout'!G78","v":0},{"$f":"'Receipt Totals'!G70","v":0},0,{"$f":"'Receipt Totals'!H70","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C79","v":"TBD"},{"$f":"'CBD Builder Breakout'!D79:E79","v":0},null,{"$f":"'CBD Builder Breakout'!F79+'CBD Builder Breakout'!G79","v":0},{"$f":"'Receipt Totals'!G71","v":0},0,{"$f":"'Receipt Totals'!H71","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C80","v":"TBD"},{"$f":"'CBD Builder Breakout'!D80:E80","v":0},null,{"$f":"'CBD Builder Breakout'!F80+'CBD Builder Breakout'!G80","v":0},{"$f":"'Receipt Totals'!G72","v":0},0,{"$f":"'Receipt Totals'!H72","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C81","v":"TBD"},{"$f":"'CBD Builder Breakout'!D81:E81","v":0},null,{"$f":"'CBD Builder Breakout'!F81+'CBD Builder Breakout'!G81","v":0},null,0,{"$f":"'Receipt Totals'!H73","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C82","v":"TBD"},{"$f":"'CBD Builder Breakout'!D82:E82","v":0},null,{"$f":"'CBD Builder Breakout'!F82+'CBD Builder Breakout'!G82","v":0},null,0,{"$f":"'Receipt Totals'!H74","v":" "}]
[false,null,{"$f":"'CBD Builder Breakout'!C83","v":"TBD"},{"$f":"'CBD Builder Breakout'!D83:E83","v":0},null,{"$f":"'CBD Builder Breakout'!F83+'CBD Builder Breakout'!G83","v":0},null,0,{"$f":"'Receipt Totals'!H75","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C84","v":"TBD"},{"$f":"'CBD Builder Breakout'!D84:E84","v":0},null,{"$f":"'CBD Builder Breakout'!F84+'CBD Builder Breakout'!G84","v":0},null,0,{"$f":"'Receipt Totals'!H76","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C85","v":"TBD"},{"$f":"'CBD Builder Breakout'!D85:E85","v":0},null,{"$f":"'CBD Builder Breakout'!F85+'CBD Builder Breakout'!G85","v":0},null,0,{"$f":"'Receipt Totals'!H77","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C86","v":"TBD"},{"$f":"'CBD Builder Breakout'!D86:E86","v":0},null,{"$f":"'CBD Builder Breakout'!F86+'CBD Builder Breakout'!G86","v":0},null,0,{"$f":"'Receipt Totals'!H78","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C87","v":"TBD"},{"$f":"'CBD Builder Breakout'!D87:E87","v":0},null,{"$f":"'CBD Builder Breakout'!F87+'CBD Builder Breakout'!G87","v":0},null,0,{"$f":"'Receipt Totals'!H79","v":0}]
[false,null,{"$f":"'CBD Builder Breakout'!C88","v":"TBD"},{"$f":"'CBD Builder Breakout'!D88:E88","v":0},null,{"$f":"'CBD Builder Breakout'!F88+'CBD Builder Breakout'!G88","v":0},null,0,{"$f":"'Receipt Totals'!H80","v":0}]
[null,null,"SUBTOTAL-COST TO COMPLETE:",null,null,{"$f":"SUM(F13:F88)","v":2100},{"$f":"SUM(G13:G88)","v":0},{"$f":"SUM(H13:H88)","v":2100}]
[null,null,9998,"INTEREST EXPENSE",null,{"$f":"'CBD Builder Breakout'!F90","v":0},null,0]
[null,null,4,"CLOSING COSTS",null,{"$f":"'CBD Builder Breakout'!F91","v":0},null,0]
[null,null,"FINAL REQUESTED TOTALS:",null,null,{"$f":"SUM(F89:F91)","v":2100},{"$f":"SUM(G89:G91)","v":0},{"$f":"SUM(H89:H91)","v":2100}]
[null,null,"LOAN AMOUNT REQUEST:"]
[null,null,"ESTIMATED CASH NEEDED TO CLOSE:",null,null,{"$f":"H92-F93","v":2100}]
[null,null,"Construction Funds Available (for CDD use only):",null,null,{"$f":"H89-H13+H90","v":2100}]
[null,null,"Loan to Cost of Construction Ratio:",null,null,{"$f":"F93/F89","v":0}]
[null,null,"**Lot Cost: \nIf Land is being purchased or owned LESS than one year - Construction Budget will equal purchase price or appraised value, whichever is less. \n\nIf Land has been owned MORE than one year - Construction Budget will reflect the appraised value AND any land payoffs (if applicable) will need to be accounted for in the \"Financed Budget\" column. \n\nRemodel Loans Require a Completed Scope of Work Sheet"]
[null," ","For Detached Structures - Utilize the Following Letters to indicate what type of building is being constructed: \nA - Additional Dwelling Unit (ADU)          G - Garage          S - Shop"]
[]
[]
[null,null,"Borrower:",null,null,"Borrower:",null,null,null,null," "]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Borrower:",null,null,"Borrower:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Contractor:",null,null,"Contractor:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[]
[null,null,"Loan Officer and Branch:",null,null,"Loan Officer:"]
[null,null,null,"PRINT HERE",null,null,"SIGN HERE"]
[null,null,null,null,null,null,"Rev. 2/2025"]

{"sheet":"Built Import File","index":5,"n_rows":60,"n_cols":11,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["IMPORTFILE","Name","Description","Type","Budget Amount ","% Weight","Phase","%Complete","Funded Amount","Remaining Amount","Prepaid Amount"]
["FORMAT","Cannot exceed 255 characters","Cannot Exceed 255 characters","Must contain a valid item type: hard, land, soft, closing, contingency_reserve, interest_reserve, custom_fee, inspection_fee, general_fee","Must contain a valid amount","Must contain a valid number 0-100","Cannot exceed 255 characters","Must contain a valid amount.","Cannot be greater than budget amount","Must contain a valid amount","Must contain a valid amount"]
["VERSION:1.1","REQUIRED",null,"REQUIRED","REQUIRED"]
[null,"Lot Cost ",null,"Land",{"$f":"'Appraisal CBD'!H13","v":0},null,"Land"]
[null,"Plans & Specs ",null,"Soft",0,null,"Soft"]
[null,"Permits",null,"Soft",{"$f":"'Appraisal CBD'!H15","v":0},null,"Cost to Construct"]
[null,"Water Hookup & Shares",null,"Soft",{"$f":"'Appraisal CBD'!H16","v":0},null,"Cost to Construct"]
[null,"Temp Power Hookup ",null,"Soft",{"$f":"'Appraisal CBD'!H17","v":0},null,"Cost to Construct"]
[null,"Excavation/Grade/Fill ",null,"Hard",{"$f":"'Appraisal CBD'!H18","v":0},null,"Cost to Construct"]
[null,"Surveying & Engineering",null,"Soft",{"$f":"'Appraisal CBD'!H19","v":0},null,"Cost to Construct"]
[null,"Foundation Labor",null,"Hard",{"$f":"'Appraisal CBD'!H20","v":0},null,"Cost to Construct"]
[null,"Foundation Concrete",null,"Hard",{"$f":"'Appraisal CBD'!H21","v":0},null,"Cost to Construct"]
[null,"Steps / Walks / Driveway",null,"Hard",{"$f":"'Appraisal CBD'!H22","v":0},null,"Cost to Construct"]
[null,"Garage/Basement Concrete",null,"Hard",{"$f":"'Appraisal CBD'!H23","v":0},null,"Cost to Construct"]
[null,"Chimney / Fireplace",null,"Hard",{"$f":"'Appraisal CBD'!H24","v":0},null,"Cost to Construct"]
[null,"Masonry",null,"Hard",{"$f":"'Appraisal CBD'!H25","v":0},null,"Cost to Construct"]
[null,"Framing Lumber",null,"Hard",{"$f":"'Appraisal CBD'!H26","v":0},null,"Cost to Construct"]
[null,"Siding",null,"Hard",{"$f":"'Appraisal CBD'!H27","v":0},null,"Cost to Construct"]
[null,"Framing Labor",null,"Hard",{"$f":"'Appraisal CBD'!H28","v":0},null,"Cost to Construct"]
[null,"Rough Plumbing",null,"Hard",{"$f":"'Appraisal CBD'!H29","v":0},null,"Cost to Construct"]
[null,"Electrical Wiring ",null,"Hard",{"$f":"'Appraisal CBD'!H30","v":0},null,"Cost to Construct"]
[null,"Finish Plumbing",null,"Hard",{"$f":"'Appraisal CBD'!H31","v":0},null,"Cost to Construct"]
[null,"Sewer / Septic ",null,"Hard",{"$f":"'Appraisal CBD'!H32","v":0},null,"Cost to Construct"]
[null,"Gutters / Downspouts",null,"Hard",{"$f":"'Appraisal CBD'!H33","v":0},null,"Cost to Construct"]
[null,"Water Line Install",null,"Hard",{"$f":"'Appraisal CBD'!H34","v":0},null,"Cost to Construct"]
[null,"Insulation ",null,"Hard",{"$f":"'Appraisal CBD'!H35","v":0},null,"Cost to Construct"]
[null,"Roof Trusses",null,"Hard",{"$f":"'Appraisal CBD'!H36","v":0},null,"Cost to Construct"]
[null,"Roofing",null,"Hard",{"$f":"'Appraisal CBD'!H37","v":0},null,"Cost to Construct"]
[null,"Drywall",null,"Hard",{"$f":"'Appraisal CBD'!H38","v":0},null,"Cost to Construct"]
[null,"Lighting Fixtures",null,"Hard",{"$f":"'Appraisal CBD'!H39","v":0},null,"Cost to Construct"]
[null,"Heating",null,"Hard",{"$f":"'Appraisal CBD'!H40","v":0},null,"Cost to Construct"]
[null,"Windows & Screens",null,"Hard",{"$f":"'Appraisal CBD'!H41","v":0},null,"Cost to Construct"]
[null,"Exterior Doors/Trim ",null,"Hard",{"$f":"'Appraisal CBD'!H42","v":0},null,"Cost to Construct"]
[null,"Interior Doors/Trim",null,"Hard",{"$f":"'Appraisal CBD'!H43","v":0},null,"Cost to Construct"]
[null,"Finish Labor ",null,"Hard",{"$f":"'Appraisal CBD'!H44","v":0},null,"Cost to Construct"]
[null,"Garage Doors/Openers",null,"Hard",{"$f":"'Appraisal CBD'!H45","v":0},null,"Cost to Construct"]
[null,"Cabinets",null,"Hard",{"$f":"'Appraisal CBD'!H46","v":0},null,"Cost to Construct"]
[null,"Exterior Painting",null,"Hard",{"$f":"'Appraisal CBD'!H47","v":0},null,"Cost to Construct"]
[null,"Staircase",null,"Hard",{"$f":"'Appraisal CBD'!H48","v":0},null,"Cost to Construct"]
[null,"Hardwood Floors/Tile",null,"Hard",{"$f":"'Appraisal CBD'!H49","v":0},null,"Cost to Construct"]
[null,"Carpet / Vinyl / Countertops",null,"Hard",{"$f":"'Appraisal CBD'!H50","v":0},null,"Cost to Construct"]
[null,"Misc. Hardware ",null,"Hard",{"$f":"'Appraisal CBD'!H51","v":0},null,"Cost to Construct"]
[null,"Mirrors / Shower Doors",null,"Hard",{"$f":"'Appraisal CBD'!H52","v":0},null,"Cost to Construct"]
[null,"Appliances",null,"Hard",{"$f":"'Appraisal CBD'!H53","v":0},null,"Cost to Construct"]
[null,"Safety Equipment / Vacuum Stystem ",null,"Hard",{"$f":"'Appraisal CBD'!H54","v":0},null,"Cost to Construct"]
[null,"Insurance / Cleaning",null,"Hard",{"$f":"'Appraisal CBD'!H55","v":0},null,"Cost to Construct"]
[null,"Decks",null,"Hard",{"$f":"'Appraisal CBD'!H56","v":0},null,"Cost to Construct"]
[null,"Landscaping",null,"Hard",{"$f":"'Appraisal CBD'!H57","v":0},null,"Cost to Construct"]
[null,"Required Inspection Costs ",null,"Hard",{"$f":"'Appraisal CBD'!H58","v":2100},null,"Cost to Construct"]
[null,"Profit / Overhead",null,"Hard",{"$f":"'Appraisal CBD'!H59","v":0},null,"Cost to Construct"]
[null,"Taxes",null,"Hard",{"$f":"'Appraisal CBD'!H60","v":0},null,"Cost to Construct"]
[null,"Cushion/Contingency",null,"Hard",{"$f":"'Appraisal CBD'!H61","v":0},null,"Cost to Construct"]
[null,"Log Set Up Labor",null,"Hard",{"$f":"'Appraisal CBD'!H62","v":0},null,"Cost to Construct"]
[null,"Log Delivery",null,"Soft",{"$f":"'Appraisal CBD'!H63","v":0},null,"Cost to Construct"]
[null,"Utility Fees",null,"Soft",{"$f":"'Appraisal CBD'!H64","v":0},null,"Cost to Construct"]
[null,"Demolition ",null,"Hard",{"$f":"'Appraisal CBD'!H65","v":0},null,"Cost to Construct"]
[null,"Interior Painting",null,"Hard",{"$f":"'Appraisal CBD'!H66","v":0},null,"Cost to Construct"]
[null,"Portable Toilet ",null,"Hard",{"$f":"'Appraisal CBD'!H67","v":0},null,"Cost to Construct"]
[null,{"$f":"'Appraisal CBD'!D90","v":"INTEREST EXPENSE"},null,"Soft",{"$f":"'Appraisal CBD'!F90","v":0},null,"Soft"]
[null,{"$f":"'Appraisal CBD'!D91","v":"CLOSING COSTS"},null,"Soft",{"$f":"'Appraisal CBD'!F91","v":0},null,"Soft"]