need 100% correct answer will be upvote in 10 minutes

Exam Directions Problem Set 1 Basic Mtg Calcs DCF Problem 1 DCF Problem 25 Yr DCF B C D E F G Complete the Analysis to Answer the Questions Below Before Tax Cash Flows: Potential Gross Income Vacancy \\& Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service Before Tax Cash Flow Answer the following: Sale value at EOY 5 Net Sale Proceeds at EOY 5 IRR overall (unlevered) IRR equity GPV of equity NPV of equity \\begin{tabular}{rrrrrr} Year 1 & \\multicolumn{1}{c}{ Year 2 } & \\multicolumn{1}{c}{ Year 3 } & Year 4 & Year 5 & Year 6 \\\\ \\( \\$ 950,000 \\) & \\( \\$ 1,007,000 \\) & \\( \\$ 1,067,420 \\) & \\( \\$ 1,131,465 \\) & \\( \\$ 1,199,353 \\) & \\( \\$ 1,271,314 \\) \\\\ \\( \\$ 95,000 \\) & \\( \\$ 100,700 \\) & \\( \\$ 106,742 \\) & \\( \\$ 113,147 \\) & \\( \\$ 119,935 \\) & \\( \\$ 127,131 \\) \\\\ \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) \\\\ \\hline\\( \\$ 855,000 \\) & \\( \\$ 906,300 \\) & \\( \\$ 960,678 \\) & \\( \\$ 1,018,319 \\) & \\( \\$ 1,079,418 \\) & \\( \\$ 1,144,183 \\) \\\\ \\( \\$ 400,000 \\) & \\( \\$ 420,000 \\) & \\( \\$ 441,000 \\) & \\( \\$ 463,050 \\) & \\( \\$ 486,203 \\) & \\( \\$ 510,513 \\) \\\\ \\hline\\( \\$ 455,000 \\) & \\( \\$ 486,300 \\) & \\( \\$ 519,678 \\) & \\( \\$ 555,269 \\) & \\( \\$ 593,215 \\) & \\( \\$ 633,670 \\) \\\\ \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\\\ \\hline\\( \\$ 107,683 \\) & \\( \\$ 138,983 \\) & \\( \\$ 172,361 \\) & \\( \\$ 207,951 \\) & \\( \\$ 245,898 \\) & \\end{tabular} 4 pts 4 pts 4 pts 4 pts 4 pts 4 pts 24 pts total Exam Directions Problem Set 1 Basic Mtg Calcs DCF Problem 1 DCF Problem 25 Yr DCF B C D E F G Complete the Analysis to Answer the Questions Below Before Tax Cash Flows: Potential Gross Income Vacancy \\& Credit Losses Other Income Effective Gross Income Operating Expenses Net Operating Income Debt Service Before Tax Cash Flow Answer the following: Sale value at EOY 5 Net Sale Proceeds at EOY 5 IRR overall (unlevered) IRR equity GPV of equity NPV of equity \\begin{tabular}{rrrrrr} Year 1 & \\multicolumn{1}{c}{ Year 2 } & \\multicolumn{1}{c}{ Year 3 } & Year 4 & Year 5 & Year 6 \\\\ \\( \\$ 950,000 \\) & \\( \\$ 1,007,000 \\) & \\( \\$ 1,067,420 \\) & \\( \\$ 1,131,465 \\) & \\( \\$ 1,199,353 \\) & \\( \\$ 1,271,314 \\) \\\\ \\( \\$ 95,000 \\) & \\( \\$ 100,700 \\) & \\( \\$ 106,742 \\) & \\( \\$ 113,147 \\) & \\( \\$ 119,935 \\) & \\( \\$ 127,131 \\) \\\\ \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) & \\( \\$ 0 \\) \\\\ \\hline\\( \\$ 855,000 \\) & \\( \\$ 906,300 \\) & \\( \\$ 960,678 \\) & \\( \\$ 1,018,319 \\) & \\( \\$ 1,079,418 \\) & \\( \\$ 1,144,183 \\) \\\\ \\( \\$ 400,000 \\) & \\( \\$ 420,000 \\) & \\( \\$ 441,000 \\) & \\( \\$ 463,050 \\) & \\( \\$ 486,203 \\) & \\( \\$ 510,513 \\) \\\\ \\hline\\( \\$ 455,000 \\) & \\( \\$ 486,300 \\) & \\( \\$ 519,678 \\) & \\( \\$ 555,269 \\) & \\( \\$ 593,215 \\) & \\( \\$ 633,670 \\) \\\\ \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\( -\\$ 347,317 \\) & \\\\ \\hline\\( \\$ 107,683 \\) & \\( \\$ 138,983 \\) & \\( \\$ 172,361 \\) & \\( \\$ 207,951 \\) & \\( \\$ 245,898 \\) & \\end{tabular} 4 pts 4 pts 4 pts 4 pts 4 pts 4 pts 24 pts total