X AutoSave @ off GBD230- Retirement Income Case[1] - Protected View v 9 Search Nainika Pawla File Home Insert Page Layout Formulas Data Review View Automate Help Comments i PROTECTED VIEW This file has been verified by Microsoft Defender Advanced Threat Protection and it hasn't detected any threats. If you need to edit this file, click enable editing. Enable Editing D14 v : X fx =D11+D13 A B C D E F G H J Table 2: Terminal Cash Flow IN Sales Value (Year 10 perpetual value) a (see Table 3) $578,536.97 =Table3!D16/Rate_Cap Original Loan b $138,000.00 5 Less Principal Payments C ($20,024.60) 6 = Outstanding Loan Balance d=b-c $117,975.40 Cash After Loan Payoff e=a-d $460,561.56 8 Basis & Taxable Gains (or Loss) 9 Cost Basis $455,520.00 10 Less Accumulated Depreciation g ($135,583.20) 11 Taxable Gain (or Loss) h=e- (f-g) $140,624.76 12 Tax Rate on Long Term Capital Gain i 27.4% 13 Less Taxes on Gain (or Loss) j=h*i ($38,531.19) 14 = Net Cash Flow from Sales k-h-j $102,093.58 This value is added to Year 10 as terminal value 15 16 17 18 19 MainMenu Flowchart Assumptions Table1 Table2 Table3 Stock Scenarios Documentation Ready -2. C Search M Cloudy