Please help, spreadsheet is fine but please show the formulas

The information shown below is for a marginally successful project. Use hand computations as requested by the instructor to do the following:

a. Determine the CFBT and CFAT Series. The effective tax rate is 32%.

b. Obtain before-tax and after-tax i* (interest rate over the specified period of time) values to evaluate the effect of depreciation and taxes. (Assume that tax savings are used to offset taxes in other parts of the corporation.)

c. Determine the project's economic success if the after-tax MARR is 5%.

Year Gross Income $ Operating Expense First Cost & Salvage $

0 -150,000

1 60,000 -55,000

2 75,000 -50,000

3 90,000 -45,000

4 105,000 -40,000 10,000