All requirement are attached
ACC 4230 Spring 2023 IDEA Assignment #2 Requirements You must complete the requirements listed below and submit this assignment via the Pilot Dropbox by the beginning of class on Tuesday, March 28. Also, the text of your paper should be double-spaced. Failure to follow appropriate formatting will be reflected in your grade for the assignment. Failure to submit the case when specified will result in a substantial point reduction as the penalty for late submission. Also, the assignment submitted must be each student’s own work, collaboration among students in completing this assignment is not permitted. Requirements: Part 1 Import the data file “4230 spring23 IDEA accts_rec” from Pilot into IDEA. Assume that after reviewing a list of parties related to this client, you notice that the customers with customer numbers 100316 and 100348 are related to the owners of the company. Determine the amount of accounts receivable that relates to each these related-party customers. What percent of total accounts receivable balance is made up of these two related-party customers balances? Use the table format below for your answers. (Hint: use the “Summarization” command in IDEA.) Include a “screenshot” of your IDEA summarization results showing these balances as Appendix A for this assignment. CustomerCustomer #100316#100348Total Balance of customer’s account Number of invoices in customer balance Percentage of total Accounts Receivable balance Part 2 In a brief paragraph, explain why an auditor might want to perform the procedure in Part 1 above. IDEA accts rec f22 INVOICE_NOINVOICE_DATECUSTOMER_NUMBERINVOICE_TOTALCREDIT_LIMITDUE_DATEAUTHORIZEDAR_CLERKCASH_RECEIPTS_CLERKGL_ACCOUNTING 5660542/4/22100184244.2450003/6/22YesHMKFKLCT 5661875/21/22100122995.4410006/20/22YesHMKSGMB 5662416/30/221002672057.8350007/30/22YesHMKFKLCT 5662457/28/2210014011.9550008/27/22YesHMKFKLCT 5662638/17/221001401984.1950009/16/22YesNCSFKLCT 5662658/17/221002482904.8250009/16/22YesHMKFKLCT 5662738/21/221003014837.02500011/29/22YesHMKSGMB 5662888/27/22100344642.5950009/26/22YesHMKFKLCT 5662898/28/22100235339.945009/27/22YesHMKFKLCT 5662978/31/221001331181.21500011/29/22YesHMKFKLCT 5663029/2/221003271347.56500010/2/22YesHMKSGCT 5663039/2/221001401276.29500012/1/22YesHMKFKLCT 5663059/2/221002722249.53500010/2/22YesHMKFKLCT 5663079/2/22100272898.13500012/1/22YesHMKFKLCT 5663089/2/221003291205.28500010/2/22YesNCSFKLMB 5663099/2/221001404815.91500010/2/22YesHMKFKLHMK 5663109/2/221001451093.66500012/1/22YesHMKFKLCT 5663109/2/221002901728.27500012/1/22YesHMKFKLCT 5663129/3/221003121391.08500010/3/22YesHMKFKLCT 5663139/3/221001401276.29500012/2/22YesHMKSGMB 5663149/3/221001911257.59500010/3/22YesHMKFKLMB 5663169/3/221001295975.29500010/3/22YesNCSSGCT 5663179/3/22100189829.95500012/2/22YesNCSFKLCT 5663189/3/221001404905.09500010/3/22YesHMKFKLHMK 5663199/3/221002411640.98500012/2/22YesHMKFKLCT 5663209/3/221001402943.05500010/3/22YesHMKSGMB 5663219/3/221001431914.42500012/2/22YesNCSFKLCT 5663229/4/22100346729.26500012/3/22YesHMKFKLCT 5663239/4/221001401276.29500012/3/22YesHMKFKLMB 5663249/4/22100175564.66500012/3/22YesHMKFKLCT 5663259/4/221002301605.30500010/4/22YesHMKSGMB 5663269/4/22100198893.85500012/3/22YesHMKFKLCT 5663289/4/221001403924.07500010/4/22YesHMKFKLCT 5663299/4/221003361605.30500010/4/22YesHMKFKLCT 5663329/8/22100326505.86500010/8/22YesHMKSGCT 5663339/8/221002274013.25500010/8/22YesHMKFKLCT 5663349/8/221002803190.71500012/7/22YesHMKFKLCT 5663359/8/221002551197.23500010/8/22YesHMKFKLMB 5663369/9/221003397491.41500010/9/22NoHMKSGHMK 5663379/9/221002461978.16500010/9/22YesNCSFKLCT 5663389/9/22100116638.60500010/9/22YesHMKFKLMB 5663399/9/221002731866.32500012/8/22YesHMKSGCT 5663409/10/22100302279.0350010/10/22YesHMKFKLCT 5663419/10/2210032734.59500010/10/22YesHMKFKLCT 5663429/11/221003061605.30500010/11/22YesNCSFKLCT 5663479/14/221002221605.30500010/14/22YesHMKFKLMB 5663499/14/221002101248.51500010/14/22YesHMKFKLCT 5663509/14/22100178922.13500010/14/22YesHMKFKLMB 5663519/14/22100216699.31500010/14/22YesHMKFKLMB 5663529/14/221001252391.47500012/13/22YesHMKFKLCT 5663529/14/221001904255.82500012/13/22YesHMKFKLCT 5663549/14/22100104470.56500012/13/22YesHMKSGMB 5663559/14/22100339831.11500012/13/22YesHMKSGMB 5663569/14/221002641978.32500012/13/22YesHMKFKLCT 5663579/15/22100213831.11500012/14/22YesHMKFKLMB 5663579/15/221002581000.88500012/14/22YesHMKFKLCT 5663579/15/221002991605.30500010/15/22YesHMKFKLMB 5663579/15/221003322369.95500012/14/22YesNCSFKLCT 5663639/16/221002233781.62500012/15/22YesHMKFKLMB 5663649/16/221002571058.68500012/15/22YesNCSFKLCT 5663659/16/22100179717.39500010/16/22YesNCSSGCT 5663669/16/22100167582.92500010/16/22YesHMKFKLCT 5663689/18/221001401276.29500012/17/22YesHMKSGCT 5663709/18/22100223799.77500010/18/22YesNCSFKLMB 5663749/21/22100236282.33500012/20/22YesNCSFKLCT 5663759/22/221002841886.11500012/21/22YesHMKFKLCT 5663769/22/22100126697.01500010/22/22YesHMKFKLMB 5663779/22/22100345652.87500010/22/22YesHMKFKLCT 5663799/22/22100293944.88500012/21/22YesHMKSGCT 5663819/23/22100273410.39500010/23/22YesHMKFKLMB 5663829/23/221001401276.29500012/22/22YesHMKFKLMB 5663839/23/22100132838.35500012/22/22YesHMKSGCT 5663849/23/221003093236.37500012/22/22YesNCSFKLMB 5663859/23/221002162793.33500012/22/22YesNCSFKLMB 5663869/23/221001521093.85200010/23/22YesHMKFKLCT 5663879/23/221002681518.44500012/22/22YesHMKFKLCT 5663889/24/2210011769.3850010/24/22YesHMKFKLCT 5663899/24/22100305829.95400012/23/22YesNCSFKLMB 5663919/24/221001401666.31500012/23/22YesHMKSGCT 5663929/25/221001401798.83500010/25/22YesHMKFKLCT 5663979/28/22100257529.52500010/28/22YesHMKFKLMB 5663989/28/22100173587.52500010/28/22YesHMKFKLMB 5663999/28/22100170943.08500012/27/22YesNCSFKLCT 5664009/29/22100145622.46500010/29/22YesHMKSGCT 5664019/29/2210034373.63500010/29/22YesHMKFKLCT 5664039/29/22100166858.83500010/29/22YesHMKFKLCT 5664049/29/221002891783.67200010/29/22YesHMKFKLCT 5664079/30/221002401445.74200010/30/22YesHMKFKLCT 5664089/30/22100223258.15500010/30/22YesHMKFKLCT 5664109/30/22100188994.60500012/29/22YesNCSFKLMB 5664119/30/221001431138.66500010/30/22YesHMKFKLMB 5664129/30/221001131956.87500010/30/22YesHMKFKLCT 5664139/30/221001402591.43500012/29/22YesHMKSGCT 56641610/2/2210032043.32500011/1/22YesNCSFKLMB 56641710/2/221002072174.89500012/31/22YesHMKFKLCT 56642310/5/22100291629.75500011/4/22YesHMKFKLCT 56642410/5/221001401605.30500011/4/22YesHMKFKLMB 56642510/5/221001401610.28500011/4/22YesHMKFKLCT 56642710/5/221001091605.30500011/4/22YesHMKSGMB 56642810/5/22100197510.91500011/4/22YesHMKSGCT 56642910/5/221002461322.45500011/4/22YesHMKFKLCT 56643010/5/221001481167.89500011/4/22YesNCSFKLMB 56643110/5/221002551002.71500011/4/22YesHMKFKLCT 56643210/5/22100208610.96500011/4/22YesHMKFKLCT 56643310/5/22100189430.41500011/4/22YesHMKFKLCT 56643410/5/22100330342.50500011/4/22YesHMKHMKCT 56643510/6/221001881694.48500011/5/22YesHMKFKLMB 56643710/6/22100293426.82500011/5/22YesNCSFKLCT 56643810/6/221002411248.57500011/5/22YesHMKFKLCT 56643910/6/221001761605.30500011/5/22YesHMKFKLCT 56644010/6/221001402407.95500011/5/22YesHMKSGCT 56644110/6/22100197679.40500011/5/22YesNCSFKLMB 56644210/6/221002022645.031000011/5/22YesHMKFKLCT 56644310/6/2210020214.721000011/5/22YesNCSFKLMB 56644410/6/22100261198.95500011/5/22YesHMKFKLCT 56644510/7/221003211605.30500011/6/22YesNCSFKLCT 56644610/7/2210022874.28500011/6/22YesHMKFKLCT 56644810/7/221002571996.88500011/6/22YesNCSFKLMB 56644910/8/221003481848.39200011/7/22YesNCSFKLCT 56645010/8/221001651019.61500011/7/22YesNCSFKLMB 56645110/8/22100140448.21500011/7/22YesHMKFKLCT 56645210/8/221003164561.40500011/7/22YesHMKSGCT 56645410/8/221002581605.30500011/7/22YesHMKFKLCT 56645610/9/22100307338.44500011/8/22YesHMKFKLCT 56645710/9/22100239619.06500011/8/22YesHMKSGCT 56646210/14/221002931588.75500011/13/22YesHMKFKLCT 56646310/14/221002591418.09500011/13/22YesHMKFKLCT 56646410/14/221001291134.49500011/13/22YesHMKFKLCT 56646510/14/2210014154.3250011/13/22YesNCSFKLMB 56646610/14/2210014563.91500011/13/22YesHMKFKLCT 56646710/14/221002601561.46500011/13/22NoHMKFKLHMK 56646810/14/22100264784.17500011/13/22YesNCSFKLMB 56646910/14/221003061605.30500011/13/22YesHMKSGCT 56647110/15/221001401701.53500011/14/22YesHMKFKLMB 56647310/15/22100305833.50400011/14/22YesHMKFKLCT 56647410/15/22100175935.59500011/14/22YesHMKFKLCT 56647510/15/22100278304.92100011/14/22YesNCSSGCT 56647610/16/22100197797.80500011/15/22YesNCSFKLMB 56647810/16/22100206422.91500011/15/22YesHMKSGCT 56647910/16/221001402760.51500011/15/22YesHMKFKLCT 56648210/19/22100224836.92500011/18/22YesHMKFKLMB 56648310/19/2210015149.55500011/18/22YesNCSFKLCT 56648410/19/22100276897.29100011/18/22YesHMKFKLMB 56648510/19/22100277458.10500011/18/22YesHMKFKLCT 56648610/19/22100228822.01500011/18/22YesNCSSGCT 56648710/19/2210026869.34500011/18/22YesNCSFKLCT 56648810/19/22100260968.31500011/18/22YesHMKFKLCT 56648910/19/22100188507.90500011/18/22YesHMKFKLCT 56649010/19/22100315587.91500011/18/22YesHMKFKLCT 56649110/19/22100209710.06500011/18/22YesHMKFKLMB 56649210/19/22100113824.01500011/18/22YesNCSFKLMB 56649310/19/221003441377.19500011/18/22YesNCSSGMB 56649410/19/22100232826.40500011/18/22YesHMKFKLCT 56649510/19/22100325693.82500011/18/22YesHMKFKLCT 56649610/20/22100226700.92500011/19/22YesNCSFKLCT 56649710/20/22100307975.29500011/19/22YesHMKFKLCT 56649910/20/221003169959.25500011/19/22YesHMKFKLCT 56650010/20/221001401772.62500011/19/22YesNCSSGCT 56650110/20/22100349739.87500011/19/22YesHMKFKLCT 56650310/22/221002562880.05500011/21/22YesNCSFKLCT 56650410/23/22100138920.61100011/22/22YesHMKFKLMB 56650510/23/221002301533.28500011/23/22YesHMKFKLMB 56650610/23/221002202375.64500011/22/22YesHMKFKLCT 56650910/26/22100249935.59500011/25/22YesHMKFKLMB 56651010/26/221002871242.07500011/25/22YesHMKSGCT 56651110/26/22100203990.93500011/25/22YesHMKFKLCT 56651210/27/22100322605.38500011/26/22YesNCSFKLCT 56651410/28/2210026843.32500011/27/22YesHMKFKLCT 56651510/28/221001971176.30500011/27/22YesHMKFKLCT 56651610/28/221001112842.251000011/27/22YesHMKFKLMB 56651710/28/221001611605.30500011/27/22YesHMKFKLCT 56651810/28/221003241093.91500011/27/22YesHMKFKLMB 56652010/28/22100321550.23500011/27/22YesNCSFKLCT 56652110/28/221002311670.04500011/27/22YesHMKFKLCT 56652210/28/22100140305.86500011/27/22YesHMKFKLCT 56652310/28/221001321605.30500011/27/22YesNCSFKLCT 56652410/28/22100338809.33100011/27/22YesHMKFKLCT 56652510/28/221003501150.07500011/27/22YesHMKFKLMB 56652610/28/221001401605.30500011/27/22YesHMKFKLCT 56652710/28/22100248297.28500011/27/22YesHMKFKLCT 56652810/28/221003031341.60500011/27/22YesNCSFKLMB 56652910/28/22100274346.68500011/27/22YesHMKFKLMB 56653010/28/221001872639.09500011/27/22YesNCSFKLCT 56653110/28/221002211570.82500011/27/22YesNCSFKLCT 56653210/28/221001401276.29500011/27/22YesHMKFKLCT 56653310/28/22100211672.35500011/27/22YesHMKSGCT 56653410/28/22100210216.85500011/27/22YesHMKSGMB 56653510/28/221002661093.66500011/27/22YesHMKSGCT 56653610/29/221003251159.27500011/28/22YesNCSFKLCT 56653710/29/22100152449.77100011/28/22YesHMKFKLMB 56653810/29/22100114811.32100011/28/22YesHMKFKLCT 56653910/29/22100216898.78500011/28/22YesHMKFKLCT 56654010/29/22100284969.14500011/28/22YesNCSFKLCT 56654210/29/22100200198.18500011/28/22YesNCSSGCT 56654310/30/221002321605.30500011/29/22YesHMKFKLCT 56654410/30/22100178992.20500011/29/22YesHMKSGCT 56654510/30/2210023966.04500011/29/22YesHMKFKLMB 56654610/30/22100268713.21500011/29/22YesHMKFKLMB 56654710/30/221002961866.73500011/29/22YesHMKFKLCT 56654810/30/221002241783.67500011/29/22YesHMKFKLCT 56654910/30/22100192520.06100011/29/22YesHMKFKLMB 56655110/30/221001091437.14500011/29/22YesHMKFKLCT 56655210/30/22100140210.95500011/29/22YesHMKFKLHMK 56655310/30/22100123376.43500011/29/22YesHMKFKLCT 56655410/30/22100291650.62500011/29/22YesHMKFKLMB 56655510/30/221002171565.62500011/29/22YesHMKFKLCT 56655610/30/22100247855.63500011/29/22YesNCSFKLCT 56655911/2/22100211944.93500012/2/22YesHMKFKLCT 56656011/2/22100214792.57500012/2/22YesHMKFKLMB 56656111/2/22100281297.28100012/2/22YesHMKSGCT 56656211/2/221001402337.27500012/2/22YesHMKSGMB 56656311/2/221001151016.63500012/2/22YesHMKSGMB 56656411/2/22100132860.98500012/2/22YesNCSSGCT 56656511/2/221001401276.29500012/2/22YesHMKSGCT 56656611/2/22100297631.23500012/2/22YesHMKFKLCT 56656811/2/22100225705.05100012/2/22YesHMKSGCT 56656911/2/22100185962.44500012/2/22YesHMKFKLCT 56657011/2/221003433899.35500012/2/22YesHMKSGCT 56657111/2/22100280895.09500012/2/22YesNCSSGCT 56657211/2/221003151482.69500012/2/22YesHMKFKLCT 56657311/2/221001441932.20500012/2/22YesHMKFKLCT 56657411/2/221001701315.56500012/2/22YesHMKFKLCT 56657511/2/221003164165.02500012/2/22YesHMKFKLCT 56657611/2/221001451363.69500012/2/22YesHMKSGMB 56657711/2/22100124703.17500012/2/22YesNCSFKLMB 56657911/4/221002562131.03500012/4/22YesHMKFKLCT 56658011/4/22100250898.13500012/4/22YesNCSFKLMB 56658111/4/221001754102.43500012/4/22YesHMKFKLCT 56658211/4/22100116996.43500012/4/22YesHMKFKLCT 56658311/4/22100137425.75500012/4/22YesHMKSGCT 56658411/4/22100276783.01100012/4/22YesHMKMBCT 56658511/4/22100120892.97500012/4/22YesNCSFKLCT 56658611/4/221002132087.30500012/4/22NoHMKFKLHMK 56658711/4/221002862064.34500012/4/22YesHMKFKLCT 56658811/4/22100322440.07500012/4/22YesNCSFKLCT 56658911/4/22100140482.99500012/4/22YesHMKFKLCT 56659011/4/2210033136.33500012/4/22YesHMKSGMB 56659111/4/22100184862.30500012/4/22YesHMKSGMB 56659211/4/22100329559.26500012/4/22YesNCSFKLCT 56659311/4/22100269509.45500012/4/22YesHMKFKLCT 56659411/4/2210022512.04100012/4/22YesHMKFKLCT 56659511/4/221001541692.71500012/4/22YesHMKFKLCT 56659711/4/22100275589.01100012/4/22YesHMKFKLCT 56659811/4/22100219737.13100012/4/22YesHMKFKLCT 56659911/4/221003214459.17500012/4/22YesHMKFKLCT 56660011/4/22100220132.08500012/4/22YesNCSSGMB 56660111/4/221002242545.86500012/4/22YesHMKFKLMB 56660211/5/22100216998.30500012/5/22YesHMKSGCT 56660311/5/22100140282.33500012/5/22YesHMKFKLCT 56660411/5/22100321447.97500012/5/22YesNCSFKLCT 56660511/5/22100108402.00500012/5/22YesHMKFKLMB 56660611/5/22100161550.49500012/5/22YesHMKFKLCT 56660711/5/221001482601.37500012/5/22YesHMKSGCT 56660811/5/221003051188.24400012/5/22YesHMKSGCT 56660911/5/221001771543.41500012/5/22YesHMKFKLMB 56661011/5/22100297658.77500012/5/22YesHMKFKLMB 56661111/5/22100272451.72500012/5/22YesHMKFKLCT 56661211/5/2210017943.32500012/5/22YesHMKFKLMB 56661411/5/22100141763.3250012/5/22YesHMKSGCT 56661511/5/221003131428.06500012/5/22YesHMKFKLCT 56661611/5/221001251515.16500012/5/22YesHMKFKLCT 56661711/5/2210014131.9550012/5/22YesHMKSGCT 56661811/5/22100140173.31500012/5/22YesHMKFKLMB 56661911/5/221002092318.77500012/5/22YesHMKSGMB 56662011/5/221001101211.56500012/5/22YesHMKFKLCT 56662111/5/22100198527.17500012/5/22YesHMKFKLCT 56662211/5/221003391605.30500012/5/22YesHMKFKLMB 56662411/6/221001052367.56100012/6/22YesNCSFKLCT 56662511/6/221003481325.70200012/6/22YesHMKFKLMB 56662611/6/221003153543.76500012/6/22YesHMKSGCT 56662711/6/221002281029.12500012/6/22YesHMKFKLMB 56663011/9/22100104623.70500012/9/22YesHMKFKLCT 56663111/9/22100261825.23500012/9/22YesHMKFKLCT 56663211/9/22100140198.13500012/9/22YesHMKFKLMB 56663311/9/22100287699.10500012/9/22YesNCSFKLCT 56663411/9/22100102590.19500012/9/22YesNCSSGCT 56663511/9/22100234463.50500012/9/22YesNCSFKLMB 56663611/9/221002501102.41500012/9/22YesHMKFKLCT 56663811/9/221002231094.00500012/9/22YesHMKFKLCT 56663911/9/22100237602.21500012/9/22YesHMKSGCT 56664011/9/22100212895.97500012/9/22YesHMKFKLMB 56664111/9/22100261554.46500012/9/22YesNCSFKLMB 56664211/9/22100305984.76400012/9/22YesHMKFKLCT 56664611/12/2210031049.55500012/12/22YesHMKFKLMB 56664711/12/22100146448.07500012/12/22YesHMKFKLMB 56664811/12/22100146514.17500012/12/22YesNCSFKLCT 56664911/12/22100182910.68500012/12/22YesHMKFKLMB 56665011/12/22100283132.08500012/12/22YesNCSFKLCT 56665111/12/2210022736.33500012/12/22YesHMKFKLMB 56665211/12/22100110470.30500012/12/22YesHMKFKLCT 56665411/12/22100340925.30500012/12/22YesNCSFKLCT 56665511/12/22100294888.41500012/12/22YesHMKFKLCT 56665611/12/2210024466.04100012/12/22YesHMKSGCT 56665711/12/22100168880.31500012/12/22YesHMKSGMB 56665811/12/221003351338.03500012/12/22YesHMKFKLCT 56665911/12/221002853439.84500012/12/22YesHMKFKLCT 56666011/12/22100303642.24500012/12/22YesHMKFKLCT 56666111/12/2210018043.32500012/12/22YesHMKFKLCT 56666211/12/22100107743.20100012/12/22YesHMKFKLCT 56666311/12/22100298934.21500012/12/22YesHMKFKLMB 56666411/12/22100198586.49500012/12/22YesHMKSGCT 56666511/12/221001532225.42100012/12/22YesHMKFKLCT 56666611/12/221002182321.51500012/12/22YesHMKFKLCT 56666711/12/221001313281.58500012/12/22YesNCSSGCT 56666811/13/221001404581.72500012/13/22YesHMKFKLHMK 56667211/16/22100326614.16500012/16/22YesNCSFKLCT 56667311/16/221001231982.62500012/16/22YesHMKFKLMB 56667411/16/22100253891.85500012/16/22YesHMKFKLCT 56667511/16/22100123776.98500012/16/22YesHMKSGMB 56667711/16/22100168883.39500012/16/22YesHMKSGMB 56667811/16/22100200449.54500012/16/22YesHMKFKLCT 56667911/16/22100140438.35500012/16/22YesHMKFKLCT 56668011/16/221001062401.74500012/16/22YesHMKFKLCT 56668111/17/221002601164.83500012/17/22YesHMKFKLCT 56668211/17/22100283173.29500012/17/22YesHMKFKLCT 56668311/17/2210014098.56500012/17/22YesHMKFKLMB 56668411/17/221002031069.94500012/17/22YesHMKSGCT 56668511/17/221001752142.61500012/17/22YesHMKFKLCT 56668711/18/221001532231.32500012/18/22YesNCSSGCT 56668811/18/221001402747.52500012/18/22YesHMKFKLCT 56668911/18/221002791377.65500012/18/22YesHMKFKLCT 56669011/18/22100225519.59100012/18/22YesHMKFKLMB 56669111/18/2210031766.04100012/18/22YesHMKFKLMB 56669211/18/2210028637.61500012/18/22YesHMKFKLCT 56669311/18/221002911036.49500012/18/22YesHMKFKLCT 56669411/18/22100309949.09500012/18/22YesNCSFKLCT 56669511/18/2210019975.24500012/18/22YesHMKFKLCT 56669611/18/221001912960.47500012/18/22YesHMKFKLMB 56669711/18/22100198483.12500012/18/22YesHMKFKLMB 56669911/18/221001251093.93500012/18/22YesNCSSGCT 56670011/19/221002012215.90500012/19/22YesHMKFKLCT 56670111/19/22100303842.91500012/19/22YesHMKFKLCT 56670211/19/221001404603.26500012/19/22YesHMKFKLHMK 56670311/19/221001403357.86500012/19/22YesHMKFKLCT 56670411/19/221001881219.74500012/19/22YesHMKFKLMB 56670511/19/221002381584.77500012/19/22YesHMKFKLCT 56670711/19/22100140356.66500012/19/22YesHMKFKLCT 56670811/19/221002582326.66500012/19/22YesHMKFKLCT 56670911/19/221002551523.93500012/19/22YesHMKFKLCT 56671011/19/22100282688.73500012/19/22YesHMKFKLCT 56671111/19/221001682586.02500012/19/22NoHMKFKLHMK 56671211/19/221002231425.73500012/19/22YesHMKFKLMB 56671311/19/221003301579.51500012/19/22YesNCSSGCT 56671411/19/22100290564.96500012/19/22YesHMKSGCT 56671711/23/22100282491.94500012/23/22YesHMKSGCT 56671811/23/22100265185.17100012/23/22YesHMKSGCT 56671911/23/22100181206.36500012/23/22YesHMKFKLCT 56672011/23/221003411109.81500012/23/22YesHMKFKLCT 56672111/23/221002511258.52100012/23/22YesHMKFKLMB 56672211/23/221003491750.56500012/23/22YesHMKSGMB 56672311/23/22100289840.06200012/23/22YesNCSFKLMB 56672411/23/221001811223.30500012/23/22YesNCSSGCT 56672511/23/22100317542.13500012/23/22YesHMKFKLCT 56672611/23/221002121084.12500012/23/22YesHMKFKLMB 56672711/25/221001805206.79500012/25/22YesHMKFKLMB 56672811/25/2210011478.77100012/25/22YesHMKFKLCT 56672911/25/22100341173.35500012/25/22YesHMKFKLMB 56673011/25/22100231875.80500012/25/22YesHMKFKLCT 56673111/25/221003181911.15500012/25/22YesNCSFKLCT 56673211/25/2210029233.02500012/25/22YesHMKSGCT 56673311/25/221001171862.8250012/25/22YesNCSFKLCT 56673411/25/221001402742.74500012/25/22YesHMKSGMB 56673511/25/221002361262.71500012/25/22YesNCSSGMB 56673611/25/22100120947.75500012/25/22YesHMKFKLCT 56673711/25/22100262869.76500012/25/22YesNCSFKLMB 56673811/25/22100300198.1350012/25/22YesHMKFKLMB 56673911/25/22100342537.00500012/25/22YesHMKFKLMB 56674011/25/22100154494.98500012/25/22YesHMKFKLMB 56674111/25/221002271347.18500012/25/22YesHMKFKLMB 56674211/25/22100164709.05500012/25/22YesHMKFKLCT 56674311/25/221002481404.09500012/25/22YesNCSFKLCT 56674411/25/221001401276.29500012/25/22YesHMKFKLCT 56674511/25/221001371505.22500012/25/22YesHMKSGCT 56674611/25/22100310189.76500012/25/22YesNCSFKLCT 56674711/26/221001172189.6650012/26/22YesHMKFKLCT 56674811/26/221001752665.32500012/26/22YesHMKSGCT 56674911/26/2210015833.02200012/26/22YesHMKFKLCT 56675011/26/22100330710.17500012/26/22YesNCSFKLCT 56675111/26/22100210463.95500012/26/22YesHMKFKLMB 56675211/26/2210031418.55500012/26/22YesNCSFKLMB 56675311/26/22100170825.57500012/26/22YesHMKFKLCT 56675411/26/22100325438.63500012/26/22YesHMKFKLCT 56675511/26/221003322943.84500012/26/22YesHMKFKLCT 56675611/26/22100197884.38500012/26/22YesNCSFKLMB 56675711/26/22100105561.45100012/26/22YesHMKFKLCT 56675811/27/221001751631.04500012/27/22YesHMKFKLMB 56675911/27/22100237920.82500012/27/22YesNCSFKLMB 56676011/27/22100140421.88500012/27/22YesHMKFKLMB 56676111/27/22100171814.91500012/27/22YesHMKSGCT 56676211/27/22100291843.12500012/27/22YesNCSFKLMB 56676311/27/22100306416.57500012/27/22YesHMKSGMB 56676411/27/22100227792.42500012/27/22YesHMKFKLMB 56676511/27/221002641223.61500012/27/22YesHMKFKLCT 56676611/27/22100221495.46500012/27/22YesHMKFKLMB 56676711/27/221001571076.53500012/27/22YesHMKFKLCT 56676812/1/22100140458.39500012/31/22YesHMKSGCT 56676912/1/22100311842.09500012/31/22YesNCSFKLCT 56677012/1/22100226155.14500012/31/22YesHMKFKLCT 56677112/1/221001401616.85500012/31/22YesHMKSGMB 56677212/1/22100264593.10500012/31/22YesNCSFKLCT 56677312/1/221003151862.23500012/31/22YesHMKFKLMB 56677412/1/221003486005.37200012/31/22YesHMKSGCT 56677512/6/22100209273.5750001/5/23YesNCSFKLMB 56677612/7/221002452686.7250001/6/23YesNCSSGCT 56677712/7/22100244263.4210001/6/23YesHMKFKLCT 56677812/8/2210018953.4850001/7/23YesHMKFKLMB 56677912/8/221001556123.75100001/7/23YesHMKFKLMB 56678012/8/221002055459.03100001/7/23YesHMKFKLCT 56678112/8/22100349640.1550001/7/23YesHMKFKLMB 56678212/8/221002802626.6650001/7/23YesHMKFKLCT 56678312/9/22100294201.2650001/8/23YesNCSFKLCT 56678412/9/22100230183.4250001/8/23YesHMKSGCT 56678512/9/221002162650.4150001/8/23YesNCSFKLCT 56678612/9/22100309673.8650001/8/23YesHMKSGMB 56678712/9/22100225975.9310001/8/23YesNCSSGMB 56678812/9/22100233458.295001/8/23YesHMKFKLCT 56678912/10/221002595744.8350001/9/23YesNCSFKLMB 56679012/10/221002702068.1450001/9/23YesHMKFKLMB 56679112/10/22100333206.6510001/9/23YesHMKFKLMB 56679212/10/221002741768.9850001/9/23YesHMKFKLMB 56679312/10/22100260372.9850001/9/23YesHMKFKLMB 56679412/10/22100168800.6450001/9/23YesHMKFKLCT 56679512/10/221001021204.6350001/9/23YesNCSFKLCT 56679612/10/2210026973.7850001/9/23YesHMKFKLCT 56679712/11/221001522239.8010001/10/23YesHMKSGCT 56679812/11/22100188149.2850001/10/23YesNCSFKLCT 56679912/11/221001501284.33100001/10/23YesHMKFKLCT 56680012/12/22100282466.0250001/11/23YesHMKSGCT 56680112/12/221002021302.16100001/11/23YesHMKFKLCT 56680212/13/221001631473.9815001/12/23YesNCSFKLCT 56680312/13/2210030591.9040001/12/23YesHMKFKLMB 56680412/15/22100346107.1250001/14/23YesNCSFKLMB 56680512/17/221003451951.0350001/16/23YesHMKFKLCT 56680612/18/221001111371.20100001/17/23YesHMKFKLCT 56680712/19/221002192868.2610001/18/23YesHMKFKLCT 56680812/20/221001771203.6950001/19/23YesNCSFKLMB 56680912/21/22100148771.1550001/20/23YesHMKFKLCT 56681012/22/22100122482.1510001/21/23YesHMKFKLMB 56681112/23/2210011129.69100001/22/23YesNCSFKLMB 56681212/24/2210030145.2150001/23/23YesHMKFKLMB 56681312/25/22100341103.2150001/24/23YesHMKSGCT 56681412/25/22100191534.1450001/24/23YesNCSFKLMB 56681512/26/22100229575.0210001/25/23YesHMKSGMB 56681612/26/221003491156.4850001/25/23YesHMKFKLMB 56681712/27/221003422619.2450001/26/23YesHMKFKLCT 56681812/27/22100167939.1150001/26/23YesHMKFKLMB 56681912/28/22100194196.125001/27/23YesHMKFKLCT 56682012/28/22100278944.3110001/27/23YesHMKSGCT 56682112/29/221003485050.5120001/28/23YesNCSFKLCT 56682212/29/22100266680.8950001/28/23YesHMKFKLCT 56682312/30/221001000.9950001/29/23YesHMKSGMB 56682412/30/221001762835.6550001/29/23YesNCSFKLCT 56682512/31/221003112490.8350001/30/23YesHMKFKLMB 56682612/31/221002022083.34100001/30/23YesHMKSGCT ACC 4230: Formatting and citations requirements Formatting: your work presentation should be neat and professional 1. Spelling, grammar, and proper use of terminology are important and will be considered during the grading process. Use complete sentences to answer questions, and for all discussions. 2. For hardcopy submissions: staple pages together – no paperclips, no report covers, no 3-ring binders. 3. Include a cover page with your name, the title of the assignment, the course number, and the semester/year on it. All work should be in black and white only. Do not use color for text or data. 4. You must use Excel and/or Word as appropriate. For a professional document, use either Calibri or Times New Roman font, in size 11 or 12. Do not mix font types or sizes in the text of your document. 5. Double-space all text. 6. Use page numbers. Place them at the bottom of each page, either in the center or on the right side. Page 1 is the first page of your paper, not the cover page. If your cover sheet is part of your document file, follow these steps: a. Place a section break after the cover sheet (Layout > Breaks > Section Break > Next Page). b. Go to the footer in the first page of your paper and Unlink to Previous. c. Insert page numbers in the footer of your paper. 7. Tables, charts, and figures may be presented using 10 font. Even if you start with a standard font size, it is unacceptable if any material appears in “micro-font” in the finished product due to page fitting/shrinking. a. This is 12-font b. This is 11-font c. This is 10-font: anything that looks smaller than this in a table or figure is unacceptable 8. If a table is too big to present properly on a single page, divide it in some rational manner over multiple pages. Remember to show table headings, titles, etc. on every page. 9. Be conscious of pagination and insert page breaks where appropriate. Titles or headings should not appear at the bottom of one page and the text at the top of the next. Avoid having a bullet extend from one page to the next. 10. Answers must be in your own words; copy/pasting material is not acceptable. (Certain exceptions apply when quoting language from accounting standards.) 11. Cheating, plagiarism, and any other form of academic dishonesty will not be tolerated. Ignorance will not be accepted as an excuse, i.e., “I didn’t know that what I did is considered plagiarism.” Please review the Wright State Student Handbook for further information about the university’s academic regulations. Choosing information sources Using appropriate information sources is vital to your success in this class and in your professional work. Your information sources should be just that: original sources that directly provide the information you seek, not a collection of statements originating elsewhere that you insert into your paper. Depending on what you are looking for, a site like Wikipedia might be useful as a starting point – but only to suggest more credible, reliable, original information sources. Wikipedia, Investopedia, and other general information internet sites are not appropriate information sources for college-level work. A report citing such sources immediately brands the author as too lazy to do any actual research. Carefully vet online sources. Before you go online to do research, plan some specific resources to investigate. A Google keyword search is a terrible way to begin online research because there is no focus to the results and trying to filter for relevance can be overwhelming. For example, googling “annual reports” pulls up more than one billion results in less than 1 second. The appearance of a link in a Google search is no guarantee that the source is legitimate. Annual reports (10-Ks) are readily available for free on the SEC website in a system called EDGAR. In addition, almost every company posts its own annual reports and SEC filings on the Investor Relations page of its website. Any other site with a “dot.com” ending that claims to be a free resource for annual reports or other financial data should be viewed very suspiciously. It is offering something to you for “free” that is already freely available from the original sources. Why would they do that? Such sites are notorious for requiring you to register by providing information about yourself and they make their profits by selling that information. Such sites are also notorious disseminators of malware – all you have to do is arrive on the homepage. That said, there are a few well-known commercial sites that are useful. Bloomberg, Yahoo! Finance, Morningstar Financials, and www.NASDAQ.com fall into this category. These sites tend to focus primarily on stock market activity and they are good sources of historical stock prices. However, their analyses often consist only of a few financial information summaries and ratios, which may or may not be up to date. Accounting professional publications Journal of Accountancy CPA Journal Useful Dunbar Library electronic resources Company general information: Mergent Online To search for articles on any topic: Business Source Complete (use the “advanced search” option to enter multiple filters) WSU Business librarian: Carol Fang (
[email protected] ) Citing your sources Citing information in a 10-K: A few example citations are shown below. · Note 8: Other intangible assets and goodwill, p. 72 · MD&A, p. 23 · Statement of cash flows, Financing activities section Citing a journal article Brown, Kevin F., and Kathryn E. Easterday. 2016. Personal disaster recovery plans: helping individuals when tragedy occurs. CPA Journal 86 (5):50-53. Citing online resources I am not aware of hard and fast rules about citing webpages. Information and/or format may differ depending on the kind of information you are citing and its source. It may be an article with an identified author; a report published by a public or private entity on its own website, or some other kind of information made publicly available. Provide as much information as possible (author and/or organization name, title, web address, etc.) Sometimes it is impossible, but make every effort to ensure that the entire URL appears on one line and does not run from one line to the next. A few examples appear below. Electronic article Hulbert, Mark. Posted January 11, 2008. The January effect's disappearing act. Barron's Online, http://www.marketwatch.com/story/january-effect-has-failed-to-materialize-this-year A report published by the Tax Foundation, a non-profit think tank Tax Foundation. State-local tax burdens: all states, one year (1977-2009), http://www.taxfoundation.org/taxdata Additional information about online resources Sometimes there is a note asking that the information be cited in a certain way. For the following data about inflation growth, a note on the