EXCEL ASSIGNMENT

profileSUMMER11
ABCPreschool.xlsx

ABC Preschool

ABC Preschool
2013 - 2014
Assumptions
Tuition Activities
Miscellaneous Registration Discount Full Day Half Day Previous Enrolled Child Discount Package Cost
Testing Fee $100 Percent 12.50% 2 $14,000 $10,000 Discount Percentage 10.00% None $0
Student Accident Insurance $25 Date 7/1/13 3 $12,000 $8,000 Regular $1,250
Supplies Fees 2.00% P $8,000 $6,000 Annual Interest Rate Premium $5,000
Finance Term (months) 9 Rate 8.0%
Student ID First Name Last Name Class Previously Enrolled Child Registration Extracurricular Activities Enrolled Tuition Before Discounts Tuition Discounts Fees & Activities Total Financed Monthly Payment
AB1312 George Liberman 2 N 6/12/13 None Full Day
AC1231 Alexandra Liberman 3 N 6/12/13 Regular Full Day
VF4312 Sarah George 2 Y 7/25/13 None Full Day
EW0971 Mary Arnett 2 Y 7/14/13 None Full Day
SO9814 Jordan Abreu 3 N 7/30/13 Premium Full Day
JH3123 Lissette Ibbotson P Y 8/14/13 Premium Half Day
IM2944 Fred Ibbotson 2 Y 8/10/13 None Half Day
KY8931 Hunter Matos P Y 6/12/13 Premium Half Day
BE3123 Connor Strickland 2 N 8/19/13 None Half Day
SO3294 Samuel Liberman P N 6/30/13 Regular Full Day
JU4829 Jacob Upchurch 3 N 8/22/13 Premium Full Day
Tuition is based on full day/half day and which class they attend
Discounts are for previously enrolled child or registration before 7/1/2013 (Parents can receive both discounts)
Fees & Activities include testing fee, accident insurance supply fee and the activities package
All children listed participated in the financing program (actually their parents did) for a 9 month period with an annual interest rate of 8%