Investment assignment

Initial investment :  243,824.60 Sales price  / pc:  6.29 Material costs  / piece:  3.23 Sales volume pcs: 52894.00 Sales volume growth after year 1: 5.00% Other operating expenses:  10,327.00 Tax rate: 20.00% Yield requirement: 12.00% Lost income:  37,347.00 Depreciation period of the initial investment: 3

fill the following excel and answer the questions:

Critical selling price (in year 1) = ?  Margin return percentage (in year 1) = ? % Free cash flow (FCF) (in year 2) = ?  Present value in year 0 = ?  Net present value (3 year investment) = ?  NPV alternative (3 year investment) = ? 

Year Investment Sales amount Revenue Cost of goods sold Operating expences Depreciations Taxes Free cash Flow Cumulative FCF WACC Discounting factor Present value NPV EBIT 0.00 0.00 I (5) 3 . 0.00% 0.0000 - 1.00 0.00 . 15 15 3 - 0.00% 0.0000 2.00 0.00 - 0.00% 0.0000 W 3.00 0.00 - . 0.00% 0.0000 Year Investment Sales amount Revenue Cost of goods sold Operating expences Depreciations Taxes Free cash Flow Cumulative FCF WACC Discounting factor Present value NPV EBIT 0.00 0.00 I (5) 3 . 0.00% 0.0000 - 1.00 0.00 . 15 15 3 - 0.00% 0.0000 2.00 0.00 - 0.00% 0.0000 W 3.00 0.00 - . 0.00% 0.0000