Please help solve problems 6-12 and 6-13. Kindly find attachment below for the question and templates for the problems.

PROBLEM 6-1 Cash provided by operations (CPBO) differs from free cash flow for the following reasons: 1. : Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-2 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-3 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-4 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-5 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-6 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-7 Given Solution Solution a-b. Balance Sheet Cash and Marketable Securit $ Accounts Receivable Inventories Current Assets $ Net Property Plant & Equipm Total $ 2015 500 6,000 9,500 16,000 17,000 33,000 100.00% Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owner 7,200 6,800 14,000 7,000 21,000 12,000 33,000 100.00% Income Statement Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income $ $ $ $ $ $ $ $ $ 2015 30,000 (20,000) 10,000 (8,000) 2,000 (900) 1,100 (400) 700 100.00% Solution c. Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-8 Given Sales Cost of Goods sold/Sales Operating expenses/sales Interest expense Earnings before Taxes Tax rate Net Income Solution: $ $ 15,000,000 60% 30% 300,000 0.35 Note: Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-9 Given WalMart Statements of Cash Flow In Millions of USD (except for per share item 12 Months ended 1/31/2013 1/31/2012 Net Income 12,731.00 11,284.00 Depreciation and Non-cash Items 6,470.00 6,308.00 Deferred Taxes (8.00) 89.00 Changes in Working Capital 1,161.00 2,271.00 Cash from Operating Activities 20,354.00 19,952.00 Capital Investment Expenditures Cash from Investing Activities 1/31/2011 11,231.00 4,720.00 (129.00) 2,419.00 18,241.00 1/31/2010 10,267.00 4,265.00 263.00 249.00 15,044.00 (15,670.00) (14,463.00) (14,186.00) (12,351.00) (15,670.00) (14,463.00) (14,186.00) (12,351.00) Interest and Financing Cash Flows Total Cash Dividends Paid Issuance (Retirement) of Stock, Net Issuance (Retirement) of Debt, Net Cash from Financing Activities (334.00) (3,586.00) (7,691.00) 4,477.00 (7,134.00) (227.00) (2,802.00) (1,718.00) (92.00) (4,839.00) (349.00) (2,511.00) (3,580.00) 4,018.00 (2,422.00) 113.00 (2,214.00) (4,549.00) 4,041.00 (2,609.00) Foreign Exchange Effects Net Change in Cash 252.00 (2,198.00) 97.00 747.00 (101.00) 1,532.00 205.00 289.00 Solution: Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-10 Given: ($ billions) Net Property, Plant and Equipment (2008 $ 3.507 Less: Depreciation Expense (2009) 0.727 Plus: Capex (2009) Net Property, Plant and Equipment (2009 $ 3.500 Solution: Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-11 Given: In Millions of $ Cash & Equivalents Short Term Investments Cash and Short Term Investments Accounts Receivable Inventories Total Current Assets Accounts Payable Accrued Expenses Notes Payable/Short Term Debt Current Port. of LT Debt Total Current Liabilities $ 2015 2014 2013 2012 807,926 $ 560,960 $ 617,866 $ 658,255 178,994 197,408 182,442 614,513 986,920 758,368 800,308 1,272,768 2,028,060 2,365,823 2,341,609 2,302,447 1,456,271 1,441,024 1,450,258 1,262,308 4,471,251 4,565,215 4,592,175 4,837,523 1,138,770 1,601,413 1,584,959 1,416,367 878,454 901,546 902,164 863,683 1,038,633 789,285 979,675 821,126 531,635 386,879 303,214 248,028 $ 3,587,492 $ 3,679,123 $ 3,770,012 $ 3,349,204 Solution a: Operating Current Assets Operating Current Liabilities Operating Net Working Capital Solution b: Change in Operating Net Working Capital Solution c: Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-12 Solution Legend Given (refer to problem 6-7): Balance Sheet Cash and Marketable Securities Accounts Receivable Inventories Current Assets Net Property Plant & Equipment Total Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity Income Statement Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income Projected growth rate in revenues Tax rate $ $ $ $ $ $ $ $ $ $ $ $ 2015 500 1.52% 6,000 18.18% 9,500 28.79% 16,000 48.48% 17,000 51.52% 33,000 100.00% 7,200 6,800 14,000 7,000 21,000 12,000 33,000 21.82% 20.61% 42.42% 21.21% 63.64% 36.36% 100.00% 2015 30,000 100.00% (20,000) -66.67% 10,000 33.33% (8,000) -26.67% 2,000 6.67% (900) -3.00% 1,100 3.67% (400) -1.33% 700 2.33% 20% 40% Solution: Pro forma Income Statement Sales Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income 2016 Balance Sheet Cash and Marketable Securities Accounts Receivable Inventories 2016 Current Assets Net Property Plant & Equipment Total Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity Additional Short-term Debt Needed 12,000 $ - Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-13 Solution Given (refer to problem 6-12): Balance Sheet Cash and Marketable Securities Accounts Receivable Inventories Current Assets Net Property Plant & Equipment Total Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity Income Statement Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income $ $ $ $ $ $ $ $ $ $ $ $ 2015 500 6,000 9,500 16,000 17,000 33,000 0.00% 7,200 6,800 14,000 7,000 21,000 12,000 33,000 0.00% 2015 30,000 100.00% (20,000) 10,000 (8,000) 2,000 (900) 1,100 (400) 700 Projected growth rate in revenues Tax rate 20% 40% Given (refer to problem 6-12): Pro forma Income Statement Sales Cost of Goods Sold Gross Profit Operating Expenses Net Operating income Interest Expense Earnings before Taxes Taxes Net Income 2016 Balance Sheet Cash and Marketable Securities Accounts Receivable Inventories 2016 Current Assets Net Property Plant & Equipment (Note A) Total Accounts Payable Short-term Debt Current Liabilities Long-term Debt Total Liabilities Total Owners' Equity Total Liabilities and Owners' Equity Additional Short-term Debt Needed Solution: Estimated Free Cash Flow EBIT -Taxes NOPAT + Depreciation and Amortization - Increase in Operating Net Working Capital - CapEx = Free Cash Flow Note A: Depreciation expense for 2016 = 2016 $ 2,000 Solution Legend = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output PROBLEM 6-14 Given Firm free cash flows (years 1 - 5) Cost of capital Terminal value multiple of cash flow (year 5) $ Solution a: Present value of cash flows for years 1-5 Solution b: Present value of the terminal value in year 5 Solution c: Enterprise Value = PV of interim cash flows + PV of Terminal Value 80 12% 5 Solution Legend million = Value given in problem = Formula/Calculation/Analysis required = Qualitative analysis or Short answer required = Goal Seek or Solver cell = Crystal Ball Input = Crystal Ball Output 6-12 FORCASTING PRO FORMA FINANCIAL STATEMENTS Prepare a pro forma income statement and balance sheet for Webb Enterprises, (see Problem 6-7), where revenues are expected to grow by 20% in 2016. Make the following assumptions in making your forecast of the firm's balance sheet in 2016: The income statement expenses are a constant percentage of revenues except for interest, which remains equal in dollar amount to the 2015 level, and taxes, which equal 40% of earnings before taxes. The cash and marketable securities balance remains equal to $500, and the remaining current asset accounts and fixed assets increase in proportion to the increase in revenues for 2015. Net property, plant, and equipment increase in proportion to the increase in revenues and depreciation expenses for 2016 is $2,000. Accounts payable increase in proportion to firm revenues. Owners' equity increases by the amount of firm net income for 2011 (no cash dividends are paid). Long-term debt remains unchanged, and short-term debt changes in an amount that balances the balance sheet. 6-13 FORECASTING FIRM FCF Using your pro forma financial statements from problem 6-12, estimate the firm's FCF for 2016