Scribd
Upload
13 views7 pages

Excel Formulas for Financial Calculations

The document outlines various problems related to financial calculations using formulas in a spreadsheet. It includes methods to calculate amounts, discounts, salaries, bonuses, taxes, and net amounts for sales transactions and employee salaries. Additionally, it provides formulas for calculating interest, VAT, and utility consumption billing amounts.

Uploaded by

ICT Rampur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
13 views7 pages

Excel Formulas for Financial Calculations

The document outlines various problems related to financial calculations using formulas in a spreadsheet. It includes methods to calculate amounts, discounts, salaries, bonuses, taxes, and net amounts for sales transactions and employee salaries. Additionally, it provides formulas for calculating interest, VAT, and utility consumption billing amounts.

Uploaded by

ICT Rampur
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Problem 1:

To calculate the Amount, Discount & Total Amount of following transection of


sales bill.

Formula,
Amount = Quentity * Rate
= C3*D3(Press Enter) C3= Quentity & D3= Rate

Discount = If(Quentity >=15 pcs, Amount*2.5%, Amount*1.9%)


=If(C3>=15,E3*2.5%,E3*1.9%)

Total Amount = Amount – Discount


=E3-f3
Problem 2:
To calculate the Total Salary, Total Emplyee, Highest Salary & Lowest Salary.

Formula,
Total Salary
=Sum(F3:F7)

Total Emp.
=Count(A3:A7)

Highest Salary
=Max(F3:F7)

Lowest Salary
=Min(F3:F7)
Problem 3:
To calculate Bonus, Tax, Net Amount & Grand Total.

Formula
To calculate the Bouns:
=E4*20% (Bonus will give 20% of basic salary)

To calculate Tax:
=E4*10% (Tax will pay 10% of basic salay)

To calculate Net Salary:


=E4+G4-H4 (Basic salary+Bonus-Tax)
Problem 4:
Solve the following transection by using suitable formula.

Formula:
For Hard Disk: For Mouse: For Key Board:
=B2-B2*A13 =B3-B3*A13 =B4-B4*A13
For CPU: For Printer: For Moniter:
=B5-B5*A13 =B6-B6*A13 =B7-B7*A13
For Tv Card: For Pen Drive:
=B8-B8*A13 =B9-B9*A13
problem 6
To calculete Interest, Amount, Amt per year, Amt per mounth & Amt Day.
Interest Calculation

Formula:
Interest:
=C3*D3*E3/100 (PTR/100)

Amount:
=C3+F3 (P+I)

Amt Per Year:


=G3/D3 (A/TIME)

Amt Per Mounth:


=H3/12 ((A/Y)/12)

Amt Day:
=I3/30 ((A/M)/30)
problem 7
To calculete Amount, Tax, Vat, Discount & Net Amount.

Formula:
Amount:
=C2*D2 (Rate×Quantity)
Tax:
=E2*10/100 (Amount × Tax /100)
Vat:
=E2*5% (Amount × Vat/100)
Discount:
=E2*13/100 (Amount × discount/100)
Net Amount:
=E2+F2+G2-H2 (Amount + Tax + Vat - Discount.
problem 9
To calculete Unit Consum & Bill Amt.

Formula:
Unit Consum:
=C3-D3 (Current Unit – previous Unit)

Bill Amt:
=IF(E3<=20,80,IF(E3>=20,(E3-20)*7.3+80))

You might also like