us VO nth Create an excel spreadsheet to project the current costs. Apply an average inflation rate of 8% per year to adjust the costs reported to current dollars and calculate the following: The cost for the purchase and development of the site was $5,500,000 credited at the beginning of the preconstruction period. The preconstruction work cost was $500,000 credited three months after the start of preconstruction. The construction costs of $75,000,000 can be assumed to be credited in a uniform series of costs at the end of every quarter from January 2015 through September 2016 (7 quarters). The project schedule had first turnover of units 3 months prior to completion. Preconstruction started in October 2014 and final turnover and completion was September 2016 (a total of 8 quarters or two years.) a) What is the equivalent cost in today's dollars of the Shea Homes project (as of the end of the current quarter - Oct 1, 2020)? c) What is the projected cost of the Shea Homes project if it was built in 2024 (as of the beginning of the year)? pro of be Cany the rted wil average te the fol nes projec mes project built in 202 is built in 2016 cost-Net Pre auto determi refren