How do I do this not in excel? Please go step by step in detail.

Thank you!

The following information relates to Questions 3 to 5 An investor plans to retire in 10 years. As part of the retirement portfolio, the investor buys a newly issued, 12-year, 8% annual coupon payment bond. The bond is purchased at par value, so its yield-to-maturity is 8.00% stated as an effective annual rate. 3. Calculate the approximate Macaulay duration for the bond, using a 1 bp (0.01%) increase and decrease in the yield-to-maturity and calculating the new prices per 100 of par value to six decimal places