5-38. Rural Consolidated Fire Services (RCFS) is considering applying for a federal Department of Energy (DOE) grant that would allow it to install solar panels on each of its four firehouses. The roofs on each of the firehouses are big enough to accommodate 30,000 square feet of panels. Panels cost $8 per square foot. In addition, RCFS will have to pay $8,000 per firehouse for batteries and other equipment costs and $10,000 per firehouse for installation. RCFS expects the solar panels on the four buildings to generate a total of $6,000 worth of electricity each month for the next 10 years. If RCFS puts panels on all four firehouses, the DOE will give RCFS $500,000 toward the cost of buying and installing the solar-power system. Federal stimulus money will be received at the start of the project. If RCFSs discount rate is 6 percent, should RCFS install the panels based solely on financial considerations? Support your answer with the appropriate TVM calculations.

.

Please give an answer in excel .

Input

Number of Fire Houses

Cost of capital

Monthly cost of Capital

DOE Grant

Monthly Electricity Savings

Number of Months

Size of Roofs in sq.ft.

Cost per sq. ft. for panels

Per Fire House Total

Cost for panels

Cost of Equipment

Cost Of Installation

Total Startup Cost

Total Startup Costs

DOE Grant

PV of Electricy Annuity

Net Present Value Formulas

=PV(rate,nper,pmt,fv,type)