Explore BrainMass

Free Cash Flows Problem: Excel Spreadsheet

Can someone help me solve this problem to project the free cash flows based on this financial data on the attached Excel Spreadsheet?

Fill in the yellow cells with formulas to project 2004 free cash flows. Follow the hints on the spreadsheets - the file should open to the best starting point.


Solution Preview

Please see the attached file. Have a look at formulas in cells.

Operating Income 160,710.0 128,866.4 131,877.2
Tax on Operating Income (34%) 54,641.4 43,814.6 40,758.3
NOPAT 106,068.6 85,051.8 91,119.0
Net Operating WC 403,322.0 438,764.0 443,273.0
Net Operating Long Term ...

Solution Summary

This solution provides an explanation on how to solve a problem regarding a project of free cash flow.