{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Pro Forma","Units"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Pro Forma","index":0,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[0,6,4,6],[62,0,62,6],[61,0,61,6],[60,0,60,6],[55,4,55,5],[53,3,53,5],[54,3,54,5],[11,3,11,5],[12,3,12,5],[14,3,14,5],[40,3,40,5],[56,0,56,6],[57,0,58,6],[19,3,19,5],[32,3,32,5],[21,3,21,5],[0,0,0,2],[5,3,5,5],[6,3,6,5],[10,3,10,5],[9,3,9,5],[7,3,7,5],[8,3,8,5],[52,3,52,5],[42,3,42,5],[29,3,29,5],[34,3,34,5],[38,3,38,5],[44,3,44,5],[45,3,45,5],[46,3,46,5],[47,3,47,5],[43,3,43,5],[39,3,39,5],[41,3,41,5],[31,3,31,5],[50,3,50,5],[30,3,30,5],[35,3,35,5],[37,3,37,5],[49,3,49,5],[28,3,28,5],[16,3,16,5],[15,3,15,5],[18,3,18,5],[20,3,20,5],[23,3,23,5],[27,3,27,5],[17,3,17,5],[22,3,22,5],[25,3,25,5],[26,3,26,5],[24,3,24,5],[33,3,33,5]]}
["2020: 1360 Berkeley Way. Berkeley CA 94702",null,null,"v06","Realtor","Marc Guay",{"$error":"#VALUE!"}]
["Pro Forma Tab",{"$nulls":4},"510-206-3434"]
["Rental Units",{"$f":"Units!B24","v":19},null,null,"Broker >>","David Fast"]
["Building Square Feet",{"$f":"Units!D24","v":11021},null,null,null,"650-814-0140"]
[" "]
["Revenue","Factor","Current","Description",null,null,"Notes"]
["Gross Units Rents",12,{"$f":"Units!E24*B7","v":538104},"Factor = Number of Months of Rent in Current"]
["Parking / Garage"," ",0," "]
["Laundry"," ",0," "]
["Storage / Pet Fees"," ",0," "]
["RUBS Utility Expenses"," ",0,"Ratio Utility Billing System - Tenant Utility Allocation",null,null," "]
["Vacancy",0.05,{"$f":"-SUM((C7:C11)*B12)","v":-26905.200000000001},"Minimum Allowance of 5%",null,null," "]
["Total Rental Income"," ",{"$f":"SUM(C7:C12)","v":511198.8}," "]
[]
["Operating Expenses","Factor","Current","Description",null,null,"Notes"]
["Property Taxes - Assessment",1.12E-2,{"$f":"SUM($B$16*$B$39)","v":61028.800000000003},"Purchase Price Range * Tax Rate",null,null," "]
["Property Taxes - Levy",1000,{"$f":"SUM($B$17*$B$3)","v":19000},"Tax Levy Estimate",null,null," "]
["Property Insurance",1.4500000000000001E-2,{"$f":"SUM($B$4*$B$18*100)","v":15980.450000000003},"Building SqFt * Insurance Rate per Feet",null,null," "]
["Water",0,11867,"Water Service per year"]
["Sewer",0,0,"Sewer Service per year",null,null," "]
["Garbage",0,3545,"Trash & Utilities Combined"]
["Gas & Electricity ",0,17650,"Electricty per year"]
["Combined Utilities",0,0,"Electricty, water, sewer per year"]
["Janitorial / Cleaning",0,0,"Janitorial Services per year"]
["Pest Control",0,0,"Pest Control per month per year"]
["Marketing",0,0,"Marketing per year"]
["Landscaping",0,{"$f":"SUM($B$27*12)","v":0},"Landscaping per year"]
["Management Fee - On-Site",{"$f":"IF($B$3<16,0,5%)","v":0.05},{"$f":"SUM($C$13*$B$28)","v":25559.940000000002},"% of Income per year for On-Site Management",null,null,"Lender Minimum < 16 Units"]
["Management Fee - Off-Site",{"$f":"IF($B$3>=16,4%,0)","v":0.04},{"$f":"SUM($C$13*$B$29)","v":20447.952000000001},"% of Income per year for Off-Site Management",null,null,"Lender Minimum >= 16 Units"]
["Repairs & Maintenance",750,{"$f":"SUM($B$30*$B$3)","v":14250},"Repair & Maintenance per unit per year",null,null," "]
["Replacement Reserves",250,{"$f":"SUM($B$31*$B$3)","v":4750},"Replacement Reserves per unit per year",null,null," "]
["Business License",0,0,"Business License"]
["Special Assessment",0,0,"Construction, Plumbing"]
["Contract Services",0,0,"Contract Services",null,null," "]
["City Taxes",0,0,"City Taxes"]
["Total Operating Expenses"," ",{"$f":"SUM(C16:C35)","v":194079.14199999999}," "]
[" "," "," "]
["Financing","Factor"," ","Description",null,null,"Notes"]
["Purchase Price / Value",5449000,null," "]
["LTV",0.67," ","Est LTV"]
["Down Payment Amount"," ",{"$f":"SUM($B$39-$C$42)","v":1798170}," "]
["Initial Loan Amount"," ",{"$f":"SUM($B$39*$B$40)","v":3650830}," "]
["Interest Rate - Estimate",5.8549999999999998E-2," ","Est Interest Rate"]
["Lender Points",0,{"$f":"$C$42*$B$44","v":0},"Est Lender Points"]
["Lender Fees"," ",5000,"Est Lender Fees - Appraisal, Environ, etc"]
["Broker Points",1.4999999999999999E-2,{"$f":"$C$42*$B$46","v":54762.45}," "]
["Title & Escrow Costs",4.0000000000000001E-3,{"$f":"$C$42*$B$47","v":14603.32},"Est Closing Costs"]
["Misc Closing Costs"," ",0," "]
[]
["Actual Loan Amount"," ",{"$f":"SUM($C$42:$C$48)","v":3725195.77}," "]
["Gross Operating Income"," ",{"$f":"SUM($C$7+$C$9)","v":538104}," ",null,null," "]
["Gross Income Multiplier",null,{"$f":"SUM($B$39/$C51/100)","v":0.10126295288643088}]
["Net Operating Income"," ",{"$f":"SUM($C$13-$C$36)","v":317119.658}," ",null,null," "]
["Monthly Debt Service",null,{"$f":"-PMT($B$43/12,360,$C$50,0)","v":21988.346013497659}," ",null,null," "]
["DSCR",null,{"$f":"SUM($C$53/($C$54*12))","v":1.2018474764061171}," ",null,null," "]
["CAP RATE"," ",{"$f":"($C$53/$B$39)","v":5.8197771701229584E-2}," "," ",null," "]
[" "]
["Notice: The number and values above may not have been confirmed by an appraisal or lenders underwriter. They are estimates."]
[]
[]
["Private Lending Services, Inc.  ~  Multi-Family Property Financing Specialists"]
["David Fast  ~  650-814-0140  ~  david@privatelendingservices.com"]
["Discovery Bay CA 94505  ~  CABRE #01375185  ~  www.privatelendingservices.com"]

{"sheet":"Units","index":1,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,0,1,4],[0,0,0,3]]}
["1360 Berkeley Way, Berkeley CA 94702",null,null,null,"V06",null," "]
[" "]
[" "," "," "]
["Unit ID","Unit","Name","SqFt","Current","Lease Start","Lease End","ProForma"]
[1,"x","x","x",2641," "," ",0]
[2,"x","x","x",2364,null,null,0]
[3,"x","x","x",2364,null,null,0]
[4,"x","x","x",1994,null,null,0]
[5,"x","x","x",2364," "," ",0]
[6,"x","x","x",2641," "," ",0]
[7,"x","x","x",2550," "," ",0]
[8,"x","x","x",2364," "," ",0]
[9,"x","x","x",2200," "," ",0]
[10,"x","x","x",2400," "," ",0]
[11,"x","x","x",1000,null,null,0]
[12,"x","x","x",2364,null,null,0]
[14,"x","x","x",2541,null,null,0]
[15,"x","x","x",2641,null,null,0]
[16,"x","x","x",1800,null,null,0]
[17,"x","x","x",2364,null,null,0]
[18,"x","x","x",2200,null,null,0]
[19,"x","x","x",2650,null,null,0]
[20,"x","x","x",3400,null,null,0]
[" ",{"$f":"SUM(COUNTA(B5:B23))","v":19}," ",11021,{"$f":"SUM(E5:E23)","v":44842},null,null,{"$f":"SUM(H5:H14)","v":0}]
[{"$nulls":4}," "]