Recent Question/Assignment

GBD230NGD, NGE
Should I Sell My Condo?
Epilogue- 2022
When Diana Mulhall resigned from the consulting firm in 2018, she agreed to stay on for a couple months to train her replacement Debbie before she moved back to Chicago. Debbie happened to be looking for a place to rent nearby. Diana agreed to rent her condo to Debbie for $2500/month.
Debbie is now married and pregnant and found a bigger place as the condo is too small. So once again, Diana must decide what to; find a new tenant or sell.
2022 market and condo information has been updated in Exhibits 5-10 of provided Excel spreadsheet.
1. Pick 3 comparables from Exhibit 8 and using the Sales Comparison Approach, determine the value of Diana’s condo today. (15 points)
a. What was your rationale in choosing the comparables?
b. Plug this value into “Current value” on your pro-forma.
c. If Diana were to sell her condo today for this value, what would be the Return on Investment (ROI) her 2013 investment?
2. Create a ten-year pro forma for the property-level cash flows using the provided Excel pro-forma template. Key variables requiring assumptions are: (15 points)
a. market rent
b. annual growth in rent* (note restriction on Exhibit 10)
c. the property’s change in cap rate for holding period
d. the property’s vacancy rate
Once assumptions are placed in the yellow cells on the pro-forma, the spreadsheet will populate.
Discuss the rationale behind all assumptions and the implied property-level return (IRR) produced.
3. Consider the assumptions you made in Q2 as a “base case.” Pick 3 variables in your analysis and discuss how changing each would have a positive or negative impact on your IRR (3 points)
4. Given your analysis, should Diana rent or sell her condo? (7 points, approx. 175 words) Your answer may incorporate;
a. Is the IRR generated in Q2 sufficient?
b. Consider the highest and best use theory; is the condo worth more as a rental than the sale price?
c. any non-financial factors (ie, demographics, foreign ownership, 3rd party information, etc.) you feel relevant.
Exhibit 1

Exhibit 2

Exhibit 3

Exhibit 4

Editable Microsoft Word Document
Word Count: 1838 words including References and Appendix
Title and Code: Assets Planning Management GBD230NGD, NGE

Editable Microsoft Excel Workbook
Worksheet Count: 1 worksheet

Editable Microsoft Excel Workbook
Worksheet Count: 7 worksheets


Buy Now at $19.99 USD
This above price is for already used answers. Please do not submit them directly as it may lead to plagiarism. Once paid, the deal will be non-refundable and there is no after-sale support for the quality or modification of the contents. Either use them for learning purpose or re-write them in your own language. If you are looking for new unused assignment, please use live chat to discuss and get best possible quote.

Looking for answers ?