The CFO has negotiated a cheaper deal with mCommerceBank, a competitior of eCommerceBanque. The bank has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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). The annualized interest rate charged by the bank is 9% pa. Compute the monthly payment amount to be made to the mCommerceBank. (i) 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. (iii) Write a formula in cell C50 to compute the monthly payments to be made to the bank. Nper Annualized Rate (APR) Monthly Rate Present Value (PV) Future Value (FV) Type Monthly Payments (PMT) 9% 0 Correct Answer Monthly Payments (PMT) $ (183.82) OR Monthly Payments (PMT) 8. Seeing further financing opportunity with the firm, mCommerceBank has sweetend the deal further. 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. (1) Enter the values of Present Value, Type and PMT in cells C59, C61 and C62 respectively. (ii) Write a formula in cell CS8 to compute the monthly interest rate charged by the bank. (iii) Write a formula in cell C64 to compute the loan duration (number of months). Annualized Rate (APR) Monthly Rate Present Value (PV) Future Value (FV) Type PMT Loan duration (Number of months) 8% 0 Correct Answer Loan duration (Number of months) $183.82 24.00 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). The annualized interest rate charged by the bank is 9% pa. Compute the monthly payment amount to be made to the mCommerceBank. (i) 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. (iii) Write a formula in cell C50 to compute the monthly payments to be made to the bank. Nper Annualized Rate (APR) Monthly Rate Present Value (PV) Future Value (FV) Type Monthly Payments (PMT) 9% 0 Correct Answer Monthly Payments (PMT) $ (183.82) OR Monthly Payments (PMT) 8. Seeing further financing opportunity with the firm, mCommerceBank has sweetend the deal further. 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. (1) Enter the values of Present Value, Type and PMT in cells C59, C61 and C62 respectively. (ii) Write a formula in cell CS8 to compute the monthly interest rate charged by the bank. (iii) Write a formula in cell C64 to compute the loan duration (number of months). Annualized Rate (APR) Monthly Rate Present Value (PV) Future Value (FV) Type PMT Loan duration (Number of months) 8% 0 Correct Answer Loan duration (Number of months) $183.82 24.00
Expert Answer:
Answer rating: 100% (QA)
To solve the problem you can use the following formulas in Excel i Enter the values of number of ... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1259024962
6th Canadian edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus, Devashis Mitra, Elizabeth Maynes, William Lim
Posted Date:
Students also viewed these finance questions
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Congratulations! Your portfolio returned 11% last year, 2% better than the market return of 9%. Your portfolio had a standard deviation of earnings equal to 18%, and the risk-free rate is equal to...
-
How are the tax issues associated with home offices and vacation homes used as rentals similar? How are the tax issues or requirements dissimilar?
-
After all the transactions for the year ended May 31, 2016, had been posted, the data below were taken from the records of Angelos Design Ltd. Assume all accounts have normal balances. Instructions...
-
Design Data sold a piece of machinery to HHB Drafting Company. However, after HHB had taken possession of the machine, it discovered damage and revoked the contract. The court found that the...
-
On March 20, Dodys petty cash fund of $100 is replenished when the fund contains $9 in cash and receipts for postage $52, freight-out $26, and travel expense $10. Give the journal entry to record the...
-
10. Suppose f(x) = x - 2. Use the centered difference method with h = 0.1 to approximate f'(1).
-
Following Information is given 1. Incorporation date: 1st March 2022. 2. Accounting year end: 28th Feb 2023 3. Starting capital: 2.00 (called up but not paid; Two Directors/shareholders of company Mr...
-
Discuss quality certification and its importance.
-
Determine the equilibrium composition of NO from air at 1 bar in the temperature range of 11003000 K. Plot the mole fraction of NO vs. temperature. You may assume Dhrxn o is constant for the reaction.
-
Describe the three concerns of small businesses related to the supply chain and suggest ways to manage those concerns.
-
Compare the quality awards.
-
Briefly describe ethical issues in supply chains and the key steps companies can take to avoid ethical problems.
-
Q8. Anne is a frequent flyer whose fares are reduced (through coupon giveaways) by 15% after she flies 15,000 miles a year, and then by 30% after she flies 30,000 miles. With composite good Y on the...
-
How is use of the word consistent helpful in fraud reports?
-
Bill needs a new car and can afford monthly car payments of $400. The interest rate on new car loans is 7%, APR and payments are made at month-end. Bill wonders whether to arrange a 48- or 60-month...
-
You have joined the Projects division of GrowMore Inc. Your first job is to analyze two projects, which you have code-named "alpha" and "beta." Both projects will require the same initial investment...
-
Give three examples of the types of costs incurred by firms in financial distress.
-
A strain rosette consisting of three strain gauges was used to measure the strains at a point in a thin plate of dimensions \(100 \times 20 \times 1 \mathrm{~mm}\). The measured strains in the three...
-
A particle of mass \(m\) slides inside a smooth hemispherical bowl of radius \(R\). Beginning with spherical coordinates \(r, \theta\) and \(\varphi\) to describe the dynamics, select generalized...
-
A small block of mass \(m\) and a weight of mass \(M\) are connected by a string of length \(D\). The string has been threaded through a small hole in a tabletop, so the block can slide without...
Study smarter with the SolutionInn App