Exp19_Excel_App_Cap_Comp_Tech_Store

profilelacey.xyY
Blake_Exp19_Excel_AppCapstone_Comp.xlsx
Home>Computer Science homework help>Exp19_Excel_App_Cap_Comp_Tech_Store

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 $ 125,000.00 Employee_ID Dependents
56768 8/19/20 Lopez Vivian FT 4 $ 100,000.00
31428 1/8/17 Ramsey Matthew FT 0 $ 110,000.00
46274 2/2/17 Stevenson Beverly FT 3 $ 85,000.00 Employee Lookup Filter
30261 4/29/20 Smith Peter FT 0 $ 95,000.00 Employee_ID Type Dependents Salary
43482 1/21/19 Kelley Emily PT 2 $ 18,864.00
88696 5/1/21 Carroll Phyllis PT 3 $ 23,722.00
65030 1/28/18 Hunt Barbara PT 0 $ 14,966.00 Employee Statistics
98674 12/29/18 Austin Melanie PT 4 $ 18,751.00 # PT
98065 10/14/20 Snyder Jean PT 1 $ 18,875.00 Total PT Salaries
80087 6/4/20 Morris Suzanne PT 3 $ 11,513.00 Average PT Salary
79886 6/15/18 Gibson Geraldine PT 0 $ 20,044.00 Highest PT Salary
64401 11/3/21 Graham Vicki PT 3 $ 10,354.00 # FT
72922 12/15/21 Watson Marilyn PT 4 $ 11,049.00 Total FT Salaries
90871 5/30/19 Simpson Troy PT 3 $ 24,010.00 Average FT Salary
39948 1/14/20 Barber Aaron PT 4 $ 11,156.00 Highest FT Salary
40725 12/7/20 Morales Brittany PT 3 $ 23,142.00
42988 1/31/19 Blair Cynthia PT 3 $ 12,105.00
40499 4/13/18 Jennings Dolores PT 0 $ 24,905.00
28253 4/29/18 Carroll Howard PT 3 $ 10,663.00

New_Construction

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
2
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 $ - 0 $ - 0

Code