Answered step by step
Verified Expert Solution
Question
1 Approved Answer
also, please explain all the steps. A schoci has listed its annual sution prices inchiding food & beverage (Fb) prices where all tervices (tuibon and
also, please explain all the steps.
A schoci has listed its annual sution prices inchiding food \& beverage (Fb) prices where all tervices (tuibon and FBB) and their payments are compulsory. Aso the school has listed 7 parment options as given below. Parents are requebled to deciefe their payment plish and inform the school A parent Grade and his scen wal be 77 Grade, Parent must calculate the most cost efficlent (cheapest) optien for himself among the piven options. Parent holds the required money in hand but also can gain interest by loaring to the bark, interest rates ate expected to be 12% through the whole payment lerm. Plaase advise the parent which payment option from to to to choose for his son and dauphter separalely. Use MS Excel with formulas to compare the alternatives and send your study as MS Excel: Important Notes: - The boy and the giri both has 5\% scholarkip discount only for tultion if paid in insialments. - Value Added Tax (VAT) B\% - Whtholding Tar (W4T) 5 WHT is paid out of the interest amourl eamed from the bank. Meaning goverrment takes stis of the interest earned. BAYMENT OPTIONS: 1. Eill instatment Ooton Burmert Daves Advance Paymert 312 of January 2020 instalment 1.31 of May 2020 inmulment 2 31" of Jhay 2000 Inataliment 430 of Novamber 2020 Instatment 5:31 of Jaruary 2021 2. Parens who desire to ply ag the hetion and FAB prices in adrance on the JI" of Jaruary can get 12% discoure from the fotal list price 3. Parents who desine to pay at the luticn and FBE prices in advance on the 31" ct March can get 10 'h discount from the lotal list price. 4 Parents who desire to pay al the luaton and FAB prices in advance on the 30, of Agrit can get 8 s discount from the fotal list prica. 5. Brothers and sisters regitering logether wa receve 12% dscount for each. Only vald tor tution: 6. Al discounts carnot exceed 25% for fucion paymert. 7. Scholenhip discounts can enly be appled if the parent decides io pay in instatmeras Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started