real estate question

B D E F G H Solve for the Overall Value and Overall Cap Rate of the property given the information below. Income Value Land Building Property Rate 9.50% 12.00% $200,000 $62,000 AB D F G K Use the FV (Future Value) function to determine the outstanding loan balance in Year 5. Use the amortization schedule below to check your work. Loan Principal Loan Term Interest Rate Loan Balance $4,000,000 15 10.00% ($25417,986) Interest Principal a u 5 6 7 8 9 10 Begin $4,000,000 $4,000,000 $3,633,333 $3,266,667 $2,900,000 $2,533,333 $2,166,667 $1,800,000 $1,433,333 $1,066,667 $700,000 $333,333 -$33,333 $400,000 -$766,667 -$1,133,334 PMT $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $33,333.33 $33,333.33 $33,333.33 $33,333 33 $33,333.33 $33,333 33 $33,333.33 $33,333.33 $33,333.33 $33,333.33 $33,333.33 $33,333,33 $33,333.33 $33,333 33 $33,333 33 $366,666.68 $366,666.68 $366,666.68 $366,666 68 $366,666.68 $366,666.68 $366,666 68 $366,666.68 $366,666.68 $366,666.68 $366,666.68 $366,666.68 $366,666.68 $366,666.68 $366,666.68 End $4,000,000 $3,633,333 $3,266,667 $2,900,000 $2,533,333 $2.166,667 $1,800,000 $1,433,333 $1,066,667 $700,000 $333,333 -$33,333 -$400,000 -$766,667 $1,133,334 $1,500,000 1 2 11 12 13 14 15 4 45 26 27 28 29 20 31 32 33 34 35