Use the Monsters spreadsheet to complete the following valua…
Use the Monsters spreadsheet to complete the following valuation (completely fill in the template) and use that to answer the 4 questions that follow. Monsters Incorporated (MI) is ready to launch a new product. Depending upon the success of this product, MI will have a value at the end of the year of: 20% chance of being worth $110,000,000 35% chance of being worth $145,000,000 45% change of being worth $210,000,000 The cash flows are unrelated to the state of the economy (i.e. risk from the project is diversifiable) so that the project has a beta of 0 and a cost of capital equal to the risk-free rate, which is currently 5%. Assume that the capital markets are perfect.Assume that in the event of default, 15% of the value of MI’s assets will be lost in bankruptcy costs. For the first question below, suppose that at the start of the year, MI has no debt outstanding, but has 5.6 million shares of stock outstanding. Assume MI issues debt of $150 million due next year and uses the proceeds to repurchase shares. 1. What is the initial value of equity? 2. What is the value of debt today? 3. What is the value of equity after the issuance of debt (immediately)? 4. What value was lost due to financial distress? Input the answers to the above 4 questions in order below:
Read Details