An asset has been purchased for the $500,000 and sold at the end of $50,000 at the end of its useful life. The asset is expected to generate S250,000 more in terms of revenue annually and the operating expenses increase by $100,000 each year. Assuming an effective federal tax rate of 25%, and state tax rate of 5%, calculate the rate of return over its useful life. Please use excel, is the project worth undertaking provided that MARR is 12% per year compounded monthly? Five projects are under consideration the cash flows are as follows Year A B C D E 0 -12000 -11000 -20000 -17000 -4000 1 5000 6000 4000 4000 100 2 3000 2000 7000 3000 3500 3 8000 -800 9000 6000 6000 4 15000 10000 8000 7000 5 8000 Assuming that the projects are independent, project is only taken once, and MARRR is 12%, How many bundles that we have? Assuming that initial budget $40,000 please choose the best set of the projects that should be undertaken, additional consideration is that Projects A, B, and C cannot be taken simultaneously