Week 5 Lab Summit Ridge Mountain Resort- Case Solution Sample

QUESTION

Scenario/Summary
Summit Ridge Mountain Resorts has decided to expand. Because of the popularity of the resort among the business community and families, Summit Ridge has decided to purchase some apartments for guests and seasonal employees to have an extended stay. Because these will prove to be a long-term investment, Summit Ridge has decided to put all complexes on a remodeling rotation to ensure the apartments each have a modern and functional style.

It is now your job to analyze the information regarding the apartments. The owners are looking for some specific information about rentals by apartment size (such as the number of bedrooms per apartment). Based on current housing interest rates, Summit Ridge is considering a sixth apartment complex and has asked you to perform some financial calculations and analyses to determine how adding this new complex to their portfolio enhances the resort’s financial position. They will then use this information to come up with a marketing plan to attract additional customers to the resort.

Remember that you are making a professional analysis and presentation, so be sure to give some thought to what you are trying to recommend to the management of Summit Ridge and why.

Deliverables
After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week5_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week5_Lab.xlsx.

The grading rubric for this assignment is available in the weekly Lab assignment page. The most successful students always review the criteria in this rubric before uploading their lab. This allows them to check that they have completed all of the steps in the lab. It is a very helpful final review prior to submission.

Lab Resources
Microsoft Office: Excel 2016
Options for Accessing Microsoft Excel 2016

Use a personal copy on your PC. You can request a copy of Microsoft Office 2016 via the Student Software Store icon on the Course Resources page.
If you are a MAC user, click to read the MAC User Information.
If you do not have Excel 2016 installed locally, then access the software by going to the Course Resources page, Lab Resources section, and click the Virtual Lab Citrix icon.
Lab Steps
Preparation
You will be using Microsoft Excel 2016 for this lab.

Be sure you have read the required chapter materials and reviewed the hands-on exercise videos located on the Lesson page before you begin the lab. The videos provide detailed examples walking you through the hands-on exercises. Applying the hands-on exercise examples will provide both practice and instruction of what to complete, but you will be completing the exact steps described below and submitting your workbook after you complete all steps.

Begin: Open and Save
Download the spreadsheet STUDENT_BIS155_W5_Lab5_Starter_File.xlsx. You will be prompted to save the file. Click yes.

Open the saved file from your Download folder on your computer.

Note: If you are using the Remote Lab environment, you will need to follow the instructions for uploading the file. These instructions can be found on the Lab page when you click on the Lab icon on Course Resources.

To save the spreadsheet with a new file name,

open the workbook in Excel 2016; and
in Excel, click File, then Save as, and rename it as lastname_first initial_Week5_Lab.xlsx (Jane Doe would save the file as Doe_J_Week5_Lab.xlsx).
Step 1: Insert Functions
Select the Search worksheet and then the Pet Deposit column. Create a formula to determine the required pet deposit for each unit. If the unit has two or more bedrooms and was remodeled after 2006, the deposit is $150; if not, it is $100.
The Recommendation column needs a nested function to indicate the remodeling status. If the apartment is unoccupied and has not been remodeled before 2006, then display “Please remodel” in the Recommendation column. Display ” ~ No Change” for apartments that do not meet the former criteria.
Make sure each field has the appropriate professional formatting for titles, headers, currency, percent, and so forth. Your worksheets need to be readable, clean, and professional. Please let spell-check work for you; use this feature to check for spelling errors.
Click Image to Expand

Step 2: Quick Search
Now that all of the rental properties are listed and organized, the owners would like to be able to search through the apartment numbers and return the price of the apartment number listed.

Insert number 1301 in cell B3. B3 is the cell that will be used to research apartment unit prices.
Create a nested lookup function in cell E3. Look up the rental price in column D using the apartment unit number in cell B3. (Use the INDEX function.)
Make sure each field has the appropriate professional formatting for titles, headers, currency, percent, and so forth. Your worksheets need to be readable, clean, and professional. Please let spell-check work for you; use this feature to check for spelling errors.
Click Image to Expand

Step 3: New Apartment Loan Amortization
Summit Ridge Ski owners want to purchase a sixth apartment complex. This decision is under review. Here are the details of their offer. The loan amount is $950,000 with a down payment of $400,000 for 30 years at 5.325%, with the first payment due on January 20, 2017. Please consider the loan calculations and build a loan amortization table on the Loan worksheet. Click on the Loan worksheet to begin.

In the Loan area (A1 through E7), enter the loan details in the Input Area based on the information provided above.  Place formulas to create all calculations in the Summary Calculations. The loan payment is at the end of the period.
Create a loan amortization table with the header row in A10 through F10. Add payment # (1 thru 360 for a 3-year loan). Use autofill to help. The Payment Date column needs a date function. The Interest Paid and Principal Payment columns require financial functions.
Format the sheet professionally and create a custom footer with your name on the left side, the page and page number in the center, and your professor’s name on the right side of each worksheet. Make sure you put the page back to normal view after you insert the footer at the bottom.

Loan Details
Step 4: Conditional Functions
In addition to adding the new apartments to their financial portfolios, the owners of Summit Ridge Ski Resort would like to ensure that they are paying their employees at market value and want to continue to encourage employees to stay with the company. Another phase of your project is to research all employee salaries to see if they have any effect on job satisfaction. Employee satisfaction surveys allow the company to get a pulse for how content employees are. A voluntary survey was administered to a cross-section sample of all employees in the company. This next bit of work will be on the Employee Satisfaction Worksheet.

Calculate the average job satisfaction for Administrative Assistant in cell H5. Format the results with the number format and two decimal positions.
Use the fill handle from cell H5 to copy the function down through the range H6:H11. Make certain to consider the appropriate mixed and/or absolute cell referencing.
Calculate the average salary of all Administrative Assistants and place the result in cell I5.
Use the fill handle from cell I5 to copy the function down through the range I6:I11. Make certain to consider the appropriate mixed and/or absolute cell referencing.
Calculate the number of Sales and Marketing Directors in cell H14 that have a job satisfaction level of 4 or above.
Calculate the average salary of Sales and Marketing Directors in cell H15 that have a job satisfaction level of 4 or above.
Use a process like that demonstrated in steps E and F to calculate the total number and the average salary of Managers that have a job satisfaction of 4 or greater.

H. Use the Employee Satisfaction data to create a Pivot Table showing the average salary and Job Satisfation by Position (rows). Format professionally and sort highest salary to lowest.

Step 5: Create a Documentation Sheet
Clean up the formatting of your Excel workbook, taking into account professional appearance.

The Minimum Requirement (per the Grading Rubric)

Insert a new spreadsheet into the workbook. The Documentation sheet should be the first sheet in the workbook.
Make certain each tab has a descriptive name and color for each tab (sheet) in the workbook.
Create the professional documentation worksheet. Be sure to include a description of each worksheet. An image is provided below.

Week 5 Documentation Sheet

Transcript
Summit Ridge Mountain Resort

Stay A While Longer Apartments

Author : Student Name
Date:

Purpose: Detailed analysis concerning Stay A While Longer Apartments

Contents:

Search: List of Rental Properties & Recommendations

Loan: Ammortization Schedule for Proposed Loan

Employee Satisfaction: Employee Satisfaction Summary Information

Employee Satisfaction Pivot Table

Finish and Submit
Save your Excel file. Make sure you are aware as to where your files are physically saved. Saving your file often is good practice (Ctrl + s).

Your Excel file should contain five worksheets.

Documentation Page
Search
Loan
Employee Satisfaction
Satisfaction Pivot Table
Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week5_Lab.xlsx.

Search

Stay a While Longer – Apartments Search              
               
Unit #     Rental Price        
               
               
Unit # Apartment Complex # Bed Rental Price Occupied Last Remodel Pet Deposit Recommendation
1101 Turning Leaf Circle 1 $765.00 Yes 2005    
1102 Turning Leaf Circle 1 $765.00 Yes 2003    
1103 Turning Leaf Circle 2 $895.00 No 1999    
1104 Turning Leaf Circle 2 $895.00 Yes 2005    
1105 Turning Leaf Circle 3 $1,225.00 No 2007    
1106 Turning Leaf Circle 3 $1,225.00 Yes 2005    
1107 Turning Leaf Circle 2 $895.00 No 2005    
1108 Turning Leaf Circle 2 $895.00 Yes 2009    
1109 Turning Leaf Circle 3 $1,225.00 No 2008    
1110 Turning Leaf Circle 3 $1,225.00 Yes 2009    
1201 Turning Leaf Circle 1 $775.00 Yes 2011    
1202 Turning Leaf Circle 1 $775.00 Yes 2010    
1203 Turning Leaf Circle 2 $875.00 Yes 2011    
1204 Turning Leaf Circle 2 $875.00 No 2011    
1205 Turning Leaf Circle 3 $1,050.00 Yes 2005    
1206 Turning Leaf Circle 3 $1,050.00 No 2005    
1207 Turning Leaf Circle 2 $875.00 Yes 2000    
1208 Turning Leaf Circle 2 $875.00 Yes 2000    
1209 Turning Leaf Circle 3 $1,050.00 No 2005    
1210 Turning Leaf Circle 3 $1,050.00 Yes 2005    
1301 Piedra Springs 1 $875.00 No 2008    
1302 Piedra Springs 1 $875.00 No 2001    
1303 Piedra Springs 1 $900.00 No 2001    
1304 Piedra Springs 1 $900.00 Yes 2001    
1305 Piedra Springs 2 $1,355.00 No 2005    
1306 Piedra Springs 2 $1,355.00 Yes 2005    
1307 Piedra Springs 2 $1,355.00 Yes 2011    
1308 Piedra Springs 2 $1,355.00 No 2011    
1401 Eagles Domain Road 1 $875.00 No 2005    
1402 Eagles Domain Road 2 $950.00 No 2011    
1403 Eagles Domain Road 3 $1,355.00 Yes 2011    
1404 Eagles Domain Road 1 $875.00 No 2011    
1405 Eagles Domain Road 2 $950.00 Yes 2011    
1406 Eagles Domain Road 3 $1,355.00 No 2002    
1407 Eagles Domain Road 2 $975.00 Yes 2002    
1408 Eagles Domain Road 2 $975.00 Yes 2002    
1501 Hickory Ridge Villas 1 $550.00 Yes 2011    
1502 Hickory Ridge Villas 1 $550.00 No 2011    
1503 Hickory Ridge Villas 1 $550.00 No 2003    
1504 Hickory Ridge Villas 1 $550.00 Yes 2001    
1505 Hickory Ridge Villas 2 $850.00 No 2003    
1506 Hickory Ridge Villas 2 $850.00 Yes 2011    
1507 Hickory Ridge Villas 2 $850.00 No 2011    
1601 Cypress Trail 1 $1,225.00 Yes 2005    
1602 Cypress Trail 1 $1,225.00 Yes 2005    
1603 Cypress Trail 2 $1,355.00 No 2005    
1604 Cypress Trail 2 $1,355.00 Yes 2011    
1605 Cypress Trail 3 $1,675.00 No 2011    
1606 Cypress Trail 3 $1,695.00 Yes 2005    
1607 Cypress Trail 3 $1,710.00 No 2005    
             

Loan

Input Area     Summary Calculations    
Complex Cost     Loan Amount    
Down Payment     No. Periods    
# of Pmts per Year     Monthly Rate    
Years     Monthly Payment    
APR     Total Interest Paid    
1st Payment Date          
           
           
Payment # Payment Date Beginning Balance Interest Paid Principal Payment Ending Balance
           
         

Employee Satisfaction

         
  Employee Statistics      
  ID Number Position Salary Job Satisfaction
  10474 Key Account Manager 35855 3
  11025 Sales Representative 41708 2
  11062 Key Account Manager 47572 3
  11653 Administrative Assistant 30176 4
  14731 Key Account Manager 45883 4
  14869 Support Specialist 32650 1
  15039 Support Specialist 32750 3
  15190 Sales Representative 45670 5
  16015 Sales & Marketing Director 89900 4
  16034 Budget Manager 55389 2
  16754 Sales Representative 49617 3
  18283 Support Specialist 35230 3
  22923 Key Account Manager 44854 2
  24168 Sales & Marketing Director 77846 3
  25280 Manager 70125 3
  27427 Budget Manager 62263 4
  30047 Administrative Assistant 30982 2
  30836 Sales & Marketing Director 84937 4
  31615 Administrative Assistant 32709 4
  33143 Key Account Manager 45983 5
  34737 Support Specialist 33501 1
  36528 Key Account Manager 48706 5
  37828 Sales Representative 45927 2
  38088 Support Specialist 31632 5
  38180 Sales Representative 49575 3
  39483 Support Specialist 37404 4
  39692 Budget Manager 65492 3
  42434 Support Specialist 35316 2
  42694 Budget Manager 68365 2
  43987 Key Account Manager 41130 4
  45418 Manager 72862 3
  45849 Support Specialist 30701 5
  46521 Budget Manager 66009 2
  47711 Manager 74767 4
  49542 Sales & Marketing Director 97159 5
Summary Information    
Position Average Satisfaction Average Salary
Administrative Assistant    
Budget Manager    
Sales & Marketing Director    
Key Account Manager    
Manager    
Sales Representative    
Support Specialist    
     
Sales & Marketing Directors with >= 4 Satisfaction    
Count    
Average Salary    
     
Managers with >= 4 Satisfaction    
Count    
Average Salary    
   

ANSWER

Documentation

Summit Ridge Mountain Resort
 
Stay A While Longer Apartments
 
Author : Julia Cooper
 
Date: 8/16/2018
 
Purpose: Detailed analysis concerning Stay A While Longer Apartments
 
Contents:
 
Search: List of Rental Properties & Recommendations
 
Loan: Ammortization Schedule for Proposed Loan
 
Employee Satisfaction: Employee Satisfaction Summary Information
 
Employee Satisfaction Pivot Table

Search

Stay a While Longer – Apartments Search              
               
Unit # 1401   Rental Price 875      
               
               
Unit # Apartment Complex # Bed Rental Price Occupied Last Remodel Pet Deposit Recommendation
1101 Turning Leaf Circle 1 $765.00 Yes 2005 100 No Change
1102 Turning Leaf Circle 1 $765.00 Yes 2003 100 No Change
1103 Turning Leaf Circle 2 $895.00 No 1999 100 No Change
1104 Turning Leaf Circle 2 $895.00 Yes 2005 100 No Change
1105 Turning Leaf Circle 3 $1,225.00 No 2007 150 Please Remodel
1106 Turning Leaf Circle 3 $1,225.00 Yes 2005 100 No Change
1107 Turning Leaf Circle 2 $895.00 No 2005 100 No Change
1108 Turning Leaf Circle 2 $895.00 Yes 2009 150 No Change
1109 Turning Leaf Circle 3 $1,225.00 No 2008 150 Please Remodel
1110 Turning Leaf Circle 3 $1,225.00 Yes 2009 150 No Change
1201 Turning Leaf Circle 1 $775.00 Yes 2011 100 No Change
1202 Turning Leaf Circle 1 $775.00 Yes 2010 100 No Change
1203 Turning Leaf Circle 2 $875.00 Yes 2011 150 No Change
1204 Turning Leaf Circle 2 $875.00 No 2011 150 Please Remodel
1205 Turning Leaf Circle 3 $1,050.00 Yes 2005 100 No Change
1206 Turning Leaf Circle 3 $1,050.00 No 2005 100 No Change
1207 Turning Leaf Circle 2 $875.00 Yes 2000 100 No Change
1208 Turning Leaf Circle 2 $875.00 Yes 2000 100 No Change
1209 Turning Leaf Circle 3 $1,050.00 No 2005 100 No Change
1210 Turning Leaf Circle 3 $1,050.00 Yes 2005 100 No Change
1301 Piedra Springs 1 $875.00 No 2008 100 Please Remodel
1302 Piedra Springs 1 $875.00 No 2001 100 No Change
1303 Piedra Springs 1 $900.00 No 2001 100 No Change
1304 Piedra Springs 1 $900.00 Yes 2001 100 No Change
1305 Piedra Springs 2 $1,355.00 No 2005 100 No Change
1306 Piedra Springs 2 $1,355.00 Yes 2005 100 No Change
1307 Piedra Springs 2 $1,355.00 Yes 2011 150 No Change
1308 Piedra Springs 2 $1,355.00 No 2011 150 Please Remodel
1401 Eagles Domain Road 1 $875.00 No 2005 100 No Change
1402 Eagles Domain Road 2 $950.00 No 2011 150 Please Remodel
1403 Eagles Domain Road 3 $1,355.00 Yes 2011 150 No Change
1404 Eagles Domain Road 1 $875.00 No 2011 100 Please Remodel
1405 Eagles Domain Road 2 $950.00 Yes 2011 150 No Change
1406 Eagles Domain Road 3 $1,355.00 No 2002 100 No Change
1407 Eagles Domain Road 2 $975.00 Yes 2002 100 No Change
1408 Eagles Domain Road 2 $975.00 Yes 2002 100 No Change
1501 Hickory Ridge Villas 1 $550.00 Yes 2011 100 No Change
1502 Hickory Ridge Villas 1 $550.00 No 2011 100 Please Remodel
1503 Hickory Ridge Villas 1 $550.00 No 2003 100 No Change
1504 Hickory Ridge Villas 1 $550.00 Yes 2001 100 No Change
1505 Hickory Ridge Villas 2 $850.00 No 2003 100 No Change
1506 Hickory Ridge Villas 2 $850.00 Yes 2011 150 No Change
1507 Hickory Ridge Villas 2 $850.00 No 2011 150 Please Remodel
1601 Cypress Trail 1 $1,225.00 Yes 2005 100 No Change
1602 Cypress Trail 1 $1,225.00 Yes 2005 100 No Change
1603 Cypress Trail 2 $1,355.00 No 2005 100 No Change
1604 Cypress Trail 2 $1,355.00 Yes 2011 150 No Change
1605 Cypress Trail 3 $1,675.00 No 2011 150 Please Remodel
1606 Cypress Trail 3 $1,695.00 Yes 2005 100 No Change
1607 Cypress Trail 3 $1,710.00 No 2005 100 No Change

Loan

Input Area     Summary Calculations  
Complex Cost $950,000.00   Loan Amount $550,000.00
Down Payment $400,000.00   No. Periods 360
# of Pmts per Year 12   Monthly Rate 0.44%
Years 30   Monthly Payment $3,062.72
APR 5.325%   Total Interest Paid $552,579.17
1st Payment Date 1/20/2017    
Payment # Payment Date Beginning Balance Interest Paid Principal Payment Ending Balance
1 1/20/2017 $550,000.00 $2,440.63 $622.09 $549,377.91
2 2/20/2017 $549,377.91 $2,437.86 $624.86 $548,753.05
3 3/20/2017 $548,753.05 $2,435.09 $627.63 $548,125.42
4 4/20/2017 $548,125.42 $2,432.31 $630.41 $547,495.01
5 5/20/2017 $547,495.01 $2,429.51 $633.21 $546,861.80
6 6/20/2017 $546,861.80 $2,426.70 $636.02 $546,225.78
7 7/20/2017 $546,225.78 $2,423.88 $638.84 $545,586.93
8 8/20/2017 $545,586.93 $2,421.04 $641.68 $544,945.26
9 9/20/2017 $544,945.26 $2,418.19 $644.53 $544,300.73
10 10/20/2017 $544,300.73 $2,415.33 $647.39 $543,653.34
11 11/20/2017 $543,653.34 $2,412.46 $650.26 $543,003.09
12 12/20/2017 $543,003.09 $2,409.58 $653.14 $542,349.94
13 1/20/2018 $542,349.94 $2,406.68 $656.04 $541,693.90
14 2/20/2018 $541,693.90 $2,403.77 $658.95 $541,034.95
15 3/20/2018 $541,034.95 $2,400.84 $661.88 $540,373.07
16 4/20/2018 $540,373.07 $2,397.91 $664.81 $539,708.26
17 5/20/2018 $539,708.26 $2,394.96 $667.76 $539,040.49
18 6/20/2018 $539,040.49 $2,391.99 $670.73 $538,369.76
19 7/20/2018 $538,369.76 $2,389.02 $673.70 $537,696.06
20 8/20/2018 $537,696.06 $2,386.03 $676.69 $537,019.37
21 9/20/2018 $537,019.37 $2,383.02 $679.70 $536,339.67
22 10/20/2018 $536,339.67 $2,380.01 $682.71 $535,656.96
23 11/20/2018 $535,656.96 $2,376.98 $685.74 $534,971.21
24 12/20/2018 $534,971.21 $2,373.93 $688.79 $534,282.43
25 1/20/2019 $534,282.43 $2,370.88 $691.84 $533,590.59
26 2/20/2019 $533,590.59 $2,367.81 $694.91 $532,895.68
27 3/20/2019 $532,895.68 $2,364.72 $698.00 $532,197.68
28 4/20/2019 $532,197.68 $2,361.63 $701.09 $531,496.59
29 5/20/2019 $531,496.59 $2,358.52 $704.20 $530,792.38
30 6/20/2019 $530,792.38 $2,355.39 $707.33 $530,085.06
31 7/20/2019 $530,085.06 $2,352.25 $710.47 $529,374.59
32 8/20/2019 $529,374.59 $2,349.10 $713.62 $528,660.97
33 9/20/2019 $528,660.97 $2,345.93 $716.79 $527,944.18
34 10/20/2019 $527,944.18 $2,342.75 $719.97 $527,224.21
35 11/20/2019 $527,224.21 $2,339.56 $723.16 $526,501.05
36 12/20/2019 $526,501.05 $2,336.35 $726.37 $525,774.68
37 1/20/2020 $525,774.68 $2,333.13 $729.59 $525,045.09
38 2/20/2020 $525,045.09 $2,329.89 $732.83 $524,312.25
39 3/20/2020 $524,312.25 $2,326.64 $736.08 $523,576.17
40 4/20/2020 $523,576.17 $2,323.37 $739.35 $522,836.82
41 5/20/2020 $522,836.82 $2,320.09 $742.63 $522,094.19
42 6/20/2020 $522,094.19 $2,316.79 $745.93 $521,348.26
43 7/20/2020 $521,348.26 $2,313.48 $749.24 $520,599.02
44 8/20/2020 $520,599.02 $2,310.16 $752.56 $519,846.46
45 9/20/2020 $519,846.46 $2,306.82 $755.90 $519,090.56
46 10/20/2020 $519,090.56 $2,303.46 $759.26 $518,331.30
47 11/20/2020 $518,331.30 $2,300.10 $762.62 $517,568.68
48 12/20/2020 $517,568.68 $2,296.71 $766.01 $516,802.67
49 1/20/2021 $516,802.67 $2,293.31 $769.41 $516,033.26
50 2/20/2021 $516,033.26 $2,289.90 $772.82 $515,260.44
51 3/20/2021 $515,260.44 $2,286.47 $776.25 $514,484.19
52 4/20/2021 $514,484.19 $2,283.02 $779.70 $513,704.49
53 5/20/2021 $513,704.49 $2,279.56 $783.16 $512,921.34
54 6/20/2021 $512,921.34 $2,276.09 $786.63 $512,134.70
55 7/20/2021 $512,134.70 $2,272.60 $790.12 $511,344.58
56 8/20/2021 $511,344.58 $2,269.09 $793.63 $510,550.95
57 9/20/2021 $510,550.95 $2,265.57 $797.15 $509,753.80
58 10/20/2021 $509,753.80 $2,262.03 $800.69 $508,953.12
59 11/20/2021 $508,953.12 $2,258.48 $804.24 $508,148.88
60 12/20/2021 $508,148.88 $2,254.91 $807.81 $507,341.07
61 1/20/2022 $507,341.07 $2,251.33 $811.39 $506,529.67
62 2/20/2022 $506,529.67 $2,247.73 $814.99 $505,714.68
63 3/20/2022 $505,714.68 $2,244.11 $818.61 $504,896.07
64 4/20/2022 $504,896.07 $2,240.48 $822.24 $504,073.82
65 5/20/2022 $504,073.82 $2,236.83 $825.89 $503,247.93
66 6/20/2022 $503,247.93 $2,233.16 $829.56 $502,418.37
67 7/20/2022 $502,418.37 $2,229.48 $833.24 $501,585.14
68 8/20/2022 $501,585.14 $2,225.78 $836.94 $500,748.20
69 9/20/2022 $500,748.20 $2,222.07 $840.65 $499,907.55
70 10/20/2022 $499,907.55 $2,218.34 $844.38 $499,063.17
71 11/20/2022 $499,063.17 $2,214.59 $848.13 $498,215.04
72 12/20/2022 $498,215.04 $2,210.83 $851.89 $497,363.15
73 1/20/2023 $497,363.15 $2,207.05 $855.67 $496,507.48
74 2/20/2023 $496,507.48 $2,203.25 $859.47 $495,648.01
75 3/20/2023 $495,648.01 $2,199.44 $863.28 $494,784.73
76 4/20/2023 $494,784.73 $2,195.61 $867.11 $493,917.62
77 5/20/2023 $493,917.62 $2,191.76 $870.96 $493,046.66
78 6/20/2023 $493,046.66 $2,187.89 $874.83 $492,171.83
79 7/20/2023 $492,171.83 $2,184.01 $878.71 $491,293.13
80 8/20/2023 $491,293.13 $2,180.11 $882.61 $490,410.52
81 9/20/2023 $490,410.52 $2,176.20 $886.52 $489,524.00
82 10/20/2023 $489,524.00 $2,172.26 $890.46 $488,633.54
83 11/20/2023 $488,633.54 $2,168.31 $894.41 $487,739.13
84 12/20/2023 $487,739.13 $2,164.34 $898.38 $486,840.75
85 1/20/2024 $486,840.75 $2,160.36 $902.36 $485,938.39
86 2/20/2024 $485,938.39 $2,156.35 $906.37 $485,032.02
87 3/20/2024 $485,032.02 $2,152.33 $910.39 $484,121.63
88 4/20/2024 $484,121.63 $2,148.29 $914.43 $483,207.20
89 5/20/2024 $483,207.20 $2,144.23 $918.49 $482,288.71
90 6/20/2024 $482,288.71 $2,140.16 $922.56 $481,366.15
91 7/20/2024 $481,366.15 $2,136.06 $926.66 $480,439.49
92 8/20/2024 $480,439.49 $2,131.95 $930.77 $479,508.72
93 9/20/2024 $479,508.72 $2,127.82 $934.90 $478,573.82
94 10/20/2024 $478,573.82 $2,123.67 $939.05 $477,634.77
95 11/20/2024 $477,634.77 $2,119.50 $943.22 $476,691.56
96 12/20/2024 $476,691.56 $2,115.32 $947.40 $475,744.16
97 1/20/2025 $475,744.16 $2,111.11 $951.61 $474,792.55
98 2/20/2025 $474,792.55 $2,106.89 $955.83 $473,836.72
99 3/20/2025 $473,836.72 $2,102.65 $960.07 $472,876.65
100 4/20/2025 $472,876.65 $2,098.39 $964.33 $471,912.32
101 5/20/2025 $471,912.32 $2,094.11 $968.61 $470,943.71
102 6/20/2025 $470,943.71 $2,089.81 $972.91 $469,970.81
103 7/20/2025 $469,970.81 $2,085.50 $977.22 $468,993.58
104 8/20/2025 $468,993.58 $2,081.16 $981.56 $468,012.02
105 9/20/2025 $468,012.02 $2,076.80 $985.92 $467,026.10
106 10/20/2025 $467,026.10 $2,072.43 $990.29 $466,035.81
107 11/20/2025 $466,035.81 $2,068.03 $994.69 $465,041.13
108 12/20/2025 $465,041.13 $2,063.62 $999.10 $464,042.03
109 1/20/2026 $464,042.03 $2,059.19 $1,003.53 $463,038.49
110 2/20/2026 $463,038.49 $2,054.73 $1,007.99 $462,030.51
111 3/20/2026 $462,030.51 $2,050.26 $1,012.46 $461,018.05
112 4/20/2026 $461,018.05 $2,045.77 $1,016.95 $460,001.10
113 5/20/2026 $460,001.10 $2,041.25 $1,021.47 $458,979.63
114 6/20/2026 $458,979.63 $2,036.72 $1,026.00 $457,953.63
115 7/20/2026 $457,953.63 $2,032.17 $1,030.55 $456,923.08
116 8/20/2026 $456,923.08 $2,027.60 $1,035.12 $455,887.96
117 9/20/2026 $455,887.96 $2,023.00 $1,039.72 $454,848.24
118 10/20/2026 $454,848.24 $2,018.39 $1,044.33 $453,803.91
119 11/20/2026 $453,803.91 $2,013.75 $1,048.97 $452,754.95
120 12/20/2026 $452,754.95 $2,009.10 $1,053.62 $451,701.33
121 1/20/2027 $451,701.33 $2,004.42 $1,058.30 $450,643.03
122 2/20/2027 $450,643.03 $1,999.73 $1,062.99 $449,580.04
123 3/20/2027 $449,580.04 $1,995.01 $1,067.71 $448,512.33
124 4/20/2027 $448,512.33 $1,990.27 $1,072.45 $447,439.88
125 5/20/2027 $447,439.88 $1,985.51 $1,077.21 $446,362.68
126 6/20/2027 $446,362.68 $1,980.73 $1,081.99 $445,280.69
127 7/20/2027 $445,280.69 $1,975.93 $1,086.79 $444,193.91
128 8/20/2027 $444,193.91 $1,971.11 $1,091.61 $443,102.30
129 9/20/2027 $443,102.30 $1,966.27 $1,096.45 $442,005.84
130 10/20/2027 $442,005.84 $1,961.40 $1,101.32 $440,904.52
131 11/20/2027 $440,904.52 $1,956.51 $1,106.21 $439,798.32
132 12/20/2027 $439,798.32 $1,951.61 $1,111.11 $438,687.20
133 1/20/2028 $438,687.20 $1,946.67 $1,116.05 $437,571.16
134 2/20/2028 $437,571.16 $1,941.72 $1,121.00 $436,450.16
135 3/20/2028 $436,450.16 $1,936.75 $1,125.97 $435,324.19
136 4/20/2028 $435,324.19 $1,931.75 $1,130.97 $434,193.22
137 5/20/2028 $434,193.22 $1,926.73 $1,135.99 $433,057.23
138 6/20/2028 $433,057.23 $1,921.69 $1,141.03 $431,916.20
139 7/20/2028 $431,916.20 $1,916.63 $1,146.09 $430,770.11
140 8/20/2028 $430,770.11 $1,911.54 $1,151.18 $429,618.93
141 9/20/2028 $429,618.93 $1,906.43 $1,156.29 $428,462.65
142 10/20/2028 $428,462.65 $1,901.30 $1,161.42 $427,301.23
143 11/20/2028 $427,301.23 $1,896.15 $1,166.57 $426,134.66
144 12/20/2028 $426,134.66 $1,890.97 $1,171.75 $424,962.91
145 1/20/2029 $424,962.91 $1,885.77 $1,176.95 $423,785.97
146 2/20/2029 $423,785.97 $1,880.55 $1,182.17 $422,603.80
147 3/20/2029 $422,603.80 $1,875.30 $1,187.42 $421,416.38
148 4/20/2029 $421,416.38 $1,870.04 $1,192.68 $420,223.70
149 5/20/2029 $420,223.70 $1,864.74 $1,197.98 $419,025.72
150 6/20/2029 $419,025.72 $1,859.43 $1,203.29 $417,822.43
151 7/20/2029 $417,822.43 $1,854.09 $1,208.63 $416,613.79
152 8/20/2029 $416,613.79 $1,848.72 $1,214.00 $415,399.80
153 9/20/2029 $415,399.80 $1,843.34 $1,219.38 $414,180.41
154 10/20/2029 $414,180.41 $1,837.93 $1,224.79 $412,955.62
155 11/20/2029 $412,955.62 $1,832.49 $1,230.23 $411,725.39
156 12/20/2029 $411,725.39 $1,827.03 $1,235.69 $410,489.70
157 1/20/2030 $410,489.70 $1,821.55 $1,241.17 $409,248.53
158 2/20/2030 $409,248.53 $1,816.04 $1,246.68 $408,001.85
159 3/20/2030 $408,001.85 $1,810.51 $1,252.21 $406,749.64
160 4/20/2030 $406,749.64 $1,804.95 $1,257.77 $405,491.87
161 5/20/2030 $405,491.87 $1,799.37 $1,263.35 $404,228.52
162 6/20/2030 $404,228.52 $1,793.76 $1,268.96 $402,959.56
163 7/20/2030 $402,959.56 $1,788.13 $1,274.59 $401,684.98
164 8/20/2030 $401,684.98 $1,782.48 $1,280.24 $400,404.73
165 9/20/2030 $400,404.73 $1,776.80 $1,285.92 $399,118.81
166 10/20/2030 $399,118.81 $1,771.09 $1,291.63 $397,827.18
167 11/20/2030 $397,827.18 $1,765.36 $1,297.36 $396,529.82
168 12/20/2030 $396,529.82 $1,759.60 $1,303.12 $395,226.70
169 1/20/2031 $395,226.70 $1,753.82 $1,308.90 $393,917.80
170 2/20/2031 $393,917.80 $1,748.01 $1,314.71 $392,603.09
171 3/20/2031 $392,603.09 $1,742.18 $1,320.54 $391,282.54
172 4/20/2031 $391,282.54 $1,736.32 $1,326.40 $389,956.14
173 5/20/2031 $389,956.14 $1,730.43 $1,332.29 $388,623.85
174 6/20/2031 $388,623.85 $1,724.52 $1,338.20 $387,285.65
175 7/20/2031 $387,285.65 $1,718.58 $1,344.14 $385,941.51
176 8/20/2031 $385,941.51 $1,712.62 $1,350.10 $384,591.41
177 9/20/2031 $384,591.41 $1,706.62 $1,356.10 $383,235.31
178 10/20/2031 $383,235.31 $1,700.61 $1,362.11 $381,873.20
179 11/20/2031 $381,873.20 $1,694.56 $1,368.16 $380,505.04
180 12/20/2031 $380,505.04 $1,688.49 $1,374.23 $379,130.81
181 1/20/2032 $379,130.81 $1,682.39 $1,380.33 $377,750.48
182 2/20/2032 $377,750.48 $1,676.27 $1,386.45 $376,364.03
183 3/20/2032 $376,364.03 $1,670.12 $1,392.60 $374,971.43
184 4/20/2032 $374,971.43 $1,663.94 $1,398.78 $373,572.64
185 5/20/2032 $373,572.64 $1,657.73 $1,404.99 $372,167.65
186 6/20/2032 $372,167.65 $1,651.49 $1,411.23 $370,756.43
187 7/20/2032 $370,756.43 $1,645.23 $1,417.49 $369,338.94
188 8/20/2032 $369,338.94 $1,638.94 $1,423.78 $367,915.16
189 9/20/2032 $367,915.16 $1,632.62 $1,430.10 $366,485.06
190 10/20/2032 $366,485.06 $1,626.28 $1,436.44 $365,048.62
191 11/20/2032 $365,048.62 $1,619.90 $1,442.82 $363,605.80
192 12/20/2032 $363,605.80 $1,613.50 $1,449.22 $362,156.58
193 1/20/2033 $362,156.58 $1,607.07 $1,455.65 $360,700.93
194 2/20/2033 $360,700.93 $1,600.61 $1,462.11 $359,238.82
195 3/20/2033 $359,238.82 $1,594.12 $1,468.60 $357,770.23
196 4/20/2033 $357,770.23 $1,587.61 $1,475.11 $356,295.11
197 5/20/2033 $356,295.11 $1,581.06 $1,481.66 $354,813.45
198 6/20/2033 $354,813.45 $1,574.48 $1,488.24 $353,325.22
199 7/20/2033 $353,325.22 $1,567.88 $1,494.84 $351,830.38
200 8/20/2033 $351,830.38 $1,561.25 $1,501.47 $350,328.90
201 9/20/2033 $350,328.90 $1,554.58 $1,508.14 $348,820.77
202 10/20/2033 $348,820.77 $1,547.89 $1,514.83 $347,305.94
203 11/20/2033 $347,305.94 $1,541.17 $1,521.55 $345,784.39
204 12/20/2033 $345,784.39 $1,534.42 $1,528.30 $344,256.09
205 1/20/2034 $344,256.09 $1,527.64 $1,535.08 $342,721.01
206 2/20/2034 $342,721.01 $1,520.82 $1,541.90 $341,179.11
207 3/20/2034 $341,179.11 $1,513.98 $1,548.74 $339,630.37
208 4/20/2034 $339,630.37 $1,507.11 $1,555.61 $338,074.76
209 5/20/2034 $338,074.76 $1,500.21 $1,562.51 $336,512.25
210 6/20/2034 $336,512.25 $1,493.27 $1,569.45 $334,942.80
211 7/20/2034 $334,942.80 $1,486.31 $1,576.41 $333,366.39
212 8/20/2034 $333,366.39 $1,479.31 $1,583.41 $331,782.99
213 9/20/2034 $331,782.99 $1,472.29 $1,590.43 $330,192.55
214 10/20/2034 $330,192.55 $1,465.23 $1,597.49 $328,595.06
215 11/20/2034 $328,595.06 $1,458.14 $1,604.58 $326,990.48
216 12/20/2034 $326,990.48 $1,451.02 $1,611.70 $325,378.78
217 1/20/2035 $325,378.78 $1,443.87 $1,618.85 $323,759.93
218 2/20/2035 $323,759.93 $1,436.68 $1,626.04 $322,133.90
219 3/20/2035 $322,133.90 $1,429.47 $1,633.25 $320,500.65
220 4/20/2035 $320,500.65 $1,422.22 $1,640.50 $318,860.15
221 5/20/2035 $318,860.15 $1,414.94 $1,647.78 $317,212.37
222 6/20/2035 $317,212.37 $1,407.63 $1,655.09 $315,557.28
223 7/20/2035 $315,557.28 $1,400.29 $1,662.43 $313,894.85
224 8/20/2035 $313,894.85 $1,392.91 $1,669.81 $312,225.03
225 9/20/2035 $312,225.03 $1,385.50 $1,677.22 $310,547.81
226 10/20/2035 $310,547.81 $1,378.06 $1,684.66 $308,863.15
227 11/20/2035 $308,863.15 $1,370.58 $1,692.14 $307,171.01
228 12/20/2035 $307,171.01 $1,363.07 $1,699.65 $305,471.36
229 1/20/2036 $305,471.36 $1,355.53 $1,707.19 $303,764.17
230 2/20/2036 $303,764.17 $1,347.95 $1,714.77 $302,049.40
231 3/20/2036 $302,049.40 $1,340.34 $1,722.38 $300,327.03
232 4/20/2036 $300,327.03 $1,332.70 $1,730.02 $298,597.01
233 5/20/2036 $298,597.01 $1,325.02 $1,737.70 $296,859.31
234 6/20/2036 $296,859.31 $1,317.31 $1,745.41 $295,113.91
235 7/20/2036 $295,113.91 $1,309.57 $1,753.15 $293,360.75
236 8/20/2036 $293,360.75 $1,301.79 $1,760.93 $291,599.82
237 9/20/2036 $291,599.82 $1,293.97 $1,768.75 $289,831.08
238 10/20/2036 $289,831.08 $1,286.13 $1,776.59 $288,054.48
239 11/20/2036 $288,054.48 $1,278.24 $1,784.48 $286,270.00
240 12/20/2036 $286,270.00 $1,270.32 $1,792.40 $284,477.61
241 1/20/2037 $284,477.61 $1,262.37 $1,800.35 $282,677.26
242 2/20/2037 $282,677.26 $1,254.38 $1,808.34 $280,868.92
243 3/20/2037 $280,868.92 $1,246.36 $1,816.36 $279,052.55
244 4/20/2037 $279,052.55 $1,238.30 $1,824.42 $277,228.13
245 5/20/2037 $277,228.13 $1,230.20 $1,832.52 $275,395.61
246 6/20/2037 $275,395.61 $1,222.07 $1,840.65 $273,554.96
247 7/20/2037 $273,554.96 $1,213.90 $1,848.82 $271,706.14
248 8/20/2037 $271,706.14 $1,205.70 $1,857.02 $269,849.11
249 9/20/2037 $269,849.11 $1,197.46 $1,865.26 $267,983.85
250 10/20/2037 $267,983.85 $1,189.18 $1,873.54 $266,110.31
251 11/20/2037 $266,110.31 $1,180.86 $1,881.86 $264,228.45
252 12/20/2037 $264,228.45 $1,172.51 $1,890.21 $262,338.25
253 1/20/2038 $262,338.25 $1,164.13 $1,898.59 $260,439.65
254 2/20/2038 $260,439.65 $1,155.70 $1,907.02 $258,532.63
255 3/20/2038 $258,532.63 $1,147.24 $1,915.48 $256,617.15
256 4/20/2038 $256,617.15 $1,138.74 $1,923.98 $254,693.17
257 5/20/2038 $254,693.17 $1,130.20 $1,932.52 $252,760.65
258 6/20/2038 $252,760.65 $1,121.63 $1,941.09 $250,819.56
259 7/20/2038 $250,819.56 $1,113.01 $1,949.71 $248,869.85
260 8/20/2038 $248,869.85 $1,104.36 $1,958.36 $246,911.49
261 9/20/2038 $246,911.49 $1,095.67 $1,967.05 $244,944.44
262 10/20/2038 $244,944.44 $1,086.94 $1,975.78 $242,968.66
263 11/20/2038 $242,968.66 $1,078.17 $1,984.55 $240,984.11
264 12/20/2038 $240,984.11 $1,069.37 $1,993.35 $238,990.76
265 1/20/2039 $238,990.76 $1,060.52 $2,002.20 $236,988.56
266 2/20/2039 $236,988.56 $1,051.64 $2,011.08 $234,977.48
267 3/20/2039 $234,977.48 $1,042.71 $2,020.01 $232,957.47
268 4/20/2039 $232,957.47 $1,033.75 $2,028.97 $230,928.50
269 5/20/2039 $230,928.50 $1,024.75 $2,037.97 $228,890.53
270 6/20/2039 $228,890.53 $1,015.70 $2,047.02 $226,843.51
271 7/20/2039 $226,843.51 $1,006.62 $2,056.10 $224,787.41
272 8/20/2039 $224,787.41 $997.49 $2,065.23 $222,722.18
273 9/20/2039 $222,722.18 $988.33 $2,074.39 $220,647.79
274 10/20/2039 $220,647.79 $979.12 $2,083.60 $218,564.19
275 11/20/2039 $218,564.19 $969.88 $2,092.84 $216,471.35
276 12/20/2039 $216,471.35 $960.59 $2,102.13 $214,369.22
277 1/20/2040 $214,369.22 $951.26 $2,111.46 $212,257.77
278 2/20/2040 $212,257.77 $941.89 $2,120.83 $210,136.94
279 3/20/2040 $210,136.94 $932.48 $2,130.24 $208,006.70
280 4/20/2040 $208,006.70 $923.03 $2,139.69 $205,867.01
281 5/20/2040 $205,867.01 $913.53 $2,149.19 $203,717.83
282 6/20/2040 $203,717.83 $904.00 $2,158.72 $201,559.11
283 7/20/2040 $201,559.11 $894.42 $2,168.30 $199,390.81
284 8/20/2040 $199,390.81 $884.80 $2,177.92 $197,212.88
285 9/20/2040 $197,212.88 $875.13 $2,187.59 $195,025.30
286 10/20/2040 $195,025.30 $865.42 $2,197.30 $192,828.00
287 11/20/2040 $192,828.00 $855.67 $2,207.05 $190,620.95
288 12/20/2040 $190,620.95 $845.88 $2,216.84 $188,404.12
289 1/20/2041 $188,404.12 $836.04 $2,226.68 $186,177.44
290 2/20/2041 $186,177.44 $826.16 $2,236.56 $183,940.88
291 3/20/2041 $183,940.88 $816.24 $2,246.48 $181,694.40
292 4/20/2041 $181,694.40 $806.27 $2,256.45 $179,437.95
293 5/20/2041 $179,437.95 $796.26 $2,266.46 $177,171.48
294 6/20/2041 $177,171.48 $786.20 $2,276.52 $174,894.96
295 7/20/2041 $174,894.96 $776.10 $2,286.62 $172,608.34
296 8/20/2041 $172,608.34 $765.95 $2,296.77 $170,311.57
297 9/20/2041 $170,311.57 $755.76 $2,306.96 $168,004.61
298 10/20/2041 $168,004.61 $745.52 $2,317.20 $165,687.41
299 11/20/2041 $165,687.41 $735.24 $2,327.48 $163,359.92
300 12/20/2041 $163,359.92 $724.91 $2,337.81 $161,022.11
301 1/20/2042 $161,022.11 $714.54 $2,348.18 $158,673.93
302 2/20/2042 $158,673.93 $704.12 $2,358.60 $156,315.33
303 3/20/2042 $156,315.33 $693.65 $2,369.07 $153,946.26
304 4/20/2042 $153,946.26 $683.14 $2,379.58 $151,566.67
305 5/20/2042 $151,566.67 $672.58 $2,390.14 $149,176.53
306 6/20/2042 $149,176.53 $661.97 $2,400.75 $146,775.78
307 7/20/2042 $146,775.78 $651.32 $2,411.40 $144,364.38
308 8/20/2042 $144,364.38 $640.62 $2,422.10 $141,942.27
309 9/20/2042 $141,942.27 $629.87 $2,432.85 $139,509.42
310 10/20/2042 $139,509.42 $619.07 $2,443.65 $137,065.78
311 11/20/2042 $137,065.78 $608.23 $2,454.49 $134,611.29
312 12/20/2042 $134,611.29 $597.34 $2,465.38 $132,145.90
313 1/20/2043 $132,145.90 $586.40 $2,476.32 $129,669.58
314 2/20/2043 $129,669.58 $575.41 $2,487.31 $127,182.27
315 3/20/2043 $127,182.27 $564.37 $2,498.35 $124,683.92
316 4/20/2043 $124,683.92 $553.28 $2,509.44 $122,174.49
317 5/20/2043 $122,174.49 $542.15 $2,520.57 $119,653.92
318 6/20/2043 $119,653.92 $530.96 $2,531.76 $117,122.16
319 7/20/2043 $117,122.16 $519.73 $2,542.99 $114,579.17
320 8/20/2043 $114,579.17 $508.45 $2,554.27 $112,024.90
321 9/20/2043 $112,024.90 $497.11 $2,565.61 $109,459.29
322 10/20/2043 $109,459.29 $485.73 $2,576.99 $106,882.29
323 11/20/2043 $106,882.29 $474.29 $2,588.43 $104,293.86
324 12/20/2043 $104,293.86 $462.80 $2,599.92 $101,693.95
325 1/20/2044 $101,693.95 $451.27 $2,611.45 $99,082.49
326 2/20/2044 $99,082.49 $439.68 $2,623.04 $96,459.45
327 3/20/2044 $96,459.45 $428.04 $2,634.68 $93,824.77
328 4/20/2044 $93,824.77 $416.35 $2,646.37 $91,178.40
329 5/20/2044 $91,178.40 $404.60 $2,658.12 $88,520.28
330 6/20/2044 $88,520.28 $392.81 $2,669.91 $85,850.37
331 7/20/2044 $85,850.37 $380.96 $2,681.76 $83,168.61
332 8/20/2044 $83,168.61 $369.06 $2,693.66 $80,474.95
333 9/20/2044 $80,474.95 $357.11 $2,705.61 $77,769.34
334 10/20/2044 $77,769.34 $345.10 $2,717.62 $75,051.72
335 11/20/2044 $75,051.72 $333.04 $2,729.68 $72,322.04
336 12/20/2044 $72,322.04 $320.93 $2,741.79 $69,580.25
337 1/20/2045 $69,580.25 $308.76 $2,753.96 $66,826.30
338 2/20/2045 $66,826.30 $296.54 $2,766.18 $64,060.12
339 3/20/2045 $64,060.12 $284.27 $2,778.45 $61,281.66
340 4/20/2045 $61,281.66 $271.94 $2,790.78 $58,490.88
341 5/20/2045 $58,490.88 $259.55 $2,803.17 $55,687.72
342 6/20/2045 $55,687.72 $247.11 $2,815.61 $52,872.11
343 7/20/2045 $52,872.11 $234.62 $2,828.10 $50,044.01
344 8/20/2045 $50,044.01 $222.07 $2,840.65 $47,203.36
345 9/20/2045 $47,203.36 $209.46 $2,853.25 $44,350.11
346 10/20/2045 $44,350.11 $196.80 $2,865.92 $41,484.19
347 11/20/2045 $41,484.19 $184.09 $2,878.63 $38,605.56
348 12/20/2045 $38,605.56 $171.31 $2,891.41 $35,714.15
349 1/20/2046 $35,714.15 $158.48 $2,904.24 $32,809.91
350 2/20/2046 $32,809.91 $145.59 $2,917.13 $29,892.78
351 3/20/2046 $29,892.78 $132.65 $2,930.07 $26,962.71
352 4/20/2046 $26,962.71 $119.65 $2,943.07 $24,019.64
353 5/20/2046 $24,019.64 $106.59 $2,956.13 $21,063.51
354 6/20/2046 $21,063.51 $93.47 $2,969.25 $18,094.26
355 7/20/2046 $18,094.26 $80.29 $2,982.43 $15,111.83
356 8/20/2046 $15,111.83 $67.06 $2,995.66 $12,116.17
357 9/20/2046 $12,116.17 $53.77 $3,008.95 $9,107.21
358 10/20/2046 $9,107.21 $40.41 $3,022.31 $6,084.91
359 11/20/2046 $6,084.91 $27.00 $3,035.72 $3,049.19
360 12/20/2046 $3,049.19 $13.53 $3,049.19 $(0.00)

Employee Satisfaction

Employee Statistics      
ID Number Position Salary Job Satisfaction
10474 Key Account Manager 35855 3
11025 Sales Representative 41708 2
11062 Key Account Manager 47572 3
11653 Administrative Assistant 30176 4
14731 Key Account Manager 45883 4
14869 Support Specialist 32650 1
15039 Support Specialist 32750 3
15190 Sales Representative 45670 5
16015 Sales & Marketing Director 89900 4
16034 Budget Manager 55389 2
16754 Sales Representative 49617 3
18283 Support Specialist 35230 3
22923 Key Account Manager 44854 2
24168 Sales & Marketing Director 77846 3
25280 Manager 70125 3
27427 Budget Manager 62263 4
30047 Administrative Assistant 30982 2
30836 Sales & Marketing Director 84937 4
31615 Administrative Assistant 32709 4
33143 Key Account Manager 45983 5
34737 Support Specialist 33501 1
36528 Key Account Manager 48706 5
37828 Sales Representative 45927 2
38088 Support Specialist 31632 5
38180 Sales Representative 49575 3
39483 Support Specialist 37404 4
39692 Budget Manager 65492 3
42434 Support Specialist 35316 2
42694 Budget Manager 68365 2
43987 Key Account Manager 41130 4
45418 Manager 72862 3
45849 Support Specialist 30701 5
46521 Budget Manager 66009 2
47711 Manager 74767 4
49542 Sales & Marketing Director 97159 5
    1790645
Summary Information    
Position Average Satisfaction Average Salary
Administrative Assistant 3.33 31289.00
Budget Manager 2.60 63503.60
Sales & Marketing Director 4.00 87460.50
Key Account Manager 3.71 44283.29
Manager 3.33 72584.67
Sales Representative 3.00 46499.40
Support Specialist 3.00 33648.00
     
Sales & Marketing Directors with >= 4 Satisfaction    
Count 3  
Average Salary 90665.33  
     
Managers with >= 4 Satisfaction    
Count 1  
Average Salary 74767.00

Employee Satisfaction Pivot Tab

  Data  
Position Average of Salary Average of Job Satisfaction
Sales & Marketing Director 87460.5 4
Manager 72584.6666666667 3.33333333333333
Budget Manager 63503.6 2.6
Sales Representative 46499.4 3
Key Account Manager 44283.2857142857 3.71428571428571
Support Specialist 33648 3
Administrative Assistant 31289 3.33333333333333
Total Result 51161.2857142857 3.25714285714286

Looking for best Case Study Assignment Help. Whatsapp us at +16469488918 or chat with our chat representative showing on lower right corner or order from here. You can also take help from our Live Assignment helper for any exam or live assignment related assistance.