ACE FINANCIAL SERVICES - SPECIFICATIONS

Savings Accounts & Mortgage Checker

Goal: To be able to compare different accounts

Specification:   Have a worksheet that looks good; define which inputs required; have a worksheet of input data; expand to have a database with input data; output figures plus charts.

Inputs:  Start balance

End balance

Time horizon (year, month, day)

Interest rate

Net movements on account (withdrawals, savings)

Tax?

Show total cost of loan etc

Make a copy, which has explanatory notes on

Shares

Goal:   To be able to use as many financial key figures as possible in Excel

Specification:   Have a worksheet that looks good; define which inputs required; have a worksheet of input data; expand to have a database with input data; output figures plus charts.

Inputs:  Share static data - name, code, quantity

Daily prices

Simulate sales / purchases to generate performance

Benchmark: FTSE? Something similar etc - have 1 US stock

Make a copy, which has explanatory notes on

When enter new prices in their fields, should be able to calculate:

return

highlight movers up/down

% weighting of portfolio

highlight weightings changes

Analysis:

Graphs over time using equations to model prices