Argo's real estate department is considering buying an office and leasing it out. They ask you to calculate the NPV (7% discount rate) and IRR of the investment and have given you the data below. Assume that the office is sold in year 20 and that the mortgage runs 20 years.

IMPORTANT: SHOW FORMULAS USED TO CALCULATE INSIDE BELOW TABLES

Item Value Inflator Square Footage Property Price ($) Down Payment 2,500 955,000 20% Interest Rate 4.4% Closing Costs at Start $5,000 Broker Fee in Year 20 5.5% 1.7% 3.30 1.5% Yearly Property Appreciation Rent/ sq. ft/ Inflator Op. Costs/ year ($)/ Inflator Tax Rate 9,640 1.5% 21.0% Depreciation/ year ($) 4,000 K L M N O Q R S T U V W I + 20 1 7 8 9 10 11 12 13 14 15 16 17 18 19 9 A B D E F G J 0 1 2 3 4 5 6 2 Key Assumptions 3 Square footage 4 Property price ($) 5 Down payment 6 Interest rate 7 Closing costs at start 8 Broker fee in year 20 Property Value 10 Yearly appreciation 11 Mortgage Balance 12 Net Property Value 13 Operating Assumptions 14 Rent/sq.ft. / Inflator 15 Op. costs/yr. ($) / Inflator 16 Tax rate 17 Depreciation/year ($) 18 Cash Flows 19 Rent Income 20 minus: Operating Costs 21 minus: Debt Amortization 22 plus: Interest tax shield 23 plus: Depreciation tax shield 24 minus: Initial Expenses 25 plus: Sale Property in year 20 26 Total Cash Flows 27 IRR 28 NPV @7% 29 30 Note: Tax shields are the tax gains from expensing interest or depreciation. The general formula is interest expense x tax rate for interest tax shield. 21 A B C D E G . J K L M N O R S T U 1 1 3 4 7 9 10 11 12. 13 14 15 16 17 18 19 20 2 3 Beg. Balance 4. Payment 5 Interest 6 Principal 7 Ending Balance