Question

In: Accounting

Mott Company has a line of credit with Bay Bank. Mott can borrow up to $570,000...

Mott Company has a line of credit with Bay Bank. Mott can borrow up to $570,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 year. 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 payable in cash on the last day of the month. The interest rate is applied to the outstanding monthly balance. For example, Mott pays 8 percent (7 percent + 1 percent) annual interest on $75,000 for the month of January. Month Amount Borrowed or (Repaid) Prime Rate for the Month, % January $ 75,000 7 February 57,000 7 March (50,000 ) 8 April through October No change No change November (36,000 ) 8 December (22,000 ) 7 Mott earned $42,000 of cash revenue during the year.

b.Prepare an income statement, balance sheet, and statement of cash flows for the year.

Complete this question by entering your answers in the tabs below.

  • Income Statement
  • Balance Sheet
  • Stmt of Cash Flows

Prepare the income statement for the year.

Solutions

Expert Solution

Solution

MOTT Company
Income statement
Cash Revenue $        42,000.00
Expenses
Interest expense
(refer calculations) $          6,805.00
$        35,195.00
MOTT Company
Balance sheet
Assets
Total current and non current assets
Libilities
Current liabilities
Bank overdraft $        24,000.00
Stockholder's equity
Retained Earnings $        35,195.00
Total liabilities and stockholder's equity
MOTT Company
Statement of Cash Flows
Cash flows from operating activities
Cash revenue earned $                                42,000.00
Net cash flow from operating Activities $        42,000.00
Cash flow from Investing activiites $                       -  
Cash flow from finaning activities
Amount borrowed during year $                              132,000.00
Amount repaid during during $                            (108,000.00)
Interest paid during year $                                 (6,805.00)
Net cash flow from Financing Activities $        17,195.00
Net change in cash $        59,195.00
Beginning cash balance $                       -  
Ending cash balance $                       -  
Month Amount borrowed or (repaid) oustand amount Prime rate for month applicable rate Interest amount
January $                                75,000.00 $        75,000.00 7% 8% $    500.00
Feburary $                                57,000.00 $      132,000.00 7% 8% $    880.00
March $                               (50,000.00) $        82,000.00 8% 9% $    615.00
april-october $                                               -   $        82,000.00 8% 9% $ 4,305.00
november $                               (36,000.00) $        46,000.00 8% 9% $    345.00
december $                               (22,000.00) $        24,000.00 7% 8% $    160.00
Total Interest $ 6,805.00

Please give thumbs up if you like my answer :-)


Related Solutions

Mott Company has a line of credit with Bay Bank. Mott can borrow up to $570,000...
Mott Company has a line of credit with Bay Bank. Mott can borrow up to $570,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 year. 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...
Mott Company has a line of credit with Bay Bank. Mott can borrow up to $600,000...
Mott Company has a line of credit with Bay Bank. Mott can borrow up to $600,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...
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $301,500...
Colson Company has a line of credit with Federal Bank. Colson can borrow up to $301,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 2.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 $454,000...
Singer Company has a line of credit with United Bank. Singer can borrow up to $454,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...
Singer Company has a line of credit with United Bank. Singer can borrow up to $302,500...
Singer Company has a line of credit with United Bank. Singer can borrow up to $302,500 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 1.50 percent above the bank’s prime rate. Funds are borrowed or repaid on the...
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 .44 percent per month. In addition, 4 percent of the amount that you borrow must be deposited in a noninterest-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. Enter your answer as a...
You've worked out a line of credit arrangement that allows you to borrow up to $55...
You've worked out a line of credit arrangement that allows you to borrow up to $55 million at any time. The interest rate is 0.65 percent per month. In addition, 3 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.    Required: (a) What is the effective annual interest rate on this lending arrangement? (Do not round your intermediate calculations.) (Click to...
You've worked out a line of credit arrangement that allows you to borrow up to $70...
You've worked out a line of credit arrangement that allows you to borrow up to $70 million at any time. The interest rate is 0.61 percent per month. In addition, 2 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.    Required: (a) What is the effective annual interest rate on this lending arrangement? (Do not round your intermediate calculations.) (Click to...
A firm has established a revolving line of credit for $900,000 with a bank at a...
A firm has established a revolving line of credit for $900,000 with a bank at a rate of prime plus 2%. There is an annual fee of 1/2% on any unused funds. Interest is discounted on loans. Prime was 5% when the agreement was made. Assume the firm decides to take down the line for $500,000 for 60 days when the prime is at 6%. What is the effective annual rate?
A DI has $14 million in T-bills, a $9 million line of credit to borrow in...
A DI has $14 million in T-bills, a $9 million line of credit to borrow in the repo market, and $9 million in excess cash reserves with the Fed. The DI currently has borrowed $7 million in fed funds and $3 million from the Fed discount window to meet seasonal demands. a. What is the DI’s total available (sources of) liquidity? b. What is the DI’s current total uses of liquidity? c. What is the net liquidity of the DI?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT