File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share 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 X E9 v IX fx =-VDB(OF_PP,,Exp_DepYr,D2,E2,Exp_DepF,1) B C D E F G H K M N O Table 1: Operational Net Cash Flow Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10 Initial Cash Outlay Note ($455,520.00) Potential Revenue a $81,881.91 $83,028.26 $84,190.65 $85,369.32 $86,564.49 $87,776.39 $89,005.26 $90,251.34 $91,514.86 $92,796.06 Less Vacancy or Turnover b ($5,977.38) ($6,061.06) ($6,145.92) ($6,231.96) ($6,319.21) ($6,407.68) ($6,497.38) ($6,588.35) ($6,680.58) ($6,774.11) VOUS Less Management Fee $20,470.48) ($20,757.06) ($21,047.66) ($21,342.33) ($21,641.12) ($21,944.10) ($22,251.32) ($22,562.83) ($22,878.71) ($23,199.02) Less Property Tax $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 $1,402.00 8 Net Revenue e a-b-c-d $56.836.05 $57,612.13 $58,399.07 $59,197.03 $60,006.16 $60,826.62 $61,658.56 $62,502.16 $63,357.56 $64.224.94 9 Less Depreciation f d-e ($15,927.27) ($15,348.10) ($14,789.99) ($14,252.17) ($13,733.91) ($13,234.49) ($12,753.24) ($12,289.48) ($11,842.59) ($11,411.95) 10 = Income from Operations 8 $40,908.78 $42,264.03 $43,609.09 $44,944.86 $46,272.25 $47,592.13 $48,905.33 $50,212.67 $51,514.96 $52,812.98 11 Less Interest Expense on Loan h ($9,742.80) ($9.640.77) ($9,531.53) ($9,414.58) ($9,289.38) ($9,155.33) ($9.011.82) ($8,858.18) ($8,693.70) ($8,517.60) 12 = Taxable Income i=g-h $31,165.98 $32,623.26 $34,077.55 $35,530.28 $36,982.88 $38,436.79 $39,893.50 $41,354.49 $42.821.27 $44,295.39 13 Less Income taxes ($8.539.48) ($8,938.77) ($9,337.25) ($9,735.30) ($10,133.31) ($10,531.68) ($10,930.82) ($11,331.13) ($11,733.03) ($12,136.94) 14 Net Income k-i-i $22,626.50 $23,684.49 $24,740.30 $25,794.98 $26,849.57 $27,905.11 $28,962.68 $30,023.36 $31,088.24 $32,158.45 15 Less Principal Payments ($1,445.23) ($1,547.26) ($1.656.50) ($1.773.45) ($1,898.65) ($2,032.70) ($2,176.21) ($2,329.85) ($2.494.33) ($2.670.43) 16 Add back Depreciation $15,927.27 $15,348.10 $14,789.99 $14,252.17 $13,733.91 $13,234.49 $12,753.24 $12,289.48 $11.842.59 $11.411.95 17 Terminal Value $102.093.58 18 = Net Cash Flow from Project m=k-l+f+ ($455,520.00) $37,108.55 $37,485.33 $37,873.79 $38,273.71 $38,684.82 $39,106.91 $39,539.72 $39.983.00 $40.436.50 $142.993.55 19 20 Discount 1.0000 0.9091 0.8264 0.7513 0.6830 0.6209 0.5645 0.5132 0.4665 0.4241 0.3855 21 Discounted Cash Flow ($455.520.00) $33,735.04 $30,979.61 $28,455.14 $26,141.46 $24,020.23 $22,074.83 $20,290.13 $18.652.36 $17.149.02 $55.130.20 22 Accumulative Discounted Cash Flow ($455.520.00) ($421,784.96) ($390.805.35) ($362.350.21) ($336.208.75) ($312,188.52) ($290.113.69) ($269.823.56) ($251.171.20) ($234.022.17) ($178.891.97) 23 24 Net Present Value or NPV ($178.891.97) =NPV(Rate RR.E18:N18)+D18 25 IRR 1.19% =IRR(D18:N18) 26 MIRR 5.46% =MIRR(D18:N18.Rate_RR.Rate_ReInvt) 27 EVA=MIRR - Rate_RR -4.54% =D26-Rate RR 28 Discounted Payback Period 17.4 years =INTERCEPT(D2:N2,D22:N22) 29 Atata: MainMenu Flowchart | Assumptions Table1 Table2 Table3 | Stock Scenarios Documentation 939% Read 1:41 PM -2"C Cloudy Q Search LO M O W 3/12/2023