## 11 financial calculations that you can’t do in EXCEL

By Charles Flock on 10/18/2011 8:16 PM
Here is a list of 11 very simple financial calculations that you can’t do in EXCEL, either because the EXCEL design of a function doesn’t support the input data, or because EXCEL produces a result that is wrong  or unreliable. Of course, we used EXCEL 2010 and, of course, you can do them in SQL Server using XLeratorDB.
Part 1 of 11 - Enter a negative yield to calculate the price of a bond

## Enter a negative rate into the XNPV function

By Charles Flock on 10/18/2011 8:15 PM
11 Financial Calculations that you can’t do in EXCEL - Part 2 of 11

## Rely on the results of the XIRR function

By Charles Flock on 10/18/2011 8:14 PM
11 Financial Calculations that you can’t do in EXCEL - Part 3 of 11

## Calculate the price (or yield) of a bond on its issue date when it has an odd first period

By Charles Flock on 10/18/2011 8:13 PM
11 Financial Calculations that you can’t do in EXCEL - Part 4 of 11

## Correctly calculate the accrued interest on a bond with an odd first period

By Charles Flock on 10/18/2011 8:13 PM
11 Financial Calculations that you can’t do in EXCEL - Part 5 of 11

## Correctly calculate the price of a bond with an odd long first period

By Charles Flock on 10/18/2011 8:12 PM
11 Financial Calculations that you can’t do in EXCEL - Part 6 of 11

## Calculate the PRICE of a bond with a monthly coupon

By Charles Flock on 10/18/2011 8:11 PM
11 Financial Calculations that you can’t do in EXCEL - Part 7 of 11

## Calculate the cumulative interest payments for a loan with a balloon payment

By Charles Flock on 10/18/2011 8:10 PM
11 Financial Calculations that you can’t do in EXCEL - Part 8 of 11

## Calculate the interest payment amount on a pay-in-advance loan

By Charles Flock on 10/18/2011 8:10 PM
11 Financial Calculations that you can’t do in EXCEL - Part 9 of 11

## Calculate the price of a bond with an odd last coupon before the last coupon period

By Charles Flock on 10/18/2011 8:09 PM
11 Financial Calculations that you can’t do in EXCEL - Part 10 of 11

## Calculate a PMT amount when there is an odd first period

By Charles Flock on 10/18/2011 8:08 PM
11 Financial Calculations that you can’t do in EXCEL - Part 11 of 11

## Search Blogs

 KeywordsPhrase

## Blog Archives

Archive
 < October 2011 >
SunMonTueWedThuFriSat
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345
Monthly
Go