Question

In: Finance

With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...

With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 11,700 in the first year, with growth of 7 percent each year for the next five years. Production of these lamps will require $79,000 in net working capital to start. Total fixed costs are $176,000 per year, variable production costs are $18 per unit, and the units are priced at $64 each. The equipment needed to begin production will cost $660,000. The equipment will be depreciated using the straight-line method over a 5-year life and is not expected to have a salvage value. The tax rate is 22 percent and the required rate of return is 16 percent. What is the NPV of this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

NPV=

Solutions

Expert Solution

Calculation of NPV of the Project
Particulars 0 1 2 3 4 5
Initial Investment
Cost of Equipment -660000
Investment in net working capital -79000
Net Investment (A) -739000
Operating Cash Flows
Sales Units (B) 11700 12519 13395.33 14333.0031 15336.31332
Annual Sales (C = B*$64) 748800 801216 857301.12 917312.1984 981524.0523
Variable Costs (D = B*$18) 210600 225342 241115.94 257994.0558 276053.6397
Fixed Costs (E ) 176000 176000 176000 176000 176000
Depreciation (F)
$660,000 / 5 years
132000 132000 132000 132000 132000
Profit Before Tax (G = C-D-E-F) 230200 267874 308185.18 351318.1426 397470.4126
Tax @22% (H = G*22%) 50644 58932.28 67800.7396 77289.99137 87443.49077
Profit After Tax (I = G-H) 179556 208941.72 240384.4404 274028.1512 310026.9218
Add back Depreciation (J = F) 132000 132000 132000 132000 132000
Net Operating Cash Flows (K = I+J) 311556 340941.72 372384.4404 406028.1512 442026.9218
Terminal Value
Recovery of Working Capital (L) 79000
Total Cash Flows (M = A+K+L) -739000 311556 340941.72 372384.4404 406028.1512 521026.9218
Discount Factor@16% (N)
1/(1+16%)^n n=0,1,2,3,4,5
1 0.862068966 0.743162901 0.640657674 0.552291098 0.476113015
Discounted Cash Flows (O = M*N) -739000 268582.7586 253375.2378 238570.9492 224245.7334 248067.6989
NPV of the Project 493842.378
Therefore, NPV of this project is $493,842.38

Related Solutions

With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 8,100 in the first year, with growth of 5 percent each year for the next five years. Production of these lamps will require $46,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 7,000 in the first year, with growth of 8 percent each year for the next five years. Production of these lamps will require GH¢35,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 8,000 in the first year, with growth of 8 percent each year for the next five years. Production of these lamps will require $45,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 7,600 in the first year, with growth of 5 percent each year for the next five years. Production of these lamps will require $41,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 10,200 in the first year, with growth of 7 percent each year for the next five years. Production of these lamps will require $49,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 10,800 in the first year, with growth of 7 percent each year for the next five years. Production of these lamps will require $61,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 10,700 in the first year, with growth of 6 percent each year for the next five years. Production of these lamps will require $59,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 10,800 in the first year, with growth of 7 percent each year for the next five years. Production of these lamps will require $61,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 8,000 in the first year, with growth of 8 percent each year for the next five years. Production of these lamps will require $45,000 in...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden...
With the growing popularity of casual surf print clothing, two recent MBA graduates decided to broaden this casual surf concept to encompass a “surf lifestyle for the home.” With limited capital, they decided to focus on surf print table and floor lamps to accent people’s homes. They projected unit sales of these lamps to be 8,500 in the first year, with growth of 7 percent each year for the next five years. Production of these lamps will require $50,000 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT