Angus Case – please only refer to the angus Cartwright case in the case pack ple

Angus Case – please only refer to the angus Cartwright case in the case pack
please use excel sheets for exhibits 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.