This is an excel question having trouble to figure out formulas. Please write them out. Create a formula for each age category, using the Excel IF function to determine where each customer amount belongs.Calculate each "Total" cell by using the Excel SUM function and Include all possible cells. Leave no cells blank.HINT: Use the =AND function to check for date ranges. For example, =IF(AND(E8>30,E8<=60),[VALUE IF TRUE],[VALUE IF FALSE]))Number of Days UnpaldCustomer0-3031-6061-90Over 90TotalFitness ManiaHealth for LifeHolistic Health OptionsImage ReimagingToday's Gym WorldWhole Life Fitness CenterWorkouts UnlimitedTotal Accounts RecelvableEstimated Uncollectible( %)Estimated Uncollectible ($)2%10%25%45% Xercise Cycles Company sells exercise equipment to gyms on account. At year end, the following accounts receivable were uncollected.Required:1) Calculate the number of days unpaid, using the Excel DAYS function.Number of DaysToday's Date12/31/202212/31/2022CustomerAmountInvoice DateUnpaldFitness Mania$2,5006/17/20221,90012,7507,000Health for Life12/21/2022Holistic Health OptionsImage ReimagingToday's Gym World10/12/202212/5/2022|11/29/202211/20/202212/31/202212/31/202212/31/202212/31/202212/31/20224,600Whole Life Fitness Center15,900Workouts Unlimited3,80010/2/2022Total$48,450

Estimated Uncollectible - Estimated Uncollectible is the debtors which are due for the period of…

Create a formula for each age category, using the Excel IF function to determine where each customer amount belongs. Calculate each "Total" cell by using the Excel SUM function and include all possible cells. Leave no cells blank. HINT: Use the =AND function to check for date ranges. For example, =IF(AND(E8>30,E8<=60),[VALUE IF TRUEJ,[VALUE IF FALSE])) Number of Days Unpald Customer 0-30 31-60 61-90 Over 90 Total Fitness Mania Health for Life Holistic Health Options Image Reimaging Today's Gym World Whole Life Fitness Center Workouts Unlimited Total Accounts Receivable Estimated Uncollectible( %) Estimated Uncollectible ($) 2% 10% 25% 45%

Create a formula for each age category, using the Excel IF function to determine where each customer amount belongs. Calculate each "Total" cell by using the Excel SUM function and include all possible cells. Leave no cells blank. HINT: Use the =AND function to check for date ranges. For example, =IF(AND(E8>30,E8<=60),[VALUE IF TRUEJ,[VALUE IF FALSE])) Number of Days Unpald Customer 0-30 31-60 61-90 Over 90 Total Fitness Mania Health for Life Holistic Health Options Image Reimaging Today's Gym World Whole Life Fitness Center Workouts Unlimited Total Accounts Receivable Estimated Uncollectible( %) Estimated Uncollectible ($) 2% 10% 25% 45%

Principles of Accounting Volume 1

19th Edition

ISBN:9781947172685

Author:OpenStax

Publisher:OpenStax

Chapter12: Current Liabilities

Section: Chapter Questions

Problem 11EB: Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from...

See similar textbooks

Similar questions

The following transactions were completed by Hammond Auto Supply during January, which is the first month of this fiscal year. Terms of sale are 2/10, n/30. The balances of the accounts as of January 1 have been recorded in the general ledger in your Working Papers or in CengageNow. Hammond Auto Supply does not track cash sales by customer. Jan. 2Issued Ck. No. 6981 to JSS Management Company for monthly rent, 775. 2J. Hammond, the owner, invested an additional 3,500 in the business. 4Bought merchandise on account from Valencia and Company, invoice no. A691, 2,930; terms 2/10, n/30; dated January 2. 4Received check from Vega Appliance for 980 in payment of 1,000 invoice less discount. 4Sold merchandise on account to L. Paul, invoice no. 6483, 850. 6Received check from Petty, Inc., 637, in payment of 650 invoice less discount. 7Issued Ck. No. 6982, 588, to Fischer and Son, in payment of invoice no. C1272 for 600 less discount. 7Bought supplies on account from Doyle Office Supply, invoice no. 1906B, 108; terms net 30 days. 7Sold merchandise on account to Ellison and Clay, invoice no. 6484, 787. 9Issued credit memo no. 43 to L. Paul, 54, for merchandise returned. 11Cash sales for January 1 through January 10, 4,863.20. 11Issued Ck. No. 6983, 2,871.40, to Valencia and Company, in payment of 2,930 invoice less discount. 14Sold merchandise on account to Vega Appliance, invoice no. 6485, 2,050. Jan. 18Bought merchandise on account from Costa Products, invoice no. 7281D, 4,854; terms 2/10, n/60; dated January 16; FOB shipping point, freight prepaid and added to the invoice, 147 (total 5,001). 21Issued Ck. No. 6984, 194, to M. Miller for miscellaneous expenses not recorded previously. 21Cash sales for January 11 through January 20, 4,591. 23Issued Ck. No. 6985 to Forbes Freight, 96, for freight charges on merchandise purchased on January 4. 23Received credit memo no. 163, 376, from Costa Products for merchandise returned. 29Sold merchandise on account to Bruce Supply, invoice no. 6486, 1,835. 31Cash sales for January 21 through January 31, 4,428. 31Issued Ck. No. 6986, 53, to M. Miller for miscellaneous expenses not recorded previously. 31Recorded payroll entry from the payroll register: total salaries, 6,200; employees federal income tax withheld, 872; FICA Social Security tax withheld, 384.40, FICA Medicare tax withheld, 89.90. 31Recorded the payroll taxes: Social Security tax, 384.40, FICA Medicare tax, 89.90; state unemployment tax, 334.80; federal unemployment tax, 37.20. 31Issued Ck. No. 6987, 4,853.70, for salaries for the month. 31J. Hammond, the owner, withdrew 1,000 for personal use, Ck. No. 6988. Required 1. Record the transactions in the general journal for January. If you are using Working Papers, start with page 1 in the journal. Assume the periodic inventory method is used. The chart of accounts is as follows: 2. Post daily all entries involving customer accounts to the accounts receivable ledger. 3. Post daily all entries involving creditor accounts to the accounts payable ledger. 4. Post daily the general journal entries to the general ledger. Write the owners name in the Capital and Drawing accounts. 5. Prepare a trial balance. 6. Prepare a schedule of accounts receivable and a schedule of accounts payable. Do the totals equal the balances of the related controlling accounts?
The following transactions were completed by Yang Restaurant Equipment during January, the first month of this fiscal year. Terms of sale are 2/10, n/30. The balances of the accounts as of January 1 have been recorded in the general ledger in your Working Papers or in CengageNow. Yang Restaurant Equipment does not track cash sales by customer. Jan. 2Issued Ck. No. 6981 to Tri-County Management Company for monthly rent, 850. 2L. Yang, the owner, invested an additional 4,500 in the business. 4Bought merchandise on account from Valentine and Company, invoice no. A694, 2,830; terms 2/10, n/30; dated January 2. 4Received check from Velez Appliance for 980 in payment of invoice for 1,000 less discount. 4Sold merchandise on account to L. Parrish, invoice no. 6483, 755. 6Received check from Peck, Inc., 637, in payment of 650 invoice less discount. 7Issued Ck. No. 6982, 588, to Frost and Son, in payment of invoice no. C127 for 600 less discount. 7Bought supplies on account from Dudley Office Supply, invoice no. 190B, 93.54; terms net 30 days. 7Sold merchandise on account to Ewing and Charles, invoice no. 6484, 1,115. 9Issued credit memo no. 43 to L. Parrish, 47, for merchandise returned. 11Cash sales for January 1 through January 10, 4,454.87. 11Issued Ck. No. 6983, 2,773.40, to Valentine and Company, in payment of 2,830 invoice less discount. 14Sold merchandise on account to Velez Appliance, invoice no. 6485, 2,100. 14Received check from L. Parrish, 693.84, in payment of 755 invoice, less return of 47 and less discount. Jan. 19Bought merchandise on account from Crawford Products, invoice no. 7281, 3,700; terms 2/10, n/60; dated January 16; FOB shipping point, freight prepaid and added to invoice, 142 (total 3,842). 21Issued Ck. No. 6984, 245, to A. Bautista for miscellaneous expenses not recorded previously. 21Cash sales for January 11 through January 20, 3,689. 23Received credit memo no. 163, 87, from Crawford Products for merchandise returned. 29Sold merchandise on account to Bradford Supply, invoice no. 6486, 1,697.20. 29Issued Ck. No. 6985 to Western Freight, 64, for freight charges on merchandise purchased January 4. 31Cash sales for January 21 through January 31, 3,862. 31Issued Ck. No. 6986, 65, to M. Pineda for miscellaneous expenses not recorded previously. 31Recorded payroll entry from the payroll register: total salaries, 5,899.95; employees federal income tax withheld, 795; FICA Social Security tax withheld, 365.80, FICA Medicare tax withheld, 85.50. 31Recorded the payroll taxes: FICA Social Security tax, 365.80; FICA Medicare tax, 85.50; state unemployment tax, 318.60; federal unemployment tax, 35.40. 31Issued Ck. No. 6987, 4,653.65, for salaries for the month. 31L. Yang, the owner, withdrew 1,000 for personal use, Ck. No. 6988. Required 1. Record the transactions in the general journal for January. If you are using Working Papers, start with page 1 in the journal. Assume the periodic inventory method is used. The chart of accounts is as follows: 2. Post daily all entries involving customer accounts to the accounts receivable ledger. 3. Post daily all entries involving creditor accounts to the accounts payable ledger. 4. Post daily the general journal entries to the general ledger. Write the owners name in the Capital and Drawing accounts. 5. Prepare a trial balance. 6. Prepare a schedule of accounts receivable and a schedule of accounts payable. Do the totals equal the balances of the related controlling accounts?
The following transactions were completed by Yang Restaurant Equipment during January, the first month of this fiscal year. Terms of sale are 2/10, n/30. The balances of the accounts as of January 1 have been recorded in the general ledger in your Working Papers or in CengageNow. Yang Restaurant Equipment does not track cash sales by customer. Jan. 2Issued Ck. No. 6981 to Tri-County Management Company for monthly rent, 850. 2L. Yang, the owner, invested an additional 4,500 in the business. 4Bought merchandise on account from Valentine and Company, invoice no. A694, 2,830; terms 2/10, n/30; dated January 2. 4Received check from Velez Appliance for 980 in payment of invoice for 1,000 less discount. 4Sold merchandise on account to L. Parrish, invoice no. 6483, 755. 6Received check from Peck, Inc., 637, in payment of 650 invoice less discount. 7Issued Ck. No. 6982, 588, to Frost and Son, in payment of invoice no. C127 for 600 less discount. 7Bought supplies on account from Dudley Office Supply, invoice no. 190B, 93.54; terms net 30 days. 7Sold merchandise on account to Ewing and Charles, invoice no. 6484, 1,115. 9Issued credit memo no. 43 to L. Parrish, 47, for merchandise returned. 11Cash sales for January 1 through January 10, 4,454.87. 11Issued Ck. No. 6983, 2,773.40, to Valentine and Company, in payment of 2,830 invoice less discount. 14Sold merchandise on account to Velez Appliance, invoice no. 6485, 2,100. 14Received check from L. Parrish, 693.84, in payment of 755 invoice, less return of 47 and less discount. Jan. 19Bought merchandise on account from Crawford Products, invoice no. 7281, 3,700; terms 2/10, n/60; dated January 16; FOB shipping point, freight prepaid and added to invoice, 142 (total 3,842). 21Issued Ck. No. 6984, 245, to A. Bautista for miscellaneous expenses not recorded previously. 21Cash sales for January 11 through January 20, 3,689. 23Received credit memo no. 163, 87, from Crawford Products for merchandise returned. 29Sold merchandise on account to Bradford Supply, invoice no. 6486, 1,697.20. 29Issued Ck. No. 6985 to Western Freight, 64, for freight charges on merchandise purchased January 4. 31Cash sales for January 21 through January 31, 3,862. 31Issued Ck. No. 6986, 65, to M. Pineda for miscellaneous expenses not recorded previously. 31Recorded payroll entry from the payroll register: total salaries, 5,899.95; employees federal income tax withheld, 795; FICA Social Security tax withheld, 365.80, FICA Medicare tax withheld, 85.50. 31Recorded the payroll taxes: FICA Social Security tax, 365.80; FICA Medicare tax, 85.50; state unemployment tax, 318.60; federal unemployment tax, 35.40. 31Issued Ck. No. 6987, 4,653.65, for salaries for the month. 31L. Yang, the owner, withdrew 1,000 for personal use, Ck. No. 6988. Required 1. Record the transactions for January using a sales journal, page 91; a purchases journal, page 74; a cash receipts journal, page 56; a cash payments journal, page 63; and a general journal, page 119. Assume the periodic inventory method is used. 2. Post daily all entries involving customer accounts to the accounts receivable ledger. 3. Post daily all entries involving creditor accounts to the accounts payable ledger. 4. Post daily those entries involving the Other Accounts columns and the general journal to the general ledger. Write the owners name in the Capital and Drawing accounts. 5. Add the columns of the special journals and prove the equality of the debit and credit totals. 6. Post the appropriate totals of the special journals to the general ledger. 7. Prepare a trial balance. 8. Prepare a schedule of accounts receivable and a schedule of accounts payable. Do the totals equal the balances of the related controlling accounts?
After all revenue and expenses have been closed at the end of the fiscal period ended December 31, Income Summary has a debit of 45,550 and a credit of 36,520. On the same date, D. Mau, Drawing has a debit balance of 12,000 and D. Mau, Capital had a beginning credit balance of 63,410. a. Journalize the entries to close the remaining temporary accounts. b. What is the new balance of D. Mau, Capital after closing the remaining temporary accounts? Show your calculations.
Review the following transactions and prepare any necessary journal entries. A. On January 5, Bunnet Co. purchases 350 aprons (Supplies) at $25 per apron from a supplier, on credit. Terms of the purchase are 3/10, n/30 from the invoice date of January 5. B. On February 18, Melon Construction receives advance cash payment from a client for construction services in the amount of $20,000. Melon had yet to provide construction services as of February 18. C. On March 21, Noonan Smoothies sells 875 smoothies for $4 cash per smoothie. The sales tax rate is 6.5%. D. On June 7, Organic Methods paid a portion of their noncurrent note in the amount of $9,340 cash.
EXPENSE METHOD OF ACCOUNTING FOR PREPAID EXPENSES Davidsons Food Mart paid 1,200 in advance to the local newspaper for advertisements that will appear monthly. The following entry was made: At the end of the year, December 31, 20--, Davidson received notification that advertisements costing 800 had been run. Prepare the adjusting entry.
Whole Leaves wants to upgrade their equipment, and on January 24 the company takes out a loan from the bank in the amount of $310,000. The terms of the loan are 6.5% annual interest rate, payable in three months. Interest is due in equal payments each month. Compute the interest expense due each month. Show the journal entry to recognize the interest payment on February 24, and the entry for payment of the short-term note and final interest payment on April 24. Round to the nearest cent if required.
On January 1, Incredible Infants sold goods to Babies Inc. for $1,540, terms 30 days, and received payment on January 18. Which journal would the company use to record this transaction on the 18th? A. sales journal B. purchases journal C. cash receipts journal D. cash disbursements journal E. general journal
The trial balance of Jillson Company as of December 31, the end of its current fiscal year, is as follows: Here are the data for the adjustments. ab. Merchandise Inventory at December 31, 54,845.00. c. Store supplies inventory (on hand), 488.50. d. Insurance expired, 680. e. Salaries accrued, 692. f. Depreciation of store equipment, 3,760. Required Complete the work sheet after entering the account names and balances onto the work sheet.
Reviewing insurance policies revealed that a single policy was purchased on March 1, for one years coverage, in the amount of $9,000. There was no previous balance in the Prepaid Insurance account at that time. Based on the information provided, A. Make the December 31 adjusting journal entry to bring the balances to correct. B. Show the impact that these transactions had.
xercise cycles company sells exercise equipment to gyms on account. At year-end, the following accounts receivable were uncollected. Require A)calculate the number of days unpaid, using excel DAYS function?
You have been provided with the end of year, unadjusted trial balance for City Movers LTD and a list of balance day adjustments to be entered into the General Journal. CITY MOVERS UNADJUSTED TRIAL BALANCE AS AT 31st August 2021 Cash at bank 60080 Accounts Receivable 68250 Allowance for Doubtful Debts 1500 Prepaid Insurance 3600 Moving Van 45000 Acc. Depreciation- Van 9000 Capital – Gui Nash 102000 Drawings – Gui Nash 16,500 Fees Revenue 90930 Moving staff wages 10000 Total 203430 203430 Additional Information The annual Insurance policy was paid on 1st June 2021. An Accounts Receivable of $750 is uncollectable and is to be written off. The policy is to have the Allowance for Doubtful Debts equal to 2% of accounts receivable Moving van is depreciated at 10% per annum straight line method. Wages amounting to $ 950 had been incurred but not been paid as at 31st August 2021. Required:…