Question

Charming Paper Company sells to the 12 accounts listed here. Average Age of the Account Over the Last Year Account 29 43 Receivable Balance Outstanding $ 63,400 165,000 77,300 21,600 50,000 297,000 32,200 349,000 40,100 98,500 229,000 63,000 Capital Financial Corporation will lend 90 percent against account balances that have averaged 30 days or less, 80 percent for account balances between 31 and 40 days, and 70 percent for account balances between 41 and 45 days. Customers that take over 45 days to pay their bills are not considered acceptable accounts for a loan. The current prime rate is 16.50 percent, and Capital charges 4.50 percent over prime to Charming as its annual loan rate. a. Determine the maximum loan for which Charming Paper Company could qualify. Maximum loan amount b. Determine how much one month's interest expense would be on the loan balance determined in part a. (Do not round intermediate calculations. Round your final answer to 2 decimal places.) Interest expense

Answer 1

Answer:

a)Maximum Loan Amount
Average receivable days' range	Loan Amount
30 days or less	90% x ($63400+77300+32200+229000) = $361,710
Between 31 days & 40 days	80% x ($297000 + $40100 + $63000) = $320,080
Between 41 days & 45 days	70% x ($165000+ $50000) = $150,500
over 45 days	$0
Maximum loan amount	$832,290
b) Annual loan rate = Prime rate + extra charges over prime = 16.50% + 4.50% = 21%
Monthly interest expense = $832,290 x 21% x 1/ 12 = $14,565.075 or $14,565.08