IT IS URGENT!

Please provide excel file

Please answer the questions as required. Double check your answers. Answer all questions. You can start from any question preferred. You have 90 minutes. Q1: (Total: 40 points) Classes/Grades Advance Payment Installments 10.140 TL + VAT 9,750TL + VAT 5 Inst 10.250 TL + VAT 9,600TL + VAT 5 Inst.) 0.7,8 9,620 TL + VAT 9.200TL + VAT 5 Inst.) Tota 58.890TL+VAT 58250TL+VAT 55,620TL+VAT Food & Beverage 1.350 TL + VAT 1.250TL + VAT 5 (Inst.) 7700TL-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 34 Grade and his son will be gih 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% WAT 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 31" of May 2021 Installment 1: 30h 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 28 of February can get 16.8% 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 30th 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). Please answer the questions as required. Double check your answers. Answer all questions. You can start from any question preferred. You have 90 minutes. Q1: (Total: 40 points) Classes/Grades Advance Payment Installments 10.140 TL + VAT 9,750TL + VAT 5 Inst 10.250 TL + VAT 9,600TL + VAT 5 Inst.) 0.7,8 9,620 TL + VAT 9.200TL + VAT 5 Inst.) Tota 58.890TL+VAT 58250TL+VAT 55,620TL+VAT Food & Beverage 1.350 TL + VAT 1.250TL + VAT 5 (Inst.) 7700TL-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 34 Grade and his son will be gih 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% WAT 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 31" of May 2021 Installment 1: 30h 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 28 of February can get 16.8% 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 30th 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)