The Honda Civic Hybrid is a variation of the Honda Civic with a hybrid electric powertrain. Honda introduced the Civic Hybrid in Japan in December 2001. In the United States, it was the first hybrid automobile to be certified as an Advanced Technology Partial Zero-Emissions Vehicle (AT- PZEV) from the California Air Resources Board. The Civic Hybrid uses an Integrated Motor Assist hybrid system similar to that of the Honda Insight. Early models from 2001 to 2005 used a 5-speed manual transmission, whereas later models feature a continuously variable automatic transmission. The Civic Hybrid was only marketed in sedan configurations until 2013, when Honda introduced a hatchback version. In February 2009, Honda reported that since 2001 they had sold more than 255,000 Civic Hybrids, including more than 190,000 units sold in North America. For a time, the Civic Hybrid was the second best-selling hybrid electric car in the U.S. Honda Malaysia offers finance packages to its new car purchasers. The new car market is highly competitive, and Honda Malaysia management think that they could boost sales of the Honda Civic hybrid if they offer finance at an annual interest rate of 3%, compounded monthly. However, Honda Malaysia pays its bank 4.5% per annum, compounded monthly, for the funds required. Therefore, the price of the Honda hybrid needs to be carefully determined to compensate for this discrepancy in interest rates. A buyer bought a Honda civic hybrid 1.5L at the end of 2009 at a price of RM 116 311.50. The buyer paid a down payment of RM 6300 and the remainder was financed at 3% per annum compounded monthly. He started paying his first installment in January 2010. i. ii. a) The buyer pays equal monthly payments over 5 years to discharge the debt. Calculate the size of each monthly repayment. (4M) By using EXCEL, set up an amortization schedule (table) for the 5 years loan. Print and scan this table together with your answers for submission. (5M) iii. Calculate what the monthly repayments would be if the loan was interest-free and compare. Does your answer seem reasonable? (4M) b) Given that Honda Malaysia's cost of capital is 4.5% per annum compounded monthly, what is the amount loan they took from the bank for this customer? What can you conclude? c) To spur economy growth, the interest rates were reduced in January 2013. The bank announced that the interest rate on the car loan will drop to 2.5% compounded monthly. i. ii. How will this affect the buyer? You need to show all the necessary working and explain the findings as compared to part (a), in terms of monthly payments and interest. Re do excel amortization schedule (make changes based on your table in part a(ii). Print and scan this excel table together with your answers for submission. (11M) The buyer had a fixed deposit of RM 10000 and decided to use this cash to help him pay up the loan after 36 months. This means that he will be able to finish paying his loan faster. How long will he take to finish paying the loan? In your opinion, do you think that this is a wise step to take? Explain. (14M)