Question
(Calculating free cash flows) Presently, Solartech Skateboards is considering expanding its product line to include gas-powered skateboards; however, it is questionable how well they will
(Calculating free cash flows) Presently, Solartech Skateboards is considering expanding its product line to include gas-powered skateboards; however, it is questionable how well they will be received by skateboarders. While you feel there is a 60 percent chance you will sell 10,000 of these per year for 10 years (after which time this project is expected to shut down because solar-powered skateboards will become more popular), you also recognize that there is a 20 percent chance that you will only sell 3,000 and also a 20 percent chance you will sell 13,000. The gas skateboards would sell for $100 each and have a variable cost of $40 each. Regardless of how many you sell, the annual fixed costs associated with production would be $160,000. In addition, there would be a $1,000,000 initial expenditure associated with the purchase of new production equipment. It is assumed that this initial expenditure will be depreciated using simplified straight-line method down to zero over 10 years. Because of the number of stores that will need inventory, the working capital requirements are the same regardless of the level of sales, and this project will require a one-time initial investment of $50,000 in net working capital, and that working-capital investment will be recovered when the project is shut down. Finally, assume that the firms marginal tax rate is 34 percent.
- Whatistheinitialoutlayassociatedwiththeproject?
- Whataretheannualfreecashflowsassociatedwiththeprojectforyears1through9undereachsalesforecast?Whatistheexpectedannualfreecashflowsforyears1through9?
- What is the terminal cash flow in year 10 (that is, what is the free cash flow in year 10 plus any additional cash flows associated with the termination of the project)?
- Usingtheexpectedfreecashflows,whatistheprojectsNPVgivena10percentrequiredrateofreturn?WhatwouldtheprojectsNPVbeiftheysold10,000skateboards?
I know how to come up with the answers if there was a 100 percent chance to sell 10,000 skateboards for 10 years.
EBIT = units sold(sales-variable costs) (fixed costs) - depreciation
EBIT = 10,000 (100-40) 160,000 100,000 = 340,000
EBIT(1 - tax rate) = net income
340,000 (1 0.34) = 224,400
Annual Free Cash flows for year 1 to 9: 224, 400 + 100,000 = 324,400
324,400 + 50,000 = 374,400
Using excel, NPV given a 10 percent required rate of return = $962,574.73 .
Not sure how to to this when it is broken down to 60%-20%-20% chance. That is where I need help.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started