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.

And please can you solve it with calculations than on excel. Thank you

Solutions

Expert Solution

Computation of NPV:
A Initial Cash Outflow:
Purchase of Equipment $           120,000
Net Working Capital $             10,000
PV of Cash Outflows $           130,000
B Terminal Cash Inflows:
a Sale of Equipment at end of Project $             10,000
Less: Book Value $                       -  
Capital Gain $             10,000
Less: Tax @ 35% $                3,500
Net Cash Inflow on Sale of Equipment $                6,500
b Net Working Capital $             10,000
c Termianl Cash Inflow (a+b) $             16,500
PVF(14%,8 yr) = 1.14^(-8) 0.3506
PV of Terminal Cash Inflow $                5,784
C Operational Cash flows
a. Forecasted Revenue per Year $             80,000
b. Annual Cash Costs $             25,000
Depreciation per year ($ 120,000/8years) $             15,000
Expenses for the year $             40,000
c. Profit before Taxation (a-b) $             40,000
d. Less: Tax @ 35% per year $             14,000
e. Profit after Taxation (c-d) $             26,000
Add: Depreciation $             15,000
f. Net Operating Cash Inflows $             41,000
g. PVAF(14%, 8 Years) $             4.6389
h. Present Value of Operational Cash Inflows (f*g) $           190,193
D Computation of NPV
a. Present Value of Operational Cashflows $     190,193.42
PV of Terminal Cash Inflow $          5,784.22
Present Value of Cash Inflows $     195,977.64
b. PV of Cash Outflows $           130,000
c. NPV = PV od Cash Inflows - PV of Cash Outflows $       65,977.64

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
Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an...
Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an estimated life of 4 years and no salvage value. The estimated net income and net cash flow from the project are as follows: Year Net Income Net Cash Flow 1 $75,000        $280,000        2 100,000        300,000        3 109,000        200,000        4 36,000        120,000        $320,000        $900,000        The company's minimum desired rate of return is 12%. The present value of $1 at compound interest of 12% for 1,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT