Shulou(Shulou.com)06/03 Report--

What this article shares with you is the function of how sas is used in financial calculation. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

Reorganized:

Some nouns:

Issue: date of issue of securities; first-interest: first day of interest payment of securities; settlement: date of settlement of securities; rate: interest rate; par: par value of securities (default $1000 in sas); frequency: number of coupon payments (1, for annual payment; 2 for semi-annual payment; 4 for quarterly payment); basis: date for setting count day; cost: initial cost of asset; date-purchased: date of asset purchase; end date of first-period; first period Salvage: depreciated value, depreciated value; period: depreciation period; maturity: maturity date of securities; total number of periods nper repaid interest; pv: present value; start-period (last-period): first period (last period) in calculation; Type: as an indicator variable, shows interest payment; Life: effective life of assets; Redemption: maturity date redemption; pr: nominal value of $100 securities; fractionaldollar: valuation in fractional form; fraction: integer denominator of fraction Decimaldollar: decimal list price (with decimal price); coupon: annual coupon rate on securities; yld: annual yield on securities; nominalrate: nominal interest rate; nper: total interest payment period; npery: interest payment period during the year; principal: present value; schedule: details of interest rate, etc.; financerate: interest rate invested in cash flow; reinvestrate: rate of return on reinvested cash flow

ACCRINT

Calculate the accrued interest on regular interest-paying securities.

FINANCE ('ACCRINT', issue, first-interest, settlement, rate, par, frequency,)

ACCRINTM

It is safe to pay interest and calculate accrued interest on the due date.

FINANCE ('ACCRINTM', issue, settlement, rate, par,)

AMORDEGRC

The depreciation coefficient used for each accounting period calculates depreciation.

FINANCE ('AMORDEGRC', cost, date-purchased, first-period, salvage, period, rate,)

AMORLINC

The calculated depreciation for each accounting period.

FINANCE ('AMORLINC', cost, date-purchased, first-period, salvage, period, rate,)

COUPDAYBS

Calculate the number of days from the beginning of the par period to the settlement date.

FINANCE ('COUPDAYBS', date-purchased, first-period, period,)

COUPDAYS

Calculates the number of days of the interest period including the balance sheet date.

FINANCE ('COUPDAYS', settlement, maturity, frequency,)

COUPDAYSNC

Calculate from the number of days on the settlement date to the next interest payment date.

FINANCE ('COUPDAYSNC', settlement, maturity, frequency,)

COUPNCD

Calculate the next interest payment day after the settlement date.

FINANCE ('COUPNCD', settlement, maturity, frequency,)

COUPNUM

Calculate the number of coupons between the payment settlement date and the maturity date.

FINANCE ('COUPNUM', settlement, maturity, frequency,)

COUPPCD

Calculate the last interest payment day before the balance sheet date.

FINANCE ('COUPPCD', settlement, maturity, frequency,)

CUMIPMT

Calculate the accumulated interest paid between two periods.

FINANCE ('CUMIPMT', rate, nper, pv, start-period, end-period,)

CUMPRINC

Calculate the loan payments that accumulate mainly between two periods.

FINANCE ('CUMPRINC', rate, nper, pv, start-period, end-period,)

DB

The depreciation of an asset is calculated by using the fixed declining balance method within a specified period of time.

FINANCE ('DB', cost, salvage, life, period,)

DDB

Use the double declining balance method or some other method you specify to calculate the depreciation of the asset within a specified period of time.

FINANCE ('DDB', cost, salvage, life, period,)

DISC

Calculate the discount rate of securities.

FINANCE ('DISC', settlement, maturity, pr, redemption,)

DOLLARDE

Convert the price of the dollar, expressed as a fraction, that the dollar price is denominated exclusively as a decimal.

FINANCE ('DOLLARDE', fractionaldollar, fraction)

DOLLARFR

Convert the price of the dollar, the decimal number into a fraction.

FINANCE ('DOLLARFR', decimaldollar, fraction)

DURATION

Calculate the one-year period for each periodic interest payment.

EFFECT

Calculate the actual annual interest rate.

FINANCE ('EFFECT', nominalrate, npery)

FV

Calculate the future value of an investment.

FINANCE ('FV', rate, nper,)

FVSCHEDULE

Compound interest calculation initial principal calculation future value.

FINANCE ('FVSCHEDULE', principal, schedule1, schedule2...)

INTRATE

The calculated interest rate of the full investment.

FINANCE ('INTRATE', settlement, maturity, investment, redemption,)

IPMT

Calculate the interest paid on regular investments.

FINANCE ('IPMT', rate, period, nper, pv,)

IRR

Calculate the internal rate of return for a series of cash flows.

FINANCE ('IRR', value1, value2,..., value_n)

MDURATION

Calculate the Macaulay modified holding period for securities with an assumed face value of $100.

FINANCE ('MDURATION', settlement, maturity, coupon, yld, frequency,)

MIRR

Calculate the internal rate of return of positive and negative cash flows at different interest rates.

FINANCE ('MIRR', value1,..., value_n, financerate, reinvestrate)

NOMINAL

Calculate the annual nominal interest rate.

FINANCE ('NOMINAL', effectrate, npery)

NPER

The number of investment periods calculated.

FINANCE ('NPER', rate, pmt, pv,)

NPV

Calculate the net present value of an investment based on a series of periodic cash flows and discount rates.

FINANCE ('NPV', rate, value-1)

ODDFPRICE

Calculate the price of the first issue of securities with a face value of $100.

FINANCE ('ODDFPRICE', settlement, maturity, issue, first-coupon, rate, yld, redemption, frequency,)

ODDFYIELD

Calculate that the first period is odd and expect securities to make a profit.

FINANCE ('ODDFYIELD', settlement, maturity, issue, first-coupon, rate, pr, redemption, frequency

);

ODDLPRICE

Calculate the par value of $100 and the last issue is the expected securities price.

FINANCE ('ODDLPRICE', settlement, maturity, last_interest, rate, yld, redemption, frequency

);

ODDLYIELD

Calculate that the final period is odd and expect securities to make a profit.

FINANCE ('ODDLYIELD', settlement, maturity, last_interest, rate, pr, redemption, frequency

);

PMT

Calculate the annual periodic payment.

FINANCE ('PMT', rate, nper, pv,)

PPMT

Calculate the principal payment of the investment within a certain period of time.

FINANCE ('PPMT'

Rate, per, nper, pv,)

PRICE

Calculate the price of securities with a face value of $100 for regular interest payments.

FINANCE ('PRICE'

Settlement, maturity, rate, yld, redemption

Frequency,)

PRICEDISC

Calculate the price of discounted securities with a face value of $100.

FINANCE ('PRICEDISC'

Settlement, maturity, discount, redemption,)

PRICEMAT

Calculate the price of a security with a face value of $100 due to pay interest.

FINANCE ('PRICEMAT'

Settlement, maturity, issue, rate

Yld,)

PV

Calculate the present value of the investment.

FINANCE ('PV'

Rate, nper, pmt,)

RATE

Calculate the interest rate of the fund for each period.

FINANCE ('RATE'

Nper, pmt, pv,)

RECEIVED

Calculate the amount received on the maturity date of the fully invested securities.

FINANCE ('RECEIVED'

Settlement, maturity, investment, discount,)

SLN

Calculate the straight-line depreciation of assets for one cycle.

FINANCE ('SLN'

Cost, salvage, life)

SYD

Calculated as the total annual depreciation of a fixed-term asset.

FINANCE ('SYD'

Cost, salvage, life, period)

TBILLEQ

Calculate the equivalent yield on treasury bonds.

FINANCE ('TBILLEQ'

Settlement, maturity, discount)

TBILLPRICE

Calculate the price of Treasury bills with a face value of $100.

FINANCE ('TBILLPRICE'

Settlement, maturity, discount)

TBILLYIELD

Calculate the yield on Treasury bills.

FINANCE ('TBILLYIELD'

Settlement, maturity, pr)

VDB

The method of decreasing balance is used to calculate the depreciation of assets at regular or partial periods.

FINANCE ('VDB'

Cost, salvage, life, start-period

End-period,)

XIRR

Calculate the internal rate of return of the schedule of irregular cash flows.

FINANCE ('XIRR'

Values, dates,)

XNPV

Calculate the net present value of non-periodic cash flow schedules.

FINANCE ('XNPV'

Rate, values, dates)

YIELD

Calculate the return on regular interest-bearing securities.

FINANCE ('YIELD'

Settlement, maturity, rate, pr, redemption

Frequency,)

YIELDDISC

Calculate the annual rate of return on discounted securities (for example, Treasury bills).

FINANCE ('YIELDDISC'

Settlement, maturity, rate, pr, redemption,)

YIELDMAT

The calculated annual rate of return on securities that pay interest at maturity.

FINANCE ('YIELDMAT'

Settlement, maturity, issue, rate

Pr,)

These are the functions of how sas is used in financial calculation, and the editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.