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

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

Lacy has a $49,500.00 student loan when she graduates on May 4, and the prime rate is set at 4.5%. 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 Interest Transaction Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance (-) Principal Amount Balance after Transaction June 1 $49,500.00 Nov 30 7% (inclusive) ☐ ☐ Dec 31 7% Jan 31 7% Feb 28 7% Mar 31 7% Total combined interest…
Lacy has a $40,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.5%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $925.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 penod 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 June 1 Nov 30 (inclusive) Dec 31 Jan 31 Feb 28 Mar 31 Balance before Transaction 0 Annual Interest Rate 8% 8% 8% 8% 8% Number of Days Interest Accrued Charged Interest 0 1 Total combined interest charged for grace penod and first four months Payment (+) or Principal Balance after…
Lacy has a $50,000.00 student loan when she graduates on May 4, and the prime rate is set at 4.75%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $875.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 of Days Charged Interest Accrued Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $50,000.00 Nov 30 7.25% (inclusive) ☐ ☐ Dec 31 7.25% Jan 31 7.25% Feb 28 7.25% Mar 31 7.25% Total…
Lacy has a $45,000.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 Interest Transaction Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance (-) Principal Balance after Amount Transaction June 1 $45,000.00 Nov 30 7.75% (inclusive) Dec 31 7.75% Jan 31 7.75% Feb 28 7.75% Mar 31 7.75% Total combined…
ns Lacy has a $41,500.00 student loan when she graduates on May 4, and the prime rate is set at 5.5%. She has decided at the end of the grace period to convert the interest to principal, and she sets her fixed monthly payment at $900.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 June 11 Nov 30 (inclusive) Dec 31 Jan 31 Feb 28 Mar 31 Balance before Transaction Annual Interest Rate 8% 8% 8% 8% 8% Number Interest Accrued of Days Charged Interest U D n Total combined interest charged for grace period and first four months: Payment (+) or Principal Balance…
Amarjeet graduated from the University of Calgary on May 2 and has student loans totalling $39,000.00. The prime rate upon graduation was 3.25%. He has decided to pay in full the interest charged during the grace period (i.e., he is not converting it to principal) before starting monthly payments of $650.00 at the fixed interest rate. Complete the table below, including calculations for the grace period and the first three months of his repayment schedule. (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 Interest Transaction Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 $39,000.00 Nov 30 5.75% (inclusive) ☐ ☐ ☐ ☐ $0.00 Dec 31 8.25% $650.00 Jan 31 8.25% $650.00 Feb 29 8.25% $650.00
Amarjeet graduated from the University of Calgary on May 2 and has student loans totalling $36,000.00. The prime rate upon graduation was 4.25%. He has decided to pay in full the interest charged during the grace period (i.e., he is not converting it to principal) before starting monthly payments of $800.00 at the fixed interest rate. Complete the table below, including calculations for the grace period and the first three months of his repayment schedule. (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 Interest Transaction Rate Number Interest Accrued of Days Charged Interest Payment (+) or Advance Principal Balance after Amount Transaction (-) June 1 Nov 30 6.75% ப $0.00 (inclusive) Dec 31 9.25% $800.00 Jan 31 9.25% $800.00 Feb 29 9.25% $800.00 $36,000.00
Amarjeet graduated from the University of Calgary on May 2 and has student loans totalling $31,000.00. The prime rate upon graduation was 4.5%. He has decided to pay in full the interest charged during the grace period (i.e., he is not converting it to principal) before starting monthly payments of $800.00 at the fixed interest rate. Complete the table below, including calculations for the grace period and the first three months of his repayment schedule. (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.) Payment Date Balance Annual before Interest Transaction Rate Number Interest Accrued of Days Charged Interest Advance (-) (+) or Principal Balance after Amount Transaction June 1 Nov 30 $31,000.00 7% (inclusive) Π $0.00 Dec 31 9.5% Jan 31 9.5% $800.00 $800.00 Feb 29 9.5% $800.00
Angelica received a 12-year non-subsidized student loan of $14,000 at an annual interest rate of 5.3% (compounded monthly). She will begin repaying the loan after she graduates in 4 years. How much interest must she pay on the loan during the period of time that payments on the loan are not being made? (Round your answer to the nearest cent.) $ Determine her monthly payment on the loan.
Angelica received a 12-year non-subsidized student loan of $18,000 at an annual interest rate of 5.6% (compounded monthly). She will begin repaying the loan after she graduates in 4 years. (a) How much interest must she pay on the loan during the period of time that payments on the loan are not being made? (Round your answer to the nearest cent.) (b) Determine her monthly payment on the loan. (Round your answer to the nearest cent.)
Sandy Kupchack just graduated from State University with a bachelor’s degree in history. During her four years atthe university, Sandy accumulated $12,000 in student loans. She asks for your help in determining the amount ofthe quarterly loan payment. She tells you that the loan must be paid back in five years and that the annual interestrate is 8%. Payments begin in three months.Required:Determine Sandy’s quarterly loan payment.
Amarjeet graduated from the University of Calgary on May 2 and has student loans totalling $36,000.00. The prime rate upon graduation was 3.25%. He has decided to pay in full the interest charged during the grace period (i.e., he is not converting it to principal) before starting monthly payments of $625.00 at the fixed interest rate. Complete the table below, including calculations for the grace period and the first three months of his repayment schedule. (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 $36,000.00 Nov 30 5.75% $0.00 (inclusive) Dec 31 8.25% $625.00 Jan 31 8.25% $625.00 Feb 29 8.25% $625.00