Question

Charming Paper Company sells to the 12 accounts listed here. Average Age of the Account Over the Last Year 25 43 19 57 42 39 24 67 32 59 Receivable Balance Outstanding $ 63,600 133,000 73,300 29,100 56,100 253,000 33,400 349,000 45,300 90,600 237,000 61,000 Account A B K 15 37 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 as its annual loan rate The current prime rate is 12.50 percent, and Capital charges 4.50 percent over prime to Charming 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

0-30 days Amount 41-45 days Amount 31-40 days Amount $ 63,600 F A $133,000 $56,100 $189,100 253,000 B $ 73,300 C 45,300 E Total L 61,000 33,400 Total K $237,000 $407,300 Loan% 70% 359,300 Total $132,370 Loan % 80% Loan 90% 287,440 Loan % Loan Loan $366,570 Maximum loan amount $ 786,380 -366570+287440+132370 Interest expense $11,140.38 -786380*17%/12