Question

1 Approved Answer

Posted on Oct 03, 2024

Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial

image text in transcribed

Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property# Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 US US US US US US US US US US US US US US Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada US US US US US US US US US US US 1,939, 130 1/1/2005 2,007,417 1/1/2006 2,026,105 1/1/2007 2,591,820 1/1/2008 2,893,469 1/1/2009 3,299,651 1/1/2010 3,799,724 1/1/2011 3,838,244 1/1/2012 4,175,877 1/1/2013 4,246,340 1/1/2014 4,280,977 1/1/2015 4,287,914 1/1/2016 4,843,234 1/1/2017 4,906,557 1/1/2018 1,062,978 1/1/2000 1,032,873 1/1/2001 1,052,245 1/1/2002 1,067,507 1/1/2003 1,096,547 1/1/2004 1,109,824 1/1/2005 1,158,858 1/1/2006 1,230, 191 1/1/2007 1,241,952 1/1/2008 1,840,710 1/1/2009 1,937,798 1/1/2010 2,059,581 1/1/2011 2,079,213 1/1/2012 2,133,972 1/1/2013 2,333,776 1/1/2014 2,396,224 1/1/2015 2,503,186 1/1/2016 2,613,720 1/1/2017 2,346,875 1/1/2018 1/1/2000 1/1/2001 1/1/2002 575,614 1/1/2003 1,221,934 1/1/2004 1,793,259 1/1/2005 2,341,287 1/1/2006 2,499,775 1/1/2007 2,610,511 1/1/2008 2,639,654 1/1/2009 2,692,258 1/1/2010 (b) Summarize the NEP in the table provided in the ANS 1 tab using IF, SUM & SUMIFS functions based on the data set in question 1(a). Sum of NEP Table Location US Year Class Canada Grand Total 2000 Commercial Property 2000 Personal Property Total 2000 2001 Commercial Property 2001 Personal Property Total 2001 2002 Commercial Property 2002 Personal Property Total 2002 2003 Commercial Property 2003 Personal Property Total 2003 2004 Commercial Property 2004 Personal Property Total 2004 2005 Commercial Property 2005 Personal Property Total 2005 2006 Commercial Property 2006 Personal Property Total 2006 2007 Commercial Property 2007 Personal Property Total 2007 2008 Commercial Property Personal Property 2008 2000 Total Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Commercial Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property# Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property Personal Property 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 US US US US US US US US US US US US US US Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada Canada US US US US US US US US US US US 1,939, 130 1/1/2005 2,007,417 1/1/2006 2,026,105 1/1/2007 2,591,820 1/1/2008 2,893,469 1/1/2009 3,299,651 1/1/2010 3,799,724 1/1/2011 3,838,244 1/1/2012 4,175,877 1/1/2013 4,246,340 1/1/2014 4,280,977 1/1/2015 4,287,914 1/1/2016 4,843,234 1/1/2017 4,906,557 1/1/2018 1,062,978 1/1/2000 1,032,873 1/1/2001 1,052,245 1/1/2002 1,067,507 1/1/2003 1,096,547 1/1/2004 1,109,824 1/1/2005 1,158,858 1/1/2006 1,230, 191 1/1/2007 1,241,952 1/1/2008 1,840,710 1/1/2009 1,937,798 1/1/2010 2,059,581 1/1/2011 2,079,213 1/1/2012 2,133,972 1/1/2013 2,333,776 1/1/2014 2,396,224 1/1/2015 2,503,186 1/1/2016 2,613,720 1/1/2017 2,346,875 1/1/2018 1/1/2000 1/1/2001 1/1/2002 575,614 1/1/2003 1,221,934 1/1/2004 1,793,259 1/1/2005 2,341,287 1/1/2006 2,499,775 1/1/2007 2,610,511 1/1/2008 2,639,654 1/1/2009 2,692,258 1/1/2010 (b) Summarize the NEP in the table provided in the ANS 1 tab using IF, SUM & SUMIFS functions based on the data set in question 1(a). Sum of NEP Table Location US Year Class Canada Grand Total 2000 Commercial Property 2000 Personal Property Total 2000 2001 Commercial Property 2001 Personal Property Total 2001 2002 Commercial Property 2002 Personal Property Total 2002 2003 Commercial Property 2003 Personal Property Total 2003 2004 Commercial Property 2004 Personal Property Total 2004 2005 Commercial Property 2005 Personal Property Total 2005 2006 Commercial Property 2006 Personal Property Total 2006 2007 Commercial Property 2007 Personal Property Total 2007 2008 Commercial Property Personal Property 2008 2000 Total