For amortization of the loan for a company, PMT() and IPMT() functions are used.

For valuation, XNPV and XIRR with DATE and IF functions are used. Based on that IRR and NPV are calculated and eventually based on a criteria, the investment or NOT investment is suggested. Also to find Cumulative Cash Flow, INDIRECT(), CELL(), and COUNT() functions are used to make the project more flexible.