fbpx
Search
Close this search box.

All articles with 'finance' Tag

Compound Interest Formula in Excel

Published on Apr 2, 2024 in Learn Excel
Compound Interest Formula in Excel

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.

Continue »

Top 10 Accounting KPIs and How to Calculate them in Excel?

Published on Aug 8, 2023 in Financial Modeling, Learn Excel
Top 10 Accounting KPIs and How to Calculate them in Excel?

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. ? […]

Continue »

8 Reasons you must get better at Excel in 2015

Published on Jan 12, 2015 in Learn Excel
8 Reasons you must get better at Excel in 2015

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.

Continue »

Dressing Financial Statements – What Motivated Mr. Bean to Defraud Latte?

Published on Dec 11, 2012 in Financial Modeling

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…

Continue »

Financial Ratios – Cappuccino or Latte?

Published on Nov 21, 2012 in Financial Modeling
Financial Ratios – Cappuccino or Latte?

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!

Continue »

Accumulated Depreciation using Mixed References

Published on Jul 19, 2011 in Excel Howtos, Financial Modeling
Accumulated Depreciation using Mixed References

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.

Continue »

Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]

Published on May 24, 2011 in Financial Modeling, Learn Excel
Mod() function in excel to Implement Escalation Frequency [Financial Modeling Tutorials]

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 […]

Continue »

Howto: Excel Based Mutual Fund Portfolio Tracker

Published on Nov 13, 2006 in Learn Excel, personal finance

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 […]

Continue »

Google Life!

Published on Sep 13, 2006 in Random

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 […]

Continue »

Some things and Some links…

Published on Dec 17, 2005 in Random

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 […]

Continue »

Shareholders, value creation and all that bushllit

Published on Nov 24, 2005 in Random

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. […]

Continue »

Come again?

Published on Jul 3, 2005 in Random

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 […]

Continue »

Of career and electives…

Published on Mar 25, 2005 in Random

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 […]

Continue »

The PHD Blogmela

Published on Mar 5, 2005 in Random

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. […]

Continue »

FINdigestible!

Published on Feb 20, 2005 in Random

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 […]

Continue »