Different harvester models have different efficiencies

Assignment Help Financial Management

Reference no: EM131317247

A tomato farmer is considering three harvesters. The different harvester models have different efficiencies in picking the tomatoes and rates at which individual tomatoes are damaged. Therefore, the different harvesters are expected to result in different annual cash flows. Three models are available as described in the table below.

Item

Model A

Model B

Model C

Cost

$20,000

$17,500

$27,500

Annual Revenue

$5,000

$4,500

$5,700

Salvage Value

$750

$500

$2,500

Useful Life

The farmer can also rent the Model A harvester, which results in net revenues of $1,000 per year. The analysis period is 15 years, after which the farmer plans to retire. Assuming a MARR of 10%, which model (if any) should the farmer purchase to maximize her profit? Use both the IRR and ERR methods to answer this question. Your calculations must be completed using MS Excel and you must upload your MS Excel.

Reference no: EM131317247

Questions Cloud

Scholarship fund for students at clever college : You wish to establish a scholarship fund for students at Clever College. The fund wouldpay an annual scholarship that would start at $5,000 awarded one year from now andincrease by 3.5% per year forever. If the fund could earn an effective annual ..

Describe the relationship of the binary number s : What modifications are necessary to make the n-bit adder properly add two signed numbers represented in 2's complement binary? Explain.

How much money do you have if you hold the bond to? maturity : Consider an annual coupon bond with a face value of ?100?, 9 years to? maturity, and a price of ?$92. The coupon rate on the bond is 8%. If you can reinvest coupons at a rate of 4.5?% per? annum, then how much money do you have if you hold the bond t..

Required rate of return on a common stock : 1. What is the required rate of return on a common stock that is expected to pay a $0.75 annual dividend next year if dividends are expected to grow at 2% annually and the current stock price is $8.59?

Different harvester models have different efficiencies : A tomato farmer is considering three harvesters. The different harvester models have different efficiencies in picking the tomatoes and rates at which individual tomatoes are damaged. Therefore, the different harvesters are expected to result in diff..

Would you want to work for this company : Would you want to work for this company? Why or why not? How, if at all was your answer affected by the job analysis and compensation information in the case study ?Columbus Custom Carpentry is a family-owned company founded in 1946.

What was the highest goal of the mannerist artists : What was the highest goal of the Mannerist artists? Which one of the following artists was held in high esteem by the popes

What is the required monthly payment : If the mortgage requires monthly payments over a term of 20 years, with each payment made at the end of the period, what is the required monthly payment?

What is the risk-free rate of return : The expected return on HiLo stock is 12.04 percent while the expected return on the market is 10.52 percent. The beta of HiLo is 1.28. What is the risk-free rate of return?

User Account

All Pages