After tax analysis | Engineering homework help

For each funding option, perform a spreadsheet analysis that shows the total ATCF and its present worth over a 6-year period, the time it will take to realize the full advantage of MACRS depreciation. An after-tax return of 10% is expected. Which funding option is best for Pro-Fence? (Hint: For the spreadsheet, sample column headings are: year, GI − OE, loan interest, loan principal, equity investment, depreciation rate, depreciation, book value, TI, taxes, and ATCF.)