Question: If there's any excel work, please list out formulas. A small heat pump now costs $2,400 to purchase and install. It has a projected useful
If there's any excel work, please list out formulas.


A small heat pump now costs $2,400 to purchase and install. It has a projected useful life of 18 years and will incur annual maintenance costs of $75 per year in real (year-zero) dollars over the useful life. These costs are projected to increase at 4% per year, which is the expected general inflation rate. The annual cost of electricity for the heat pump is $700 in year-zero dollars. Electricity prices are projected to increase at an annual rate of 8%. The firm's MARR, which includes an allowance for general price inflation, is 18% per year (im). No market value is expected from the heat pump at the end of the 18 years of service life. Click the icon to view the interest and annuity table for discrete compounding when i= 18% per year. a. What is the PW of owning and operating the heat pump? The PW is $(Round to the nearest dollar.) b. () What is the AW, expressed in actual dollars, of owning and operating the heat pump? The AW is $. (Round to the nearest dollar.) (ii) What is the AW in real dollars of owning and operating the heat pump? The AW is $. (Round to the nearest dollar.) Capital Recovery Factor To Find A Given P A/P N 1 2 3 4 5 6 7 8 9 10 Discrete Compounding; i = 18% Single Payment Uniform Series Compound Compound Sinking Amount Present Amount Present Fund Factor Worth Factor Factor Worth Factor Factor To Find F To Find P To Find F To Find P To Find A Given P Given F Given A Given A Given F F/P P/F FIA PIA A/F 1.1800 0.8475 1.0000 0.8475 1.0000 1.3924 0.7182 2.1800 1.5656 0.4587 1.6430 0.6086 3.5724 2.1743 0.2799 1.9388 0.5158 5.2154 2.6901 0.1917 2.2878 0.4371 7.1542 3.1272 0.1398 2.6996 0.3704 9.4420 3.4976 0.1059 3.1855 0.3139 12.1415 3.8115 0.0824 3.7589 0.2660 15.3270 4.0776 0.0652 4.4355 0.2255 19.0859 4.3030 0.0524 5.2338 0.1911 23.5213 4.4941 0.0425 6.1759 0.1619 28.7551 4.6560 0.0348 7.2876 0.1372 34.9311 4.7932 0.0286 8.5994 0.1163 42.2187 4.9095 0.0237 10.1472 0.0985 50.8180 5.0081 0.0197 11.9737 0.0835 60.9653 5.0916 0.0164 14.1290 0.0708 72.9390 5.1624 0.0137 16.6722 0.0600 87.0680 5.2223 0.0115 19.6733 0.0508 103.7403 5.2732 0.0096 23.2144 0.0431 123.4135 5.3162 0.0081 27.3930 0.0365 146.6280 5.3527 0.0068 1.1800 0.6387 0.4599 0.3717 0.3198 0.2859 0.2624 0.2452 0.2324 0.2225 0.2148 0.2086 0.2037 0.1997 0.1964 0.1937 0.1915 0.1896 0.1881 0.1868 11 12 13 14 15 16 17 18 19 20
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
