AC/DC rock inside your Excel spreadsheet!

One of the most bizarre uses of Excel. An AC/DC rock video within the spreadsheet!

Watch the video below, or download the spreadsheet itself at http://www.acdcrocks.com/excel.




If you enjoyed this post, go to the top left corner of the blog, where you can subscribe for regular updates, our monthly ezine and your free report.

Breaking Loan Payments Into Principal and Interest Components

By Stephen Nelson

Microsoft Excel can help you down a loan payment into its principal and interest components. Excel's IPMT function lets you calculate the interest component of a loan payment. And Excel's PPMT function lets you calculate the principal component of a payment.

Using the IPMT Function to Calculate Payment Interest

The IPMT function calculates the interest portion of a payment given its interest rate, the period, the term (or number of payments), present value (or loan balance), future value (or balloon payment), and, optionally, the type-of-annuity switch. If you set the type-ofannuity switch to 1, Excel assumes payments occur at the beginning of the period, following the annuity due convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the period following the ordinary annuity convention.

The function uses the following syntax:

IPMT (rate, period, nper, pv, fv, type)

For example, to calculate the period interest rate for the 54th payment on a 30-year, $150,000 mortgage charging 8% annual interest, you use the following formula:

=IPMT(.08/12,54,30*12,150000,0,0)

The function returns the value -957.51. Notice that to convert the 8% annual interest to a period interest, the formula divides the annual interest rate by 12. Notice, too, that to convert the 30-year term to a term in months, the formula multiplies 30 by 12. The function returns the interest payment amount as a negative value because it reflects a cash outflow you pay.

NOTE If you set the pv argument to -150000, you indicate that you're loaning money. In this case, the function returns 957.51, a positive value, showing that the interest payment amount is a positive cash inflow.

Using the PPMT Function to Calculate Payment Principal

The PPMT function calculates the principal portion of a payment given its interest rate, the period, the term (or number of payments), present value (or loan balance), future value (or balloon payment), and, optionally, the type-of-annuity switch. If you set the type-of-annuity switch to 1, Excel assumes payments occur at the beginning of the period, following the annuity due convention. If you set the annuity switch to 0 or you omit the argument, Excel assumes payments occur at the end of the period following the ordinary annuity convention. The function uses the following syntax:

PPMT (rate, period, nper, pv, fv, type)

For example, to calculate the period principal payment for the 54th payment on a 30-year, $150,000 mortgage charging 8% annual interest, you use the following formula:

=PPMT (.08/12,54,30*12,150000,0,0)

The function returns the value -143.13. Notice that to convert the 8% annual interest to a period interest, the formula divides the annual interest rate by 12. Notice, too, that to convert the 30-year term to a term in months, the formula multiplies 30 by 12. The function returns the principal payment amount as a negative value because it reflects a cash outflow you pay.

NOTE: If you set the pv argument to -150000, you indicate that you're actually loaning money. And in this case, the function returns 143.13, a positive value, showing that the principal payment amount is a positive cash inflow.

Stephen L. Nelson is a Bellevue, Washington CPA and the author of many bestselling books including the MBA's Guide to Microsoft Excel from which this article is adapted. Nelson also edits the popular information web sites forming an S corp online and the incorporating a business, the forming an LLC web sites.
Article Source: http://EzineArticles.com/?expert=Stephen_Nelsonhttp://EzineArticles.com/?Breaking-Loan-Payments-Into-Principal-and-Interest-Components&id=859513

Giving and receiving feedback

by Angela Robson of Nicholson Consultancy

In this article we are going to look at giving feedback, which (if used correctly) is a tool anybody can use, at any time, with no cost (other than time), that will make definite, long term improvements to the business. It can be used to correct behaviour or to praise good performance. But like any tool there is a right and wrong way to use it.

The RIGHT way:

1. Remember the reason for giving feedback is to correct an individuals behaviour - not to vent your emotion.
2. Describe the specific behaviours / results you have observed, and explain the impact on the business, the team and you.
3. Check your observations are correct
4. Are there any mitigating circumstances ( remember to actively listen)
5. Describe the behaviours / results you are looking for (be accurate and concise)
6. Together, search for a solution
7. Check the individual will do it (beware of “I’ll try”, which translates as, “I’m not going to do it”)
8. Thank them in advance
9. Give regular updates and stay focused on their behaviour / results.
   

The process for giving feedback on good performance is very similar:

1. Describe the specific behaviours / results you are praising
2. Explain how you feel about the results / behaviours
3. Look at how the outcome was achieved and how it can be applied in other situations
4. Thank them, and give further encouragement

For any feedback to be successful it needs to be specific, descriptive and factual, and delivered in a non-judgemental manner. You need to focus on the actual behaviours and results, not the individual. If necessary prepare beforehand and gather any information / evidence you need.
Be careful though, feedback will fail if you use any sort of:

• Personal criticism e.g. “you’re not good enough” or “you’re too sloppy at work” - it will
  make them defensive
• Assumptions about a person’s mental state e.g. “you’ve a bad attitude” or “you’re lazy” – this will make them both resentful and defensive
• Generalisations e.g. “you’re always late” or “you’re always missing your deadlines” - if you exaggerate, they won’t believe you
• Contaminated praise e.g. “that was quite good…for you” or “that report was very
  thorough...apart from the obvious mistake” - they won’t know if they are being
  praised or criticised
  

To be really effective at feedback you need to be able not only to give effective feedback, but also to receive it. It is important to seek out feedback (even asking for feedback on your feedback). This will help you to learn and progress and ultimately lead to an improvement in performance.
When receiving feedback remember:

1. To listen actively
2. Suspend judgement and let them finish
3. Repeat back the main points (this will show you have understood what has been said)
4. Ask for specifics
5. If necessary gather further information from other people
6. Decide what you want to do next

Remember that if you ask for feedback, then you need to accept what you hear and don’t begin to defend yourself. You need to understand that this is their observation. You don’t have to believe it, or act upon it, but you must listen to them openly. If you begin to defend your actions, others may stop telling you the truth.

We have included below our all time top ten tips for giving feedback.

Top 10 Feedback Tips

1. Consider the business reasons for giving feedback
2. Make it timely
3. Praise in public, criticise in private
4. Keep it simple
5. Put it in context
6. Focus on behaviour / results, not personality
7. Use objective information, not just your own opinion
8. Focus on the future
9. Listen to the other person’s point of view
10. Don’t overdo it!

Angela Robson is a Director of Nicholson Consultancy Limited, specialising in Business Strategy and Lean Thinking. Angela contributes to the e-zine, “Better Today”, with information for those who are interested in making improvements in their business. If you’re interested in Lean Manufacturing, visit Nicholson Consultancy’s blog, Manufacturing Times.

Where to go when the banks say ‘NO’

by Glen Feechan

Although there are signs that the banks are gradually starting to lend again, it is not at anything like the levels business has been used to. I am sure many of you will be very aware of the lack of finance available from the banks even with a profitable business. What these same banks have done to the economy might bring you down too and they can’t take the risk!

Against this backdrop, I thought it might be worth looking to see if we can come up with some ways of accessing funds between us, without the banks’ help.

I have suggested a few routes to look at below, but I am keen that anyone should add their own ideas to the comments on the blog post so that we can all use this as a resource.

One of the more obvious routes is financing fixed assets you already hold, for example the refinance of properties and/or equipment/vehicles. Although finance is still tighter in these areas than it was, you may well have better luck than approaching the banks.

Another option along the same lines is to fund your debtors through factoring or invoice discounting. Due to the current climate you may not be able to fund as high a percentage as previously but this could be a very useful option.

If you are based in the UK, at FC Procurement we work with good suppliers in both of these areas, if you wish to explore the options.

Equity funding may be an option for some, maybe through business angels for smaller companies. However although funds are likely to be available, investors are looking for bargains and know they can get them.

For smaller businesses, short term loans from friends and family may be an option but think carefully, as if things don’t work out as planned you may damage a lot more than your credit rating.

One of the more innovative ways of accessing funds we have come across has now been used by a number of our owner-managed (UK) clients. It is now possible, under certain circumstances, to access personal pension funds to invest in private companies. A number of clients have used this method to access money tied up in pension funds from previous employers or in personal pension plans to invest cash in their own business.

This essentially brings a new equity investor into the business, without having to find one, allowing the long-term growth of the business to accrue to the owner for his/her retirement. This route may not be for everyone and you will need to talk to an Independent Financial Advisor (IFA) to discuss whether it is the right route for you. If you want to know more, we work closely with an IFA with experience in this field and can introduce you. Just drop me an email (glen@feechan.co.uk) or call on 0845 6439693.

These are just a few ideas, but please add your own in the comments below. Together we can get through whatever is to come.