1) The Pukie-Duke Company asked you to determine some of the after-tax cash flows for equipment used for research and development that is being considered. PDC expects the experiment to operate for five years and to require the purchase of $300,000 worth of capital equipment. The capital equipment will have a resale value of $100,000 at the end of the five years. Pukie-Duke has found a company that will make them a $200,000 loan for the equipment at 10% and 4 years and they want to finance the equipment if possible. Pukie-Duke plans to use MACRS depreciation schedule (three year life) for income tax calculations. The income tax rate is 35%, capital gains are taxed at 21%, and Pukie-Duke uses an after tax MARR of 12%. It turns out that due to them being in the green energy program they can get a 10% tax credit for new investment in equipment. But it will require the purchase of an additional two acres of land for $60,000 and the building of an explosion proof room that will cost $220,000 to be constructed but can be sold back to the original landowner for the ending book value of the land and building at the end of the five years. Assume that the building and land are purchased in January of the first year and sold in December of the 5th year. PDC wants to be a good citizen and evaluate this total alternative of equipment, building and land. The new equipment results in an increase in Pukie-Duke's before-tax annual net income of $145,000, find if it is worth investing on this equipment. 2. If Pukie-Duke could not find outside funds for the capital investment and had to put the total $300,000 for the equipment up front under the same conditions as in problem 1 would it be a wise decision and how did you determine that i.e. did it make the MARR? 3. If Pukie-Duke could lease the machine under the same conditions as Problem 1 except the lease payments would be $65,000 for the equipment, would this make the MARR?

PREFERABLY IN EXCEL PLS!!! :)