Business

profileStud111
Exp19_Excel_AppCapstone_Comp.xls.xlsx
Home>Business & Finance homework help>Marketing homework help>Business

Employee_Info

Tech Store Unlimited
Employee Information 401K Cut Off 1/1/19
Employee_ID Start_Date First_Name Last_Name Type Dependents 401k Eligible Salary Employee Lookup
31461 2/1/17 Nelson Gail FT 1 Y $ 125,000.00 Employee_ID Dependents
56768 8/19/20 Lopez Vivian FT 4 N $ 100,000.00 125000
31428 1/8/17 Ramsey Matthew FT 0 Y $ 110,000.00
46274 2/2/17 Stevenson Beverly FT 3 Y $ 85,000.00 Employee Lookup Filter
30261 4/29/20 Smith Peter FT 0 N $ 95,000.00 Employee_ID Type Dependents Salary
43482 1/21/19 Kelley Emily PT 2 N $ 18,864.00 FT
88696 5/1/21 Carroll Phyllis PT 3 N $ 23,722.00
65030 1/28/18 Hunt Barbara PT 0 N $ 14,966.00 Employee Statistics
98674 12/29/18 Austin Melanie PT 4 N $ 18,751.00 # PT 15
98065 10/14/20 Snyder Jean PT 1 N $ 18,875.00 Total PT Salaries $254,119.00
80087 6/4/20 Morris Suzanne PT 3 N $ 11,513.00 Average PT Salary $16,941.27
79886 6/15/18 Gibson Geraldine PT 0 N $ 20,044.00 Highest PT Salary $24,905.00
64401 11/3/21 Graham Vicki PT 3 N $ 10,354.00 # FT 5
72922 12/15/21 Watson Marilyn PT 4 N $ 11,049.00 Total FT Salaries $515,000.00
90871 5/30/19 Simpson Troy PT 3 N $ 24,010.00 Average FT Salary $103,000.00
39948 1/14/20 Barber Aaron PT 4 N $ 11,156.00 Highest FT Salary $125,000.00
40725 12/7/20 Morales Brittany PT 3 N $ 23,142.00
42988 1/31/19 Blair Cynthia PT 3 N $ 12,105.00
40499 4/13/18 Jennings Dolores PT 0 N $ 24,905.00
28253 4/29/18 Carroll Howard PT 3 N $ 10,663.00
Full Time Employees
Employee_ID Start_Date First_Name Last_Name Type Dependents 401k Eligible Salary
31461 2/1/17 Nelson Gail FT 1 Y $ 125,000.00
56768 8/19/20 Lopez Vivian FT 4 N $ 100,000.00
31428 1/8/17 Ramsey Matthew FT 0 Y $ 110,000.00
46274 2/2/17 Stevenson Beverly FT 3 Y $ 85,000.00
30261 4/29/20 Smith Peter FT 0 N $ 95,000.00

New_Construction

Tech Store Unlimited
Facility Amortization Table
Payment Details Loan Details
Payment $8,647.55 Loan $450,000.00
APR 5.75% Periodic Rate 0.479%
Years 5 # of Payments 60
Pmts per Year 12
Payment Number Beginning Balance Payment Amount Interest Paid Principal Repayment Remaining Balance Cumulative Interest Cumulative Principal
1 $416,303.09 $ 8,000.00 ($450,060.29) $ 458,060.29 ($41,757.20) $ (2,156.25) #NAME?
2 ($41,757.20)
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Totals $ (450,060.29) $ 458,060.29

Code

Scenario Summary

Scenario Summary
Current Values: Good Most Likely Bad
Created by Microsoft Office User on 4/1/2020 Created by Microsoft Office User on 4/1/2020 Created by Microsoft Office User on 4/1/2020
Changing Cells:
APR 5.75% 3.12% 5.75% 6.25%
Years 5 5 5 5
Result Cells:
Payment $8,647.55 $8,109.93 $8,647.55 $8,752.17
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.