What is the net present value using an excel function


Problem:

Harry Smith is considering the purchase of a red van for use in shuttling people to a local airport. The van will cost $40,000 and is expected to last 5 years. He expects to sell the van at the end of year 5 for $6,000. After paying wages to drivers, taxes, fees, gasoline, maintenance and other costs, he expects the following cash inflows: Year 1 $4,000, Year 2 $8,000, year 3 $12,000, year 4 $16,000 and year 5 $6,000. The total cash inflow in year 5 is expected to be $12,000, ($6,000 from the operation of the van and $6,000 from the sale of the van.)

1) If the appropriate required rate of return is 8%, what is the net present value using an excel function and should he make the investment?

2) If Mr. Smith's business grows to where the free cash flow becomes $600,000 per year in 2012, what is the value of that business? Assume that cash flow is expected to grow at 2% per year for the future. What information do you need that is not given? What is a reasonable estimate for the missing information? Please explain why you made your choice.

3) If Mr. Smith decides to implement a Balanced Scorecard, choose 2 metrics and explain how you would measure these metrics.

Solution Preview :

Prepared by a verified Expert
Finance Basics: What is the net present value using an excel function
Reference No:- TGS01813636

Now Priced at $25 (50% Discount)

Recommended (94%)

Rated (4.6/5)