EMI Loan Calculation

An Equated monthly installments (EMI) is a fixed payment amount made by a borrower to a lender at a specified date for each calendar month. EMI are used to pay off both interest and principal each month, so that over a specified number of years, the loan is paid off in full.




The mathematical formula above indicates how EMI is manually calculated where:
  • EMI = Equated Monthly Installment
  • P = Principal
  • R = Interest Rate
  • N = Loan Period

Using Excel in calculating EMI


Below is the procedure on how to do EMI calculation in Microsoft Excel


How Green Tea Affects Blood Pressure

This article was taken from Hemato-Centric Life Institute and re-blog for my personal reference.


How Green Tea Affects Blood Pressure

By Solha Park, PharmD and Moa Park, PharmD

Among the major risk factors of developing cardiovascular diseases such as heart attack, heart failure and stroke, high blood pressure is most closely and consistently related to the development of cardiovascular disease requiring immediate treatment with medications and lifestyle modifications.1While there are many ways to control high blood pressure, regular consumption of green tea has been shown to have a positive relationship with lowering blood pressure when combined with healthy diet and regular exercise.


High blood pressure is a chronic medical condition that can lead to many serious health problems including cardiovascular diseases and kidney disease. Persistent high blood pressure may damage other parts of body such as blood vessels and eyes. While it does not have any symptoms, these long-term complications usually take several years to develop. Fortunately, high blood pressure can be detected easily through a regular medical checkup and can be controlled with lifestyle modification and medications.


Blood pressure is measured as two different pressure types: systolic and diastolic blood pressure. Systolic blood pressure refers to the measurement of blood pressure when the heart pumps out the blood, and diastolic blood pressure refers to the pressure in between two heartbeats. The systolic numbers are often written above or before the diastolic numbers and are higher. The following table shows different stages from normal blood pressure to stage 1 and 2 high blood pressure. The level of the patient’s high blood pressure determines what kind of treatment one may need.

Category
Systolic (mmHg)
Diastolic (mmHg)
Normal
Less than 120
Less than 80
Pre-hypertension
Between 120 – 139
Between 80 – 89
High Blood Pressure (stage 1)
Between 140 – 159
Between 90 – 99
High Blood Pressure (stage 2)
160 or Higher
100 or Higher


Important risk factors of high blood pressure are age, gender, family history, and lifestyle including lack of physical activity, obesity, diets high in sodium (from salt), and some medications.1,6 About one out of three adults in the United States develop high blood pressure.6 Older people are more likely to develop high blood pressure, and men tend to develop high blood pressure earlier than women at the age of 55 and older. High blood pressure can also be hereditary.


How is blood pressure regulated? Blood pressure is regularly maintained by various chemicals in our bodies that send signals to several layers in blood vessels, such as elastic fibers, smooth muscles and connective tissues. Angiotensin, a powerful constrictor of the blood vessels, is an endogenous hormone (a hormone made in human body). Upon activation, it signals stress hormones to be released, constricting the blood vessels by tightening the smooth muscles surrounding the vessels, and causing the kidneys to reduce fluid loss.7 As a result, blood volume increases and blood vessels become narrower raising the blood pressure. On the other hand, nitric oxide, a dilator, is a gaseous chemical in our bodies involved in lowering blood pressure. When it is released into blood vessels, it relaxes the smooth muscles and dilates the vessels which keep blood vessels open as shown in the above figure.7,8 By doing so, nitric oxide decreases the pressure in blood vessels and allows for increased blood flow.

According to recent animal studies on green tea and high blood pressure, catechins in green tea have been shown to affect the activities of angiotensin and nitric oxide. EGCG in green tea has been shown to interfere with the activation process of angiotensin and consequently cause a decrease in blood pressure. EGCG has also been shown to promote biological production of nitric oxide.

Moreover, drinking green tea has been associated with lowering blood pressure in many population studies. Catechins, the major chemicals found in green tea, have been shown to be an antioxidant. The antioxidant effect of catechins in green tea can reduce damages to the blood vessels caused by free radicals and help preserve normal blood vessel function over time.

As the beneficial health effects of green tea are constantly being studied, it would be advisable to encourage the habitual consumption of green tea, especially for those at risk of developing high blood pressure or already suffering from the condition. Although a single food item should not be expected to have a significant impact on one’s health, regular consumption of green tea combined with an improved lifestyle, such as regular physical exercise and healthy diet, may have a great impact on maintaining normal blood circulation and better health.




-----




How to Print Multiple Computer Files in sequence

Doing a big project with multiple documents that needs to be printed in sequence seems to be very easy. However, this will not be easy if we are talking about 500 documents in MS Word, Excel, PDF, CAD Drawings, etc.

Here's one way of doing it.

Setup the printer to the correct layout and paper


  • go your your devices and printer setting
  • cllick the printer you will be using and make it the default printer
  • setup the printer paper orientation whether it will be in landscape of portrait mode
  • select the paper size

Arrange the documents and print


  1. Copy individual documents to a single location and arrange in sequence.
  2. highlight up to 15 documents to be printed at time.
  3. make a right-button click on the mouse
  4. and select print.
  5. viola.... your document will now be printed in sequence or arrangement. Just make sure that you are the only one using the printer.


As for other other options, there are lots of it. Since I am happy with the one I am using, so I will stick to it at the moment till I encounter another problem.

Cheers.


Lady Finger (or “OKRA”) for Diabetes

Lady Finger (or “OKRA”) for Diabetes




Procedure

  • Take two pieces of Lady Finger
  • Remove/cut both ends of each piece, put a small cut in the middle
  • Place these two pieces in glass of water.
  • Cover the glass and keep it at room temperature during night.
  • Early morning, before breakfast simply remove two pieces of lady Finger from the glass and drink the water.
  • Keep doing it on daily basis.
  • Within two weeks, verify the initial result in reduction of your SUGAR.

History


One person was able to control of her diabetes. She was on Insulin for a few years, but after taking the lady fingers every morning for a few months, she has stopped Insulin but continues to take the lady fingers every day. But she chops the lady fingers into fine pieces in the night, adds the water and drinks it all up the next morning. You can try it as it will not do you any harm even if it does not do much good to you, but remember that you have to keep taking it for a few months before seeing the results - as most cases might be chronic.


All about OKRA


Okra is a green, fuzzy, deeply ridged pod. Most common in warmer climates, it can also be grown in cooler areas if the proper variety and cultivation techniques are used.

Selection: Choose bright green pods about 3-4 inches long. They should be firm and moist, not spotted, moldy, limp or dry.

Storage and handling: Store in a plastic bag in the refrigerator 2-3 days. When ready to use wash well in a bowl of cold water.

Preparation: Remove stem end and slice if desired. Prevent okra from becoming slimy by adding vinegar or other acidic ingredients such as tomatoes when cooking, or by breading okra with cornmeal before frying.

Serving suggestions: Okra can be fried (SIS, p. 117), pickled, or added to curries (SIS, p. 116), sautés, and soups. Okra is used in Gumbo, a southern specialty soup, to help thicken it. Substitute okra for zucchini in ratatouille (SIS, p. 125). Dress cooked okra with butter and lemon juice, butter and curry powder, or toss with a vinaigrette and chill.

Nutrients: Vitamins A, B6, C, K; thiamin; folate; calcium; fiber.

1 lb raw = 8 cups whole (4 c. sliced)
1 lb cooked = 2 1⁄4 cups

The Fruit and Vegetable Guide is reproduced here with permission of Herald Press, publisher of Simply in Season.

Converting yout BluRay device to Region Free

You want to see a 3D bluray sexy movie you borrowed from your friend in your bluray player? However, the bluray player suddenly shows you a message that "Your DVD is out of region"...

Do not cry, there is a solution to it.

I recently bought a Samsung BD-D5500 bluray player in Saudi Arabia with indicated Region of 2 and a letter B. I know very well that it will not work in the Philippines because of the region concern, but since I just want to watch youtube, so the player is ok. I am not thinking of sending the item to Philippines even if my package is still accepting those kinds of stuff.

Googling the intenet, I found a very good information about BluRay and the regions. See below on the BluRay/DVD regions where you are located. Buying a bluray from China assures you that it is a Region Free, meaning all BluRay and DVD will play fine.

Here are some information for the regions:


According to the map above, Saudi Arabia and Africa are Region B for the bluray. While Philippines is a Region A. This means that a Bluray brought from US can be played by the bluray player bought in the Philippines. However, even of bluray disk will play, there is a chance that your DVD collections of erotic movies from US will not play because it is DVD Region 1 while Philippines is using DVD Region 3.

Since i bought the unit with Bluray region B and DVD region 2, and I need to play the mouth watering bluray of my friend, then I have to fixed my player to be region free.

Here's how you can make your Blu ray player to be region free. I took this tip from http://www.videohelp.com/dvdhacks/samsung-bd-e5500/11837:

-----------------------------------------------

Do this tip if you are going to change the bluray player (to Region free) bought in Saudi Arabia.
  1. Remove any disk in the tray of the bluray player and ensure that the TV is on, and connected to the player.
  2. Switch the player off and then back on. 
  3. Wait for the main menu on the TV screen 
  4. In your remote, press the eject button to open the tray. 
  5. Press the eject button to close the tray. 
  6. As soon as the "No Disk" message appears at the top right corner do the following. 
  7. Press the REPEAT button (located just above the TV program button at the bottom of the remote)
  8. Enter 57538 on the number pad.
  9. The region code "2" should appear at the top right corner of the screen. (this appears in less than a second.) 
  10. Press "9" right away if 2 is shown. (Note: if you press 9 after 2 disappear, then you have to repeat again from step 4). You will that it will display 9 after.
  11. Restart the player 
  12. Play a foreign DVD to check. 
------------------------------------------

Note:
The button "REPEAT" sometimes not in your remote. Try to use "STOP", or "RETURN" from your player remote control.

Only a handful made it on the first try. It took me about 20 tries, to figure out what is wrong with what I am doing.

As a tip, familiarize yourself with the steps from 4 to 10. Do the steps in succession without pause.



*****    E N D    *****


------------------------------------------
Happy watching scandal, chito miranda, wally bayola, marian rivera, dingdong, virgin people, and the like.

------------------------------------------




Lagundi and Ginger (or "Luya")

I became interested in Herbal Medicines. The plants that interest me are as follows:

a) Lagundi
b) Ginger (or "Luya")

Lagundi

Lagundi is a common medicinal shrub grown in the Philippines, and also grows wild in many places like Mt. Banahaw. The scientific name of lagundi is ‘Vitex negundo’.


The use of Lagundi for medicinal purposes has a long history in the Philippines and is used for centuries. The Philippine Department of Health has certified Lagundi as a medicinal plant for treatment in cases of colds, flu, pharyngitis, and asthma. It is included in 10 herbal medicines made by Philippines Health Department as an effective herbal medicine. 

Lagundi is also known for its analgesic effect that helps lessen pain and distress. At present, pharmaceutical companies sell it in tablet form at drug stores. A new cough syrup for children made from Lagundi is also on the market nowadays. These products are approved by the Bureau of Food and Drugs. The Philippine government actively promotes it as an alternative to Western cough medicines.

Ginger

Ginger or ginger root is the rhizome of the plant Zingiber officinale, consumed as a delicacy, medicine, or spice. It lends its name to its genus and family. Other notable members of this plant family are turmeric, cardamom, and galangal. Wikipedia.



Aromatic, pungent and spicy, ginger adds a special flavor and zest to Asian stir fries and many fruit and vegetable dishes. Fresh ginger root is available year round in the produce section of your local market.

Ginger is the underground rhizome of the ginger plant with a firm, striated texture. The flesh of the ginger rhizome can be yellow, white or red in color, depending upon the variety. It is covered with a brownish skin that may either be thick or thin, depending upon whether the plant was harvested when it was mature or young.

 

Health Benefits

Historically, ginger has a long tradition of being very effective in alleviating symptoms of gastrointestinal distress. In herbal medicine, ginger is regarded as an excellent carminative (a substance which promotes the elimination of intestinal gas) and intestinal spasmolytic (a substance which relaxes and soothes the intestinal tract). Modern scientific research has revealed that ginger possesses numerous therapeutic properties including antioxidant effects, an ability to inhibit the formation of inflammatory compounds, and direct anti-inflammatory effects.

Gastrointestinal Relief

A clue to ginger's success in eliminating gastrointestinal distress is offered by recent double-blind studies, which have demonstrated that ginger is very effective in preventing the symptoms of motion sickness, especially seasickness. In fact, in one study, ginger was shown to be far superior to Dramamine, a commonly used over-the-counter and prescription drug for motion sickness. Ginger reduces all symptoms associated with motion sickness including dizziness, nausea, vomiting, and cold sweating.

Safe and Effective Relief of Nausea and Vomiting During Pregnancy

Ginger's anti-vomiting action has been shown to be very useful in reducing the nausea and vomiting of pregnancy, even the most severe form, hyperemesis gravidum, a condition which usually requires hospitalization. In a double-blind trial, ginger root brought about a significant reduction in both the severity of nausea and number of attacks of vomiting in 19 of 27 women in early pregnancy (less than 20 weeks). Unlike antivomiting drugs, which can cause severe birth defects, ginger is extremely safe, and only a small dose is required.

A review of six double-blind, randomized controlled trials with a total of 675 participants, published in the April 2005 issue of the journal, Obstetrics and Gynecology,has confirmed that ginger is effective in relieving the severity of nausea and vomiting during pregnancy. The review also confirmed the absence of significant side effects or adverse effects on pregnancy outcomes.

Anti-Inflammatory Effects

Ginger contains very potent anti-inflammatory compounds called gingerols. These substances are believed to explain why so many people with osteoarthritis or rheumatoid arthritis experience reductions in their pain levels and improvements in their mobility when they consume ginger regularly. In two clinical studies involving patients who responded to conventional drugs and those who didn't, physicians found that 75% of arthritis patients and 100% of patients with muscular discomfort experienced relief of pain and/or swelling.

Arthritis-related problems with your aging knees? Regularly spicing up your meals with fresh ginger may help, suggests a study published in a recent issue of Osteoarthritis Cartilage. In this twelve month study, 29 patients with painful arthritis in the knee (6 men and 23 women ranging in age from 42-85 years) participated in a placebo-controlled, double-blind, crossover study. Patients switched from placebo to ginger or visa versa after 3 months. After six months, the double-blind code was broken and twenty of the patients who wished to continue were followed for an additional six months.

By the end of the first six month period, those given ginger were experiencing significantly less pain on movement and handicap than those given placebo. Pain on movement decreased from a score of 76.14 at baseline to 41.00, while handicap decreased from 73.47 to 46.08. In contrast, those who were switched from ginger to placebo experienced an increase in pain of movement (up to 82.10) and handicap (up to 80.80) from baseline. In the final phase of the study when all patients were getting ginger, pain remained low in those already taking ginger in phase 2, and decreased again in the group that had been on placebo.

Not only did participants' subjective experiences of pain lessen, but swelling in their knees, an objective measurement of lessened inflammation, dropped significantly in those treated with ginger. The mean target knee circumference in those taking ginger dropped from 43.25cm when the study began to 39.36cm by the 12th week. When this group was switched to placebo in the second phase of the study, their knee circumferences increased, while those who had been on placebo but were now switched to ginger experienced a decrease in knee circumference. In the final phase, when both groups were given ginger, mean knee circumference continued to drop, reaching lows of 38.78 and 36.38 in the two groups.

How does ginger work its anti-inflammatory magic? Two other recent studies provide possible reasons.

A study published in the November 2003 issue of Life Sciences suggests that at least one reason for ginger's beneficial effects is the free radical protection afforded by one of its active phenolic constituents, 6-gingerol. In this in vitro (test tube) study, 6-gingerol was shown to significantly inhibit the production of nitric oxide, a highly reactive nitrogen molecule that quickly forms a very damaging free radical called peroxynitrite.

Another study appearing in the November 2003 issue of Radiation Research found that in mice, five days treatment with ginger (10 mg per kilogram of body weight) prior to exposure to radiation not only prevented an increase in free radical damage to lipids (fats found in numerous bodily components from cell membranes to cholesterol), but also greatly lessened depletion of the animals' stores of glutathione, one of the body's most important internally produced antioxidants.

A study published in the February 2005 issue of the Journal of Alternative and Complementary Medicine sheds further light on the mechanisms of action that underlie ginger's anti-inflammatory effectiveness. In this research, ginger was shown to suppress the pro-inflammatory compounds (cytokines and chemokines) produced by synoviocytes (cells comprising the synovial lining of the joints), chrondrocytes (cells comprising joint cartilage) and leukocytes (immune cells).

Protection against Colorectal Cancer

Gingerols, the main active components in ginger and the ones responsible for its distinctive flavor, may also inhibit the growth of human colorectal cancer cells, suggests research presented at the Frontiers in Cancer Prevention Research, a major meeting of cancer experts that took place in Phoenix, AZ, October 26-30, 2003.

In this study, researchers from the University of Minnesota's Hormel Institute fed mice specially bred to lack an immune system a half milligram of (6)-gingerol three times a week before and after injecting human colorectal cancer cells into their flanks. Control mice received no (6)-gingerol.

Tumors first appeared 15 days after the mice were injected, but only 4 tumors were found in the group of -gingerol-treated mice compared to 13 in the control mice, plus the tumors in the -gingerol group were smaller on average. Even by day 38, one mouse in the (6)-gingerol group still had no measurable tumors. By day 49, all the control mice had been euthanized since their tumors had grown to one cubic centimeter (0.06 cubic inch), while tumors in 12 of the (6)-gingerol treated mice still averaged 0.5 cubic centimeter—half the maximum tumor size allowed before euthanization.

Research associate professor Ann Bode noted, "These results strongly suggest that ginger compounds may be effective chemopreventive and/or chemotherapeutic agents for colorectal carcinomas."

In this first round of experiments, mice were fed ginger before and after tumor cells were injected. In the next round, researchers will feed the mice ginger only after their tumors have grown to a certain size. This will enable them to look at the question of whether a patient could eat ginger to slow the metastasis of a nonoperable tumor. Are they optimistic? The actions of the University of Minnesota strongly suggest they are. The University has already applied for a patent on the use of (6)-gingerol as an anti-cancer agent and has licensed the technology to Pediatric Pharmaceuticals (Iselin, N.J.).

Ginger Induces Cell Death in Ovarian Cancer Cells

Lab experiments presented at the 97th Annual Meeting of the American Association for Cancer, by Dr Rebecca Lui and her colleagues from the University of Michigan, showed that gingerols, the active phytonutrients in ginger, kill ovarian cancer cells by inducing apoptosis (programmed cell death) and autophagocytosis (self-digestion).

Ginger extracts have been shown to have both antioxidant, anti-inflammatory and anti-tumor effects on cells. To investigate the latter, Dr Liu examined the effect of a whole ginger extract containing 5% gingerol on a number of different ovarian cancer cell lines.

Exposure to the ginger extract caused cell death in all the ovarian cancer lines studied.

A pro-inflammatory state is thought to be an important contributing factor in the development of ovarian cancer. In the presence of ginger, a number of key indicators of inflammation (vascular endothelial growth factor, interleukin-8 and prostaglandin E2) were also decreased in the ovarian cancer cells.

Conventional chemotherapeutic agents also suppress these inflammatory markers, but may cause cancer cells to become resistant to the action of the drugs. Liu and her colleagues believe that ginger may be of special benefit for ovarian cancer patients because cancer cells exposed to ginger do not become resistant to its cancer-destroying effects. In the case of ovarian cancer, an ounce of prevention—in the delicious form of liberal use of ginger—is an especially good idea. Ovarian cancer is often deadly since symptoms typically do not appear until late in the disease process, so by the time ovarian cancer is diagnosed, it has spread beyond the ovaries. More than 50% of women who develop ovarian cancer are diagnosed in the advanced stages of the disease.

Immune Boosting Action

Ginger can not only be warming on a cold day, but can help promote healthy sweating, which is often helpful during colds and flus. A good sweat may do a lot more than simply assist detoxification. German researchers have recently found that sweat contains a potent germ-fighting agent that may help fight off infections. Investigators have isolated the gene responsible for the compound and the protein it produces, which they have named dermicidin. Dermicidin is manufactured in the body's sweat glands, secreted into the sweat, and transported to the skin's surface where it provides protection against invading microorganisms, including bacteria such asE. coli and Staphylococcus aureus (a common cause of skin infections), and fungi, including Candida albicans.

Ginger is so concentrated with active substances, you don't have to use very much to receive its beneficial effects. For nausea, ginger tea made by steeping one or two 1/2-inch slices (one 1/2-inch slice equals 2/3 of an ounce) of fresh ginger in a cup of hot water will likely be all you need to settle your stomach. For arthritis, some people have found relief consuming as little as a 1/4-inch slice of fresh ginger cooked in food, although in the studies noted above, patients who consumed more ginger reported quicker and better relief.

Description

The spice ginger is the underground rhizome of the ginger plant, known botanically as Zingiber officinale. The plant's botanical name is thought to be derived from its Sanskrit name singaberawhich means "horn shaped," a physical characteristic that ginger reflects.

The flesh of the ginger rhizome can be yellow, white or red in color, depending upon the variety. It is covered with a brownish skin that may either be thick or thin, depending upon whether the plant was harvested when it was mature or young. The ginger rhizome has a firm, yet striated texture and a taste that is aromatic, pungent and hot.

History

Native to southeastern Asia, a region whose cuisines still feature this wonderfully spicy herb, ginger has been renowned for millennia in many areas throughout the world.

Ginger is mentioned in ancient Chinese, Indian and Middle Eastern writings, and has long been prized for its aromatic, culinary and medicinal properties. After the ancient Romans imported ginger from China almost two thousand years ago, its popularity in Europe remained centered in the Mediterranean region until the Middle Ages when its use spread throughout other countries. Although it was a very expensive spice, owing to the fact that it had to be imported from Asia, it was still in great demand. In an attempt to make it more available, Spanish explorers introduced ginger to the West Indies, Mexico and South America, and in the 16th century, these areas began exporting the precious herb back to Europe.

Today, the top commercial producers of ginger include Jamaica, India, Fiji, Indonesia and Australia.

How to Select and Store

Whenever possible, choose fresh ginger over the dried form of the spice since it is not only superior in flavor but contains higher levels of gingerol as well as ginger's active protease (it's anti-inflammatory compound). Fresh ginger root is sold in the produce section of markets. When purchasing fresh ginger root, make sure it is firm, smooth and free of mold. Ginger is generally available in two forms, either young or mature. Mature ginger, the more widely available type, has a tough skin that requires peeling while young ginger, usually only available in Asian markets, does not need to be peeled.

Even through dried herbs and spices like ginger powder are widely available in supermarkets, you may want to explore the local spice stores in your area. Oftentimes, these stores feature an expansive selection of dried herbs and spices that are of superior quality and freshness than those offered in regular markets. Just like with other dried spices, when purchasing dried ginger powder try to select organically grown ginger since this will give you more assurance that it has not been irradiated.

Ginger is also available in several other forms including crystallized, candied and pickled ginger.

Fresh ginger can be stored in the refrigerator for up to three weeks if it is left unpeeled. Stored unpeeled in the freezer, it will keep for up to six months.

Dried ginger powder should be kept in a tightly sealed glass container in a cool, dark and dry place. Alternatively, you can store it in the refrigerator where it will enjoy an extended shelf life of about one year.

Tips for Preparing and Cooking

To remove the skin from fresh mature ginger, peel with a paring knife. The ginger can then be sliced, minced or julienned. The taste that ginger imparts to a dish depends upon when it is added during the cooking process. Added at the beginning, it will lend a subtler flavor while added near the end, it will deliver a more pungent taste.

How to Enjoy

A Few Quick Serving Ideas
  1. Turn up the heat while cooling off by making ginger lemonade. Simply combine freshly grated ginger, lemon juice, cane juice or honey and water.
  2. Add extra inspiration to your rice side dishes by sprinkling grated ginger, sesame seeds and nori strips on top.
  3. Combine ginger, soy sauce, olive oil and garlic to make a wonderful salad dressing.
  4. Add ginger and orange juice to puréed sweet potatoes.
  5. Add grated ginger to your favorite stuffing for baked apples.
  6. Spice up your healthy sautéed vegetables by adding freshly minced ginger.

For some of our favorite recipes, click Recipes.

The case of a credit card overcharging

If you have a credit card in the Philippines, you'd better check this and make sure you are not being overcharged by the bank.

The image below is a cutout taken from my recent Billing Statement. I laid out here how the discrepancy will occur, and eventually will overcharge you via Finance Charge.

Credit Card Billing Statement cutout


Please be familiar with the term and data:

  • MONTHLY INTEREST RATE - it is indicated on top of the billing statement. In my case it is 3%
  • FINANCE CHARGE - indicated here is Php 368.25
  • PURCHASE ADVANCE - these are the total amount of purchases including the 0% interest for the current billing period.
  • PREVIOUS BALANCE - the amount indicated in the previous billing statement. This does not include the payment done for the said previous billing statement.
  • PAYMENT RECEIVED (or PAYMENT CREDIT)- this is the payment made for the previous Billing Statement
  • LATE CHARGE - This amount is charged to the credit card owner if he/she fails to pay the minimum amount on/before the due date. Charges range from Php 500 up is normally applied to late payment of Minimum Due.
  • OUTSTANDING BALANCE - the amount that has to be paid by the credit card owner on/before the due date. Failure of payment will result in LATE CHARGE  in the next Billing Statement.
Now, let us look deeper into the Billing Statement:

  • The Outstanding Balance is the sum of PURCHASE ADVANCE plus FINANCE CHARGE plus LATE CHARGE plus PREVIOUS BALANCE minus PAYMENT RECEIVED. So based on the Billing Statement, the values are 5,990.71 + 368.25 + 0 + 11,105.85 - 3,500 = 13,964.81.
  • The Outstanding Balance value seems to be correct at Php  13,964.81,  right?   Unfortunately it is ........ WRONG!!!!
  • The formula indicated in the first bullet is correct except when somebody forgot to ask where the FINANCE CHARGE came from (or how it was calculated).
  • As indicated in the Billing Statement, the percentage is only 3% (MONTHLY INTEREST RATE) and it only applies to the resulting amount taken from PREVIOUS BALANCE minus PAYMENT RECEIVED.
  • PREVIOUS BALANCE minus PAYMENT RECEIVED  is equal to 11,105.85 - 3,500 =  7,605.85
  • The 3% of Php 7,605.85 is only Php 228.18.
  • Comparing the FINANCE CHARGE between calculated value (i.e. Php 228.18) and the listed value in the Billing Statement (i.e. Php 368.25) is the method how you are going to determine if the bank is overcharging you.

Always check this number and try to calculate using a calculator and/or excel. If you found a discrepancy, then always make it appoint to claim that even in a small amount. I you don't want that small amount, you can just donate it for the benefits of the needy.

DO NOT DONATE IT TO THE BANK, THEY ALREADY HAVE LOTS OF MONEY.

People who are so busy with life and has a lot of money to spend, seldom they noticed that small amount is being charged to them.

Automatic Login to Windows 7

The computer I am using is normally locked up in my room. The tablet is the one I used whenever I go around because of its computer function with the addition of a mobile calling capability.

Inputting my password in the computer that is normally locked up is a hazzle, so I looked for a way to automatically log me in the computer whenever I open it.

The link is http://www.7tutorials.com/log-automatically-windows-7-without-typing-your-password#main-content.

Enjoy.

Signs of Ageing Debtor

I have been managing AllTechSolution Enterprises Inc. especially its technical operation. The books below are my guides:
  • How to Win Friends and Influence People
  • DO's and Dont's of Business
  • Dilbert Principle of Management
  • 30-day MBA in Marketing
The books are available in prints, or in video that can be downloaded from the youtube. These books helped me a lot to be on top of any business dealings and public relation. One of this is how to determine a customer that does not pay on time.

Using the 30 day MBA (page 40), I found the following items that normally shows sign that a client will default in their payment:

  • Checks are bouncing
  • Partial payments being offered
  • Post-dated payment offered
  • Claims that payment have been lost in the post
  • Claims that the necessary signatories for the checks payment are away

If you have a business and the client gives you one of the reason above, then act right away.

One word of advice, do not give payment terms to clients who has not yet bought from you. Check the forums if the company has a bad reputation.