Jan 12

Written by: Matt Abar
1/12/2010 11:50 AM

Some FinFolio reports have custom columns where you can pick any calculation from our library. We currently have about forty calculations which cover everything from transaction type summations, to rates of return, to fixed income accruals.

When you select a column calculation, you can also change any custom parameters for that calculation. For example, when you select Return, you can specify whether FinFolio should use the time-weighted return calculation or the dollar-weighted (internal) method.

We have one report simply called the "Four Column" report; every column on the report is a custom calculation column. Combine that with the custom grouping and ability to set the row level and your customization options are almost endless. I'll talk more about report grouping in my next post.

The calculation library (still in flux) currently includes:

Billing

• Fees
• Invoices

Cost basis

• Basis
• Capital gain distributions
• Capital gain tax paid
• Collective gain
• Ordinary dividends
• Qualified dividends
• Proceeds
• Realized gains and losses
• Section 1202 Income
• Unit cost
• Unrealized gain and loss
• Unrecaptured Section 1250 Gain

Fixed income

• Accrued Appreciation
• Accrued Income
• Accrued interest
• Estimated annual income
• Yield

Market value

• Average daily value
• Average simple value
• Market value

Rate of return

• Index performance
• Return

Trade amounts

• Buys
• Buys and contributions
• Contributions
• Corporate actions
• Dividends
• Income
• Interest
• Net transfers
• Non dividends
• Price
• Sells
• Sells and withdrawals
• Transfers in
• Transfers out
• Units
• Withdrawals

 

Tags: