Hello,

I need help with a finance assignment. The company to work on is EXXON MOBIL. I need 100 percent accuracy. Thank you

FS to FCF Template Based on historical financial data, find FCF for the company of your choice. 1. In week 1 you were asked to choose a publicly traded company and submit its name for instructor's approval. Assuming 2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4). Template below is approximate, you may modify it to suit your company 3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice Solution Legend Value given in problem Formula/Calculation/Analysis required Qualitative analysis or Short answer required If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Financial Data Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Year 2 Year 3 Year 4 Year 5 Year 1 Current Assets, other than Cash and Marketable Securities Current Liabilities, excluding Debt Net Working Capital (CA-CL) Year 2 Year 3 Year 4 Year 5 Year 2 Year 3 Year 4 Year 5 Assets Cash & Short Term Investments Short-term Investments Receivables Inventories Prepaid Expenses Total Current Assets Net Property, Plant & Equipment Total Assets Liabilities Accounts payable Current maturities of long-term debt Income taxes payable Total current liabilities Long-term debt Total Liabilities Total stockholders' equity (deficit) Total Liabilities & Shareholder's Equity Income Statement Revenue Total revenues Expenses Cost of Goods Sold General, administrative and other Depreciation and amortization Total expenses Operating income Interest expense Income before income taxes Income tax benefit (expense) Net income Dividends Paid Non-distributed Income Find Changes in NWC Change in NWC (NWC Investment) Find CapEx Year 1 Net Property, Plant & Equipment Depreciation and amortization Capex You can read more using the following link Howard Keen, Clearing Up Confusion over calculation of FCF. Estimate FCF If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Tax Rate Year Year 1 Year 2 Year 3 Year 4 Year 5 EBIT EBIT(1-T) = NOPAT Plus: Depreciation Expense Less: CAPEX Less: Working Capital Investment Firm Free Cash Flow Page 1 Based on historical financial data, find FCF for the company of your choice (Exxon Mobil). 1. In week 1 please choose a publicly traded company and submit its name for instructor's approval. Please do not choose a company which became public less than 3 years ago. It is also a good idea to choose a company that is already paying dividends on regular basis. 2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4) 3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice. I suggest starting from the FS to FCF Practice Template and adjust it accordingly FS to FCF Template Based on historical financial data, find FCF for the company of your choice. 1. In week 1 you were asked to choose a publicly traded company and submit its name for instructor's approval. Assuming 2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4). Template below is approximate, you may modify it to suit your company Solution Legend Value given in problem Formula/Calculation/Analysis required Qualitative analysis or Short answer required 3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Financial Data 2012 2013 Year 1 Year 2 (In Millions) Assets Cash & Short Term Investments Short-term Investments Receivables Inventories Prepaid Expenses Total Current Assets Net Property, Plant & Equipment Total Assets Liabilities Accounts payable Current maturities of long-term debt Income taxes payable Total current liabilities Long-term debt Total Liabilities Total stockholders' equity (deficit) Total Liabilities & Shareholder's Equity (In Millions) Income Statement Revenue Total revenues Expenses Cost of Goods Sold General, administrative and other Depreciation and amortization Total expenses Operating income Interest expense Income before income taxes Income tax benefit (expense) Net income Dividends Paid Non-distributed Income 2014 Year 3 2015 Year 4 2016 Year 5 $9,923 $34,987 $14,542 $5,008 $64,460 $269,335 $333,795 $4,913 $33,152 $16,135 $5,108 $59,308 $287,500 $346,808 $4,658 $28,009 $16,678 $3,565 $52,910 $296,583 $349,493 $3,705 $19,875 $16,245 $2,798 $42,623 $294,135 $336,758 $3,657 $21,394 $15,080 $1,285 $41,416 $288,898 $330,314 $50,728 $3,653 $9,758 $64,139 $97,996 $162,135 $171,660 $333,795 $48,085 $15,808 $7,831 $71,724 $94,589 $166,313 $180,495 $346,808 $42,227 $17,468 $4,938 $64,633 $103,796 $168,429 $181,064 $349,493 $32,412 $18,762 $2,802 $53,976 $105,972 $159,948 $176,810 $336,758 $31,193 $13,830 $2,615 $47,638 $108,846 $156,484 $173,830 $330,314 Year 1 2012 $480,681 Year 2 2013 $438,255 Year 3 2014 $411,939 Year 4 2015 $268,882 Year 5 2016 $226,094 $371,863 $13,877 $15,888 $401,628 $79,053 $327 $78,726 ($31,045) $47,681 $10,419 $37,262 $350,476 $12,877 $17,182 $380,535 $57,720 $9 $57,711 ($24,263) $33,448 $11,179 $22,269 $330,128 $12,598 $17,297 $360,023 $51,916 $286 $51,630 ($18,015) $33,615 $11,816 $21,799 $217,056 $11,501 $18,048 $246,605 $22,277 $311 $21,966 ($5,415) $16,551 $12,260 $4,291 $184,565 $10,799 $22,308 $217,672 $8,422 $453 $7,969 $406 $8,375 $12,615 ($4,240) Year 1 $54,537 $60,486 ($5,949) Year 2 $54,395 $55,916 ($1,521) Year 3 $48,252 $47,165 $1,087 Year 4 $38,918 $35,214 $3,704 Year 5 $37,759 $33,808 $3,951 $4,428 $2,608 $2,617 $247 Find Changes in NWC Current Assets, other than Cash and Marketable Sec Current Liabilities, excluding Debt Net Working Capital (CA-CL) Change in NWC (NWC Investment) Find CapEx Net Property, Plant & Equipment Depreciation and amortization Capex You can read more using the following link Year 1 $269,335 $15,888 Year 2 Year 3 Year 4 $287,500 $296,583 $294,135 $17,182 $17,297 $18,048 $18,165 $9,083 ($2,448) Howard Keen, Clearing Up Confusion over calculation of FCF. Year 5 $288,898 $22,308 ($5,237) Estimate FCF Tax Rate 35% If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Year Year 1 EBIT EBIT(1-T) = NOPAT Plus: Depreciation Expense Less: CAPEX Less: Working Capital Investment Firm Free Cash Flow Year 2 $57,720 $37,518 $17,182 $18,165 $4,428 $32,107 Year 3 $51,916 $33,745 $17,297 $9,083 $2,608 $39,351 Year 4 $22,277 $14,480 $18,048 ($2,448) $2,617 $32,359 Year 5 $8,422 $5,474 $22,308 ($5,237) $247 $32,772 Based on the financial information of EXXON MOBIL CORPORATION taken from its 10K Statement for the year ending 2016, 2015, 2014, 2013 and 2012, free cash flow of the organization has been determined. The free cash flow of the firm has been positve during last 4 years, the trend analysis of free cash flows shows that there has been a significant drop in the amount of free cash flow durin year 4 and for the remainning years the free cash flow has been quite stable, the reason for the drop during year 4 is low earnings of the firm. Page 1 FS to FCF Template Based on historical financial data, find FCF for the company of your choice. 1. In week 1 you were asked to choose a publicly traded company and submit its name for instructor's approval. Assuming 2. Download annual financial data for the last 5 years from Edgar Website (forms 10-K). Attention: if your company became public less than 5 years ago, you will also have to download data from its IPO filing prospectus (form 424B4). Template below is approximate, you may modify it to suit your company Solution Legend Value given in problem Formula/Calculation/Analysis required Qualitative analysis or Short answer required 3. Using approach similar to the one described in this module's Excel file you will have to calculate the FCF for the company of your choice If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Financial Data 2012 2013 Year 1 Year 2 (In Millions) Assets Cash & Short Term Investments Short-term Investments Receivables Inventories Prepaid Expenses Total Current Assets Net Property, Plant & Equipment Total Assets Liabilities Accounts payable Current maturities of long-term debt Income taxes payable Total current liabilities Long-term debt Total Liabilities Total stockholders' equity (deficit) Total Liabilities & Shareholder's Equity (In Millions) Income Statement Revenue Total revenues Expenses Cost of Goods Sold General, administrative and other Depreciation and amortization Total expenses Operating income Interest expense Income before income taxes Income tax benefit (expense) Net income Dividends Paid Non-distributed Income 2014 Year 3 2015 Year 4 2016 Year 5 $9,923 $34,987 $14,542 $5,008 $64,460 $269,335 $333,795 $4,913 $33,152 $16,135 $5,108 $59,308 $287,500 $346,808 $4,658 $28,009 $16,678 $3,565 $52,910 $296,583 $349,493 $3,705 $19,875 $16,245 $2,798 $42,623 $294,135 $336,758 $3,657 $21,394 $15,080 $1,285 $41,416 $288,898 $330,314 $50,728 $3,653 $9,758 $64,139 $97,996 $162,135 $171,660 $333,795 $48,085 $15,808 $7,831 $71,724 $94,589 $166,313 $180,495 $346,808 $42,227 $17,468 $4,938 $64,633 $103,796 $168,429 $181,064 $349,493 $32,412 $18,762 $2,802 $53,976 $105,972 $159,948 $176,810 $336,758 $31,193 $13,830 $2,615 $47,638 $108,846 $156,484 $173,830 $330,314 Year 1 2012 $480,681 Year 2 2013 $438,255 Year 3 2014 $411,939 Year 4 2015 $268,882 Year 5 2016 $226,094 $371,863 $13,877 $15,888 $401,628 $79,053 $327 $78,726 ($31,045) $47,681 $10,419 $37,262 $350,476 $12,877 $17,182 $380,535 $57,720 $9 $57,711 ($24,263) $33,448 $11,179 $22,269 $330,128 $12,598 $17,297 $360,023 $51,916 $286 $51,630 ($18,015) $33,615 $11,816 $21,799 $217,056 $11,501 $18,048 $246,605 $22,277 $311 $21,966 ($5,415) $16,551 $12,260 $4,291 $184,565 $10,799 $22,308 $217,672 $8,422 $453 $7,969 $406 $8,375 $12,615 ($4,240) Year 1 $54,537 $60,486 ($5,949) Year 2 $54,395 $55,916 ($1,521) Year 3 $48,252 $47,165 $1,087 Year 4 $38,918 $35,214 $3,704 Year 5 $37,759 $33,808 $3,951 $4,428 $2,608 $2,617 $247 Find Changes in NWC Current Assets, other than Cash and Marketable Sec Current Liabilities, excluding Debt Net Working Capital (CA-CL) Change in NWC (NWC Investment) Find CapEx Net Property, Plant & Equipment Depreciation and amortization Capex You can read more using the following link Year 1 $269,335 $15,888 Year 2 Year 3 Year 4 $287,500 $296,583 $294,135 $17,182 $17,297 $18,048 $18,165 $9,083 ($2,448) Howard Keen, Clearing Up Confusion over calculation of FCF. Year 5 $288,898 $22,308 ($5,237) Estimate FCF Tax Rate 35% If you have difficulty estimating company's tax rate you may assume statutory tax rate of 35% Year Year 1 EBIT EBIT(1-T) = NOPAT Plus: Depreciation Expense Less: CAPEX Less: Working Capital Investment Firm Free Cash Flow Year 2 $57,720 $37,518 $17,182 $18,165 $4,428 $32,107 Year 3 $51,916 $33,745 $17,297 $9,083 $2,608 $39,351 Year 4 $22,277 $14,480 $18,048 ($2,448) $2,617 $32,359 Year 5 $8,422 $5,474 $22,308 ($5,237) $247 $32,772 Based on the financial information of EXXON MOBIL CORPORATION taken from its 10K Statement for the year ending 2016, 2015, 2014, 2013 and 2012, free cash flow of the organization has been determined. The free cash flow of the firm has been positve during last 4 years, the trend analysis of free cash flows shows that there has been a significant drop in the amount of free cash flow durin year 4 and for the remainning years the free cash flow has been quite stable, the reason for the drop during year 4 is low earnings of the firm. Page 1