EXCEL

The idea of buying a new machine to replace the older one arose at the last management team meeting. The older one would not be sold but could be used as backup if necessary. If Pecan Peanuts does decide to replace the older machine and buy a new one, the finance dept has indicated that the maximum monthly payment they could afford, based on current profit forecasts for the next six years, would be 2000 p.m. The Companys bankers would be able to offer an interest rate of 9% to borrow the 96,000 cost of the new machine. What range of months would you recommend that the loan is taken over to keep within Pecan Peanuts budget?

{Insert calculation IN EXCEL and summarise result approx. 200 words

Insert calculation IN EXCEL and summarise result approx. 200 words}