Archive for the ‘Business’ Category

Template: Simple Financial Statements

Monday, February 18th, 2008

Forum member Allmec has shared a set of simple financial statement templates. They include: Profit and Loss (Income) Statement, Balance Sheet, and Cash Flow Statement. They are formatted in Pounds, but should easily be modified for use with other currencies, such as the dollar. You may also find them useful as a "jumping ...

Template: Loan Grid Worksheet

Sunday, January 6th, 2008

The Loan Grid Worksheet template allows you to quickly visualize alternatives when considering a loan. For instance: You are considering a loan of $12,000 at 8% interest for a term of 60 months. There are many loan amortization spreadsheets that you could plug these numbers into and see that the ...

Template: David Seah’s Compact Calendar for Numbers

Tuesday, December 4th, 2007

This is a Numbers port of David Seah's Compact Calendar. David has developed a number of great productivity tools over the years including The Printable CEO Series. I highly recommend his site. The Compact Calendar allows you to plan projects quickly, while envisioning time in a different manner than other tools ...

Template: Problem Solving Using the Toyota A3 Method

Wednesday, October 24th, 2007

Forum member Steve has shared a cool Numbers spreadsheet template on the forums, that allows a user to use the A3 problem solving methodology to work through business process problems. Steve describes the template: This is another tool that I have found very useful in small (30 people) and large (40,000 people) ...

Template: Project Template With Gantt Chart for Apple iWork Numbers

Saturday, October 6th, 2007

Forum member Bjoern has been kind enough to share his Project Template with Gantt chart. The template includes: a project description area, a fuel-gauge style chart, and columns for WBS (Work Breakdown Statements), Tasks, Task Leads, Start Time, End Time, Duration (in days), and a neat in-cell chart. You can view the ...

How to Get Stock Quotes into Apple iWork Numbers ‘08

Sunday, August 19th, 2007

NEW VERSION ADDED 8/23/2007 One of the most glaring missing features of Apple iWork Numbers '08 is the ability to get data into the sheet from outside sources. A very common need is to pull in stock quotes, then manipulate the data. While, I have not found a ...

Loan Amortization Schedule Template for iWork Numbers

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 ...