Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need more help with the excel "if", etc. formula

I need more help with the EXCEL "IF", etc. formulas Xercise Cycles Company...

60.1K

Verified Solution

Question

Accounting

I need more help with the EXCEL "IF", etc. formulas

Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The Controller has asked you to help prepare the Aging of Accounts Receivable Schedule and the corresponding journal entries. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.

image
image
image
please help!
You received part A C E Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected. 1 3 Required: 4 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx). 5 6 Number of Days Unpaid 197 Invoice Date Today's Date 12/31/2016 12/31/2016 12/31/2016 12/31/2016 Customer Amount 6/17/2016 12/21/2016 10/12/2016 12/5/2016 11/29/2016 8 Fitness Mania 2,500 2,000 12,750 7,000 4,600 15,900 $ 10 80 9 Health for Life 10 Holistic Health Options 11 Image Reimaging 12 Today's Gym World 13 Whole Life Fitness Center 26 12/31/2016 32 12/31/2016 12/31/2016 11/20/2016 41 10/2/2016 90 3,800 14 Workouts Unlimited 1 of 1 Next Prey NOV P w X 30 19 The IF statement may include the following arguments: ,>=, ,>=,

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students