Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedi 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: O

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Budget Bible Budgeting Made Simple

Authors: Jessica Charise Brant, Adrienne Homet Hand

979-8218059880

More Books

Students also viewed these Accounting questions

Question

Influences on Nonverbal Communication?

Answered: 1 week ago