Pleasedothese exercises and problems in Excel with Excel formulas.

total accounts receivable on December 31, 2015. The rate = 3% of the total total accounts receivable. Record this entry. Please answer in Excel with formulas Problem G. Berta Company's estimates uncollectible accounts at 1.5% of total net sales. Total net sales for the year were $230,000; receivables at year-end were$530,000; and the Allowance for Doubtful Accounts had a zero balance. Requirements: 1.Compute the estimated uncollectible accounts at the end of the fiscal using Allowance for Doubtful Account, and record this entry in the general journal, 2.What is the balance of accounts receivable, net