Angus Cartwright III Financial Analysis Essay

Submitted By Anthony-Furia
Words: 1084
Pages: 5
Open Document
Breakdown of Returns (Cash Flow, Tax, Future Value)

Allison Green

IRR:
14.93%

Cash Flow Before Tax Income Tax Consequences Futures Total
Year
Actual
Discounted

Actual
Discounted

Actual
Discounted

Actual
Discounted
0

1
$434,307
$377,902

($91,865)
($79,935)

$0
$0

$342,441
$297,968
2
$460,413
$348,589

($102,596)
($77,678)

$0
$0

$357,816
$270,911
3
$487,302
$321,031

($113,697)
($74,903)

$0
$0

$373,605
$246,128
4
$514,998
$295,214

($125,181)
($71,758)

$0
$0

$389,816
$223,456
5
$543,524
$271,103

($137,064)
($68,366)

$0
$0

$406,461
$202,737
6
$572,907
$248,647

($149,360)
($64,823)

$0
$0

$423,547
$183,823
7
$603,171
$227,783

($162,085)
($61,210)

$0
$0

$441,086
$166,573
8
$634,343
$208,444

($175,256)
($57,589)

$0
$0

$459,087
$150,855
9
$666,450
$190,553

($188,890)
($54,008)

$0
$0

$477,560
$136,545
10
$699,520
$174,033 ($203,005)
($50,505)

$6,421,018
$1,597,477

$6,917,534
$1,721,004
Total
$5,616,933
$2,663,298

($1,448,999)
($660,775)

$6,421,018
$1,597,477

$10,588,952
$3,600,000
Percent

73.98%

-18.35%

44.37%

100.00%

Stony Walk

IRR:
14.54%

Cash Flow Before Tax Income Tax Consequences Futures Total
Year
Actual
Discounted

Actual
Discounted

Actual
Discounted

Actual
Discounted
0

1
$331,149
$289,112

($123,260)
($107,613)

$0
$0

$207,889
$181,499
2
$362,865
$276,587

($139,048)
($105,987)

$0
$0

$223,816
$170,600
3
$395,532
$263,216

($155,474)
($103,464)

$0
$0

$240,058
$159,752
4
$429,180
$249,352

($172,568)
($100,261)

$0
$0

$256,612
$149,091
5
$463,837
$235,279

($190,360)
($96,559)

$0
$0

$273,476
$138,719
6
$499,533
$221,221

($208,885)
($92,505)

$0
$0

$290,649
$128,715
7
$536,301
$207,354

($228,176)
($88,221)

$0
$0

$308,125
$119,133
8
$574,171
$193,816

($248,270)
($83,806)

$0
$0

$325,901
$110,010
9
$613,178
$180,708

($269,207)
($79,337)

$0
$0

$343,971
$101,371
10
$653,355
$168,106 ($291,027)
($74,880)

$8,347,871
$2,147,883

$8,710,199
$2,241,109
Total
$4,859,102
$2,284,752

($2,026,276)
($932,635)

$8,347,871
$2,147,883

$11,180,696
$3,500,000
Percent

65.28%

-26.65%

61.37%

100.00%

Ivy Terrace

IRR:
15.13%

Cash Flow Before Tax Income Tax Consequences Futures Total
Year
Actual
Discounted

Actual
Discounted

Actual
Discounted

Actual
Discounted
0

1
$336,131
$291,961

($42,086)
($36,555)

$0
$0

$294,045
$255,405
2
$359,102
$270,925

($51,587)
($38,920)

$0
$0

$307,515
$232,006
3
$382,762
$250,829

($61,416)
($40,247)

$0
$0

$321,346
$210,582
4
$407,132
$231,739

($71,587)
($40,747)

$0
$0

$335,545
$190,992
5
$432,233
$213,697

($82,113)
($40,597)

$0
$0

$350,120
$173,100
6
$458,087
$196,718

($93,006)
($39,940)

$0
$0

$365,081
$156,778
7
$484,717
$180,801

($104,282)
($38,897)

$0
$0

$380,435
$141,903
8
$512,145
$165,929

($115,954)
($37,568)

$0
$0

$396,191
$128,361
9
$540,397
$152,075

($128,039)
($36,032)

$0
$0

$412,358
$116,043
10
$569,496
$139,204 ($140,552)
($34,356)

$4,868,339
$1,189,982

$5,297,283
$1,294,830
Total
$4,482,202
$2,093,876

($890,621)
($383,858)

$4,868,339
$1,189,982

$8,459,920
$2,900,000
Percent

72.20%

-13.24%

41.03%

100.00%

Fowler Building

IRR:
15.38%

Cash Flow Before Tax Income Tax Consequences Futures Total
Year
Actual
Discounted

Actual
Discounted

Actual
Discounted

Actual
Discounted
0

1
$90,325
$78,284

$11,454
$9,927

$0
$0

$101,779
$88,211
2
$121,857
$91,534

($2,285)
($1,717)

$0
$0

$119,572
$89,818
3
$154,651
$100,681

($16,669)
($10,852)

$0
$0

$137,982
$89,830
4
$188,756
$106,503

($31,729)
($17,903)

$0
$0

$157,026
$88,600
5
$224,225
$109,651

($47,502)
($23,229)

$0
Show More

Related Documents: Angus Cartwright III Financial Analysis Essay

Angus Cartwright III Case Study v2 Essay

RES 9776 – Spring 2015 Real Estate Finance Professor: Stephen J. Pearlman Case Study - Angus Cartwright III Joonho Kim Yan Chen Qinqin (Renee) Yang Jae Paik Contents I. Case Overview 2 II. Analysis and Assumptions 2 III. Financial Analysis 4 IV. Recommendations Reasoning 5 Appendix 6 Exhibit 5 Exhibit 8 I. Case Overview Angus Cartwright III, an investment advisor, was asked to provide investment advisory services for two clients…

Words 1464 - Pages 6

Real Estate Decision Making

investment. While there are no prerequisites for this course (other than a keen interest in the subject area), students should be reasonably comfortable working with numbers. For the most part, the mathematical calculations involved in real estate analysis are very straightforward. There will be a moderately heavy (but interesting) reading load (with which students are expected to keep up) and frequent short exercises. SURP 841 - Fall 2011 – Course Outline Page 2 of 7 Course Format The…

Words 2314 - Pages 10

Angus Catwright Case Essay

Angus Cartwright III Case Exhibit 1 gives us an overview of each of the properties, such as the gross purchase price, the depreciable base, estimated sales prices, the amount of the first mortgage and so forth. These assumptions are significant to the calculations used throughout the entire case. In Exhibit 2 we find the first-year project setups. This is important information because we can see how much each real estate property will cost in the first year. This information is also useful…

Words 1710 - Pages 7