what is the PGI, -VCL, EGI, -OE, -CAPX, NOI, -DS, BTCF, and ATCF of -Taxes of $15,000 in Year 1

Transcribed Image Text:

4 PROFORMA 5 6 PGI 57-VCL 58 EGI 9 OE 50-CAPX 51 NO 32-DS 53 BTCF 4-TAXES (given) 55 ATCF 56 67 PURCHASE PRICE 68 69 SP B C D E F G H YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 70 SELLING EXPENSES (6%) 71 NSP 72 -OMB 73 BTER 74 TAXES (given) 75 ATER 76 77 UNLEVERAGED (TOTAL) NPV 78 UNLEVERAGED (TOTAL) IRR 79 80 BEFORE TAX NPV 81 BEFORE TAX IRRI 12 AFTER TAX NPV 04 AFTER TAX IRR 85 86 GOING IN CAP RATE 87 DEBT COVERAGE RATIO (EACH YEAR) 80 09 NET EQUITY MULTIPLE (31,221) 90 91 $ (15,000) $ (21,000) $ (27,000) 4 PROFORMA 5 6 PGI 57-VCL 58 EGI 9 OE 50-CAPX 51 NO 32-DS 53 BTCF 4-TAXES (given) 55 ATCF 56 67 PURCHASE PRICE 68 69 SP B C D E F G H YEAR 0 YEAR 1 YEAR 2 YEAR 3 YEAR 4 70 SELLING EXPENSES (6%) 71 NSP 72 -OMB 73 BTER 74 TAXES (given) 75 ATER 76 77 UNLEVERAGED (TOTAL) NPV 78 UNLEVERAGED (TOTAL) IRR 79 80 BEFORE TAX NPV 81 BEFORE TAX IRRI 12 AFTER TAX NPV 04 AFTER TAX IRR 85 86 GOING IN CAP RATE 87 DEBT COVERAGE RATIO (EACH YEAR) 80 09 NET EQUITY MULTIPLE (31,221) 90 91 $ (15,000) $ (21,000) $ (27,000)