CR Oil is an integrated oil company. The following information is taken from its income statements for 2009 and 2010 (all dollar figures are in millions):,2009,Sales: $15,000; cost of goods sold: 50% of sales, depreciation: $500, CAPEX: $400, additional investment in net working capital: $150,2010,Sales: $16,000, cost of goods sold: 55% of sales, depreciation: $580, CAPEX: $250, additional investment in net working capital: $50,Applicable tax rate for the company is 35%.,Calculate company’s free cash flows (FCF) for 2009 and 2010,Estimate company’s FCF for 2010-2014 using the following assumptions: , Company’s sales will grow at 6% per year over the next five years;, Cost of goods sold as a percentage of sales is expected to increase by 1% each year, i.e., the gross margin ratio will be decreasing by 1% every year;, Total CAPEX each year is expected to be equal to 25% of additional sales that year (compared to the previous year);, Increase in net working capital in a given year will be equal to 5% of additional sales that year (compared to the previous year);, Total depreciation each year will be equal to the total depreciation in a prior year plus 20 % of CAPEX incurred in a prior year (for example, depreciation in 2010 was 500 + 20% x 400 = 580). Since the company is a going concern we need not be concerned about the liquidation value of the firm’s assets at the end of 2015.,,Please put in excel so I can see calulatation to check myself thx

Order Your Custom Essay

Order Your Custom Essay

Regent Papers is a library of common essays on high school, college, undergraduate and postgraduate topics. We have collected top papers from various institution, students and professors. The papers are based on common essay topics in all subjects.

M | T | W | T | F | S | S |
---|---|---|---|---|---|---|

« Oct | ||||||

1 | ||||||

2 | 3 | 4 | 5 | 6 | 7 | 8 |

9 | 10 | 11 | 12 | 13 | 14 | 15 |

16 | 17 | 18 | 19 | 20 | 21 | 22 |

23 | 24 | 25 | 26 | 27 | 28 | 29 |

30 |

2922 Oak Grove Drive La CaĆ±ada Flintridge, CA 91521.

+2 54723059803 (text only-sms)

© 2015 www.regentessays.com. All Rights Reserved