Please show how to get the Discounted Cash Flow in Excel. I have attached the answers to the other questions. Thanks.

=150000/12 026 Input Current age Retirement age Number of years until retirement Annual withdrawal ($) Number of years to withdraw Interest rate (%) 150,000 15 7.00% Calculation & Output Question 7 Present value of withdrawals at age 65 Annual deposit until retirement Question 8 Present value of lump sum Discounted Cash Flow Present Value of withdrawals can be calculated using PV function in excel PV = PV(rate = 7%, nper = 15, pmt = 150,000, fv = 0, 0) = $1,366,187.10 Annual Deposit until retirement can be calculated using PMT function Deposit = PMT(7%, 40, 0, 1366187.1, 0) = $6,843.42 Present Value of lump sum = FV / (1 + r)^n = 1,366,187.10 / (1 + 7%)^40 = $91,234.50