Given the information above, Identify all sources of cash (cash inflow), and uses of cash (cash outflow) for the period of August 31, 2012 to May 31 2013. Please perform in excel then attach the results here in a table.

Exhibit 1 Monthly Shipments at Selling Price (thousands of dollars) Forecast as of Forecast as of Month Actual September 2012 May 2013 6,421 2012 October 6,508 November 6,219 6,302 December 6,250 6,009 January 2013 6,074 6,170 6,006 February 5,996 March 6,291 5,197 April 6,515 4,165 ay 6,832 3,744 50,685 44,014 Eight months total 6,759 June 12,681 July 7,374 6,645 August 6,478 7,201 September 6,433 7,394 Twelve months total 26,315 34,650 Fiscal vear total 77,000 78.664 Exhibit 2 Balance Sheets, 2012-2013 (thousands of dollars) 2012 2013 November December August September October January February March April May Cash 8,350 3,328 3,523 4,511 4,239 4,878 5,182 3,962 6,277 4,994 5,793 5,969 6,421 5,851 6,009 6,170 5,606 5,197 3,365 3,744 Accounts receivable 11,234 Inventory 7,154 21,297 7,364 16,661 7,524 7,219 17,581 7,277 17,525 7,097 18,145 7,529 18,317 8,371 17,530 12,163 20,901 Current assets 17,468 20,876 45,500 45,500 Gross PP&E 45,500 45,500 45,500 45,500 45,500 45,500 45,500 45,500 30,368 31.208 31,328 31.448 30,488 30,608 30,728 30,848 30.968 31,088 Accumulated depreciation Net PP&E 15,132 15,012 14,892 14,772 14,652 14,532 14,412 14,292 14,172 14,052 Prepaid expenses 242 58 23 45 47 52 65 46 46 54 31,731 32,383 32,398 35,094 Total assets 36,671 32.224 32,729 32,794 31,868 35,007 4,977 5,197 5,347 5,352 5,110 5,130 5,162 5,122 6,223 5,969 Accounts payable Notes payable, bank 0 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 4 252 174 331 107 269 417 140 216 273 Accrved taxes Other accrued expenses 1,142 1,142 1,500 1,542 1,542 1,542 1,542 1,542 1,542 1,142 Customer advance payments 1,651 1,651 1,651 1,200 1,200 1,200 800 800 2,700 2,700 Current liabilities 12,959 13,141 12,204 8,380 13,394 13,714 13,425 12,921 15.281 15,084 Shareholders' equity 28,291 18,337 18,668 18,973 19,265 19,588 19,874 19,664 19,813 19,923 Total liabilities and equity 31,731 36,671 32,383 32,398 32,224 32,729 32,794 31,868 35,094 35,007 Selling term of net 30 days Depreciation of $120,000 per month Purchase terms of net 30 days Outstanding taxes on 2012 fiscal year income were due January 15, 2013. On December 15, 2011, March 15, 2012, June 15, 2012, and September 15, 2012, payments of 25 % of each of the estimated tax for 2012 ($1,500,000) 15, 2013, June 15, 2013, and September 15, 2013, in equal increments were due. Taxes payable for 2013 were assumed to be $1,500,000 and would be paid on December 15, 2012, March Exhibit 3 Income Statemehts, 2012-2013 (thousands of dollars) Eight Fiscal Year 2012 Ending September 09/30/2012 2012 2012 2012 2012 2013 2013 2013 2013 2013 Months November December January February August October March April May Total Net sales 6,321 5,969 71,642 6,421 6,302 6,009 6,170 6,006 5,197 4,165 3,744 44,014 56,955 COGS 4,994 4,727 5,003 4,914 4,695 4,815 4,692 4,087 3,215 2,876 34,297 1,314 Gross profit 1,327 1,418 1,388 1,314 1,242 14,687 1,355 1,110 950 868 9,717 Operating expenses Depreciation and amortization Interest expense 9,509 773 763 777 788 733 728 744 685 587 566 5,608 120 120 1,440 120 120 120 120 120 120 120 120 960 0 0 0 25 25 25 25 25 25 25 25 200 Interest income 13 14 120 6 6 7 7 10 60 Profit (loss) before tax 447 373 3,858 502 461 443 489 433 289 225 167 3,009 Income taxes 152 127 1.312 171 157 151 166 147 98 76 57 1,023 2,546 400 295 293 1,986 Net income 246 331 304 323 286 191 148 111 Dividends 0 200 0 0 0 0 400 0 400 a 6% annualized interest rate charged on outstanding bank loans. 2% annualized rate of retum on beginning monthly cash balances The federal tax rate on all eamings was 34%. Exhibit 1 Monthly Shipments at Selling Price (thousands of dollars) Forecast as of Forecast as of Month Actual September 2012 May 2013 6,421 2012 October 6,508 November 6,219 6,302 December 6,250 6,009 January 2013 6,074 6,170 6,006 February 5,996 March 6,291 5,197 April 6,515 4,165 ay 6,832 3,744 50,685 44,014 Eight months total 6,759 June 12,681 July 7,374 6,645 August 6,478 7,201 September 6,433 7,394 Twelve months total 26,315 34,650 Fiscal vear total 77,000 78.664 Exhibit 2 Balance Sheets, 2012-2013 (thousands of dollars) 2012 2013 November December August September October January February March April May Cash 8,350 3,328 3,523 4,511 4,239 4,878 5,182 3,962 6,277 4,994 5,793 5,969 6,421 5,851 6,009 6,170 5,606 5,197 3,365 3,744 Accounts receivable 11,234 Inventory 7,154 21,297 7,364 16,661 7,524 7,219 17,581 7,277 17,525 7,097 18,145 7,529 18,317 8,371 17,530 12,163 20,901 Current assets 17,468 20,876 45,500 45,500 Gross PP&E 45,500 45,500 45,500 45,500 45,500 45,500 45,500 45,500 30,368 31.208 31,328 31.448 30,488 30,608 30,728 30,848 30.968 31,088 Accumulated depreciation Net PP&E 15,132 15,012 14,892 14,772 14,652 14,532 14,412 14,292 14,172 14,052 Prepaid expenses 242 58 23 45 47 52 65 46 46 54 31,731 32,383 32,398 35,094 Total assets 36,671 32.224 32,729 32,794 31,868 35,007 4,977 5,197 5,347 5,352 5,110 5,130 5,162 5,122 6,223 5,969 Accounts payable Notes payable, bank 0 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 5,000 4 252 174 331 107 269 417 140 216 273 Accrved taxes Other accrued expenses 1,142 1,142 1,500 1,542 1,542 1,542 1,542 1,542 1,542 1,142 Customer advance payments 1,651 1,651 1,651 1,200 1,200 1,200 800 800 2,700 2,700 Current liabilities 12,959 13,141 12,204 8,380 13,394 13,714 13,425 12,921 15.281 15,084 Shareholders' equity 28,291 18,337 18,668 18,973 19,265 19,588 19,874 19,664 19,813 19,923 Total liabilities and equity 31,731 36,671 32,383 32,398 32,224 32,729 32,794 31,868 35,094 35,007 Selling term of net 30 days Depreciation of $120,000 per month Purchase terms of net 30 days Outstanding taxes on 2012 fiscal year income were due January 15, 2013. On December 15, 2011, March 15, 2012, June 15, 2012, and September 15, 2012, payments of 25 % of each of the estimated tax for 2012 ($1,500,000) 15, 2013, June 15, 2013, and September 15, 2013, in equal increments were due. Taxes payable for 2013 were assumed to be $1,500,000 and would be paid on December 15, 2012, March Exhibit 3 Income Statemehts, 2012-2013 (thousands of dollars) Eight Fiscal Year 2012 Ending September 09/30/2012 2012 2012 2012 2012 2013 2013 2013 2013 2013 Months November December January February August October March April May Total Net sales 6,321 5,969 71,642 6,421 6,302 6,009 6,170 6,006 5,197 4,165 3,744 44,014 56,955 COGS 4,994 4,727 5,003 4,914 4,695 4,815 4,692 4,087 3,215 2,876 34,297 1,314 Gross profit 1,327 1,418 1,388 1,314 1,242 14,687 1,355 1,110 950 868 9,717 Operating expenses Depreciation and amortization Interest expense 9,509 773 763 777 788 733 728 744 685 587 566 5,608 120 120 1,440 120 120 120 120 120 120 120 120 960 0 0 0 25 25 25 25 25 25 25 25 200 Interest income 13 14 120 6 6 7 7 10 60 Profit (loss) before tax 447 373 3,858 502 461 443 489 433 289 225 167 3,009 Income taxes 152 127 1.312 171 157 151 166 147 98 76 57 1,023 2,546 400 295 293 1,986 Net income 246 331 304 323 286 191 148 111 Dividends 0 200 0 0 0 0 400 0 400 a 6% annualized interest rate charged on outstanding bank loans. 2% annualized rate of retum on beginning monthly cash balances The federal tax rate on all eamings was 34%