Hello I am needing some understanding on 13-16 using excel to show my work . I need a walk through of how to drag and auto fill,

Question 14

1/ 1pts

Excel Questions 13-16.Complete the amortization table provided in the Excel document posted in IvyLearnin the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following:

How much of the last payment goes towards the principal? Interest?

(round tothe hundredths place)

Principal: $

Interest: $

Answer 1:

596.57

Answer 2:

2.98

Question 15

1/ 1pts

Excel Questions 13-16.Complete the amortization table provided in the Excel document posted in IvyLearnin the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following:

Find the total interest paid by the end of the mortgage.

(round tothe hundredths place)

Question 16

1/ 1pts

Excel Questions 13-16.Complete the amortization table provided in the Excel document posted in IvyLearnin the homework area by setting the appropriate values for a $100,000, 30-year mortgage at 6% interest and using Excel's autofill (drag) feature to fill in the cells to the end of the mortgage period. Use this to answer the following:

How many months will it take to pay at least half of the principal?

Question 17

1/ 1pts

Excel Questions 17-20.Change the spreadsheet so that the mortgage is for 15 years rather than 30 years.

How much of the first payment goes towards the principal? Interest?

(round tothe hundredths place)

Principal: $

Interest: $

Answer 1:

343.86

Answer 2:

500

Question 18

1/ 1pts

Excel Questions 17-20.Change the spreadsheet so that the mortgage is for 15 years rather than 30 years.

How much of the last payment goes towards the principal? Interest?

(round tothe hundredths place)

Principal: $

Interest: $

Answer 1:

839.66

Answer 2:

4.20

Question 19

1/ 1pts

Excel Questions 17-20.Change the spreadsheet so that the mortgage is for 15 years rather than 30 years.

Find the total interest paid by the end of the mortgage.

(round tothe hundredths place)