2 Riscko debtor schedule as at 31 May 20XX correction task You are Joan Jacks and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2 Riscko debtor schedule as at 31 May 20XX correction task You are Joan Jacks and you are an Accountant who works for Riskco, a reputable risk management consultancy company. You are checking the debtor's ledger for the 31st of May prepared by the accounts clerk John Bee. John Bee has recently had a heavy workload, so you are anticipating some errors in his work. You are required to check the debtors schedule based on the invoice and repayment information below. Using spreadsheet software please produce and amend the report based on your calculations: Riskco debtor schedule 31 May 20XX (prepared by John Bee) Balance outstanding Debtor Nella Pty Ltd Aban Pty Ltd Gan Pty Ltd Nena Pty Ltd Jan Pty Ltd Total $1,250 $1,350 $450 $240 $1,200 $4,490 Customer transaction details Nella Pty Ltd Risk management invoice 12 dated 1 May for $350. Risk management invoice 59 dated 1 April for $500 Risk management invoice 32 dated 1 January for $400 Paid invoice 32 on 15 May (full amount). Paid invoice 59 on 14 May (50% of the balance). Aban Pty Ltd 0-30 days $350 $200 $240 $790 4 31-60 days $500 $230 $730 61-90+ days $400 $230 $450 $1,200 $2,280 2 Riscko debtor schedule as at 31 May 20XX correction task You are Joan Jacks and you are an Accountant who works for Riskco, a reputable risk management consultancy company. You are checking the debtor's ledger for the 31st of May prepared by the accounts clerk John Bee. John Bee has recently had a heavy workload, so you are anticipating some errors in his work. You are required to check the debtors schedule based on the invoice and repayment information below. Using spreadsheet software please produce and amend the report based on your calculations: Riskco debtor schedule 31 May 20XX (prepared by John Bee) Balance outstanding Debtor Nella Pty Ltd Aban Pty Ltd Gan Pty Ltd Nena Pty Ltd Jan Pty Ltd Total $1,250 $1,350 $450 $240 $1,200 $4,490 Customer transaction details Nella Pty Ltd Risk management invoice 12 dated 1 May for $350. Risk management invoice 59 dated 1 April for $500 Risk management invoice 32 dated 1 January for $400 Paid invoice 32 on 15 May (full amount). Paid invoice 59 on 14 May (50% of the balance). Aban Pty Ltd 0-30 days $350 $200 $240 $790 4 31-60 days $500 $230 $730 61-90+ days $400 $230 $450 $1,200 $2,280
Expert Answer:
Answer rating: 100% (QA)
Riskco Debtor Schedule 31 May 20XX Amended by Joan Jacks Debtor Balance Outstanding 030 days 3160 da... View the full answer
Related Book For
Corporate Finance and Investment decisions and strategies
ISBN: 978-1292064062
8th edition
Authors: Richard Pike, Bill Neale, Philip Linsley
Posted Date:
Students also viewed these finance questions
-
C 5:03 PM Problem 3. Epi (3 points) La Lockdown sleep - A group of researchers at Delhi Technological University in Delhi, India surveyed over 1000 students (ranging in age from 7 to 59) in Delhi...
-
Lombard Ltd has been offered a contract for which there is available production capacity. The contract is for 20,000 identical items, manufactured by an intricate assembly operation, to be produced...
-
Go to www.theglobeandmail.com/globe-investor/funds-and-etfs/fund-lookup, find "Fund Lookup." Next, click on "Fund Company." Select a fund company, then pick 3 funds operated by the fund company and...
-
Moss Co. issued $42,000,000 of five-year, 11% bonds, with interest payable semiannually, at a market (effective) interest rate of 9%. Determine the present value of the bonds payable using the...
-
Renkas Heaters selected data for October 2017 are presented here (in millions): Calculate the following costs: 1. Direct materials inventory 10/31/2017 2. Fixed manufacturing overhead costs for...
-
The comparative balance sheet of Lankau Enterprises Inc. at December 31, 2014 and 2013 is as follows: Additional data obtained from the income statement and from an examination of the accounts in the...
-
Question 2 (50 points) When does the complex exponential prefactor for the solutions to the time- independent Schrodinger's equation matter? Let's find out with this example. An electron is confined...
-
The bar codes above represent locations in a warehouse. How many units would be left in each location? If you picked 250 units from location 00000113774360000 If you picked 250 units from location 00...
-
Cash Receipts Budget and Accounts Receivable Aging Schedule Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted the following sales: Quarter 1 Quarter 2...
-
A solution is made that contains 0 . 1 4 moles of solute dissolved in 0 . 8 3 L of solution. What is the molarity of the solution? 1 . 7 5 moles of solute is dissolved in 2 2 . 4 L of solution. What...
-
A 15.67 gram sample of iron is heated in the presence of excess chlorine. A metal chloride is formed with a mass of 45.50 g. Determine the empirical formula of the metal chloride. Enter the elements...
-
C can react with CO 2 to form CO . If this reaction is applied with low processing cost, explain its impact on the chemical industry. You can explain the use of CO , the source of C and CO 2 .
-
A solution is prepared such that the initial concentration of A 2 + is 1 . 5 0 \ times 1 0 - 3 M and the initial concentration of X is 4 . 6 0 \ times 1 0 - 3 M . A 2 + and X are allowed to react as...
-
A proton has a radius of approximately 1 . 0 \ times 1 0 1 3 cm and a mass of 1 . 7 \ times 1 0 2 4 g . Part A Determine the density of a proton. For a sphere V = ( 4 3 ) \ pi r 3 .
-
a) Define the following terms and give one example from your daily life for each term. b) Explain the scattering of light. Which parameters affect the scattering? Use this phenomenon to explain why...
-
The Pletcher Transportation Company uses a responsibility reporting system to measure the performance of its three investment centers: Planes, Taxis, and Limos. Segment performance is measured using...
-
The directors of Zeus plc are considering opening a new manufacturing facility. The finance director has provided the following information: Initial capital investment: 2,500,000. Dividends for the...
-
Mr Cowdrey runs a manufacturing business. He is considering whether to accept one of two mutually exclusive investment projects and, if so, which one to accept. Each project involves an immediate...
-
(a) Berlan plc has annual earnings before interest and tax of 15 million. These earnings are expected to remain constant. The market price of the company's ordinary shares is 86 pence per share cum...
-
The Milham Theatre Club has been in existence for a number of years. Members pay an annual subscription of 15 which entitles them to join trips to professional productions at a reduced rate. On 1...
-
The accounting records of the Happy Tickers Sports and Social Club are in a mess. You manage to find the following information to help you prepare the accounts for the year to 31 December 2015. (1)...
-
A business both buys loose tools and also makes some itself. The following data is available concerning the years ended 31 December 2014, 2015 and 2016. You are to draw up the Loose Tools Account for...
Study smarter with the SolutionInn App