Templates by Domenico Cristarella

CALCULATE THE AMORTIZATION SCHEDULE OF A MORTGAGE OR CONSUMER LOAN, EITHER AT FIXED OR VARIABLE INTEREST RATE OR BOTH (most online…

A useful tool to help you take control of your finances by organizing and aggregating all relevant information in one…

FULLY FLEDGED ACCOUNTING AND FINANCIAL MANAGEMENT PACKAGE FOR PRIVATE INVESTORS, SMALL FINANCIAL SERVICE BUSINESSES AND PROFESSIONALS A comprehensive tool to…

This tool calculates return of an investment denominated in any currency, split between Realized and Unrealized and further dissected into…

CALCULATE DEPRECIATION OF AN ASSET USING 4 OF THE MOST POPULAR DEPRECIATION METHODS. Fully editable version available. This excel tool will calculate the…

ASSET ALLOCATION MODEL WITH REALISTIC PROJECTIONS OF FINANCIAL SITUATION AT RETIREMENT AND CALCULATION OF RESOURCES NEEDED FROM THEN ON. Supporting…

CALCULATE THE EFFECTIVE NET YIELD-TO-MATURITY (OR TO SALE DATE) OF A BOND, KEEPING PRICE VOLATILITY AND INTEREST RATE RISK UNDER…

THE MODEL CALCULATES MONTHLY AMORTIZATION FOR PREPAID EXPENSES AND/OR UNEARNED INCOME, GENERATING RELEVANT ACCOUNTING ENTRIES. Prepaid expenses represent expenditures that have been…

CALCULATE NET TOTAL RETURN ON BOND INVESTMENT DENOMINATED IN ANY CURRENCY, broken-down by trading gains (realized & unrealized), foreign exchange gains (realized…

The model compares the net value generated by buying a home vs. renting one, until mortgage pay-off, assuming availability of…

This model actually includes two calculators: year-on-year inflation calculator flat rate inflation calculator   The first one calculates the equivalent…

Achieve greater diversification in your asset allocation by using this tool to calculate the correlation coefficient between any two variables, including…