If the owners choose to invest in bonds instead, they look at a {L} bond set to mature in {M} years with a bond rate of
Posted: Tue Jan 18, 2022 1:01 pm
If the owners choose to invest in bonds instead, they look at a {L} bond set to mature in {M} years with a bond rate of {N}, payable semi-annually. The market rate is {J}, compounded semi-annually. The owners will only purchase the bond if they can afford it with their savings ({H}), and they can get the bond at a discount because they think the market rate will go down, potentially making the bond more valuable in the future.
8. If the bond rate is {N}, will the bond be sold at a premium or a discount? Explain your answer.
9. Calculate the purchase price of the bond if it is purchased today ({M} years before maturity).
10. Do the owners have enough money to buy their bond? Will they make the purchase?
(Please use an Amortilization table and provide formulas used in excel)
STUDENT ID (last 6 digits only) 237264 Assignment #3: Learning O 2 3 FORMULA LIST (A) 4 5 6 D) 7 B 9 10 DATA LIST Cost of Goods Sold Equipment Renovations Other Financing Interest rate Compounding periods per year (CY) Length of amortization (years) Savings/Surplus Property and vehicle cost Mortgage rate Term of mortgage Bond face value Time until maturity Bond rate 2 SSSSSSSSS (G) (H) 11 $37,000.00 $7,260.00 $2,000.00 $2,510.00 5.55% semi-annually 6 $46,250.00 $166,500.00 4.4% 9 $50,875.00 5 2.4% 12 13 14 15 (K) {L) {M) 16 17 10 ON
8. If the bond rate is {N}, will the bond be sold at a premium or a discount? Explain your answer.
9. Calculate the purchase price of the bond if it is purchased today ({M} years before maturity).
10. Do the owners have enough money to buy their bond? Will they make the purchase?
(Please use an Amortilization table and provide formulas used in excel)
STUDENT ID (last 6 digits only) 237264 Assignment #3: Learning O 2 3 FORMULA LIST (A) 4 5 6 D) 7 B 9 10 DATA LIST Cost of Goods Sold Equipment Renovations Other Financing Interest rate Compounding periods per year (CY) Length of amortization (years) Savings/Surplus Property and vehicle cost Mortgage rate Term of mortgage Bond face value Time until maturity Bond rate 2 SSSSSSSSS (G) (H) 11 $37,000.00 $7,260.00 $2,000.00 $2,510.00 5.55% semi-annually 6 $46,250.00 $166,500.00 4.4% 9 $50,875.00 5 2.4% 12 13 14 15 (K) {L) {M) 16 17 10 ON