Audit Plan

djprse
mod03auditplan.xlsx

Analytic Ratios

Company Name
Ratio Analysis
Recent Year Year - 1 Year -2
Short Term Debt
Cash Ratio
Quick Ratio
Current Ratio
Liquidity
A/R Turnover
Days to collect A/R
Inventory Turnover
Days to sell Inventory
Long-Term Debt
Debt to Equity
Times Interest Earned
Profitability
Earning per Share
Gross Profit Percentage
Profit Margin
Return on Assets
Return on Common Equity

Horizontal

Summit, Inc. Company Name
Income Statement Horizontal Analysis of Income Statement
For the Year Ended December 31 Recent Year vs Year -1 Year -1 vs Year -2
$ Change % Change $ Change % Change
2015 2014 2013
Net Sales $ 75,368,814.00 $ 74,293,018.50 $ 72,343,206.50 Net Sales
Cost of Goods Sold $ 54,642,390.00 $ 53,127,749.50 $ 50,994,082.50 Cost of Goods Sold
Gross Profit $ 20,726,424.00 $ 21,165,269.00 $ 21,349,124.00 Gross Profit
Operating Expenses $ 18,588,869.00 $ 19,066,984.50 $ 18,620,554.00 Operating Expenses
Income from Operations $ 2,137,555.00 $ 2,098,284.50 $ 2,728,570.00 Income from Operations
Other Revenue and Gains $ 600,000.00 $ 520,000.00 $ 450,000.00 Other Revenue and Gains
Other Expenses and Losses $ 1,690,974.00 $ 1,669,608.50 $ 1,648,976.50 Other Expenses and Losses
Income before Income Taxes $ 1,046,581.00 $ 948,676.00 $ 1,529,593.50 Income before Income Taxes
Income taxes $ 441,657.18 $ 429,470.50 $ 670,768.00 Income taxes
Net Income $ 604,923.82 $ 519,205.50 $ 858,825.50 Net Income
Earnings per share $ 1.21 $ 1.04 $ 1.72 Earnings per share
Summit, Inc. Company Name
Balance Sheet Horizontal Analysis of Balance Sheet
As of December 31 Recent Year vs Year -1 Year -1 vs Year -2
$ Change % Change $ Change % Change
2015 2014 2013
Assets Assets
Current Assets Current Assets
Cash and Equivalents $ 3,860,639 $ 3,662,423 $ 4,033,273 Cash and Equivalents
Net Receivables $ 6,521,082 $ 4,309,929 $ 3,968,204 Net Receivables
Inventory $ 16,118,011 $ 12,768,599 $ 12,635,752 Inventory
Other current assets $ 86,139 $ 71,603 $ 65,871 Other current assets
Total Current Assets $ 26,585,871 $ 20,812,554 $ 20,703,100 Total Current Assets
Property, plant, & Equip $ 31,131,524 $ 30,817,765 $ 29,134,366 Property, plant, & Equip
Total Assets $ 57,717,395 $ 51,630,319 $ 49,837,466 Total Assets
Liabilities Liabilities
Current Liabilities Current Liabilities
Payables $ 6,484,843 $ 4,730,388 $ 3,793,187 Payables
Short term/current long term debt $ 7,687,909 $ 5,149,334 $ 4,836,335 Short term/current long term debt
Other current liabilities $ 1,033,822 $ 883,680 $ 841,275 Other current liabilities
Total current liabilities $ 15,206,574 $ 10,763,402 $ 9,470,797 Total current liabilities
Long-term debt $ 12,210,045 $ 11,171,003 $ 11,189,960 Long-term debt
Total Liabilities $ 27,416,619 $ 21,934,405 $ 20,660,757 Total Liabilities
Stockholder's Equity Stockholder's Equity
Common Stock $ 500,000 $ 500,000 $ 500,000 Common Stock
Additional PICap $ 7,858,823 $ 7,858,823 $ 7,858,823 Additional PICap
Retained Earnings $ 21,941,953 $ 21,337,091 $ 20,817,886 Retained Earnings
Total Stockholder's Equity $ 30,300,776 $ 29,695,914 $ 29,176,709 Total Stockholder's Equity
Total Liab & Stockholder's Equity $ 57,717,395 $ 51,630,319 $ 49,837,466 Total Liab & Stockholder's Equity