ANGUS CASE- please only use information from the angus case in the course pack e

ANGUS CASE- please only use information from the angus case in the course pack excel sheets and use formulas for any calculations on excel, and 2-page maximum additional writing.
Q1. Follow the example of “Alison Green”, finish Exhibit 1 to 4 for the other three properties.
Q2. Finish Exhibits 5 to 7 for “Ivy Terrace” only. Exhibit 5 can be programmed using a spreadsheet. You can follow the format used in Exhibit 5 for “Alison Green” or use the more standard format of DCF model discussed in class. In the end, we only need to compare the two properties to each other to draw some conclusions.
Q3. In general, what would you consider as the major risk for each of the four properties? (Only outlines are needed, 1-2 pages.)
each student should build a spreadsheet model for the discounted cash flow model, Angus case, or short-case format.