how to show my work for these question in excel

BUSA523 Corporate Finance Assignment #2: On Weeks 4 and 5 (5 Marks) Question 1 (3 Marks) You are considering buying a 10-year bond with a 5% coupon rate (paid annually) that has been trading for exactly four years. The bond's face value is $1000. The bond is currently trading at $1118.80; assuming a 4% discount rate (EAR), answer the following questions: 1) What is the current yield on this bond? (0.5 Mark) 2) What is rate of return on this bond if you decided to hold it until maturity? (0.5 Mark) 3) What is the per period discount rate most suitable for valuing the bond given the bond's expected frequency of coupon payments? (1 Mark) 4) Would you invest in this bond? Why or why not? (1 Mark) Question 2 (2 Marks) True or False? If false, please explain. 1) The yield to maturity (YTM) is the discount rate used to calculate the fundamental value of a bond. (0.5 Mark) 2) An annuity provides a stream of cash flows for a defined period of time, while an annuity-due provides a stream of cash flows that lasts forever. (0.5 Mark) 3) If a bond's coupon rate is higher than the discount rate then the bond is expected to trade at a premium to it's face value. (0.5 Mark) 4) In general, Bond prices have an inverse relationship with interest rates; that is, when interest rates rise, bond prices fall. (0.5 Mark) Important instructions: Please follow the below instructions: Please show your work neatly and in detail (step by step) Combine all the final answers on the first page of the submitted file You may use Word, Excel or PDF as the file format Round the final answer for (%) to at least four decimal places. Ex. 0.0521563 should be written as 0.0522, or as 5.22%. Round real numbers to at least two decimal places. Ex. 120.5514 should be written as 120.55 Please collaborate with your team members only The assignment is due by 5 pm, Wednesday, Apr 27th