please help me setting up the excel im so lost. Also how do you find npv with no discount rate do i use the irr given,9%. And is npv the maximum willingness to pay. Please help I will give thumbs up.!!

Take a look at this: You are an adviser to a private equity client who is thinking about buying this bullding. This client requires an 9% IRR after taxes are taken into account, and you are nervous because this market has shown no rent or occupancy growth for the past five years (but no declines eltherl) You anticipate a three year holding period. Note that this is not strictly speaking a triple net lease, but there are provisions for recovering expenses from the tenants. Do not worry about the differences in cost items between this pro forma and the example in class. Every one is different. Do not include items from the class example that are not included here. There are three scenarios, 1. Flat cash flows. 2. A 1% rise in cash flows each year. 3. Scenario 1, but with an increase in the vacancy rate from 5% to 20% in year 2 . (for this one, the standard formulas will not work because the cash flows are not constant, or constant growth.) What is the maximum willingness to pay for this building in each case? Provide three spreadsheets showing the pro forma for each