Question

In: Finance

Compute the cash flow, tax flow, and after tax flow for the following real estate investment...

Compute the cash flow, tax flow, and after tax flow for the following real estate investment property:

-Gross rents are expected to be $36,000 per year

-Expected vacancy allowance is 5% of gross rents

-Property management fees are 8% of rents collected

-Total estimated operating expenses per year $7,200

-Payment of mortgage per year:

Interest 12,000

Principal 3,000

Total 15,000

-Depreciation allowance for the year is $14,350

-The owner's earned income is $100,000 and his marginal tax bracket is 30%

Compute the following:

A) Before tax cash flow

B) Tax flow (taxable income or loss from property annual operation)

C) Income taxes due or tax savings from annual operation of this investment property

D) Annual after tax cash flow from the property

Solutions

Expert Solution

A) Before tax cash flow = Gross rent - Vacancy allowance @ 5% of gross rent - Management fee @ 8% of net collected - Operating expenses - Payment of mortgage (interest and principal) + Earned income

Before tax caah flow = $36,000 - ($36,000 * 5%) - ($36,000 * 95% * 8%) - $7,200 - $15,000 + $1,00,000

Before tax cash flow = $36,000 - $1800 - $2736 -$7,200 - $15,000 = $1,09,264

B) Taxable income = Before tax cash flow + Principal payment of mortgage - Depriciation

Taxable income = $1,09,264 + $3,000 - 14,350= $97,914

C) Income tax due = Taxable income * Tax rate = $97,914 * 30% = $29,374.20

D) Annual after tax cash flow = Before tax cash flow - Income tax due = $1,09,264 - $29,374.20


Related Solutions

You are presented with a real estate investment with cash flow in year 1 of $100,000,...
You are presented with a real estate investment with cash flow in year 1 of $100,000, increasing by $5,000 per year through year 5. And, you estimate you can sell the deal at the end of the 5th year for $1,250,000. If your discount rate is 12%, should you buy the deal at the $1,100,000 asking price? A) Yes, because the IRR is a positive 9.34% B) No, because the NPV is a negative $33,455 C) Yes, because the NPV...
Calculate the After-Tax Cash Flow, NPV (at minimum ROR=20%) and ROR for the following investment with...
Calculate the After-Tax Cash Flow, NPV (at minimum ROR=20%) and ROR for the following investment with 6 years life time: -The investor is a Non-integrated petroleum company -Total producible oil in the reserve is estimated to be 2,400,000 barrel -Production rate will be 400,000 barrel of oil per year from year 1 to year 6 -Mineral rights acquisition cost for property would be $1,600,000 at time zero -Intangible drilling cost (IDC) is expected to be $7,000,000 at time zero -Tangible...
A real estate investment has the following expected cash flows:                         Year       
A real estate investment has the following expected cash flows:                         Year           Cash Flows                           1              $9,000                           2               13,000                           3               18,000                           4               25,000 The discount rate is 12 percent. What is the investment’s present value? Round your answer to 2 decimal places; for example 2345.25.
a) What is the Before Tax Cash Flow? b) What is the After Tax Cash Flow?...
a) What is the Before Tax Cash Flow? b) What is the After Tax Cash Flow? Given: Annual Debt Service                            $20,876             Vacancy & Collection Loss 5%             Depreciation                                       11,000             PGI                                                      46,200             Interest                                               1,700             Operating Expenses                            18,400             Marginal Tax Rate                              28%                         All numbers are annual If possible, please use a financial calculator and show me how to solve as I need to learn this concept for this class.
Consider the following cash flow of an investment and compute the ROR using a trial and...
Consider the following cash flow of an investment and compute the ROR using a trial and error method. Year 0 1 2 3 4 5 6 7 8 9 10 Cash Flow -$5,000 $100 $100 $100 $100 $100 $100 $100 $100 $100 $7100 What will be your decision on this investment if the MARR is 5%?
Compute the IRR on the following cash flow streams: a. An initial investment of $22,482 followed...
Compute the IRR on the following cash flow streams: a. An initial investment of $22,482 followed by a single cash flow of $32,290 in year 6. (Round answer to 2 decimal places, e.g. 5.25%.) IRR % ____ b. An initial investment of $1,229,844 followed by a single cash flow of $1,864,300 in year 4. (Round answer to 2 decimal places, e.g. 5.25%.) IRR % _____ c. An initial investment of $1,749,912 followed by cash flows of $1,585,900 and $1,108,200 in...
If the tax rate is 40 percent, compute the before-tax real interest rate and the after-tax...
If the tax rate is 40 percent, compute the before-tax real interest rate and the after-tax real interest rate. (answer in percentages. If whole percentages, do not need decimals. If have decimals, round to nearest hundredth of percent) Show all steps clearly assume multiplying percentages by $100 before-tax real interest rate = nominal interest rate - inflation rate reduction in nominal interest = nominal interest rate multiplied by tax rate after-tax nominal interest rate = nominal interest rate - reduction...
For each of the following independent situations, compute the net after-tax cash flow amount by subtracting cash outlays for operating expenses and income taxes from cash revenue.
After-Tax Cash FlowsFor each of the following independent situations, compute the net after-tax cash flow amount by subtracting cash outlays for operating expenses and income taxes from cash revenue. The cash outlay for income taxes is determined by applying the income tax rate to the cash revenue received less the cash and noncash (depreciation) expenses.ABCCash revenue received$94,000$454,000$224,000Cash operating expenses paid58,000319,000149,000Depreciation on tax return16,00034,00024,000Income tax rate40%30%20%Do not use negative signs with any of your answers below.ABCCash revenue$Answer$Answer$AnswerCash outlays:Operating expensesAnswerAnswerAnswerIncome taxesAnswerAnswerAnswerTotal cash...
A real estate investor feels that the cash flow from a property will enable her to...
A real estate investor feels that the cash flow from a property will enable her to pay a lender $18,000 per year, at the end of every year, for 10 years. How much should the lender be willing to loan her if he requires a 9% annual interest rate (annually compounded, assuming the first of the 10 equal payment arrives one year from the date the loan is disbursed) The answer was 115,517.83 Can you show the work. Thanks
A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2...
A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2 17,000 3 22,000 4 22,000 The discount rate is 11 percent. What is the investment’s present value? Round it to two decimal places, i.e., 1234.45.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT