i know its should be done in excel but at lest give me the forlma that i need to put it in excel

11.24 The Norcross Fiber Company is considering automating its piecegoods screen-printing system at a cost of $20,000. The firm expects to phase out the new printing system at the end of five years due to changes in style. At that time, the firm could scrap the system for $2,000 in today's dollars. The expected net savings due to automation also are in today's dollars (constant dollars): The system qualifies as a five-year MACRS property and will be depreciated accordingly. The expected average general inflation rate over the next five years is approximately 5% per year. The firm will finance the entire project by borrowing at 10%. The scheduled repayment of the loan will be: The firm's market interest rate for project evaluation during this inflationridden time is 20%. Assume that the net savings and the selling price will be responsive to this average inflation rate. The firm's marginal tax rate is known to be 40%. a. Determine the after-tax cash flows of this project in actual dollars. b. Determine the net present-value reduction (or gains) in profitability due to inflation. 11.24 The Norcross Fiber Company is considering automating its piecegoods screen-printing system at a cost of $20,000. The firm expects to phase out the new printing system at the end of five years due to changes in style. At that time, the firm could scrap the system for $2,000 in today's dollars. The expected net savings due to automation also are in today's dollars (constant dollars): The system qualifies as a five-year MACRS property and will be depreciated accordingly. The expected average general inflation rate over the next five years is approximately 5% per year. The firm will finance the entire project by borrowing at 10%. The scheduled repayment of the loan will be: The firm's market interest rate for project evaluation during this inflationridden time is 20%. Assume that the net savings and the selling price will be responsive to this average inflation rate. The firm's marginal tax rate is known to be 40%. a. Determine the after-tax cash flows of this project in actual dollars. b. Determine the net present-value reduction (or gains) in profitability due to inflation