Question

In: Finance

Consider a capital expenditure project that has forecasted revenues equal to $80,000 per year; cash expenses...

Consider a capital expenditure project that has forecasted revenues equal to $80,000 per year; cash expenses are estimated to be $25,000 per year. The cost of the project equipment is $120,000, and the equipment’s estimated salvage value at the end of the project is $10,000. The equipment’s $120,000 cost will be depreciated on a straight-line basis to $0 over an 8-year estimated economic life. Assume that the project requires an initial $10,000 working capital investment. The company can recover this working capital investment at the end of the project. The company’s marginal tax rate is 35%. Calculate the project’s net present value using a 14% discount rate

Solutions

Expert Solution

Answer:- NPV= $65977.64

Explanation:-

Following is the excel sheet showing the calculation of NPV :-

Following is the Formula sheet of above excel sheet for easy understanding of the calculation :-


Related Solutions

Consider a capital expenditure project that has forecasted revenues equal to $80,000 per year; cash expenses...
Consider a capital expenditure project that has forecasted revenues equal to $80,000 per year; cash expenses are estimated to be $25,000 per year. The cost of the project equipment is $120,000, and the equipment’s estimated salvage value at the end of the project is $10,000. The equipment’s $120,000 cost will be depreciated on a straight-line basis to $0 over an 8-year estimated economic life. Assume that the project requires an initial $10,000 working capital investment. The company can recover this...
A project has a forecasted cash flow of $126 in year 1 and $137 in year...
A project has a forecasted cash flow of $126 in year 1 and $137 in year 2. The interest rate is 5%, the estimated risk premium on the market is 11.5%, and the project has a beta of 0.66. If you use a constant risk-adjusted discount rate, answer the following: a. What is the PV of the project? (Do not round intermediate calculations. Round your answer to 2 decimal places.) b. What is the certainty-equivalent cash flow in year 1...
A project has a forecasted cash flow of $115 in year 1 and $126 in year...
A project has a forecasted cash flow of $115 in year 1 and $126 in year 2. The interest rate is 6%, the estimated risk premium on the market is 11.25%, and the project has a beta of .55. If you use a constant risk-adjusted discount rate, what is: a. The PV of the project? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Present value            $ b. The certainty-equivalent cash flow in year 1 and year...
Consider a capital expenditure project to purchase and install new equipment with an initial cash outlay...
Consider a capital expenditure project to purchase and install new equipment with an initial cash outlay of $25,000. The project is expected to generate net after-tax cash flows each year of $6800 for ten years, and at the end of the project, a one-time after-tax cash flow of $11,000 is expected. The firm has a weighted average cost of capital of 12 percent and requires a 3-year payback on projects of this type. Determine whether this project should be accepted...
Project B costs $52,125. The project’s cash revenues are expected to be $12,000 per year for...
Project B costs $52,125. The project’s cash revenues are expected to be $12,000 per year for 5 years. If the WACC is 12%, what is the project's simple payback period? 0.23 years 2.22 years 4.34 years 5.94 years 10.01 years
AFTER TAX CASH FLOW Initial investment in the asset $80,000 Annual revenues $50,000 Annual expenses $20,000...
AFTER TAX CASH FLOW Initial investment in the asset $80,000 Annual revenues $50,000 Annual expenses $20,000 Duration 6 years. Since the asset was in very good condition, it was sold ate the end of the 6 th year in $35,000 instead of $20,000. Calculate the After Tax Cash Flow and After Tax NPV for this project, using a tax rate of 30%, an after tax MARR of 12% per year
CAPITAL EXPENDITURE DATA FOR PROJECT A Initial Investment Expected Cash Inflows $10,000 Year 1 $1,000 Year...
CAPITAL EXPENDITURE DATA FOR PROJECT A Initial Investment Expected Cash Inflows $10,000 Year 1 $1,000 Year 2 $2,000 Year 3 $2,000 Year 4 $5,000 Year 5 $2,000 a. Calculate payback period for Project A. b. If the cash inflow in Year 4 were $6,000 instead of $5,000, calculate the payback period. c. If an investment yields $1,000 a year from now, then how much is it worth today if the cost of money is 10%, using discounted cash flows (DCF)?...
The Wet Corp. has an investment project that will reduce expenses by $20,000 per year for...
The Wet Corp. has an investment project that will reduce expenses by $20,000 per year for 3 years. The project's cost is $20,000. If the asset is part of the 3-year MACRS category (33.33% first year depreciation) and the company's tax rate is 36%, what is the cash flow from the project in year 1?
The Wet Corp. has an investment project that will reduce expenses by $30,000 per year for...
The Wet Corp. has an investment project that will reduce expenses by $30,000 per year for 3 years. The project's cost is $35,000. If the asset is part of the 3-year MACRS category (33.33% first year depreciation) and the company's tax rate is 33%, what is the cash flow from the project in year 1? (Do not round intermediate calculations. Round your answer to the nearest dollar amount.) $23,950 $23,400 $24,730 $25,410
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments...
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments starting one year after the loan is made over a period of ten years. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan? If you are using the excel please show me the code or equation to do it myself
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT