Question
My company sells a new style of testosterone boosters for guys that enjoy working out. They are high quality, reasonably affordable and highly effective. All
My company sells a new style of testosterone boosters for guys that enjoy working out. They are high quality, reasonably affordable and highly effective. All bottles of testosterone boosters would sell for $50 each. Given that the purchase price of the equipment to create each bottle is $20,000 (with the depreciation set at $2,000/year for a period of 5 years), the initial bottles to be sold in Year 1 is 3,000. Years 2 and 3 are predicted to go up to 5,000, while Years 4 and 5 leveled up to 6,000. Assume that the rent for the factory is $30,000 a year, it stays that way. To add to this, employees' wages are set aside at $10,000 per year. The discounted rate is at 10%
REVENUE
Year 1
Year 2
Year 3
Year 4
Year 5
No. of Units to Sell (@ $50/Unit)
3000
5,000
5,000
6,000
6,000
Total
$150,000
$250,000
$250,000
$300,000
$300,000
EXPENSES
Advertising
1,500
1,500
1,500
1,500
1,500
Wages
10,000
10,000
10,000
10,000
10,000
COGS
15,000
15,000
15,000
15,000
15,000
Rent
30,000
30,000
30,000
30,000
30,000
Depreciation
2,000
2,000
2,000
2,000
Total
56,500
58,500
58,500
58,500
58,500
Cash Flow
Profit
$93,500
$191,500
$191,500
$241,500
$241,500
Tax (12%)
11,220
22,980
22,980
28,980
28,980
Net Profit
82,280
168,520
168,520
212,520
212,520
Cash Flow
86,280
172,520
172,520
216,520
216,520
Purchase of Equipment
$20,000
Total Cash Flow = $864,360
Year 1 PV= $86,280/1.10 = $78,436.36
Year 2 PV= $172,520/1.21 =$142,578.51
Year 3 PV= $172,520/1.331 = $129,616.83
Year 4 PV= $216,520/1.4641 =$147,886.07
Year 5 PV= $216,520/1.61051 = $134,441.89
Total PV for five years = $632,959.66
NPV= $632,959.66 - 20,000 =$612,959.66
I need help with what the payback time will be?
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