Question

In: Finance

Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...

Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks he can sell it for $50,000 at the end of 4 years. Assume that the Mr. Agirich expects that the inflation rate will be 4% and that operating receipts, operating expenses, and terminal value will increase at the rate of inflation (i.e., operating receipts, operating expenses and terminal value are stated as real dollars, thus, you must convert them to nominal dollars) . The bank has offered to lend Mr. Agirich $60,000. The loan will be fully amortized at a 10% interest rate over six years (annual payments). Mr. Agirich anticipates that his marginal tax rate over the next four years will be 20%. The IRS will allow Aggie Farms to depreciate the investment using straight‑line over 10 years. Mr. Agirich requires at least a 13% pre-tax, risk-free return on capital and a 2% risk premium on projects of comparable risk to the irrigation system.

A. Lay out the cash flows for the investment.

B. Calculate the net present value. [NPV=-$1,323.25]

C. Discuss whether or not the irrigation system is a profitable investment.

D. Evaluate the financial feasibility of this investment. Would there be a potential liquidity problem if the investment was profitable? Explain.

Solutions

Expert Solution

Incremental receipt in year 1 = 15,000 x (1 + 4%) = $ 15,600 (grows at the rate of 4% annually)

Incremental expenses in year 1 = 4,000 x (1 + 4%) = $ 4,160 (grows at the rate of 4% annually)

Salvage value in year 4 = 50,000 x (1 + 4%)4 = $  58,493

Discount rate = post tax discount rate = Pre tax discount rate x (1 - tax rate) = (13% + 2%) x (1 - 20%) = 12%

Part (A) and (B) Have been answered in the table below:

The rows highlighted in yellow contain answers to part (A) & (B). Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output.

Part (C)

Annual mortgage payment = PMT(Rate, Period, PV, FV) = PMT (10%, 6, -60000,0) =  13,776.44

Interest portion from the mortgage can be calculated using the IPMT function in excel.

Please see the table below:

Year, n Linkage 0 1 2 3 4
Annual Mortgage payment A     13,776.44 13,776.44     13,776.44 13,776.44
Interest portion B = IPMT(10%,n,6,-60000,0)       6,000.00     5,222.36       4,366.95     3,426.00
Principal repayment portion C = A - B       7,776.44     8,554.09       9,409.50 10,350.45
EBIT D (Calculated above)       4,440.00     4,897.60       5,373.50     5,868.44
[-] Interest B (above)       6,000.00     5,222.36       4,366.95     3,426.00
EBT E = D - B     (1,560.00)       (324.76)       1,006.56     2,442.45
[-] Taxes F = E x 20%        (312.00)         (64.95)          201.31        488.49
Net income G = E - F     (1,248.00)       (259.80)          805.25     1,953.96
OCF H = G + Depreciation of 7000       5,752.00     6,740.20       7,805.25     8,953.96
[-] Principal repayment C (above)       7,776.44     8,554.09       9,409.50 10,350.45
Cash flow for the year I = H - C     (2,024.44) (1,813.89)     (1,604.25) (1,396.49)

Please see the row titled "Net Income". On a pure accrual basis,  the project is not profitable in year 1 & 2 but it is profitable over its entire lifespan. If we add net income over the entire life of the project, it's positive =  (1,248.00) + (259.80) + 805.25 + 1,953.96 = $ 1,251.40

Part D.

The project has negative NPV, hence it's not financially feasible.

Look at the row titled "Cash flow for the year". We are seeing negative cash flows year after year. So, there is indeed liquidity issue as well. So, there will be a potential liquidity problem in the project, specially in servicing the mortgage.


Related Solutions

Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to...
Mr. Agirich of Aggie Farms is thinking about investing in a center pivot irrigation system to irrigate 100 acres of land. The irrigation system costs $70,000. Mr. Agirich expects that the irrigation system will increase yield and thus operating receipts by $15,000 per year but it will cost $4,000 a year to pay for electricity, maintenance, and additional labor. Mr. Agirich plans on keeping the irrigation system for 4 years before replacing it with a new one and he thinks...
Mr. Agirich of Aggie Farms is thinking about investing in a new Double LL four-row potato...
Mr. Agirich of Aggie Farms is thinking about investing in a new Double LL four-row potato harvester. He is currently operating two two-row harvesters and the new harvester would replace both of the current potato harvesters. Mr. Agirich expects that he will save $29,000 a year by eliminating one tractor and one operator.   He also expects the new harvester to not bruise the potatoes as much as the old harvesters. The potato processor has agreed to pay a $0.11/sack premium...
A farmer is thinking about investing in a center pivot irrigation system to irrigate 80 acres...
A farmer is thinking about investing in a center pivot irrigation system to irrigate 80 acres of land in Fresno. The current operating expenses are $80 per acre. It is estimated that the irrigation will increase yields and thus operating receipts by $100 per acre. The cost for drilling a well would be $10,000 and the cost for the center pivot irrigation system would be $22,000. The irrigation system would be ¼ mile long and would irrigate 80 acres. Suppose...
A farmer is thinking about investing in a center pivot irrigation system to irrigate 80 acres...
A farmer is thinking about investing in a center pivot irrigation system to irrigate 80 acres of land in Fresno. With an irrigation system, operating expenses would increase by $75 per acre due to electricity, maintenance and additional labor. It is estimated that the irrigation will increase yields and this operating receipts by $150 per acre. The cost of drilling a well would be $8,200 and the cost for the center pivot irrigation system would be $31,000. The irrigation system...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land that is adjacent the ranch he now owns. Mr. Agirich can operate the additional 100 acres with present labor, machinery and breeding livestock. The land is selling for $400 per acre.   Mr. Agirich believes that the operating receipts per acre of land per year will $450 and operating expenses will be $420 in present dollars. Mr. Agirich expects that the inflation rate will be...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land...
Mr. Agirich of Aggie Farms is considering the purchase of 100 acres of prime ranch land that is adjacent the ranch he now owns. Mr. Agirich can operate the additional 100 acres with present labor, machinery and breeding livestock. The land is selling for $400 per acre.   Mr. Agirich believes that the operating receipts per acre of land per year will $450 and operating expenses will be $420 in present dollars. Mr. Agirich expects that the inflation rate will be...
Mr. Jones of Montana Farms is thinking about investing in a new J-Wing four-row Beet harvester....
Mr. Jones of Montana Farms is thinking about investing in a new J-Wing four-row Beet harvester. He is currently operating two two-row harvesters and the new harvester would replace both of the current potato harvesters. Mr. Jones expects that he will save $29,000 a year by eliminating one tractor and one operator.   He also expects the new harvester to not bruise the beets as much as the old harvesters. The beet processor has agreed to pay a $0.11/sack premium for...
Organic Farms is considering an investment in a new irrigation system that will cost $65,000 and...
Organic Farms is considering an investment in a new irrigation system that will cost $65,000 and last for four years. The firm's cost of capital, appropriate for this project, is 8.00% per year. The incremental free cash flows for the irrigation project are as follows: Year Free Cash Flows 0 -$65,000 1 20,300 2 20,300 3 20,300 4 20,300 Compute the NPV for the project. Identify the correct formula used to solve the previous problem. Compute the IRR for the...
Your friend, Martinez, and you are thinking about investing in a company and are discussing the...
Your friend, Martinez, and you are thinking about investing in a company and are discussing the company’s balance sheet.  You are both very knowledgeable about the different formats of the balance sheet. You are convinced that the best format is the Unclassified Balance Sheet, but Martinez strongly believes that it is the Classified Balance Sheet. Given what you have read and our discussions in class of Chapter 5 and your prior accounting classes knowledge, give a well-reasoned and detailed argument of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT