Question

how would I solve this problem using an excel workbook only. i cannot figure out present worth on excel worksheet for this problem

homework questions Chapter 6, Problem 34P & Bookmarks Show all steps ON Enter question < Continue to post 12 questions remaining Life Cycle Cost An international aerospace contractor has been asked by a municipal police department to estimate and analyze the life cycle costs for a proposed drone surveillance system to monitor traffic patterns and congestion within the central thoroughfares of the city. The list of items Include the following general categories: R&D costs (R&D), nonrecurring investment costs (NRI). recurring investment costs (RI), scheduled and unscheduled maintenance costs (Maint), equipment usage costs (Equip), and disposal costs (Disp). The costs in 5 million units) for the 20-year life cycle have been estimated. Calculate the annual LCC at an interest rate of 7% per year Year RED NRI Maint Equip 55 LI 3.5 25 05 5.2 15 3.1 5 6.5 27 11-20 Snap a photo from your phone to post a question RI Die 0 1 My Textbook Solutions 2 0.6 4 10.5 10.5 3.6 53 Eng