Cash flow Cumulative Assignment

>

 ABC 1 Year Cash flow Cumulati” aria-describedby=”g04″> 26. A manufacturing company is planning to buy new equipment that costs $100,000. Because of this investment, they estimate the follow- ing annual savings during the next seven years: $14,000; $17,000; $23,300; $22,000; $21,000; $18,000; $16,700. Use Excel functions to calcu- late the following. (Refer to worksheet “4.26”) a. Net present value of this investment. Assume that the return in investment for this com- pany is 5%. b. Internal rate of return. C. Payback period. d. Since the APR given by a local bank is only 3%, the company is planning to borrow the money needed to buy the equipment. Identify the yearly payments the company should make to pay off the loan in five years. Home Insert Draw Page Layout >> A. 3 %- co Foi Clipboard Font Alignment Number Cel x V fx E G24 ABC 1 Year Cash flow Cumulative 0 ($100,000)| ($100,000) 11 $14,000 ($86,000) 4 2 $17,000 ($69,000) 5 3 $23.300 ($45,700) 64 $22,000 ($23,700 75 $21,000 ($2,700) 86 $18,000 $15,300 9 7 $16,700 $32,000. .