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:

Dollywood corporation accumulates the following data concerning a mixed cost, using miles as the activity level. miles driven total cost january 10,000 $16,500 february 8,000 $14,500 march 9,000 $12,500 april 7,000 $12,000 compute the variable and fixed cost elements using the high-low method

On coral island in 2012, the labor force is 12,000, the unemployment rate is 10 percent, and the labor force participation rate is 60 percent. during 2013, 200 unemployed people found jobs and the working-age population increased by 1,000. the total number of people in the labor force did not change. the working-age population at the end of 2013 was the unemployment rate at the end of 2013 was round up to the second decimal. the labor force participation rate at the end of 2013 was round up to the second decimal.

Nell and kirby are in the process of negotiating their divorce agreement. what should be the tax consequences to nell and kirby if the following, considered individually, became part of the agreement? a. in consideration for her one-half interest in their personal residence, kirby will transfer to nell stock with a value of $200,000 and $50,000 of cash. kirby's cost of the stock was $150,000, and the value of the personal residence is $500,000. they purchased the residence three years ago for $300,000.nell's basis for the stock is $ xkirby's basis in the house is $ xb. nell will receive $1,000 per month for 120 months. if she dies before receiving all 120 payments, the remaining payments will be made to her estate.the payments (qualify, do not qualify) as alimony and are (included in, excluded from) nell's gross income as they are received.c. nell is to have custody of their 12-year-old son, bobby. she is to receive $1,200 per month until bobby (1) dies or (2) attains age 21 (whichever occurs first). after either of these events occurs, nell will receive only $300 per month for the remainder of her life.$ x per month is alimony that is (included in, excluded from) nell's gross income, and the remaining $ x per month is considered (child support, property settlement) and is (nontaxable, taxable) to nell.