Excel Templates

### How to Use Cost Benefit Analysis Calculator in Excel

What is Cost Benefit Analysis A cost-benefit analysis is the process to measure the benefits of a decision or taking action minus the costs ...

### How to Create an Inventory Cost Carrying Calculator in Excel – 3 Steps

This is an overview of the final output.   Inventory Carrying Cost Formula Inventory Carrying Cost = (Average Inventory x ...

### How to Create Reverse Mortgage Calculator in Excel (With Easy Steps)

Here's an overview of the calculator we'll make. How to Create a Reverse Mortgage Calculator in Excel (With Easy Steps) Step 1 - ...

### How to Create a Reverse EMI Calculator in Excel – 2 Methods

This is an overview:   Method 1 - Using the Goal Seek Feature to Create a Reverse EMI Calculator in Excel Step 1: Establishing ...

### How to Create Fixed Rate Mortgage Calculator in Excel

Microsoft Excel computes costs associated with our mortgages, such as interest and monthly payments, which is one of its powerful features. If you ...

### How to Construct Cost Inflation Index Calculator in Excel

Undoubtedly, Microsoft Excel is a ubiquitous tool for analyzing data and solving complex problems. Now, wouldn’t it be great if we could make a ...

### How to Create Shipping Cost Calculator in Excel: 3 Methods

Method 1 - Gather Data for Shipping Cost per Unit with Tax The dataset contains the shipping details of a shipping corporation if anyone wants any ...

### How to Create Offset Mortgage Calculator in Excel (With Easy Steps)

Here’s an overview of the offset mortgage calculator we’ve prepared for this article. Introduction to Offset Mortgage Offset mortgages ...

### How to Create a Maternity Leave Calculator in Excel – 6 Easy Steps

This is an overview of the maternity leave calculator. It calculates Statutory Maternity Pay (SMP) and Statutory Maternity Leave (SML).   ...

### How to Make Chattel Mortgage Calculator in Excel (with Alternative)

Certainly, Microsoft Excel is a handy and popular tool for analyzing large sets of data. Now, if you are looking to calculate your Chattel Mortgage, ...

### How to Create a Gas Mileage Calculator in Excel – 6 Steps

This is an overview. Step 1 - Enter the Date and the Odometer Reading Insert two columns: Date and Odometer Reading. Enter the ...

### How to Create a Vacation Calendar in Excel – 8 Steps

Create a vacation calendar from 2021 to 2030 with a button to change the year. Step 1 - Add a Spin Button to Select the Year Look at the following ...

### How to Create a Payroll Process Flowchart in Excel – 6 Steps

In a Flowchart each element in the diagram has different shapes. For example, a Rectangle indicates the Start or End of a flowchart. Other shapes ...

### How to Perform an Interest Rate Sensitivity Analysis in Excel – 4 Steps

Step 1 - Select a Dataset to perform the Sensitivity Analysis This is the sample dataset: John takes a loan from a bank: the Loan Amount, ...

### How to Perform Interest Rate Swap Calculation in Excel

Step 1 - Set Up the Format We'll use the following information: Notional Amount - This is the original swap amount for both ...

Advanced Excel Exercises with Solutions PDF