Hello,

Could anyone please solve this task in excel and show the formulas they used?

You are asked to compute the free cash flows for a project with a duration of 4 years. You receive the following relevant selected information: 0 1 2 3 4 5 Sales - 22.97 22.97 22.97 22.97 Costs of goods Sold - 12.72 12.72 12.72 12.72 Unlevered Net Income -6.56 4.71 3.45 7.35 3.96 - 1.77 Depreciation - 2.95 2.95 2.95 2.95 2.95 In addition you know that 15% of sales and costs of goods sold are entering and exiting working capital every period. What is the free cash flow over the whole duration of the project? (rounded to two decimal places) Select one: a.-18.36; 0.22; 0.5; 4.4;1.01; -3.18 b.-21.31;9.2; 6.4; 10.3; 6.91; -0.36 C.-21.31; 0.22; 0.5; 4.4;1.01; -3.18 X False. d. -6.56; 0.22; 0.5; 4.4;1.01; -3.18 e.-21.31; 6.12; 6.4; 10.3; 6.91; 2.72