microsoft excel assignments

Documentation

New Perspectives Excel 2013

Tutorial 4: SAM Project 1a

Spring Software

Create an Expense Analysis

Author:

Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

Rental Cost History

Spring Software
Rental Cost History
Location	2011	2012	2013	2014	2015	2016	Trend	Total Cost Per Location
Cambridge	$ 557,980	$ 580,299	$ 626,723	$ 689,395	$ 792,805	$ 911,725		$ 4,158,928
Waltham	$ 438,966	$ 447,745	$ 461,178	$ 475,013	$ 489,263	$ 503,941		$ 2,816,107
Framingham	$ 212,488	$ 220,988	$ 229,827	$ 239,020	$ 248,581	$ 258,524		$ 1,409,428
Nashua	$ 176,984	$ 182,294	$ 191,408	$ 199,065	$ 209,018	$ 219,469		$ 1,178,237
Total	$ 1,386,418	$ 1,431,326	$ 1,509,136	$ 1,602,493	$ 1,739,667	$ 1,893,660		$ 9,562,699

Cambridge 2011 2012 2013 2014 2015 2016 557980 580299.20000000007 626723.13600000017 689395.44960000028 792804.7670400003 911725.48209600023 Waltham 2011 2012 2013 2014 2015 2016 438966 447745.32 461177.67960000003 475013.00998800003 489263.40028764005 503941.30229626928 Framingham 2011 2012 2013 2014 2015 2016 212488 220987.52000000002 229827.02080000003 239020.10163200003 248580.90569728005 258524.14192517125 Nashua 2011 2012 2013 2014 2015 2016 176984 182293.52000000002 191408.19600000003 199064.52384000004 209017.75003200004 219468.63753360006

Rental Cost Projection

Spring Software
Rental Cost Projection
Location	2017	2018	2019	2020	2021	Trend	Total Cost Per Location
Cambridge	$ 1,021,133	$ 1,143,668	$ 1,280,909	$ 1,434,618	$ 1,606,772		$ 6,487,099
Waltham	$ 529,138	$ 555,595	$ 583,375	$ 612,544	$ 643,171		$ 2,923,823
Framingham	$ 266,280	$ 274,268	$ 282,496	$ 290,971	$ 299,700		$ 1,413,716
Nashua	$ 230,442	$ 241,964	$ 254,062	$ 266,766	$ 280,104		$ 1,273,338
Total	$ 2,046,993	$ 2,215,496	$ 2,400,842	$ 2,604,898	$ 2,829,747		$ 12,097,977

Share of Projected Rental Cost

Cambridge Waltham Framingham Nashua 6487099.1606157012 2923823.4985406604 1413715.9730337826 1273337.9000481125