Excel Templates | Excel Spreadsheets


Free Excel Templates

Travel Planner

Posted on July 25, 2009
Filed Under Other | 11 Comments

Share

Finally … home again. After spending one week in Hongkong and China, met with my offline business partners, finally I can straight my legs at home and hoping that all meeting there will give me good business results. And this is my second visit this year and I just saw that the world economic crisis didn’t really affect this country. Or maybe I just saw from my business perspective.

If you have a plan to visit China and you don’t know how to speak Chinese, you should be prepare anything carefully, since most of people in China doesn’t speak English and they don’t know how to read latin words. One spreadsheet that I used to remind me about situation in my travel destination beside my travel expense spreadsheet, is my travel planner spreadsheet.

Travel Planner

This spreadsheet is created based on my weekly planner spreadsheet. So, you can adjust your time activities references like in weekly planner. Unlike the weekly planner that have one week period, this travel planner has a flexible period that you can adjust with maximum of 14 days. This travel planner consist of two worksheets with explanation as follows :

Read more

Tags: , , , , , , , , , , ,

Cost of Goods Sold Calculator

Posted on July 18, 2009
Filed Under Finance | 5 Comments

Share

If you are running a company or if you are working as an accounting, you will be familiar with the meaning of Cost of Goods Sold or usually known as COGS. COGS is the costs that go into creating the products that a company sells; therefore, the only costs included in the measure are those that are directly tied to the production of the products.

For example, the COGS for an mobile phone maker would include the material costs for the parts that go into making the mobile phone along with the labor costs used to put the mobile phone together. The cost of sending the mobile phones to buyers and the cost of the labor used to sell it would be excluded. That is the example of the basic interpretation of COGS. The accounts included in the COGS calculation will differ from one type of business to another.

Based on accounting rules and inventory valuation method, COGS can be calculated using one of three cost flows :
1. First In, First Out (FIFO), items purchased first are sold first.
2. Last In, First Out (LIFO), items purchased last are sold first.
3. Average

Cost of Goods Sold

Note that these are cost flow assumptions. This means that the order in which costs are removed from inventory can be different from the order in which the goods are physically removed from inventory.

There several factors that can affect the choice of cost flow, and depend on your company policy.

Read more

Tags: , , , , , , , ,

Home Inventory

Posted on July 18, 2009
Filed Under Other | 5 Comments

Share

This is an inventory spreadsheet that is created to help you record any detail information regarding all of your family belongings in your house. By building and maintaining this list, you can easily get the detail of your item when you need it. For example, you can easily track which items that can be insured, or already insured or which item that was stolen if something bad happened to your house.

By having this list, you can easily manage your items when you are moving to other house or apartment. And if you plan to sell several of your items you will easily estimate the price based on the item depreciation value.

It may seem difficult at beginning to start recording all of your inventory, especially when you have a big house and all items spreading everywhere. But, it will be better to start making the list before you regret it later.

Home Inventory

You can follow the flow in this spreadsheet to start recording your item. I created this sheet with assumption to record items room by room. It is easier for me to do that. And I don’t write one by one for item like MP3, CDs, and books. I just try to generalize them.

Read more

Tags: , , , , ,

Page 26 of 42« First...1020...2425262728...40...Last »