Question

In: Finance

Problem 16-17 Bank Financing The Raattama Corporation had sales of $3.4 million last year, and it...

Problem 16-17
Bank Financing

The Raattama Corporation had sales of $3.4 million last year, and it earned a 5% return (after taxes) on sales. Recently, the company has fallen behind in its accounts payable. Although its terms of purchase are net 30 days, its accounts payable represent 59 days' purchases. The company's treasurer is seeking to increase bank borrowing in order to become current in meeting its trade obligations (that is, to have 30 days' payables outstanding). The company's balance sheet is as follows (in thousands of dollars):

Cash $100 Accounts payable $600
Accounts receivable 300 Bank loans 700
Inventory
1,400
Accruals
200
   Current assets $1,800    Current liabilities $1,500
Land and buildings 600 Mortgage on real estate 700
Equipment 600 Common stock, $0.10 par 300
     
Retained earnings
500
Total assets
$3,000
Total liabilities and equity
$3,000
  1. How much bank financing is needed to eliminate the past-due accounts payable? Round your answer to the nearest dollar.
    $   
  2. Assume that the bank will lend the firm the amount calculated in Part a. The terms of the loan offered are 8%, simple interest, and the bank uses a 360-day year for the interest calculation. What is the interest charge for one month? (Assume there are 30 days in a month.) Round your answer to the nearest dollar. Do not round intermediate calculations.
    $   
  3. Now ignore Part b and assume that the bank will lend the firm the amount calculated in Part a. The terms of the loan are 7.5%, add-on interest, to be repaid in 12 monthly installments. Do not round intermediate calculations.
    1. What is the total loan amount? Round your answer to the nearest dollar.
      $   
    2. What are the monthly installments? Round your answer to the nearest dollar.
      $   
    3. What is the APR of the loan? Round your answer to two decimal places.
      %
    4. What is the effective rate of the loan? Round your answer to two decimal places.
      %

  4. Would you, as a bank loan officer, make this loan?
    -Select-YesNoItem 7

Solutions

Expert Solution

Bank financing

Answer to Part(a)

Amount payable current(59 days purchase)- $600

Target amount payable- 30 days purchase

Hence amount of finance needed to clear past due account payable- (600/59)*30 - $305

Answer to part (b)

Amount of loan provided by bank in part (a)- $305

Interest Rate - 8% simple interest

Interest rate for one month -8%/12 -.67%

Interest amount for one month - $305*.67% =$2.04

Answer to part (c)

(i) Amount of bank finance ( as calculated in part A) =$305

(ii) Calculation of monthly installment =

Interest Rate =7.5% Simple Interest

Monthly Interest Rate(r)= 7.5%/12 =.625%

No of Monthly Installments(n) = 12 installments

PV =305

Use formula

PMT(r,n,PV)

PMT(.625%,12,300)

=$26.03

Hence monthly installments =$26.03

(iii) APR of the loan = 7.5% (as provided in the question

(iv) Effective rate of interest =

=(1+APR/n)^n -1 =.0766 or 7.76%

Answer to part (d)

Being as bank officer, i determine that the amount of net worth of company is negative i.e common stock+ retained earning

=300+-500=-200

Hence as bank officer i am not in a favour of advancing loan to the company


Related Solutions

Eagle Corporation had $10 Million in Sales last year. Cost of goods sold were $6 Million,...
Eagle Corporation had $10 Million in Sales last year. Cost of goods sold were $6 Million, depreciation expense was $1 Million, interest payment on outstanding debt was $2 Million, and the firm’s tax rate is 35%. What was Eagle Corporation’s Net Income (after tax)? What was Eagle Corporation’s Net Cash Flow? (1 point) What would happen to Net Income and Cash Flow if Depreciation increased by $1 Million? What would happen to Net Income and Cash Flow is the Depreciation...
Last year, Carriage House Corporation had sales of $18 million and costs of goods sold of...
Last year, Carriage House Corporation had sales of $18 million and costs of goods sold of $3 million. Operating expenses amounted to $2,500,000. The firm had $8 million in 6.5% bonds outstanding. The firm had $830,000 in depreciation expense. Also, Carriage House sold 1,250 shares of Textron Corporation stock for $150 per share. Carriage House had purchased the shares for $110 per share two years ago. Carriage House also sold land for $2.8 million that it had purchased earlier for...
Seashell Mfg., Inc. had $750 million of sales last year, and it had $435 million of...
Seashell Mfg., Inc. had $750 million of sales last year, and it had $435 million of fixed assets that were used at only 65% of capacity. What is the maximum sales growth rate Seashell could achieve before it had to increase its fixed assets?
Last year LaCroix Optical had $145 million of sales, and it had $40 million of fixed...
Last year LaCroix Optical had $145 million of sales, and it had $40 million of fixed assets that were used at 75% of capacity. Use this information to solve the next two problems. In millions, by how much could LaCroix Optical sales increase before it is required to increase its fixed assets? LaCroix Optical was approached by the Department of Defense (DoD)because of their ability to manufacture the lens required for night vision goggles. LaCroix Optical is the last remaining...
Last year LaCroix Optical had $145 million of sales, and it had $40 million of fixed...
Last year LaCroix Optical had $145 million of sales, and it had $40 million of fixed assets that were used at 75% of capacity. Use this information to solve the next two problems. (10 points) In millions, by how much could LaCroix Optical sales increase before it is required to increase its fixed assets? (10 points) LaCroix Optical was approached by the Department of Defense (DoD)because of their ability to manufacture the lens required for night vision goggles. LaCroix Optical...
In 2016, the Allen Corporation had sales of $60 million, total assets of $50 million, and total liabilities of $16 million.
In 2016, the Allen Corporation had sales of $60 million, total assets of $50 million, and total liabilities of $16 million. The interest rate on the company's debt is 5.7%, and it's tax rate is 35%. The operating profit margin is 13%.Please answer: a. Compute the firm's 2016 net operating income and net income.b. Calculate the firm's operating return on assets and return on equity. (Hint: You can assume that interest must be paid on all of the firm's liabilities.)
Williams & Sons last year reported sales of $17 million,cost of goods sold (COGS) of...
Williams & Sons last year reported sales of $17 million, cost of goods sold (COGS) of $12 and an inventory turnover ratio of 2. The company is now adopting a new inventory system. If the new system is able to reduce the firm's inventory level and increase the firm's inventory turnover ratio to 3 while maintaining the same level of sales and COGS, how much cash will be freed up? Do not round intermediate calculations. Round your answer to the...
Butterfly Tractors had $18.00 million in sales last year. Costof goods sold was $8.80 million,...
Butterfly Tractors had $18.00 million in sales last year. Cost of goods sold was $8.80 million, depreciation expense was $2.80 million, interest payment on outstanding debt was $1.80 million, and the firm’s tax rate was 21%.a. What was the firm’s net income? 3.63 millionb. What was the firm’s cash flow? 6.43 millionc. What would happen to net income and cash flow if depreciation were increased by $1.80 million?(Enter your numeric answers in millions rounded to 2 decimal places. Select "unaffected"...
Butterfly Tractors had $17.50 million in sales last year. Cost of goods sold was $8.70 million,...
Butterfly Tractors had $17.50 million in sales last year. Cost of goods sold was $8.70 million, depreciation expense was $2.70 million, interest payment on outstanding debt was $1.70million, and the firm’s tax rate was 30%. a. What was the firm’s net income? (Enter your answers in millions rounded to 2 decimal places.) b. What was the firm’s cash flow? (Enter your answers in millions rounded to 2 decimal places.) c. What would happen to net income and cash flow if...
Butterfly Tractors had $21.50 million in sales last year. Cost of goods sold was $9.50 million,...
Butterfly Tractors had $21.50 million in sales last year. Cost of goods sold was $9.50 million, depreciation expense was $3.50 million, interest payment on outstanding debt was $2.50 million, and the firm’s tax rate was 30%. a. What was the firm’s net income and net cash flow? (Enter your answers in millions rounded to 2 decimal places. For example, for $3.92 million, enter "3.92", not "3920000")   Net income $  million   Net cash flow $  million b. What would happen to net income...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT