Reference no: EM132192399
Questions:
1.) Enter the data from the case info. detailed in this document into the XLS TEMPLATE THAT I EMAILED. Once completed, what is the Purchase Price at the stated discount rate? Insert answer here then Paste XLS on the next page
2.) What is the leveraged equity IRR?
__________________then Paste XLS on the next page
3.) Now using the most recent XLS above based on variables...
What is the terminal cap rate that results in a leveraged IRR of ZERO % (rounded).
4.) Now using the most recent XLS above ...What is the first-year cash on cash return?
5.) Now using the XLS sheet and the balance sheet tab...
What are the totals for assets, liabilities and equity. Hint...include working capital.
_____Assets = ; Liabilities total $ and equity totals.
6.) Explain the impact of ecommerce on the use and size of future Rite Aid/Walgreen stores. Then what could be the impact on this store and your returns? Explain reasoning.
7.) What are the top risks with this asset? Explain reasoning.
8.) What are the top strengths with this asset from a financial perspective? Explain reasoning.