Hello, Could you please provide me with the FORMULAS used to solve problem 20.5 (chapter 20/Accounting Information Systems). The solution you have is the correct solution, but I need the formulas used.

The Question: Rossco is considering the purchase of a new computer with the following estimated costs: initial system design:$54,000, hardware:$74,000,software:$35,000,one-time initial training:$11,000, system installation:$20,000 and file conversion:$12,000. A net reduction of 3 employees is expected with average yearly salary of $40,000.The system will decrease average yearly inventory by $150,000. Annual operating costs will be $30,000.

The expected life of the machine is 4 years, with estimated salvage value of Zero. The effective Tax Rate is 40%. All computer purchase costs will e depreciated over its 4 years life. Rossco can invest money made available from the reduction in inventory at its cost of capital of 11%. All cash flows, except for the initial investment and start-up costs,are at the end of the year. Assume 365 days in a year.

Required: Use a spreadsheet to perform feasibility analysis. compute the following as part of the analysis: Initial Investment - after-Tax cash flows for years 1-4 , payback period - Net Present Value - Internal Rate of Return.

_______________________________________________

Note: please Clearly Write the Formulas to be entered into Excel ( NP - NPV - IRR .... etc)