Find the discounted pay back periods using excel


Problem: Can you help me get started with this assignment?

Find the Discounted Pay back Periods using Excel:

Project A: -$283,000; $46,000; $89,000; $104,000; $123,000; $187,000; $72,000

Project B: -$318,000; $72,000; $213,000; $131,000; $112,000; $92,000; $64,000

(The interest rate =10%, and the cost recovery policy is 3 years.

Solution Preview :

Prepared by a verified Expert
Finance Basics: Find the discounted pay back periods using excel
Reference No:- TGS01811904

Now Priced at $20 (50% Discount)

Recommended (92%)

Rated (4.4/5)