PLEASE USE EXCEL

a. Create a new worksheet named: Debt i. Complete the entire problem on the Debt worksheet. b. Question 1: The U.S. national debt is $30,000,000,000,000 (30 trillion!). Assume that the government pays 3.25% annual interest on the debt. If the government makes a payment of 1,000,000,000,000 ( 1 trillion) at the end of each year, then how many years will it take to pay off the national debt? i. Assume that no additional money is borrowed. ii. Assume that interest is compounded only once per year. iii. In a single formula (one cell), calculate and round (using a function) your answer to 2 decimal places. c. Question 2: You buy a U.S. treasury bond for $18,700 today. In ten years, the bond matures, and the government pays you $30,000. What is the annual interest rate for the bond? i. Assume the interest on the bond compounds monthly