Net present value calculation

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

There are a couple of functions(NPV, NETPV) in SAS .


NETPV(r,freq,c0,c1,...,cn)

NPV(r,freq,c0,c1,...,cn)

It is convenient if the cashflows are uneven for each period.

When the cashflows are the same for each period. You can use the mort function.
Here is an example. Suppose that monthly cashflow is 7000, annual intest rate is 7% and period=30 years.

The present value=1052152.9756 ~1 million.   Or in other words your monthly payment is 7000 when you borrow 1 million yuan from a bank with a contract of 7% and 30 years to buy a house. A morgage payment is usually below 1/3 of your income. So you need a yearly salary 7000*3*12 ~250000 Yuan; otherwise renting a house is a better choice.


30
31   data _null_;
32      npv=1000000;
33      rate=0.07; *annual intest rate;
34      term=12*30;*30 years;
35      npv=mort(.,7000,rate/12,term);
36      put npv=;
37   run;

npv=1052152.9756
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Calculation Present ulation ATION value present