Use the Excel Spreadsheet “Norsemen” to solve this problem….
Use the Excel Spreadsheet “Norsemen” to solve this problem. You want to help the Norsemen fund their new football stadium; the bonds are being issued today to raise the necessary funds for construction. Because the construction process is expected to be lengthy, the bonds will not make any payments until the end of the 6th year, when it will make its first semi-annual payment. It will make 29 more semi-annual payments thereafter. The bonds’ coupon rate is 7%, and par value is $1,000. How much would you pay for the bonds today if your required rate of return is 8%? Format for answer: $X,XXX.XX; round to nearest cent with no leading 0’s and with $ sign included. Only input that value and no words or other characters. Examples: $1,283.54 or $998.45. You should input the answer here and also make sure to highlight final answer in Excel.
Read DetailsIn the Excel template, use the “Peter WACC” tab. Peter Par…
In the Excel template, use the “Peter WACC” tab. Peter Parker Industries manufactures a variety of superhero weapons. The company is considering introducing a new super-charged, solar-powered, disintegration ray gun. The company’s CFO has collected the following information about the company for WACC calculation: The company has a Beta of 1.4. The risk free rate is 2.5% and the market risk premium is 7.5%. The company has 100,000 shares outstanding with a current price of $12. The company also has 10,000 shares of preferred stock outstanding with a dividend rate of 6% and a par value of $50. It is currently trading for $42.50. The company’s cost of debt is 4.0%, and the 4,000 bonds with a par value of $1,000 that are currently trading for 98.5%. The company’s tax rate is 21%. What is PP’s WACC? Format: XX.XX% with no leading 0’s.
Read DetailsBased on your knowledge of temperature tolerance in bacteria…
Based on your knowledge of temperature tolerance in bacterial species, evaluate the graph shown above. Select the appropriate classification for “Ec,” depicted with the yellow line in the graph, that describes its preferred temperature range.
Read Details