Business, 26.09.2019 18:00 allyssaharrisooy50au

Receivables using excel for aging accounts receivable the lake lucerne company uses the allowance method of estimating bad debts expense. an aging schedule is prepared in order to calculate the balance in the allowance account. the percentage uncollectible is calculated as follows: 1-30 days 1% 31-60 days 2% 61-90 days 5% 91-365 days 50% after 365 days, the account is written off. use the blue shaded areas on the enter-answers tab for inputs. always use cell references and formulas where appropriate to receive full credit. copy/pasting values will not earn full points. requirements possible points 1 calculate the number of days each receivable is outstanding. 12 2 complete the schedule of accounts receivable. 45 3 journalize the adjusting entry for bad debts expense. 4 *for all requirements, enter all amounts as positive values. do not use a minus sign or parentheses for any values.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 23:00

Each of the four independent situations below describes a sales-type lease in which annual lease payments of $12,500 are payable at the beginning of each year. each is a finance lease for the lessee. (fv of $1, pv of $1, fva of $1, pva of $1, fvad of $1 and pvad of $1) (use appropriate factor(s) from the tables provided.) situation 1 2 3 4 lease term (years) 3 3 3 3 assetâ€™s useful life (years) 3 4 4 6 lessorâ€™s implicit rate (known by lessee) 14 % 14 % 14 % 14 % residual value: guaranteed by lessee 0 $ 5,000 $ 2,500 0 unguaranteed 0 0 $ 2,500 $ 5,000 purchase option: after (years) none 2 3 3 exercise price n/a $ 7,500 $ 1,500 $ 3,500 reasonably certain? n/a no no yes

Answers: 1

Answer

Business, 22.06.2019 04:40

Select the correct answerwhat is the responsibility of each of the twelve federal reserve's banks in their districts? a.they set the prime rateob.they monitor functioning of banks in their through onsite and offsite reviewsc.they assess taxes in their destnictd.they write fiscal policies

Answers: 1

Answer

Business, 22.06.2019 10:50

Jen left a job paying $75,000 per year to start her own florist shop in a building she owns. the market value of the building is $120,000. she pays $35,000 per year for flowers and other supplies, and has a bank account that pays 5 percent interest. what is the economic cost of jen's business?

Answers: 3

Answer

Business, 22.06.2019 11:10

Yowell company granted a sales discount of $360 to a customer when it collected the amount due on account. yowell uses the perpetual inventory system. which of the following answers reflects the effects on the financial statements of only the discount? assets = liab. + equity rev. − exp. = net inc. cash flow a. (360 ) = na + (360 ) (360 ) − na = (360 ) (360 ) oa b. na = (360 ) + 360 360 − na = 360 na c. (360 ) = na + (360 ) (360 ) − na = (360 ) na d. na = (360 ) + 360 360 − na = 360 na

Answers: 1

Answer

You know the right answer?

Receivables using excel for aging accounts receivable the lake lucerne company uses the allowance me...

Questions