Please i need step by step And drow graph

3-P59 A coal-fired power plant has upgraded an emission control valve. The modification costs only $8000 and is expected to last 6 years with a $200 salvage value. The maintenance cost is expected to be high at $1700 the first year, increasing by 11% per year thereafter. Determine the equivalent present worth of the modification and maintenance cost by hand and by spreadsheet at 8% per year. Formulas Symbol Formula (F/P, i, n) (P/F, i, n) (A/F, i, n) r = P + 1) P = F (1+ 1) 1- ""= 1- "(+1) "(+1) * P - " 1- "(+1) * =p ***** (F1, i, ni) (A/P, t, ) sau also sod 500 (PA, i, n) = * (1+)" )) .)=P) 1-=-= ) PIG , i , m ( ( ,FIG , i) (1 .1 .G) 22 | | F=G[(1+ 0 = A=0.0+ 1 - 1 P = 41 * - ) P / A1 , g , i ( , ) = - = (1+ ia) (1/me) - 1 = | *m 1- " = ia = (1+) -1 PMT Porf //// bridges throughout the area. Further, they estimate that the deposits will increase by $100,000 per year for only 9 years thereafter, then cease. Determine the equivalent (a) present worth and (b) annual series amounts, if public funds earn at a rate of 5% per year. 2-P56 The announcement of the HAC cement factory states that the $200 million (M) investment is planned for 2018. Most large investment commitments are actually spread out over several years as the plant is constructed and production is initiated. Further investigation may determine, for example, that the $200 M is a present worth in the year 2018 of anticipated investments during the next 4 years (2019 through 2022). Assume the amount planned for 2019 is $100 M with constant decreases of $25 M each year thereafter. As before, assume the time value of money for investment capital is 10% per year to answer the following questions using tabulated factors and spreadsheet functions, as requested below. (a) In equivalent present worth values, does the planned decreasing investment series equal the announced $200 M in 2018? Use both tabulated factors and spreadsheet functions. (b) Given the planned investment series, what is the equivalent annual amount that will be invested from 2019 to 2022? Use both tabulated factors and spreadsheet functions. (c) (This optional question introduces Excel's Goal Seek tool.) What must be the amount of yearly constant decrease through 2022 to have a present worth of exactly $200 M in 2018. provided $100 M is expended in 2019? Use a spreadsheet. 3-P59 A coal-fired power plant has upgraded an emission control valve. The modification costs only $8000 and is expected to last 6 years with a $200 salvage value. The maintenance cost is expected to be high at $1700 the first year, increasing by 11% per year thereafter. Determine the equivalent present worth of the modification and maintenance cost by hand and by spreadsheet at 8% per year. 4-P60 Now let's go back to the proposed Houston American Cement plant in Georgia. The revenue series estimate of $50 million annually is quite optimistic, especially since there are many other cement product plants operating in Florida and Georgia on the same limactana damit