Question

In: Finance

A tract of farm land requires an initial outlay $50,000. The first-year net cash flow is...

A tract of farm land requires an initial outlay $50,000. The first-year net cash flow is $4,000 and will increase 4% annually. The land value will grow 2% annually. A farmer’s real cost of capital is 6% and the anticipated inflation rate is 3%. The farmer pays 20% tax on ordinary income and 15% tax on capital gain. The farmer is considering making the investment on the tract of farm land and holding it for 6 years. Please help the farmer evaluate the profitability of the investment.

Solutions

Expert Solution

Farmer's nominal cost of capital = 6% + 3% = 9%

We first chalk out the Net-cashflows in excel

Year Cash-flows Cash-flow due to tax Net cash-flows
0 -50000 0 -50000
1 4000 -800 3200
2 4160 -832 3328
3 4326.4 -865.28 3461.12
4 4499.456 -899.8912 3599.5648
5 4679.43424 -935.886848 3743.547392
6 4866.61161 -973.3223219 3893.289288
6 56308.12096 -8446.218144 47861.90282

We calculate the NPV with nominal cost of capital 9% using NPV function in excel

NPV = Initial investment + NPV (9%, All net cash-flows from year 1-6)

Year Net cash-flows
0 -50000
1 3200
2 3328
3 3461.12
4 3599.5648
5 3743.547392
6 51755.19211
NPV -5747.488031

Since the NPV of the investment is negative, the investment is not profitable.


Related Solutions

A project needs an initial outlay of $3000 for equipment and will net a cash flow...
A project needs an initial outlay of $3000 for equipment and will net a cash flow of $250 for the next 15 years. At the end of the 15th year, there is a Salvage Value of $1000 for the equipment. What is the NPV of the project if the cost of capital is 15% p.a. effective (to the nearest dollar)? Select one: a. -$945 b. -$1415 c. $2250 d. $1585
A project needs an initial outlay of $3000 for equipment and will net a cash flow...
A project needs an initial outlay of $3000 for equipment and will net a cash flow of $300 for the next 12 years. At the end of the 12th year, there is a Salvage Value of $1000 for the equipment. What is the NPV of the project if the cost of capital is 12% p.a. effective (to the nearest dollar)?
6. A project requires initial capital outlay of GH₡300,000. The project will provide annual cash flow...
6. A project requires initial capital outlay of GH₡300,000. The project will provide annual cash flow of GH₡80,000 for 5 years. what is the payback period? * Your answer
A proposed project requires an initial cash outlay of $250,919 for equipment and an additional cash...
A proposed project requires an initial cash outlay of $250,919 for equipment and an additional cash outlay of $30,951 in year 1 to cover operating costs. During years 2 through 4, the project will generate cash inflows of $500,000 a year. What is the net present value of this project at a discount rate of 4 percent? Round your answer to the nearest whole dollar.
initial cash outlay is $50,000. the required rate of return is 9%. the length of time...
initial cash outlay is $50,000. the required rate of return is 9%. the length of time of the project is 6 years. each year the project is expected to provide $12,500 of free cash flow. calculate the IRR
Initial cash outlay is $50,000. The required rate of return is 9%. The length of time...
Initial cash outlay is $50,000. The required rate of return is 9%. The length of time of the project is 6 years. Each year the project is expected to provide $12,500 of free cash flow. 1a. Calculate NPV 1b. Calculate the (estimated) IRR Hint: start with (I.C.O. / F.C.F) The existing 10 year, 6% bonds are trading in the market at $900. The corporate tax rate is 32% Estimated YTM formula: YTM=Coupon+par value-market valueyearsmarket value+par value2 After-tax interest rate =...
QUESTION 14 The following table presents the initial cash outlay and cash flow projections for a...
QUESTION 14 The following table presents the initial cash outlay and cash flow projections for a new line of digital cameras that DigiCam is evaluating: Year Cash inflow / outflow Amount of cash flow 0 Initial cash outlay for buying plant and equipment (at the beginning of Year 1) $2,350,000 1 Net operating pretax cash inflows $1,000,000 2 Net operating pretax cash inflows $1,200,000 3 Net operating pretax cash inflows $1,300,000 3 Salvage value (at the end of Year 3)...
An investment requires an outlay of $20,000 and has an expected cash flow of $23,700 one...
An investment requires an outlay of $20,000 and has an expected cash flow of $23,700 one year later. What is the internal rate of return of the investment?
An investment requires an outlay of $20,000 and has an expected cash flow of $23,700 one...
An investment requires an outlay of $20,000 and has an expected cash flow of $23,700 one year later. What is the internal rate of return of the investment?
An investment project requires an initial outlay of $100,000, and is expected to generate annual cash...
An investment project requires an initial outlay of $100,000, and is expected to generate annual cash inflows of $28,000 for the next 5 years. The cost of capital is 12 percent. Determine the internal rate of return for the project (to the nearest tenth of one percent). a. 12.0% b. 12.6% c. 3.6% d. 12.4%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT