Question

Colson Company has a line of credit with Federal Bank. Colson can borrow up to $403,000...

Colson Company has a line of credit with Federal Bank. Colson can borrow up to $403,000 at any time over the course of the 2018 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the first four months of 2018. Colson agreed to pay interest at an annual rate equal to 2.50 percent above the bank’s prime rate. Funds are borrowed or repaid on the first day of each month. Interest is payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. For example, Colson pays 6.00 percent (3.50 percent + 2.50 percent) annual interest on $78,800 for the month of January.

Month Amount Borrowed
or (Repaid)
Prime Rate for
the Month
January $ 78,800 3.50 %
February 123,200 2.50
March (17,500 ) 3.00
April 29,300 3.50

Required

  1. Compute the amount of interest that Colson will pay on the line of credit for the first four months of 2018. (Round answers to nearest whole dollar.)

  1. Compute the amount of Colson's liability at the end of each of the first four months. (Do not round intermediate calculations. Round your final answers to the nearest whole dollar.)

Homework Answers

Answer #1

amount of interest that Colson will pay on the line of credit for the first four months of 2018.

Month

(a)

Amount borrowed or repaid at

the beginning of the month

(b) ($)

Amount outstanding during the month

(c) ($)

Interest rate(prime rate + 2.5%) - expressed annually

(d)

Interest Paid

(e=c*d*1/12) ($)

January 78,800 78,800 6% 394
Feburary 123,200 202,000 5% 842
March (17,500) 184,500

5.5%

846
April 29,300 213,800 6% 1,069

LIABILITY AT THE END OF EACH MONTH

Month

Balance at the end of the month ($)

January 78,800
Feburary 202,000 (78,800+123,200)
March 184,500 (202,000-17,500)
April 213,800(184,500+29,300)

hope you got the answer, please comment for any clarification

Thankyou and all the best for future

PLEASE UPVOTE...

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Exercise 7-11 Accounting for a line of credit LO 7-6 Colson Company has a line of...
Exercise 7-11 Accounting for a line of credit LO 7-6 Colson Company has a line of credit with Federal Bank. Colson can borrow up to $390,500 at any time over the course of the 2018 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the first four months of 2018. Colson agreed to pay interest at an annual rate equal to 3.00 percent above the bank’s prime...
Singer Company has a line of credit with United Bank. Singer can borrow up to $420,000...
Singer Company has a line of credit with United Bank. Singer can borrow up to $420,000 at any time over the course of the 2016 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the first three months of 2016. Singer agreed to pay interest at an annual rate equal to 1.50 percent above the bank’s prime rate. Funds are borrowed or repaid on the first day...
Singer Company has a line of credit with United Bank. Singer can borrow up to $374,000...
Singer Company has a line of credit with United Bank. Singer can borrow up to $374,000 at any time over the course of the Year 1 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during the first three months of Year 1. Singer agreed to pay interest at an annual rate equal to 2.00 percent above the bank’s prime rate. Funds are borrowed or repaid on the...
Mott Company has a line of credit with Bay Bank. Mott can borrow up to $400,000...
Mott Company has a line of credit with Bay Bank. Mott can borrow up to $400,000 at any time over the course of the 2018 calendar year. The following table shows the prime rate expressed as an annual percentage along with the amounts borrowed and repaid during 2018. Mott agreed to pay interest at an annual rate equal to 1 percent above the bank’s prime rate. Funds are borrowed or repaid on the first day of each month. Interest is...
3. North Woods Company has a line of credit with the Olympia State Bank. North Woods...
3. North Woods Company has a line of credit with the Olympia State Bank. North Woods agreed to pay interest at an annual rate equal to 2% above the bank's prime rate. Funds are borrowed or repaid on the first day of each month and interest is paid in cash on the last day of each month. Borrowing is shown as a positive amount, and repayments are shown as negative amounts indicated by parentheses. Activity to date is given as...
The York Company has arranged a line of credit that allows it to borrow up to...
The York Company has arranged a line of credit that allows it to borrow up to $52 million at any time. The interest rate is .628 percent per month. Additionally, the company must deposit 6 percent of the amount borrowed in a non-interest bearing account. The bank uses compound interest on its line-of-credit loans. What is the effective annual rate on this line of credit?
Question 1 Company A has a line of credit with the bank. Company A can borrow...
Question 1 Company A has a line of credit with the bank. Company A can borrow up to $100,000 at prime plus 2%. In January, the company borrowed 20,000. In February, repaid $4,000. If prime for February is 4%, how much interest expense does Company A report on the income statement in February? Question 2 On January 1, 2018, Company B borrowed 50,000 signing a 3-year installment note payable with yearly cash payments of $19,402 due each December 31. Assuming...
You’ve worked out a line of credit arrangement that allows you to borrow up to $40...
You’ve worked out a line of credit arrangement that allows you to borrow up to $40 million at any time. The interest rate is .36 percent per month. In addition, 4 percent of the amount that you borrow must be deposited in a non-interest-bearing account. Assume that your bank uses compound interest on its line of credit loans. a. What is the effective annual interest rate on this lending arrangement? (Do not round intermediate calculations and enter your answer as...
On January 1, 2018, Brown Co. borrowed cash from First Bank by issuing a $42,000 face...
On January 1, 2018, Brown Co. borrowed cash from First Bank by issuing a $42,000 face value, four-year term note that had an 6 percent annual interest rate. The note is to be repaid by making annual cash payments of $12,121 that include both interest and principal on December 31 of each year. Brown used the proceeds from the loan to purchase land that generated rental revenues of $22,260 cash per year. Organize the information in accounts under an accounting...
Calculating the Effective Annual Cost of Short-Term Bank Credit M&M Beverage Company has a $300,000 line...
Calculating the Effective Annual Cost of Short-Term Bank Credit M&M Beverage Company has a $300,000 line of credit that requires a compensating balance equal to 20 percent of the loan amount. The rate paid on the loan is 7 percent per annum; $200,000 is borrowed for a 6-month period deposit with the lending bank. The dollar cost of the loan includes the interest expense and the opportunity cost of maintaining an idle cash balance equal to the 20 percent compensating...