please use excel thanks! clearly

The prepaid insurance account is named "1200 - Prepaid Insurance" The insurance expense account is named "5200 - Insurance Expense" The insurance policy costs $5,409 and covers the period from 10/01/2019 to 09/30/2020. The full amount of $5,409 was paid on 09/15/2019 Prepare a schedule that supports the following: Monthly expenses in 2019 for this policy Total balance in the Prepaid Insurance account as of 12/31/2019 related to this policy Total insurance expense for 2019 for this policy Assume that an auditor has requested this support for your company and that the existing Excel support was corrupted and is not recoverable. Prepare an audit support schedule that you believe will be adequate. Some ideas include formulas, formatting of dollar signs, cell borders and headers. Please include your first and last name in the top left hand corner of the worksheet. Please save your file as an Excel spreadsheet as "LastnameFirstnameExcelTest" to the Candidate Testing Documents folder on the computer desktop. The prepaid insurance account is named "1200 - Prepaid Insurance" The insurance expense account is named "5200 - Insurance Expense" The insurance policy costs $5,409 and covers the period from 10/01/2019 to 09/30/2020. The full amount of $5,409 was paid on 09/15/2019 Prepare a schedule that supports the following: Monthly expenses in 2019 for this policy Total balance in the Prepaid Insurance account as of 12/31/2019 related to this policy Total insurance expense for 2019 for this policy Assume that an auditor has requested this support for your company and that the existing Excel support was corrupted and is not recoverable. Prepare an audit support schedule that you believe will be adequate. Some ideas include formulas, formatting of dollar signs, cell borders and headers. Please include your first and last name in the top left hand corner of the worksheet. Please save your file as an Excel spreadsheet as "LastnameFirstnameExcelTest" to the Candidate Testing Documents folder on the computer desktop