Question

In: Accounting

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 net working capital to start. Total fixed costs are GH¢ 95,000 per year, variable production costs are GH¢ 20 per unit, and the units are priced at GH¢48 each. The equipment needed to begin production will cost GH¢175,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 34 percent, and the required rate of return is 25 percent. Evaluate the project using NPV.

Solutions

Expert Solution

The first step would be to compute units sold at growth rate of 8% after the year 2 to Year 5.

Depreciation is computed using straight line method.

Depreciation = 175000/5 = 35000

Operating cash flows is sum of net income and depreciation

Year 0

Year 1

Year 2

Year 3

Year 4

Year 5

Quantity sold with growth at 8%

0

7000

7560

8164.8

8817.984

9523.423

Revenue per unit

48

48

48

48

48

Revenue

336000

362880

391910.4

423263.2

457124.3

Fixed costs

95000

95000

95000

95000

95000

variable costs at 20

140000

151200

163296

176359.7

190468.5

Depreciation (175000/5)

35000

35000

35000

35000

35000

Earnings before tax

66000

81680

98614.4

116903.6

136655.8

Taxes at 34%

22440

27771.2

33528.9

39747.21

46462.98

Net income

43560

53908.8

65085.5

77156.34

90192.85

Operating cash flow =
net income + deprn

78560

88908.8

100085.5

112156.3

125192.9

Initial capital spent

-175,000

Net working capital

-35000

35000

Total cash flows

-210000

78560

88908.8

100085.5

112156.3

160192.9

Present value factor at 25%

1.00000

0.80000

0.64000

0.51200

0.40960

0.32768

Present value

-210000

62848

56901.63

51243.78

45939.24

52491.99

Present value of cash inflows = 62848 + 56901.63 + 51243.78 + 45939.24 +52491.99 = 269424.6

Cash outflows = 210,000

Net present value = 269424.6 – 210,000 = 59424.6

The project has positive NPV and should be taken


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 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...
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,900 in the first year, with growth of 8 percent each year for the next five years. Production of these lamps will require $63,000 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT