Exercise 10-5A (Algo) Calculations for a line of credit LO 10-2 Colson Company has a line of credit with Federal Bank. Colson can borrow up to $373,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 four months of Year 1. Colson 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 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 5.25 percent (3.25 percent + 2.00 percent) annual interest on $84,800 for the month of January. Month Amount Borrowed or (Repaid) January February March April Month January February March April Required: a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of Year 1. Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar. $ 84,800 124,000 (15,200) 26,400 Prime Rate for the Interest Paid Month 3.25% 2.25 2.75 3.25 b. Compute the amount of Colson's liability at the end of each of the first four months. Note: Round your final answers to the nearest whole dollar.
Exercise 10-5A (Algo) Calculations for a line of credit LO 10-2 Colson Company has a line of credit with Federal Bank. Colson can borrow up to $373,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 four months of Year 1. Colson 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 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 5.25 percent (3.25 percent + 2.00 percent) annual interest on $84,800 for the month of January. Month Amount Borrowed or (Repaid) January February March April Month January February March April Required: a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of Year 1. Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar. $ 84,800 124,000 (15,200) 26,400 Prime Rate for the Interest Paid Month 3.25% 2.25 2.75 3.25 b. Compute the amount of Colson's liability at the end of each of the first four months. Note: Round your final answers to the nearest whole dollar.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
![Exercise 10-5A (Algo) Calculations for a line of credit LO 10-2
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $373,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 four months of Year 1. Colson 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 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 5.25 percent (3.25 percent + 2.00 percent)
annual interest on $84,800 for the month of January.
Month
January
February
Month
Amount Borrowed
or (Repaid)
January
February
March
April
$ 84,800
124,000
(15,200)
26,400
Prime Rate
for the
March
April
Required:
a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of Year 1.
Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar.
Interest Paid
Month
3.25%
2.25
2.75
3.25
b. Compute the amount of Colson's liability at the end of each of the first four months.
Note: Round your final answers to the nearest whole dollar.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb828d974-21a6-44e8-a19c-78b2b23452a3%2Fc0ebc5ef-1fc4-4152-854f-e48bc342f007%2Fp5ocm6a_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Exercise 10-5A (Algo) Calculations for a line of credit LO 10-2
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $373,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 four months of Year 1. Colson 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 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 5.25 percent (3.25 percent + 2.00 percent)
annual interest on $84,800 for the month of January.
Month
January
February
Month
Amount Borrowed
or (Repaid)
January
February
March
April
$ 84,800
124,000
(15,200)
26,400
Prime Rate
for the
March
April
Required:
a. Compute the amount of interest that Colson will pay on the line of credit for the first four months of Year 1.
Note: Do not round intermediate calculations. Round your final answers to the nearest whole dollar.
Interest Paid
Month
3.25%
2.25
2.75
3.25
b. Compute the amount of Colson's liability at the end of each of the first four months.
Note: Round your final answers to the nearest whole dollar.
![b. Compute the amount of Colson's liability at the end of each of the first four months.
Note: Round your final answers to the nearest whole dollar.
Month
January
February
March
April
Balance End of
Month
< Prev
************
3 of 10 ‒‒‒
W
N](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fb828d974-21a6-44e8-a19c-78b2b23452a3%2Fc0ebc5ef-1fc4-4152-854f-e48bc342f007%2Foa3j4kk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:b. Compute the amount of Colson's liability at the end of each of the first four months.
Note: Round your final answers to the nearest whole dollar.
Month
January
February
March
April
Balance End of
Month
< Prev
************
3 of 10 ‒‒‒
W
N
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education