Chat with us, powered by LiveChat a) a Word file of their solution and (b) an Excel file of their solution. The Word file must show your work, explain your Excel calculations in detail, provide answers to the assignment ques | Wridemy

a) a Word file of their solution and (b) an Excel file of their solution. The Word file must show your work, explain your Excel calculations in detail, provide answers to the assignment ques

a) a Word file of their solution and (b) an Excel file of their solution. The Word file must show your work, explain your Excel calculations in detail, provide answers to the assignment questions, be typed, double-spaced, font size 12, and up to five pages long, excluding any exhibits you may want to attach. The Excel spreadsheet must be well organized and clearly answer the assignment questions. Your Excel calculations must be entered as formulas; do not hard code values in your answers.

This case is only for use by students in the Spring 2023 FIN311 course. You may not share with others or disseminate this case in any form or way.

Case 1 Aspis Securities, Inc.

Aspis Securities, Inc. provides financial analysis and information about publicly traded securities. You work as an analyst for Aspis. The firm’s owner, George Stein, is preparing to make a presentation to the firm’s clients and has asked you to provide some input regarding the bonds of KLX, a publically traded company. To simplify calculations, assume that it currently is January 1, 2023. Regarding KLX’s existing bonds, George wants you to concentrate on the mortgage bonds in the Table below. These bonds were issued at different times but each one of them had 20 years to maturity when first issued. KLX’s bonds pay interest semiannually, and each bond has a par value of $1000.

Table Bond Price per bond Coupon Rate Maturity Year Years to

Maturity* I $ 825.00 3.75% 2028 5 II 930.52 6.50 2033 10 III 1108.08 9.25 2038 15

* As of January 1, 2023.

Given the above information, George asked you to calculate: • The nominal annual yield to maturity (YTM) of each bond • The effective annual YTM of each bond • The current yield of each bond • The expected price of each bond on January 1, 2024, assuming interest rates do not

change • The capital gains (losses) yield of each bond for 2023, assuming interest rates do not

change • The total expected return of each bond for 2023, assuming interest rates do not change • The interest rate risk of each bond (George has asked you tabulate and graph your

results) • The yield to call for bond I, assuming it can be called after 4 years at $1010.

From past experience George knows that attendees raise several questions during his presentations. So, once he reviewed your calculations, George asked you to prepare answers to the following questions:

• Given that upon maturity each of KLX’s bonds pays $1,000, is bond I a better investment than bonds II and III?

• Which of KLX’s three bonds has the most interest rate risk? • How likely is it that KLX will call bond I?

This case is only for use by students in the Spring 2023 FIN311 course. You may not share with others or disseminate this case in any form or way.

• If interest rates do not change, what would happen to the price of each of KLX’s bonds between January 1, 2023 and the time each bond matures? George wants you to provide a graph which shows how the prices of these bonds change between now and their time to maturity.

Finally, assume the YTM of bond III remains unchanged until January 1, 2025. Consider an investor who buys bond III on January 1, 2025 and keeps it for three years. In addition, the investor deposits all coupon interest payments from the bond in a bank account that pays 3% interest (compounded semi-annually) until the end of the 3-year investment period. At the end of the 3-year period the yield on bond III is 7.2% and the investor sells the bond and closes the bank account. Calculate:

• The total amount of money the investor will have at the end of the 3-year period • The annual rate of return the investors will get from the 3-year investment in bond III.

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?

About Wridemy

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

Hire a tutor today CLICK HERE to make your first order

Related Tags

Academic APA Writing College Course Discussion Management English Finance General Graduate History Information Justify Literature MLA