Business, 25.01.2021 21:10 dtbrooks4792

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. 1) Calculate the number of days unpaid, USING THE EXCEL DAYS FUNCTION (fx).
2) Use the information above to complete the Aging of Accounts Recievable Schedule Below.
Create a formula for each age category, using the Excel IF and AND FUNCTION (fx) to determine where each customer amount belongs.
3) Prepare the adjusting journal entry for recording bad debt expense if the allowance for doubtful accounts had the following unadjusted balance:
4) Prepare the adjusting journal entry for recording bad debt expense if the Allowance for Doubtful Accounts had the following unadjusted balance:

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 02:50

Seattle bank’s start-up division establishes new branch banks. each branch opens with three tellers. total teller cost per branch is $96,000 per year. the three tellers combined can process up to 90,000 customer transactions per year. if a branch does not attain a volume of at least 60,000 transactions during its first year of operations, it is closed. if the demand for services exceeds 90,000 transactions, an additional teller is hired and the branch is transferred from the start-up division to regular operations. required what is the relevant range of activity for new branch banks

Answers: 2

Answer

Business, 22.06.2019 13:40

After much consideration, you have chosen cancun over ft. lauderdale as your spring break destination this year. however, spring break is still months away, and you may reverse this decision. which of the following events would prompt you to reverse this decision? a. the marginal cost of going to cancun decreases.b. the marginal cost of going to ft. lauderdale decreases.c. the marginal benefit of going to cancun increases.d. the marginal benefit of going to ft. lauderdale decreases.

Answers: 2

Answer

Business, 22.06.2019 23:10

Jake and janelle loved to prepare gourmet meals for friends and family. they started a business of preparing theme-type dinners for friends who were having parties. to generate even more interest in the business, janelle created on her website. she posted pictures of events, and close-ups of the food they served. she encouraged patrons and others to post reviews, comments, and favorite recipes, and to share their own party ideas. her promotion became a dialogue between buyers of her service and the business. interactive promotion infomercials product placement broadcast

Answers: 2

Answer

Business, 22.06.2019 23:50

Mauro products distributes a single product, a woven basket whose selling price is $15 and whose variable expense is $12 per unit. the company’s monthly fixed expense is $4,200. required: 1. solve for the company’s break-even point in unit sales using the equation method. 2. solve for the company’s break-even point in dollar sales using the equation method and the cm ratio. (do not round intermediate calculations. round "cm ratio percent" to nearest whole percent.) 3. solve for the company’s break-even point in unit sales using the formula method. 4. solve for the company’s break-even point in dollar sales using the formula method and the cm ratio. (do not round intermediate calculations. round "cm ratio percent" to nearest whole percent.)

Answers: 2

Answer

You know the right answer?

Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The C...

Questions