NCF Please calculate NCF for each year Sales 50,000,000 130,000,000 150,000,000
ID: 2728485 • Letter: N
Question
NCF
Please calculate NCF for each year
Sales 50,000,000 130,000,000 150,000,000 160,000,000 110,000,000 80,000,000 var % 30% 30% 30% 30% 30% 30% Var $ 15,000,000 39,000,000 45,000,000 48,000,000 33,000,000 24,000,000 Fixed $ 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 10,000,000 Dep % 20.00% 32.00% 19.00% 12.00% 11.00% 6.00% Dep $ 24,000,000 38,400,000 22,800,000 14,400,000 13,200,000 7,200,000 EBIT 25,000,000 81,000,000 95,000,000 102,000,000 67,000,000 46,000,000 tax % 30.24% 30.24% 30.24% 30.24% 30.24% 30.24% Tax $ 7,560,000 24,494,400 28,728,000 30,844,400 20,260,800 13,910,400 NI 17,440,000 56,505,600 66,272,000 71,155,600 46,739,200 32,089,600NCF
Please calculate NCF for each year
Explanation / Answer
Calculation of net cash flow Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 EBIT $25,000,000 $81,000,000 $95,000,000 $102,000,000 $67,000,000 $46,000,000 Tax @ 30.24% $7,560,000 $24,494,400 $28,728,000 $30,844,800 $20,260,800 $13,910,400 Earning after tax $17,440,000 $56,505,600 $66,272,000 $71,155,200 $46,739,200 $32,089,600 Add: - Depreciation $24,000,000 $38,400,000 $22,800,000 $14,400,000 $13,200,000 $7,200,000 Net cash flow $41,440,000 $94,905,600 $89,072,000 $85,555,200 $59,939,200 $39,289,600 The caculation has been done from EBIT number onwards
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.