Answered step by step
Verified Expert Solution
Link Copied!

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 part

image text in transcribed

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 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Emerging Markets Handbook

Authors: Pran Tiku

1st Edition

0857192981, 978-0857192981

More Books

Students also viewed these Finance questions

Question

Analyse the various techniques of training and learning.

Answered: 1 week ago