SECTION A: Report Writing (70 marks) Scenario Niall Horan is a Human Resources Executive at One Direction Berhad with a monthly salary RM6,000. He is planning on buying a two stories house at Puchong, Selangor. The house is currently selling at RM85,000. He is willing to pay 10% out of the cash value as her deposit for the house. The balance will be financed will be financed through a housing loan with a tenant period year. To execute this plan, Niall has come to you for a financial consultation. BAS1103 FINANCIAL MATHEMATICS/ASSIGNMENT Task You have been assigned to work with your team (TWO members in a group can't be less or more than TWO) to discuss and select a product. You are advised to consult selection loan in Malaysia banks. Each group must meet Niall concerns: 1. Select two available selection loan in Malaysia. 2. Determine the monthly installment amount for Niall Horan has to pay under both loans. 3. Prepare the amortization schedules for the first 5 years for both loans using Microsoft Excel. 4. Determine the 45th interest payment for both loans. 5. Determine the outstanding balance will be for both loans if Niall wanted to settle the loan in lump sum after 10 years. 6. Based on 1 to 5, determine the best house loan for Niall. Selection of the loans: Group 2 Maybank Vs RHB Format of the Report 1) Your report should consist of the following: a) Cover page b) Introduction c) Content d) Conclusion (Decision & Justification) e) References 2) Each page must be typed. Page 2 of 5