As we go into the new year, 2018, I want to share with you for free my latest book: Power BI for the Busy Professional.

To let you have a glimpse of the value in it, below is the preface:



I started my data analysis career with Comviva – Airtel Africa creating daily, weekly, monthly and ad-hoc reports for the entire operations in the CRBT product unit across Africa. The company operated across ten countries in Africa then and I was creating between 11 and 30 reports daily. The company had just moved to Africa after Bharti Airtel acquired Zain Africa operations, so everything started from scratch – my colleagues and I had to build everything from scratch.

Power BI is the tool I wish we had then. I would have been able to automate all our reports with ability to drill down and drill through, allowed each country operations manager see only what is within their region/country while the big bosses overseeing the entire continent can see everything. I would not have needed to work on public holidays that were local to us since the other country guys needed their reports and were not on holidays.

Most importantly, I would have been able to build more insightful reports and ones focused on providing business intelligence, I would have had more time to do more strategic revenue improving activities rather than slaving away at recurrent reports making. And the management would always have all the data and reports they needed in a very interactive and real-time way.

This book is to give you what I lacked then; it is my own way of making it easy for you to learn and immediately start using Power BI without having to take a leave off work or risk migraines. I have used very easy to follow illustrations with a hands-on approach to ensure that it would be fun and easy for you. You are already a busy professional, this book is to fit perfectly into your life and not disrupt it.

And about me? I am a four-time Microsoft Most Valuable Professional (MVP) and the only one in my area of award in Africa. Helping people and companies make the most of their data is what I do full-time. I have also written books and created online courses that have been used by over 18,000 people across the world. You can connect with me on LinkedIn: https://www.linkedin.com/in/olafusimichael/



You can download the book from Amazon Kindle today for free at https://www.amazon.com/dp/B078NF5XYP or get the PDF version at https://drive.google.com/file/d/1Mj_LRdhZJhoX5A6AxpT3wNDWtKqKB86c/view?usp=sharing 





Enjoy! And a wonderful 2018 to you!
Today's guest post is from someone I have lots of respect for and who wishes to be anonymous. Someone who has been there since before my life took a drastic turn -- even provided help when GTBank wanted to ruin me in 2014.

Enjoy!

image: smallbankmanager.com

There is no social security system in our dear country Nigeria. If you lose your job, lose your ability to hustle or get a terrible disease and you have no family to take care of you, you are basically screwed. For this reason we must self-insure by becoming financially independent. This does not mean all unforeseen disaster is 100% covered – war could break out, stock markets could crash, governments could fail etc. However, one can at least reduce risk to as low as reasonably possible by becoming financially independent. Everyone can become financially independent. Some will have an easier path than others: those in the middle class and above.

The first step is to save 50% of your income. This is a minimum savings rate. No buts, no ifs, no excuses. There are several sites that show how fast one will achieve financial independence as a function of the savings rate. In case you haven't come across one, check out this one here. This savings rate does not depend on your actual income. So whether you earn N20,000 or N200,000 or N2,000,000, the same minimum savings rate should apply. There are people who live on less than N10,000 per month. Do whatever it will take to live on only half of your income. Refer to the book “The richest man in Babylon” if you have any reason why you think this will not work for low incomes.

Max out your pension contribution. The law in the Nigeria is that employees contribute as a minimum, 8% of their earnings to a pension scheme with a minimum employer match of 10%. If you are self-employed, contribute 18% of your earnings to a pension scheme. It is very easy to open a pension account. Additional contributions over the 18% are tax deductible as long as you make no withdrawals within 5 years of making the contribution however since Dec 1 2017, it is no longer withdrawable tax free. Retirement age is 50 years.

Invest your savings. Invest in what you know and understand. I prefer real estate, self-owned business, low cost index funds and money market instruments (e.g. treasury bills, bonds). Diversification is key. Put your eggs in many baskets. Don’t fall for quick money making schemes. Invest in low risk instruments if you do not have the appetite for high risk investments. Invest with a focus on generating alternate income. Re-invest the income generated until you retire and wish to begin withdrawal. Your withdrawal rate must be lower than your investment growth rate after accounting for inflation. Being in Nigeria makes accounting for inflation a herculean task but it is still possible to do so.

Give out a minimum of 10% of your income. You may give to relatives, the less privileged, church, charities etc. The main concept here is to give to those less privileged and not to keep 100% of your income to yourself. Controversially, I will say, if your church owns a private jet, best to focus your giving directly to the poor. This is a personal opinion. As you mature in your quest for financial independence, you may increase this percentage.

The wealthiest people today are all entrepreneurs or inherited their wealth from their entrepreneurial parents. Stir up the entrepreneur in you if your parents aren’t multimillionaires.

Ensure you have a will so that your immediate family is taken care of if anything happens to you. I cannot over emphasize this.


Good luck!
And so we have the first guest post, by a sales coach. His bio is really long and loaded I don't know how to cut it down to a few paragraphs, so I'll just repost as sent. The article itself is not very long but still impactful. It has forced me to rethink my attitude towards phone calls and missed calls. I hope to see some good results as I imbibe the lessons he shared.

image: entrepreneur.com

Please check your phone and find out how many missed calls you had today, especially the calls you haven't returned.

Those missed calls could be missed sales.

I worked with a boss several years ago who punished us greatly when we missed our calls. We had a very steep target that year and he said we had to be very alert to block any loopholes from us missing opportunities to make money. He taught us that our phones were called 'Mobile phones' not 'Landline phones' so we were to take them with us everywhere including the bathroom๐Ÿ˜ฒ.

There's some truth in this though because over the years I've seen him grow rapidly in his career attributing it to his attitude towards his phone calls.

I've seen salespeople who don't pick their calls or return missed calls yet they complain about the economy as a result of poor sales. Some, always have their numbers going to voicemail, that's a travesty. So how in the world will clients contact you for more deals or give you referrals.

We live in a fast paced world today. If you brand yourself for not picking calls or not returning missed calls, you would not be considered for opportunities. Therefore, you'll be missing too many opportunities and it will cost you a lot. Who knows, maybe what you thought the conversation would be about would be something else entirely that could move your sales to a whole new level.



LONG BIO

Iyore Ogbuigwe is a highly sought after sales and persuasion expert for local, international and multinational corporations. He is co-leading the team that's training a 14,000 plus sales force across the six regions of Nigeria for a multi million dollar corporation and Nigeria's number one online retailer - JUMIA.

Iyore has a wealth management background from the prestigious multinational - Standard Chartered Bank - where he successfully doubled a portfolio of $3.5 million to over $7 million in only eleven months. At Diamond Bank, Iyore was overseeing a portfolio of over 700 affluent individuals; he brought in 21 High Networth Individuals to the bank in one month and was rewarded with an all expense paid trip to the FIFA World Cup.

Iyore is the managing partner at Katalyst Consulting, a training and management consulting company dedicated to helping individuals and organizations transit from potential to profit. They have a growing list of clientele, some of which include Jumia, GTBank, Access Bank, Stanbic IBTC Bank, Union Bank, First Bank, Shell, NNPC, MTN, ChamsAccess, Main One, Sage, Jobberman and the Nigerian Government.

Iyore's sales and persuasion seminars tagged 'Peak Performance Selling' which hold in Nigeria, Ghana and in the United States of America have produced amazing results in the lives and businesses of the participants. Iyore is the creator of 'How To Sell When No One Wants To Buy®,' the most advanced sales system for exceeding sales targets.

Iyore was a Lead Faculty at the Lagos Business School (Pan-Atlantic University) on 'Planning and Executing Marketing and Sales Strategy' for the JCI Annual Individual Development Seminar. 

Iyore's availability is extremely limited. As such, he's very selective and he is not cheap. He is the author of 5 books on selling, he is a weekly columnist in the Guardian Newspaper on sales strategies; he has been featured on 92.3 Inspiration FM, EKO 89.7 FM and Lagos Talks 91.3 FM.

--
Iyore Ogbuigwe
NIGERIA +2348034666403
GHANA +233579415743
katalyst Consulting
https://www.youtube.com/watch?v=yFtsig3CiPI
'Video of N8.8M Deal Closed Immediately After Sales Seminar With Iyore Ogbuigwe'

image: youtube.com

First, my gift to you: If you have something of profound use to share, like an article on any general life topic or a even a technical stuff that you think some people will find of use, our friendship just got tighter.

As my Christmas gift to you all, I now allow you, my esteemed readers and friends, to reach my over 2,300 daily blog readers, hundreds of thousands of annual visitors and close to a 100,000 twitter followers with your life impacting thoughts, ideas and tutorials. Let it be meaty, with a personal touch and include your byline (short bio) so you can own the audience too. 

Just email me at michael@olafusimichael.com

I also wanna sing you a Christmas song. Enjoy!

Feliz Navidad
Feliz Navidad
Feliz Navidad

I wanna wish you a Merry Christmas
I wanna wish you a Merry Christmas
I wanna wish you a Merry Christmas
From the bottom of my heart.   
I wanna wish you a Merry Christmas
I wanna wish you a Merry Christmas
I wanna wish you a Merry Christmas
From the bottom of my heart.

Feliz Navidad
Feliz Navidad
Feliz Navidad
When you launch the Power BI Desktop, the start up screen you get has Get Data on the top left side.




The Get Data is the your first window into the Query Editor. If you are familiar with Excel, the Query Editor is the exact replica of PowerQuery. 




In Power BI, it is your main data manipulation and data cleaning tool. Once you connect to the data you want to analyse, it is good to go to the Query Editor to examine the data and, if the data needs some cleaning or transformation, do all that transformation in the Query Editor.






Clicking on Edit, when done connecting to the data, takes you to the Query Editor, and I recommend you always use Edit rather than Load which brings in the entire data without allowing for preview and modification/transformation.

Below is what the Query Editor looks like and it always opens as a separate window from the main Power BI window.


The Query Editor can be divided into four functional sections.


1. Menu section
2. Queries section
3. Data Preview section, and
4. Query Settings section.

The Menu section is more like the control panel housing all the tools you will need for most of your data cleaning and data transformation processes. In the end, it is a section you will have to be very proficient at and we will do a lot of practical demonstration of real world analysis that involves using this section.

The Queries section mainly lists all the data sources you are connected to. Right-clicking on any of the data source gives you some very useful set of options.


The Data Preview section shows a preview of the data selected in the Queries section. This gives the Query Editor some advantages over loading the data directly into the Data model, especially in a case of a large data set that would take too many system resources and time to load. By loading just a preview, one can get working immediately on the data and even set filters and formulas to pull in just the segment of the data set that is needed rather than pulling in the entire data set. It also has some useful features — like filter, rename, delete, replace errors and others.




The Query Settings serves as a very interactive and feature-rich audit trail. It allows you to see all the transformation steps carried out in applied order. You can modify any step and re-order the steps if you want.


In future chapters we will do some real world analysis that will help us further dive into the Query Editor and see its practical usefulness.

In our training classes, whenever I hear a participant say he can't find a particular menu item exactly where I pointed out then I suspect he is using Mac. And I am usually correct.


If you use the Mac version of Microsoft office, a lot of things are not the same as with the Windows version. In today's post I am going to show you the practical differences you should be aware of between the two common editions of the Mac version and the Windows version of Excel.

First of all, the verdict. My recommendations. 
  1. If you want to be a superb user of Excel for data analysis and master the new advanced tools in Excel, you will have to put aside the Mac versions of Excel. Either you get a Windows PC/laptop or create a Windows OS powered Virtual Machine on your Mac and install Excel on it. 
  2. If you already use Excel on Mac and are okay with not being able to do PowerQuery/PowerPivot, then go for Excel 2016 Mac edition. It is better designed and has more features than the Excel 2011 Mac edition (the edition before the 2016 one as Mac has no Excel 2013 edition). Microsoft has re-added the missing Macro/VBA features people complained about when migrating from Excel 2011 Mac to Excel 2016 Mac, so no reason to stay with the Excel 2011 anymore.

Excel 2011 for Mac


When Microsoft did Excel 2010 for Windows, they also made Excel 2011 for Mac. Unfortunately, their capabilities are not equal. Microsoft tried to give them both the same base features but when you want to do more, like work with Macros/VBA, enable add-ins like Analysis Toolpak or Solver, work with external data sources or do more with your PivotTable then you'll see that the Mac version is somewhat limited compared to the Windows one.

One main thing to note if you are already familiar with the Windows version of Excel is that the File>>Options menu is Excel>>Preferences in the Mac versions.



And if you want to enable the Developer menu, you'll click on Ribbon (last item in the last row) in Excel Preferences window.




Lastly, the menu on the Excel 2011 for Mac can be very confusing. They are two menu layers that you'll find yourself cycling between to locate commands/features you want to use. And it is much worse if you are already used to where things are placed in the Windows version.



Excel 2016 for Mac


Microsoft must have heard the complaints about the Excel 2011 for mac and how much people wanted similar experience and UI to the Windows version. They really did well with the Excel 2016 for Mac one. The menu items are arranged in the same way as in the Windows version. There is still the two menu layers confusion but less confusing than in the Excel 2011. The look is also very cool and mirrors the Windows one.

The main issues are still the advanced tools. And now, with the advent of PowerQuery, PowerPivot, PowerView and many more advanced features in the Excel 2016 for Windows (Office 365 one, especially), the Mac version is looking a lot more like a watered down version. 

Also, just like the Excel 2011 for Mac, the File>>Options menu is accessible as Excel>>Preferences in the Excel 2016 for Mac version.





And those are the practical differences I find between the Mac versions and the Windows version. 

If you would like to read something more official from Microsoft, then head over to https://support.office.com/en-us/article/Compare-Excel-for-Mac-2011-with-Excel-2016-for-Mac-602a6c30-e6a6-47c5-9e0d-b16af397427a (for comparison between the 2011 and 2016 editions of the Mac versions) and https://support.office.com/en-us/article/Compare-Excel-2016-for-Mac-with-Excel-2013-for-Windows-1b24f293-739c-4120-b884-893b6687e0d0 (for the comparison between Mac and Windows version of Excel).




What are your thoughts?


Happy birthday to me!

Let me try to look for a recent photo of me to share. One with my new specs/glasses. Hmm. I can't find one to share. Will share later. 

[To insert nice photo here someday]

This year has been a great one for me -- made more money than I have ever made before, finally broke free from the employee mindset (will elaborate in another paragraph) and started seriously building solutions that will sell themselves without my active involvement (mass-market products). I know it is not advisable to be very proud of one's achievements because of the common saying that pride is the beginning of downfall. So I try everyday to forget where I am coming from and how far I have come in order to avoid feeling successful and begin to invite my downfall. But if I am being objective and saying things as they really are -- three years ago I never would have believed that I would be where I am today. Not that I have an absolute much now but compared to what and who I was in 2014, now is like I hit a jackpot. And for that I am very grateful to God and all of you who have in little and big ways contributed to my progress in life.

And as a way of paying forward that gratitude, at least for those who are not happy with their current life/job and want a radical change, today I will be sharing the lessons I learned since I took the bold bet of changing my life course and followed the entrepreneurship path.

1. Employee Mindset vs Entrepreneur Mindset
My biggest obstacle was my employee mindset. The very things and skills and habits that made me a great asset to my bosses and the companies I worked for, surprisingly, were hindering my business from growing. 

You know how you used to feel when you see a junior colleague get a new job that is higher than yours in both status and pay, and then you try to pin it to some professional certification or MSc/PhD that he has and you don't? And how you always try to match or outdo your peers in your physical presentation/appearance, in being-in-charge attitude and work skills? 

The unfortunate result is that you take too many things personal. You can't afford to say no to a request from your bosses' bosses' boss. You can't afford to see other people get promotion or better new jobs without thinking they're leaving you behind. You can't think of paying someone else to do your job, the company mustn't find out or you might be sacked. You are always trying to improve your hard-skills and learning new ones.

So what's wrong with all that? Nothing, if you have a career to grow. But a lot is wrong with all that if you are building your own company. First, is that the competition mindset that helped you best other job prospects and guaranteed you promotion in your paid employment is going to ruin you in entrepreneurship. Also, if you swap pleasing your bosses with pleasing your clients no matter what, life in business is going to be brutally hard for you. Lastly, it is better to spend more time on strategy and product formulation than on the treadmill of hard-skills development. And I learned all these the hard and painful way.

In entrepreneurship, having a strategy and prudently implementing it is the key to long lasting growth. Forget about what other people are doing. In fact, forget about gaining more qualifications and certificates. Ignore what your friends in paid jobs are doing and saying, even if they earn more than your company makes as revenue. Stop trying to bend to every potential client's needs/requests. Be very structured in your services and products. Remove yourself from the operational (day-to-day) aspects of the business. Have products that sell themselves without too much custom work from you. Pay people to do what you already do extremely well (and this can be very hard in the beginning). Let all the aspects of you that don't matter to the bottomline not be a priority -- forget about your looks, your phonetics and every other thing that would have mattered in pursuit of the CEO/MD role in another man's company but don't contribute to your sales in your own company that can't fire you. 

2. Prioritize Learning What You Need Now For Your Next Business Growth Phase
Today, in church, Pastor Poju Oyemade was preaching on the right strategies for starting, running and growing your business. That rather than first getting a well furnished expensive office before getting clients, you should first learn the trading part (sell to clients first) and build the business on that learning. And many other things that are very correct and valuable. But guess what? I didn't really enjoy it. Why? Now my brain is configured to seek just what I need now for the next phase in my business. 

You won't see me attending conferences, business events and taking business courses just because they are advertised as helpful to entrepreneurs or I could find something of value there. I am not looking for something that can help me by using the scatter approach -- going everywhere and learning everything. I know what the pain points in my business are and I focus more on learning that will help me overcome those issues. I practice what is called energy management rather than time management. Time management is focused on doing more with your 24 hours a day; energy management focuses on doing the right things only. 

You won't find me learning some new hardskills if I don't know how to monetize it and have well laid out plans of fitting it into my company's big strategy. I won't even attend conferences just because some bigshots worth knowing are there. I am not looking for a job or one big contract. I know my customers and where to get them, big man your pocket. I would rather go where my conventional customers are than where some celebrated people are.

3. Long Term
I focus more on direction than speed. I don't ask myself how much I have done (anymore) but where am I heading. That is why I have stopped writing blog posts daily. I am de-emphasising activities in my life. I am a naturally hardworking person, I can't sit still without doing something. Even when I am sick, I work. I don't know how to take a vacation, the thought of not doing any serious work is not one I find appealing at all (made worse by the fact that I will be paying for the vacation). 

Now I focus more on weeding. Weeding out unnecessary activities in my life. I pick a long term goal and head in its direction. I don't bother too much about my speed of progress, I only make sure I don't do anything that isn't in the direction of my big long term goal.

That is the main reason I have not fully started the R and Python training courses. The when is not a big issue, the doing it right and properly is the priority.


And those are my birthday gifts to you all. I think they are the most valuable things I can offer. If they are useful to you, do let me know.

Cheers. And wish me long life and prosperity. ๐Ÿ˜€
First, I joined Institute of Directors and attended the compulsory training for all intending members. In the training class, I had as colleagues MD/CEO of big companies -- Nigerians, Indians, Swedish, British and other nationals. It was a very enriching experience for me, apart from the deep learning I got on how company directors are to carry out their duties. And as excepted, I was the worst dressed. My car was with the mechanic because LASTMA refused me Road Worthiness (the new way to renew the road worthiness certificate is to go for their computerised test which will almost always find something wrong). So I took public transport the first day, then remembered there is Uber. So I took Uber from the venue home the first day, and for the entire second day.

Now you have to take your car here for inspection

That's my car. Was told the brake lights are faulty, one tiny rod under the car is missing and hand-brake needs adjusting as the major faults that caused the road worthiness denial

Here is the verdict room. Excellent people, they called me back that I forgot my phone.

Iod Class. That's me on the ___ (take a guess)


I also continued my back and forth to Republique du Benin. In fact, I am currently there. And I have become a small celebrity. The people at the company I am volunteering for think I know everything. They ask me all types of questions and they always feel amazed by everything I show them. This week I showed them how to extract data from a damaged hard disk using Linux live boot and Linux commands. I also showed them how to connect two computers together using a RJ45 cable, configure the IP address and share files/folders/printers between the computers. They were singing my praises. They are more experienced on hardware and computer repair than networking and programming. So I am more like their God-send. Then today, I decided to gain from them. I asked that they help me clean off the dust I am very sure has greatly settled inside my laptop. And with small fear I watched as they dismantled my laptop. I am glad I asked for the favour because it was no small dust they found inside. Even the fan was full of dust. They gave me special treatment, cleaned every part of my laptop and used a special foam sprayer to clean the exterior making it look new.











Now the laptop looks new and is not always hot like before. I guess the dust was blocking the fan. Happy me.

We had a training class in Asaba last week and my laptop crashed on the night of the day one. It was a terrible thing. I was to continue the class the next day. Luckily, I had a colleague with me and we ended up using one of the participants' laptop. Unfortunately, the problem was a hardware one and not a simple software repair/reinstallation. I had to buy another hard disk. So I bought a 1 Terabyte SSD hard disk for N75,000. 

And that's all that's been going on in my life the last couple of days. Also, I intend to be more strategic with my blog posts since I am no longer following the one post per day rule. I will be making a lot more educational posts.

A bientot!


In september, we had a webinar on Using Microsoft Excel for Investment Planning, Personal Finance & Financial Analysis. Many people loved it and the practical application in their own personal finance and family finances/investment planning. You can still watch the recorded video on YouTube.

Today, however, I have decided to do the written version of it so many more people can benefit from it. You can download the practice along Excel file here.



There are five major formulas you need to have a good grasp of if you want to put some structure and calculations around your financial goals and investment strategy. And they are:

  1. PMT
  2. PV
  3. FV
  4. RATE, and
  5. NPER
PMT
PMT is the Excel formula you use to determine how much you need to save regularly (weekly, monthly, yearly) in an interest bearing account to achieve a particular set financial goal (education fund for your children, buy a house, buy a car or be a multi-millionaire). It is also the formula you use to calculate how much you pay back monthly or yearly for a loan that requires you to pay back the same amount (to cover both interest and principal) over the lifetime of the loan.

How it works is very easy. And below are the transcripts of the demonstration in the video and practice file.

a. Want to have N20 million saved in an education fund for your children by 2030 (13 years time).
Question: How much should you contribute in a 15% annual interest bearing savings/investment account?


PMT has five parameters:
  • Rate: The interest rate. And in this sample case, it is the 15% annual interest rate.
  • Nper: The number of periods. In this case, it is the number of years you plan to save for, 13 years.
  • Pv: Present Value. How much you currently have saved in the investment account. In this case, since we are starting from scratch, that would be zero.
  • Fv: Future Value. The final amount you want in the investment account by the end of the specified period. In this case, 20 million Naira. Notice the minus I put in the formula, it's just a technical way of getting Excel to show the answer in a positive value. That's all.
  • Type: Will you be saving at the end of the year or at the start of the year. For end of year, you put 0 or leave it empty, and for at the start of the year, you put 1. The logic applies for other types of period -- weekly, monthly etc.
One very important thing to note is that the rate and number of periods must agree. You can't use annual rate to calculate monthly contributions without first converting that annual rate to monthly rate. You should check out the part in the practice file on monthly contribution for the same goal to get a good grasp of how to convert from annual rate and annual period to monthly rate and monthly period.

b. You bought a 3 bedroom flat for N100 million and were allowed to do 25% down payment while flexible spreading the remainder in a monthly repayment at a 2% monthly rate.
Question: How much will you pay if you spread the payment over 5 years (60 months)?


Try figure this one out and compare your answer with mine. 

In this sample case, PV is the loan amount outstanding. NPER is the duration. Rate is the repayment interest rate. FV is zero since you mustn't owe them anymore at the end of the duration nor pay them excess. And TYPE is at month end repayment (hence, the leaving empty).

PV
PV is for calculating the worth of an investment project after factoring the cost of the capital (loan interest rate, if you borrowed the money from the bank). 

c. You are part of board of directors for a manufacturing company. They are considering a business idea that will cost N300 million and generate N50 million every year into the 9th year.
Question: If the company's cost of capital (discount rate) is 15% what will be the present value of the business idea if executed and is it a profitable one?


Notice how there is all those components of PMT formula in there -- Rate, Nper, Fv and Type. They still mean the same as previously explained. This time, though, we have the periodic inflow/payment from the business project (same as PMT) and want to calculate the present value/worth (PV). If we can be able to service the cost of the capital deployed and still turn a profit (pay back both the interest and capital of the borrowed money to finance the business idea, and still have something left as profit/compensation for all our stress).

Again the minus in the PMT box is to get Excel to display the final answer in a positive figure. Nothing more.

FV
FV is a very interesting and useful financial planning formula. It allows you estimate how much you will have in an interest bearing account if you do consistent periodic (weekly, monthly or yearly) contribution/saving. 

d. You invest/save N40,000 monthly in a 15% interest rate investment account. 
       Question: In 10 years, how much will you have? What about in 30 years?

 
I don't think I need to explain how this work, based on all my previously explanations you should be able to figure out how it works.

Also notice how the future value stratospherically increase when you save for 30 years as against the 10 years? That is the power of compound interest.

RATE
This is useful for those who take microfinance loans or co-operative loans or buy land on installment payment or any loan that you are required to pay specific constant amounts regularly. It would make a lot of sense to calculate what the actual rate of the loan is, since most times they don't provide you the rate.

e. My dad took a 6 months loan of N400,000 from LAPO Microfinance bank. He would be paying back N479,000 split into equal monthly payments.
Question: What is the rate he was given the loan at?


No comment. You go figure out.

NPER
This is useful for calculating how long it would take you to finish paying for a car or home if you opt for an installmental payment amount you choose. 

f. Your company has a car loan scheme. You took N4 million loan to buy a car and you are allowed to make monthly repayment at a 2% monthly rate.
Question: How long will it take you to pay off the car loan if you make a monthly payment of N200,000?


No comment. You go figure out.

Don't forget to watch the demonstration video and work along with the practice file.