《建筑工程经济与管理》课程设计.docx

1、建筑工程经济与管理课程设计建筑工程经济与管理课程设计工程管理专业使用一、课程设计的目的建筑工程经济与管理课程设计是工程工程专业一门重要的专业主干课建筑工程经济与管理的辅助课程，是建筑工程经济与管理课程的重要实践环节。其目的是为了培养学生综合运用所学理论和方法解决实际问题的能力。本课程设计的任务是，使学生能够掌握财务公式应用的基本步骤、方法，通过财务公式的应用学习，为财务计算或在毕业后从事技术经济评价工作打下良好的基础。二、课程内容一、应用Excel财务计算公式完成下列年金终值表(保留两位小数)表1年金A折现率i(%)计息期n终值F200058￥19,098.223000610￥39,542.3

2、85000712￥89,442.266000815￥162,912.6870005.511￥102,084.49800069￥91,930.539000414￥164,627.2010000316￥201,568.8112000918￥495,616.0614001815￥85,351.37二、应用Excel财务计算公式完成下列现值终值表(结果保留两位小数)表2现值P折现率i(%)计息期n终值F2000582,954.9130006105,372.54500071211,260.96600081519,033.0170005.51112,614.6580006913,515.839000414

3、15,585.091000031616,047.061200091856,605.451400181516,763.25三、应用Excel财务计算公式完成下列年金现值表(结果保留两位小数)表3年金A折现率i(%)计息期n现值P20005812,926.43300061022,080.26500071239,713.43600081551,356.8770005.51156,647.7580006954,413.54900041495,068.1110000316125,611.0212000918105,067.50140018157,128.21四、应用Excel财务计算公式完成下列终值现值

4、表(结果保留两位小数)表4终值F折现率i(%)计息期n现值P2000581,353.6830006101,675.1850007122,220.0660008151,891.4570005.5113,884.378000694,735.1990004145,197.28100003166,231.67120009182,543.92五、应用Excel财务计算公式计算下表6个方案的净现值NPV、内部收益率IRR，计算期均为16年，基准收益率12%。(保留两位小数)表5方案ABCDEF投资600640700750720680年净收益250280310285245210表6ABCDEF期间净现金流量

5、净现金流量净现金流量净现金流量净现金流量净现金流量0￥-600.00￥-640.00￥-700.00￥-750.00￥-720.00￥-680.001￥250.00￥280.00￥310.00￥285.00￥285.00￥210.002￥250.00￥280.00￥310.00￥285.00￥285.00￥210.003￥250.00￥280.00￥310.00￥285.00￥285.00￥210.004￥250.00￥280.00￥310.00￥285.00￥285.00￥210.005￥250.00￥280.00￥310.00￥285.00￥285.00￥210.006￥250.00￥28

6、0.00￥310.00￥285.00￥285.00￥210.007￥250.00￥280.00￥310.00￥285.00￥285.00￥210.008￥250.00￥280.00￥310.00￥285.00￥285.00￥210.009￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0010￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0011￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0012￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0013￥250.

7、00￥280.00￥310.00￥285.00￥285.00￥210.0014￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0015￥250.00￥280.00￥310.00￥285.00￥285.00￥210.0016￥250.00￥280.00￥310.00￥285.00￥285.00￥210.00NPV￥1,143.50￥1,312.72￥1,461.94￥1,237.59￥1,267.59￥784.54IRR41.51%43.62%44.16%37.77%39.39%30.44%六、贷款700000元，期限30年，年利率为6%，若每年年末进行等额本利和

8、还款，试用Excel财务计算函数完成下表。（提示：运用函数PMT、PPMT、IPMT计算，结果保留两位小数。）表7还款计算表期数偿还本金偿还利息本息合计贷款余额1￥-8,854.24￥-42,000.00￥-50,854.24￥-691,145.762￥-9,385.49￥-41,468.75￥-50,854.24￥-681,760.273￥-9,948.62￥-40,905.62￥-50,854.24￥-671,811.654￥-10,545.54￥-40,308.70￥-50,854.24￥-661,266.115￥-11,178.27￥-39,675.97￥-50,854.24￥-650

9、,087.846￥-11,848.97￥-39,005.27￥-50,854.24￥-638,238.877￥-12,559.91￥-38,294.33￥-50,854.24￥-625,678.968￥-13,313.50￥-37,540.74￥-50,854.24￥-612,365.469￥-14,112.31￥-36,741.93￥-50,854.24￥-598,253.1510￥-14,959.05￥-35,895.19￥-50,854.24￥-583,294.1011￥-15,856.59￥-34,997.65￥-50,854.24￥-567,437.5112￥-16,807.99￥-

10、34,046.25￥-50,854.24￥-550,629.5213￥-17,816.47￥-33,037.77￥-50,854.24￥-532,813.0614￥-18,885.45￥-31,968.78￥-50,854.24￥-513,927.6015￥-20,018.58￥-30,835.66￥-50,854.24￥-493,909.0216￥-21,219.70￥-29,634.54￥-50,854.24￥-472,689.3317￥-22,492.88￥-28,361.36￥-50,854.24￥-450,196.4518￥-23,842.45￥-27,011.79￥-50,854.

11、24￥-426,354.0019￥-25,273.00￥-25,581.24￥-50,854.24￥-401,081.0020￥-26,789.38￥-24,064.86￥-50,854.24￥-374,291.6221￥-28,396.74￥-22,457.50￥-50,854.24￥-345,894.8822￥-30,100.55￥-20,753.69￥-50,854.24￥-315,794.3323￥-31,906.58￥-18,947.66￥-50,854.24￥-283,887.7524￥-33,820.97￥-17,033.27￥-50,854.24￥-250,066.7825￥-

12、35,850.23￥-15,004.01￥-50,854.24￥-214,216.5526￥-38,001.25￥-12,852.99￥-50,854.24￥-176,215.3127￥-40,281.32￥-10,572.92￥-50,854.24￥-135,933.9928￥-42,698.20￥-8,156.04￥-50,854.24￥-93,235.7929￥-45,260.09￥-5,594.15￥-50,854.24￥-47,975.7030￥-47,975.70￥-2,878.54￥-50,854.24￥0.00七、应用线性折旧法，利用Excel财务计算公式计算完成，固定资产的线

13、性折旧计算表。（提示：应用SLN函数，保留两位小数）已知：设备原值500000元；折旧年限30年；预计净残值5000元；清理费用2000元。表8年份年净残值年折旧费累计折旧额年末净值0￥500,000.00￥0.00￥0.00￥500,000.001￥483,433.33￥16,566.67￥16,566.67￥483,433.332￥466,866.67￥16,566.67￥33,133.33￥466,866.673￥450,300.00￥16,566.67￥49,700.00￥450,300.004￥433,733.33￥16,566.67￥66,266.67￥433,733.335￥41

14、7,166.67￥16,566.67￥82,833.33￥417,166.676￥400,600.00￥16,566.67￥99,400.00￥400,600.007￥384,033.33￥16,566.67￥115,966.67￥384,033.338￥367,466.67￥16,566.67￥132,533.33￥367,466.679￥350,900.00￥16,566.67￥149,100.00￥350,900.0010￥334,333.33￥16,566.67￥165,666.67￥334,333.3311￥317,766.67￥16,566.67￥182,233.33￥317,76

15、6.6712￥301,200.00￥16,566.67￥198,800.00￥301,200.0013￥284,633.33￥16,566.67￥215,366.67￥284,633.3314￥268,066.67￥16,566.67￥231,933.33￥268,066.6715￥251,500.00￥16,566.67￥248,500.00￥251,500.0016￥234,933.33￥16,566.67￥265,066.67￥234,933.3317￥218,366.67￥16,566.67￥281,633.33￥218,366.6718￥201,800.00￥16,566.67￥29

16、8,200.00￥201,800.0019￥185,233.33￥16,566.67￥314,766.67￥185,233.3320￥168,666.67￥16,566.67￥331,333.33￥168,666.6721￥152,100.00￥16,566.67￥347,900.00￥152,100.0022￥135,533.33￥16,566.67￥364,466.67￥135,533.3323￥118,966.67￥16,566.67￥381,033.33￥118,966.6724￥102,400.00￥16,566.67￥397,600.00￥102,400.0025￥85,833.3

17、3￥16,566.67￥414,166.67￥85,833.3326￥69,266.67￥16,566.67￥430,733.33￥69,266.6727￥52,700.00￥16,566.67￥447,300.00￥52,700.0028￥36,133.33￥16,566.67￥463,866.67￥36,133.3329￥19,566.67￥16,566.67￥480,433.33￥19,566.6730￥3,000.00￥16,566.67￥497,000.00￥3,000.00八、应用年数总和法，利用Excel财务计算公式计算完成，固定资产的线性折旧计算表。（提示：应用SYD函数，保留

18、两位小数）已知：设备原值500000元；折旧年限30年；预计净残值5000元；清理费用2000元。表9年份年净残值年折旧费累计折旧额年末净值0￥500,000.00￥0.00￥0.00￥500,000.001￥467,935.48￥32,064.52￥32,064.52￥467,935.482￥436,939.78￥30,995.70￥63,060.22￥436,939.783￥407,012.90￥29,926.88￥92,987.10￥407,012.904￥378,154.84￥28,858.06￥121,845.16￥378,154.845￥350,365.59￥27,789.25￥1

19、49,634.41￥350,365.596￥323,645.16￥26,720.43￥176,354.84￥323,645.167￥297,993.55￥25,651.61￥202,006.45￥297,993.558￥273,410.75￥24,582.80￥226,589.25￥273,410.759￥249,896.77￥23,513.98￥250,103.23￥249,896.7710￥227,451.61￥22,445.16￥272,548.39￥227,451.6111￥206,075.27￥21,376.34￥293,924.73￥206,075.2712￥185,767.74￥

20、20,307.53￥314,232.26￥185,767.7413￥166,529.03￥19,238.71￥333,470.97￥166,529.0314￥148,359.14￥18,169.89￥351,640.86￥148,359.1415￥131,258.06￥17,101.08￥368,741.94￥131,258.0616￥115,225.81￥16,032.26￥384,774.19￥115,225.8117￥100,262.37￥14,963.44￥399,737.63￥100,262.3718￥86,367.74￥13,894.62￥413,632.26￥86,367.741

21、9￥73,541.94￥12,825.81￥426,458.06￥73,541.9420￥61,784.95￥11,756.99￥438,215.05￥61,784.9521￥51,096.77￥10,688.17￥448,903.23￥51,096.7722￥41,477.42￥9,619.35￥458,522.58￥41,477.4223￥32,926.88￥8,550.54￥467,073.12￥32,926.8824￥25,445.16￥7,481.72￥474,554.84￥25,445.1625￥19,032.26￥6,412.90￥480,967.74￥19,032.2626￥1

22、3,688.17￥5,344.09￥486,311.83￥13,688.1727￥9,412.90￥4,275.27￥490,587.10￥9,412.9028￥6,206.45￥3,206.45￥493,793.55￥6,206.4529￥4,068.82￥2,137.63￥495,931.18￥4,068.8230￥3,000.00￥1,068.82￥497,000.00￥3,000.00九、应用双倍余额递减法，利用Excel财务计算公式计算完成，固定资产的线性折旧计算表。（提示：应用DDB函数，保留两位小数）已知：设备原值500000元；折旧年限30年；预计净残值5000元；清理费用20

23、00元。表10年份年净残值年折旧费累计折旧额年末净值0￥500,000.00￥0.00￥0.00￥500,000.001￥466,666.67￥33,333.33￥33,333.33￥466,666.672￥435,555.56￥31,111.11￥64,444.44￥435,555.563￥406,518.52￥29,037.04￥93,481.48￥406,518.524￥379,417.28￥27,101.23￥120,582.72￥379,417.285￥354,122.80￥25,294.49￥145,877.20￥354,122.806￥330,514.61￥23,608.19￥1

24、69,485.39￥330,514.617￥308,480.30￥22,034.31￥191,519.70￥308,480.308￥287,914.95￥20,565.35￥212,085.05￥287,914.959￥268,720.62￥19,194.33￥231,279.38￥268,720.6210￥250,805.91￥17,914.71￥249,194.09￥250,805.9111￥234,085.52￥16,720.39￥265,914.48￥234,085.5212￥218,479.82￥15,605.70￥281,520.18￥218,479.8213￥203,914.50

25、￥14,565.32￥296,085.50￥203,914.5014￥190,320.20￥13,594.30￥309,679.80￥190,320.2015￥177,632.18￥12,688.01￥322,367.82￥177,632.1816￥165,790.04￥11,842.15￥334,209.96￥165,790.0417￥154,737.37￥11,052.67￥345,262.63￥154,737.3718￥144,421.54￥10,315.82￥355,578.46￥144,421.5419￥134,793.44￥9,628.10￥365,206.56￥134,793.4

26、420￥125,807.21￥8,986.23￥374,192.79￥125,807.2121￥117,420.06￥8,387.15￥382,579.94￥117,420.0622￥109,592.06￥7,828.00￥390,407.94￥109,592.0623￥102,285.92￥7,306.14￥397,714.08￥102,285.9224￥95,466.86￥6,819.06￥404,533.14￥95,466.8625￥89,102.40￥6,364.46￥410,897.60￥89,102.4026￥83,162.24￥5,940.16￥416,837.76￥83,162.2427￥77,618.09￥5,544.15￥422,381.91￥77,618.0928￥72,443.55￥5,174.54￥427,556.45￥