1 / 9

FINANCIAL FUNCTIONS

FINANCIAL FUNCTIONS. MGMI 311. Type of Financial Functions. Asset Depreciation Calculations (คำนวณค่าเสื่อมราคา) Investment Valuation Functions (คำนวณการประเมินค่าโครงการลงทุน) Loan Amortization Functions (คำนวณหาเงินต้น และดอกเบี้ยที่ต้องชำระในแต่ละงวด)

oprah
Télécharger la présentation

FINANCIAL FUNCTIONS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FINANCIAL FUNCTIONS MGMI 311

  2. Type of Financial Functions • Asset Depreciation Calculations (คำนวณค่าเสื่อมราคา) • Investment Valuation Functions (คำนวณการประเมินค่าโครงการลงทุน) • Loan Amortization Functions (คำนวณหาเงินต้น และดอกเบี้ยที่ต้องชำระในแต่ละงวด) • Financial Market Instruments Calculations (คำนวณเกี่ยวกับตราสารทางการเงิน)

  3. 1. Asset Depreciation Calculation • DB - Fixed-Declining Balance • DDB - Double-Declining Balance • SLN - Straight-Line Depreciation • SYD - Sum-of-Years' Digits • VDB - Variable Declining Balance

  4. 1. Asset Depreciation Calculation • What are your company ‘Fixed Asset’? ในการดำเนินธุรกิจของกลุ่ม มีการลงทุนในสินทรัพย์ถาวรใดบ้าง ที่ต้องนำมาคำนวณค่าเสื่อมราคาในงบการเงินประจำปี • How would you calculate depreciation cost for each asset? สินทรัพย์แต่ละรายการ คำนวณค่าเสื่อมราคาด้วยวิธีใด Workshop : GroupXX_week06

  5. 1. Asset Depreciation Calculation • Cost The initial cost of the asset • Salvage The value of the asset at the end of the depreciation • Life The number of periods over which the asset is to be depreciated • Period The period number for which you want to calculate the depreciation • [Month] The number of months calculated for the first depreciation, otherwise = 12 • [Factor] The rate of depreciation, otherwise =2

  6. 2. Loan Amortization Functions • IPMT - Interest Payment for an investment or loan • PMT - Periodic Payment for an annuity • PPMT - Payment on the Principal for an annuity or loan Workshop : GroupXX_week06

  7. 3.Investment Valuation Functions • FV - Future Value of an investment • IPMT - Interest Payment for an investment or loan • IRR - Internal Rate of Return • NPER - Number of Periods for an investment or loan • NPV - Net Present Value formula • PMT - Periodic Payment for an annuity • PPMT - Payment on the Principal for an annuity or loan • PV - Present Value of an investment • RATE - Interest rate per period

  8. 3.Investment Valuation Functions • What is your company short-term investment plan? ( < 5 years) ระบุแผนการลงทุนในระยะสั้น • Details of the specified investment • Period of Investment • Interest rate (if known) • Amount received after investment

  9. 3.Investment Valuation Functions • Rate Interest Rate • NPER Number of Period • Pmt Payment each period • PV Present Value of the Money (default value = 0) • Type 1 : payment made at the start of the period 0 : payment made at the end of the period (default value = 0) • FV Future Value of the Money

More Related