Download the 'Applying Excel' worksheet below and save it to your computer. View the tutorlal video, and then complete the worksheet.

Enter formulas in cells that contain question marks $($only use formulas$).$ After entering formulas in all of the cells that contain question marks, werify that the amounts match the example below.

$($a$)$ Complete the amortization schedule

$($b$)$ Record lssuance of the note

$($c$)$ Record the first installment payment

$($d$)$ Record the second linstallment payment

Change your worksheet setup so that the annual interest rate is $7\%.$ You should now have the following:

$($a$)$ Complete the amortization schedule

ff you do not get this answer, review your worksheet and formulas and try again.

Save your completed Applying Excel form to your computer and then upload it here by cllcking "Browse". Next click "Save". You will use this worksheet to answer questions in Part $2.($c$)$ Record the first installment payment

$($d$)$ Record the second installment payment "View the tutorlal, then camplete the warksheet, replacing the question marks below with formules.