Advertisements
Advertisements
प्रश्न
Name and explain the function which returns the future value of an investment which has constant payment and interest.
उत्तर
PMT: The PMT function calculates the periodic payment for an annuity assuming equal payments and a constant rate of interest. The syntax of PMT function is as follows: = PMT (rate, nper, pv, [fv], [type]) where
Rate is the interest rate per period,
Nper is the number of periods,
Pv is the present value or the amount the future payments are worth presently, future value or cash balance that after the last payment is made (a future value of zero when we omit this optional argument) Type is the value 0 for payments made at the end of the period or the value 1 for payments made at the beginning of the period.
The PMT function is often used to calculate the payment for mortgage loans that have a fixed rate of interest.
APPEARS IN
संबंधित प्रश्न
From the following information calculate Operating Profit ratio: Opening Stock Rs 10,000; Purchases Rs 1,20,000; Revenue from operations Rs 4,00,000; Purchase Returns Rs 5,000; Returns from Revenue from operations Rs 15,000; Selling Expenses Rs 70,000; Administrative Expenses Rs 40,000; Closing Stock Rs 60,000.
Bhim International Ltd., in order to raise additional funds for expansion purpose, took a loan of ₹ 10,00,000 at a rate of 12% per annum from NZ Bank on 1st July, 2023, against which it offered ₹ 15,00,000, 8% Debentures of ₹ 100 each as a collateral security.
Calculate the finance cost to the company for the year 2023-24.