EXCEL FORMULA Required. Accessibility tab summary: Students please use the information below to complete the question completing the required cells. Given information for this question is presented in rows $6$ through $12.$ The required answers are in rows $18$ through $21.$Kyoto Joe, Inc., sells earnings forecasts for$$Japanese securities$.$ Its credit terms are $2/10,$ net $30.$ Based on experience, $65$ percent$$of all customers will take the discount. a$.$ What is the average collection period for the company? b$.$ If the company sells $980$ forecasts every month at a price of $$1,670$ each, what is$$its average balance sheet amount in accounts receivable?Input Area:Terms$2\%/10$Net$30$Percentage taking discount$65\%$Units sold per period $980$Sales price$$1,670$Days per year $365$Months per year $12($Use cells A$6$ to D$12$ from the given information to complete this question.$)$Output Area:Average collection period$$Total annual sales$$7,879,200$Receivables turnover $30\mathrm{.}4167$Average receivables balance$$ Kyoto Joe, Inc., sells earnings forecasts for Japanese securities$.$ Its credit terms are $2//10,$ net $30.$ Based on experience, $65$ percent of all customers will take the discount. a$.$ What is the average collection period for the company? b$.$ If the company sells $980$ forecasts every month at a price of $$1,670$ each, what is its average balance sheet amount in accounts receivable? $($Use cells A$6$ to D$12$ from the given information to complete this question.$)$ Output Area: Average collection period Total annual sales Receivables turnover Average receivables balance