Answered step by step
Verified Expert Solution
Question
1 Approved Answer
fill in the green begin{tabular}{|c|c|c|c|c|c|c|} hline & Property A & & & Property B & & hline Income-Rent: & 125,000 & & & &
fill in the green \begin{tabular}{|c|c|c|c|c|c|c|} \hline & Property A & & & Property B & & \\ \hline Income-Rent: & 125,000 & & & & Property C & Property D \\ \hline \multirow{2}{*}{\multicolumn{7}{|c|}{(Expenses)(Management)8sisofrent}} \\ \hline (Management) 8 sis of rent & 10,000 & & & & & \\ \hline (Repairs) & & & & 800 & 176,000 & 10,000 \\ \hline (Real Estate Faxes) & & & & 550 & 125,000 & 6,500 \\ \hline (Insurance) & 11,5005,000 & & & 900 & 350,000 & 11,500 \\ \hline (Depreciation) & 5,00025,000 & & & 590 & 13,500 & 8,500 \\ \hline EBIT & 63,50025,000 & & - & 2,200 & 58,000 & 3.500 \\ \hline (Interest) & 53,50050,000 & & & 4,960 & 1,477,500 & 85,000 \\ \hline EBT & 50,00013,500 & & & 900 & 1,000,000 & 4,100 \\ \hline (Taxes 21X) & 13,5002.835 & & & 4,060 & 477,500 & 80,900 \\ \hline \multirow[t]{2}{*}{ Net income } & 10,6652.835 & & = & 853 & 100,275 & 16,989 \\ \hline & 10,665 & & & 3,207 & 377,225 & 63,911 \\ \hline \multirow{3}{*}{ Net Operating income = EBIT + Depreciation } & & & & & & \\ \hline & 88,500 & & +4 & & & \\ \hline & & & & & & \\ \hline Purchase Price & 1,040,000 & & & 85,000 & 20,000,000 & 1,040,000 \\ \hline Loan Amount & 825,000 & & & 82,500 & 18,250,000 & 825,000 \\ \hline Rate & 4.75 & & & 5.254 & 4.25% & 3.754 \\ \hline Amortiation (Year) & 15 & & & 15 & 30 & 30 \\ \hline & & & & & & \\ \hline \multirow[t]{2}{*}{ Bayment: } & 56.417 .11 & & & & & \\ \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ Outputs }} & & & & & \\ \hline & & Guldelines & & & & \\ \hline Caplate & 8.51 & 81 & Lapent & & & \\ \hline Net income Mulupler: & 11.8 & 10.00 & & & & \\ \hline Gross Multiplier & 8.3 & 8.3. & & & & \\ \hline Loan-to-Value & 79.33 & 80x, & mint & & & \\ \hline Debt Coverage & 1.15 & 1.25s & & & & \\ \hline & & & & & & \\ \hline & & & & & & \\ \hline \end{tabular} Solve for NOI, Payment, and Five calculations for each property (All Green Cells). Upload completed calculations in canvas. Property " A " calculations are complete and can be used as an example. Change property "B" to a 30 year loan. What was the DCR at 15 year and 30 years. Interpret the DCR for both calculations
fill in the green
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started