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

Transcribed Image Text:

Colson Company has a line of credit with Federal Bank. Colson can borrow up to $435,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 1.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 5.25 percent (3.75 percent + 1.50 percent) annual Interest on $78,900 for the month of January. Amount Borrowed or (Repaid) Prime Rate for the Month Month January February $ 78,900 March April 115,200 (16,000) 33,500 3.75% 2.75 3.25 3.75 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. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required A Required B Compute the amount of interest that Colson will pay on the line of credit for the first four months of the year. (Round your answers to the nearest whole dollar.) Month Interest Paid January S 5,161 February 4,992 March April 5,161 x 5,000 Required A Required B 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.) Month January S February March April Balance End of Month 440,289 445,281 450,442 455,442 Colson Company has a line of credit with Federal Bank. Colson can borrow up to $435,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 1.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 5.25 percent (3.75 percent + 1.50 percent) annual Interest on $78,900 for the month of January. Amount Borrowed or (Repaid) Prime Rate for the Month Month January February $ 78,900 March April 115,200 (16,000) 33,500 3.75% 2.75 3.25 3.75 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. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required A Required B Compute the amount of interest that Colson will pay on the line of credit for the first four months of the year. (Round your answers to the nearest whole dollar.) Month Interest Paid January S 5,161 February 4,992 March April 5,161 x 5,000 Required A Required B 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.) Month January S February March April Balance End of Month 440,289 445,281 450,442 455,442