Loan Amortization Schedule in Excel – FREE Template
Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.
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. ? […]
Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel
Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,
- Introduction to IRR & XIRR functions
- Calculate rate of return from a set of cash-flows with XIRR
- Simulating purchase or terminal value changes with data tables
- Apply conditional formatting to visualize the outputs
- Common issues and challenges faced when using XIRR
Should finance people learn Power BI?
I recently went to Sydney to conduct some training programs on Advanced Excel and Power BI. While I was there, I met my good friend Danielle, who runs Plum Solutions, a financial modeling consultancy & training company. We got talking about various things and the topic eventually turned to “finance people and Power BI”. We […]
Which power plan is best for me? Excel for everyday problems
We had to switch power providers soon, so I started reviewing the options. There are heaps of providers in New Zealand and each offer a ton of different plans. Some offer welcome bonus or credit worth up to $ 200. Other offer straight forward rates. Some others offer discount if you sign up for both electricity and gas with them. So how do you decide which one is better for you?
Using Excel of course.
The result is awesome. I ended up saving more than $1000 with a simple model. Puzzled? Curious? Check out this short but powerful video tut.
Sara’s Copy Shop – Break even analysis and what-if modeling in Excel [Videos]
Last week, I asked you to share an analysis problem that you couldn’t solve in Excel. We got quite a few very interesting problems in comments and email. In this post, let me explain how to solve Sara’s copy shop problem using Excel.
What is Sara’s copy shop problem?
Thanks to Caroline who posted this problem.
Sara wants to open a copy shop. Each copier costs $5,000 per year to lease. The rent & other fixed costs per month are $300. There is a $0.02 variable cost per copy. Each copier can print up to 100,000 copies per year. She plans to charge $0.11 per copy from her customers. Sara estimates that the demand can be any of the 4 values – 500, 1000, 1500 or 2000 copies per day.
- Build a model to estimate profit per given number of copiers & demand values
- Find the mix of copiers & demand values that can make maximum profit for Sara (copiers – 1 to 6, demand – 500 to 2000)
CP042: Financial Analysis & Modeling concepts – 101
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 42nd session of Chandoo.org podcast, Let’s talk about money. We are going to learn about various concepts that are vital for doing financial analysis and building models.
What is in this session?
In this podcast,
- Quick announcement about Awesome August
- 5 key finance concepts
- Time value of money
- Compound interest
- Risk free rate of return
- Net Present Value – NPV
- Internal Rate of Return – IRR
- Case study – Uber vs. Your car
- Conclusions