Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Public Finance In Canada

Authors: Harvey Rosen, Beverly George Dahlby, Roger Smith, Jean-Francois Wen, Tracy Snoddon

3rd Canadian Edition

0070951659, 978-0070951655

More Books

Students also viewed these Finance questions