Excel ® Assignment: Asset Retirement ScenariosMolly Company plans to retire its primary production facility in 30 years. The company is considering the establishment of a retirement account that will be used to accumulate funds during the 30- year period. The retirement account will then be used to replace the retired production facility.

RequiredDownload the spreadsheet file titled “chapter_ 10_ 41” from the textbook Web site. Use scenario manager to create a scenario summary report of the total value of the retirement account for the following three scenarios concerning the value of the retirement account at the end of the 30- year period. The annual contribution will be made at the beginning of each year, starting with the first year. This task can best be accomplished using the FV function.