80.2K

Verified Solution

Link Copied!

Please i need step by step And drow graph

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. Formulas Symbol Formula (F/P, i, n) (P/F, i, n) F = P +1) P = F (1 + 1)/ *F= _ 1 (A/F, i, n) 1- "(+1) r=4 (F/A, i, ) F = * (1+)" - AP , i , n1 (

Answer & Explanation Solved by verified expert

See Answer