help IP2

• I need this by Friday the latest.  This has to be in a word document.   The excel spreadsheet needs to be attached along with a word document. Word document has to be 1-2 pages.   Please only respond if you actually know something about this topic. 
•  

Please do not respond and waste each others time if you do not know anything about this.  

This class is crucial for me. 

please do not ask for additional money.  

• Assume that UPC is issuing a 10-year, $10,000 par value bond with a 6% annual coupon if its required rate of return is 6%. What is the value of this bond? Show your calculations in the Excel file.
• If the coupon rate changes to 7%, would UPC be issuing a discount or a premium bond? Show your calculations in the Excel file.
• If the coupon rate changes to 5%, would UPC be issuing a discount or a premium bond? Show your calculations in the Excel file.
• What are the values of the 5%, 6%, and 7% coupon bonds over time if the required return remained at 6%? Complete the table for years 1–8.
• Assume that UPC was successful in generating $15 million from its bond issue. Design a strategy for the financing of project C. Respond using a Word document.