Answer:
Capital needed = $1,061,342.10
Explanation:
Description Amount
----------------------------------------------------------------------------------------------------
Annual Savings = $80,000 x 80% $64,000.00
Inflation Rate 3.00%
Period = 68 years - 43 years 25 years
Future Value (Annual Savings) = $64,000 x (1+3%)^25 $134,001.79
Future Value (Social Security) = $26,000 x (1+3%)^25 $54,438.23
PMT = $134,001.79 - $54,438.23 $79,563.56
Inflation Adjusted Rate = (1.08/1.03) - 1 4.85%
Period = 90 years - 68 years 22 years
Capital needed = PV(4.85%,22,-79,563.56) $1,061,342.10
Hope this helps!