Hello

I have been having a problem with this excel assignment and I had posted it yesterday

but I haven't get helped since please help me

the excel details instruction is attacked

SDSU Accounting Information Systems ACCTG 333, Spring 2016 Excel Assignment Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks. Mastering the basics of Excel is critical to your success. You should already know how to create spreadsheets using common mathematical formulas and Excel Functions. In AIS, you will develop or improve your skills linking multiple spreadsheets; creating formulas using Excel functions IF, VLOOKUP, ROUND; and creating PIVOT tables. Excel Assignment 1: For the first Excel assignment you will create a yearend workbook with multiple spreadsheets to convert the unadjusted trial balance of Waren Sports Supply to a set complete financial statements and account analysis. You should recall the steps in the accounting cycle to 1) prepare unadjusted trial balance, 2) determine and record adjustments, 3) create adjusted trial balance, and 4) create financial statements: Balance Sheet, Income Statement, Statement of Cash Flows (Indirect method). You will begin with the Yearend Worksheet template found on BlackBoard that includes all the accounts and unadjusted trial balance figures. The instructions below give you the information needed to calculate and record adjustments in Excel, and to add these adjustments to the Yearend Worksheet to create the adjusted trial balance. You will use the adjusted trial balance data to create financial statements in Excel. Your Excel workbook should be fully integrated. For example, a change in the tax rate from 15% to 17% should automatically update your tax expense/accrual adjustment, the adjusted trial balance, and the financial statements. Therefore, all calculations must be in Excel and all data should be referenced from one cell to another. Instructions: 1. Download the Waren Sports Supply Yearend Workbook from BlackBoard. Save the file as: lastname_firstname_WSS2016spring. 2. You will note that the December 31, 2013 Post Closing Trial Balance and December 31, 2014 Unadjusted Trial Balance are populated with numbers. a. Do debits equal credits? i. Use the SUM function to total each column of the spreadsheet. b. Should the 2014 allowance for doubtful accounts be a debit or credit balance? i. How could this happen? You will make an adjustment later. c. Why are 2014 retained earnings the same as 2013? i. When is net income or loss recorded in retained earnings? ii. We will not close out the temporary accounts at this time. 3. ADJUSTMENT SHEET: Adjustments will be recorded on the Adjustment worksheet in the Excel Workbook. a. Use the VLOOKUP function to populate account name after you input the account number. (Click on the hyperlink for support from Microsoft.com.) You might find using Labels/Range Names is helpful to define the account numbers and titles. b. After each adjustment, write an explanation for the adjustment. Include any assumptions or calculation figures, such as bad debt expense rate or interest rate. This explanation is important documentation to support and justify the adjustment. c. Depreciation Expense is $35,109.50. Input this figure in the adjustments worksheet. d. Interest Expense: An $80,000, two-year note was signed and funded on December 16, 2014 with annual stated interest of 6%. Create a formula to calculate the adjustment amount based on a 365 day year. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. e. Bad debt expense: Bad debt expense is 0.2% of net sales. Create a formula to calculate the adjustment amount. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. f. Inventory and cost of sales adjustment: Waren uses the periodic inventory method. A physical inventory was taken at midnight on 12/31/14. The cost basis of the inventory on hand is $198,246.00. Adjust the inventory balance and close out the purchase and related accounts to cost of sales. g. Income tax expense: Income tax expense cannot be calculated until all other adjustments are posted and the income before income taxes reflects all adjustments. This will be calculated later in the assignment. h. Add the adjustment balances to the Yearend Worksheet in the Adjustments columns. Since there is only one adjustment per account, you can do this by using the = or + functions. (in a more complex company with multiple adjustments for each account, you might use the SUMIF function to bring adjustments forward to the Yearend Worksheet.) 4. Use formulas to combine the Unadjusted Trial Balance and Adjustments to create the Adjusted Trial Balance. Many accounts can be either a net debit or a net credit in the Adjusted Trial Balance. Consequently, IF statements must be used to determine if the balance is a debit or credit. The IF statement should place a blank if the criteria are not met, for example, =IF (debitscredits>0, debits-credits, \"\")replace debits and credits with cell references for the unadjusted trial balance and the adjustment columns. Copy the formulas to all cells in the total columns. 5. After completing steps 3 and 4, you are ready to calculate income tax expense. A table is included on the Yearend Worksheet to help you calculate income tax expense. a. Calculate income before income taxes using the Adjusted Trial Balance data. Income is equal to revenues minus expenses. In the accounting system, income is equal to credits minus debits. Create a formula in cell F59 on the Yearend Worksheet to calculate income before taxes, e.g., SUM(credits)-SUM(debits). (Do not bring income before tax from the income statement because you haven't created the income statement yet.) b. The marginal income tax rates are as follows: Income before Tax Rate $75,000 36% c. Use an IF statement to calculate income tax expense. The IF statement must consider income at 3 different levels. This requires an embedded or nested IF statement, i.e., 2 IF statements in one formula. (Be sure to test your IF statement at different levels of income before taxyour formula needs to work at all levels.) d. After calculating tax expense, you can determine Net Income. The Net Income check figure is provided. e. Create an adjustment for income tax expense on the Adjustment worksheet. The amount on the adjustment worksheet will be reference from cell F61 on the Yearend Worksheet. Bring the adjustment to the Yearend Worksheet in the adjustment columns. f. All adjustments are now complete. 6. Populate the Balance Sheet and Income Statement debit and credit columns on the Yearend Worksheet using IF statements similar to step 4. above. Total Balance Sheet debits will not equal total creditswhy? The same conditions apply to the Income Statement. Calculate the difference below to compare to Net Income. 7. Complete the Financial Statements on the appropriate worksheets. The Statement of Cash Flows uses the indirect method. a. Use formulas to insert the correct figures into the Financial Statements worksheets from the Yearend Worksheet balance sheet or income statement columns. i. December 31, 2014 retained earnings in the Balance Sheet will b. c. d. e. pull from the Income Statement because the temporary accounts haven't been closed. Calculations in the financial statements should be limited to sum, plus, and minus to aggregate or subtract accounts. On the Statement of Cash Flows you can bring the balances from the Yearend Worksheet or the Balance Sheet and Income Statement, whichever you prefer. Compare the ending cash balance on the Statement of Cash Flows to the Balance Sheet cash. The amounts should equal. Remove the gridlines from the financial statements. 8. The assignment is due at the time specified in the Syllabus. Your electronic submission MUST BE in EXCEL format. Google Docs, Open Office, Numbers, etc. are not acceptable formats. a. E-mail the completed workbook to aisassignments@gmail.com b. Upload using turnitin to BB>SUA Project Assignments > Excel Assignment. Turnitin will separate the pages, but we will be able to see and download your work. SDSU Accounting Information Systems ACCTG 333, Spring 2016 Excel Assignment Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks. Mastering the basics of Excel is critical to your success. You should already know how to create spreadsheets using common mathematical formulas and Excel Functions. In AIS, you will develop or improve your skills linking multiple spreadsheets; creating formulas using Excel functions IF, VLOOKUP, ROUND; and creating PIVOT tables. Excel Assignment 1: For the first Excel assignment you will create a yearend workbook with multiple spreadsheets to convert the unadjusted trial balance of Waren Sports Supply to a set complete financial statements and account analysis. You should recall the steps in the accounting cycle to 1) prepare unadjusted trial balance, 2) determine and record adjustments, 3) create adjusted trial balance, and 4) create financial statements: Balance Sheet, Income Statement, Statement of Cash Flows (Indirect method). You will begin with the Yearend Worksheet template found on BlackBoard that includes all the accounts and unadjusted trial balance figures. The instructions below give you the information needed to calculate and record adjustments in Excel, and to add these adjustments to the Yearend Worksheet to create the adjusted trial balance. You will use the adjusted trial balance data to create financial statements in Excel. Your Excel workbook should be fully integrated. For example, a change in the tax rate from 15% to 17% should automatically update your tax expense/accrual adjustment, the adjusted trial balance, and the financial statements. Therefore, all calculations must be in Excel and all data should be referenced from one cell to another. Instructions: 1. Download the Waren Sports Supply Yearend Workbook from BlackBoard. Save the file as: lastname_firstname_WSS2016spring. 2. You will note that the December 31, 2013 Post Closing Trial Balance and December 31, 2014 Unadjusted Trial Balance are populated with numbers. a. Do debits equal credits? i. Use the SUM function to total each column of the spreadsheet. b. Should the 2014 allowance for doubtful accounts be a debit or credit balance? i. How could this happen? You will make an adjustment later. c. Why are 2014 retained earnings the same as 2013? i. When is net income or loss recorded in retained earnings? ii. We will not close out the temporary accounts at this time. 3. ADJUSTMENT SHEET: Adjustments will be recorded on the Adjustment worksheet in the Excel Workbook. a. Use the VLOOKUP function to populate account name after you input the account number. (Click on the hyperlink for support from Microsoft.com.) You might find using Labels/Range Names is helpful to define the account numbers and titles. b. After each adjustment, write an explanation for the adjustment. Include any assumptions or calculation figures, such as bad debt expense rate or interest rate. This explanation is important documentation to support and justify the adjustment. c. Depreciation Expense is $35,109.50. Input this figure in the adjustments worksheet. d. Interest Expense: An $80,000, two-year note was signed and funded on December 16, 2014 with annual stated interest of 6%. Create a formula to calculate the adjustment amount based on a 365 day year. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. e. Bad debt expense: Bad debt expense is 0.2% of net sales. Create a formula to calculate the adjustment amount. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. f. Inventory and cost of sales adjustment: Waren uses the periodic inventory method. A physical inventory was taken at midnight on 12/31/14. The cost basis of the inventory on hand is $198,246.00. Adjust the inventory balance and close out the purchase and related accounts to cost of sales. g. Income tax expense: Income tax expense cannot be calculated until all other adjustments are posted and the income before income taxes reflects all adjustments. This will be calculated later in the assignment. h. Add the adjustment balances to the Yearend Worksheet in the Adjustments columns. Since there is only one adjustment per account, you can do this by using the = or + functions. (in a more complex company with multiple adjustments for each account, you might use the SUMIF function to bring adjustments forward to the Yearend Worksheet.) 4. Use formulas to combine the Unadjusted Trial Balance and Adjustments to create the Adjusted Trial Balance. Many accounts can be either a net debit or a net credit in the Adjusted Trial Balance. Consequently, IF statements must be used to determine if the balance is a debit or credit. The IF statement should place a blank if the criteria are not met, for example, =IF (debitscredits>0, debits-credits, \"\")replace debits and credits with cell references for the unadjusted trial balance and the adjustment columns. Copy the formulas to all cells in the total columns. 5. After completing steps 3 and 4, you are ready to calculate income tax expense. A table is included on the Yearend Worksheet to help you calculate income tax expense. a. Calculate income before income taxes using the Adjusted Trial Balance data. Income is equal to revenues minus expenses. In the accounting system, income is equal to credits minus debits. Create a formula in cell F59 on the Yearend Worksheet to calculate income before taxes, e.g., SUM(credits)-SUM(debits). (Do not bring income before tax from the income statement because you haven't created the income statement yet.) b. The marginal income tax rates are as follows: Income before Tax Rate $75,000 36% c. Use an IF statement to calculate income tax expense. The IF statement must consider income at 3 different levels. This requires an embedded or nested IF statement, i.e., 2 IF statements in one formula. (Be sure to test your IF statement at different levels of income before taxyour formula needs to work at all levels.) d. After calculating tax expense, you can determine Net Income. The Net Income check figure is provided. e. Create an adjustment for income tax expense on the Adjustment worksheet. The amount on the adjustment worksheet will be reference from cell F61 on the Yearend Worksheet. Bring the adjustment to the Yearend Worksheet in the adjustment columns. f. All adjustments are now complete. 6. Populate the Balance Sheet and Income Statement debit and credit columns on the Yearend Worksheet using IF statements similar to step 4. above. Total Balance Sheet debits will not equal total creditswhy? The same conditions apply to the Income Statement. Calculate the difference below to compare to Net Income. 7. Complete the Financial Statements on the appropriate worksheets. The Statement of Cash Flows uses the indirect method. a. Use formulas to insert the correct figures into the Financial Statements worksheets from the Yearend Worksheet balance sheet or income statement columns. i. December 31, 2014 retained earnings in the Balance Sheet will b. c. d. e. pull from the Income Statement because the temporary accounts haven't been closed. Calculations in the financial statements should be limited to sum, plus, and minus to aggregate or subtract accounts. On the Statement of Cash Flows you can bring the balances from the Yearend Worksheet or the Balance Sheet and Income Statement, whichever you prefer. Compare the ending cash balance on the Statement of Cash Flows to the Balance Sheet cash. The amounts should equal. Remove the gridlines from the financial statements. 8. The assignment is due at the time specified in the Syllabus. Your electronic submission MUST BE in EXCEL format. Google Docs, Open Office, Numbers, etc. are not acceptable formats. a. E-mail the completed workbook to aisassignments@gmail.com b. Upload using turnitin to BB>SUA Project Assignments > Excel Assignment. Turnitin will separate the pages, but we will be able to see and download your work. SDSU Accounting Information Systems ACCTG 333, Spring 2016 Excel Assignment Waren Sports Yearend Worksheet Introduction: Accountants use Excel to analyze transactions and accounts, prepare financial statements, calculate budgets, create invoices, and many more tasks. Mastering the basics of Excel is critical to your success. You should already know how to create spreadsheets using common mathematical formulas and Excel Functions. In AIS, you will develop or improve your skills linking multiple spreadsheets; creating formulas using Excel functions IF, VLOOKUP, ROUND; and creating PIVOT tables. Excel Assignment 1: For the first Excel assignment you will create a yearend workbook with multiple spreadsheets to convert the unadjusted trial balance of Waren Sports Supply to a set complete financial statements and account analysis. You should recall the steps in the accounting cycle to 1) prepare unadjusted trial balance, 2) determine and record adjustments, 3) create adjusted trial balance, and 4) create financial statements: Balance Sheet, Income Statement, Statement of Cash Flows (Indirect method). You will begin with the Yearend Worksheet template found on BlackBoard that includes all the accounts and unadjusted trial balance figures. The instructions below give you the information needed to calculate and record adjustments in Excel, and to add these adjustments to the Yearend Worksheet to create the adjusted trial balance. You will use the adjusted trial balance data to create financial statements in Excel. Your Excel workbook should be fully integrated. For example, a change in the tax rate from 15% to 17% should automatically update your tax expense/accrual adjustment, the adjusted trial balance, and the financial statements. Therefore, all calculations must be in Excel and all data should be referenced from one cell to another. Instructions: 1. Download the Waren Sports Supply Yearend Workbook from BlackBoard. Save the file as: lastname_firstname_WSS2016spring. 2. You will note that the December 31, 2013 Post Closing Trial Balance and December 31, 2014 Unadjusted Trial Balance are populated with numbers. a. Do debits equal credits? i. Use the SUM function to total each column of the spreadsheet. b. Should the 2014 allowance for doubtful accounts be a debit or credit balance? i. How could this happen? You will make an adjustment later. c. Why are 2014 retained earnings the same as 2013? i. When is net income or loss recorded in retained earnings? ii. We will not close out the temporary accounts at this time. 3. ADJUSTMENT SHEET: Adjustments will be recorded on the Adjustment worksheet in the Excel Workbook. a. Use the VLOOKUP function to populate account name after you input the account number. (Click on the hyperlink for support from Microsoft.com.) You might find using Labels/Range Names is helpful to define the account numbers and titles. b. After each adjustment, write an explanation for the adjustment. Include any assumptions or calculation figures, such as bad debt expense rate or interest rate. This explanation is important documentation to support and justify the adjustment. c. Depreciation Expense is $35,109.50. Input this figure in the adjustments worksheet. d. Interest Expense: An $80,000, two-year note was signed and funded on December 16, 2014 with annual stated interest of 6%. Create a formula to calculate the adjustment amount based on a 365 day year. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. e. Bad debt expense: Bad debt expense is 0.2% of net sales. Create a formula to calculate the adjustment amount. Use ROUND function to round to nearest penny. DO NOT TYPE IN A CALCULATED AMOUNT. f. Inventory and cost of sales adjustment: Waren uses the periodic inventory method. A physical inventory was taken at midnight on 12/31/14. The cost basis of the inventory on hand is $198,246.00. Adjust the inventory balance and close out the purchase and related accounts to cost of sales. g. Income tax expense: Income tax expense cannot be calculated until all other adjustments are posted and the income before income taxes reflects all adjustments. This will be calculated later in the assignment. h. Add the adjustment balances to the Yearend Worksheet in the Adjustments columns. Since there is only one adjustment per account, you can do this by using the = or + functions. (in a more complex company with multiple adjustments for each account, you might use the SUMIF function to bring adjustments forward to the Yearend Worksheet.) 4. Use formulas to combine the Unadjusted Trial Balance and Adjustments to create the Adjusted Trial Balance. Many accounts can be either a net debit or a net credit in the Adjusted Trial Balance. Consequently, IF statements must be used to determine if the balance is a debit or credit. The IF statement should place a blank if the criteria are not met, for example, =IF (debitscredits>0, debits-credits, \"\")replace debits and credits with cell references for the unadjusted trial balance and the adjustment columns. Copy the formulas to all cells in the total columns. 5. After completing steps 3 and 4, you are ready to calculate income tax expense. A table is included on the Yearend Worksheet to help you calculate income tax expense. a. Calculate income before income taxes using the Adjusted Trial Balance data. Income is equal to revenues minus expenses. In the accounting system, income is equal to credits minus debits. Create a formula in cell F59 on the Yearend Worksheet to calculate income before taxes, e.g., SUM(credits)-SUM(debits). (Do not bring income before tax from the income statement because you haven't created the income statement yet.) b. The marginal income tax rates are as follows: Income before Tax Rate $75,000 36% c. Use an IF statement to calculate income tax expense. The IF statement must consider income at 3 different levels. This requires an embedded or nested IF statement, i.e., 2 IF statements in one formula. (Be sure to test your IF statement at different levels of income before taxyour formula needs to work at all levels.) d. After calculating tax expense, you can determine Net Income. The Net Income check figure is provided. e. Create an adjustment for income tax expense on the Adjustment worksheet. The amount on the adjustment worksheet will be reference from cell F61 on the Yearend Worksheet. Bring the adjustment to the Yearend Worksheet in the adjustment columns. f. All adjustments are now complete. 6. Populate the Balance Sheet and Income Statement debit and credit columns on the Yearend Worksheet using IF statements similar to step 4. above. Total Balance Sheet debits will not equal total creditswhy? The same conditions apply to the Income Statement. Calculate the difference below to compare to Net Income. 7. Complete the Financial Statements on the appropriate worksheets. The Statement of Cash Flows uses the indirect method. a. Use formulas to insert the correct figures into the Financial Statements worksheets from the Yearend Worksheet balance sheet or income statement columns. i. December 31, 2014 retained earnings in the Balance Sheet will b. c. d. e. pull from the Income Statement because the temporary accounts haven't been closed. Calculations in the financial statements should be limited to sum, plus, and minus to aggregate or subtract accounts. On the Statement of Cash Flows you can bring the balances from the Yearend Worksheet or the Balance Sheet and Income Statement, whichever you prefer. Compare the ending cash balance on the Statement of Cash Flows to the Balance Sheet cash. The amounts should equal. Remove the gridlines from the financial statements. 8. The assignment is due at the time specified in the Syllabus. Your electronic submission MUST BE in EXCEL format. Google Docs, Open Office, Numbers, etc. are not acceptable formats. a. E-mail the completed workbook to aisassignments@gmail.com b. Upload using turnitin to BB>SUA Project Assignments > Excel Assignment. Turnitin will separate the pages, but we will be able to see and download your work. WAREN SPORTS SUPPLY, YEAR-END WORKSHEET, DECEMBER 31, 2014 (Accounts with no activity in this worksheet are excluded in this solution.) 12/31/2013 ACCT ACCOUNT POST CLOSING NO. TITLE TRIAL BALANCE DEBIT CREDIT 12/31/2014 UNADJUSTED TRIAL BALANCE DEBIT CREDIT YEAR-END ADJUSTMENTS DEBIT CREDIT ----------------- ----------------- 12/31/2014 ADJUSTED TRIAL BALANCE DEBIT CREDIT ADJUSTED BALANCE SHEET ADJUSTED INCOME STATEMENT DEBIT CREDIT DEBIT CREDIT ----------------- ----------------- ----------------- ----------------- ASSETS 10100 10200 10300 10400 10600 10800 10900 Cash Accounts receivable Allowance for doubtful accounts Inventory Marketable securities Fixed assets Accumulated depreciation 20100 20300 20400 20500 20600 20700 20900 21000 LIABILITIES Accounts payable Federal income taxes withheld State unemployment taxes payable Federal unemployment taxes payable F.I.C.A. taxes payable Federal incomes taxes payable Interest payable Notes payable 26000 29000 STOCKHOLDERS' EQUITY Common stock Retained earnings 30100 30200 30300 30400 30500 30600 30700 30800 31200 REVENUE AND GROSS PROFIT Sales Sales returns and allowances Sales discounts taken Cost of goods sold Purchases Purchases returns and allowances Purchases discounts taken Freight-in Miscellaneous revenue 40100 40200 40300 40400 40500 40600 40800 40900 41000 40700 11,025.19 21,065.00 EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries expense Payroll tax expense Interest expense Bad debt expense Other operating expense Federal income tax expense 3,250.81 101,681.00 320,665.00 109,988.07 44,537.00 1,149.19 101,681.00 24,000.00 332,590.00 81,559.50 81,559.50 11,279.35 1,326.76 281.17 83.31 1,593.30 39,797.00 8,767.15 1,670.43 85.98 25.47 2,210.04 0.00 80,000.00 225,000.00 90,264.99 225,000.00 90,264.99 1,587,586.00 61,111.00 15,405.82 1,132,015.00 19,445.00 16,631.60 24,642.69 825.00 57,600.00 21,905.00 5,621.45 141,024.23 11,512.96 29,287.75 ----------------- ----------------- ----------------- ----------------- ----------------- ----------------- TOTALS NET INCOME Income before Taxes NOTE: Income Tax Expense Net Income Tax rates for income before taxes $75,000 Net Income Check 15% 25% 36% 130,112.59 Debits and Credits in the Balance Sheet and Income Statement will not be equal. The difference is Net Income which hasn't been closed to retained earnings. Calculate the differences between debits and credits on the NET INCOME row for each statement. The amounts should equal and also equal the net income check figure WAREN SPORTS SUPPLY YEAR-END ADJUSTING ENTRIES DECEMBER 31, 2014 Entry # Account # 1 1 Account Title 40400 10900 Record depreciation expense for 2014 2 2 Debit Credit WAREN SPORTS SUPPLY BALANCE SHEET AT DECEMBER 31, 2014 AND 2013 ASSETS 2014 CURRENT ASSETS Cash Accounts receivable - net Inventory Marketable securities Total current assets FIXED ASSETS - Net of accumulated depreciation Total assets LIABILITIES AND STOCKHOLDERS' EQUITY CURRENT LIABILITIES Accounts payable Payroll taxes withheld and payable Federal income taxes payable Interest payable Total current liabilities NOTE PAYABLE Total liabilities STOCKHOLDERS' EQUITY Common stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 2013 WAREN SPORTS SUPPLY STATEMENT OF INCOME AND RETAINED EARNINGS FOR THE YEAR ENDED DECEMBER 31, 2014 REVENUE (Net Sales) COST OF GOODS SOLD GROSS MARGIN OPERATING EXPENSES Rent expense Advertising expense Office supplies expense Depreciation expense Wages and salaries Payroll taxes Bad debt expense Other operating expense Total operating expenses Operating income OTHER INCOME - Miscellaneous income OTHER EXPENSE - Interest expense INCOME BEFORE TAXES FEDERAL INCOME TAXES NET INCOME RETAINED EARNINGS - Beginning of year RETAINED EARNINGS - End of year WAREN SPORTS SUPPLY STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 2014 CASH FLOWS FROM OPERATING ACTIVITIES CASH FLOWS FROM INVESTING ACTIVITIES CASH FLOWS FROM FINANCING ACTIVITIES NET INCREASE IN CASH CASH - Beginning of year CASH - End of year