Desmond Corp. purchased ten $1,0006% bonds of Circuit Corporation when the market rate of interest was 14%. Interest is paid semiannually, and the bonds will mature in four years. Using the PV function in Excel B, compute the price Desmond paid (the present value) for the bond investment. (Assume that all payments of interest and principal occur at the end of the period. Round your answer to the nearest cent.) Desmond paid on the bond investment. Hodson Corp. purchased ten $1,0008% bonds of Eagle Corporation when the market rate of interest was 6%. Interest is paid semiannually, and the bonds will mature in four years. Using the PV function in Excel , compute the price Hodson paid (the present value) for the bond investment. (Assume that all payments of interest and principal occur at the end of the period. Round your answer to the nearest cent.) Hodson paid on the bond investment. You have invested in a commercial building that you are leasing to a national retail chain. The tenant has signed a 12 -year lease agreement that cannot be canceled. You expect to collect $4,000 per month for the full term of the lease. Payments occur at the end of each month. What is the present value of this investment if the interest rate is 18% and compounded monthly? (Use the PV function in Excel to calculate the answer. Do not round any intermediate calculations. Round your final present value answer to the nearest whole dollar.) The present value of this investment is You have invested in a commercial building that you are leasing to a national retail chain. The tenant has signed a 10-year lease agreement that cannot be canceled. You expect to collect $8,000 per month for the full term of the lease. Payments occur at the end of each month. What is the present value of this investment if the interest rate is 12% and compounded monthly? (Use the PV function in Excel to calculate the answer. Do not round any intermediate calculations. Round your final present value answer to the nearest whole dollar.)