Charming Paper Company sells to the 12 accounts listed here. Receivable Balance
ID: 2791955 • Letter: C
Question
Charming Paper Company sells to the 12 accounts listed here. Receivable Balance Outstanding Average Age of the Account Over the Last Year Account $63,400 B. 165,000 77,300 21,600 50,000 297,000 32,200 349,000 40,100 98,500 229,000 63,000 12 34 23 31 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 expenseExplanation / Answer
a.
Sum of Balances averaging 30 days or less = $63,400 + $77,300 + $32,200 + $229,000 = $401,900
Sum of Balances averaging from 31 days to 40 days = $297,000 + $40,100 + $63,000 = $400,100
Sum of Balances averaging from 41 days to 45 days = $165,000 + $50,000 = $215,000
Maximum qualifying loan = ($401,900 * 90%) + ($400,100 * 80%) + (215,000 * 70%) = $832,290
b.
Annual loan rate = 16.5% + 4.5% = 21%
One month interest expense = $832,290 * 21% * 1/12 = $14,565.08