Given the following time events and incremental cash flow, if the MARR is 12% per year, which alternative should be selected on the basis of rate of return? Assume alternative B requires the extra $7,000 initial investment. (You can use Excel). Year Incremental CFB-CFA 0 -7,000 1 +1,500 2 +1,500 3 +1,500 4 +1,500 5 +5,000

Explanation:

I have attached a screenshot of the spreadsheet I used.

First, input each incremental cashflow in its own cell,

Input the MARR rate as well

To determine if accepting alternative B is worth it or not based on rate of return, use IRR (Internal rate of return) function on excel by typing "=IRR" and select the array of cells containing the cashflows. IRR is 13.84% is positive and it means that alternative B is more profitable since the IRR is greater than the MARR of 12%

one of the appeals of a sole proprietorship is that business expenses are kept separate from your personal income tax return

consumer credit. an advantage is that it allows consumers to afford expensive goods and services now, increasing their standard of living. however, a disadvantage is that it creates a trap for debt, if people do not have self control, they may see themselves filing personal bankruptcy.