Please provide work and answers in spreadsheet format. Thank you vert much! =)

ABC Corp leases unused warehouse space to XYZ Corp for $2,500/month, payable in advance. On 9/01/2017, ABC received $30,000 of rent from XYZ for the one-year period 9/01/2017 - 8/31/2018. Determine what amount of the $30,000 rent received by ABC on 9/01/17 should be recognize in its: A. Income statement for the year ended 12/31/2017 as rent revenue B. Balance sheet on 12/31/2017 as unearned rent revenue