A B C D E F G H 7. The CFO has negotiated a cheaper deal with mCommerceBank, a competitior of eCommerceBanque. The bank has agreed to provide loan of $2102, for 1 year and the payments are required to be paid monthly (at the end). 40 The annualized interest rate charged by the bank is 9% pa. Compute the monthly payment amount to be made to the mCommerceBank. $ (183.82) (1) Enter the values of number of periods, Present Value and Type in cells C43, C46 and C48 respectively. (ii) Write a formula in cell C45 to convert the annual rate to monthly interest rate. 41 (iii) Write a formula in cell C50 to compute the monthly payments to be made to the bank. 42 43 Nper Correct Answer 44 Annualized Rate (APR) 9% 9 45 Monthly Rate Monthly Payments (PMT) 46 Present Value (PV) 47 Future Value (FV) OR 48 Type Monthly Payments (PMT) 49 50 Monthly Payments (PMT) 51 52 53 8. Seeing further financing opportunity with the firm, mCommerceBank has sweetend the deal further. 54 The bank has agreed to provide loan of $2102, at a rate of 8% per annum, and payments of $95.05 per month (at the end) till the loan is repaid completely. 0 $183.82 Correct Answer (1) Enter the values of Present Value, Type and PMT in cells C59, C61 and C62 respectively. (ii) Write a formula in cell C58 to compute the monthly interest rate charged by the bank. 55 (iii) Write a formula in cell C64 to compute the loan duration (number of months). 56 57 Annualized Rate (APR) ) 8% 58 Monthly Rate 59 Present Value (PV) 60 Future Value (FV) 0 61 Type 62 PMT Loan duration (Number of months) 24.00 63 Loan duration (Number of months) 64 65 A B C D E F G H 7. The CFO has negotiated a cheaper deal with mCommerceBank, a competitior of eCommerceBanque. The bank has agreed to provide loan of $2102, for 1 year and the payments are required to be paid monthly (at the end). 40 The annualized interest rate charged by the bank is 9% pa. Compute the monthly payment amount to be made to the mCommerceBank. $ (183.82) (1) Enter the values of number of periods, Present Value and Type in cells C43, C46 and C48 respectively. (ii) Write a formula in cell C45 to convert the annual rate to monthly interest rate. 41 (iii) Write a formula in cell C50 to compute the monthly payments to be made to the bank. 42 43 Nper Correct Answer 44 Annualized Rate (APR) 9% 9 45 Monthly Rate Monthly Payments (PMT) 46 Present Value (PV) 47 Future Value (FV) OR 48 Type Monthly Payments (PMT) 49 50 Monthly Payments (PMT) 51 52 53 8. Seeing further financing opportunity with the firm, mCommerceBank has sweetend the deal further. 54 The bank has agreed to provide loan of $2102, at a rate of 8% per annum, and payments of $95.05 per month (at the end) till the loan is repaid completely. 0 $183.82 Correct Answer (1) Enter the values of Present Value, Type and PMT in cells C59, C61 and C62 respectively. (ii) Write a formula in cell C58 to compute the monthly interest rate charged by the bank. 55 (iii) Write a formula in cell C64 to compute the loan duration (number of months). 56 57 Annualized Rate (APR) ) 8% 58 Monthly Rate 59 Present Value (PV) 60 Future Value (FV) 0 61 Type 62 PMT Loan duration (Number of months) 24.00 63 Loan duration (Number of months) 64 65