Question

Bruno's Lunch Counter is expanding and expects operating cash flows of $25,600 a year for 5 years as a result. This expansion requires $69,000 in new fixed assets. These assets will be worthless at the end of the project. In addition, the project requires $5,800 of net working capital throughout the life of the project. What is the net present value of this expansion project at a required rate of return of 13 percent

Answer 1

Answer:s

NPV is $ 18,389.13  

Explanation:

Years                                                                                          cash flow    

0         Capital+net working capital(-69000-5800)                    -74,800

1                cash inflows                                                                25,600

2                cash inflows                                                               25,600

3                cash inflows                                                               25,600

4                cash inflows                                                                25,600

5               cash inflows+net working capital(25,600+5800)      31,400

The formula for npv in excel is =npv(rate,values)

note that the values here refer to the inflows alone, the initial capital outlay is added manually to the formula as that should not be discounted as it is already in its present value state.

The npv is $ 18,389.13  

Kindly find attached

Download xlsx