精品最新来自国外的房地产投资财务评估的第手资料Word下载.docx
- 文档编号:18268766
- 上传时间:2022-12-14
- 格式:DOCX
- 页数:43
- 大小:45.86KB
精品最新来自国外的房地产投资财务评估的第手资料Word下载.docx
《精品最新来自国外的房地产投资财务评估的第手资料Word下载.docx》由会员分享,可在线阅读,更多相关《精品最新来自国外的房地产投资财务评估的第手资料Word下载.docx(43页珍藏版)》请在冰豆网上搜索。
$283,500
$284,850
$286,200
$287,550
$288,900
Costsofsale
[2]
($25,000)
($10,000)
Landplusbuyingcosts
($234,000)
Designfees
($60,000)
($45,338)
Buildingcosts
($157,813)
($158,594)
($159,375)
($160,156)
($32,800)
Projectcashflowsbeforetax
$0
$65,544
$274,850
$276,200
$277,550
$278,900
RESULTS
Netpresentvalueatamonthlyrateof
4%
$16,607
Internalrateofreturn
4.27%
51.28%perannum
Workbook6.3:
DemonstratingMultipleIRRsWithinOneSetofCashFlows.
ProjectDataandCalculations.
EOY0
EOY1
EOY2
CashFlows
-190
455
-270
CalculatedIRR=
8.49%
CalculatedNPV=
$1.37
DataTableofNPVsatVariousRatesofReturn
ReqdRate
14.00%
Rate
NPV
0.00%
-$5.00
1.00%
-$4.18
2.00%
-$3.44
3.00%
-$2.75
-$2.13
5.00%
-$1.56
6.00%
-$1.05
7.00%
-$0.59
8.00%
-$0.19
9.00%
$0.18
10.00%
$0.50
11.00%
$0.77
12.00%
$1.01
13.00%
$1.21
15.00%
$1.49
16.00%
$1.59
17.00%
$1.65
18.00%
$1.68
19.00%
$1.69
20.00%
$1.67
21.00%
$1.62
22.00%
$1.55
23.00%
$1.45
24.00%
$1.34
25.00%
$1.20
26.00%
$1.04
27.00%
$0.87
28.00%
$0.67
29.00%
$0.46
30.00%
$0.24
31.00%
-$0.01
32.00%
-$0.26
33.00%
-$0.53
34.00%
-$0.82
35.00%
-$1.11
Workbook6.4:
DemonstratingNoIRRSolutionWithinOneSetofCashFlows.
ShowingthatValidNPVSolutionExists,evenwhenIRRcannotbeComputed.
ProjectDataandComputations
-210
#NUM!
-$18.63
RequiredRate
-$24.18
-$23.44
-$22.75
-$22.13
-$21.56
-$21.05
-$20.59
-$20.19
-$19.82
-$19.50
-$19.23
-$18.99
-$18.79
-$18.51
-$18.41
-$18.35
-$18.32
-$18.31
-$18.33
Workbook6.5:
DemonstratingConflictBetweenIRRandNPVinMutuallyExclusiveInvestments.
WithPlotofNPVProfiles
PROJECTA
-2000
200
3700
41.11%
$1,297.70
PROJECTB
2000
1480
49.50%
$1,080.55
DATATABLEFORNPVPROFILES
ReqdRates
NPVA
NPVB
0%
$1,900.00
$1,480.00
1%
$1,825.12
$1,431.04
2%
$1,752.40
$1,383.31
3%
$1,681.78
$1,336.79
$1,613.17
$1,291.42
5%
$1,546.49
$1,247.17
6%
$1,481.67
$1,203.99
7%
$1,418.64
$1,161.85
8%
$1,357.34
$1,120.71
9%
$1,297.70
$1,080.55
10%
$1,239.67
$1,041.32
11%
$1,183.18
$1,003.00
12%
$1,128.19
$965.56
13%
$1,074.63
$928.97
14%
$1,022.47
$893.20
15%
$971.64
$858.22
16%
$922.12
$824.02
17%
$873.84
$790.56
18%
$826.77
$757.83
19%
$780.88
$725.80
20%
$736.11
$694.44
21%
$692.44
$663.75
22%
$649.83
$633.70
23%
$608.24
$604.27
24%
$567.64
$575.44
25%
$528.00
$547.20
26%
$489.29
$519.53
27%
$451.48
$492.40
28%
$414.55
$465.82
29%
$378.46
$439.76
30%
$343.20
$414.20
31%
$308.72
$389.14
32%
$275.02
$364.55
33%
$242.07
$340.44
34%
$209.85
$316.77
35%
$178.33
$293.55
36%
$147.49
$270.76
37%
$117.32
$248.39
38%
$87.80
$226.42
39%
$58.90
$204.85
40%
$30.61
$183.67
41%
$2.92
$162.87
42%
($24.20)
$142.43
43%
($50.76)
$122.35
44%
($76.77)
$102.62
45%
($102.26)
$83.23
46%
($127.23)
$64.18
47%
($151.70)
$45.44
48%
($175.68)
$27.03
49%
($199.18)
$8.92
50%
($222.22)
($8.89)
Workbook6.6:
ProjectRankingWithinMutuallyExclusiveProjects.
DemonstratingConfictRankingBetweenNPVandIRR,ProjectsBigandSmall.
ProjectsBS,DataandComputations
EOY3
ProjectB
CashFlows
-100000
147000
ProjectS
-100
350
COMMENTS
IRR
B
$10,443.28
13.70%
UsingNPV,SelectBig.
S
$162.96
51.83%
UsingIRR,SelectSmall
Workbook6.7DemonstratingNPVandIRRConflictWithTimingPatternDifferences.
WithinMutuallyExclusiveProjects.
ProjectsNandF,ProjectDataandComputations
ProjectN
-1150
1000
400
100
ProjectF
500
1100
N
$164.80
21.48%
UsingNPV,SelectF
F
$180.58
16.50%
UsingIRR,SelectN
WorkSheet6.7:
Extension
DemonstratingConflictBewteenIRRandNPVinMutuallyExclusiveInvestments
NPVN
NPVF
$350.00
$550.00
$329.28
$506.81
$309.09
$465.18
$289.43
$425.04
$270.26
$386.33
$251.58
$348.97
$233.36
$312.92
$215.58
$278.10
$198.24
$244.48
$181.32
$211.98
$148.67
$150.21
$132.91
$120.84
$117.52
$92.42
$102.48
$64.92
$87.77
$38.30
$73.40
$12.51
$59.34
$12.47
$45.59
$36.67
$32.14
$60.13
$18.98
$82.87
$6.10
$104.93
$6.51
$126.32
$18.86
$147.09
$30.95
$167.24
$42.80
$186.80
$54.41
$205.80
$65.78
$224.25
$76.93
$242.18
$87.85
$259.60
$98.57
$276.54
$109.07
$293.00
$119.38
$309.01
$129.49
$324.59
$139.40
$339.74
$149.14
$354.49
36.00%
$158.69
$368.85
37.00%
$168.07
$382.82
38.00%
$177.27
$396.43
39.00%
$186.31
$409.68
40.00%
$195.19
$422.59
41.00%
$203.91
$435.18
42.00%
$212.48
$447.44
43.00%
$220.89
$459.39
44.00%
$229.16
$471.04
45.00%
$237.29
$482.40
46.00%
$245.28
$493.49
47.00%
$253.14
$504.30
48.00%
$260.86
$514.85
49.00%
$268.46
$525.14
50.00%
$275.93
$535.19
Workbook6.8:
DemonstratingReplacementChainNPVCalculations.
CashFlowData:
TheNPVValueateachreplicationdate
Project
Short
$627
Long
$1,582
RESULTS:
CurrentNPVsofReplications
$1,715[1]
Workbook6.9:
CalculatingOptimumReplacementTimingWithinanInf
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 精品 最新 来自 国外 房地产 投资 财务 评估 资料
![提示](https://static.bdocx.com/images/bang_tan.gif)