PART C

USING EXCEL

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?

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 {A} {B} {C} {D} {E} {F} {G} {H} {0} {J} {K} {L} {M} {N} $35,000.00 $5,430.00 $2,000.00 $2,510.00 2.43% semi-annually 10 $43,750.00 $157,500.00 1.9% 13 $48,125.00 9 2.4%