An investor has received the following information from a selling agent: • Purchase price $2,248,000 • NOI (net operating income) $248,440 • Capital Improvements $24,000 • Structural reserves $12,400 The anticipated financing structure is for an 80% mortgage with monthly payments of principal and interest, an interest rate of 8% per annum for a term of 25 years. a) Calculate CFO (cash flow from operations), CFAF (cash flow after financing), ROA and ROE.
Question
An investor has received the following information from a selling agent: • Purchase price 248,440 • Capital Improvements 12,400 The anticipated financing structure is for an 80% mortgage with monthly payments of principal and interest, an interest rate of 8% per annum for a term of 25 years. a) Calculate CFO (cash flow from operations), CFAF (cash flow after financing), ROA and ROE.
Solution
Sure, let's calculate these step by step:
a) CFO (Cash Flow from Operations)
CFO is calculated by subtracting the capital improvements and structural reserves from the NOI (Net Operating Income).
CFO = NOI - Capital Improvements - Structural Reserves CFO = 24,000 - 212,040
b) CFAF (Cash Flow After Financing)
To calculate CFAF, we first need to calculate the annual mortgage payment. The loan amount is 80% of the purchase price, the interest rate is 8% per annum, and the term is 25 years.
Loan amount = Purchase price * Mortgage percentage Loan amount = 1,798,400
We can use the formula for the annual mortgage payment:
Annual mortgage payment = Loan amount * [r(1 + r)^n] / [(1 + r)^n – 1]
Where: r = annual interest rate / number of payments per year = 8% / 12 = 0.00667 (monthly interest rate) n = number of payments = 25 years * 12 months/year = 300 payments
Annual mortgage payment = 162,392.04
Then, CFAF is calculated by subtracting the annual mortgage payment from the CFO.
CFAF = CFO - Annual mortgage payment CFAF = 162,392.04 = $49,647.96
c) ROA (Return on Assets)
ROA is calculated by dividing the NOI by the purchase price.
ROA = NOI / Purchase price ROA = 2,248,000 = 0.1105 or 11.05%
d) ROE (Return on Equity)
To calculate ROE, we first need to calculate the equity, which is the purchase price minus the loan amount.
Equity = Purchase price - Loan amount Equity = 1,798,400 = $449,600
Then, ROE is calculated by dividing the CFAF by the equity.
ROE = CFAF / Equity ROE = 449,600 = 0.1105 or 11.05%
Similar Questions
A property with a trailing cap rate of 5.7% was purchased for $28,480,000. The purchase was financed using an interest-only debt of 70% at an interest rate of 5.85% per annum. Capital improvements are $238,000 and structural reserves are $115,000 in Year 1. The income return on equity (ROE) for this property at the end of Year 1 is:
Discounted cash flows applicationsLoans are a very common DCF application in finance.You are buying your first house for $220,000 and are paying $30,000 as a down payment. You have arranged to finance the remaining $190,000 30‐year mortgage with a 7% nominal interest rate and monthly payments. What are the equal monthly payments you must make?
Investment $10,000,000 ROCE 10% Market rate of return 17% Debt Equity 0 1 1 1 2 1 3 1
The ______ is the cost of borrowing or the price paid for the rental of funds expressed as a percentage per year. The chief financial officer (CFO) of a large corporation that wishes to borrow $100 million to construct a factory in the United States should use the ______ market. discount factor; goods discount factor; bond interest rate ; goods interest rate ; bond
What is the estimate for Net New Financing for 2024? Note: Make sure you use the correct positive or negative sign
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.