You have been hired as a consultant for Melody Harmonitune Sdn. Bhd. (MHSB), a manufacturer of fine zithers, to evaluate a capital budgeting proposal. MHSB observes that the market for zithers is growing quickly. To confirm their observation, the company hired a marketing firm to analyse the zither market, at a cost of RM125,000. An excerpt of the marketing report is as follows:
The zither industry will have a rapid expansion in the next four years. With the brand name recognition that MHSB brings to bear, we feel that the company will be able to sell 3,200, 4,300, 3,900, and 2,800 units each year for the next four years, respectively. Again, capitalising on the name recognition of MHSB, we feel that a premium price of RM780 can be charged for each zither. Because zithers appear to be a fad, we feel at the end of the four-year period, sales should be discontinued.
MHSB agrees to the suggested price for the first year but intends to raise it by RM20 each year. MHSB also believes that fixed costs for the project will be RM425,000 per year, and variable costs are 15 percent of sales for the first two years. Due to inflation MHSB expects that the variable cost per unit will increase to RM120 and RM123 for the third and fourth year, respectively. The equipment necessary for production will cost RM4.2 million and will be depreciated using the straight-line method down to zero by the end of the project period. However, MHSB estimates that the equipment will have a scrap value of RM250,000 at the end of the fourth year. Net working capital of RM125,000 will be required immediately, and thereafter, the working capital requirements will be at 5 percent of sales. MHSB has a 25 percent tax rate, and the required return on the project is 13 percent.
A. What is the project’s cash flow for each of the next four years?
B. What is the payback period? Based on your answer, would you recommend MHSB to invest in this project?
C. Compute the net present value of the project. Should MHSB proceed with the project? Why or why not?
CFinance - unknown, Monday, April 2, 2012 at 11:12pm
Year 0 1 2 3 4
Units Sold 3,200 4,300 3,900 2,800
Price per unit 780 800 820 840
Total Revenue 2,496,000 3,440,000 3,198,000 2,352,000
Variable cost (15%) 374,400 516,000 468,000 344,400 Variable cost has to be adjusted to make it Rm 120 & 123 for 3rd & 4th year
Fixed Cost 425,000 425,000 425,000 425,000
Depreciation 987,500 987,500 987,500 987,500
Income before tax 709,100 1,511,500 1,317,500 595,100
Tax (38%) 177,275 377,875 329,375 148,775
Net Income 531,825 1,133,625 988,125 446,325
Operating Cash Flow 1,519,325 2,121,125 1,975,625 1,433,825 Net Income + Depreciation
After Tax Salvage 187,500 Since the book value is zero, all amount received will be taxed at 25%
Net Working Capital (125,000) 125,000 Working Capital will be recovered at the end of project
Total Cash Flow (4,200,000) 1,394,325 2,121,125 1,975,625 1,746,325
NPV (13%) 1,135,329
CFinance - unknown, Monday, April 2, 2012 at 11:13pm
the tax should be 25%... plz help is this the correct way.. especially the depriaction part....