# Finance Assignment | Professional Writing

Problem #3: A 3 year bond has semiannual coupons of 11% per annum. The continuously compounding yield is 17%. The bond has a face value of \$300. You will be pricing the bond initially, and at future times throughout the life of the bond as it pulls to par at maturity, using the same continuously compounding yield throughout. Since the yield is given with continuous compounding, the usual formulas will not work without changing the yield to the equivalent discrete frequency. Instead, string out the cash flows (each of the coupons separately plus the final redemption value) in the columns of a spreadsheet similar to the one shown here. Each row will compute the bond price at a different point in time: А Frequency-m Face syour face value> Coupon rate syour coupon rate> Yield syour yield> Redemption value Coupon 1 Coupon cash flow> Coupon 2 <coupon cash flow> Coupon 3 <coupon cash flow> etc… =C3 Time of payment 1.5 Value etc… Time of payment cyour maturity> Value Time by month Value Time of payment 0.5 Bond value Value =sum all cells to the right =sum all cells to the right =sum all cells to the right 0.08333 0.16667 0.25000 0.33333 etc…

Don't use plagiarized sources. Get Your Assignment on
Finance Assignment | Professional Writing
Just from \$13/Page

Each cell in the table is the above cash flow valued at the time in column B for that row. If the time of payment is less than the time in column B, the value is zero, otherwise discount the cash flow back to the time given in column B for that row You are to compute the value of the bond for each month in column B by adding up the outstanding cash flows along that row, each discounted from the time of its payment, back to the time at which you are valuing the bond. For the values in the table, use an “if” statement to set the value to zero if the “Time of payment” is less than the “Time by month”, otherwise discount that cash flow using the continuously compounding rate. In order to copy your “if” statement containing the formula to every cell in the table, place a “\$” in front of the column letter and/or the row number in the cell references as appropriate. What is the initial value of the bond? Problem #3: 381.19 Answer correct to 2 decimals Just Save Submit Problem #3 for Grading Attempt #2 Attempt #3 Attempt #4 Attempt #5 Problem #3 Your Answer: Your Mark: Attempt #1 381.19 0/1x

Get Finance homework help today

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Retail
Good
Customer 463469, October 18th, 2022
Outstanding work!!
Customer 460073, August 4th, 2022
Impeccable!
Customer 452441, April 3rd, 2022
Thank you very much! Efficient and professional! I was literally "blocked" since 3 days
Customer 462519, February 3rd, 2022
Excellent.
Customer 460073, June 15th, 2022
Excellent analysis.
Customer 459667, April 2nd, 2022
Human Resources Management (HRM)
Good job.
Customer 462499, June 11th, 2022
This was by far one of the best that I have received!
Customer 453375, April 22nd, 2022
Military
Very good job, thanks.
Customer 456821, December 20th, 2022
Health Care
Thank you!
Customer 454001, March 11th, 2020
English 101
Good job.
Customer 462537, April 4th, 2022
Accounting
Thank you so much for the help, with your help that provided me with more time to learn the materials and do other assignments. I wish you existed back in 2005.
Customer 453041, June 3rd, 2020
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend