im having trouble figuring out the calculations based up this information
The new Designer Shoes was expected to sell for $119 per unit and had projected sales of 4600 units in the first year, with a projected (Most-Likely scenario) 23.0% growth rate per year for subsequent years. A total investment of $1,099,000 for new equipment was required. The equipment had fixed maintenance contracts of $298,490 per year with a salvage value of $ 144,115 and variable costs were 8% of revenues. Balky also needed to consider both the Best-Case and Worst-Case scenarios in the analysis with growth rates of 33.00% and 2.30% respectively. The new equipment would be depreciated to zero using straight line depreciation. The new project required an increase in working capital of $132,310 and $15,877 of this inerease would be offset with accounts payable. PSUWC currently has 1074000 shares of stock outstanding at a current price of $78.00. Even though the company has outstanding stock, it is not publicly traded and therefore there is no publicly available financial information. However, after analysis management believes that its equity beta is 0.94. The company also has 97000 bonds outstanding, with a current price of $926.00. The bonds pay interest semi-annually at a coupon rate of 5.20%. The bonds have a par value of $1,000 and will mature in 9 years. The average corporate tax rate was 37%. Management believes the S\&P 500 is a reasonable proxy for the market portfolio. Therefore, the cost of equity is calculated using the company's equity beta and the market risk premium based on the S\&P 500 annual expected rate of return - Balky would calculate the monthly expected market return using 5 years of past monthly price data available in the worksheet Marketdata. This would then be multiplied by 12 to estimate the annual expected rate. Balky remembered that if the expected rate of return for the market was too low, too high, or negative, a forward looking rate of an historical average of about 9.5% would have to be used, as the calculated value for the current 5-year period may not be representative of the future. Balky would consider a E(Rm) between 8-12\% acceptable. Balky would calculate the market risk premium: E(Rm) - Rf from the previous calculations using the risk-free rate data available in the worksheet Marketdata. Balky noted that the risk-free rate was on an annual basis. On the "CapitalBudget" Worksheet: Step 2: Calculate the weights of Equity and Weights of Debt for the firm. Use the stock and bond data provided in the case. Step 3: Calculate the Cost of Equity for the firm. Use the CAPM and the Market data provided on on the Worksheet "MarketData". Step 4: Caleulate the Cost of Debt for the firm. Use the information provided about the firms bonds to calculate the YTM. Step 5: Calculate the after-tax cost of debt. Use the given tax nate for the firm. Step 6: Use the results from steps 2-5 to calculate the WACC (Weighted Average Cost of Capital) for the firm. Step 7: Input the appropriate Initial Cash Outlays IMPORTANT: All cash inflows need to be POSITIVE and all cash outflows need to be NEGATIVE. The new Designer Shoes was expected to sell for $119 per unit and had projected sales of 4600 units in the first year, with a projected (Most-Likely scenario) 23.0% growth rate per year for subsequent years. A total investment of $1,099,000 for new equipment was required. The equipment had fixed maintenance contracts of $298,490 per year with a salvage value of $ 144,115 and variable costs were 8% of revenues. Balky also needed to consider both the Best-Case and Worst-Case scenarios in the analysis with growth rates of 33.00% and 2.30% respectively. The new equipment would be depreciated to zero using straight line depreciation. The new project required an increase in working capital of $132,310 and $15,877 of this inerease would be offset with accounts payable. PSUWC currently has 1074000 shares of stock outstanding at a current price of $78.00. Even though the company has outstanding stock, it is not publicly traded and therefore there is no publicly available financial information. However, after analysis management believes that its equity beta is 0.94. The company also has 97000 bonds outstanding, with a current price of $926.00. The bonds pay interest semi-annually at a coupon rate of 5.20%. The bonds have a par value of $1,000 and will mature in 9 years. The average corporate tax rate was 37%. Management believes the S\&P 500 is a reasonable proxy for the market portfolio. Therefore, the cost of equity is calculated using the company's equity beta and the market risk premium based on the S\&P 500 annual expected rate of return - Balky would calculate the monthly expected market return using 5 years of past monthly price data available in the worksheet Marketdata. This would then be multiplied by 12 to estimate the annual expected rate. Balky remembered that if the expected rate of return for the market was too low, too high, or negative, a forward looking rate of an historical average of about 9.5% would have to be used, as the calculated value for the current 5-year period may not be representative of the future. Balky would consider a E(Rm) between 8-12\% acceptable. Balky would calculate the market risk premium: E(Rm) - Rf from the previous calculations using the risk-free rate data available in the worksheet Marketdata. Balky noted that the risk-free rate was on an annual basis. On the "CapitalBudget" Worksheet: Step 2: Calculate the weights of Equity and Weights of Debt for the firm. Use the stock and bond data provided in the case. Step 3: Calculate the Cost of Equity for the firm. Use the CAPM and the Market data provided on on the Worksheet "MarketData". Step 4: Caleulate the Cost of Debt for the firm. Use the information provided about the firms bonds to calculate the YTM. Step 5: Calculate the after-tax cost of debt. Use the given tax nate for the firm. Step 6: Use the results from steps 2-5 to calculate the WACC (Weighted Average Cost of Capital) for the firm. Step 7: Input the appropriate Initial Cash Outlays IMPORTANT: All cash inflows need to be POSITIVE and all cash outflows need to be NEGATIVE
