I have a project in finance I need done. I attached the details. There must be NO PLAGIARISM, thank you. Atleast 15 Pages in18hours
Students should familiarize themselves with bonds and/or preferred stock as an investment opportunity and as a source of funds. In this assignment, students will determine why a fixed-income security may be offered by a firm, what features it must have in order to be attractive to investors, and what kind of financial results were achieved as a result. Balance sheet accounts as well as certain ratios are to be analyzed.
Â· Papers should be 10 to 20 pages in length, 10-point font, and double-spaced; and should include a cover page, table of contents, introduction, body of the report, summary or conclusion, and works cited.
Â· Even though this is not a scientific-type writing assignment and is mostly creative in nature, references are still very important. At least six authoritative, outside references are required (anonymous authors or web pages are not acceptable). These should be listed on the last page titled “Works Cited.”
Â· Appropriate citations are required.
Â· All DeVry University policies are in effect including the plagiarism policy.
Â· Any questions about this paper may be discussed in the weekly Q & A discussion topic.
Â· This paper is worth 170 total points and will be graded on quality of research topic and paper information, use of citations, grammar, and sentence structure. See the grading rubric; this is also available in Doc Sharing.
Students should pick a company that has issued bonds in the last three years so that the Internet can provide sufficient financial data for analysis.
Post in the Journal (a) your company choice, (b) the security offered, and (c) when that security was issued. Itâ€™s suggested that you work on at least one of each of the remaining sections each week.
The final report is made up of separate sections for each milestone listed below. Each section should be approximately one page (excluding charts, graphs, etc.).
Important: When preparing your report, separate the sections with headings that are the same as the highlighted milestones below.
1. Company Background (15 points) This section should include what industry the firm is in, its products, its competitors, and the stated main reason for needing capital (to fund receivables, capacity expansion, retire older debt, etc.).
2. Balance Sheets (20 points) What did the balance sheet looked like in the quarter just prior to issuing the bonds? Include both a copy from before the issue and after the issue. Calculate at least five of the ratios shown in the Moodyâ€™s Bond Rating Chart contained in the Week 2 Lecture both before and after the bonds were issued, and discuss why you think they are important to your report.
3. Trends in YTM and Price (20 points) At what price and YTM was the initial offering sold? Tabulate the price and YTM of the issue at the end of each calendar quarter for the last six quarters. Then, plot the tabulated values to visualize the trends in YTM and prices.
4. Purpose of the Offering and Leverage (20 points) What was the planned use of the funds raised? If you canâ€™t find a specific discussion about that, then use your judgment as to why you think the funds were needed and explain your reasoning. Calculate the financial leverage before and after the offering.
5. Credit Rating (20 points) What credit rating have the bonds been given by the bond credit rating services? Research the criteria each agency uses to determine the rating. Why (or why not) do you think that recent financial statements justify the rating?
6. Rate of Return (30 points) If you were one of the original investors in this issue and you had invested $10,000, what would your total return be if you sold the securities at todayâ€™s market price? Compute the duration of the bond and its convexity currently. Add a brief discussion about your calculations.
7. Comparisons (30 points) Identify and compare pre-offering EPS and total equity $ to the most current values. Compute the firm’s current WACC assuming the total debt of the firm is in the issue that you analyzed. This means that if the company has more than one debt issue outstanding with a total face value of $X million and your chosen issue involves $Y million, then assume that all $X million is in your issue. This will simplify the calculations without diminishing learning value. Discuss at least three overall conclusions about this offering as a result of your research.
8. Comments (15 points) Please give your opinion about the value of this project to your overall learning experience in this course. Constructive comments, both positive and negative, are appreciated. Discuss at least two characteristics about this project. Please edit your report so that it is something that makes you proud.