Question: Solve the following problem (NO process, just the answers in an Excel document) Suppose you borrow $50000 when financing a coffe shop with a cost

 Solve the following problem (NO process, just the answers in an

Solve the following problem (NO process, just the answers in an Excel document) Suppose you borrow $50000 when financing a coffe shop with a cost of $65000. You expect to generate a cash flow of S65000 at the end of the year if demand is weak, $81250 if demand is as expected and $89375 if demand is strong. Each scenario is equally likely. The currert risk-free interest rate is 5% (risk of debt) and there's an 9% risk premium for the risk of the assets: 1. What should the value of the equity be? (Answer the Question in Cell A1) 2. What is the expected return? (Answer the Question in Cell B1) 3. What would be the return of equity if the demand is strong? (Answer the Question in Cell C1) 4. What would be the return of equity if the demand is weak? (Answer the Question in Cell D1) 5. What would be the expected return if you borrowed $30,000 instead? (Answer the Question in Cell E1)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!