Household budget spreadsheet and its importance

Household Budget Spreadsheet and its Importance

A household budget spreadsheet is the most efficient tools to manage the different aspects of personal finances including debt. It lets you keep a check on the expenses that are incurred due to the household activities. These are versatile mediums to keep track of unexpected and unnecessary expenses. Making such a spreadsheet is an easy task.

The first step is to select a budget template that best suits you. Wide varieties of budget templates are available on the internet and can be easily downloaded without incurring any cost. You can even design your own template using excel. A self made template is ensured to have all the attributes as per your requirements. You need to make six pages with the following titles: income, utilities, calendar, debt, seasonal and budget.

The budget page is used for balancing all the income and expenses. Subsequently you need to create the following list: income, utilities, seasonal, and debt. The income page is created so as to enter all the sources of income and the respective amounts. Then you need to total the amount column and this has to be linked to the budget page. However before you have the exact numbers you should key in the lowest expected income; which needs to be totaled and linked to the amount cell on the budget page.

The utility page consists of payments that are not debts namely electricity, natural gas, transportation, groceries, etc. After you have listed all the proximate values the total needs to be calculated and a link is to be established with the budget page. The calendar and seasonal pages are used as agents to remind you of yearly, bi-yearly and other payments. A column for every month is to be made and the respective payment for each month is to be entered in the corresponding column.  

In the Household Budget Spreadsheet the debt page is used to list all the debts due, interest rates and the minimum monthly payments. At the end comes the budget page which consists of all the amounts from every page.

Letter of credit basics

Letter of Credit Basics

Are you doing business overseas and your supplier has asked you for a letter of credit? Do you own a distributor, wholesaler or re-seller and have a large purchase order where you need a letter of credit to pay your suppliers?

As the number of national and international transactions grows, so does the number of suppliers that are asking to be paid with a letter of credit. A letter of credit is a financial instrument that serves two purposes. It ensures that your suppliers get paid (that’s why they ask for them). It also ensures that you get the goods you bargained for — otherwise the suppliers will not get paid. It protects both of you.

Letters of credit come in many flavors. The most common are:

Revocable Letter of Credit: A revocable letter of credit allows the issuer to modify it, amend it or even cancel it. Since a RLC can be modified, most suppliers don’t like it because it increases their risk.

Irrevocable Letter of Credit: An irrevocable letter of credit does not allow for amendments, modifications or cancellation unless there is agreement by the parties. Since it is a form of guaranteed payment, many suppliers prefer this type of payment option.

Standby Letter of Credit: A standby letter of credit is a payment guarantee — rather than a payment mechanism. Under the terms of the agreement, the supplier can draw on the letter of credit if the client does not pay.

Transferable Letter of Credit : A transferable letter of credit can be revocable or irrevocable. This type of LOC allows the recipient to transfer part or all of the benefits to another party.

Qualifying for a letter of credit is not always easy. It requires one of two things. First, the business owner can deposit the actual amount of cash needed for the transaction with the bank or financial institution that issues the letter. This, of course, is very expensive. A second option is to have a bank give you a line of credit, and issue the letter of credit using the line of credit as collateral. Although this is the most common method of financing a LOC, it is also the hardest because your business must qualify for bank financing.

There is another trade finance option though. It is called purchase order financing. Purchase order financing is ideal for companies that have exhausted their bank resources. The purchase order funding company provides you with the necessary letters of credit to pay your suppliers using your purchase order as collateral. The transaction is settled once your client pays. Purchase order funding is the ideal tool to grow your business to the next level.