Cash flow table showing all time increments and cash flows

Assignment Help Business Economics

Reference no: EM13839422

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: EM13839422

Questions Cloud

Calculate the share of total income received by quintile : A group of 10 people have the following annual incomes: $55,000, $30,000, $15,000, $20,000, $35,000, $80,000, $40,000, $45,000, $30,000, $50,000. Calculate the share of total income received by each quintile of this income distribution.

The store financed the refrigerator by charging : A refrigerator sold for $500. The store financed the refrigerator by charging 0.5% monthly interest on the unpaid balance. If the refrigerator is paid for with 30 equal end-of-month payments:

Considering the full price of each of the two products : Assume that Bob is only purchasing two products G and W. The market price of G is $25 and of W is $20. By spending all of his budgeted amount on these two items, he is maximizing utility and receiving 100 utilities from the last unit of G and 80 util..

Raise the gasoline tax as 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?

Cash flow table showing all time increments and cash flows : 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%. In EXCEL create a Cash Fl..

Nobody is truly charitable-they just give money to show off : 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..

Markets capable of fixing themselves : Do you think governments should step in and help an economy move to potential or are "markets" capable of fixing themselves? Carefully consider the impact of falling prices.

Two important policy goals of the government and the fed : Two important policy goals of the government and the Fed are to keep unemployment and inflation low, while at the same time making sure that GDP is increasing at an average of 3% per year. It is important to have the right mix of policies and that al..

What would be subsequent steps-fiscal and monetary policy : Assume that the country is in a period of high unemployment, interest rates are at almost zero, inflation is about 2% per year, and GDP growth is less than 2% per year. Make sure you include both the positive and negative effects of your actions, and..

User Account

All Pages