Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please tell me the calculation formula for the green part L10 A x fx A B D E F G | J K. L 1
Please tell me the calculation formula for the green partL10 A x fx A B D E F G | J K. L 1 2 3 4 5 6 Year Purchase Price Loan Amount 0 (8,950,000) 6,265,000 8,950,000 650,000 2.5% 6,265,000 5.0% 20 7.0% Disposition Amount Loan Payoff 10,505,933 (5,228,447) 1 Assumptions: 2 Purchase Price 3 Year 1 NOI 4 Growth Rate 5 Loan Amount 6 Interest Rate 7 Loan Term 8 Cap Rate 9 10 11 12 13 14 15 16 17 NOI Debt Payments 650,000 (496,155) 666,250 (496,155) 682,906 (496,155) 699,979 (496,155) 717,478 (496,155) 735,415 (496,155) Determine the Marginal Rate of Return for the 3rd year - Just fill in the appropriate cells Don't sell at the end of year 3 Cash from Operations Disposition Loan Payoff Total Cash Flow L10 A x fx A B D E F G | J K. L 1 2 3 4 5 6 Year Purchase Price Loan Amount 0 (8,950,000) 6,265,000 8,950,000 650,000 2.5% 6,265,000 5.0% 20 7.0% Disposition Amount Loan Payoff 10,505,933 (5,228,447) 1 Assumptions: 2 Purchase Price 3 Year 1 NOI 4 Growth Rate 5 Loan Amount 6 Interest Rate 7 Loan Term 8 Cap Rate 9 10 11 12 13 14 15 16 17 NOI Debt Payments 650,000 (496,155) 666,250 (496,155) 682,906 (496,155) 699,979 (496,155) 717,478 (496,155) 735,415 (496,155) Determine the Marginal Rate of Return for the 3rd year - Just fill in the appropriate cells Don't sell at the end of year 3 Cash from Operations Disposition Loan Payoff Total Cash Flow
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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