know there is a Bartleby on this, but the commas are all out of place and I'm still confused. Could you give a more in-depth solution and explain on how to calcultae FCF, specifically with excel functions? We are entering the widget business. It costs $500,000, payable in year 1, to develop a prototype. This cost can be depreciated on a straight-line basis during years 1-5. Each widget sells for $40 and incurs a variable cost of $20. During year 1 the market size is 100,000, and the market size is growing at 10% per year. Profits are taxed at 40%, but there are no taxes on negative profits. a) Given our other assumptions, what market share (in %) is needed to ensure the total free cash flow (FCF) of $0 over the five year period? Note: FCF during a year equals after-tax profits plus depreciation minus fixed costs (if any).b) Describe how an increase in percent market growth rate changes total FCF over years 1-5.c) Describe how simultaneous changes in percent market share and changes in percent market growth rate changes total FCF over years 1-5
I know there is a Bartleby on this, but the commas are all out of place and I'm still confused. Could you give a more in-depth solution and explain on how to calcultae FCF, specifically with excel functions?
We are entering the widget business. It costs $500,000, payable in year 1, to develop a prototype. This cost can be depreciated on a straight-line basis during years 1-5. Each widget sells for $40 and incurs a variable cost of $20. During year 1 the market size is 100,000, and the market size is growing at 10% per year. Profits are taxed at 40%, but there are no taxes on negative profits. a) Given our other assumptions, what market share (in %) is needed to ensure the total
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 8 images
