Your brother works as a primary school teacher. He is thinking about taking out a loan for a new car and has asked you to help him decide on the best loan plan for him. Based on the scenario given, choose two loan plans from a local bank. Give details of the plans being offered and work out the monthly payments so that it is within your brother's budget. Draw the amortisation schedules on a monthly basis using excel. Based on the amortisation schedules, calculate the total amount of interest paid throughout the life of each loan plan using excel. Justify which plan is most suitable for your brother. All excel sheets must be attached. Report your findings in not more than 750 words. Your brother works as a primary school teacher. He is thinking about taking out a loan for a new car and has asked you to help him decide on the best loan plan for him. Based on the scenario given, choose two loan plans from a local bank. Give details of the plans being offered and work out the monthly payments so that it is within your brother's budget. Draw the amortisation schedules on a monthly basis using excel. Based on the amortisation schedules, calculate the total amount of interest paid throughout the life of each loan plan using excel. Justify which plan is most suitable for your brother. All excel sheets must be attached. Report your findings in not more than 750 words