Excel for Finance

How to Make Balance Sheet in Excel (2 Useful Examples)

Example 1 - Horizontal Balance Sheet In the Horizontal balance sheet, the Assets and the Liabilities & Equities columns are shown side by side. ...

How to Calculate Interest Rate in Excel (3 Ways)

Consider the following dataset that we'll use to calculate interest rates. We'll calculate the Monthly and Yearly Interest Rates, as well as the ...

How to Apply a Simple Interest Formula in Excel (with 3 Examples)

  Example 1 - Calculating Simple Interest to be Paid by an Individual with Formula Problem: Chris has taken a loan of  $1,000,000 with a ...

How to Use a Compound Interest Formula in Excel – 4 Methods

The Simple Interest Formula Use this interest formula to calculate the amount of interest: I = Pnr I = calculated simple interest P = ...

How to Do Forecasting on Excel (4 Easy Ways)

Method 1 - Applying FORECAST Function in Excel The FORECAST function calculates or predicts the future value based on a given value. Calculating the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo