{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input Sheet","Summary Sheet","Rental Analysis","Math","Builder Finance","Western Union","MAN GROUP Auto","BF automated"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Input Sheet","index":0,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[]}
[]
["FOR OFFICE USE ONLY"]
["Franklin Street"]
["Duplexes Palm Coast"]
[null,"Inputs"]
[]
[null,"Single Family","Lot 2","Lot 3","Lot 4","Lot 5","Lot 6","Lot 7","Total"]
["Gross SF",2796]
["Square Feet (AC)",2400,0,0,null,null,null,0,{"$f":"SUM(B9:H9)/7","v":342.85714285714283}]
["Gross Sales Price",285000,0,0,0,0,0,0,{"$f":"SUM(B10:H10)","v":285000}]
["Marketing and Closing % (COGS)",0.06,{"$f":"B11","v":0.06},{"$f":"C11","v":0.06},{"$f":"D11","v":0.06},{"$f":"E11","v":0.06},{"$f":"F11","v":0.06},{"$f":"D11","v":0.06},{"$f":"SUM(B11:H11)/7","v":0.06}]
["COGS",{"$f":"B11*B10","v":17100},{"$f":"C11*C10","v":0},0,0,0,0,0,{"$f":"SUM(B12:H12)","v":17100}]
["Net Sales Proceeds",{"$f":"B10-B12","v":267900},{"$error":"#REF!"},{"$f":"D10-D12","v":0},0,0,0,0,{"$error":"#REF!"}]
["Costs"]
["Land / Purchase",27000,0,0,0,0,0,0,{"$f":"SUM(B15:H15)","v":27000}]
["Land Improvements",0]
["Vertical",163557]
["Inspections",750]
["Appraisal/Survey/Other",725]
["Legal (J RILEY WILLIAMS)",685]
["MS Closing Costs",{"$f":"750+650+30","v":1430}]
["Other: Survey's & Builders Risk",0,0,{"$f":"C22","v":0},0,0,0,0,0]
["Total Costs before Debt",{"$f":"SUM(B15:B22)","v":194147},0,0,0,0,0,0,27000]
[]
["Profit before Debt",{"$f":"B13-B23","v":73753},{"$error":"#REF!"},0,0,0,0,0,{"$error":"#REF!"}]
["Margin",{"$f":"B25/B13","v":0.2753004852556924},{"$error":"#REF!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,null,0.06,0.05,0.04]
["Debt  ",null,null,null,null,null,null,null,null,null,"Early Payoff",7,6,3]
["Months of Interest Reserve",12,{"$f":"B29","v":12},{"$f":"C29","v":12},{"$f":"D29","v":12},{"$f":"E29","v":12},{"$f":"F29","v":12},{"$f":"D29","v":12},{"$f":"SUM(B29:H29)/7","v":12},null,"Original cost",{"$f":"$B$37+$B$38","v":19609.424581005587},{"$f":"$B$37+$B$38","v":19609.424581005587},19609.424581005587]
["Interest Rate",6.7500000000000004E-2,{"$f":"B30","v":6.7500000000000004E-2},{"$f":"C30","v":6.7500000000000004E-2},{"$f":"D30","v":6.7500000000000004E-2},{"$f":"E30","v":6.7500000000000004E-2},{"$f":"F30","v":6.7500000000000004E-2},{"$f":"D30","v":6.7500000000000004E-2},6.7500000000000004E-2,null,"Actual cost",{"$f":"L37+L38","v":18558.919692737429},{"$f":"M37+M38","v":15640.850558659218},10621.771648044692]
["Points",3.7499999999999999E-2,{"$f":"B31","v":3.7499999999999999E-2},3.7499999999999999E-2,3.7499999999999999E-2,3.7499999999999999E-2,3.7499999999999999E-2,{"$f":"D31","v":3.7499999999999999E-2},3.7499999999999999E-2,null,"Total savings",{"$f":"($B$37+$B$38)-L30","v":1050.5048882681585},{"$f":"($B$37+$B$38)-M30","v":3968.574022346369},{"$f":"($B$37+$B$38)-N30","v":8987.6529329608948}]
["Total Factor ",{"$f":"B30/12*B29+B31","v":0.10500000000000001},0.10500000000000001,0.10500000000000001,0.10500000000000001,0.10500000000000001,0.10500000000000001,0.10500000000000001]
[null,null,null,null,null,null,null,null,null,null,"Interest Portion",{"$f":"L31-L34","v":1050.5048882681585},{"$f":"M31-M34","v":2101.0097765363134},5252.5244413407827]
["Borrower Equity",27000,null,null,null,null,null,null,null,null,"Points Portion",{"$f":"0","v":0},{"$f":"L38-M38","v":1867.5642458100556},{"$f":"(L38-N38)","v":3735.1284916201121}]
["Net Loan",{"$f":"B23-B34","v":167147},{"$f":"C23","v":0},0,0,0,0,0,{"$f":"SUM(B35:H35)","v":167147}]
["Loan with Interest & Points",{"$f":"B35/(1-B32)","v":186756.42458100559},null,null,null,null,null,null,null,null,"Total",{"$f":"$B$35+L37+L38","v":185705.91969273743},{"$f":"$B$35+M37+M38","v":182787.85055865924},177768.7716480447]
["Interest",{"$f":"B36*(B30/12*B29)","v":12606.058659217879},null,null,null,null,null,null,null,null,"Interest",{"$f":"($B$37/$B$29)*L28","v":7353.5342178770952},{"$f":"($B$37/$B$29)*M28","v":6303.0293296089385},{"$f":"($B$37/$B$29)*N28","v":3151.5146648044692}]
["Points",{"$f":"B36*B31","v":7003.3659217877093},null,null,null,null,null,null,null,null,"Points",{"$f":"$B$38*(L27/$B$31)","v":11205.385474860335},{"$f":"$B$38*(M27/$B$31)","v":9337.8212290502797},{"$f":"$B$38*(N27/$B$31)","v":7470.2569832402232}]
["Recording, Stamps, Intangible & Title",1.35E-2]
["Recording, Stamps, Intangible & Title",{"$f":"B36*B39","v":2521.2117318435753}]
["Loan, Interest, Points and Fees",{"$f":"+B40+B36","v":189277.63631284915}]
["Interest and Points (% of Sales)",{"$f":"(B37+B38)/B10","v":6.8804998529844161E-2},{"$f":"C35/SUM(1-SUM(C30/12*C29))-C35","v":0},0,0,0,0,0,{"$f":"SUM(C42:H42)","v":0}]
[null,null,{"$f":"#REF!-C35-C42","v":{"$error":"#REF!"}},{"$f":"#REF!-D35-D42","v":{"$error":"#REF!"}},{"$f":"#REF!-E35-E42","v":{"$error":"#REF!"}},{"$f":"#REF!-F35-F42","v":{"$error":"#REF!"}},{"$f":"#REF!-G35-G42","v":{"$error":"#REF!"}},{"$f":"#REF!-H35-H42","v":{"$error":"#REF!"}},{"$f":"SUM(B43:H43)","v":{"$error":"#REF!"}}]
[]
["Summary",null,{"$f":"C7","v":"Lot 2"},"Lot 3","Lot 4","Lot 5","Lot 6","Lot 7",{"$f":"D47","v":{"$error":"#REF!"}}]
["Loan before Interest & Points",{"$f":"B35","v":167147},{"$f":"C35","v":0},0,0,0,0,0,167147]
["Toal Loan after Interest, Points & Fees",{"$f":"B41","v":189277.63631284915},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"I35+#REF!","v":{"$error":"#REF!"}}]
["Margin to Net Sales",{"$f":"B47/B13","v":0.70652346514688003},{"$f":"#REF!/C13","v":{"$error":"#REF!"}},{"$f":"#REF!/D13","v":{"$error":"#REF!"}},{"$f":"#REF!/E13","v":{"$error":"#REF!"}},{"$f":"#REF!/F13","v":{"$error":"#REF!"}},{"$f":"#REF!/G13","v":{"$error":"#REF!"}},{"$f":"#REF!/H13","v":{"$error":"#REF!"}},{"$f":"#REF!/I10","v":{"$error":"#REF!"}}]
["Builder Equity",{"$f":"B23-B35","v":27000},{"$f":"C23-C35","v":0},{"$f":"D23-D35","v":0},null,null,null,{"$f":"H23-H35","v":0},{"$f":"SUM(B49:H49)","v":27000}]
["Equity as a Percent of Total Costs",{"$f":"B49/B23","v":0.13906988003935161},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},1]
["Mainsail LTV",{"$f":"B47/B10","v":0.66413205723806723},{"$f":"C47/C13","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"I47/I10","v":{"$error":"#REF!"}}]
["LTC",{"$f":"B46/(B23)","v":0.86093011996064839},null,null,null,null,null,null,null,"<=solve to 95% or less"]
[]
["Per Foot/Acre Data",{"$f":"B9","v":2400},{"$f":"C45","v":"Lot 2"},"Lot 3","Lot 4","Lot 5","Lot 6","Lot 7","Total"]
["Sales Price ",{"$f":"B10/B9","v":118.75},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B55:H55)/4","v":{"$error":"#DIV/0!"}}]
["Cost to Build (ex. Land)",{"$f":"B17/B54","v":68.148750000000007},{"$f":"#REF!/C9","v":{"$error":"#REF!"}},{"$f":"#REF!/D9","v":{"$error":"#REF!"}},{"$f":"#REF!/E9","v":{"$error":"#REF!"}},{"$f":"#REF!/F9","v":{"$error":"#REF!"}},{"$f":"#REF!/G9","v":{"$error":"#REF!"}},{"$f":"#REF!/H9","v":{"$error":"#REF!"}},{"$f":"SUM(B56:H56)/4","v":{"$error":"#REF!"}}]
["Cost to Build w/Land & Closing Costs",{"$f":"B23/B54","v":80.89458333333333}]
["Profit ",{"$f":"B55-B57","v":37.85541666666667},{"$f":"C23/C9","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(B58:H58)/4","v":{"$error":"#DIV/0!"}}]
[]
["MLS Market Data",{"$f":"B54","v":2400},{"$f":"C54","v":"Lot 2"},{"$f":"D54","v":"Lot 3"},null,null,null,{"$f":"H54","v":"Lot 7"}]
["Average Sales Price",385000]
["Average Price Per Foot",130]
["Average Size (S.F.)",2900]
["Percent of Asking Price",1]
["Average Days on Market",90]
["Number of houses sold last 360 days",45]

{"sheet":"Summary Sheet","index":1,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,"Five Mile"]
[null,"Builder",{"$f":"'Input Sheet'!A4","v":"Duplexes Palm Coast"},null,null,"Builder"]
[null,{"$f":"'Input Sheet'!A3","v":"Franklin Street"},null,null,null,{"$f":"B4","v":"Franklin Street"}]
[null,"Square Feet",{"$f":"'Input Sheet'!B8","v":2796},null,null,"Square Feet",{"$f":"C5","v":2796}]
[null,"Reserve Period",{"$f":"'Input Sheet'!B29","v":12},null,null,"Reserve Period",{"$f":"C6","v":12}]
[null,"Interest Rate",{"$f":"'Input Sheet'!B30","v":6.7500000000000004E-2},null,null,"Interest Rate",{"$f":"C7","v":6.7500000000000004E-2}]
[null,"Points",{"$f":"'Input Sheet'!B31","v":3.7499999999999999E-2},null,null,"Points",{"$f":"C8","v":3.7499999999999999E-2}]
[]
[]
[null,"Appraised Value",{"$f":"'Input Sheet'!B10","v":285000},null,null,"Appraised Value",{"$f":"C11","v":285000}]
[null,"Cost of sales %",{"$f":"'Input Sheet'!B11","v":0.06},null,null,"cost of sales %",{"$f":"C12","v":0.06}]
[null,"COGS",{"$f":"C11*-C12","v":-17100},null,null,"COGS",{"$f":"G11*-G12","v":-17100}]
[null,"Net Revenue",{"$f":"C11+C13","v":267900},null,null,"Net Revenue",{"$f":"G11+G13","v":267900}]
[]
[null,"Lot",{"$f":"'Input Sheet'!B15","v":27000},null,null,"  Purchase",{"$f":"C16","v":27000}]
[null,"Vertical",{"$f":"'Input Sheet'!B17","v":163557},null,null,"  Improvements",{"$f":"C17","v":163557}]
[null,"Sales",{"$f":"'Input Sheet'!B19","v":725},null,null,"  City and County ",0]
[null,"Legal MS",{"$f":"'Input Sheet'!B20","v":685},null,null,"Sales",{"$f":"C18","v":725}]
[null,"Closing Misc",{"$f":"'Input Sheet'!B21","v":1430},null,null,"Legal MS",685]
[null,"Recording/Stamps",{"$f":"'Input Sheet'!B40","v":2521.2117318435753},null,null,"Closing Misc",1430]
[null,"Interest",{"$f":"'Input Sheet'!B37","v":12606.058659217879},null,null,"Recording/Stamps",2521.2117318435753]
[null,"Points",{"$f":"'Input Sheet'!B38","v":7003.3659217877093},null,null,"Interest payments",12606.058659217879]
[null,"Total",{"$f":"SUM(C16:C23)","v":215527.63631284915},null,null,"Points",7003.3659217877093]
[null,null,null,null,null,"Total",{"$f":"SUM(G16:G24)","v":215527.63631284915}]
[null,"Profit",{"$f":"C14-C24","v":52372.36368715085}]
[null,null,null,null,null,"Profit",{"$f":"G14-G25","v":52372.36368715085}]
[null,null,null,null,null,"Profit Margin",{"$f":"G27/G14","v":0.19549221234472136}]
[null,"Borrower Cash at Closing",{"$f":"IF('Input Sheet'!B51<0.75,0,SUM('Input Sheet'!B51-0.75)*C11)","v":0},null,null,"monthly interest due",{"$f":"G23/12","v":1050.5048882681565}]
[null,"Borrower Equity",{"$f":"'Input Sheet'!B34","v":27000}]
[null,"Total Borrower Equity",{"$f":"C29+C30","v":27000},null,null,"Borrower Cash at Closing",{"$f":"C29","v":0}]
[null,"Total Loan (closing)",{"$f":"'Input Sheet'!B47-C29","v":189277.63631284915},null,null,"Total Borrower Equity",{"$f":"C31","v":27000}]
[null,"LTV",{"$f":"C32/C11","v":0.66413205723806723},null,null,"Total Loan (closing)",{"$f":"C32","v":189277.63631284915}]
[null,"LTC",{"$f":"'Input Sheet'!B46/'Input Sheet'!B23","v":0.86093011996064839},null,null,"LTV",{"$f":"G33/G11","v":0.66413205723806723}]
[null,null,null,null,null," LTC",{"$f":"(G33-G24)/(G25-G24)","v":0.87411537299341047}]
[null,"Vertical Cost PSF",{"$f":"C17/C5","v":58.496781115879827}]
[null,"Vertical and Land",{"$f":"C16+C17","v":190557},null,null,"Sales Price PSF",{"$f":"G11/G5","v":101.931330472103}]
[null,"Total Project with Financing",{"$f":"C24/C5","v":77.084276220618435},null,null,"Vertical Cost PSF",{"$f":"C36","v":58.496781115879827}]
[null,null,null,null,null,"Vertical and Land",{"$f":"C37","v":190557}]
[null,null,null,null,null,"Total Project w/ Financing",{"$f":"C38","v":77.084276220618435}]

{"sheet":"Rental Analysis","index":2,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"Gross Square Feet (AC)",{"$f":"'Input Sheet'!B8","v":2796}]
[null,"Square Feet (AC)",{"$f":"'Input Sheet'!B9","v":2400}]
[null,"Monthly Rent",{"$f":"0.009*'Input Sheet'!B10","v":2565}]
[null,"Rent PSF",{"$f":"C9/C7","v":0.91738197424892709}]
[]
[null,"Gross Rent",{"$f":"C9*12","v":30780}]
[null,"Less Vacancy",{"$f":"C9*-1","v":-2565}]
[null,"Net Revenue",{"$f":"C12+C13","v":28215}]
[]
[null,"Utilities",150]
[null,"Insurance",500]
[null,"Lawn",600]
[null,"General R&M",500]
[null,"Move-In/Out",250]
[null,"Property Taxes",0]
[null,"Other",0]
[null,"Leasing/Mgt",1080]
[null,"Total",{"$f":"SUM(C16:C23)","v":3080}]
[]
[null,"Net Cash Flow",{"$f":"C14-C24","v":25135}]
[]
[null,"Cap Rate",{"$f":"7%","v":7.0000000000000007E-2}]
[]
[null,"Indicative Value",{"$f":"C26/C28","v":359071.42857142852}]
[null,"Value per SQFT",{"$f":"C30/C7","v":128.4232577151032}]

{"sheet":"Math","index":3,"n_rows":59,"n_cols":7,"rows_kept":59,"cut":false,"hidden":false,"merged":[[31,3,31,4],[42,2,42,4],[11,0,11,3],[12,0,12,1],[12,3,12,4],[14,2,14,3],[18,0,18,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Loan Amount",null,null,null,{"$f":"'Input Sheet'!B47","v":189277.63631284915}]
["Note Rate (MAX)",null,9.2981177007668947E-2,null,null,{"$f":"E12*C13","v":17599.257405598215},"Annual"]
["Divide by ",null,12,"months =",{"$f":"F13/C14","v":1466.6047837998512},"per month"]
[null,12,"months x",null,{"$f":"E14","v":1466.6047837998512},"monthly =",{"$f":"B15*E15","v":17599.257405598215}]
[null,null,null,null,null,null,"Interest Reserve"]
[]
[]
["Mainsail Fees"]
[]
["Points",null,null,{"$f":"'Input Sheet'!B38","v":7003.3659217877093}]
["Inspection(s)",null,null,750," Gross Loan Amount",null,{"$f":"E12","v":189277.63631284915}]
["Processing",null,null,750]
["Underwriting",null,null,650," Less Interest Reserve",null,{"$f":"G15","v":17599.257405598215}]
["Wire",null,null,30]
["Interest on IR",null,null,{"$f":"F40","v":1636.3996680334567}," Net Loan Amount***",null,{"$f":"G22-G24","v":171678.37890725094}]
[]
[null,null,null,null,"Interest on IR",{"$f":"G28/E12","v":8.6454992777314672E-3},{"$f":"B40*D40","v":1636.3996680334567}]
["Total:",null,null,{"$f":"SUM(D21:D25)+D27+D26","v":10819.765589821167}]
[]
[]
[null,null,null,"Interest charged on Interest Reserve:"]
[]
[null,{"$f":"G26","v":171678.37890725094},"x",{"$f":"C13","v":9.2981177007668947E-2},"=",{"$f":"B34*D34","v":15962.857737564758}]
[]
[null,{"$f":"F13","v":17599.257405598215},"-",{"$f":"F34","v":15962.857737564758},"=",{"$f":"B36-D36","v":1636.3996680334567}]
[]
[null,{"$f":"F36","v":1636.3996680334567},"÷",{"$f":"C14","v":12},"=",{"$f":"B38/D38","v":136.36663900278805}]
[]
[null,{"$f":"F38","v":136.36663900278805},"x",{"$f":"B15","v":12},"=",{"$f":"B40*D40","v":1636.3996680334567}]
[]
[]
[null,null,"Effective Rate of Interest Result:"]
[]
[null,{"$f":"D29","v":10819.765589821167},"÷",{"$f":"G26","v":171678.37890725094},"=",{"$f":"B45/D45","v":6.3023460838167247E-2}]
[]
[null,{"$f":"F45/B49","v":6.3023460838167247E-2},"+",{"$f":"F47-B47","v":0.11677653916183277},"=",{"$f":"17.98%","v":0.17980000000000002}]
[null,null,null,"Note Rate",null,"ERI"]
["Term",1]
["in yrs","12 months"]
[]
[]
[]
[]
["Executive Team Signature for Closing"]
[]
[]
["x",null,null,null,null,"Date:"]
[null,"David C. Griggs"]

{"sheet":"Builder Finance","index":4,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"'Input Sheet'!A3","v":"Franklin Street"}]
[null,null,null,null,"Builder Finance",null,null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Total"]
[null,null,0.06,"Points",{"$f":"E9*C4","v":8532},null,null,"Disbursed",null,0,0.28000000000000003,0.17,0.33,0.22,"completed","closed"]
[null,null,{"$f":"8.75%","v":8.7499999999999994E-2},"Loan",13245.3]
[null,null,null,"LIP",115500,null,null,"Mainsail ",{"$f":"($E$11*$G$7)/12","v":355.5},355.5,355.5,355.5,355.5,355.5,355.5,355.5,{"$f":"SUM(I6:P6)","v":2844}]
[null,null,null,"Fees",2180,null,0.1,"Cost",{"$f":"E4+E5+(E10-E9)+E7+E8","v":26700.3},0,{"$f":"J8","v":15959.7},0,0,0,0,0]
[null,null,null,"Proccesing+A/L",2743,null,null,"Remaining",{"$f":"E11-I7","v":15959.7},{"$f":"I8-J7","v":15959.7},0,0,0,0,0,0]
[null,null,null,"TL interest and points",142200,null,null,"Builder Finance ",0,{"$f":"($E$6*J4)","v":0},{"$f":"(K10*$G$10)/12","v":136.50250000000003},{"$f":"((L10+K10)*$G$10)/12","v":300.12750000000005},{"$f":"((M10+L10+K10)*$G$10)/12","v":617.75250000000005},{"$f":"((N10+M10+L10+K10)*$G$10)/12","v":829.50250000000005},{"$f":"N9","v":829.50250000000005},{"$f":"O9","v":829.50250000000005},{"$f":"SUM(I9:P9)","v":3542.8900000000003}]
[null,null,null,"TL+ FEES(recording)",142200,null,0.1,"Cost",0,0,{"$f":"($E$6*K4)-K7","v":16380.300000000003},{"$f":"($E$6*L4)","v":19635},{"$f":"($E$6*M4)","v":38115},{"$f":"($E$6*N4)","v":25410}]
[null,null,null,"Mainsail",{"$f":"E10-E12","v":42660},null,null,"Remaining",0,{"$f":"$E$12-J10","v":99540},{"$f":"J11-K10","v":83159.7},{"$f":"K11-L10","v":63524.7},{"$f":"L11-M10","v":25409.699999999997},{"$f":"M11-N10","v":-0.30000000000291038}]
[null,null,null,"Builder finance ",{"$f":"E10*0.7","v":99540},null,null,"Total interest cost",{"$f":"I6+I9","v":355.5},{"$f":"J6+J9","v":355.5},{"$f":"K6+K9","v":492.00250000000005},655.62750000000005,973.25250000000005,1185.0025000000001,1185.0025000000001,1185.0025000000001,{"$f":"SUM(I12:P12)","v":6386.8900000000012}]
[null,null,null,null,null,null,null,"Total Project Draw",null,null,{"$f":"$E$6*K4","v":32340.000000000004},{"$f":"$E$6*L4","v":19635},38115,25410,{"$f":"SUM(K13:N13)","v":115500}]
[null,null,null,"ACV",200000,null,null,"Mainsail Inflow",0,{"$f":"$E$5/12","v":1103.7749999999999},1103.7749999999999,1103.7749999999999,1103.7749999999999,1103.7749999999999,1103.7749999999999,1103.7749999999999]
[null,null,null,"LTV",{"$f":"E10/E14","v":0.71099999999999997},null,null,"Net Intrest",{"$f":"I14-I12","v":-355.5},{"$f":"J14-J12","v":748.27499999999986},611.77249999999981,448.14749999999981,130.52249999999981,-81.227500000000191,-81.227500000000191,-81.227500000000191,{"$f":"SUM(I15:P15)","v":1339.5349999999987}]
[]
[null,null,null,"Builder Finance to Loan",{"$f":"E12/E6","v":0.86181818181818182},null,null,"Cost of Funds",{"$f":"(I12*12)/$E$10","v":0.03},{"$f":"(J12*12)/$E$10","v":0.03},4.1519198312236293E-2,5.5327215189873422E-2,8.213101265822785E-2,0.10000021097046415,0.10000021097046415,0.10000021097046415,{"$f":"AVERAGE(I17:P17)","v":6.7372257383966253E-2}]
[null,null,null,"LTV (Builder Finance)",{"$f":"E12/E14","v":0.49769999999999998}]
[null,null,null,null,null,null,null,"Builder interest*7",{"$f":"(E5/12)*7","v":7726.4249999999993}]
[null,null,null,null,null,null,null,"Points",{"$f":"E4","v":8532},null,null,"ONLY MAINSAIL",null,"FACTOR"]
[null,null,null,null,null,null,null,"Fees",{"$f":"E7","v":2180},null,null,{"$f":"I20+I19+I21-((E10*10%)/8)","v":16660.924999999999},null,{"$f":"L24/L21","v":2.4111376369159174}]
[null,null,null,null,null,null,null,"(Mainsail investor)",{"$f":"-Q6","v":-2844}]
[null,null,null,null,null,null,null,"(Builder Finance)",{"$f":"-Q9","v":-3542.8900000000003},"Return",null,"TOTAL ON SAME AMOUNT "]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I19:I23)","v":12051.535},{"$f":"I24/E11","v":0.28250199249882796},null,{"$f":"I24*(150/45)","v":40171.783333333333}]

{"sheet":"Western Union","index":5,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"'Input Sheet'!A3","v":"Franklin Street"}]
[null,null,null,null,"MAN FUND",null,null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Total"]
[null,null,{"$f":"'Input Sheet'!B31","v":3.7499999999999999E-2},"Points",{"$f":"'Input Sheet'!B38","v":7003.3659217877093},null,null,"Disbursed",null,0,0.28000000000000003,0.17,0.33,0.22,"completed","closed"]
[null,null,{"$f":"'Input Sheet'!B30","v":6.7500000000000004E-2},"Loan",{"$f":"'Input Sheet'!B37","v":12606.058659217879}]
[null,null,null,"LIP",{"$f":"'Input Sheet'!B17","v":163557},null,null,"Mainsail ",{"$f":"($E$11*$G$7)/12","v":552.05977257914344},552.05977257914344,552.05977257914344,552.05977257914344,552.05977257914344,552.05977257914344,552.05977257914344,552.05977257914344,{"$f":"SUM(I6:P6)","v":4416.4781806331475}]
[null,null,null,"Fees",2180,null,0.1,"Cost",{"$f":"E4+E5+(E10-E9)+E7+E8","v":25720.63631284915},0,{"$f":"J8","v":40526.536396648051},0,0,0,0,0]
[null,null,null,"Proccesing+A/L",{"$f":"1410","v":1410},null,null,"Remaining",{"$f":"E11-I7","v":40526.536396648051},{"$f":"I8-J7","v":40526.536396648051},0,0,0,0,0,0]
[null,null,null,"TL interest and points",{"$f":"'Input Sheet'!B36","v":186756.42458100559},null,null,"Builder Finance ",0,{"$f":"($E$6*J4)","v":0},{"$f":"(K10*$G$10)/12","v":21.955931680633146},{"$f":"((L10+K10)*$G$10)/12","v":137.80880668063318},{"$f":"((M10+L10+K10)*$G$10)/12","v":362.69968168063315},{"$f":"((N10+M10+L10+K10)*$G$10)/12","v":512.62693168063322},{"$f":"N9","v":512.62693168063322},{"$f":"O9","v":512.62693168063322},{"$f":"SUM(I9:P9)","v":2060.3452150837993}]
[null,null,null,"TL+ FEES(recording)",{"$f":"'Input Sheet'!B47","v":189277.63631284915},null,0.05,"Cost",0,0,{"$f":"($E$6*K4)-K7","v":5269.4236033519555},{"$f":"($E$6*L4)","v":27804.690000000002},{"$f":"($E$6*M4)","v":53973.810000000005},{"$f":"($E$6*N4)","v":35982.54}]
[null,null,null,"Mainsail",{"$f":"E10-E12","v":66247.172709497201},null,null,"Remaining",0,{"$f":"$E$12-J10","v":123030.46360335195},{"$f":"J11-K10","v":117761.04},{"$f":"K11-L10","v":89956.349999999991},{"$f":"L11-M10","v":35982.539999999986},{"$f":"M11-N10","v":0}]
[null,null,null,"Builder finance ",{"$f":"E10*0.65","v":123030.46360335195},null,null,"Total interest cost",{"$f":"I6+I9","v":552.05977257914344},{"$f":"J6+J9","v":552.05977257914344},{"$f":"K6+K9","v":574.01570425977661},689.86857925977665,914.75945425977659,1064.6867042597767,1064.6867042597767,1064.6867042597767,{"$f":"SUM(I12:P12)","v":6476.8233957169468}]
[null,null,null,null,null,null,null,"Total Project Draw",null,null,{"$f":"$E$6*K4","v":45795.960000000006},{"$f":"$E$6*L4","v":27804.690000000002},53973.810000000005,35982.54,{"$f":"SUM(K13:N13)","v":163557.00000000003}]
[null,null,null,"ACV",{"$f":"'Input Sheet'!B10","v":285000},null,null,"Mainsail Inflow",0,{"$f":"$E$5/12","v":1050.5048882681565},1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565]
[null,null,null,"LTV",{"$f":"E10/E14","v":0.66413205723806723},null,null,"Net Intrest",{"$f":"I14-I12","v":-552.05977257914344},{"$f":"J14-J12","v":498.44511568901305},476.48918400837988,360.63630900837984,135.7454340083799,-14.181815991620169,-14.181815991620169,-14.181815991620169,{"$f":"SUM(I15:P15)","v":876.71082216014872}]
[]
[null,null,null,"MAN FUND to Loan",{"$f":"E12/E6","v":0.75221765869606283},null,null,"Cost of Funds",{"$f":"(I12*12)/$E$10","v":3.5000000000000003E-2},{"$f":"(J12*12)/$E$10","v":3.5000000000000003E-2},3.6391982620345695E-2,4.3736931168319629E-2,5.799477246732785E-2,6.7500000000000004E-2,6.7500000000000004E-2,6.7500000000000004E-2,{"$f":"AVERAGE(I17:P17)","v":5.1327960781999152E-2}]
[null,null,null,"LTV (MAN FUND)",{"$f":"E12/E14","v":0.43168583720474368}]
[null,null,null,null,null,null,null,"Builder interest*7",{"$f":"(E5/12)*7","v":7353.5342178770952}]
[null,null,null,null,null,null,null,"Points",{"$f":"E4","v":7003.3659217877093},null,null,"ONLY MAINSAIL",null,"FACTOR"]
[null,null,null,null,null,null,null,"Fees",{"$f":"E7","v":2180},null,null,{"$f":"I20+I19+I21-((E10*10%)/8)","v":14170.92968575419},null,{"$f":"L24/L21","v":2.3663647968138357}]
[null,null,null,null,null,null,null,"(Mainsail investor)",{"$f":"-Q6","v":-4416.4781806331475}]
[null,null,null,null,null,null,null,"(Builder Finance)",{"$f":"-Q9","v":-2060.3452150837993},"Return",null,"TOTAL ON SAME AMOUNT "]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I19:I23)","v":10060.076743947859},{"$f":"I24/E11","v":0.15185669565194357},null,{"$f":"I24*(150/45)","v":33533.589146492865}]

{"sheet":"MAN GROUP Auto","index":6,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"'Input Sheet'!A3","v":"Franklin Street"}]
[null,null,null,null,"MAN FUND",null,null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Total"]
[null,null,{"$f":"'Input Sheet'!B31","v":3.7499999999999999E-2},"Points",{"$f":"'Input Sheet'!B38","v":7003.3659217877093},null,null,"Disbursed",null,0,0.28000000000000003,0.17,0.33,0.22,"completed","closed"]
[null,null,{"$f":"'Input Sheet'!B30","v":6.7500000000000004E-2},"Loan",{"$f":"'Input Sheet'!B37","v":12606.058659217879}]
[null,null,null,"LIP",{"$f":"'Input Sheet'!B17","v":163557},null,null,"Mainsail ",{"$f":"($E$11*$G$7)/12","v":394.32840898510239},394.32840898510239,394.32840898510239,394.32840898510239,394.32840898510239,394.32840898510239,394.32840898510239,394.32840898510239,{"$f":"SUM(I6:P6)","v":3154.6272718808186}]
[null,null,null,"Fees",2180,null,0.1,"Cost",{"$f":"E4+E5+(E10-E9)+E7+E8","v":25720.63631284915},0,{"$f":"J8","v":21598.77276536313},0,0,0,0,0]
[null,null,null,"Proccesing+A/L",{"$f":"1410","v":1410},null,null,"Remaining",{"$f":"E11-I7","v":21598.77276536313},{"$f":"I8-J7","v":21598.77276536313},0,0,0,0,0,0]
[null,null,null,"TL interest and points",{"$f":"'Input Sheet'!B36","v":186756.42458100559},null,null,"Builder Finance ",0,{"$f":"($E$6*J4)","v":0},{"$f":"(K10*$G$10)/12","v":100.82161347765366},{"$f":"((L10+K10)*$G$10)/12","v":216.67448847765368},{"$f":"((M10+L10+K10)*$G$10)/12","v":441.56536347765365},{"$f":"((N10+M10+L10+K10)*$G$10)/12","v":591.49261347765378},{"$f":"N9","v":591.49261347765378},{"$f":"O9","v":591.49261347765378},{"$f":"SUM(I9:P9)","v":2533.5393058659224}]
[null,null,null,"TL+ FEES(recording)",{"$f":"'Input Sheet'!B47","v":189277.63631284915},null,0.05,"Cost",0,0,{"$f":"($E$6*K4)-K7","v":24197.187234636876},{"$f":"($E$6*L4)","v":27804.690000000002},{"$f":"($E$6*M4)","v":53973.810000000005},{"$f":"($E$6*N4)","v":35982.54}]
[null,null,null,"Mainsail",{"$f":"E10-E12","v":47319.40907821228},null,null,"Remaining",0,{"$f":"$E$12-J10","v":141958.22723463687},{"$f":"J11-K10","v":117761.04},{"$f":"K11-L10","v":89956.349999999991},{"$f":"L11-M10","v":35982.539999999986},{"$f":"M11-N10","v":0}]
[null,null,null,"Builder finance ",{"$f":"E10*0.75","v":141958.22723463687},null,null,"Total interest cost",{"$f":"I6+I9","v":394.32840898510239},{"$f":"J6+J9","v":394.32840898510239},{"$f":"K6+K9","v":495.15002246275606},611.0028974627561,835.89377246275603,985.82102246275622,985.82102246275622,985.82102246275622,{"$f":"SUM(I12:P12)","v":5688.1665777467424}]
[null,null,null,null,null,null,null,"Total Project Draw",null,null,{"$f":"$E$6*K4","v":45795.960000000006},{"$f":"$E$6*L4","v":27804.690000000002},53973.810000000005,35982.54,{"$f":"SUM(K13:N13)","v":163557.00000000003}]
[null,null,null,"ACV",{"$f":"'Input Sheet'!B10","v":285000},null,null,"Mainsail Inflow",0,{"$f":"$E$5/12","v":1050.5048882681565},1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565]
[null,null,null,"LTV",{"$f":"E10/E14","v":0.66413205723806723},null,null,"Net Intrest",{"$f":"I14-I12","v":-394.32840898510239},{"$f":"J14-J12","v":656.17647928305405},555.35486580540044,439.5019908054004,214.61111580540046,64.683865805400274,64.683865805400274,64.683865805400274,{"$f":"SUM(I15:P15)","v":1665.3676401303537}]
[]
[null,null,null,"MAN FUND to Loan",{"$f":"E12/E6","v":0.86794345234161097},null,null,"Cost of Funds",{"$f":"(I12*12)/$E$10","v":2.4999999999999998E-2},{"$f":"(J12*12)/$E$10","v":2.4999999999999998E-2},3.139198262034569E-2,3.8736931168319624E-2,5.2994772467327853E-2,6.2500000000000014E-2,6.2500000000000014E-2,6.2500000000000014E-2,{"$f":"AVERAGE(I17:P17)","v":4.5077960781999146E-2}]
[null,null,null,"LTV (MAN FUND)",{"$f":"E12/E14","v":0.4980990429285504}]
[null,null,null,null,null,null,null,"Builder interest*7",{"$f":"(E5/12)*7","v":7353.5342178770952}]
[null,null,null,null,null,null,null,"Points",{"$f":"E4","v":7003.3659217877093},null,null,"ONLY MAINSAIL",null,"FACTOR"]
[null,null,null,null,null,null,null,"Fees",{"$f":"E7","v":2180},null,null,{"$f":"I20+I19+I21-((E10*10%)/8)","v":14170.92968575419},null,{"$f":"L24/L21","v":2.551875283295427}]
[null,null,null,null,null,null,null,"(Mainsail investor)",{"$f":"-Q6","v":-3154.6272718808186}]
[null,null,null,null,null,null,null,"(Builder Finance)",{"$f":"-Q9","v":-2533.5393058659224},"Return",null,"TOTAL ON SAME AMOUNT "]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I19:I23)","v":10848.733561918065},{"$f":"I24/E11","v":0.22926604057938774},null,{"$f":"I24*(150/45)","v":36162.445206393553}]

{"sheet":"BF automated","index":7,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,{"$f":"'Input Sheet'!A3","v":"Franklin Street"}]
[null,null,null,null,"Builder Finance",null,null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Total"]
[null,null,{"$f":"'Input Sheet'!B31","v":3.7499999999999999E-2},"Points",{"$f":"'Input Sheet'!B38","v":7003.3659217877093},null,null,"Disbursed",null,0,0.28000000000000003,0.17,0.33,0.22,"completed","closed"]
[null,null,{"$f":"'Input Sheet'!B30","v":6.7500000000000004E-2},"Loan",{"$f":"'Input Sheet'!B37","v":12606.058659217879}]
[null,null,null,"LIP",{"$f":"'Input Sheet'!B17","v":163557},null,null,"Mainsail ",{"$f":"($E$11*$G$7)/12","v":473.19409078212294},473.19409078212294,473.19409078212294,473.19409078212294,473.19409078212294,473.19409078212294,473.19409078212294,473.19409078212294,{"$f":"SUM(I6:P6)","v":3785.552726256984}]
[null,null,null,"Fees",2180,null,0.1,"Cost",{"$f":"E4+E5+(E10-E9)+E7+E8","v":25720.63631284915},0,{"$f":"J8","v":31062.654581005598},0,0,0,0,0]
[null,null,null,"Proccesing+A/L",{"$f":"1410","v":1410},null,null,"Remaining",{"$f":"E11-I7","v":31062.654581005598},{"$f":"I8-J7","v":31062.654581005598},0,0,0,0,0,0]
[null,null,null,"TL interest and points",{"$f":"'Input Sheet'!B36","v":186756.42458100559},null,null,"Builder Finance ",0,{"$f":"($E$6*J4)","v":0},{"$f":"(K10*$G$10)/12","v":122.77754515828674},{"$f":"((L10+K10)*$G$10)/12","v":354.48329515828681},{"$f":"((M10+L10+K10)*$G$10)/12","v":804.26504515828674},{"$f":"((N10+M10+L10+K10)*$G$10)/12","v":1104.1195451582869},{"$f":"N9","v":1104.1195451582869},{"$f":"O9","v":1104.1195451582869},{"$f":"SUM(I9:P9)","v":4593.8845209497213}]
[null,null,null,"TL+ FEES(recording)",{"$f":"'Input Sheet'!B47","v":189277.63631284915},null,0.1,"Cost",0,0,{"$f":"($E$6*K4)-K7","v":14733.305418994409},{"$f":"($E$6*L4)","v":27804.690000000002},{"$f":"($E$6*M4)","v":53973.810000000005},{"$f":"($E$6*N4)","v":35982.54}]
[null,null,null,"Mainsail",{"$f":"E10-E12","v":56783.290893854748},null,null,"Remaining",0,{"$f":"$E$12-J10","v":132494.3454189944},{"$f":"J11-K10","v":117761.04},{"$f":"K11-L10","v":89956.349999999991},{"$f":"L11-M10","v":35982.539999999986},{"$f":"M11-N10","v":0}]
[null,null,null,"Builder finance ",{"$f":"E10*0.7","v":132494.3454189944},null,null,"Total interest cost",{"$f":"I6+I9","v":473.19409078212294},{"$f":"J6+J9","v":473.19409078212294},{"$f":"K6+K9","v":595.97163594040967},827.67738594040975,1277.4591359404096,1577.3136359404098,1577.3136359404098,1577.3136359404098,{"$f":"SUM(I12:P12)","v":8379.4372472067043}]
[null,null,null,null,null,null,null,"Total Project Draw",null,null,{"$f":"$E$6*K4","v":45795.960000000006},{"$f":"$E$6*L4","v":27804.690000000002},53973.810000000005,35982.54,{"$f":"SUM(K13:N13)","v":163557.00000000003}]
[null,null,null,"ACV",{"$f":"'Input Sheet'!B10","v":285000},null,null,"Mainsail Inflow",0,{"$f":"$E$5/12","v":1050.5048882681565},1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565,1050.5048882681565]
[null,null,null,"LTV",{"$f":"E10/E14","v":0.66413205723806723},null,null,"Net Intrest",{"$f":"I14-I12","v":-473.19409078212294},{"$f":"J14-J12","v":577.31079748603361},454.53325232774682,222.82750232774674,-226.95424767225313,-526.80874767225328,-526.80874767225328,-526.80874767225328,{"$f":"SUM(I15:P15)","v":-1025.9030293296087}]
[]
[null,null,null,"Builder Finance to Loan",{"$f":"E12/E6","v":0.81008055551883684},null,null,"Cost of Funds",{"$f":"(I12*12)/$E$10","v":3.0000000000000006E-2},{"$f":"(J12*12)/$E$10","v":3.0000000000000006E-2},3.7783965240691379E-2,5.2473862336639254E-2,8.0989544934655711E-2,0.1,0.1,0.1,{"$f":"AVERAGE(I17:P17)","v":6.6405921563998285E-2}]
[null,null,null,"LTV (Builder Finance)",{"$f":"E12/E14","v":0.46489244006664704}]
[null,null,null,null,null,null,null,"Builder interest*7",{"$f":"(E5/12)*7","v":7353.5342178770952}]
[null,null,null,null,null,null,null,"Points",{"$f":"E4","v":7003.3659217877093},null,null,"ONLY MAINSAIL",null,"FACTOR"]
[null,null,null,null,null,null,null,"Fees",{"$f":"E7","v":2180},null,null,{"$f":"I20+I19+I21-((E10*10%)/8)","v":14170.92968575419},null,{"$f":"L24/L21","v":1.9188256224427926}]
[null,null,null,null,null,null,null,"(Mainsail investor)",{"$f":"-Q6","v":-3785.552726256984}]
[null,null,null,null,null,null,null,"(Builder Finance)",{"$f":"-Q9","v":-4593.8845209497213},"Return",null,"TOTAL ON SAME AMOUNT "]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(I19:I23)","v":8157.4628924580993},{"$f":"I24/E11","v":0.14365956541171382},null,{"$f":"I24*(150/45)","v":27191.542974860331}]