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 after tax NPV using a after tax equity discount rate? round your final answer to whole numbers
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 after tax NPV using a after tax equity discount rate? round your final answer to whole numbers
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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