Ms. Wadeson obtained a $15,000 demand loan from TD Canada Trust on May 23 to purchase a car. The interest rate on the loan was prime plus 2%. The loan required payments of $700 on the fifteenth of each month, beginning June 15. The prime rate was 4.5% at the outset, dropped to 4.25% on July 26, and then jumped by 0.5% on September 14. Prepare a loan repayment schedule showing the details of the first four payments

Ms. Wadeson obtained a $15,000 demand loan from TD Canada Trust on May 23 to purchase a car. The interest rate on the loan was prime plus 2%. The loan required payments of $700 on the fifteenth of each month, beginning June 15. The prime rate was 4.5% at the outset, dropped to 4.25% on July 26, and then jumped by 0.5% on September 14. Prepare a loan repayment schedule showing the details of the first four payments

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

The Continental Bank made a loan of $26,000.00 on March 26 to Dr. Hirsch to purchase equipment for her office. The loan was secured by a demand loan subject to a variable rate of interest that was 6% on March 26. The rate of interest was raised to 6.6% effective July 1 and to 7% effective September 1. Dr. Hirsch made partial payments on the loan as follows: $900 on May 5; $800 on June 30; and $400 on October 19. Each payment is first applied to any accumulated interest. Any remainder is then used to reduce the outstanding principal. The terms of the note require payment on October 31 of any interest not paid off by partial payments. How much must Dr. Hirsch pay on October 31? Dr. Hirsch must pay $------ on October 31.
The Continental Bank made a loan of $ 24 comma 000.00 on March 10 to Dr. Hirsch to purchase equipment for her office. The loan was secured by a demand loan subject to a variable rate of interest that was 5% on March 10. The rate of interest was raised to 5.25% effective July 1 and to 5.75% effective September 1. Dr. Hirsch made partial payments on the loan as follows: $1000 on May 24; $700 on June 28; and $300 on October 22. Each payment is first applied to any accumulated interest. Any remainder is then used to reduce the outstanding principal. The terms of the note require payment on October 31 of any interest not paid off by partial payments. How much must Dr. Hirsch pay on October 31 ? Question content area bottom Part 1 Dr. Hirsch must pay $ enter your response here on October 31. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.)
1. Terry Bergolt's bank granted him a single-payment loan of $4,400 at an interest rate of 6% exact interest. The term of the loan is 72 days. 1a. What is the exact interest? 1b) What is the maturity value of the loan? 2. Jane Dimas obtained a single-payment loan of $420 to pay a repair bill. She agreed to repay the loan in 90 days at an interest rate of 6.25% ordinary interest 2a. What is the ordinary interest? 2b. What is the maturity value of the loan?
Pamela borrowed $12,000 for investment purposes on March 12 on a demand note providing for a variable rate of interest and payment of any accrued interest on December 31. She repaid $1,230 on June 17, $1,880 on September 10, and $3,460 on November 8. How much is the final payment on December 31 if the rate of interest was 11.5% on March 12, 8.75% effective August 1, and 6.45% effective October 1? (Use the Declining Balance Approach) June 17 Payment Calculate the interest accrued to June 17. Calculate the amount of the payment that can be applied to the principal. Calculate the remaining principal. September 10 Payment Calculate the interest accrued to August 1. Calculate the interest accrued to September 10. Calculate the amount of the payment that can be applied to the principal. Calculate the remaining principal. November 8 Payment Calculate the interest accrued to October 1. Calculate the interest accrued to November 8. Calculate the amount of the payment that can be applied to the…
On March 1, Minnerly Motors obtains a business loan from a local bank. Theloan is a $25,000 interest-only loan with a nominal rate of 11%. Interest iscalculated on a simple interest basis with a 365-day year. What is Minnerly’sinterest charge for the first month (assuming 31 days in the month)?
On June 15, Julio borrowed $950.00 from Sheridan Credit Union at 6.1% per annum calculated on the daily balance. He gave the credit union six cheques for $150 00 dated the 15th of each of the next six months starting July 15 and a cheque dated January 15 for the remaining balance to cover payment of interest and repayment of principal. Construct a complete repayment schedule for the loan including totals for Amount Paid, Interest Paid, and Principal Repaid Complete the repayment schedule below (Round to the nearest cent as needed.) Balance Before Payment $950.00 Payment Number 0 June 15 1 July 15 Amount Paid $150.00 Interest Paid Principal Repaid Balance After Payment. $950.00
The Continental Bank made a loan of $21,000.00 on March 4 to Dr. Hirsch to purchase equipment for her office. The loan was secured by a demand loan subject to a variable rate of interest that was 8% on March 4. The rate of interest was raised to 8.4% effective July 1 and to 8.9% effective September 1. Dr. Hirsch made partial payments on the loan as follows: $700 on May 4; $1000 on June 29; and $400 on October 18. Each payment is first applied to any accumulated interest. Any remainder is then used to reduce the outstanding principal. The terms of the note require payment on October 31 of any interest not paid off by partial payments. How much must Dr. Hirsch pay on October 31? Dr. Hirsch must pay $ on October 31. (Round the final answer to the nearest cent as needed. Round all intermediate values to six decimal places as needed.)
A borrower has two alternatives for a loan: (1) issue a $420,000, 30-day, 6% note or (2) issue a $420,000, 30-day note that the creditor discounts at 6%. Assume a 360-day year. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Calculate the amount of the interest expense for each option. Round your answer to the nearest dollar. $ fill in the blank 2 for each alternative. Determine the proceeds received by the borrower in each alternative. Round your answers to the nearest dollar. (1) $420,000, 30-day, 6% interest-bearing note: $ fill in the blank 3 (2) $420,000, 30-day note discounted at 6%: $ fill in the blank 4 Alternative 1 is more favorable to the borrower because the borrower receives more cash .
You have a credit card with an APR (Annual Percentage Rate) of 12%. You begin with a balance of $200, in response to which you make a payment of $75. The first month you make charges amounting to $50. You make a payment of $75 to reduce the new balance, and the second month you charge $60. Previous balances, payments and purchases for the months 1 and 2 are given in the table below: Month Previous Balance Payment Purchases Finance Charge New Balance 1 $200 $75 $50 a:$ b:$ 2 $ $75 $60 c:$ d:$
Ada signed a simple discount promissory note for $5,400. The discount rate is 11%, and the term of the note is 6 months. What are Ada's proceeds on the loan? A. $4,411 B. $4,806 C. $4,906 D. $5,103
On October 31st, David signed a 4-month, $5,000 simple interest loan earning 7. Find the maturity date, interest, and maturity value.
Paul and Sandy Moede signed an $8000 note at Citizen's Bank. Citizen's charges a 6.50% discount rate. Assume the loan is for 300 days. Find the Effective rate