PLEASEEE HURRRYYY IM IN A TESTUse a spreadsheet to solve this business problem. The owners of an electronics store want to find which of their products makes the most profit during the past month. 100 MP3 players at $200 with a profit of 40%

60 televisions at $700 with a profit of 22%

40 DVD players at $350 with a profit of 38%

200 computer monitors at $280 with a profit of 29%

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 3.50 percent over prime to charming as its annual loan rate. a. determine the maximum loan for which charming paper company could qualify.