Homework 1

Please provide answer in excel format  Please provide detailed solution and give the explanation of the concept

usiness: BUQU 1130: Business Mathematics Page 137 6. [HW] A $25,000, 10% bond redeemable at par on Dec 1, 2028, is purchased on September 25, 2017, to yield 7.6^ compounded semi-annually. Bond interest is payable semi-annually. a) What is the cash price of the bond? b) What is the accrued interest? c) What is the purchase price?

H4.

mni.3

aa.1

Give typing answer with explanation and conclusion  1- Imagine the bond above displayed the following details: $10,000 Matures: January 31, 2030; Interest of $200 payable June 30 and December 31 of each year. Can you calculate the annual effective interest rate for this bond?   a)2%   b)4%   c)6%   d)One cannot tell.

Please answer in typing format

Question 5: A Treasury Bill quotation appeared in WSJ on January 28, 2022 (Prices are for January 27, 2022) Calculate the following and show the main calculator keys in your solution. 1/26/2023 0.735 0.725 +0.095 0.741 a. Days to maturity (Keep in mind one day adjustment) b. Asked and Bid Price c. Bond Equivalent Yield (BEY) d. Effective Yield

1. Calculate the price of a bond using the Excel PV function. Bond Pricing - Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In fx Calculate Now Calculation a Calculate Sheet Function Defined Formula Library Names Auditing Options Calculation B14 fe A B D E F G 1 On January 1, Ruiz Company issued bonds as follows: 2 Face Value: 3 Number of Years: 4 Stated Interest Rate: 5 Interest payments per year 6 (Note: the bonds pay interest annually.) $ 500,000 30 7% 7 8 Required: 9 1) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all 11 function arguments as cell references. 12 13 a) Market Interest Rate: 9% 14 Annual Interest Payment: 15 Bond Selling Price: 16 17 b) Market Interest Rate: 5.5% 18 Annual Interest Payment: 19 Bond Selling Price: 20 21 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 22 23 The bond in (a)…

vvk.1

neat and clean answer needed

Help

Please correct answer and don't use hand raiting and don't use Ai solution

Solve Bond Y using Excel

Please help me understand how to answer the last equation?

A4) Finance On August 16, 2012, a bond had a market price of $8,240.66 and accrued interest of $157.95 when the market rate was 8%What is the bond's face value if it matures on May 15, 2033?

It is now June 1, 2023. Consider the following corporate bonds. Bond Bank of Naboo Bond Mongo Co. Bond Krypton Limited Bond Coupon Rate 8% ??? ??? Maturity Date June 1, 2028 January 1, 2030 June 1, 2048 Semiannual Coupon Payment Per $100 of Face Value ??? $3.00 $0 Price Per $100 of Face Value ??? ??? $22.810708 It is now June 1, 2023. Calculate the entries missing from the above table. Yield to Maturity Annual Rate, Compounded Semi-annually 5.50% 5.00% ???

ccounting-20202 Ghadna Al Maskari Section 1 / Midterm Exam 2 Spring 2021 Which of the following is right about bonds trading Select one: O a. Bond prices are quoted as a percentage of the face value O b. No interest will be paid after bond trading O c. Newspapers and the financial press publish bond prices and trading activity daily O d. Bondholders can sell their bonds, at any time, at the current market price on national securities exchanges Next page 直。 اكتب هنا ل لبحث

Assume there are five default-free bonds with the following cash flows: Bond Price today Cash Flows Year 1 $50 $200 A $48 $1265 BCDE Year 2 $94.5 $45.5 $912 $1200 $100 $50 $50 Assume that you are financially constrained and can use up to $1300 to invest initially. The arbitrage profit you can make by trading those bonds is the closest to: Year 3 A) $94 B) $33 C) Cannot be calculated on the basis of this information D) $61 Year 4 $50 $50 $1050 O,

2. Calculate the current price of the following bonds. Current date is 01 January 2020 a b C d e f Face value $1,000 $6,000 $5,000 $10,000 $1,000 $2,000 Interest, pa 4% 5% 4.50% 8% 6% 4% Required rate Coupon 5% Annually 6% Nil 6% Semi annual 6.50% Quarterly 8% Semi annual 6% Monthly Maturity 31-Dec-20 1-Jul-21 1-Jul-22 31-Dec-30 31-Dec-40 1-Jul-25

Subject - account  Please help me.  Thankyou.

A B C D E The following tables contain coupon, pricing, and other information for a series of bonds with different maturities. Bond Characteristics Settlement date Bond A 3/15/2023 Maturity date 11/14/2027 Bond B Bond C Bond D 3/15/2023 3/15/2023 3/15/2023 11/14/2027 11/14/2047 11/14/2047 Annual coupon rate 4.00% 4.00% 7.50% 7.50% Yield to maturity 5.00% 5.00% 5.00% 5.00% Redemption value (% of face value) 100 100 100 100 Coupon payments per year 1 2 1 2 Required: Note: Use cells A2 to E10 from the given information to complete this question. Using the information above, please calculate the flat (or quoted) price as well as days since last coupon, days in a coupon period, accrued interest, and finally the invoice price. All prices are expressed as percent of par. Flat price (% of par) Days since last coupon Days in coupon period Accrued interest (% of par) Invoice price (% of par) Bond A Bond B Bond C Bond D F

nku.3

If the YTM on the following bonds are identical except, what is the price of bond B?   Bond A                         Bond B  Face value                  $1,000                          $1,000  Semiannual coupon      $45                               $35 Years to maturity          20                               20 Price                             $1,098.96                     ?

Required: Note: Use cells A2 to B12 from the given information to complete this question. Using any necessary data above, calculate the Macaulay Duration of each bond. Then, use the Macaulay Duration to solve for the Modified Duration.

2 The following tables contain coupon, pricing, and other information for a series of bonds with different maturities. 3 4 Bond Characteristics 5 Settlement date 6 Maturity date 7 Annual coupon rate 8 Yield to maturity 9 Redemption value (% of face value) 10 Coupon payments per year 11 12 Required: Bond A 3/15/2023 Bond B 3/15/2023 Bond C 3/15/2023 Bond D 3/15/2023 11/14/2027 11/14/2027 11/14/2047 11/14/2047 4.00% 5.00% 100 4.00% 5.00% 100 7.50% 7.50% 5.00% 100 5.00% 100 2 13 Note: Use cells A2 to E10 from the given information to complete this question. 14 Using the information above, please calculate the flat (or quoted) price as well as days since 15 last coupon, days in a coupon period, accrued interest, and finally the invoice price. All prices are expressed as percent of par. 16 17 18 Flat price (% of par) 19 Days since last coupon 20 Days in coupon period 21 Accrued interest (% of par) 22 Invoice price (% of par) 23 Bond A Bond B Bond C Bond D