hi there,

could you solve this on excel and attach the screenshot with it. I need to see the excel formula also.

What is the yield to maturity of zero-coupon bond with a $8,000 face value, eleven years to maturity, and a price of $4,500

A construction company spends $2.8 million to purchase a new crane. The crane will have a capital cost allowance (CCA) rate of 40%. If the opportunity capital is 11% and the company marginal tax rate is 30%, what is the present value of the CCA tax shield? Not that the half year rule applies

An investment fund promises to pay $600 at the end of each year for 9 years in return for an initial investment of $5,100. What is the promised annual rate of return

A perpetuity will pay $3,000 per year, starting seven years after the perpetuity is purchased. What is the present value of this perpetuity on the date that it is purchased, given that the interest rate is 8%.

Sobeys is considering adding a new line of healthy frozen foods to its product mix. The new line of food will require Sobeys to spend $11 million on marketing, but Sobeys expects the new products to generate cash flow of $3million per year for the next 8 years. If its cost of capital is 9%, what is the NPV of this investment?