Please hurry need this in 30 mins. Please do these exercises and problems in Excel with Excel formulas. Present these exercises and problems in Excel. You must apply Excel formulas. Do not simply plug in the numbers, please use formulas to calculate all values in the spreadsheets. or add an attachment

Problem F. Castro Shoes Company is in the power boat manufacturing business. As of 2015 September 1, the balance in its Accounts Receivable by Age account is $156,000. A schedule of accounts receivable by age is as follows: Balance 21,000 25,690 Current 850 570 Account Past Due In Days 31-60 1-30 350 Over 60 670 Elson, Adam Griffin, Erica 700 550 300 Castro Rod All other 109,010 25,000 accounts Totals 155 70 3,755 4,375 4,500 1,567 156,000 5,550 2,226 Use the Following Uncollectible Accounts rates: Current 1.5% 2% 10% 21% 1-30 days past due 31-60 days past due Over 60 days past due Requirements: 1. Compute the estimated uncollectible accounts at the end of the fiscal year using above rates. 2. The credit balance was $230 in Allowance for Doubtful Accounts (December 31, 2015), please calculate the amount of the adjustment for uncollectable accounts expense. This adjustment should included as a part of the adjusting entries. Record this entry 3. Elson Adam (account receivable) did not make a payment on time and the amount of $670 was classified as uncollectible and written off on Problem F. Castro Shoes Company is in the power boat manufacturing business. As of 2015 September 1, the balance in its Accounts Receivable by Age account is $156,000. A schedule of accounts receivable by age is as follows: Balance 21,000 25,690 Current 850 570 Account Past Due In Days 31-60 1-30 350 Over 60 670 Elson, Adam Griffin, Erica 700 550 300 Castro Rod All other 109,010 25,000 accounts Totals 155 70 3,755 4,375 4,500 1,567 156,000 5,550 2,226 Use the Following Uncollectible Accounts rates: Current 1.5% 2% 10% 21% 1-30 days past due 31-60 days past due Over 60 days past due Requirements: 1. Compute the estimated uncollectible accounts at the end of the fiscal year using above rates. 2. The credit balance was $230 in Allowance for Doubtful Accounts (December 31, 2015), please calculate the amount of the adjustment for uncollectable accounts expense. This adjustment should included as a part of the adjusting entries. Record this entry 3. Elson Adam (account receivable) did not make a payment on time and the amount of $670 was classified as uncollectible and written off on