subject
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:

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 04:40
Select the correct text in the passage.which sentences in the given passage explains the limitations of monetary policies? monetary policies - limitationsmonetary policies are set by the central bank to bring about growth in the economy.de can be achieved these policiesw at anden i sca poit would be fair to say that changes in the economy cannot be brought about instantly by monetary po des.monetary policy can only influence not control, economic growththe monetary policy makers do work on sining the perfect balance between demand and supply of money in the economy
Answers: 3
question
Business, 22.06.2019 07:20
Richardson hired j.c. flood company, a plumbing contractor, to correct a stoppage in the sewer line of her house. the plumbing company's 'snake' device, used to clear the line leading to the main sewer, became caught in the underground line. to release it, the company excavated a portion of the sewer line in richardson's backyard. in the process, the company discovered numerous leaks in a rusty, defective water pipe that ran parallel with the sewer line. to meet public regulations, the water pipe, of a type no longer approved for such service, had to be replaced either then or later, when the yard would have to be excavated again. the plumbing company proceeded to repair the water pipe. though richardson inspected the company's work daily and did not express any objection to the extra work involved in replacing the water pipe, she refused to pay any part of the total bill after the company completed the entire operation. j.c. flood company then sued richardson for the costs of labor and material it had furnished. (c) for what, if anything, should richardson be liable? explain."
Answers: 1
question
Business, 22.06.2019 10:50
The uptowner just paid an annual dividend of $4.12. the company has a policy of increasing the dividend by 2.5 percent annually. you would like to purchase shares of stock in this firm but realize that you will not have the funds to do so for another four years. if you require a rate of return of 16.7 percent, how much will you be willing to pay per share when you can afford to make this investment?
Answers: 3
question
Business, 22.06.2019 11:30
Money from an allowance or job is known as .
Answers: 3
You know the right answer?
Xercise Cycles Company has provided its year ended accounts receivables that were uncollected. The C...
Questions
question
Chemistry, 23.09.2019 03:30