{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Project Costs","Lease Income","Property Value Realisation","Cashflow&Income Stmt Loan Basis","Total Share Capital Basis","Cashflow&Income Stmt Loan EB5"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":"Project Costs","index":0,"n_rows":74,"n_cols":10,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["School Construction Budget"]
[]
[]
[null,"Proposed School Size",null,null,null,null,null,50000,"Sq Ft"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Australian Dollars"]
[null,null,null,null,null,null,null,"Per Sq /Ft",null,"Total Costs"]
[null,"Acquisition Costs"]
[null,null,"Land/Property Costs",null,null,null,null,49.09,null,{"$f":"H12*$H$4","v":2454500}]
[null,null,"Closing Costs",null,null,null,null,1,null,{"$f":"H13*$H$4","v":50000}]
[null,null,"Other Charges",null,null,null,null,0,null,0]
[]
[null,"Total Acquisition Costs",null,null,null,null,null,{"$f":"SUM(H12:H15)","v":50.09},null,{"$f":"SUM(J12:J15)","v":2504500}]
[]
[null,"Hard Construction Costs"]
[null,null,"Predevelopment and Soil Preparation",null,null,null,null,1.77,null,{"$f":"H19*$H$4","v":88500}]
[null,null,"Structure",null,null,null,null,24.78,null,1239000]
[null,null,"Plumbing",null,null,null,null,3.54,null,177000]
[null,null,"Electrical",null,null,null,null,7.08,null,354000]
[null,null,"Mechanical",null,null,null,null,5.31,null,265500]
[null,null,"FireProtection",null,null,null,null,1.77,null,88500]
[null,null,"Internal Walls ",null,null,null,null,5.31,null,265500]
[null,null,"Roofing",null,null,null,null,4.43,null,221500]
[null,null,"Windows & Doors",null,null,null,null,3.54,null,177000]
[null,null,"Carpentry",null,null,null,null,5.31,null,265500]
[null,null,"Plaster",null,null,null,null,0.89,null,44500]
[null,null,"Finish Floors",null,null,null,null,1.77,null,88500]
[null,null,"Paint",null,null,null,null,1.77,null,88500]
[null,null,"Parking & Exteriors",null,null,null,null,13.28,null,664000]
[null,null,"Cleaning",null,null,null,null,0.89,null,44500]
[null,null,"Overhead & Utilities",null,null,null,null,2.66,null,133000]
[null,null,"Hard Costs Contingency",null,null,null,null,4.43,null,221500]
[null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(H19:H35)","v":88.53},null,{"$f":"SUM(J19:J35)","v":4426500}]
[]
[null,"Soft Costs"]
[null,null,"Architectural & Engineering",null,null,null,null,4.6399999999999997,null,{"$f":"H39*$H$4","v":231999.99999999997}]
[null,null,"Builders Risk Insurance",null,null,null,null,1.28,null,64000]
[null,null,"Real Estate Taxes",null,null,null,null,1.44,null,72000]
[null,null,"Legal Services",null,null,null,null,1.6,null,80000]
[]
[null,null,"Consulting Fees"]
[null,null,"Geo-Technical Engineering",null,null,null,null,0.24,null,{"$f":"H45*$H$4","v":12000}]
[null,null,"Appraisal Costs",null,null,null,null,0.11,null,5500]
[null,null,"Market Studies",null,null,null,null,0.06,null,3000]
[null,null,"Renderings",null,null,null,null,0.08,null,4000]
[null,null,"Traffic Study",null,null,null,null,0.48,null,24000]
[null,null,"Environmental Study",null,null,null,null,0.13,null,6500]
[null,null,"Land Survey",null,null,null,null,0.32,null,16000]
[null,null,"Land Plat",null,null,null,null,0.24,null,12000]
[null,null,"Survey(as Built)",null,null,null,null,0.46,null,23000]
[null,null,"Title Insurance Updates",null,null,null,null,0.11,null,5500]
[null,null,"Constructions Inspections",null,null,null,null,0.24,null,12000]
[null,null,"Printing, Reproductions & Photography",null,null,null,null,0.17,null,8500]
[]
[null,null,"Impact Permit & Connection Fees",null,null,null,null,3.68,null,184000]
[null,null,"Marketing & Advertising",null,null,null,null,4.8,null,240000]
[null,null,"General & Administrative Fees",null,null,null,null,3.2,null,160000]
[null,null,"Soft Costs Contingency",null,null,null,null,1.4,null,70000]
[]
[null,null,"Sub-Total Soft Costs",null,null,null,null,{"$f":"SUM(H39:H61)","v":24.68},null,{"$f":"SUM(J39:J62)","v":1234000}]
[]
[null,"Financing Costs"]
[null,null,"Doc Stamps/Intangible Tax-PMM",null,null,null,null,1.67,null,{"$f":"H66*$H$4","v":83500}]
[null,null,"Other Closing Costs",null,null,null,null,1.77,null,88500]
[null,null,"Interest Reserve",null,null,null,null,3.64,null,182000]
[]
[null,null,"Sub-total Financing Costs",null,null,null,null,{"$f":"SUM(H66:H68)","v":7.08},null,{"$f":"SUM(J66:J68)","v":354000}]
[]
[null,"Total Soft Costs",null,null,null,null,null,{"$f":"H70+H63","v":31.759999999999998},null,{"$f":"J70+J63","v":1588000}]
[]
[null,"Total Project Costs",null,null,null,null,null,{"$f":"H72+H36+H16","v":170.38},null,{"$f":"J72+J36+J16","v":8519000}]

{"sheet":"Lease Income","index":1,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,"Calculating Lease Income",{"$f":"'Project Costs'!J9","v":"Australian Dollars"}]
[]
[null,null,"Lease Amount",{"$f":"'Project Costs'!J74","v":8519000},null,2.5]
[null,null,"Number of Advance Payments",3,null,2.75]
[null,null,"Number of Payments",{"$f":"10*12","v":120},null,3]
[null,null,"Payments Per Year",12,null,3.25]
[null,null,"Annual Interest Rate     %-age",3.75,null,3.5]
[null,null,"Residual   (Assumed 10% )",{"$f":"D3*0.1","v":851900},null,3.5]
[null,null,"(For Lease Income Calculation)",null,null,3.75]
[null,null,null,null,null,4]
[null,null,null,null,null,4.25]
[null,null,"Solution Using TVM Functions",null,null,4.5]
[null,null,"Regular Monthly Payment",{"$f":"IF(D4>10,\"Too Many Advance Payments\",(D3-PV((D7/100)/D6,D5,0,-D8))/(PV((D7/100)/D6,D5-D4,-1)+D4))","v":78647.898130029076},null,4.75]
[null,null,"First Payment at Closing",{"$f":"D13*D4","v":235943.69439008721},null,5]
[]
[null,null,null,null,null,3.75]
[null,null,null,null,null,4]
[null,null,null,null,null,4.25]
[null,null,null,null,null,4.5]
[null,null,null,null,null,4.75]
[null,null,null,null,null,5]
[null,null,null,null,null,5.25]
[null,null,null,null,null,5.5]
[null,null,null,null,null,5.75]
[null,null,null,null,null,6]

{"sheet":"Property Value Realisation","index":2,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,null,null,null,null,{"$f":"'Lease Income'!D1","v":"Australian Dollars"}]
[null,null,null,"Total  Cost of Property",null,null,null,{"$f":"'Project Costs'!J74","v":8519000}]
[]
[null,null,null,"Less: Cost of Land",null,null,null,{"$f":"'Project Costs'!J16","v":2504500}]
[null,null,null,"(Land Cannot be Depreciated)"]
[]
[null,null,null,"Depreciable Value of Property",null,null,null,{"$f":"H4-H6","v":6014500}]
[]
[null,null,null,null,null,null,"Year","Asset Book Value","Depreciation","WDV"]
[null,null,null,"Depreciation Assuming 7.5% WDV",null,null,1,{"$f":"H9","v":6014500},{"$f":"H12*0.075","v":451087.5},{"$f":"H12-I12","v":5563412.5}]
[null,null,null,null,null,null,2,{"$f":"J12","v":5563412.5},{"$f":"H13*0.075","v":417255.9375},{"$f":"H13-I13","v":5146156.5625}]
[null,null,null,null,null,null,3,{"$f":"J13","v":5146156.5625},385961.7421875,4760194.8203125]
[null,null,null,null,null,null,4,4760194.8203125,357014.61152343749,4403180.2087890627]
[null,null,null,null,null,null,5,4403180.2087890627,330238.51565917971,4072941.6931298831]
[null,null,null,null,null,null,6,4072941.6931298831,305470.62698474125,3767471.0661451421]
[null,null,null,null,null,null,7,3767471.0661451421,282560.32996088563,3484910.7361842566]
[null,null,null,null,null,null,8,3484910.7361842566,261368.30521381923,3223542.4309704374]
[null,null,null,null,null,null,9,3223542.4309704374,241765.68232278278,2981776.7486476544]
[null,null,null,null,null,null,10,2981776.7486476544,223633.25614857409,2758143.4924990805]
[]
[null,null,null,"Sale Value of Property --- Depreciated for 10 years",null,null,null,null,null,{"$f":"J21","v":2758143.4924990805}]
[null,null,null,"Sale value of Acquired Land  --- Assuming  5% Appreciation",null,null,null,null,null,{"$f":"H6*1.05","v":2629725}]
[]
[null,null,null,"Total Realisable Value from Sale of Property at the end of 10th year",null,null,null,null,null,12630344]
[null,null,null,"Assuming Book Value"]

{"sheet":"Cashflow&Income Stmt Loan Basis","index":3,"n_rows":80,"n_cols":16,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Property Value Realisation'!H3","v":"Australian Dollars"},null,null,"Basis of One School of 120,000 Sq Ft"]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,null,null,"Zero",1,2,3,4,5,6,7,8,9,10]
[null,null,"%-age Holding"]
[null,"Inflow",10,"Major Shareholder  ",null,{"$f":"'Project Costs'!J74*C5*0.01","v":851900}]
[null,null,{"$f":"100-C5","v":90},"Individual Investors  -(Loan Finance)",null,{"$f":"'Project Costs'!J74-'Cashflow&Income Stmt Loan Basis'!F5","v":7667100}]
[]
[null,null,null,"Lease Income --- As Calculated",null,null,{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886}]
[]
[null,null,null,"Sale of Asset at 10th Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[]
[]
[]
[]
[null,"Outflow",null,"Cost of Construction",null,{"$f":"'Project Costs'!J74","v":8519000}]
[]
[]
[null,null,5,"Loan Interest Paid to Individual Investors",null,null,{"$f":"$F$6*$C$18/100","v":383355},{"$f":"$F$6*$C$18/100","v":383355},383355,383355,383355,383355,383355,383355,383355,383355]
[null,null,null,"Flat Rate %-age "]
[]
[null,null,null,"Corporate Income Taxes from Income Statement-- Paid Following Year",null,null,{"$f":"F52","v":0},{"$f":"G52","v":21866.455512069773},28632.768012069773,34891.607074569773,40681.033207382265,46036.252380233818,50989.830115121513,55571.889519892633,59810.294469305925,63730.819047513214]
[]
[null,null,null,"Dividends Paid to Shareholder",null,null,{"$f":"F59","v":0},{"$f":"G59","v":78719.239843451171},103077.96484345118,125609.78546845118,146451.71954657615,165730.50856884176,183563.38841443745,200058.80227161347,215317.06008950132,229430.94857104754]
[]
[null,null,null,"Repayment to Individual Investors  - Sale of Property",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[null,null,null,"Repayment to Individual Investors  - Shortfall from Internal Generation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F6-P25","v":-4963244}]
[]
[]
[null,"Net Cash Flow== SURPLUS/(SHORTFALL)",null,null,null,{"$f":"SUM(F5:F10)-SUM(F15:F27)","v":0},{"$f":"SUM(G5:G10)-SUM(G15:G27)","v":560419.77756034886},459834.08220482792,428709.04470482795,399918.38501732785,373287.02480639052,348653.01661127328,325866.55903078988,304789.08576884272,285292.42300154164,5230502.0099417884]
[]
[null,"Cumulative Cash  Flow",null,null,null,{"$f":"F29","v":0},{"$f":"F31+G29","v":560419.77756034886},{"$f":"G31+H29","v":1020253.8597651768},1448962.9044700046,1848881.2894873326,2222168.3142937231,2570821.3309049965,2896687.8899357864,3201476.975704629,3486769.3987061707,8717271.4086479582]
[null,null,null,"Cash Flow Return to Major Shareholder",null,{"$f":"F29/$F$5","v":0},{"$f":"G29/$F$5","v":0.65784690405018065},0.53977471793030629,0.50323869550983447,0.4694428747708978,0.43818174058738174,0.40926519146762919,0.38251738353185805,0.3577756611912698,0.33488956802622566,6.1398075008120534]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,"Income Statement",null,"Zero",1,2,3,4,5,6,7,8,9,10]
[]
[null,null,null,"Upfront Profit on Project Completion",null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Lease Income",null,null,{"$f":"G8","v":943774.77756034886},{"$f":"H8","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[null,null,null,"Total Income",null,{"$f":"SUM(F41:F44)","v":0},{"$f":"SUM(G41:G44)","v":943774.77756034886},{"$f":"SUM(H41:H44)","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[null,null,null,"Loan Interest Payment ",null,null,{"$f":"G18","v":383355},{"$f":"H18","v":383355},383355,383355,383355,383355,383355,383355,383355,383355]
[null,null,null,"Book Depreciation",null,null,{"$f":"'Property Value Realisation'!I12","v":451087.5},{"$f":"'Property Value Realisation'!I13","v":417255.9375},{"$f":"'Property Value Realisation'!I14","v":385961.7421875},{"$f":"'Property Value Realisation'!I15","v":357014.61152343749},{"$f":"'Property Value Realisation'!I16","v":330238.51565917971},{"$f":"'Property Value Realisation'!I17","v":305470.62698474125},{"$f":"'Property Value Realisation'!I18","v":282560.32996088563},{"$f":"'Property Value Realisation'!I19","v":261368.30521381923},{"$f":"'Property Value Realisation'!I20","v":241765.68232278278},{"$f":"'Property Value Realisation'!I21","v":223633.25614857409}]
[]
[null,null,null,"Profit Before Tax",null,{"$f":"F45-SUM(F47:F49)","v":0},{"$f":"G45-SUM(G47:G49)","v":109332.27756034886},143163.84006034886,174458.03537284886,203405.16603691131,230181.26190116908,254949.15057560755,277859.44759946316,299051.4723465296,318654.09523756604,336786.5214117748]
[]
[null,null,null,"Corporate Taxes (Range from 15%- 39%) Average Assumed 20%",null,{"$f":"F50*0.2","v":0},{"$f":"G50*0.2","v":21866.455512069773},28632.768012069773,34891.607074569773,40681.033207382265,46036.252380233818,50989.830115121513,55571.889519892633,59810.294469305925,63730.819047513214,67357.304282354962]
[]
[null,null,null,"Profit After Tax",null,{"$f":"F50-F52","v":0},{"$f":"G50-G52","v":87465.822048279078},114531.07204827908,139566.42829827909,162724.13282952906,184145.00952093527,203959.32046048605,222287.55807957053,239241.17787722367,254923.27619005283,269429.21712941985]
[]
[]
[null,null,null,"Return on Investment to Major Shareholder",null,{"$f":"F54/$F$5","v":0},{"$f":"G54/$F$5","v":0.10267146619119506},0.13444192046986628,0.16382959067763717,0.19101318561982517,0.21615801094134907,0.23941697436375872,0.26093151552948768,0.28083246610778689,0.29924084539271373,0.31626859623127107]
[]
[null,null,null,"Dividends Declared and  Paid Following  Year -90% of Profit After Tax",null,{"$f":"F54*0.9","v":0},78719.239843451171,103077.96484345118,125609.78546845118,146451.71954657615,165730.50856884176,183563.38841443745,200058.80227161347,215317.06008950132,229430.94857104754,242486.29541647786]
[]
[]
[]
[null,null,null,"Balance Sheet"]
[]
[null,null,null,"Share Capital",null,{"$f":"$F$5","v":851900},{"$f":"$F$5","v":851900},851900,851900,851900,851900,851900,851900,851900,851900,851900]
[null,null,null,"Accumulated Reserves",null,{"$f":"F54-F59","v":0},{"$f":"F66+G54-G59","v":8746.5822048279078},{"$f":"G66+H54-H59","v":20199.68940965581},34156.332239483716,50428.745522436628,68843.24647453014,89239.178520578746,111467.93432853583,135392.05211625819,160884.3797352635,187827.30144820546]
[null,null,null,"Loan from Investors",null,{"$f":"$F$6","v":7667100},{"$f":"$F$6","v":7667100},7667100,7667100,7667100,7667100,7667100,7667100,7667100,7667100,{"$f":"$F$6-P25-P26","v":0}]
[null,null,null,"Taxes Payable",null,{"$f":"F52","v":0},{"$f":"G52","v":21866.455512069773},28632.768012069773,34891.607074569773,40681.033207382265,46036.252380233818,50989.830115121513,55571.889519892633,59810.294469305925,63730.819047513214,67357.304282354962]
[null,null,null,"Dividents Payable",null,{"$f":"F59","v":0},{"$f":"G59","v":78719.239843451171},103077.96484345118,125609.78546845118,146451.71954657615,165730.50856884176,183563.38841443745,200058.80227161347,215317.06008950132,229430.94857104754,242486.29541647786]
[]
[null,null,null,"Total Share holders Equity & Liabilities",null,{"$f":"SUM(F65:F70)","v":8519000},{"$f":"SUM(G65:G70)","v":8628332.2775603477},8670910.4222651776,8713657.724782506,8756561.4982763957,8799610.0074236058,8842792.3970501367,8886098.6261200421,8929519.4066750649,8973046.1473538224,1349570.9011470382]
[]
[null,null,null,"Leased Property",null,{"$f":"F15","v":8519000},{"$f":"F73","v":8519000},{"$f":"G73","v":8519000},8519000,8519000,8519000,8519000,8519000,8519000,8519000,0]
[null,null,null,"Accumulated Depreciation",null,0,{"$f":"G48","v":451087.5},{"$f":"G74+H48","v":868343.4375},{"$f":"H74+I48","v":1254305.1796875},1611319.7912109375,1941558.3068701173,2247028.9338548584,2529589.2638157438,2790957.5690295631,3032723.251352346,0]
[null,null,null,"Net Value of Leased Property",null,{"$f":"F73-F74","v":8519000},{"$f":"G73-G74","v":8067912.5},{"$f":"H73-H74","v":7650656.5625},7264694.8203125,6907680.2087890627,6577441.6931298822,6271971.0661451416,5989410.7361842562,5728042.4309704369,5486276.7486476544,0]
[]
[null,null,null,"Cash & Bank Balances",null,{"$f":"F5+F6-F15","v":0},{"$f":"G31","v":560419.77756034886},{"$f":"H31","v":1020253.8597651768},1448962.9044700046,1848881.2894873326,2222168.3142937231,2570821.3309049965,2896687.8899357864,3201476.975704629,3486769.3987061707,8717271.4086479582]
[]
[null,null,null,"Total Assets & Bank Balances",null,{"$f":"F75+F77","v":8519000},{"$f":"G75+G77","v":8628332.2775603496},8670910.4222651776,8713657.7247825041,8756561.4982763957,8799610.0074236058,8842792.3970501386,8886098.6261200421,8929519.4066750668,8973046.1473538242,8717271.4086479582]
[null,null,null,null,null,{"$f":"F71-F79","v":0},{"$f":"G71-G79","v":0},0,0,0,0,0,0,0,0,-7367700.5075009204]

{"sheet":"Total Share Capital Basis","index":4,"n_rows":80,"n_cols":16,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Cashflow&Income Stmt Loan Basis'!A1","v":"Australian Dollars"},null,null,"Basis of One School of 120,000 Sq Ft"]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,null,null,"Zero",1,2,3,4,5,6,7,8,9,10]
[null,null,"%-age Holding"]
[null,"Inflow",25,"Major Shareholder   -                               Share Capital",null,{"$f":"'Project Costs'!J74*C5/100","v":2129750}]
[null,null,{"$f":"100-C5","v":75},"Individual Investors  -                              Share Capital",null,{"$f":"'Project Costs'!J74-'Total Share Capital Basis'!F5","v":6389250}]
[]
[null,null,null,"Lease Income --- As Calculated",null,null,{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886}]
[]
[null,null,null,"Sale of Asset at 10th Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[]
[]
[]
[]
[null,"Outflow",null,"Cost of Construction",null,{"$f":"'Project Costs'!J74","v":8519000}]
[]
[]
[null,null,null,"Loan Interest Paid to Individual Investors",null,null,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,"Corporate Income Taxes from Income Statement-- Paid Following Year",null,null,{"$f":"F52","v":0},{"$f":"G52","v":98537.455512069777},105303.76801206978,111562.60707456978,117352.03320738226,122707.25238023383,127660.83011512151,132242.88951989263,136481.29446930593,140401.81904751321]
[]
[null,null,null,"Dividends Paid to Shareholder",null,null,{"$f":"F59","v":0},{"$f":"G59","v":354734.83984345122},379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,459578.98841443745,476074.40227161348,491332.66008950135,505446.54857104761]
[]
[null,null,null,"Repayment to Individual Investors  - Sale of Property",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[null,null,null,"Repayment to Individual Investors  - Shortfall from Internal Generation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F6-P25","v":-6241094}]
[]
[]
[null,"Net Cash Flow== SURPLUS/(SHORTFALL)",null,null,null,{"$f":"SUM(F5:F10)-SUM(F15:F27)","v":0},{"$f":"SUM(G5:G10)-SUM(G15:G27)","v":943774.77756034886},490502.48220482783,459377.44470482785,430586.78501732787,403955.42480639042,379321.41661127331,356534.95903078991,335457.48576884274,315960.82300154155,6539020.4099417888]
[]
[null,"Cumulative Cash  Flow",null,null,null,{"$f":"F29","v":0},{"$f":"F31+G29","v":943774.77756034886},{"$f":"G31+H29","v":1434277.2597651766},1893654.7044700044,2324241.4894873323,2728196.9142937227,3107518.330904996,3464053.2899357858,3799510.7757046288,4115471.5987061705,10654492.00864796]
[null,null,null,"Cash Flow Return to All Shareholders ",null,{"$f":"F29/($F$5+$F$6)","v":0},{"$f":"G29/($F$5+$F$6)","v":0.11078469040501807},5.7577471793030618E-2,5.3923869550983432E-2,5.0544287477089785E-2,4.7418174058738168E-2,4.4526519146762922E-2,4.1851738353185806E-2,3.9377566119126982E-2,3.7088956802622558E-2,0.76758075008120541]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,"Income Statement",null,"Zero",1,2,3,4,5,6,7,8,9,10]
[]
[null,null,null,"Upfront Profit on Project Completion",null,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Lease Income",null,null,{"$f":"G8","v":943774.77756034886},{"$f":"H8","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[null,null,null,"Total Income",null,{"$f":"SUM(F41:F44)","v":0},{"$f":"SUM(G41:G44)","v":943774.77756034886},{"$f":"SUM(H41:H44)","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[null,null,null,"Loan Interest Payment ",null,null,{"$f":"G18","v":0},{"$f":"H18","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Book Depreciation",null,null,{"$f":"'Property Value Realisation'!I12","v":451087.5},{"$f":"'Property Value Realisation'!I13","v":417255.9375},{"$f":"'Property Value Realisation'!I14","v":385961.7421875},{"$f":"'Property Value Realisation'!I15","v":357014.61152343749},{"$f":"'Property Value Realisation'!I16","v":330238.51565917971},{"$f":"'Property Value Realisation'!I17","v":305470.62698474125},{"$f":"'Property Value Realisation'!I18","v":282560.32996088563},{"$f":"'Property Value Realisation'!I19","v":261368.30521381923},{"$f":"'Property Value Realisation'!I20","v":241765.68232278278},{"$f":"'Property Value Realisation'!I21","v":223633.25614857409}]
[]
[null,null,null,"Profit Before Tax",null,{"$f":"F45-SUM(F47:F49)","v":0},{"$f":"G45-SUM(G47:G49)","v":492687.27756034886},526518.84006034886,557813.03537284886,586760.16603691131,613536.26190116908,638304.15057560755,661214.44759946316,682406.4723465296,702009.09523756604,720141.5214117748]
[]
[null,null,null,"Corporate Taxes (Range from 15%- 39%) Average Assumed 20%",null,{"$f":"F50*0.2","v":0},{"$f":"G50*0.2","v":98537.455512069777},{"$f":"H50*0.2","v":105303.76801206978},111562.60707456978,117352.03320738226,122707.25238023383,127660.83011512151,132242.88951989263,136481.29446930593,140401.81904751321,144028.30428235498]
[]
[null,null,null,"Profit After Tax",null,{"$f":"F50-F52","v":0},{"$f":"G50-G52","v":394149.82204827911},421215.07204827911,446250.42829827906,469408.13282952906,490829.00952093524,510643.32046048605,528971.55807957053,545925.1778772237,561607.27619005286,576113.21712941979]
[]
[]
[null,null,null,"Return on Investment to All Shareholders",null,{"$f":"F54/$F$5","v":0},{"$f":"G54/($F$5+$F$6)","v":4.6267146619119508E-2},{"$f":"H54/($F$5+$F$6)","v":4.9444192046986628E-2},5.2382959067763711E-2,5.5101318561982519E-2,5.7615801094134902E-2,5.9941697436375875E-2,6.2093151552948762E-2,6.4083246610778688E-2,6.5924084539271371E-2,6.7626859623127103E-2]
[]
[null,null,null,"Dividends Declared and  Paid Following  Year -90% of Profit After Tax",null,{"$f":"F54*0.9","v":0},354734.83984345122,379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,459578.98841443745,476074.40227161348,491332.66008950135,505446.54857104761,518501.89541647781]
[]
[]
[]
[null,null,null,"Balance Sheet"]
[]
[null,null,null,"Share Capital",null,{"$f":"$F$5","v":2129750},{"$f":"$F$5","v":2129750},2129750,2129750,2129750,2129750,2129750,2129750,2129750,2129750,2129750]
[null,null,null,"Accumulated Reserves",null,{"$f":"F54-F59","v":0},{"$f":"F66+G54-G59","v":39414.982204827887},{"$f":"G66+H54-H59","v":81536.489409655798},126161.53223948367,173102.34552243649,222185.24647452997,273249.57852057862,326146.73432853562,380739.25211625797,436899.97973526316,494511.30144820514]
[null,null,null,"Loan from Investors",null,{"$f":"$F$6","v":6389250},{"$f":"$F$6","v":6389250},6389250,6389250,6389250,6389250,6389250,6389250,6389250,6389250,{"$f":"$F$6-P25-P26","v":0}]
[null,null,null,"Taxes Payable",null,{"$f":"F52","v":0},{"$f":"G52","v":98537.455512069777},105303.76801206978,111562.60707456978,117352.03320738226,122707.25238023383,127660.83011512151,132242.88951989263,136481.29446930593,140401.81904751321,144028.30428235498]
[null,null,null,"Dividents Payable",null,{"$f":"F59","v":0},{"$f":"G59","v":354734.83984345122},379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,459578.98841443745,476074.40227161348,491332.66008950135,505446.54857104761,518501.89541647781]
[]
[null,null,null,"Total Share holders Equity & Liabilities",null,{"$f":"SUM(F65:F70)","v":8519000},{"$f":"SUM(G65:G70)","v":9011687.2775603496},9084933.8222651761,9158349.5247825049,9231921.6982763968,9305638.6074236054,9379489.3970501367,9453464.0261200406,9527553.2066750657,9601748.3473538235,3286791.5011470378]
[]
[null,null,null,"Leased Property",null,{"$f":"F15","v":8519000},{"$f":"F73","v":8519000},{"$f":"G73","v":8519000},8519000,8519000,8519000,8519000,8519000,8519000,8519000,0]
[null,null,null,"Accumulated Depreciation",null,0,{"$f":"G48","v":451087.5},{"$f":"G74+H48","v":868343.4375},{"$f":"H74+I48","v":1254305.1796875},1611319.7912109375,1941558.3068701173,2247028.9338548584,2529589.2638157438,2790957.5690295631,3032723.251352346,0]
[null,null,null,"Net Value of Leased Property",null,{"$f":"F73-F74","v":8519000},{"$f":"G73-G74","v":8067912.5},{"$f":"H73-H74","v":7650656.5625},7264694.8203125,6907680.2087890627,6577441.6931298822,6271971.0661451416,5989410.7361842562,5728042.4309704369,5486276.7486476544,0]
[]
[null,null,null,"Cash & Bank Balances",null,{"$f":"F5+F6-F15","v":0},{"$f":"G31","v":943774.77756034886},{"$f":"H31","v":1434277.2597651766},1893654.7044700044,2324241.4894873323,2728196.9142937227,3107518.330904996,3464053.2899357858,3799510.7757046288,4115471.5987061705,10654492.00864796]
[]
[null,null,null,"Total Assets & Bank Balances",null,{"$f":"F75+F77","v":8519000},{"$f":"G75+G77","v":9011687.2775603496},9084933.8222651761,9158349.5247825049,9231921.698276395,9305638.6074236054,9379489.3970501386,9453464.0261200424,9527553.2066750657,9601748.3473538253,10654492.00864796]
[null,null,null,null,null,{"$f":"F71-F79","v":0},{"$f":"G71-G79","v":0},0,0,0,0,0,0,0,0,-7367700.5075009223]

{"sheet":"Cashflow&Income Stmt Loan EB5","index":5,"n_rows":98,"n_cols":16,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Total Share Capital Basis'!A1","v":"Australian Dollars"},null,null,"Basis of One School of 120,000 Sq Ft"]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,null,null,"Zero",1,2,3,4,5,6,7,8,9,10]
[null,null,"%-age Holding"]
[null,"Inflow",25,"Major Shareholder  ",null,{"$f":"'Project Costs'!J74*C5*0.01","v":2129750}]
[null,null,{"$f":"100-C5","v":75},"Individual Investors  -(Loan Finance)",null,{"$f":"'Project Costs'!J74-'Cashflow&Income Stmt Loan EB5'!F5","v":6389250}]
[null,null,null,"Number of Investors for EB 5 @ US500,000",{"$f":"ROUND(F6/500000,0)","v":13}]
[null,null,null,"Lease Income --- As Calculated",null,null,{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886},{"$f":"'Lease Income'!$D$13*12","v":943774.77756034886}]
[]
[null,null,null,"EB5- MANAGEMENT INCOME @US50,000/PER INVESTOR",null,null,{"$f":"50000*E7","v":650000},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Sale of Asset at 10th Year",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[]
[]
[]
[]
[null,"Outflow",null,"Cost of Construction",null,{"$f":"'Project Costs'!J74","v":8519000}]
[null,null,null,"EB5 EXPENSES TOTAL PER INCOME STATEMENT",null,null,{"$f":"SUM(G50:G63)","v":149000}]
[]
[null,null,5,"Loan Interest Paid to Individual Investors",null,null,0,0,0,0,0,{"$f":"$F$6*$C$20/100","v":319462.5},319462.5,319462.5,319462.5,319462.5]
[null,null,null,"Flat Rate %-age                                                   FROM 6TH YEAR"]
[]
[null,null,null,"Corporate Income Taxes from Income Statement-- Paid Following Year",null,null,{"$f":"F70","v":0},{"$f":"G70","v":198737.45551206978},105303.76801206978,111562.60707456978,117352.03320738226,122707.25238023383,63768.330115121513,68350.389519892633,72588.794469305925,76509.319047513214]
[]
[null,null,null,"Dividends Paid to Shareholder",null,null,{"$f":"F77","v":0},{"$f":"G77","v":715454.83984345116},379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,229565.98841443745,246061.40227161348,261319.66008950133,275433.54857104761]
[]
[null,null,null,"Repayment to Individual Investors  - Sale of Property",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Property Value Realisation'!J26","v":12630344}]
[null,null,null,"Repayment to Individual Investors  - Shortfall from Internal Generation",null,null,null,null,null,null,null,null,null,null,null,{"$f":"F6-P27","v":-6241094}]
[]
[]
[null,"Net Cash Flow== SURPLUS/(SHORTFALL)",null,null,null,{"$f":"SUM(F5:F12)-SUM(F17:F29)","v":0},{"$f":"SUM(G5:G12)-SUM(G17:G29)","v":1444774.7775603489},{"$f":"SUM(H5:H12)-SUM(H17:H29)","v":29582.482204827946},459377.44470482785,430586.78501732787,403955.42480639042,59858.916611273307,330977.95903078991,309900.48576884274,290403.82300154166,{"$f":"SUM(P5:P12)-SUM(P17:P29)","v":6513463.4099417888}]
[]
[null,"Cumulative Cash  Flow",null,null,null,{"$f":"F31","v":0},{"$f":"F33+G31","v":1444774.7775603489},{"$f":"G33+H31","v":1474357.2597651768},1933734.7044700047,2364321.4894873323,2768276.9142937227,2828135.830904996,3159113.7899357858,3469014.2757046288,3759418.0987061705,10272881.50864796]
[null,null,null,"Cash Flow Return to Major Shareholder",null,{"$f":"F31/$F$5","v":0},{"$f":"G31/$F$5","v":0.67837763942263118},1.3890119593768258E-2,0.21569547820393373,0.20217714990835914,0.18967269623495267,2.8106076587051675E-2,0.15540695341274324,0.14551026447650792,0.13635582721049028,3.0583230003248216]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Year ","Year","Year","Year","Year","Year","Year","Year","Year","Year","Year"]
[null,null,null,"Income Statement",null,"Zero",1,2,3,4,5,6,7,8,9,10]
[]
[null,null,null,"EB5- MANAGEMENT INCOME @US50,000/PER INVESTOR",null,null,{"$f":"G10","v":650000},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Lease Income",null,null,{"$f":"G8","v":943774.77756034886},{"$f":"H8","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[null,null,null,"Total Income",null,{"$f":"SUM(F43:F46)","v":0},{"$f":"SUM(G43:G46)","v":1593774.7775603489},{"$f":"SUM(H43:H46)","v":943774.77756034886},943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886,943774.77756034886]
[]
[]
[null,null,null,"Incorporation of Company",null,null,1000]
[null,null,null,"Renewal of Company #1 ($2,000 = $200 X 10 years)",null,null,2000]
[null,null,null,"Appraisal Report ($5,000 each)",null,null,5000]
[null,null,null,"Site Inspection Cost ($25,000 per project) ",null,null,25000]
[null,null,null,"Accountant ($600 per year X LP X 10 years)",null,null,6000]
[null,null,null,"Economic Report ($7,500)",null,null,7500]
[null,null,null,"Bridge Loan Closing Fees 1%",null,null,0]
[null,null,null,"Regional Center 1st Payment",null,null,2500]
[null,null,null,"Regional Center 2nd Payment ",null,null,5000]
[null,null,null,"1st Commission ($25,000 at submission)",null,null,25000]
[null,null,null,"2nd Commission ($25,000 at approval)",null,null,25000]
[null,null,null,"3rd Commission ($10,000 at Year1)",null,null,10000]
[null,null,null,"I-924 Petition ($15,000 per project) ",null,null,15000]
[null,null,null,"Real Estate Lawyer Due Diligence/Registration's Fees",null,null,20000]
[]
[null,null,null,"Loan Interest Payment ",null,null,{"$f":"G20","v":0},0,0,0,0,319462.5,319462.5,319462.5,319462.5,319462.5]
[null,null,null,"Book Depreciation",null,null,{"$f":"'Property Value Realisation'!I12","v":451087.5},{"$f":"'Property Value Realisation'!I13","v":417255.9375},{"$f":"'Property Value Realisation'!I14","v":385961.7421875},{"$f":"'Property Value Realisation'!I15","v":357014.61152343749},{"$f":"'Property Value Realisation'!I16","v":330238.51565917971},{"$f":"'Property Value Realisation'!I17","v":305470.62698474125},{"$f":"'Property Value Realisation'!I18","v":282560.32996088563},{"$f":"'Property Value Realisation'!I19","v":261368.30521381923},{"$f":"'Property Value Realisation'!I20","v":241765.68232278278},{"$f":"'Property Value Realisation'!I21","v":223633.25614857409}]
[]
[null,null,null,"Profit Before Tax",null,{"$f":"F47-SUM(F48:F67)","v":0},993687.27756034886,526518.84006034886,557813.03537284886,586760.16603691131,613536.26190116908,318841.65057560755,341751.94759946316,362943.9723465296,382546.59523756604,400679.0214117748]
[]
[null,null,null,"Corporate Taxes (Range from 15%- 39%) Average Assumed 20%",null,{"$f":"F68*0.2","v":0},{"$f":"G68*0.2","v":198737.45551206978},{"$f":"H68*0.2","v":105303.76801206978},111562.60707456978,117352.03320738226,122707.25238023383,63768.330115121513,68350.389519892633,72588.794469305925,76509.319047513214,80135.804282354962]
[]
[null,null,null,"Profit After Tax",null,{"$f":"F68-F70","v":0},{"$f":"G68-G70","v":794949.82204827911},{"$f":"H68-H70","v":421215.07204827911},446250.42829827906,469408.13282952906,490829.00952093524,255073.32046048605,273401.55807957053,290355.1778772237,306037.27619005286,320543.21712941985]
[]
[]
[null,null,null,"Return on Investment to Major Shareholder",null,{"$f":"F72/$F$5","v":0},{"$f":"G72/$F$5","v":0.37325968871852522},0.19777676818794651,0.20953183627105484,0.22040527424793008,0.23046320437653961,0.11976678974550349,0.12837260621179505,0.13633298644311478,0.14369633815708552,0.15050743849250844]
[]
[null,null,null,"Dividends Declared and  Paid Following  Year -90% of Profit After Tax",null,{"$f":"F72*0.9","v":0},{"$f":"G72*0.9","v":715454.83984345116},379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,229565.98841443745,246061.40227161348,261319.66008950133,275433.54857104761,288488.89541647787]
[]
[]
[]
[null,null,null,"Balance Sheet"]
[]
[null,null,null,"Share Capital",null,{"$f":"$F$5","v":2129750},{"$f":"$F$5","v":2129750},2129750,2129750,2129750,2129750,2129750,2129750,2129750,2129750,2129750]
[null,null,null,"Accumulated Reserves",null,{"$f":"F72-F77","v":0},{"$f":"F84+G72-G77","v":79494.982204827946},{"$f":"G84+H72-H77","v":121616.48940965586},166241.53223948379,213182.34552243672,262265.2464745302,287772.5785205788,315112.73432853585,344148.25211625826,374751.97973526351,406806.30144820554]
[null,null,null,"Loan from Investors",null,{"$f":"$F$6","v":6389250},{"$f":"$F$6","v":6389250},6389250,6389250,6389250,6389250,6389250,6389250,6389250,6389250,{"$f":"$F$6-P27-P28","v":0}]
[null,null,null,"Taxes Payable",null,{"$f":"F70","v":0},{"$f":"G70","v":198737.45551206978},105303.76801206978,111562.60707456978,117352.03320738226,122707.25238023383,63768.330115121513,68350.389519892633,72588.794469305925,76509.319047513214,80135.804282354962]
[null,null,null,"Dividents Payable",null,{"$f":"F77","v":0},{"$f":"G77","v":715454.83984345116},379093.5648434512,401625.38546845119,422467.31954657618,441746.10856884171,229565.98841443745,246061.40227161348,261319.66008950133,275433.54857104761,288488.89541647787]
[]
[null,null,null,"Total Share holders Equity & Liabilities",null,{"$f":"SUM(F83:F88)","v":8519000},{"$f":"SUM(G83:G88)","v":9512687.2775603496},9125013.8222651761,9198429.5247825049,9272001.6982763968,9345718.6074236054,9100106.8970501367,9148524.5261200424,9197056.7066750675,9245694.8473538235,2905181.0011470383]
[]
[null,null,null,"Leased Property",null,{"$f":"F17","v":8519000},{"$f":"F91","v":8519000},{"$f":"G91","v":8519000},8519000,8519000,8519000,8519000,8519000,8519000,8519000,0]
[null,null,null,"Accumulated Depreciation",null,0,{"$f":"G66","v":451087.5},{"$f":"G92+H66","v":868343.4375},{"$f":"H92+I66","v":1254305.1796875},1611319.7912109375,1941558.3068701173,2247028.9338548584,2529589.2638157438,2790957.5690295631,3032723.251352346,0]
[null,null,null,"Net Value of Leased Property",null,{"$f":"F91-F92","v":8519000},{"$f":"G91-G92","v":8067912.5},{"$f":"H91-H92","v":7650656.5625},7264694.8203125,6907680.2087890627,6577441.6931298822,6271971.0661451416,5989410.7361842562,5728042.4309704369,5486276.7486476544,0]
[]
[null,null,null,"Cash & Bank Balances",null,{"$f":"F5+F6-F17","v":0},{"$f":"G33","v":1444774.7775603489},1474357.2597651768,1933734.7044700047,2364321.4894873323,2768276.9142937227,2828135.830904996,3159113.7899357858,3469014.2757046288,3759418.0987061705,10272881.50864796]
[]
[null,null,null,"Total Assets & Bank Balances",null,{"$f":"F93+F95","v":8519000},{"$f":"G93+G95","v":9512687.2775603496},9125013.8222651761,9198429.5247825049,9272001.698276395,9345718.6074236054,9100106.8970501386,9148524.5261200424,9197056.7066750657,9245694.8473538253,10272881.50864796]
[null,null,null,null,null,{"$f":"F89-F97","v":0},{"$f":"G89-G97","v":0},0,0,0,0,0,0,0,0,-7367700.5075009214]