Homework Help is Here – Start Your Trial Now!
Business
Finance
Lacy has a $43,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.25%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $950.00. She opts for the variable rate on her student loan. Create the first four repayments of her repayment schedule. Calculate the total interest charged for both the grace period and the four payments combined. Assume February does not involve a leap year. (Round all monetary values to the nearest penny.) (Use a minus sign before the dollar sign to denote a negative monetary value. For example, "$149.63") (Give all "Number of Days" quantities as fractions with denominator 365.) Date Balance Annual before Transaction Interest Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $43,500.00 Nov 30 7.75% (inclusive) Dec 31 7.75% Jan 31 7.75% Feb 28 7.75% Mar 31 7.75% Total combined interest charged for grace period and first four months: 4

Lacy has a $43,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.25%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $950.00. She opts for the variable rate on her student loan. Create the first four repayments of her repayment schedule. Calculate the total interest charged for both the grace period and the four payments combined. Assume February does not involve a leap year. (Round all monetary values to the nearest penny.) (Use a minus sign before the dollar sign to denote a negative monetary value. For example, "$149.63") (Give all "Number of Days" quantities as fractions with denominator 365.) Date Balance Annual before Transaction Interest Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $43,500.00 Nov 30 7.75% (inclusive) Dec 31 7.75% Jan 31 7.75% Feb 28 7.75% Mar 31 7.75% Total combined interest charged for grace period and first four months: 4

Excel Applications for Accounting Principles
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
icon
Related questions
Question

Am. 111.

Lacy has a $43,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.25%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $950.00. She opts for the variable rate on her student loan. Create the first four repayments of her repayment schedule. Calculate the total interest charged for both the grace period and the four payments combined. Assume February does not involve a leap year. (Round all monetary values to the nearest penny.) (Use a minus sign before the dollar sign to denote a negative monetary value. For example, "-$149.63".) (Give all "Number of Days" quantities as fractions with denominator 365.) Date Balance before Transaction Annual Interest Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $43,500.00 Nov 30 7.75% (inclusive) ☐ Dec 31 7.75% Jan 31 7.75% Feb 28 7.75% Mar 31 7.75% Total combined interest charged for grace period and first four months:
Transcribed Image Text:Lacy has a $43,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.25%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $950.00. She opts for the variable rate on her student loan. Create the first four repayments of her repayment schedule. Calculate the total interest charged for both the grace period and the four payments combined. Assume February does not involve a leap year. (Round all monetary values to the nearest penny.) (Use a minus sign before the dollar sign to denote a negative monetary value. For example, "-$149.63".) (Give all "Number of Days" quantities as fractions with denominator 365.) Date Balance before Transaction Annual Interest Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $43,500.00 Nov 30 7.75% (inclusive) ☐ Dec 31 7.75% Jan 31 7.75% Feb 28 7.75% Mar 31 7.75% Total combined interest charged for grace period and first four months:
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost of Credit
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS