Shea is pricing materials (wood, wire, pipe, etc.) for new home construction on a "per unit" basis. Inflation on materials has been running at 16.0% for the past 3 years and is expected to remain at that rate for the next 10 years. The actual dollars paid for expenses at the end of year 3 for a "unit" are $55,000.

What did the same set of materials cost 3 years ago? If the trend continues, what will they cost 10 years from now?

Solve in excel