John wiggins is considering the purchase of a small restaurant. the purchase price listed by the seller is $800,000. john has used past financial information to estimate that the net cash flows (cash inflows less cash outflows) generated by the restaurant would be as follows:

Since NPV is negative (-$73,835.60), the project should be rejected.

Explanation:

                                      Years                       Amount

                                         0                        -$800,000

                                       1–6                          $80,000

                                         7                            $70,000

                                         8                           $60,000

                                         9                           $50,000

                                        10                         $740,000

In order to determine if this is a good investment or not, we need to calculate the net present value (NPV). If NPV  ≥ 0, then the project is good, it NPV is negative, then the project should be rejected.

I will use an excel spreadsheet to calculate the NPV with a 10% discount rate.

We must first determine the present value of the cash flows and then subtract the investment from it.

The present value of the cash flows = $726,164.60 and obviously its smaller than the initial investment: $726,164.60 - $800,000 = -$73,835.60

Since NPV is negative, the project should be rejected.

answer production department;