Colson Company has a line of credit with Federal Bank. Colson can borrow up to $800,000 at any time over the course of the 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 the year. Colson agreed to pay interest at an annual rate equal to 2 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 percent (4 percent + 2 percent) annual interest on $80,000 for the month of January. Month January February March April Amount Borrowed or (Repaid) $ 80,000 50,000 (30,000) 20,000 Prime Rate for the Month 4.00% 4.25 4.50 4.25 Required a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of the year. b. Compute the amount of Colson's liability at the end of each of the first four months.

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter16: Working Capital Policy And Short-term Financing
Section: Chapter Questions
Problem 30P
icon
Related questions
Question
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $800,000 at any time over the course
of the 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 the year. Colson agreed to pay interest at an annual rate
equal to 2 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 percent (4 percent + 2 percent) annual interest on $80,000 for the month of January.
Month
January
February
March
April
Amount Borrowed
or (Repaid)
$ 80,000
50,000
(30,000)
20,000
Required
a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of the year.
b. Compute the amount of Colson's liability at the end of each of the first four months.
Required A Required B
Complete this question by entering your answers in the tabs below.
Month
Prime Rate for
the Month
January
February
March
April
4.00%
4.25
4.50
4.25
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.)
Balance End of
Month
Transcribed Image Text:Colson Company has a line of credit with Federal Bank. Colson can borrow up to $800,000 at any time over the course of the 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 the year. Colson agreed to pay interest at an annual rate equal to 2 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 percent (4 percent + 2 percent) annual interest on $80,000 for the month of January. Month January February March April Amount Borrowed or (Repaid) $ 80,000 50,000 (30,000) 20,000 Required a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of the year. b. Compute the amount of Colson's liability at the end of each of the first four months. Required A Required B Complete this question by entering your answers in the tabs below. Month Prime Rate for the Month January February March April 4.00% 4.25 4.50 4.25 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.) Balance End of Month
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Effective Annual Rate Of Return
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
Principles of Accounting Volume 1
Principles of Accounting Volume 1
Accounting
ISBN:
9781947172685
Author:
OpenStax
Publisher:
OpenStax College
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage