AutoSave OFF A B C ... A 2 |- THE BIG PROBLEM - blank - Saved to my Mac Tell me Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments Arial v 10 ~ A a Wrap Textv General X [G SB () Paste BIU 1 - A = = = Insert - Merge & Center $ %? Delete Format Conditional Format Cell Formatting as Table Styles v Sart Filter Find a Select Analyze Date V E12 + x A D E F F H L M N C P R U x INPUTS 2.000.000 IHRX TXNK.PH 3 YEARS JUNITS 52 4 MARKET RENT (MONTHLY PERUNT 480. COD GRENT INCREASE PER YEAR 19 216000 135,721.71 GINTIAL PURCHASE PRICE 5 7 VACANCY LOSS LRT LOSS 18 1H 252H141 9 OPERATINC EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 12 ORDINARY INCOME TAX 11 COINS OUT CAP RATE 10.00 25 13 CAPITAL CUINES TAK RATE SO 14 DISCOUNT RATE 12008 16 12 INCI the sig til CARE OPTION 1 WIP her chessmongs with the Compute plan party chestie in. If it gate for lowest TCH :1 OPTION 2: 19 ASSUME YOU BOAROW AT WAXIMUM LIV, BUT YOU MUST MEET THE MINDCR 20 MUX LTV 85 BON 51,600,000 21 MIN Doll Coverage Palle DCR 1.43 1.76 22 TERM (YEARS 15 15 21 AMCI/ATAN Alex 30 15 24 INTEREST RATE Z.COM 1.50% 25 CLOSING COST: 28 ORIGINATION FEE Lender 1.00 1.00% 27 OTHER NONLENDER FEES 2 2600 S 2.500 20 UNERTING der 300 IS yan APPRAISA 2010 DI 0 BURVEY 500S 500 24 31 TOTAL CLOEING COSTS 20,600 2 19.500 32 LENDER CLOSING COSTS S 17.300 16.300 11 H SS MORTGAGE OPTION 1 ERC N PV PVT FV 37 PHTS 360 0.58% $ 1,700,000 $ (11,310) OVE EBES 200 7.12% 5 1.679.00 S (11.310) Cadillo 1.50 Oily for the 44 MORTGAGE OPTION 2 EBC N PUT PV FTAT 100.00 0.5% $ 1.600.000 $ (13.936) EBS 120.20 8.70% $$ $ 1,560,400 (18.985) 20 50 Debt Ovcrage Ratio 1.30 Quality for this man No 1 : 51 PROFORM YEAR O 56 56 -MCL 57 EGI 50 CE 59 CARX YEAR: YEAR 2 2 YEAR 3 YEAR 4 $ 40,000 $484203 $ 3 489,48 9 494 544 $ 19,200 $ (19.292) $ 19,588) $ (19.7821 $ 450,000 $4654035 470,0828 474.763 5 (54,3201 $ 180, 163) ('58,02015 1189.905 OS Abans BUCK - IT 1781 Sheet1 + Select destination and press ENTER or choose Paste E C - + 85% Auto Save OFF A PO ... THE BIG PROBLEM - blank - Saved to my Mac |- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A a Wrap Text v General X [G SB () Paste BIU 1 - A = = = - - Merge & Center Insert Delete $ %? Sart Format Y Conditional Format Cell Formatting as Table Styles Find & Select Filter Analyze Date V E12 . 3 D F H K L M N P R 8 T U x 52 S PROFCRGA 54 . 55 POI 50 CL STEG SO SELA 5 CANX B NOX 51 ng 09 5 BTCF TAXES Igen HAIDE AS be BE PURCHASE PRICE Di 00 SELLINEXPENSES 70 N 71 OME 72 ETER YEAR O YEAR 1 YEAR 2 YEAR YEAR 4 $ 430,000 $ 484 802 484 800 5 489,648 S 494.544 S $19.2001 3.302S (19 5 119.686 3 (19.782 $ $ 400,000 $ 465 400 5 470.0923 474.763 > $ 10 $ 1 1 $ 10 $ as (1,8 () ( 15 $ 4,00 $ 146.541 $ 47,00 ( 147.4761 $ 290,00232 7043 238,031 237.341 5 $("36,722) 5 185 722) 3 (36,722) 5 $94.670 $95.902 39.900 15,000 $ 21.00 $ ) 27,000 1987 $ 75 82 $ 2,000,000 2.373.614 1142.49 2,231,5 (1,644,568 587.020 (31.2211 55.05 T3 TAXES en T4 ATTR 78 NARXET NPU 77 MARKETIRA 78 TS BEFORE TAX PV 12 VUCK TAX 132 k 82 AFTER TAX NV B3 AFTER TAX IRR 34 B GOING IN GAP RATE HH CUVIA TAYLAR B2 BS NET EQUITY WLLTIPLE 91 DGF APPROACH TO VALLE 92 APPRAISER HAS ASSUMED A HOLDING PERIOD OF 3 YEARS IS APPROPRIATE 93 APARNSER HAS ASSUMED A DISCOUNT RATE OF 14.516% 19 APPROPRIATE 1 YEAR INAECHT VALUE DE DIRECT CAP APPROACH TO VALUE BT GAP RATE YEAR 2 HVA 11 YEARS 99 YEAR 2 MARKET VALLE 100 101 102 OTHER MORTGAGE INFO FOR THE HOLINING PERIOD 103 TOTAL PRINCIPAL PAID 104 TOTAL INTEREST PAD 105 LENEIDE YIELD 108 10 107 10 109 10B 19 111 Sheet1 + Ready E CU -- 85% AutoSave OFF A B C ... A 2 |- THE BIG PROBLEM - blank - Saved to my Mac Tell me Home Insert Draw Page Layout Formulas Data Review View Share 0 Comments Arial v 10 ~ A a Wrap Textv General X [G SB () Paste BIU 1 - A = = = Insert - Merge & Center $ %? Delete Format Conditional Format Cell Formatting as Table Styles v Sart Filter Find a Select Analyze Date V E12 + x A D E F F H L M N C P R U x INPUTS 2.000.000 IHRX TXNK.PH 3 YEARS JUNITS 52 4 MARKET RENT (MONTHLY PERUNT 480. COD GRENT INCREASE PER YEAR 19 216000 135,721.71 GINTIAL PURCHASE PRICE 5 7 VACANCY LOSS LRT LOSS 18 1H 252H141 9 OPERATINC EXPENSE RATIO 40% 10 CAPITAL EXPENDITURES 10% OF EGI 12 ORDINARY INCOME TAX 11 COINS OUT CAP RATE 10.00 25 13 CAPITAL CUINES TAK RATE SO 14 DISCOUNT RATE 12008 16 12 INCI the sig til CARE OPTION 1 WIP her chessmongs with the Compute plan party chestie in. If it gate for lowest TCH :1 OPTION 2: 19 ASSUME YOU BOAROW AT WAXIMUM LIV, BUT YOU MUST MEET THE MINDCR 20 MUX LTV 85 BON 51,600,000 21 MIN Doll Coverage Palle DCR 1.43 1.76 22 TERM (YEARS 15 15 21 AMCI/ATAN Alex 30 15 24 INTEREST RATE Z.COM 1.50% 25 CLOSING COST: 28 ORIGINATION FEE Lender 1.00 1.00% 27 OTHER NONLENDER FEES 2 2600 S 2.500 20 UNERTING der 300 IS yan APPRAISA 2010 DI 0 BURVEY 500S 500 24 31 TOTAL CLOEING COSTS 20,600 2 19.500 32 LENDER CLOSING COSTS S 17.300 16.300 11 H SS MORTGAGE OPTION 1 ERC N PV PVT FV 37 PHTS 360 0.58% $ 1,700,000 $ (11,310) OVE EBES 200 7.12% 5 1.679.00 S (11.310) Cadillo 1.50 Oily for the 44 MORTGAGE OPTION 2 EBC N PUT PV FTAT 100.00 0.5% $ 1.600.000 $ (13.936) EBS 120.20 8.70% $$ $ 1,560,400 (18.985) 20 50 Debt Ovcrage Ratio 1.30 Quality for this man No 1 : 51 PROFORM YEAR O 56 56 -MCL 57 EGI 50 CE 59 CARX YEAR: YEAR 2 2 YEAR 3 YEAR 4 $ 40,000 $484203 $ 3 489,48 9 494 544 $ 19,200 $ (19.292) $ 19,588) $ (19.7821 $ 450,000 $4654035 470,0828 474.763 5 (54,3201 $ 180, 163) ('58,02015 1189.905 OS Abans BUCK - IT 1781 Sheet1 + Select destination and press ENTER or choose Paste E C - + 85% Auto Save OFF A PO ... THE BIG PROBLEM - blank - Saved to my Mac |- Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial v 10 ~ A a Wrap Text v General X [G SB () Paste BIU 1 - A = = = - - Merge & Center Insert Delete $ %? Sart Format Y Conditional Format Cell Formatting as Table Styles Find & Select Filter Analyze Date V E12 . 3 D F H K L M N P R 8 T U x 52 S PROFCRGA 54 . 55 POI 50 CL STEG SO SELA 5 CANX B NOX 51 ng 09 5 BTCF TAXES Igen HAIDE AS be BE PURCHASE PRICE Di 00 SELLINEXPENSES 70 N 71 OME 72 ETER YEAR O YEAR 1 YEAR 2 YEAR YEAR 4 $ 430,000 $ 484 802 484 800 5 489,648 S 494.544 S $19.2001 3.302S (19 5 119.686 3 (19.782 $ $ 400,000 $ 465 400 5 470.0923 474.763 > $ 10 $ 1 1 $ 10 $ as (1,8 () ( 15 $ 4,00 $ 146.541 $ 47,00 ( 147.4761 $ 290,00232 7043 238,031 237.341 5 $("36,722) 5 185 722) 3 (36,722) 5 $94.670 $95.902 39.900 15,000 $ 21.00 $ ) 27,000 1987 $ 75 82 $ 2,000,000 2.373.614 1142.49 2,231,5 (1,644,568 587.020 (31.2211 55.05 T3 TAXES en T4 ATTR 78 NARXET NPU 77 MARKETIRA 78 TS BEFORE TAX PV 12 VUCK TAX 132 k 82 AFTER TAX NV B3 AFTER TAX IRR 34 B GOING IN GAP RATE HH CUVIA TAYLAR B2 BS NET EQUITY WLLTIPLE 91 DGF APPROACH TO VALLE 92 APPRAISER HAS ASSUMED A HOLDING PERIOD OF 3 YEARS IS APPROPRIATE 93 APARNSER HAS ASSUMED A DISCOUNT RATE OF 14.516% 19 APPROPRIATE 1 YEAR INAECHT VALUE DE DIRECT CAP APPROACH TO VALUE BT GAP RATE YEAR 2 HVA 11 YEARS 99 YEAR 2 MARKET VALLE 100 101 102 OTHER MORTGAGE INFO FOR THE HOLINING PERIOD 103 TOTAL PRINCIPAL PAID 104 TOTAL INTEREST PAD 105 LENEIDE YIELD 108 10 107 10 109 10B 19 111 Sheet1 + Ready E CU -- 85%