Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started