Skip to main content
Super TutorResources
Chapter 9 of 14
Formula Sheet

Use of Spreadsheet in Business Applications — Formula Sheet

Madhya Pradesh Board · Class 12 · Accountancy

12 formulas from Use of Spreadsheet in Business Applications (Madhya Pradesh Board Class 12 Accountancy) on one page, grouped by topic.

80 questions80 flashcards12 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Use of Spreadsheet in Business Applications? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for formula sheet and more.

Try Super Tutor — Free

Free trial, no card needed.

12 Entries · 3 Sections

Formulas and Key Relations

Payroll Accounting

BPE = BP * NOEDP/NODM

NOEDP = (Number of Days in a Month) – (Leave without Pay) – (Unauthorised Absence)

DA = BPE * (Applicable Rate of DA for the Month)

HRA = BPE * (Applicable Rate of HRA for the Month)

TRA = (Fixed Amount) or (On Percentage Basis)

Asset Accounting and Depreciation

Total Amount of Depreciation = Acquisition Cost – Salvage Value

Straight Line Depreciation = Total Depreciable Amount / Expected Useful Life

Rate of Depreciation = (Straight Line Depreciation / Total Depreciable Amount) x 100

SLN function

DB function

Loan Repayment Schedule

Yearly Installment Amt. = PMT(D6,C6,-A6,0,1)

Monthly Installment Amt. = F6/12

Full sheet with units and worked examples

View All

Frequently Asked Questions

What are the important topics in Use of Spreadsheet in Business Applications for Madhya Pradesh Board Class 12 Accountancy?
Key topics in Use of Spreadsheet in Business Applications include Payroll Accounting, Asset Accounting and Depreciation, Loan Repayment Schedule. Study these first, then practise questions on each for the Madhya Pradesh Board Class 12 board exam.
How many formulas are in Use of Spreadsheet in Business Applications?
This sheet lists 12 formulas from Use of Spreadsheet in Business Applications, grouped by topic. Learn what each symbol stands for so you can apply the formula, not just recall it.
How should I revise Use of Spreadsheet in Business Applications for the Madhya Pradesh Board Class 12 board exam?
Learn the core ideas first, then work through the 80 practice questions on Use of Spreadsheet in Business Applications. Revise definitions regularly and use flashcards for quick recall before the exam.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

More resources for Use of Spreadsheet in Business Applications

All Madhya Pradesh Board Class 12 Accountancy Formula Sheet

For serious students

Get the full Use of Spreadsheet in Business Applications chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for Madhya Pradesh Board Class 12 Accountancy. Free to start, no card needed.

Try Super Tutor Free
Try this chapter free