Homework assignment concerns written premium.

$-$Compute the total written premium for the listed policies in each year $2015-2019.$

$-$Compute the total earned premium from the listed policies in each year $2015-2019.-$Layout your work neatly in Excel in rows for the WP and EP$.$ Submit an exhibit that is at most two pages with a landscape orientation. $-$The exhibit you submit should include titles, reasonable formatting, your name, etc. Excel Sheet: Effect Date$/$ExpirationDate$/$Premium

$4/5/20154/5/2016804$

$4/5/20164/5/2017820$

$4/5/20174/5/20181,017$

$4/5/20184/5/20191,078$

$4/5/20194/5/20201,164$

$9/14/20159/14/2016520$

$9/14/20169/14/2017530$

$9/14/20179/14/2018658$

$9/14/20189/14/2019697$

$9/14/20199/14/2020753$

$6/20/20156/20/20161,191$

$6/20/20166/20/20171,215$

$6/20/20176/20/20181,506$

$6/20/20186/20/20191,597$

$6/20/20196/20/20201,724$

$7/29/20157/29/2016549$

$7/29/20167/29/2017560$

$7/29/20177/29/2018694$

$7/29/20187/29/2019736$

$7/29/20197/29/2020795$

$5/10/20155/10/20161,810$

$5/10/20165/10/20171,846$

$5/10/20175/10/20182,289$

$5/10/20185/10/20192,427$

$5/10/20195/10/20202,621$

$4/15/20154/15/20161,947$