so i need help to complete the rest of the gold empty boxes please thats on excel
G Rame INPUTS 130,000 115.00 SON 3.0 35. ON 5.0W Gouble Area) Annual Rent Vacancy Rate Gowth Rate Operating Expenses of EG) Capital Expenditures of E) Financing Loan to Value TV Interest Rate Term Transaction Going in Cap Rate Ex Cap Rate Hold Period year Selling Expenses Discount Rate 70% 4.0 6.0 6.26 5 EN 10% $1950. DOO 097500 $1,852,500 Table 1. Value Year 1 NOI Potential Grow Income PGA) les vacancy number not Effective Gross income les Operating Expens number not) les Capital Expenditures Cast Net Operatins Income (NO) SE VINOI/C Rate Table 2. Debt Table Stabilire Value From Table Loante Value Ratio Loan Amount Equity Interest Rate trated Loan Term Monthly Debt Service use the PMT function 1491,667 70% 31994.167 SR 57.00 400% 30 595,217 1397.500) $1,708. SOO 128.491667 YAO SUDO Tablet Operating inten Potential Grow income from Table 1 Les Vacancy Effective Grou come les Operating Expenses Capital penditures Caps Net Orating Income $1852,500 4. 1970 $1,705,500 Year 2 $2.000, 500 15100229 $1.SLOTS SA 1102 $1,760,785 Year: 52068755 01014 SURA317 546. 3101.43 $1,815,015 Yeard 12180018 (3106548 SOM 277 1545,665 6196 $1.370.371 Years Year 12.11 2.264,584 331097 31110 2,085,00 2.147.555 15468650 546, 6.SI 104,737 10 $1,920,403987661 Year Year 1 $1,709,500 TA. Hafare: Cash Net Operating Income (NOI) les Debt Serve Month Before-Tex Ch Flow GTC Yew 2 51,760,70 du 5610, 187 Yew $1,815,015 011050 16727416 Yew Years $1.870,871 $1.920,403 8114 1.596 $720, 273 5785805 $566.903 $19,544.167 TC Men Doel mital Loan Amount (Table 2 Principal Paid over Years De Mortega Rance Du the CIMAL function, the art period 1, the end period is the terms tective Gros come Operating peninumber ) Cawapenditures Cape Net Operating Income NO Stab Vabre INOX/Cap Rates 51852.500 1145 17.00) $1,200 500 128411 667 Luonto Value Ratio Loan Amount Equity interest Rate wat Loan Tempel Month Debt Service use the PMT function 20 $18167 2.547.300 400N 30 395217 Year Table 1er Oglecom Potential ou income From Table 1) Vacang rective Grom income less Operating Expenses les Capdependitures Caps Operating Intame Yet 3195,000 9. SUS500 15.500 19.00 51.709.500 Yew $2,000 100 $1.00 CMS Year $2.000,795 10 S965, 317 Yw4 Years Years 52196742 10041 3109730 W.4271 120,00 147555 S. 146 546 51064 102 11,070,671,020,40307661 11.760,705 51014 11,815015 Year Table Botas Cash Net Operating Incane (NO) en Debt Service Month BenchWUTO Year 2 61,760,785 $1,709,500 Year 13.015 12 ZAID Y4 Years $1,870,871 $1920,401 MAM 1720.220 1783.00 1666,902 The Che Man minal toas Amountain lantine Remaining Martyna Balante STA, 167 der the CUMunction, the art period of the end period b the tema MO Tere Termin Sicer OVER CAR SIMON Selingen Martean maining Montagne ET Lquity Bowen - Ti li, I Canh fler Yen Yew Yes BTCF 10 Before yon Totiere To Cash Flow Table Table M Cachon Can NPV RR ra FINAL - Proforma - BLANK + Ready G Rame INPUTS 130,000 115.00 SON 3.0 35. ON 5.0W Gouble Area) Annual Rent Vacancy Rate Gowth Rate Operating Expenses of EG) Capital Expenditures of E) Financing Loan to Value TV Interest Rate Term Transaction Going in Cap Rate Ex Cap Rate Hold Period year Selling Expenses Discount Rate 70% 4.0 6.0 6.26 5 EN 10% $1950. DOO 097500 $1,852,500 Table 1. Value Year 1 NOI Potential Grow Income PGA) les vacancy number not Effective Gross income les Operating Expens number not) les Capital Expenditures Cast Net Operatins Income (NO) SE VINOI/C Rate Table 2. Debt Table Stabilire Value From Table Loante Value Ratio Loan Amount Equity Interest Rate trated Loan Term Monthly Debt Service use the PMT function 1491,667 70% 31994.167 SR 57.00 400% 30 595,217 1397.500) $1,708. SOO 128.491667 YAO SUDO Tablet Operating inten Potential Grow income from Table 1 Les Vacancy Effective Grou come les Operating Expenses Capital penditures Caps Net Orating Income $1852,500 4. 1970 $1,705,500 Year 2 $2.000, 500 15100229 $1.SLOTS SA 1102 $1,760,785 Year: 52068755 01014 SURA317 546. 3101.43 $1,815,015 Yeard 12180018 (3106548 SOM 277 1545,665 6196 $1.370.371 Years Year 12.11 2.264,584 331097 31110 2,085,00 2.147.555 15468650 546, 6.SI 104,737 10 $1,920,403987661 Year Year 1 $1,709,500 TA. Hafare: Cash Net Operating Income (NOI) les Debt Serve Month Before-Tex Ch Flow GTC Yew 2 51,760,70 du 5610, 187 Yew $1,815,015 011050 16727416 Yew Years $1.870,871 $1.920,403 8114 1.596 $720, 273 5785805 $566.903 $19,544.167 TC Men Doel mital Loan Amount (Table 2 Principal Paid over Years De Mortega Rance Du the CIMAL function, the art period 1, the end period is the terms tective Gros come Operating peninumber ) Cawapenditures Cape Net Operating Income NO Stab Vabre INOX/Cap Rates 51852.500 1145 17.00) $1,200 500 128411 667 Luonto Value Ratio Loan Amount Equity interest Rate wat Loan Tempel Month Debt Service use the PMT function 20 $18167 2.547.300 400N 30 395217 Year Table 1er Oglecom Potential ou income From Table 1) Vacang rective Grom income less Operating Expenses les Capdependitures Caps Operating Intame Yet 3195,000 9. SUS500 15.500 19.00 51.709.500 Yew $2,000 100 $1.00 CMS Year $2.000,795 10 S965, 317 Yw4 Years Years 52196742 10041 3109730 W.4271 120,00 147555 S. 146 546 51064 102 11,070,671,020,40307661 11.760,705 51014 11,815015 Year Table Botas Cash Net Operating Incane (NO) en Debt Service Month BenchWUTO Year 2 61,760,785 $1,709,500 Year 13.015 12 ZAID Y4 Years $1,870,871 $1920,401 MAM 1720.220 1783.00 1666,902 The Che Man minal toas Amountain lantine Remaining Martyna Balante STA, 167 der the CUMunction, the art period of the end period b the tema MO Tere Termin Sicer OVER CAR SIMON Selingen Martean maining Montagne ET Lquity Bowen - Ti li, I Canh fler Yen Yew Yes BTCF 10 Before yon Totiere To Cash Flow Table Table M Cachon Can NPV RR ra FINAL - Proforma - BLANK + Ready
