In: Finance
TechSquare. LLC. is considering a 5-year new project. The project will require $325,000 for fixed assets and $95,000 of working capital. The fixed assets will be depreciated straight-line to a zero-book value over 5 year. At the end of the project, the fixed assets can be sold for 25% of their original cost. The project is expected to generate annual sales of $554,000 with costs of $430,000. The tax rate is 21% and the required rate of return is 15%. What are the NPV and PI of this project?
here i am sharing the formulaes and excel working
EXCEl Formulaes:
thanks
rate the answer please