Download this file for Finance Excel Lab

In order to complete today's lab, download this spreadsheet. This spreadsheet has an introduction, a discussion of cell references and range names, information on how Excel uses dates, and today's lab task, which is to be build a calculator that calculates the future value, given

• a present value
• a starting date
• an ending date
• an interest rate

Your calculator should find the future value based on different compounding. The compounding can be

• annual
• monthly
• hourly... etc.
• and CONTINUOUSLY

You will use the concept of continuous compounding in every aspect of finance.

Paste this link into your browser:

https://docs.google.com/leaf?id=0BzmdxHsBfTsVNWMzYzk2YTctYjczYy00ZmVkLThiY2QtZDNmMzdhYWI3ODA3&hl=en