excel for account help. please show what to type in excel

2. Time Value of Money a. Create a new worksheet. i. Name the worksheet TVM ii. Complete all parts of this problem on the TVM worksheet b. Answer the following two questions on the TVM worksheet: i. Question 1: The U.S. national debt is $19,000,000,000,000 (19 trillion!). The government pays 2% interest on the debt. If the government makes a payment of $800,000,000,000 (800 billion) per year, then how many years will it take to pay off the national debt? 1. Assume that no additional money is borrowed. 2. Assume the payment is made at the beginning of each year 3. Round your answer to 2 decimal places. ii. Question 2: You buy a U.S. treasury bond for $6,300 today. In seven years, the bond matures, and the government pays you $10,000. What is the annual interest rate for the bond? 1. Assume the interest on the bond compounds at the end of each month