Excel for Finance

How to Calculate Income Tax on Salary with Old Regime in Excel

The income tax is a tax imposed on individuals in respect of their income or profits. Frequently, you need to calculate the income tax on salary by ...

How to Calculate Bond Price with Negative Yield in Excel (2 Easy Ways)

People need to calculate the Bond Price considering the future value of the Bond. Some of the Bonds have the risk of having a Negative Yield. If you ...

How to Calculate Simple Interest and Compound Interest in Excel (2 Ways)

  What Is Simple Interest? Simple Interest doesn’t compound. In other words, Simple Interest is the interest calculated on the principal ...

How to Calculate EMI for Bike Loan in Excel (2 Easy Methods)

MS Excel is a powerful software. Here, we can perform many different mathematical operations. It provides numerous built-in functions which are ...

How to Calculate Income Tax on Salary with Example in Excel

In this article, we will demonstrate different methods to calculate Income Tax on Salary. To illustrate our methods, we'll use the following sample ...

How to Calculate Price of a Semi Annual Coupon Bond in Excel (2 Ways)

If you are looking for some special tricks to calculate the price of a semi-annual coupon bond in Excel, you've come to the right place. There are ...

How to Calculate Clean Price of a Bond in Excel (3 Easy Ways)

Generally, on financial news sites, the clean price of a bond is the quoted price. The price doesn’t include accrued interest. The clean price is ...

How to Forecast in Excel Based on Historical Data (4 Methods)

What Is Forecasting? Forecasting is an essential approach that leverages historical data to make educated predictions about future trends. ...

How to Calculate Face Value of a Bond in Excel (3 Easy Ways)

In this article we will demonstrate 3 different formulas to calculate the face value of a bond in Excel. Bond and Face Value A bond is a ...

How to Calculate Bond Payments in Excel (2 Easy Methods)

Method 1 - Using the PMT Function to Calculate Bond Payments Per Month in Excel We have a dataset containing the data on Bond Amount, Annual ...

Calculate Bond Price from Yield in Excel (3 Easy Ways)

Bond yield is the rate of return of an investment made to purchase a bond. The ratio between the Coupon/Interest Payment and the Bond Price is ...

How to Calculate Income Tax in Excel Using IF Function (With Easy Steps)

  Step 1 - Set up Income Tax Slab To illustrate how to calculate taxes, we’ll use the following tax rate sample: A flat 7% for incomes 0 ...

Reverse Tax Calculation Formula in Excel (Apply with Easy Steps)

Here is a sample dataset to calculate the reverse tax calculation formula. The dataset comprises product names, MRP and Tax rates in cells B4:D9. ...

How to Calculate Simple Interest Loan Payments in Excel

In this article, I’m going to explain how to Calculate Simple Interest Loan Payments in Excel. Here, I have described five methods of calculating ...

Convert Compound Interest to Simple Interest in Excel (with Easy Steps)

Excel is the most widely used tool when it comes to dealing with huge datasets. We can perform myriads of tasks of multiple dimensions in Excel. It ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo