The corporate tax rate was 32 % and PSUWC currently has 1,000,000 shares of stock outstanding at a current price of $ 14.00. The company also has 30,000 bonds outstanding, with a current price of $ 937.00. The bonds pay interest semi-annually at a coupon rate of 5.70 %. The bonds have a par value of $1,000 and will mature in 23 years.

I only have a question on if my calculations for debt and equity and new debt/equity are correct thank you

1. Given the following data on proposed capital budgeting project. 0 0.648% .360% 0.910 $ $ $ Bruwe (Re-levered) $ Economic life of project in years. Price of New Equipment Change in NWC Fixed Costs Variable Costs (% of Revenue) Salvage value of New Equipment Marginal Tax Rate Generation First Year Capacity factor Capacity Factor Growth Rate Sale Price Cost of Bonds Cost of Stock 31,000,000.00 5,000,000.00 4,100,000.00 55% 7,000,000.00 32.0% 30000 kw per hour 60% 16% 0.159 per kw-hour 937.00 14.00 (Inputs Expected from you are highlighted in yellow) Parameters Rm Original Debt $ 28,110,000.00 Rf Original Equity $ 14,000,000.00 BELP (From Yahoo!) New Debt $ 8,370,000.00 BELP (Unlevered) New Equity $22.630.000,00 Re Old D/E Ratio 2.0079 Rd New D/E Ratio 0.3699 New Wd % Raised via Bonds 27.0% New We % Raised via Equity 73.0% WACC Old Wd 66.75% ELP Total Liabilities Old We 33.25% ELP Total Stockholder Equity ELP D/E Ratio Note Cells C20 and C21 include the initial (today's) cash flows. Column D through I are the operating cash flows. Cells 138-141 contain the terminal cash flows. $ $ $ Spreadsheet for determining Cash Flows Timeline: Year 1. Given the following data on proposed capital budgeting project. 0 0.648% .360% 0.910 $ $ $ Bruwe (Re-levered) $ Economic life of project in years. Price of New Equipment Change in NWC Fixed Costs Variable Costs (% of Revenue) Salvage value of New Equipment Marginal Tax Rate Generation First Year Capacity factor Capacity Factor Growth Rate Sale Price Cost of Bonds Cost of Stock 31,000,000.00 5,000,000.00 4,100,000.00 55% 7,000,000.00 32.0% 30000 kw per hour 60% 16% 0.159 per kw-hour 937.00 14.00 (Inputs Expected from you are highlighted in yellow) Parameters Rm Original Debt $ 28,110,000.00 Rf Original Equity $ 14,000,000.00 BELP (From Yahoo!) New Debt $ 8,370,000.00 BELP (Unlevered) New Equity $22.630.000,00 Re Old D/E Ratio 2.0079 Rd New D/E Ratio 0.3699 New Wd % Raised via Bonds 27.0% New We % Raised via Equity 73.0% WACC Old Wd 66.75% ELP Total Liabilities Old We 33.25% ELP Total Stockholder Equity ELP D/E Ratio Note Cells C20 and C21 include the initial (today's) cash flows. Column D through I are the operating cash flows. Cells 138-141 contain the terminal cash flows. $ $ $ Spreadsheet for determining Cash Flows Timeline: Year