Details of this Paper

Please assist! Using the data attached in the spre...




Please assist! Using the data attached in the spreadsheet. ?Prepare an Income Statement for each of the alternatives (Current, Hi-Tech and Broker) from the data provided. ?Compare the results of the two new alternatives to the existing operations and explain the causes for the differences (contribution margins, volumes, leverage, fixed costs, sensitivity analysis, etc.) Assume for the Hi-Tech alternative the new equipment can be leased from the manufacturer for five years at a monthly cost of $23,000 and treated as an operating lease. ?Determine the weighted average cost of capital for the existing operations and each of the two alternatives. ?Assume the equity (market) value of the company is 0.70 sales and the market value of the debt is equal to the balance sheet value. ?Compute the required rate of return on equity using the CAPM formula: the risk free rate is 3%, the market rate is 12%, the beta for existing operations is 1.5, the beta for the hi tech alternative is 1.8 and the beta for the broker alternative is 1.2. The cost of debt and the tax rate are as given in the data provided. ?Discuss the factors that affect the risk of a typical project and how they might influence a project?s risk (discount rate) versus the firm?s risk (WACC).,Question? Where is the attachment mentioned in the paper? I only received the document version. The Excel version is missing. The $23,000 (assumption) monthly cost for Hi-Tech (five years) is not highlighted in the paper. Please provide guidance!!


Paper#1707 | Written in 18-Jul-2015

Price : $25