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 9,000 in the first year, with growth of 7 percent each year for the following four years (Years 2 through 5). Production of these lamps will require $55,000 in networking capital to start. Total fixed costs are $115,000 per year, variable production costs are $24 per unit, and the units are priced at $52 each. The equipment needed to begin production will cost $195,000. The equipment will be depreciated using the straight-line method over a five-year life and is not expected to have a salvage value. The effective tax rate is 40 percent, and the required rate of return is 25 percent. What is the NPV of this project?

Solutions

Expert Solution

Solution:
Calculation of Quantity sold each year for 5 years:
Year Quantity Sold Working
1 9000
2 9630 (9000*1.07)
3 10304 (9630*1.07)
4 11025 (10304*1.07)
5 11797 (11025*1.07)
Each Year Quantity would increase by 7% from prevous year.
Given:
Net working Capital Required $55000 at Start
Total Fixed Costs $115000 per year
Variable costs $24 Per unit
Selling Price per unit $52 Per unit
Equipment $195000
Depreciation method SLM Method with no Salvage
Therefor Depreciation Amount $195000/5 =$39000
Tax rate 40%
Required rate of return 25%
Profoma Income statement for each Year:
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
Revenue 468000 500760 535808 573300 613444
(No of Units Sold * S.P.Per unit) (9000*52) (9630*52) (10304*52) (11025*52) (11797*52)
Less: Fixed Costs (Given) -115000 -115000 -115000 -115000 -115000
Less: Variable Costs -216000 -231120 -247296 -264600 -283128
(9000*24) (9630*24) (10304*24) (11025*24) (11797*24)
Less:Depreciation -39000 -39000 -39000 -39000 -39000
Net Profit Before Tax 98000 115640 134512 154700 176316
Less: Income Tax @ 40% -39200 -46256 -53804.8 -61880 -70526.4
(Net Profit before tax * Tax rate)
Net Profit After Tax 58800 69384 80707.2 92820 105789.6
Add:Depreciation 39000 39000 39000 39000 39000
Operating Cash Flow 97800 108384 119707.2 131820 144789.6
Add: Recovery of Working Capital 0 0 0 0 55000
Total Cash Flow 97800 108384 119707.2 131820 199789.6
Cash Outflow:
Equipment Purchase -195000
Net working Capital -55000
Cash Outflow -250000
NPV = PV of Inflow- PV of Outflow
$328356.38-$250000
78356.38
PV of Inflow
Year Cash Flow Discounting Factor @ 25% Working Discounted Cash Flow
a b c = a*b
1 $ 97800 0.8 (1/1.25^1) 78240
2 $ 108384 0.64 (1/1.25^2) 69365.76
3 $ 119707.2 0.512 (1/1.25^3) 61290.0864
4 $ 131820 0.4096 (1/1.25^4) 53993.472
5 $ 199789.6 0.32768 (1/1.25^5) 65467.0561
$ 328356.375
NPV of this project = $78356.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