Accounting On Excel with Amaka Ifebunandu

Accounting On Excel with Amaka Ifebunandu Accounting On Excel provides practical and relatable tips on how to manage your personal and busines

🎯 One of the best indicators of learning is not views. It's implementation.When I published the tutorial on building a 3...
17/06/2026

🎯 One of the best indicators of learning is not views. It's implementation.

When I published the tutorial on building a 3-Statement Financial Model in Excel, my goal was simple:

To break down financial modelling into a practical, step-by-step process that finance professionals, students, and aspiring analysts could follow and apply confidently.

Over the past months, I have received messages from professionals who have:

✅ Successfully recreated the model from scratch

✅ Built their own versions using different business scenarios

✅ Improved their understanding of how the Income Statement, Balance Sheet, and Cash Flow Statement interact

✅ Finally understood concepts they had previously struggled with, such as working capital, depreciation schedules, debt modelling, and statement linkages

As an educator, this is the most rewarding feedback.

Not because people watched the video.

But because they applied the knowledge.

💡 A lesson I have learnt over the years:

Financial modelling is not mastered by watching tutorials.

It is mastered by:

✅Building
✅Breaking
✅Troubleshooting
✅Rebuilding

Every time you recreate a model yourself, you move from understanding formulas to understanding business logic.

And that is where real learning happens.

One particular feedback stood out:

"I always thought financial modelling was too complex. After following the tutorial and recreating the model myself, I now understand how the three statements connect and flow together."

That is exactly why I create these tutorials.

To make finance practical.

To make Excel useful.

To help professionals move beyond reporting and develop skills that support decision-making.

If you have watched the tutorial, I would love to hear from you:

What was your biggest takeaway?

And if you have recreated the model, what part challenged you the most?

🎥 For those who haven't watched it yet, you can access the tutorial here:
▶️ https://youtu.be/TTUWCV0ZjCE

Step-by-Step Model Structure1. Build a Clean Assumptions SheetCreate a single tab (“Assumptions”) to house all inputs - ...
16/06/2026

Step-by-Step Model Structure

1. Build a Clean Assumptions Sheet

Create a single tab (“Assumptions”) to house all inputs - growth rates, unit prices, cost percentages, CapEx schedules, tax rate, debt terms. Link every formula elsewhere back to these cells so that updating your inputs instantly refreshes the entire model.

2. Forecast Revenue & Cost of Sales

Volume × Price drives juice sales.
Training revenue is a simple growth curve.
Compute raw material and packaging costs as percentages of total revenue.

3. Calculate Operating Expenses & Depreciation

Personnel, marketing, SG&A lines link to revenue.
Set up a depreciation schedule for existing assets plus new refrigerator and juicer purchases, using straight-line lives.

4. Construct the Income Statement

Link revenue, COGS, operating expenses, and depreciation.
Apply a 20% corporate tax rate to pre-tax profit.
Output Net Income each year.

5. Build the Balance Sheet

Assets: Cash, receivables, inventory (modeled via days-sales-outstanding, days-inventory-on-hand), fixed assets (net of accumulated depreciation).

Liabilities: Payables (modeled via days-payables-outstanding), existing debt, and new loan drawdown/repayments.

Equity: Opening balance + retained earnings (cumulated net income less dividends, if any).

Ensure Assets = Liabilities + Equity each year.

6. Assemble the Cash Flow Statement

Operating Activities: Start with Net Income, add back depreciation, adjust for working-capital changes.

Investing Activities: Subtract CapEx spend.

Financing Activities: Include loan drawdowns and repayments.

Confirm that the year-over-year change in cash on the Balance Sheet matches ending cash from the CF statement.

7. Run Sanity Checks
Does the cash-flow statement’s net change in cash equal the cash-line movement on the balance sheet?
Do all subtotals reconcile?
Format key ratios or a simple dashboard (e.g., EBITDA margin, debt-to-equity) for quick insights.

Watch the video in the comments

A properly linked set of financial statements lets you:✅Project future profitability by adjusting revenue and cost drive...
15/06/2026

A properly linked set of financial statements lets you:

✅Project future profitability by adjusting revenue and cost drivers
✅Test scenarios (e.g., price changes, volume growth, CapEx spikes)
✅Ensure accuracy through balance-sheet integrity and cash-flow reconciliation
✅Communicate insights clearly to stakeholders and decision-makers

Whether you’re a finance professional at an NGO, a small-business CFO, or an aspiring analyst, mastering a robust Excel-based forecasting framework is essential.

In this video, we’ll walk through how to build a dynamic, driver-based three-statement model, capturing the Income Statement, Balance Sheet, and Cash Flow Statement using a real-world demo case.

Though our demo is denominated in Nigerian Naira (₦), all techniques apply globally.

Data tells a much better story when viewed over time.That's where Excel Timelines become incredibly useful.In this dashb...
12/06/2026

Data tells a much better story when viewed over time.

That's where Excel Timelines become incredibly useful.

In this dashboard project, we used Timelines to analyze performance by:

📅 Month
📅 Quarter
📅 Year

This allows decision-makers to identify trends, seasonal patterns, and performance changes quickly.

If you're still manually filtering dates in Excel reports, you need to learn this feature.

Watch the full dashboard tutorial and see how it works.

One of my favorite Excel features for reporting is the Slicer.Instead of creating multiple reports, Slicers allow users ...
11/06/2026

One of my favorite Excel features for reporting is the Slicer.

Instead of creating multiple reports, Slicers allow users to interact with a dashboard and instantly filter results.

Want to see only Northern Region sales?

Click.

Want to analyze a specific product?

Click.

Want to compare performance across categories?

Click.

That's the beauty of interactive dashboards.

In the tutorial, I show exactly how to connect Slicers to Pivot Tables and create a professional reporting experience.

Watch the full tutorial on YouTube.

Revenue tells one story.Expenses tell another.The real insight comes when both are analyzed together.In the dashboard tu...
10/06/2026

Revenue tells one story.

Expenses tell another.

The real insight comes when both are analyzed together.

In the dashboard tutorial, we used Pivot Tables to compare:

📈 Revenue
📉 Expenses

Across different periods, products, and regions.

This helps management understand where profitability is being created and where costs may be increasing.

Data becomes powerful when it helps answer business questions.

Learn how to build this dashboard from scratch in the full YouTube tutorial.

Imagine managing a business that sells products across multiple regions.One question management will always ask is:"Whic...
09/06/2026

Imagine managing a business that sells products across multiple regions.

One question management will always ask is:

"Which region generates the most revenue?"

Instead of manually filtering thousands of rows, Pivot Tables can summarize this information instantly.

In my latest tutorial, I demonstrate how to build a dashboard that allows users to analyze revenue performance by region with just a few clicks.

That's the power of data analysis.

The faster you find answers, the faster you make decisions.

Watch the complete tutorial on YouTube.

Most businesses already have valuable data.The problem is not the lack of data.The problem is turning that data into mea...
08/06/2026

Most businesses already have valuable data.

The problem is not the lack of data.

The problem is turning that data into meaningful insights.

In this tutorial, I used a Fruit Juice Production and Sales Company dataset containing:

✅ Date
✅ Region
✅ Product
✅ Sales Price
✅ Cost Price
✅ Quantity Sold
✅ Revenue
✅ Expenses

Using Pivot Tables, Timelines, and Slicers, we transformed raw data into an interactive dashboard that answers critical business questions in seconds.

If your reports are still taking hours to prepare manually, this tutorial is for you.

Watch the full tutorial on YouTube and start analyzing data like a professional.

When I started my professional career as an accountant, one of the biggest challenges I faced was not knowing what an ac...
05/06/2026

When I started my professional career as an accountant, one of the biggest challenges I faced was not knowing what an accounting software looked like or how to use one.

At the time, I was working as an Accountant and Administrative Officer in an IT company. One day, my boss asked me to recommend an accounting software that could help streamline our accounting processes.

Naturally, I reached out to senior colleagues for guidance, hoping they would point me in the right direction. Unfortunately, no one could offer the support I needed.

That was quite frustrating at the time.

I relied heavily on Excel, but truth be told, I was not even proficient in it yet. You can imagine the dilemma I found myself in.

Then life took an unexpected turn.

While still on the job, I was involved in a severe accident that confined me to bed for a number of years. Looking back today, that challenging season became one of the most transformative periods of my life.

It was during that time that I committed myself to learning different accounting tools and developing strong Microsoft Excel skills.

Today, as a way of supporting young graduates and professionals who are building a career in finance but have little or no exposure to accounting software, I have created a free tutorial of just over one hour on how to use QuickBooks Accounting Software to perform key accounting tasks.

My goal is simple:

To help you gain practical exposure and build the confidence to confidently state on your CV and during interviews that you possess working knowledge of QuickBooks Accounting Software.

As you go through the tutorial, I encourage you to practice alongside the lessons. Practical application is where real learning happens.

If you would like access to the QuickBooks software for practice, comment "QuickBooks" and I will share the link with you.

I wish you the very best in your career journey.

Also, take some time to explore my channel for other tutorials designed to equip you with practical skills, tools, and knowledge that can accelerate your professional growth.

I am rooting for you.








Address

Rayfield/Fwavwei, Behind Rayfield Medical Center
Jos

Opening Hours

Monday 09:00 - 17:00
Tuesday 09:00 - 17:00
Wednesday 09:00 - 17:00
Thursday 09:00 - 17:00
Friday 09:00 - 17:00

Telephone

08064136773

Website

Alerts

Be the first to know and let us send you an email when Accounting On Excel with Amaka Ifebunandu posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The Business

Send a message to Accounting On Excel with Amaka Ifebunandu:

Shortcuts

Share

Category