Which plan provides the best use of the farmers capital

Reference no: EM13698226

A farmer just purchased a tractor for which he had to borrow $20,000. The bank, using an 8% interest rate, offered a choice of three payment plans as shown below. The farmer’s Minimum Attractive Rate of Return (MARR) is 15%.

Plan A: $510 per year for 5 years

Plan B: $2,956 per year for 4 years, plus $15,000 at the end of 5 Years

Plan C: Nothing for 2 years, then $9048 per year for 3 years

a) In EXCEL create a Cash Flow Table showing all time increments and all cash flows.

b) Which Plan provides the best use of the farmer’s capital?

Reference no: EM13698226

Questions Cloud

Raise the gasoline tax as a way of reducing air pollution : Suppose the government decides to raise the gasoline tax as a way of reducing air pollution and traffic congestion to their optimal levels. Which of the following describes why Pigovian taxes, such as gasoline tax, are unlike most other taxes?

Stock dividend applicable to the outstanding shares : On March 15, My Corp. BOD declared a 2 percent stock dividend applicable to the outstanding shares of its $10 par value common stock, of which 400,000 shares are authorized, 260,000 are issued, and 40,000 are held in the treasury

Any one time the following will be held : A company plans to sell 12000 units in month 1 and 13000 units in month 2. Sales will increase by 1000 units each month after that. Production will be scheduled so that at any one time the following will be held

John is a young accountant at a local cpa firm : John is a young accountant at a local CPA firm. He is wresling with a problem: tyring to decide whether to cover up a mistake made in not attaching an irrevocable election to a key client's recently sumitted tax return.

Which plan provides the best use of the farmers capital : A farmer just purchased a tractor for which he had to borrow $20,000. The bank, using an 8% interest rate, offered a choice of three payment plans as shown below. The farmer’s Minimum Attractive Rate of Return (MARR) is 15%.

Herman corporation common stock purchased : Herman Corporation common stock purchased by Fred, Inc. 60%

Theory of economic behavior on the actual mental processes : Suppose that Joe enjoys and repeatedly does stupid things like getting heavily into debt and insulting police officers. Do these actions constitute systematic errors? If he gets what he wants each time, are his stupid actions even considered to be er..

Business operates under competitive conditions : Suppose that Taher's pizza business operates under competitive conditions and that his short-run production function is q=20^E. How much labor does he employ if the price of each pizza is p = $12 and the hourly wage is w0 = $6? [Hint: In this case, i..

What single sum of money : What single sum of money at t = 4 is equivalent to receiving $5,000 at t = 1, $5,800 at t = 2, $7,300 at t = 3, and $8,200 at t = 4 if money is compounded at a rate of 11.5% per time period?

User Account

All Pages