Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You are an employee of a consultant company and have been given the following information to do an investment analysis of a new small income
You are an employee of a consultant company and have been given the following information to do an investment analysis of a new small incomeproducing property for sale to a potential investor. What is the investors after tax IRR? round your final answer to decimals Asking Price $ Rent Year $ Growth Rent Vacancy and Coll Loss of rents Expenses of EGI Appreciation Rate Tax Considerations Building Value $ Depreciation years Ordinary Income Tax Rate Capital Gains Tax Rate Depreciation Recapture Tax Rate LTV Loan Interest Loan Term years Payments Per Year Holding Period years Selling Costs of sale price Equity Discount Rate After Tax Equity Discount Rate The above information results in the following investment analysis. Equity $ Loan $ Annual Loan Payment $ Mortgage Balance $ year Summary Loan Information End of Year Payment $ $ $ Mortgage Balance $ $ $ Interest $ $ $ Principal $ $ $ Year PGI $ $ $ VCL $ $ $ EGI Expenses $ $ $ NOI $ $ $ Debt Service $ $ $ BTCF NOI $ $ $ Less: Interest $ $ $ Less Depreciation $ $ $ Taxable Income $ $ $ TaxSavings $ $ $ ATCF Cash Flow from Sale in Year Sale Price $ Sales Costs $ Mortgage Balance $ BTCF Original Cost Basis $ Accumulated Depreciation $ Adjusted Basis $ Capital Gain $ Depreciation Recapture $ Price Appreciation $ Tax on Price Appreciation $ Tax on Depreciation Recapture $ Total Capital Gain Tax $ After Tax Cash Flow from Sale What is the investors after tax IRR? round your final answer to decimals
You are an employee of a consultant company and have been given the following information to do an investment analysis of a new small incomeproducing property for sale to a potential investor. What is the investors after tax IRR? round your final answer to decimals
Asking Price
$
Rent Year
$
Growth Rent
Vacancy and Coll Loss
of rents
Expenses
of EGI
Appreciation Rate
Tax Considerations
Building Value
$
Depreciation
years
Ordinary Income Tax Rate
Capital Gains Tax Rate
Depreciation Recapture Tax Rate
LTV
Loan Interest
Loan Term
years
Payments Per Year
Holding Period
years
Selling Costs
of sale price
Equity Discount Rate
After Tax Equity Discount Rate
The above information results in the following investment analysis.
Equity
$
Loan
$
Annual Loan Payment
$
Mortgage Balance
$
year
Summary Loan Information
End of Year
Payment
$
$
$
Mortgage Balance
$
$
$
Interest
$
$
$
Principal
$
$
$
Year
PGI
$
$
$
VCL
$
$
$
EGI
Expenses
$
$
$
NOI
$
$
$
Debt Service
$
$
$
BTCF
NOI
$
$
$
Less: Interest
$
$
$
Less Depreciation
$
$
$
Taxable Income
$
$
$
TaxSavings
$
$
$
ATCF
Cash Flow from Sale in Year
Sale Price
$
Sales Costs
$
Mortgage Balance
$
BTCF
Original Cost Basis
$
Accumulated Depreciation
$
Adjusted Basis
$
Capital Gain
$
Depreciation Recapture
$
Price Appreciation
$
Tax on Price Appreciation
$
Tax on Depreciation Recapture
$
Total Capital Gain Tax
$
After Tax Cash Flow from Sale
What is the investors after tax IRR? round your final answer to decimals
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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