Archive for August, 2007
Saturday, August 18th, 2007
Presenting the Garden Budget. This template is adapted from an Excel sheet that can found here. It uses a layout similar to the event planner template included with Numbers, and allows the user to make a plan for creating a garden and see a visual representation of the projected ...
Posted in Home, Templates | No Comments »
Friday, August 17th, 2007
The compound annual growth rate measures the growth rate of an investment as if it grew at a steady rate over time.
For example, a savings account that pays a 3.00% APY will grow at three percent, year after year, until the bank changes the rate. Therefore, the CAGR on ...
Posted in Formulas | 4 Comments »
Friday, August 17th, 2007
Note: This post should hold true for both Numbers, and Excel, as the functions are identical.
The DATEDIF function finds the number of days, months, or years between two dates.
The format is DATEDIF(start-date, end-date, method)
- start-date and end-date are self explanatory
- method has several options:
"D" - counts the days between the ...
Posted in Functions | No Comments »
Thursday, August 16th, 2007
The loan amortization schedule template is based on an Excel worksheet that can be found here. Feel free to use it or modify it in any way.The sheet is suitable for calculating both short term loan amortizations, such as a car loan, as well as mortgage amortization schedules of ...
Posted in Business, Loans, Personal Finance, Templates | 6 Comments »