Question: please explain these with excel calculations. Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500

please explain these with excel calculations.
 please explain these with excel calculations. Consider the following data with
regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating
expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% -
Incremental investment in operating net working capital =$50 - Incremental investment in
long-term operating assets =$4,000 If depreciation expense was to increase by 10%

Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% - Incremental investment in operating net working capital =$50 - Incremental investment in long-term operating assets =$4,000 If depreciation expense was to increase by 10% but everything else remains as shown above, how much would free cash flow change? Assume no other factors change. Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 . If your result shows a decrease, enter a negative figure. 1 point Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% - Incremental investment in operating net working capital =$50 - Incremental investment in long-term operating assets =$4,000 If the incremental investment in operating net working capital was to increase by 10% but everything else remains as shown above, how much would free cash flow change? Assume no other factors change. Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 . If your result shows a decrease, enter a negative figure. Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% - Incremental investment in operating net working capital =$50 - Incremental investment in long-term operating assets =$4,000 If the incremental investment in operating net working capital was to decrease by 10% but everything else remains as shown above, how much would free cash flow change? Assume no other factors change. Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 . If your result shows a decrease, enter a negative figure. Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% - Incremental investment in operating net working capital =$50 - Incremental investment in long-term operating assets =$4,000 If the tax rate was to decrease to 20% but everything else remains as shown above, how much would free cash flow change? Assume no other factors change. Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 . If your result shows a decrease, enter a negative figure. Consider the following data with regards to free cash flow (FCF): - Revenue =$100,000 - Cash operating expenses =$93,500 - Depreciation expense =$1,000 - Effective tax rate =25% - Incremental investment in operating net working capital =$50 - Incremental investment inlong-term operating assets $4,000 If the tax rate was to increase to 35% but everything else remains as shown above, how much would free cash flow change? Assume no other factors change. Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 . If your result shows a decrease, enter a negative figure

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!