Hello everyone, as a beginner in VBA, I am struggling doing this step of an exercise, I don't know how to write the code, can someone help me please?
Calculation Discounted Total Value
It begins with input boxes asking for the EBIT then the income tax, the depreciation, the change in working capital and the capex.
It will do the following calculation to find the Free cash flow to the firm:
EBIT - income tax + depreciation - change in working capital - capex.
From the free cash flow found and the discount rate that we previously would have determined in an input box it will give the discounted cash flow: free cash flow / (1 + discount rate) ^ year number.
We would have to enter values for each year.
At the end the program will give us the discounted total value.
Calculation Discounted Total Value
It begins with input boxes asking for the EBIT then the income tax, the depreciation, the change in working capital and the capex.
It will do the following calculation to find the Free cash flow to the firm:
EBIT - income tax + depreciation - change in working capital - capex.
From the free cash flow found and the discount rate that we previously would have determined in an input box it will give the discounted cash flow: free cash flow / (1 + discount rate) ^ year number.
We would have to enter values for each year.
At the end the program will give us the discounted total value.