PLEASE SHOW TO MATCH EXCEL FORMAT, THANK YOU!!!

A B C D Age of Account (in % of Total days) Account 0-10 11-30 31-45 46-60 More than 60 Total E 50.00% 31.00% 7.00% 7.00% 5.00% 100.00% F 14.3 Aging schedule: Ginseng Company collects 50 percent of its receivables in 10 days or fewer, 31 percent in 11 to 30 days, 7 percent in 31 to 45 days, 7 percent in 46 to 60 days, and 5 percent in more than 60 days. The company has $1,213,000 in accounts receivable. Prepare an aging schedule for Ginseng Company. Ginseng Company's Aging Schedule G Value of Account ($) H J