Becca Heltzel
Kayla Denlinger
Benjamin Rusnak
Gabby Vandevere
Cloud Start Networking
Attachments to the Planning Memo
December 31, 2015 Preliminary Analytical Review
Based on my initial analytical procedures I found the following unusual or unexpected relationships: I found that there was a large increase in inventory from 2014 to 2015 ($1,090,000). With such a huge increase, we would have to question the existence of this inventory. Realistically, if inventory was overstated it would cause Cost of Goods Sold to be understated.
I also found that cash was an important asset to analyze during this procedure. There was a $295,000 decrease from the prior year. Completeness was not satisfied with depreciation and property, plant, and equipment.
.
Materiality
When planning materiality, I took 5% of income before taxes to obtain the $75,400, which in this company is a material number. Once I had this number I then went through each account and compared the 2014 and 2015 numbers. I calculated the difference between each year, any number found with a difference of $75,400 or more, had a high risk of materiality misstatement. The accounts that appeared to be at risk of being materially misstated are: Cash (existence), Short-term securities, Accounts Receivable and Sales (existence, occurrence, completeness), inventory and cost of goods sold (existence, completeness), Other current assets, fixed assets and depreciation (classification, completeness, valuation), accounts
Cost of Goods Sold – totaled $3,294,000.00 for year 6, and from years 6 to 7 grew +32.8% or $1,048,000.00.
• In 1993 cost of goods sold being 90% of sales and 9.6% gross profit of sales. Company’s lack of ability to manage inventory and lack of cash forced them to order from more expensive (12-15%more) warehouse than steel mills.
Different materiality bases are considered when determining planning materiality because the magnitude and nature of financial statement misstatements or omissions have different influences on different financial statement users. For example, investors are more interested in the accuracy of numbers involving net income because they are mainly concerned with the company’s ability to increase shareholder wealth. For an audit company, the primary concern when planning materiality is to take into account all expected financial statement users. These different expected users all have different
Inventory Method: The inventory amount for the year ended 12/31/2016 is $14,760,000,000 which is an $759,000,000 increase from the previous year. CVS uses the lesser of the weighted average cost or market value when determining the value of inventory. Inventory is verified for accuracy by regularly doing physical counts in all locations. Between physical counts, CVS uses sales results from previous years to accrue the estimated physical loss. These estimates are determined for each individual store and warehouse separately to ensure the most accurate information possible is reported. CVS has decided to use a new method available after annual periods beginning after 12/15/2016 known as the lower of cost and net realizable value to replace using
In the past few years, they have experienced a significant increase in inventory days. Not having attractive inventory leads to a decrease in sales and an increase in discounts and write offs leading to further decreases in EBITDA Margins. In 2009, the inventory turnover took 215 days. This is significantly above Le Chateaus competitors, for example Reitman’s inventory took only 72 days (Annual Report 2010). This means it takes Le Chateaus three times as long to sell inventory compared to their competitors. To make matters worse, this trend has been exacerbated in recent years. Le Chateau’s turnover has ballooned to a staggering 341 days while Reitman’s has kept inventory turnover stable at only 76 days.
The error would’ve been correct on the current period first quarter results. To correct the overstatement of 8 million in inventory, a credit or decrease for $8 mill should’ve been done on the inventory account, and the retained earnings should’ve been debited for the same amount:
In this example we have a case in which years 89, 90 and 91 net income is less than net cash provided by operating activities. One of the major reasons for this appears to have been depreciating high cost of equipment. The depreciation is trending downward over the three-year period indicating less long-term assets are being purchased/capitalized to run operations. While depreciation does not involve cash, it does impact net income. In addition, account payables have been decreasing over the last two years and significant cash has been used in the last year to pay the liability. In 1990 there are significant costs associated with restructuring activities. There
) There was a lack of adequate cut-off procedures to ensure the timely recording of certain period-end accruals. This resulted in an audit adjustment of $3,578,000. The benchmark for overall materiality is $3,508,000, I would consider the audit adjustment of $3,578,000 a material misstatement. Control environment, principle 2 the board of directors and management exercise oversight of development and performance of internal controls. Due to the severity and material weakness of lack of adequate cutoff procedures to ensure timely recording of period end accruals. Management and the board of directors should evaluate performance of internal control activities including adherence to standards of conduct and expected levels of competence. In
Revenue would be the new base that would be used to determine materiality. Total assets is another good alternative, however this company does not have many operating assets (only inventory and PPE are the significant accounts)
3. AASB 1031 materiality. Planning materiality and performance materiality – are only for auditors. Planning materiality – one base for the whole statement. For public companies – net profit since people are more focussed on that only if it is stable, if not pick total revenue or total assets. Used for financial statements as a whole.
Answering this question requires knowledge of three terms. The three terms are absolute amounts, materiality, and percentage analysis. The text defines absolute amounts as the absolute dollar amount of a given trend (Edmonds, Tsay, & Olds, 2011). For example, if a company had a net income amount of $400,000 in a given year, it could be reported in its absolute dollar amount of $400,000. The relative importance of the information defines materiality. An item is considered material if knowledge of it would influence the decision of a reasonably informed user (Edmonds, Tsay, & Olds, 2011). For example, a net income amount of $400,000 may be extremely material to a new start-up business; however, a $400,000 expense may immaterial to a 10-billion-dollar company like FedEx. Percentage analysis involves computing the percentage relationship between to amounts (Edmonds, Tsay, & Olds, 2011).
The standard costs and variances for direct materials, direct labor, and factory overhead for the month of May are as follows:
The auditor should consider planning materiality. When a financial statement account exceeds the planning materiality, that account should be considered significant for both the audit of internal control over financial reporting and the financial statement audit. The more the account exceeds planning materiality, the greater it should be considered significant.
Its activity during 2008 as measured by the cost of goods sold was $74,000 (COGS). It therefore had an inventory of turnover of 2.55 (74,000/29,000) times. This represents an improvement from 2.04 (43,000/21,000) times in 2005.
Inventories have been valued $871 million, an increase of $150 million from last year. This can be viewed in a multitude of ways. Caterpillar may be expecting larger sales volume, and are trying to compensate. Caterpillar could have inventory control problems. Usually, inventory increases are viewed as a negative with a company that should be in theory practicing a just in time approach.