excel 4.0

NP_EX19_EOM12-1_RichardFeliz_1.xlsm

Home >Business & Finance homework help >Accounting homework help >excel 4.0

Documentation

	New Perspectives Excel 2019 \| Module 12: End of Module Project 1
	Abernathy Academy
	DEVELOP AN EXCEL APPLICATION
Author:	Richard Feliz
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.

Payments

Accounts Table					Late Payments Table
Account ID	Code	Total Due	Payment Date	Amount Paid	Account ID	Payment Date	Amount Paid
AC-1031	F	$10,432	9/1/21	$5,432	AC-1066	10/7/21	$2,500
AC-1032	F	$10,236	9/1/21	$3,236
AC-1034	S	$7,508	9/1/21	$5,408
AC-1036	F	$10,432	9/1/21	$5,432
AC-1046	S	$7,508	9/1/21	$5,000
AC-1050	G	$9,891	9/1/21	$4,800
AC-1054	S	$5,600	9/1/21	$5,600
AC-1059	F	$9,891	9/1/21	$3,000
AC-1066	F	$10,332	9/1/21	$5,332
AC-1072	S	$7,508	9/1/21	$7,508
AC-1079	S	$7,508	9/1/21	$7,508
AC-1080	F	$9,953	9/1/21	$4,200
AC-1087	F	$9,953	9/1/21	$10,432
AC-1088	F	$10,432	9/1/21	$4,000
AC-1092	F	$10,332	9/1/21	$5,000
AC-1095	F	$10,153	9/1/21	$3,500
AC-1096	F	$9,891	9/1/21	$9,891
AC-1100	S	$7,238	9/1/21	$7,238
AC-1101	S	$5,600	9/1/21	$5,600
AC-1106	G	$7,238	9/1/21	$7,238
AC-1111	S	$7,508	9/1/21	$7,508
AC-1112	F	$9,953	9/1/21	$3,700
AC-1115	F	$9,891	9/1/21	$2,891
AC-1117	S	$7,238	9/1/21	$5,000
AC-1118	S	$5,600	9/1/21	$5,600
AC-1122	F	$9,891	9/1/21	$4,800
AC-1125	F	$10,432	9/1/21	$5,432
AC-1126	F	$9,891	9/1/21	$3,000
AC-1134	F	$9,891	9/1/21	$3,800
AC-1137	F	$10,236	9/1/21	$5,236
AC-1139	S	$7,508	9/1/21	$7,508
AC-1145	G	$9,237	9/1/21	$9,237
AC-1146	S	$7,508	9/1/21	$7,508
AC-1154	F	$9,891	9/1/21	$9,891
AC-1162	F	$9,891	9/1/21	$9,891
AC-1167	F	$10,332	9/1/21	$5,300
AC-1174	F	$10,432	9/1/21	$10,432
AC-1180	F	$10,153	9/1/21	$5,000
AC-1183	G	$9,237	9/1/21	$4,000
AC-1185	F	$10,153	9/1/21	$10,153
AC-1190	S	$7,238	9/1/21	$7,238
AC-1192	F	$10,153	9/1/21	$4,200
AC-1193	F	$9,891	9/1/21	$9,000
AC-1198	F	$9,891	9/1/21	$3,800
AC-1201	F	$10,236	9/1/21	$4,236
AC-1204	F	$9,953	9/1/21	$9,953
AC-1205	F	$10,432	9/1/21	$4,532
AC-1208	G	$7,238	9/1/21	$3,000
AC-1214	F	$9,953	9/1/21	$9,953
AC-1220	S	$5,600	9/1/21	$5,600
AC-1222	F	$9,891	9/1/21	$9,891
AC-1029	S	$7,238	9/8/21	$7,238
AC-1035	G	$9,953	9/8/21	$4,000
AC-1052	F	$10,332	9/8/21	$10,332
AC-1057	F	$10,153	9/8/21	$10,153
AC-1067	G	$7,238	9/8/21	$5,000
AC-1068	F	$10,091	9/8/21	$10,091
AC-1073	F	$9,953	9/8/21	$4,953
AC-1077	F	$10,236	9/8/21	$3,000
AC-1084	F	$9,891	9/8/21	$2,500
AC-1086	S	$7,238	9/8/21	$9,953
AC-1090	G	$9,891	9/8/21	$2,800
AC-1102	F	$10,153	9/8/21	$5,153
AC-1105	F	$10,332	9/8/21	$10,332
AC-1113	F	$10,432	9/8/21	$10,432
AC-1119	F	$10,153	9/8/21	$5,100
AC-1121	F	$9,891	9/8/21	$9,891
AC-1129	S	$7,238	9/8/21	$7,238
AC-1132	F	$9,891	9/8/21	$6,000
AC-1135	F	$10,091	9/8/21	$10,091
AC-1141	F	$10,432	9/8/21	$10,432
AC-1143	F	$10,432	9/8/21	$4,000
AC-1151	F	$9,953	9/8/21	$9,953
AC-1153	F	$10,153	9/8/21	$10,153
AC-1155	F	$9,891	9/8/21	$4,891
AC-1158	S	$5,600	9/8/21	$5,600
AC-1164	G	$8,868	9/8/21	$8,868
AC-1165	F	$9,891	9/8/21	$6,000
AC-1169	S	$5,600	9/8/21	$5,600
AC-1175	F	$10,236	9/8/21	$4,200
AC-1178	F	$9,953	9/8/21	$7,000
AC-1179	F	$10,432	9/8/21	$10,432
AC-1186	F	$9,891	9/8/21	$6,000
AC-1188	F	$9,891	9/8/21	$1,891
AC-1197	F	$9,891	9/8/21	$8,000
AC-1200	F	$10,432	9/8/21	$4,432
AC-1211	F	$10,236	9/8/21	$6,230
AC-1024	F	$10,432	9/15/21	$5,432
AC-1026	G	$9,891	9/15/21	$4,000
AC-1030	F	$10,091	9/15/21	$3,000
AC-1038	G	$9,891	9/15/21	$9,891
AC-1039	G	$9,891	9/15/21	$3,891
AC-1042	F	$10,091	9/15/21	$5,000
AC-1051	G	$9,891	9/15/21	$9,891
AC-1053	S	$7,238	9/15/21	$5,238
AC-1062	S	$5,600	9/15/21	$5,600
AC-1069	F	$10,432	9/15/21	$5,432
AC-1070	F	$10,236	9/15/21	$2,236
AC-1074	F	$10,432	9/15/21	$10,432
AC-1075	F	$10,153	9/15/21	$5,000
AC-1083	F	$9,891	9/15/21	$9,891
AC-1089	F	$10,153	9/15/21	$9,891
AC-1097	F	$9,891	9/15/21	$4,800
AC-1104	F	$9,891	9/15/21	$6,800
AC-1114	F	$9,891	9/15/21	$9,891
AC-1120	F	$9,891	9/15/21	$6,000
AC-1123	G	$9,573	9/15/21	$9,573
AC-1127	F	$9,891	9/15/21	$5,891
AC-1128	F	$10,332	9/15/21	$10,332
AC-1133	F	$9,891	9/15/21	$9,891
AC-1142	F	$10,153	9/15/21	$3,153
AC-1150	G	$7,238	9/15/21	$7,238
AC-1156	F	$10,332	9/15/21	$10,332
AC-1157	S	$7,238	9/15/21	$7,238
AC-1163	S	$7,466	9/15/21	$7,466
AC-1166	F	$9,891	9/15/21	$2,891
AC-1171	F	$9,891	9/15/21	$9,000
AC-1173	F	$9,891	9/15/21	$9,891
AC-1176	G	$9,237	9/15/21	$9,237
AC-1177	S	$7,508	9/15/21	$7,508
AC-1181	F	$10,432	9/15/21	$5,400
AC-1184	G	$7,508	9/15/21	$5,000
AC-1187	F	$9,891	9/15/21	$7,891
AC-1189	F	$10,332	9/15/21	$4,332
AC-1191	S	$5,600	9/15/21	$5,600
AC-1199	F	$9,891	9/15/21	$5,100
AC-1202	G	$9,237	9/15/21	$5,000
AC-1206	F	$10,153	9/15/21	$2,153
AC-1207	F	$10,432	9/15/21	$3,500
AC-1210	F	$10,432	9/15/21	$8,400
AC-1212	G	$9,237	9/15/21	$4,700
AC-1215	F	$10,432	9/15/21	$5,445
AC-1217	F	$9,891	9/15/21	$3,590
AC-1218	F	$10,332	9/15/21	$10,332
AC-1223	F	$9,891	9/15/21	$4,800
AC-1025	F	$10,153	9/22/21	$10,153
AC-1028	F	$10,332	9/22/21	$5,000
AC-1040	F	$10,332	9/22/21	$7,332
AC-1047	F	$9,953	9/22/21	$4,953
AC-1055	F	$9,953	9/22/21	$4,953
AC-1060	F	$10,332	9/22/21	$4,332
AC-1076	F	$10,432	9/22/21	$6,432
AC-1082	F	$10,153	9/22/21	$4,000
AC-1091	G	$9,891	9/22/21	$10,332
AC-1093	S	$7,238	9/22/21	$5,600
AC-1094	S	$5,600	9/22/21	$3,500
AC-1103	F	$9,891	9/22/21	$9,891
AC-1116	F	$10,332	9/22/21	$10,332
AC-1124	G	$8,541	9/22/21	$8,541
AC-1144	F	$10,236	9/22/21	$10,236
AC-1149	F	$10,332	9/22/21	$10,332
AC-1159	F	$10,153	9/22/21	$5,153
AC-1168	S	$7,238	9/22/21	$7,238
AC-1172	F	$9,891	9/22/21	$2,000
AC-1182	F	$10,236	9/22/21	$10,236
AC-1195	S	$5,600	9/22/21	$5,600
AC-1203	S	$7,508	9/22/21	$7,508
AC-1209	F	$10,091	9/22/21	$10,091
AC-1213	S	$7,508	9/22/21	$7,508
AC-1216	F	$9,891	9/22/21	$4,550
AC-1219	G	$7,238	9/22/21	$7,238
AC-1224	F	$9,891	9/22/21	$5,191
AC-1041	S	$7,238	9/29/21	$7,238
AC-1044	F	$10,236	9/29/21	$7,236
AC-1061	S	$7,238	9/29/21	$7,238
AC-1078	G	$9,237	9/29/21	$9,237
AC-1081	F	$10,432	9/29/21	$3,432
AC-1108	F	$10,432	9/29/21	$10,432
AC-1109	F	$10,236	9/29/21	$3,236
AC-1130	S	$5,600	9/29/21	$5,600
AC-1138	G	$9,237	9/29/21	$4,200
AC-1147	F	$9,953	9/29/21	$9,953
AC-1152	F	$10,432	9/29/21	$5,000
AC-1160	F	$9,891	9/29/21	$2,500
AC-1027	G	$9,891	10/6/21	$0
AC-1033	F	$9,237	10/6/21	$0
AC-1037	F	$10,153	10/6/21	$10,153
AC-1043	F	$10,432	10/6/21	$0
AC-1045	G	$9,237	10/6/21	$9,237
AC-1048	F	$10,432	10/6/21	$10,432
AC-1049	F	$10,153	10/6/21	$0
AC-1056	F	$10,432	10/6/21	$0
AC-1058	F	$9,891	10/6/21	$9,891
AC-1063	F	$10,153	10/6/21	$5,000
AC-1064	F	$9,891	10/6/21	$0
AC-1071	G	$9,237	10/6/21	$9,237
AC-1085	F	$10,332	10/6/21	$3,332
AC-1098	F	$9,891	10/6/21	$5,000
AC-1099	F	$10,332	10/6/21	$0
AC-1107	F	$10,091	10/6/21	$0
AC-1110	G	$9,237	10/6/21	$9,237
AC-1131	F	$10,153	10/6/21	$6,500
AC-1136	F	$10,432	10/6/21	$10,432
AC-1140	F	$9,953	10/6/21	$0
AC-1148	F	$10,432	10/6/21	$0
AC-1161	F	$9,891	10/6/21	$2,800
AC-1170	F	$10,153	10/6/21	$4,100
AC-1194	G	$7,238	10/6/21	$0
AC-1196	F	$10,153	10/6/21	$10,153
AC-1221	F	$10,153	10/6/21	$0
AC-1065	F	$9,891	10/6/21	$4,891

Entry Form

				Account IDs
Account ID	AC-1031	REGISTERED STUDENTS	TOTAL TUITION BILLED	AC-1031
Date	10/7/21			AC-1032
Amount paid	$1,000			AC-1034
				AC-1036
Total due this account	$10,432	STUDENTS - PAYMENTS	TOTAL PAID TUITION	AC-1046
Total paid to date	$5,432	189		AC-1050
Total owed	$4,000			AC-1054
				AC-1059
		STUDENTS - NO PAYMENTS	TOTAL TUITION DUE	AC-1066
		12	$0	AC-1072
				AC-1079
				AC-1080
				AC-1087
				AC-1088
				AC-1092
				AC-1095
				AC-1096
				AC-1100
				AC-1101
				AC-1106
				AC-1111
				AC-1112
				AC-1115
				AC-1117
				AC-1118
				AC-1122
				AC-1125
				AC-1126
				AC-1134
				AC-1137
				AC-1139
				AC-1145
				AC-1146
				AC-1154
				AC-1162
				AC-1167
				AC-1174
				AC-1180
				AC-1183
				AC-1185
				AC-1190
				AC-1192
				AC-1193
				AC-1198
				AC-1201
				AC-1204
				AC-1205
				AC-1208
				AC-1214
				AC-1220
				AC-1222
				AC-1029
				AC-1035
				AC-1052
				AC-1057
				AC-1067
				AC-1068
				AC-1073
				AC-1077
				AC-1084
				AC-1086
				AC-1090
				AC-1102
				AC-1105
				AC-1113
				AC-1119
				AC-1121
				AC-1129
				AC-1132
				AC-1135
				AC-1141
				AC-1143
				AC-1151
				AC-1153
				AC-1155
				AC-1158
				AC-1164
				AC-1165
				AC-1169
				AC-1175
				AC-1178
				AC-1179
				AC-1186
				AC-1188
				AC-1197
				AC-1200
				AC-1211
				AC-1024
				AC-1026
				AC-1030
				AC-1038
				AC-1039
				AC-1042
				AC-1051
				AC-1053
				AC-1062
				AC-1069
				AC-1070
				AC-1074
				AC-1075
				AC-1083
				AC-1089
				AC-1097
				AC-1104
				AC-1114
				AC-1120
				AC-1123
				AC-1127
				AC-1128
				AC-1133
				AC-1142
				AC-1150
				AC-1156
				AC-1157
				AC-1163
				AC-1166
				AC-1171
				AC-1173
				AC-1176
				AC-1177
				AC-1181
				AC-1184
				AC-1187
				AC-1189
				AC-1191
				AC-1199
				AC-1202
				AC-1206
				AC-1207
				AC-1210
				AC-1212
				AC-1215
				AC-1217
				AC-1218
				AC-1223
				AC-1025
				AC-1028
				AC-1040
				AC-1047
				AC-1055
				AC-1060
				AC-1076
				AC-1082
				AC-1091
				AC-1093
				AC-1094
				AC-1103
				AC-1116
				AC-1124
				AC-1144
				AC-1149
				AC-1159
				AC-1168
				AC-1172
				AC-1182
				AC-1195
				AC-1203
				AC-1209
				AC-1213
				AC-1216
				AC-1219
				AC-1224
				AC-1041
				AC-1044
				AC-1061
				AC-1078
				AC-1081
				AC-1108
				AC-1109
				AC-1130
				AC-1138
				AC-1147
				AC-1152
				AC-1160
				AC-1027
				AC-1033
				AC-1037
				AC-1043
				AC-1045
				AC-1048
				AC-1049
				AC-1056
				AC-1058
				AC-1063
				AC-1064
				AC-1071
				AC-1085
				AC-1098
				AC-1099
				AC-1107
				AC-1110
				AC-1131
				AC-1136
				AC-1140
				AC-1148
				AC-1161
				AC-1170
				AC-1194
				AC-1196
				AC-1221
				AC-1065

Clear Entries

Payment Entry Form

Enter Payment

Payment Summary

Payment Date	Registered Students	Total Billed	Total Paid	Amount Due
9/1/21	51	$462,985	$312,645	$150,340
9/8/21	36	$342,177	$247,939	$94,238
9/15/21	48	$456,100	$313,200	$142,900
9/22/21	27	$248,946	$188,232	$60,714
9/29/21	12	$110,162	$75,302	$34,860
10/6/21	27	$267,471	$110,395	$157,076
Grand Total	201	$1,887,841	$1,247,713	$640,128

Payments by Date