Reference no: EM133311177
Assignment: Use the attached spreadsheet to answer the following questions. Note that only cells highlighted in yellow are to be filled out, the rest will pre-populate. Data from exhibits 4-6 are given to you in the attached spreadsheet. Part
1; Effective Rents ad NPV @ 10% tab (10 pts) Assuming that the appropriate discount rate for rental cash flow is 10%, what is the NPV of each anchor tenant's lease? Be sure to incorporate Tenant Improvements (TIs) and leasing commissions (LCs). What is the effective rent (including TIs and LCs) that each anchor would pay? You may assume that TIs, LCs, and the first year's rent are paid together (time 1) and that the anchor tenant fills spaces A16-19. For Walgreens, calculate these values under two different assumptions: that it vacates after the initial lease term, and that it vacates after using all five extension options. No leasing commissions will be paid after Year 25 if Walgreens exercises its options Part
2; Effective Rents and NPV @ variable % tab (10pts) . Does applying the same discount rate (10%) in part 1 seem appropriate for each potential anchor? . If not, what discount rate would you use for each tenant, why? Please explain, use this tab to reflect your answer. Part 3; Out of Pocket tab (5 pts) Suppose Clarke's only source of income comes from Tulaberry Plaza. Estimate his first-year out-of-pocket expense (if any) to sign each anchor tenant, assuming the vacant inline space remains vacant Total: 25 points Assignment Rules: This is a group assignment, worth 7.5% of your final mark . Groups of 3 students DUE: Wednesday November 16th @ 9:50am Submit assignment via blackboard, emailed assignments not accepted Every student in the group is to hand in a peer evaluation, but only 1 student per group to hand in assignment. There will be a 10% deduction for each day assignment is late, to a maximum of 2 days, then a zero will be given Seneca's Academic Integrity policy will be strictly adhered to; if your work indicates you copied from another student or from an external source, you will be reported and given a zero if found in violation, please review Seneca's policy here