Skip to content
Question of 29

Q.(Question 8 — internal choice, attempt this

(OR)
the alternative) On 01-04-2024 Vikram borrowed ₹ 6,00,000 from State Bank of India @ 9.6% interest. The period of loan is 36 months. Calculate monthly repayment instalment assuming the instalments are made at the beginning of each month by using PMT function.
Punjab PsebPSEB Punjab Class 12 (Commerce) 2026Subjective· 4mImportance★★★★★
0% · 0/29 Questions
🔒 Locked · start free trial →

You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.

Start your 14-day free trial to unlock the full solution →

=PMT(9.6%/12, 36, -600000, 0, 1) gives about Rs 19,095 per month.

The PMT function calculates the fixed periodic payment of a loan: =PMT(rate, nper, pv, [fv], [type]).

Here: rate = 9.6%/12 = 0.8% per month; nper = 36 months; pv = 6,00,000; fv = 0; type = 1 (payment at the BEGINNING of each month).

Formula: =PMT(9.6%/12, 36, -600000, 0, 1). …

Unlock everything free for 14 days

  • Full step-by-step solutions
  • Concept-first explanations
  • Methods, shortcuts & mistakes
  • PYQ mapping + timed mock tests

Full access for 14 days. No credit card required.