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 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
Get step-by-step solutions from verified subject matter experts
