In: Finance
McGilla Golf has decided to sell a new line of golf clubs. The clubs will sell for $838 per set and have a variable cost of $395 per set. The company has spent $11137 for a marketing study that determined the company will sell 5536 sets per year for seven years. The marketing study also determined that the company will lose sales of 975 sets of its high-priced clubs. The high-priced clubs sell at $1137 and have variable costs of $670. The company will also increase sales of its cheap clubs by 1154 sets. The cheap clubs sell for $462 and have variable costs of $222 per set. The fixed costs each year will be $893859. The company has also spent $103550 on research and development for the new clubs. The plant and equipment required will cost $2868265 and will be depreciated on a straight-line basis. The new clubs will also require an increase in net working capital of $133228 that will be returned at the end of the project. The tax rate is 33 percent, and the cost of capital is 12 percent. What is the annual OCF for this project?
Statement showing Annaul OCF
Particulars | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
SPPU | 838.00 | 838.00 | 838.00 | 838.00 | 838.00 | 838.00 | 838.00 |
VCPU | 395.00 | 395.00 | 395.00 | 395.00 | 395.00 | 395.00 | 395.00 |
CPU | 443.00 | 443.00 | 443.00 | 443.00 | 443.00 | 443.00 | 443.00 |
units | 5536.00 | 5536.00 | 5536.00 | 5536.00 | 5536.00 | 5536.00 | 5536.00 |
Contribution | 2452448.00 | 2452448.00 | 2452448.00 | 2452448.00 | 2452448.00 | 2452448.00 | 2452448.00 |
Contribution loss of high priced club(975*(1137-670)) | -455325.00 | -455325.00 | -455325.00 | -455325.00 | -455325.00 | -455325.00 | -455325.00 |
Contributipn gain from cheap club ( 1154*(462-222)) | 276960.00 | 276960.00 | 276960.00 | 276960.00 | 276960.00 | 276960.00 | 276960.00 |
Fixed cost | -893859.00 | -893859.00 | -893859.00 | -893859.00 | -893859.00 | -893859.00 | -893859.00 |
Depreciation | -409752.14 | -409752.14 | -409752.14 | -409752.14 | -409752.14 | -409752.14 | -409752.14 |
PBT | 970471.86 | 970471.86 | 970471.86 | 970471.86 | 970471.86 | 970471.86 | 970471.86 |
Tax @ 33% | 320255.71 | 320255.71 | 320255.71 | 320255.71 | 320255.71 | 320255.71 | 320255.71 |
PAT | 650216.14 | 650216.14 | 650216.14 | 650216.14 | 650216.14 | 650216.14 | 650216.14 |
Add: Depreciation | 409752.14 | 409752.14 | 409752.14 | 409752.14 | 409752.14 | 409752.14 | 409752.14 |
Annual OCF | 1059968.29 | 1059968.29 | 1059968.29 | 1059968.29 | 1059968.29 | 1059968.29 | 1059968.29 |