Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Excel calculations

-1

Chosen company is   Invesco assuarance company Ltd

Analyse all the risks involved with investing into a bond offering of that particular company. You should try to separate out and quantify as much of the risks as possible). At the very least, the bond duration for the offering must be computed.

The company is contemplating another bond offering in the near future. Your task is to quantify the risk premium for the company by finding the interest rate spread over an appropriate interest rate curve. The interest rates for different maturities are usually not the same and corporate bonds are usually priced with an appropriate spread over a benchmark interest rate curve, which represents the risk-free rate. You should select a proper benchmark over which to find the spread for your chosen company. Essentially you are trying to quantify the risk premium of investing into this particular company over the benchmark rates. Keep in mind that your spread should be given in basis points over the benchmark curve. Try to break down the spread into its component risk factors as much as possible. In your report, you should discuss the spread and its component risk factors as well as suggesting enhancements or modifications in reference to a plain vanilla bond offering. After calculating the spread, suggest a bond offering with a maturity date, notional amount, and coupon rate. The company has indicated that they want to issue bonds with prices close to par as possible. The maturity for the proposed bond offering cannot be the same as the maturity of any of the company's existing bonds, nor can it be closer than six months in maturity to any bonds it currently has circulating in the market.

Answer
Discuss

Discussion

Please handle this task in excel 
Shax11 (rep: 1) Mar 16, '21 at 3:51 am
Man, this is NOT a service! This is people helping each other, not doing someone else's job or homework. Please be respectful! Everyone here has other responsibilites, and no one takes a hint of an order kindly... I am leaving this thread here in case someone finds it in the future so that they can see that this is not ok in the forum - what is OK is asking for help with tasks as you try to complete them! We love to help, not take orders!

(I am not so kind in this thread as the previous one that you posted only because you keep copy/pasting and asking the same thing, even when told that it is not ok.) Next up is a ban man! C'mon, just be respectful!
don (rep: 1989) Mar 16, '21 at 10:14 am
Add to Discussion

Answers

0

Hi Shax and welcome to the Forum

This (and your similar question) feel like schoolwork. I'll be guided by the more-experienced contributors but I believe that our approach is not to do schoolwork, homework or exams for users.

The question suggests that you must have reasonable competency in Excel already but you may need some help with web import. Suggest you look in the Excel Tutorials section of the site- you may find this non-macro method Easy Excel Web Import useful and there are VBA-based solutions too.

Good luck.

Discuss

Discussion

Dear John,
Please for the first time help me to tackle this task. 
I really appreciate your service! 
Please i really need it.
Thank you for your efficiency! Really liked your service 
Shax11 (rep: 1) Mar 16, '21 at 5:42 am
Shax

Suggest you deselect my Answer- I should get no credit for not helping!

You're studying this subject (but I'm not) so I can't really help / don't know the investment risks you are meant to show knowledge of.

Perhaps someone else can/will help but good luck anyway.
John_Ru (rep: 6142) Mar 16, '21 at 6:14 am
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login