Financial Modelling, Management Reporting & Training

March 2010


"The Barrow" by Jeff Robson Connect on LinkedIn

Jeff Robson: Click to e-mail meHello !firstname!

In this issue:

@ The West is Best

@ Go RRR at IRR!

@ Full-on

@ Say what you want!

Can you believe nearly one quarter of the year has passed already and it's almost Easter?

There's lots happening at the moment ... here are just a few things you won't want to miss:

Lunch & Learn Event: "I Never Knew Excel Could do THAT!" (Perth, WA)

Think you know what Excel can do? Maybe there's more!

Come along to this Lunch and Learn event and you'll really see the things this program could do for you in the hands of a true expert!

  • Cut data entry time and reduce errors
  • Automate processes and save time
  • Visualise answers
  • … plus loads more tips, tricks and techniques!

More Information ... be quick! The last event was sold out!

 

Training Courses
A2 30 Mar 10 High-Powered Excel for Finance
AUD795 (1 day) : Perth
Book
C1 15-16 Apr 10 VBA Macro Fundamentals
AUD1,590 (2 days) : Perth
Book
E4 20 APR 10 Upgrading to Excel 2007 for Finance
AUD795 (1 day) : Perth
Book
E5 29 APR 10 Maximising your Excel Productivity
AUD395 (0.5 days) : Perth
Book

Plus plenty of other courses around the world.

Information on all training courses has been significantly expanded and enhanced so it's easier than ever for you to browse, find and book.

Now ... let's jump into The Barrow!

Jeff Robson


In this issue...

@ The West is Best

@ Go RRR at IRR

@ Full-on

@ Say what you want

 

 

WA Businesses Most Confident

Businesses in Western Australia are the most confident in the country, with the state registering a lead of more than 10 index points according to the latest National Australia Bank survey.

Full Article

Comment: "What GFC?" That's the current mood of businesses here in Western Australia.

While it's not quite a Global Financial Christmas (yet), Australia and particularly Western Australia have rebounded strongly this year already with plenty of signs of even more to come.

Contrary to just 3-6 months ago, everyone is now talking about the next resources boom, trying to find enough staff and looking to expand.

I shudder to think what could have happened if China hadn't been there to save the resource-rich countries like Australia and provide finance to other developed countries!

3 Things I Hope we've Learned from the GFC:

  • It's actually important for people borrowing money to have adequate income ... and a deposit.
  • Don't buy financial products unless you understand them.
  • Nothing is as bad (or as good) as the media makes out.

Every day, we help clients with modelling scenarios, evaluating opportunities, and presenting information to investors. So if you know someone who might need a hand in any of these areas, they'll love you if you forward this e-mail to them or called me on +61 8 6210 8500.

Discuss: What do you think are the key learnings for the world from the GFC?

 

 

IRR vs RRR Vs WACC

"My son can tell me the price of everything, yet he knows the value of nothing". Anon

Have you been lying awake at night, wishing you could sleep but finding you can't because you're worried about the difference between IRR, RRR and WACC?

No? Me neither!

But if you'd like to know a little more about what these terms mean and how they're useful in financial modelling, this article might help.


 

   
 

Better Excel: Full Screen, Full-on

See more of the sheet grid

Sometimes you want the Excel sheet grid to fill as much of the screen as possible. To do that you can use Excel’s full screen option.

Excel 2007 – in the View Ribbon click Full Screen button in the Workbook View section. Press the Esc key to return to normal view.

Excel 2003 – in the View menu click Full screen. A Close Full Screen option should be displayed to click to return to normal view, or you can click the View menu again and select Full Screen.

   
 

Talkback to us!

If it's your mum (mom) or Leeroy Jethro Gibbs, back chat will probably just get you a clip around the ears ... but we're more than happy if you talkback to us!

You now have the ability to leave your comments, suggestions and feedback on any and every knowledge base article we have!

  • Have we missed something?
  • Would some additional information make the article more useful?
  • Is there anything that isn't quite right (surely not!)?

Just let us know! But please ... no comments about your mum/mom!

 

   

Do you know of any CFO's, analysts, accountants, or finance professionals who use Excel? Why not forward them a copy? They'll love you for it!


This message was sent to you at !email! because you are subscribed to our newsletter. 

Change Subscription - visit this page if you'd like to change your e-mail address, name, or newsletter format (e.g. from HTML to Plain Text).

We do not support spam - you are free to unsubscribe at any time.  If you would like to unsubscribe, click this link: http://www.accessanalytic.com.au/unsubscribe.php?listname=barrow&email=!email!  Please contact us if you have any difficulties with this process.

Feedback  - all feedback is read and most of it is appreciated!

Access Analytic Solutions Pty Ltd
Unit 110 (Ground Floor)
131 Adelaide Terrace
East Perth
Western Australia  6004

PO Box 6284
East Perth  WA  6892
Australia

tel 08 6210 8500 (or +61 8 6210 8500 from outside Australia)
fax 08 6210 8501 (or +61 8 6210 8501 from outside Australia)

website www.accessanalytic.com.au  Meeting Request
e-mail info@accessanalytic.com.au 


© Access Analytic Solutions Pty Ltd 2009
Excel® is a registered trademark of Microsoft Corporation
Access Analytic® is a registered trademark of Access Analytic Solutions Pty Ltd

General Information: The information in this newsletter is general information only and is not intended to constitute a recommendation for securities or financial product advice. The information does not take into account the investment objectives, the particular circumstances or needs of any particular investor. Before making any investment decision you should consider whether the information is appropriate in light of your needs and you may wish to consult a professional adviser for further advice.