Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. an analyst is assigned the task of evaluating a re

An analyst is assigned the task of evaluating a real estate investment project. Purchase price is...

Free

50.1K

Verified Solution

Question

Finance

An analyst is assigned the task of evaluating a real estateinvestment project. Purchase price is $700,000. Using theinformation in the table below, calculate the after-tax cash flowfor the sale of the property.

After-tax cash flow without property sale

$33 546

Straight-line depreciation

$18 700

Mortgage Payment

$59 404

Cumulative Mortgage principle repayments until year 5

$20 783

80% financing at 10% interest rate

Marginal income tax rate

31%

Capital gains tax rate

20%

Forecasted sales price

$927 000

Sales expense as a % of price

6%

Answer & Explanation Solved by verified expert
4.4 Ratings (789 Votes)

Price of property $700,000
Amount of Down payment(20%) $140,000
Pv Amount of Financing (80%) $560,000
Rate interest rate 10%
Pmt Mortgage Payment $59,404
Nper Number of Years of mortgage 30 (Using Nper function of excelwith Rate=10%, Pmt=59404, Pv=-560000)
Excel Command:NPER(10%,59404,-560000)
INTEREST TAX SHIELD
Mortgage Schedule: A B C=A*10% D=B-A E=A-D F=C*31%
Year Beginning Loan Balance MortgagePayment Interest Principal Ending Loan Balance Interest Tax Shield
1 $560,000 $59,404 $56,000 $3,404 $556,596 $17,360
2 $556,596 $59,404 $55,660 $3,744 $552,852 $17,254
3 $552,852 $59,404 $55,285 $4,119 $548,733 $17,138
4 $548,733 $59,404 $54,873 $4,531 $544,202 $17,011
5 $544,202 $59,404 $54,420 $4,984 $539,218 $16,870
ANNUAL DEPRECIATION TAX SHIELD
Annual Depreciation $18,700
Depreciation tax shield $5,797 (18700*31%)
ANNUAL CASH FLOWS
Year After tax cash flow Interest tax shield Depreciation tax shield Mortgage payment Total AnnualCash Flow
1 $33,546 $17,360 $5,797 ($59,404) ($2,701)
2 $33,546 $17,254 $5,797 ($59,404) ($2,807)
3 $33,546 $17,138 $5,797 ($59,404) ($2,923)
4 $33,546 $17,011 $5,797 ($59,404) ($3,050)
5 $33,546 $16,870 $5,797 ($59,404) ($3,191)
TERMINALCASH FLOW
Forecasted Sales Price $927,000
Sales expense(6%) ($55,620)
Net Sales proceeds $871,380
Amount of Capital gain $171,380 (871380-700000)
CapitalGain Tax(20%) ($34,276)
Depreciation Recapture $93,500 (18700*5)
Income tax(31%) ($28,985)
After tax cash flow fromSales $808,119 (871380-34276-28985)
Balance Loan Payment -$539,217 (560000-20783)
Net Terminalcash Flow $268,902 (808119-539217)
YEARWISE NET CASH FLOW
N CF CF/(1.1^N)
YEAR CASH FLOW PV of CASH FLOW
0 ($140,000) ($140,000)
1 ($2,701) -$2,455
2 ($2,807) -$2,319
3 ($2,923) -$2,196
4 ($3,050) -$2,083
(-3191+268902) 5 $265,711 $164,986
SUM $15,932
Net Present value $15,932

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

An analyst is assigned the task of evaluating a real estateinvestment project. Purchase price is $700,000. Using theinformation in the table below, calculate the after-tax cash flowfor the sale of the property.After-tax cash flow without property sale$33 546Straight-line depreciation$18 700Mortgage Payment$59 404Cumulative Mortgage principle repayments until year 5$20 78380% financing at 10% interest rateMarginal income tax rate31%Capital gains tax rate20%Forecasted sales price$927 000Sales expense as a % of price6%

Other questions asked by students

Q

A 200-pound male drinks in 2 hours. What is the maximum number of standard drinks...

Algebra
Q

Choctaw Co. completed the following transactions in Year 1, the first year of operation. Issued 27,000 shares...

Accounting
Q

Vectors can be Select one or more O a inverted O b scaled O c...

Geometry
Q

Learning Goal Given a center and scale factor I can verify that dilating a figure...

Geometry
Q

What is the volume of this triangular pyramid 7 m 12 m 6 m cubic...

Geometry
Q

Find the linearization of the function f(x) =1?49 - xat the point x = 0.

Basic Math
Q

Calculate the unit step response of the system whose governing equation is t de The...

Calculus
Q

Find the following;f(x) = 3x + 1, g(x)=x-16(a) (f+g)(x) =(b) (f-g)(x) =(c) (fg)(x) =(d) (f/g)(x)...

Algebra
Q

Round the decimal to the given place value 41 70483 nearest thousandth 41 70483 rounded...

Algebra
Q

Concord Corporation purchased a machine for $65300 on July 1, 2017. The company intends to...

Accounting
Q

Complete the table below: Bonny Corp. has a defined benefit pension plan for...

Accounting
Q

In Chapter 7 we studied the Master Budget schedules. Read the article, "Warby Parker Debuts...

Accounting