CASE ANALYSIS - INSPIRON INC. The following comprehensive assessment is based on a continuing case study of Inspiron Inc. The following financial statements have been provided: PART B 9 Marks The company is considering purchasing a new delivery truck for $2,500,000. The intention is to obtain a 4-year loan from their bank, at an interest rate of 9% per annum. Annual payments are expected to be made on the loan. Required: (a) Calculate Inspiron Inc.'s annual payment on this loan. (5 Marks) (b) Prepare the 4-year Amortization Schedule for this loan. (4 Marks) PART C 10 Marks As part of being a responsible corporate citizen, Inspiron Inc. wants to establish a college fund to assist under-privileged students in pursuing their 4-year under-graduate degree programmes. The tuition fee is estimated to be $75,000 for the first year but is expected to grow/increase by 4% per year thereafter. Required: (a) Assuming this college fund will earn 8% interest per annum, calculate the amount required at the start of a student's college journey to fund his/her full tuition. (5 Marks) (b) If Inspiron would like to sponsor the first student in two years' time and they currently have $215,000 earmarked for investment, what annual rate of interest is required to accumulate the amount needed as calculated in part (a)