Aging Schedule of Accounts Receivable

One assumption that should be clearly analyzed is that the collection period is of 30 days net. Not always customers have the ability and willingness to pay off their debts in 30 days, some may take more time, and some could incur in bad debt.

To consider this we need net credit sales and average receivable balance. This ratio indicates average collection period should be consistent with corporate credit policy. An increase suggests a decline in financial health of customers.

Although the company seems to be profitable, it has faced shortage of cash. It happened due to increase in Accounts Receivable as well as Inventories. On the other hand, Accounts Payable does not increase that rapidly and difficulties regarding cash collection become evident. Furthermore, the cash collection cycle becomes larger (59 days in year 2003, while more than 70 in year 2006).

In order to confirm the accounts receivable balances, I decided to use positive confirmations since this was my first time auditing the company and the collateral for the loan would be the receivables. The confirmations helped to verify the accuracy and existence of the accounts. I also calculated the Receivables Turnover Ratio in order to better evaluate the overall success of collection on accounts. The sample size that I chose was determined by the factors of tolerable misstatement, inherent risk, control risk, achieved detection risk

There are two chief participants in this case study, Paul Mackay and Jackie Patrick. Mackay, a sole proprietor of Lawsons (a general merchandising retail site in Riverdale, Ontario), has approached the Commercial Bank of Ontario in order to acquire an additional $194, 000 bank loan and a $26,000 line of Credit. Patrick, a first time loans officer, has been appointed to Mackay’s request. As such

Answer: The average collection period is definitely a good indicator of future trends of payers. In this case, the ACP illustrates that the firm’s customers have changed their payment behavior in a positive way.

Accounts receivable are amounts owed by customers on account. They result from the sale of goods and services on credit. These receivables are generally expected to be collected within 30 to 60 days. They are typically the most significant type of claim held by a company. Accounts receivable and notes receivable resulting from sales are also known as trade receivables. Accounts receivable resulting from sales are referred to as trade receivables in Alcatel's financial statements.

When compared with the industry, the receivables turnover of S&S Air of 43.05 times is well over the industry upper quartile of 14.11 times. This shows that the collection of accounts receivable is a major strength of S&S Air when compared to the rest of the industry.

The Lawsons’ efficiency ratios are another section the bank will find troubling. The company’s age of payables has nearly tripled over the last four years. This can be detrimental to the company’s image and reliability including their reliability toward the bank if granted the loan. Along with increasing age of payables is increasing age of receivables and age of inventory. Indicating that Mr. Mackay is taking longer to collect his receivables and that he has purchased too much inventory. Too much inventory results can result in further issues

J reflects department store chain. This industry is a retail business; therefore, there is a large amount of inventories. This industry also has high accounts receivable because usually customers pay with credit cards which are billed at the end of the month. However, sometimes, customers forget to pay their bills on time, and the bills are brought to next month. Therefore, the collection period is approximately 2 months.

Moreover, from the analyse tab and the function “Age”, an aging of the Accounts Receivable was performed.

8. Times interest earned = (Net Income + Interest) in Statement of Operations / Interest in

Starbucks Corps had its gross account receivables for the year 2015 increase by 14.44% which led to its net receivables increase by $88,000,000 which translates to an increase of 13.95% of the net account receivables. This was followed by an increase in doubtful debts through the previous year by 6.12% to %6,700,000 from the ear 2014. This is due to the increase in the number also sales which led to the increase in account receivables and also doubtful debts in 2015. The risk that the company undertook also increases in line with the increase in account receivables.

Accounts receivable turnover is the second method by which a company’s trade receivables’ liquidity can be evaluated (Gibson, 2011). Žager et al. (2012) noted turnover ratios should be as high as possible as this indicates a firm’s ability to convert its assets more often. 3M’s accounts receivable turnover for years 2007 and 2008 is shown in Exhibit 2. In 2007, 3M turned its accounts receivable over 7.12 times and 7.70 times in 2008. This calculates into a turnover of its accounts receivable every 51.28 days in 2007 and 47.38 days in 2008. The increase in accounts receivable turnover times per year (decrease in number of days to turnover accounts receivables) from 2007 to 2008 is a positive trend for 3M. It suggests, along with the prior calculation, the management of receivables is likely to be improving in efficiency.

iii. The cash amount to be paid for these leases in 2004 will be $44.