Assignment: Manilow Aging Analysis 30 PY Manilow Company has asked you to help create year-end journal entries. They are currently reporting.co o in accounts receivable and they have want you a download of their accounts receivable subsidiary leder for your view, along with the general ledger and the Gu brint out of the Allowance Account 3 2 W Instructions Calestate the following items 1. Using the attached spreadsheet complete the Net Realizable Value of Accounts Receivable in the inhalysis Allowance for doubtful accounts amount Bad debit expense 7. Manilow Company also wants to know how close they weruld be to the same result if they the of thethod monthly # Use Total credit was for the year 1.100.000 and estimated lad debt pense of sales Calculate the N of sales you would tell Mariew Company in to come close to the Allowance for det counts total from a Z option Part 1(a): Net Realizable Value Wel Manllaw Corporation Accounts Receivable Aging Analysis 30-Sep-20 Rs of current invelee date 0-30 days 31-60 days 61-90 days 31-120 days > 120 days 9/1/2020 $ 35,000.00 $ 25,000.00 $ 9/30/2020 $ 99,500.00 $ 99,500.00 $ ABC Company Assignment: Manilow Aging Analysis. Authored by: Joe Cooke. Provided by: Lumen Learning License: CC BY: Attribution 1300 1.000.00 13.000.00 Q 115.000.00 1.000.00 Country. LLC 5/2090 1/15/2020 $15.00 OG 10.000.00 $ 15,000.00 S 10.000.00 Debeca /11/2020 4/20/2020 $ 15,000.00 $ 20,000.00 - $15.000.00 1 30 000 LaLa Land //2020 $5,000.00 $ 500 1- w30/2020 125.000,00 125.000.000 1 1 1- S Mont and Sons 11/2020 8/471020 $ 2,000.00 $ 2.800.00 $ 2.000.00$ 1. $ 25,000.00 - B Operational or D/3/2020 /30/2020 $ 42,200.00 543,900.00 $ 45.000 DO 45,000.00 $ - S- $ Ready Mix 9/15/2020 W16/2030 $35.000.00 35.000.00 1- $ 40,500.00 $ 40,500.00 S- $ 95% DOS B0% 70 40% Probability of collection Not realisable value Allowance for doubtful accounts lob cape lock $65,000 3.000 bad debit witten of Reebile last month of the thical year) alw from a/31201 410,000 125.000 $15.000 $10.000 50 52 55.000 CRI44 Odtil 10/3030 5 52 52,400 SJ 62 $42.200 $35.000 SJ 62 141,500 SJ 32 $125,000 5 52 390.800 CRJ 44 $190,000 5555.000 AJE Balance as of 9/30/9019 $550,000 ah CO Part 1(b): Allowance for Doubtful Accounts Amount (entire fiscal year) Allowance for Doubtful Accounts Balfwd from 10/1/2019 $65,000 GJ 23, dtd 12/31/2019 $2,500 GJ 40. dtd FT/2020 $15.500 GJ 87, dtd 7/15/2020 $4,000 Authored by Joe Cooke. Provided by: Lumen Learning License St. Antibution $3.000 ta/1/2020 Unaduted balance AE Balance of bad/2020 540,000 540,000 aps lock Part 1(c): Bad Debt Expense (entire fiscal year) Bad Debt Expense Halfwd from 10/1/2018 control Unadjusted balance Balance as of D/30/2020 Part 2: Percentage of Sales Method Monthly Sales (annual 4,800,000.00 of sales for bad debt 0.509 Total allowance for bad debt 165,000 1 cops lock Allowance for Doubtful Account Baliw from 10/1/2019 Gudtd 19/01/2010 $2.500 40, dtd 3/7/2020 $15,500 GJ 7, dtd 2020 $4,000 Joxatda/1/2020 $3.000 Unadjusted balance AJE Balance as of 9/30/2020 $40.000 A shi $40.000 had Debt Expense Bal twd from 10/1/2010 Uradjusted balance AJE Balance as of 9/30/2020 Allowance for doubtful accounts - Part 1 ISLAVA GIV Mac centage Manilow Company should use Cannual 4.800,000.00 et sales for bad debt Total trance for bad debit Allowance to doubt accounts - Part Anh N 1 to N M shut Assignment: Manilow Aging Analysis 30 PY Manilow Company has asked you to help create year-end journal entries. They are currently reporting.co o in accounts receivable and they have want you a download of their accounts receivable subsidiary leder for your view, along with the general ledger and the Gu brint out of the Allowance Account 3 2 W Instructions Calestate the following items 1. Using the attached spreadsheet complete the Net Realizable Value of Accounts Receivable in the inhalysis Allowance for doubtful accounts amount Bad debit expense 7. Manilow Company also wants to know how close they weruld be to the same result if they the of thethod monthly # Use Total credit was for the year 1.100.000 and estimated lad debt pense of sales Calculate the N of sales you would tell Mariew Company in to come close to the Allowance for det counts total from a Z option Part 1(a): Net Realizable Value Wel Manllaw Corporation Accounts Receivable Aging Analysis 30-Sep-20 Rs of current invelee date 0-30 days 31-60 days 61-90 days 31-120 days > 120 days 9/1/2020 $ 35,000.00 $ 25,000.00 $ 9/30/2020 $ 99,500.00 $ 99,500.00 $ ABC Company Assignment: Manilow Aging Analysis. Authored by: Joe Cooke. Provided by: Lumen Learning License: CC BY: Attribution 1300 1.000.00 13.000.00 Q 115.000.00 1.000.00 Country. LLC 5/2090 1/15/2020 $15.00 OG 10.000.00 $ 15,000.00 S 10.000.00 Debeca /11/2020 4/20/2020 $ 15,000.00 $ 20,000.00 - $15.000.00 1 30 000 LaLa Land //2020 $5,000.00 $ 500 1- w30/2020 125.000,00 125.000.000 1 1 1- S Mont and Sons 11/2020 8/471020 $ 2,000.00 $ 2.800.00 $ 2.000.00$ 1. $ 25,000.00 - B Operational or D/3/2020 /30/2020 $ 42,200.00 543,900.00 $ 45.000 DO 45,000.00 $ - S- $ Ready Mix 9/15/2020 W16/2030 $35.000.00 35.000.00 1- $ 40,500.00 $ 40,500.00 S- $ 95% DOS B0% 70 40% Probability of collection Not realisable value Allowance for doubtful accounts lob cape lock $65,000 3.000 bad debit witten of Reebile last month of the thical year) alw from a/31201 410,000 125.000 $15.000 $10.000 50 52 55.000 CRI44 Odtil 10/3030 5 52 52,400 SJ 62 $42.200 $35.000 SJ 62 141,500 SJ 32 $125,000 5 52 390.800 CRJ 44 $190,000 5555.000 AJE Balance as of 9/30/9019 $550,000 ah CO Part 1(b): Allowance for Doubtful Accounts Amount (entire fiscal year) Allowance for Doubtful Accounts Balfwd from 10/1/2019 $65,000 GJ 23, dtd 12/31/2019 $2,500 GJ 40. dtd FT/2020 $15.500 GJ 87, dtd 7/15/2020 $4,000 Authored by Joe Cooke. Provided by: Lumen Learning License St. Antibution $3.000 ta/1/2020 Unaduted balance AE Balance of bad/2020 540,000 540,000 aps lock Part 1(c): Bad Debt Expense (entire fiscal year) Bad Debt Expense Halfwd from 10/1/2018 control Unadjusted balance Balance as of D/30/2020 Part 2: Percentage of Sales Method Monthly Sales (annual 4,800,000.00 of sales for bad debt 0.509 Total allowance for bad debt 165,000 1 cops lock Allowance for Doubtful Account Baliw from 10/1/2019 Gudtd 19/01/2010 $2.500 40, dtd 3/7/2020 $15,500 GJ 7, dtd 2020 $4,000 Joxatda/1/2020 $3.000 Unadjusted balance AJE Balance as of 9/30/2020 $40.000 A shi $40.000 had Debt Expense Bal twd from 10/1/2010 Uradjusted balance AJE Balance as of 9/30/2020 Allowance for doubtful accounts - Part 1 ISLAVA GIV Mac centage Manilow Company should use Cannual 4.800,000.00 et sales for bad debt Total trance for bad debit Allowance to doubt accounts - Part Anh N 1 to N M shut