Knowee
Questions
Features
Study Tools

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 2,248,000NOI(netoperatingincome)2,248,000 • NOI (net operating income) 248,440 • Capital Improvements 24,000Structuralreserves24,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.

...expand
🧐 Not the exact question you are looking for?Go ask a question

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 = 248,440248,440 - 24,000 - 12,400CFO=12,400 CFO = 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 = 2,248,000802,248,000 * 80% = 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 = 1,798,400[0.00667(1+0.00667)300]/[(1+0.00667)3001]=1,798,400 * [0.00667(1 + 0.00667)^300] / [(1 + 0.00667)^300 – 1] = 162,392.04

Then, CFAF is calculated by subtracting the annual mortgage payment from the CFO.

CFAF = CFO - Annual mortgage payment CFAF = 212,040212,040 - 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 = 248,440/248,440 / 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 = 2,248,0002,248,000 - 1,798,400 = $449,600

Then, ROE is calculated by dividing the CFAF by the equity.

ROE = CFAF / Equity ROE = 49,647.96/49,647.96 / 449,600 = 0.1105 or 11.05%

This problem has been solved

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

1/2

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.