Classes/Grades 1,2 3,4,5 6.7.8 Advance Payment 10.140 TL + VAT 10.250 TL + VAT 9,620 TL + VAT Installments 9,750TL + VAT 5 (Inst.) 9,600TL + VAT '5 (Inst.) 9.200TL + VAT '5 (Inst.) Total 58.890TL+VAT 58.250 TL+VAT 55,620TL+VAT Food & Beverage 1,350 TL + VAT 1.250TL + VAT '5 (Inst.) 77D0TL+VAT A school has listed its annual tuition prices including food & beverage (F&B) prices where all services (tuition and F&B) and their payments are compulsory. Also the school has listed 8 payment options as given below. Parents are requested to decide their payment plan and inform the school. A parent has two children whom his daughter has completed Kindergarten of the same school and will be 3d Grade and his son will be 8 Grade. Parent must calculate the most cost efficient (cheapest) option for himself among the given options. Parent has the required money but also can gain interest from the bank with an interest rate of 18% per year. Knowing that the interest rate will not change for the following 18 months please advise the parent which option to choose for his son and daughter separately. Prepare your calculation in MS Excel and write down your answer table below. Please email the excel file separately. Important Notes: The boy and the girl both has 5% scholarship discount. Value Added Tax (VAT): 1% Withholding Tax (WHT): 5% WHT is paid out of the interest gained form the bank. Meaning government takes 5% of the interest eamed. PAYMENT OPTIONS: 1. Payment Dates for tuition and F&B: Advance Payment: 31" of May 2021 Installment 1: 30 of September 2021 Installment 2: 31 of December 2021 Installment 3: 28th of February 2022 Installment 4:29h of April 2022 Installment 5: 31" of May 2022 2. Parents who desire to pay all the tuition and F&B prices in advance on the 28th of February can get 16.6% discount from the total list price. 3. Parents who desire to pay all the tuition and F&B prices in advance on the 31* of March can get 12% discount from the total list price. 4. Parents who desire to pay all the tuition and F&B prices in advance on the 30" of April can get 9% discount from the total list price. 5. Brothers and sisters registering together, each will receive 12% discount for tuition. 6. All discounts for tuition cannot exceed 25% even if all tuition is paid in advance. 7. Scholarship discounts can only be applied for tuition if the parent decides to pay in installments. Meaning, scholarship discounts are not valid for any advance paying options(Item 2.3.4). Classes/Grades 1,2 3,4,5 6,7,8 Advance Payment | Installments 10,140 TL + VAT 9,750TL + VAT * 5 (Inst.) 10,250 TL + VAT 9,600TL + VAT *5 (Inst.) 9,620 TL + VAT 9,200TL + VAT *5 (Inst.) Total 58,890TL+VAT 58,250TL+VAT 55,620 TL+VAT Food & Beverage 1,350 TL + VAT 1.250TL + VAT *5 (Inst.) 7,700TL+VAT A school has listed its annual tuition prices including food & beverage (F&B) prices where all services (tuition and F&B) and their payments are compulsory. Also the school has listed 8 payment options as given below. Parents are requested to decide their payment plan and inform the school. A parent has two children whom his daughter has completed Kindergarten of the same school and will be 3rd Grade and his son will be th Grade. Parent must calculate the most cost efficient (cheapest) option for himself among the given options. Parent has the required money but also can gain interest from the bank with an interest rate of 18% per year. Knowing that the interest rate will not change for the following 18 months please advise the parent which option to choose for his son and daughter separately. Prepare your calculation in MS Excel and write down your answer table below. Please email the excel file separately. Important Notes: The boy and the girl both has 5% scholarship discount Value Added Tax (VAT): 1% Withholding Tax (WHT): 5% WHT is paid out of the interest gained form the bank. Meaning government takes 5% of the interest earned. PAYMENT OPTIONS: 1. Payment Dates for tuition and F&B: Advance Payment: 31st of May 2021 Installment 1: 30th of September 2021 Installment 2: 31st of December 2021 Installment 3: 28th of February 2022 Installment 4: 29th of April 2022 Installment 5: 31st of May 2022 2. Parents who desire to pay all the tuition and F&B prices in advance on the 28th of February can get 16.6% discount from the total list price. Classes/Grades 1,2 3,4,5 6.7.8 Advance Payment 10.140 TL + VAT 10.250 TL + VAT 9,620 TL + VAT Installments 9,750TL + VAT 5 (Inst.) 9,600TL + VAT '5 (Inst.) 9.200TL + VAT '5 (Inst.) Total 58.890TL+VAT 58.250 TL+VAT 55,620TL+VAT Food & Beverage 1,350 TL + VAT 1.250TL + VAT '5 (Inst.) 77D0TL+VAT A school has listed its annual tuition prices including food & beverage (F&B) prices where all services (tuition and F&B) and their payments are compulsory. Also the school has listed 8 payment options as given below. Parents are requested to decide their payment plan and inform the school. A parent has two children whom his daughter has completed Kindergarten of the same school and will be 3d Grade and his son will be 8 Grade. Parent must calculate the most cost efficient (cheapest) option for himself among the given options. Parent has the required money but also can gain interest from the bank with an interest rate of 18% per year. Knowing that the interest rate will not change for the following 18 months please advise the parent which option to choose for his son and daughter separately. Prepare your calculation in MS Excel and write down your answer table below. Please email the excel file separately. Important Notes: The boy and the girl both has 5% scholarship discount. Value Added Tax (VAT): 1% Withholding Tax (WHT): 5% WHT is paid out of the interest gained form the bank. Meaning government takes 5% of the interest eamed. PAYMENT OPTIONS: 1. Payment Dates for tuition and F&B: Advance Payment: 31" of May 2021 Installment 1: 30 of September 2021 Installment 2: 31 of December 2021 Installment 3: 28th of February 2022 Installment 4:29h of April 2022 Installment 5: 31" of May 2022 2. Parents who desire to pay all the tuition and F&B prices in advance on the 28th of February can get 16.6% discount from the total list price. 3. Parents who desire to pay all the tuition and F&B prices in advance on the 31* of March can get 12% discount from the total list price. 4. Parents who desire to pay all the tuition and F&B prices in advance on the 30" of April can get 9% discount from the total list price. 5. Brothers and sisters registering together, each will receive 12% discount for tuition. 6. All discounts for tuition cannot exceed 25% even if all tuition is paid in advance. 7. Scholarship discounts can only be applied for tuition if the parent decides to pay in installments. Meaning, scholarship discounts are not valid for any advance paying options(Item 2.3.4). Classes/Grades 1,2 3,4,5 6,7,8 Advance Payment | Installments 10,140 TL + VAT 9,750TL + VAT * 5 (Inst.) 10,250 TL + VAT 9,600TL + VAT *5 (Inst.) 9,620 TL + VAT 9,200TL + VAT *5 (Inst.) Total 58,890TL+VAT 58,250TL+VAT 55,620 TL+VAT Food & Beverage 1,350 TL + VAT 1.250TL + VAT *5 (Inst.) 7,700TL+VAT A school has listed its annual tuition prices including food & beverage (F&B) prices where all services (tuition and F&B) and their payments are compulsory. Also the school has listed 8 payment options as given below. Parents are requested to decide their payment plan and inform the school. A parent has two children whom his daughter has completed Kindergarten of the same school and will be 3rd Grade and his son will be th Grade. Parent must calculate the most cost efficient (cheapest) option for himself among the given options. Parent has the required money but also can gain interest from the bank with an interest rate of 18% per year. Knowing that the interest rate will not change for the following 18 months please advise the parent which option to choose for his son and daughter separately. Prepare your calculation in MS Excel and write down your answer table below. Please email the excel file separately. Important Notes: The boy and the girl both has 5% scholarship discount Value Added Tax (VAT): 1% Withholding Tax (WHT): 5% WHT is paid out of the interest gained form the bank. Meaning government takes 5% of the interest earned. PAYMENT OPTIONS: 1. Payment Dates for tuition and F&B: Advance Payment: 31st of May 2021 Installment 1: 30th of September 2021 Installment 2: 31st of December 2021 Installment 3: 28th of February 2022 Installment 4: 29th of April 2022 Installment 5: 31st of May 2022 2. Parents who desire to pay all the tuition and F&B prices in advance on the 28th of February can get 16.6% discount from the total list price