Question

In: Finance

The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent...

The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent cost of capital, is considering a new project. This project involves the introduction of a new product. This project is expected to last 4 years and then to be terminated. Cost of new plant and equipment is $990,000. Shipping and installation costs are $10,000. The company needs to increase its working capital requirement. There will be an initial inventory requirement of $15,000 just to start the production. Out of this amount, the company can owe money in the form of account payable. The payable will increase by $3,000. All the investment in working capital is paid at the termination of the project at year 4. The company expects to sell 27,000 units per year in four years. Sales price per unit is $25 per year. Total variable cost of productions is $10 per unit.    At the end of 4th year, the equipment should have a market value, which equals to salvage value because book value of the equipment is zero, of $50,000. The assets would be depreciated under MACRS with 3- year life. Year 1 depreciation rate is 33%, year 2 is 45%, year 3 is 15%, and year 4 is 7%.

Questions:

a. Given the information, fill in the excel work sheet to estimate the net cash flows of the project.

b. Determine the NPV, IRR, and payback period of the project.

c. What is your recommendation about the project?

Solutions

Expert Solution

Total cost of equipment = purchase cost + installation cost

Net investment in working capital = investment in inventory - accounts payable

Operating cash flow (OCF) each year = income after tax + depreciation

profit on sale of equipment at end of year 4 = sale price - book value

book value is zero as the equipment is fully depreciated.

after-tax salvage value = salvage value - tax on profit on sale of equipment

NPV and IRR are calculated using NPV and IRR functions in Excel

Payback period is the time taken for the cumulative cash flows to equal zero

Payback period = 2 + (cash flow required in year 3 for cumulative cash flows to equal zero / year 3 cash flow) = 2 + ($214,000 / $303,000) = 2.71 years

NPV is $143,776

IRR is 15.62%

It is recommended to accept the project as the NPV is positive and the IRR is higher than the cost of capital


Related Solutions

The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent...
The Dolphin Corporation, a firm in the 40 percent marginal tax bracket with a 9 percent cost of capital, is considering a new project. This project involves the introduction of a new product. This project is expected to last 4 years and then to be terminated. Cost of new plant and equipment is $990,000. Shipping and installation costs are $10,000. The company needs to increase its working capital requirement. There will be an initial inventory requirement of $15,000 just to...
The approximate after tax cost of debt to a firm in the 40% tax bracket for...
The approximate after tax cost of debt to a firm in the 40% tax bracket for a 20 year, 12% coupon, $1000 par value bond selling for $950 is: 9.49% 9.00% 7.20% 3.60% 5.69%
Terrier Company is in a 40 percent tax bracket and has a bondoutstanding that yields...
Terrier Company is in a 40 percent tax bracket and has a bond outstanding that yields 10 percent to maturity.a. What is Terrier’s aftertax cost of debt?(Do not round intermediate calculations. Input your answer as a percent rounded to 2 decimal places.)  b. Assume that the yield on the bond goes down by 1 percentage point, and due to tax reform, the corporate tax rate falls to 25 percent. What is Terrier’s new aftertax cost of debt? (Do not round intermediate...
Charlie, who is in the 37 percent marginal tax bracket, is the president and sole owner...
Charlie, who is in the 37 percent marginal tax bracket, is the president and sole owner of Charlie Corporation (a C corporation in the 21 percent tax bracket). His current salary is $700,000 per year. Whar are the income and FICA tax consequences if the IRS determines that $200,000 of his salary is unreasonable compensation?
Casey is in the 12% marginal tax bracket, and Jean is in the 35% marginal tax...
Casey is in the 12% marginal tax bracket, and Jean is in the 35% marginal tax bracket. Their employer is experiencing financial difficulties and cannot continue to pay for the company's health insurance plan. The annual premiums are approximately $8,000 per employee. The employer has proposed to either (1) require the employee to pay the premiums or (2) reduce each employee's pay by $10,000 per year with the employer paying the premium. Which option is less objectionable to Casey, and...
Please use excel: (Comprehensive problem) The Shome Corporation, a firm in the 34 percent marginal tax...
Please use excel: (Comprehensive problem) The Shome Corporation, a firm in the 34 percent marginal tax bracket with a 15 percent required rate of return or cost of capital, is considering a new project. The project involves the introduction of a new product. This project is expected to last 5 years and then, because this is somewhat of a fad ­product, be terminated. Given the following information, determine the free cash flows associated with the project, the project’s net present...
A firm is 65% equity and 35% debt. The firm's marginal tax rate is 40%. Their...
A firm is 65% equity and 35% debt. The firm's marginal tax rate is 40%. Their bonds trade for $990, mature in nine years, have a par value of $1,000, a coupon rate of 8.00% and pay semi-annually. The firm's common stock trades for $27 and just paid a dividend of $5.00. Dividends are expected to grow at 3% forever. The firm's after tax cost of debt is _____%. PLEASE USE FINNACE CALUATLER FOR ANSWER IF NOT USE BASIC CALUATOR...
Paying Taxes (8 pts) The marginal tax bracket in a society is listed below. Marginal Rate...
Paying Taxes (8 pts) The marginal tax bracket in a society is listed below. Marginal Rate Range Individual Range Married 10% $0-$20,000 $0-$30,000 15% $20,00-$50,000 $30,000-$80,000 20% $50,00-$90,000 $80,000-$250,000 25% $90,00-$200,000 $250,000-$500,000 30% $200,000 + $500,000+ Sam has an income of $50,000. Joe, Sam’s spouse, has an income of $75,000. Daphne has an income of $150,000. Fred, Daphne’s spouse, has an income of $30,000. Married individuals have the option to either file as a married couple or as individuals. If...
The marginal tax bracket in a society is listed below. Marginal Rate Range Individual Range Married...
The marginal tax bracket in a society is listed below. Marginal Rate Range Individual Range Married 10% $0-$20,000 $0-$30,000 15% $20,00-$50,000 $30,000-$80,000 20% $50,00-$90,000 $80,000-$250,000 25% $90,00-$200,000 $250,000-$500,000 30% $200,000 + $500,000+ Sam has an income of $50,000. Joe, Sam’s spouse, has an income of $75,000. Daphne has an income of $150,000. Fred, Daphne’s spouse, has an income of $30,000. Married individuals have the option to either file as a married couple or as individuals. If Joe were to file...
If Isabella Rodriguez is single and in the 35 percent tax bracket, calculate the tax associated...
If Isabella Rodriguez is single and in the 35 percent tax bracket, calculate the tax associated with each of the following transactions. (Hint: Use the IRS regulations for capital gains in effect in 2018.) Treat each of the following cases as independent of the others. Tax savings should be preceded by a "-" sign. Round the answers to the nearest cent. She sold stock for $3,930 that she purchased for $3,000 4 months earlier. $ _____ She sold bonds for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT