Use the following information to answer the questions below. You will need Excel or a calculator You will want to follow the example in the book in Chapter 16 After-Tax Cash Flow (pgs. 308-311). To solve for the Interest Expense for year 1, I recommend using the CUMIPMT (Cumulative Interest function in Excel using 1 as the Start and 12 as the End. The April-fairy apartment community was purchased by your client for $7,500,000 with a $1,500,000 down payment and a 30-year $6,000,000 mortgage with a 4.5% rate (assume monthly payments). No points or fees were charged. Effective gross income (EGI) is expected to be $800,000 in Year 1. Operating expenses are expected to be $250,000 in Year 1. This property has 20% of value allocated to land and 80% to improvements. The owner is in a 30% income tax bracket To get full credit, you will need to select ALL of the correct responses for what the NOI, Before Tax Cash Flow, Taxable income, Income Tax, and After Tax Cash Flow are for Year 1. NOI: $550,000 NOI: 5551,000 NOI: $547,500 BTCF: $185,187 BTCF: $186,187 BTCF: $182,687 Taxable income: $63,798 Taxable income: $61,298 Taxable income: $63,898 Income Tax: $19.140 Income Tax: $16,640 Income Tax: $19.000 a ATCE: $166,047 ATCE: $163,547 ATCE: $168,047