Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 (Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started