All articles with 'finance' Tag

Classically, known as “interest on interest”, compound interest is the most common type interest used in every day finance situations.

To calculate compound interest in Excel,

on principal amount P
at the rate of interest R
for the number of years N
and compounded T times per year
we can use the formula = P*(1+R/T)^(N*T)

In this article, understand how to calculate various kinds of compound interest values using Excel formulas.

We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I  am sharing the top 10 accounting KPI calculations. These are… Topics ? Net Profit Margin Net Profit Margin = Net Profit / Sales Positive profit margin indicates business is profitable while negative indicates the business is in loss. ? […]

This is a guest post by Sohail Anwar. 

Why do so many of us use Excel? Let’s trace it back to the ’80s when Microsoft hit gold by being the first out of the blocks with the widely available operating system that was somewhat dummy proof.

Suddenly everyone could aspire to launch ‘Nukes’ like a fresh faced Matthew Broderick in the film ‘War Games’. 

By the early 90’s Windows had become even more established relative to other Operating Systems, so much so that PC manufacturers were developing components around Windows’ capabilities and suddenly PCs were Windows machines. As big business began accepting the significance of computing, Microsoft started winning huge licensing contracts with all the major corporations in all sectors, but the Finance sector in particular, where Excel would be king, was having an exponential boom at this time. For big organisations, once you spent a fortune buying licences for the Operating System it only made sense to purchase the seamlessly integrated and carefully developed/tested apps to run on them; enter Excel, Word, PowerPoint and eventually Outlook. Fast forward to 2015 and we are firmly in the age of second generation corporate professionals who have developed much of their productivity skill sets around those particular Windows tools. While all the excellent tools have their place, Excel stands out and here are 8 reasons why you need to up your Excel game more than ever this year.

Did you know What Happened at Last Coffee Day?
Mr. Bean “dressed up” the financial statements and was caught in the fraud. But he was the CEO of Latte! So why did he commit fraud in his own company??

Any Guess?

Take a cappuccino and I will give you a hint – How was Mr. Bean’s Bonus to be decided?

Read on to know more…

A Quick Question for you!
Don the hat of a financial wiz today. What I have for you are the financials of two companies: Cappuccino and Latte – Two dot com companies (Sometimes they also make revenues ;-))

Which is better – Cappuccino or Latte? ( Hint: It’s a trick question! 😉 )

It may seem obvious that Latte is performing better (Higher the revenue, the better the performance!). Sometimes a single source of data does not speak the full story!

Last time we had discussed the use of SumProduct() to ease your life for calculation of consolidated revenues and depreciation. This time we would be using the sum function! Yes you heard it right – The Sum function.

But we would use the Sum function with a small trick! We would use it to calculate running cumulative sum! And believe me, you would need this function so many times – to calculate accumulated depreciation, cumulative debt, Profits to Retained Earnings and almost all the accounts that would consolidate into the balance sheet.

You take an apartment on rent at $1000 per month and the owner puts an escalation clause saying 10% increment each 3 years. How do you model this in excel? In this tutorial we understand how escalations at certain frequency can be implemented using the mod function in excel. What is the mod() function Simply […]

Instead of searching for the NAVs of all my funds at MyIRIS or MutualFundsIndia, I have developed a small excel sheet which will fetch the values for me and displays the current portfolio value at the click of a button. Here I am trying to share the “HOWTO” of the same. Create an excel workbook […]

Birth and Early Stages:> Look up for cool names in google> Post the newborn pics in orkut. Format them in Picasa. Share them with friends using Blogger School & College:> Use Gtalk to chat with friends. Bye bye bfone!> Goodbye to combined studies, welcome google groups.> Doubts about what is the latest ninth planet? may […]

I am feeling beautiful and happy. And let me warn you, I am not yet placed 😀The world is full of new ventures, new ideas and new things. Everyday I see something new happening somewhere, something so simple and beautiful being done by somebody out there, thanks largely to my net connection. I couldn’t wait […]

The traditional theories of corporate finance have 2 viewpoints. They are, Shareholder value maximization is much more important than growing ones own limbs, stealing office stationary and gossiping at the water cooler. No one ever bothered to read the second bullet point. But the world from now onwards is not going to be like that. […]

Well, this is not an unseen sight in most of the business schools. In search of something more than the obvious facts most of us end up speaking gibberish clad, verbose rant when someone asks simple questions like ‘when is the class?’. Majorly this happens because everyone tries to be intellectual and superior by displaying […]

After lot of thought and reconsiderations I have made my decisions for electives. On the outset the list or electives may look like I am doing general management, but I have ended up taking all courses related to marketing. I know this is a tough choice to make as i will have to spend rest […]

Welcome to PHD Blogmela. Just now completed reading all the posts nominated and boy!, this is going to be a real Indian blogmela. Majority of the nominations centered around India as in they spoke about India rather than about some Indian. Ok, I am not wasting anymore time. Lets jump in to the PHD Blogmela. […]

When i was a kid, i was fascinated by numbers. So much so that I used to top all the maths courses. Later during the engineering first year when I failed to add 2 matrices in the final exam I felt like suiciding. It was such a shame for me. All the penchant for numbers […]