Answered step by step
Verified Expert Solution
Question
1 Approved Answer
i need to find the Formula1 1) U.S. U.S. 96% (4) Sun 11:11 AM QE Q- Search in Sheet Quick Search Excel File Edit View
i need to find the Formula1
1) U.S. U.S. 96% (4) Sun 11:11 AM QE Q- Search in Sheet Quick Search Excel File Edit View Insert Format Tools Data Window Help Show function on cell-1.xlsx ,,, fx 100% New Templates Open Save Print Cut Copy Paste Format Undo Redo AutoSum Sort Filter Formula Bar Toolbox Media Zoom At Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Fill Calibri (Body) - 11 - A- A abc Wrap Text General Clear I U B Paste A A GE 99 % %) Help Format Cells Themes HA Normal Aa DE DDDDD XI. , HH Delete LC ... Merge 4.0 .00 .00 >.0 Bad Conditional Formatting Insert Format Themes Aa, H 1 K L M N o Q R J24 ( fx A B C D E F G 1 2 Q1: FILL FORMULAS BY CORRECT FUNCTIONS: 3 4 AGING 5 Aging Accounts Receivable 6 7 Date: December, 31/2019 8 9 7:25A57:247:26 Analysis of Accounts Receivable by Age 10 Not 1-30 31-60 61-90 Over 90 11 Yet Days Days Days Days 12 Customer Total Due Past Due Past Due Past Due Past Due 13 $5,400 $2,600 FORMULA1 $2,000 14 B 8,700 5,600 1,900 FORMULA2 15 12,000 3,000 3,000 2,000 2,000 FORMULA3 16 D 4,000 3,800 FORMULA4 17 17 E 1,500 FORMULA5 800 18 18 F 7,000 FORMULA6 1,000 640 1,400 460 19 Totals $38,600 $15,000 $5,900 $3,400 $3,260 20 21 Estimate of Probable 22 Uncollectible Accounts Expense 23 Percent of Total 24 uncollectable UncolIECTABLE 25 Not yet due 3% FORMULA7 26 20 1-30 days past due 5% FORMAUL8 27 31-60 days past due 7% FORMUALS 28 61-90 days past due 9% FORMULA10 29 Over 90 days past due 11% % FORMULA11 30 Totals FORMULA12 31 32 33 KI $2,640 + 1 C 62 Normal View Ready Sum-0 DULO 24 (A) OTO: OStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started