Please show steps and formulas used. especially if using excel so that I can replicate and solve on my own in the future.

A small heat pump, including the duct system, now costs $2,800 to purchase and install. It has a useful life of 18 years and incurs annual maintenance expenses of $100 per year in real (year-zero) dollars over its useful life. A compressor replacement is required at the end of years 6 and 12 at a cost of $600 each in real dollars. The annual cost of electricity for the heat pump is $720 in year-zero dollars. Electricity prices are projected to increase at an annual rate of 9%. All other costs are expected to increase at 5%, which is the projected general price inflation rate. The firm's MARRwhich includes an allowance for general price inflation, is 15% per year (w). 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=5% per year. Click the icon to view the interest and annuity table for discrete compounding when i = 9% per year. Click the icon to view the interest and annuity table for discrete compounding when i= 15% per year. a. What is the PW of owning and operating the heat pump? The PW is $(Express cost as negative; Round to the nearest dollar.) b.) What is the Aw, expressed in actual dollars, of owning and operating the heat pump? The AW is $(Express cost as negative; Round to the nearest dollar.) ) What is the AW in real dollars of owning and operating the heat pump? The AW is $(Express cost as negative: Round to the nearest dollar.) N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 6% 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 F/A PIA A/F 1.0600 0.9434 1.0000 0.9434 1.0000 1.1236 0.8900 2.0600 1.8334 0.4854 1.1910 0.8396 3.1836 2.6730 0.3141 1.2625 0.7921 4.3746 3.4651 0.2286 1.3382 0.7473 5.6371 4.2124 0.1774 1.4185 0.7050 6.9753 4.9173 0.1434 1.5036 0.6651 8.3938 5.5824 0.1191 1.5938 0.6274 9.8975 6.2098 0.1010 1.6895 0.5919 11.4913 6.8017 0.0870 1.7908 0.5584 13.1808 7.3601 0.0759 1.8983 0.5268 14.9716 7.8869 0.0668 2.0122 0.4970 16.8699 8.3838 0.0593 2.1329 0.4688 18.8821 8.8527 0.0530 2.2609 0.4423 21.0151 9.2950 0.0476 2.3966 0.4173 23.2760 9.7122 0.0430 Capital Recovery Factor To Find A Given P A/P 1.0600 0.5454 0.3741 0.2886 0.2374 0.2034 0.1791 0.1610 0.1470 0.1359 0.1268 0.1193 0.1130 0.1076 0.1030 N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 10% 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 P/A A/F 1.1000 0.9091 1.0000 0.9091 1.0000 1.2100 0.8264 2.1000 1.7355 0.4762 1.3310 0.7513 3.3100 2.4869 0.3021 1.4641 0.6830 4.6410 3.1699 0.2155 1.6105 0.6209 6.1051 3.7908 0.1638 1.7716 0.5645 7.7156 4.3553 0.1296 1.9487 0.5132 9.4872 4.8684 0.1054 2.1436 0.4665 11.4359 5.3349 0.0874 2.3579 0.4241 13.5795 5.7590 0.0736 2.5937 0.3855 15.9374 6.1446 0.0627 2.8531 0.3505 18.5312 6.4951 0.0540 3.1384 0.3186 21.3843 6.8137 0.0468 3.4523 0.2897 24.5227 7.1034 0.0408 3.7975 0.2633 27.9750 7.3667 0.0357 4.1772 0.2394 31.7725 7.6061 0.0315 Capital Recovery Factor To Find A Given P A/P 1.1000 0.5762 0.4021 0.3155 0.2638 0.2296 0.2054 0.1874 0.1736 0.1627 0.1540 0.1468 0.1408 0.1357 0.1315 N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 15% 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 P/A A/F 1.1500 0.8696 1.0000 0.8696 1.0000 1.3225 0.7561 2.1500 1.6257 0.4651 1.5209 0.6575 3.4725 2.2832 0.2880 1.7490 0.5718 4.9934 2.8550 0.2003 2.0114 0.4972 6.7424 3.3522 0.1483 2.3131 0.4323 8.7537 3.7845 0.1142 2.6600 0.3759 11.0668 4.1604 0.0904 3.0590 0.3269 13.7268 4.4873 0.0729 3.5179 0.2843 16.7858 4.7716 0.0596 4.0456 0.2472 20.3037 5.0188 0.0493 4.6524 0.2149 24.3493 5.2337 0.0411 5.3503 0.1869 29.0017 5.4206 0.0345 6.1528 0.1625 34.3519 5.5831 0.0291 7.0757 0.1413 40.5047 5.7245 0.0247 8.1371 0.1229 47.5804 5.8474 0.0210 Capital Recovery Factor To Find A Given P A/P 1.1500 0.6151 0.4380 0.3503 0.2983 0.2642 0.2404 0.2229 0.2096 0.1993 0.1911 0.1845 0.1791 0.1747 0.1710 A small heat pump, including the duct system, now costs $2,800 to purchase and install. It has a useful life of 18 years and incurs annual maintenance expenses of $100 per year in real (year-zero) dollars over its useful life. A compressor replacement is required at the end of years 6 and 12 at a cost of $600 each in real dollars. The annual cost of electricity for the heat pump is $720 in year-zero dollars. Electricity prices are projected to increase at an annual rate of 9%. All other costs are expected to increase at 5%, which is the projected general price inflation rate. The firm's MARRwhich includes an allowance for general price inflation, is 15% per year (w). 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=5% per year. Click the icon to view the interest and annuity table for discrete compounding when i = 9% per year. Click the icon to view the interest and annuity table for discrete compounding when i= 15% per year. a. What is the PW of owning and operating the heat pump? The PW is $(Express cost as negative; Round to the nearest dollar.) b.) What is the Aw, expressed in actual dollars, of owning and operating the heat pump? The AW is $(Express cost as negative; Round to the nearest dollar.) ) What is the AW in real dollars of owning and operating the heat pump? The AW is $(Express cost as negative: Round to the nearest dollar.) N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 6% 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 F/A PIA A/F 1.0600 0.9434 1.0000 0.9434 1.0000 1.1236 0.8900 2.0600 1.8334 0.4854 1.1910 0.8396 3.1836 2.6730 0.3141 1.2625 0.7921 4.3746 3.4651 0.2286 1.3382 0.7473 5.6371 4.2124 0.1774 1.4185 0.7050 6.9753 4.9173 0.1434 1.5036 0.6651 8.3938 5.5824 0.1191 1.5938 0.6274 9.8975 6.2098 0.1010 1.6895 0.5919 11.4913 6.8017 0.0870 1.7908 0.5584 13.1808 7.3601 0.0759 1.8983 0.5268 14.9716 7.8869 0.0668 2.0122 0.4970 16.8699 8.3838 0.0593 2.1329 0.4688 18.8821 8.8527 0.0530 2.2609 0.4423 21.0151 9.2950 0.0476 2.3966 0.4173 23.2760 9.7122 0.0430 Capital Recovery Factor To Find A Given P A/P 1.0600 0.5454 0.3741 0.2886 0.2374 0.2034 0.1791 0.1610 0.1470 0.1359 0.1268 0.1193 0.1130 0.1076 0.1030 N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 10% 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 P/A A/F 1.1000 0.9091 1.0000 0.9091 1.0000 1.2100 0.8264 2.1000 1.7355 0.4762 1.3310 0.7513 3.3100 2.4869 0.3021 1.4641 0.6830 4.6410 3.1699 0.2155 1.6105 0.6209 6.1051 3.7908 0.1638 1.7716 0.5645 7.7156 4.3553 0.1296 1.9487 0.5132 9.4872 4.8684 0.1054 2.1436 0.4665 11.4359 5.3349 0.0874 2.3579 0.4241 13.5795 5.7590 0.0736 2.5937 0.3855 15.9374 6.1446 0.0627 2.8531 0.3505 18.5312 6.4951 0.0540 3.1384 0.3186 21.3843 6.8137 0.0468 3.4523 0.2897 24.5227 7.1034 0.0408 3.7975 0.2633 27.9750 7.3667 0.0357 4.1772 0.2394 31.7725 7.6061 0.0315 Capital Recovery Factor To Find A Given P A/P 1.1000 0.5762 0.4021 0.3155 0.2638 0.2296 0.2054 0.1874 0.1736 0.1627 0.1540 0.1468 0.1408 0.1357 0.1315 N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Discrete Compounding; i = 15% 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 P/A A/F 1.1500 0.8696 1.0000 0.8696 1.0000 1.3225 0.7561 2.1500 1.6257 0.4651 1.5209 0.6575 3.4725 2.2832 0.2880 1.7490 0.5718 4.9934 2.8550 0.2003 2.0114 0.4972 6.7424 3.3522 0.1483 2.3131 0.4323 8.7537 3.7845 0.1142 2.6600 0.3759 11.0668 4.1604 0.0904 3.0590 0.3269 13.7268 4.4873 0.0729 3.5179 0.2843 16.7858 4.7716 0.0596 4.0456 0.2472 20.3037 5.0188 0.0493 4.6524 0.2149 24.3493 5.2337 0.0411 5.3503 0.1869 29.0017 5.4206 0.0345 6.1528 0.1625 34.3519 5.5831 0.0291 7.0757 0.1413 40.5047 5.7245 0.0247 8.1371 0.1229 47.5804 5.8474 0.0210 Capital Recovery Factor To Find A Given P A/P 1.1500 0.6151 0.4380 0.3503 0.2983 0.2642 0.2404 0.2229 0.2096 0.1993 0.1911 0.1845 0.1791 0.1747 0.1710