Reference no: EM132165044
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?
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.
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.
Insert XLS Cash Flow Reports below...
#12
#13
|
Evaluate new business opportunities in Australia
: CSM80001 Final Assignment - The CEO has instructed you to prepare a detailed report to evaluate new business opportunities for contracts in Australia
|
|
Find expected value of the equivalent uniform annual cost
: For the data , assume that the optimistic probability is 20%, the most likely is 50%, and the pessimistic is 30%. What is the expected value of the equivalent.
|
|
Describe any notable microeconomic relationships
: In the workplace we are often asked to create "briefs". A brief provides a snapshot, or short, written summary, of a situation or event that has occurred.
|
|
How much money the man is expected to win or lose
: A man went to Atlantic City with $500 and placed 100 bets of $5 each, one after another, on the same number on the roulette wheel.
|
|
What is the leveraged equity irr
: Explain the impact of ecommerce on the use and size of future Rite Aid/Walgreen stores.
|
|
What is the expected result
: In the New Jersey and Nevada gaming casinos, craps is a popular gambling game. One of the many bets available is the "Hard-way 8."
|
|
Calculate the expected value of the construction cost
: A road between Fairbanks and Nome, Alaska, will have a most likely construction cost of $4 million per mile. Doubling this cost is considered.
|
|
Find the project probability distribution
: The construction time for a bridge depends on the weather. The project is expected to take 250 days if the weather is dry and hot.
|
|
Calculate the probability distribution for discount rate
: Over the last 10 years, the hurdle or discount rate for projects from the firm's research and development division has been 10% twice, 15% three times.
|