Have enough info on the Excel, just wanna know how to do the blank excels!

Thanks~

Alison Green 900 Stony Walk Number of units or square feet of rentable space 100 67,000 A Gross purchse price $ 9,600,000.00 11,500,000 B Depreciable Base $ 7,500,000.00 8,000,000 C Depreciable Life(Capital recovery period) 27.5 39 D Estimated sales price 12,500,000 14,500,000 E Estimated year of sale 10 10 F Cash flow form operations 870,200 1,057,200 G Annual increase in CFO 3% 3% H Leasehold payments 0 0 I Equity investment 3,600,000 3,500,000 J Amount of 1st mortgage 6,000,000 8,000,000 1. Interest rate 6% 6.50% 2. Term 10 10 3. Amortization period 30 20 4. Constant loan payments 7.36% 9.08% Ivy Terrace The Fowler Building 80 50,000 8,400,000 9,400,000 8,400,000 9,400,000 27.5 39 10,500,000 13,300,000 10 10 765,700 788,300 3% 4% 30,000 70,000 2,900,000 2,400,000 5,500,000 7,000,000 6% 7.50% 10 10 30 25 7.26% 8.97% First- year project setups (000s) Gross rents Vacnacies Alison Green 900 Stony walk Ivy terrace $ 1,440.00 $ 1,742.00 $ 1,296.00 $ -72.00 $ -87.10 $ -90.72 Effective gross income Real estate taxes Other operating expenses Capital reserves $ $ $ $ Cash Flow from operations Finance payments Lease payments $ $ $ Before Tax Cash Flow $ real estate Tax rate (1&2) real estate Tax rate (3&4) 1,368.00 -172.80 -300.00 -25.00 $ $ $ $ 1,205.28 120.53 -289.98 -20.00 870.20 $ -435.90 $ - $ 1,067.65 $ -726.05 $ - $ 774.77 -399.57 -30.00 434.30 $ 341.60 $ 345.20 12.00% 10.00% $ $ $ $ 1,654.90 198.59 -368.56 -20.10 The fowler building $ 1,275.00 $ -89.25 $ $ $ $ 1,185.75 118.58 -254.95 -15.00 $ $ $ 797.23 -627.97 -70.00 $ 99.25 Price/unit or Price/ rentable square foot Real estate taxes/ Gross revenue Other operating expenses/ Unit or other operating exp/square foot Other operating expenses/ Gross revenue RE taxes and operating exp/Unit or sqf Average monthly rents for apts or yearly dollars per rentable sqf of office space Actual or projected occupancy Alison Green 900 Stony Walk Ivy terrace 96,000 171.64 105000 12% 12% 10% 3000 20.80% 4728 5.5 21.16% 8.46 -3624.75 22.4% 5131.35 1200 95% 26 95% 1350 93% The Fowler Building 188 10% 5.10 20% 7.47 2.13 93% Current or projected occuoancy Added margin Break-even Occupancy Loan to value Debt Coverage ratio Alison Green 900 Stony Walk Ivy terrace 95% 95% 93% 30.16% 64.84% 62.50% 2.00 The fowler building 93% in 000s Projected Cash Flow Assumptions Cash Flow from operations: 3% growth Subtract Lease payments Subtract Financing BEFORE TAX cash flow Add amortization 6000 mortgage Add reserve Subtract depreciation 27.5 yrs Taxable income Subtract Tax payable @35% 35.00% AFTER TAX cash flow Subtract equity in Add net cash flow sale Total return Purchase price Add Capital exp. Subtract depreciation Net book Value 1 870.2 0 -435.89 434.31 2 896.31 0 -435.89 460.42 75.89 25 -272.73 262.47 91.86 80.45 25 -272.73 293.14 102.60 342.45 357.82 342.45 357.82 -3600 -3600 9600 250 2727.27 7122.73 Land Value Depreciable Base 2100 7500 Amortization Schedule Ending balance Finance charge Interest charge @6% interest rate 0 6000 Amortization 0 Sales price Net book V Gain on sale 12500 7122.73 5377.27 Depreciation taken Taxes @25% Remaining Gain Taxes @15% Total taxes 2727.27 681.82 2650 397.5 1079.32 1 5924.11 435.89 360 2 5843.66 435.89 355.45 3 5758.39 435.89 350.62 75.89 80.45 85.27 3 923.2 0 -435.89 487.31 4 950.89 0 -435.89 515 5 979.42 0 -435.89 543.53 6 1008.8 0 -435.89 572.91 7 1039.06 0 -435.89 603.17 8 1070.24 0 -435.89 634.35 85.27 25 -272.73 324.85 113.70 90.39 25 -272.73 357.66 125.18 95.81 25 -272.73 391.61 137.06 101.56 25 -272.73 426.74 149.36 107.66 25 -272.73 463.1 162.09 114.12 25 -272.73 500.74 175.26 373.61 389.82 406.47 423.55 441.09 459.09 373.61 389.82 406.47 423.55 441.09 459.09 Sales price Subtract income tax Subtract mortgage balance Net CF from sale NPV IRR 12500 1079.32 4999.66 6421.02 734.29 14.93% 4 5668 435.89 345.5 5 5572.18 435.89 340.08 6 5470.62 435.89 334.33 7 5362.96 435.89 328.24 8 5248.85 435.89 321.78 9 5127.88 435.89 314.93 90.39 95.81 101.56 107.66 114.12 120.96 9 1102.34 0 -435.89 666.45 10 1135.41 0 -435.89 699.52 120.96 25 -272.73 539.68 188.89 128.22 25 -272.73 580.01 203.00 477.56 496.52 477.56 6421.02 6917.54 10 4999.66 435.89 307.67 128.22 Equity Required Simple return measures Capitalization rate- purchase Capitalization rate- sale Cash-on-cash return (yr1) Increase in capital value Discounted return measures IRR NPV @12% Profitability index " NPV/ Initial equity" Alison Green 900 Stony walk 3,600,000 9.06% 9.08% 12.06% 30.21% 14.93% $734.29 20.40% Ivy terrace The fowler buidling Alison Green Simple return measures Capitalizaiotn rate- purchase Capitalizaiotn rate- sale Cash-on-cash Return Discounted rate od return NPV Profitibility index 900 Stony walk Ivy terrace The fowler building in 000s Alison Green Year Total Percent IRR 14.93% CF before tax Income Tax Actual Discounted Actual 1 $ 434.31 $ 377.90 $ -91.87 2 $ 460.41 $ 348.59 $ -102.60 3 $ 487.30 $ 321.03 $ -113.70 4 $ 515.00 $ 295.21 $ -125.18 5 $ 543.52 $ 271.10 $ -137.06 6 $ 572.91 $ 248.65 $ -149.36 7 $ 603.17 $ 227.78 $ -162.08 8 $ 634.34 $ 208.44 $ -175.26 9 $ 666.45 $ 190.55 $ -188.89 10 $ 699.52 $ 174.03 $ -203.00 $ 5,616.93 $ 2,663.30 $ -1,449.00 73.98% Discounted $ -79.93 $ -77.68 $ -74.90 $ -71.76 $ -68.37 $ -64.82 $ -61.21 $ -57.59 $ -54.01 $ -50.51 $ -660.77 -18.35% Futures Actual $ $ $ $ $ $ $ $ $ $ 6,421.02 $ 6,421.02 Discounted $ $ $ $ $ $ $ $ $ $ 1,597.48 $ 1,597.48 44.37% Total Actual $ 342.44 $ 357.82 $ 373.60 $ 389.82 $ 406.46 $ 423.55 $ 441.09 $ 459.09 $ 477.56 $ 6,917.53 $ 10,588.95 Discounted $ 297.97 $ 270.91 $ 246.13 $ 223.46 $ 202.74 $ 183.82 $ 166.57 $ 150.85 $ 136.54 $ 1,721.00 $ 3,600.00 100% Alison Green 900 Stony walk Ivy terrace Before tax Cash Flow 73.98% Tax benefits -18.35% Future Value 44.37% The fowler building Alison greeen 900 Stony walk Ivy terrace Return on initial cash $ 3,600.00 Recapture Mtg. Amortization $ 1,000.30 Increase in Sale price $ 2,900.00 25% Tax on depreciation $ -681.82 Capital Gains Tax on increased sales price Net cash from sale (Total) $ $ -397.50 6,420.98 The fowler building