Please show how to do in excel As a financial analyst for LBD, you've been asked to determine which of two mutually exclusive projects the company should undertake. R = 15%. A new brown dress (LBD) production line would cost $350,000 and generate cash flows of $59,000, $79,000, $79,000, and $454,000. On the other hand, a new red dress (LRD) production line costs less and has lower cash flows. Its initial cost is $60,000 while its cash flows are $34,700, $32,700, $ 30,200, and $25,300. The NPV of LBD is $

The net present value of LRD is $____

Again, when rounding to two decimals and using commas.

Using the same data, the payback for LBD is_____

years. Rounding to two decimals.

Let's do the internal rate of return. For LBD, it is

______%. Rounding to two decimals. While for LRD, it is

______%. Rounding to two decimals. Lastly, we should calculate the profitability index for LRD. It is

. Use 2 decimals. Remember the profitability index is merely a ratio, not a percent or dollar amount. Having does all of this financial analysis, which project should you select to pursue?