Categories
Business Tools

Personal budget calculator for business owners – free template

For small business owners and entrepreneurs

Budget calculator for business owners using spreadsheet.

As an entrepreneur or a small business owner, you can create a simple personal budget calculator to help your financial planning.

This article explains the important columns and what they represent to help you in preparing your own spreadsheet calculator.

Personal budget calculator for business owners

The use of a personal budget calculator

A personal budget calculator helps you to track your income and spendings. You may need it for personal reference.

In addition, a funder or an investor giving you a start-up loan could use part of this information to determine whether or not you’ll be able to meet your start-up loan repayments.

Therefore, as a small business owner if you ever need to borrow funds, you’ll need to show that your average monthly income minus costs and expenses are such that you’re not overspending.

Otherwise, you could be taking out of the money meant for the business and that is not a good sign.

Therefore, with a personal budget calculator, you can easily keep track of your personal income and expenditure.

Watch the tutorial here:

How to create a personal budget calculator from scratch

The first thing you need to do to create a personal budget calculator from scratch is to open a blank spreadsheet.

Create a personal income section in a budget calculator

In order to create the personal income section, you’ll need to add the following four columns:

a. Personal income column

Under this column is where you list all of the sources of personal income you earn in a month. For example:

  • Salary from an employer
  • Other income

The number of items under this column will depend on your personal situation.

If you need more rows just insert and add as many as you need.

b. Notes

Add a brief description for any items to help someone else understand each source of income. For example under income you can make a note that the income is from contributions.

c. Monthly net income

Include the value for each item under this column. For this column, you can rely on your bank statements to get an average of last three months for the items that are not recurring.

Your net monthly income is the final amount you get from each item less any deductions.

For example the net income from your salary is your ‘take home pay’.

d. Annual net income

In this column, you’ll need to include a formula – each monthly net income multiplied by 12.

For example, the annual net income for ‘salary from employer’ is calculated by the formula =C2*12.

Click on the cell and drag down the plus sign for the rest of the items.

That is, annual net income would be calculated automatically for you by multiplying your anticipated monthly income by 12.

Add the annual net income (use = SUM ()) to give the annual total income from all sources.

Create a personal expense section in a personal budget calculator

Copy and paste the entire personal income section a few lines away to create the personal expenses section and edit the columns.

Change the columns to:

a. Personal expenses

The items you list under this section are the expenses you personally incur in a typical month. That is, the money you personally spend each month.

For example, if you share the rent or utilities payments with your other then you only need to include the amount that you pay – not the whole rent owed on the property.

Other items you can have under personal expenses are  personal loan repayments, utilities bills, childcare or school fees, personal savings or monthly grocery bill etc.

Just like in the personal income section, the number of items you include will depend on your personal situation.

b. Notes

Add a brief description for any items to help some else understand each of the expenses you list.

c. Monthly expenses

This is the value of each personal expense item in your budget.

d. Annual expenses

If you are using the template this is auto-calculated. However, you can get the annual expenses by multiplying your anticipated monthly expenses by 12.

If you copied and pasted from the income section, the formula is the same i.e. monthly expense cell multiplied by 12 i.e. C2*12.

Click on the cell and drag down the plus sign for the rest of the items.

Monthly balance

If your personal expenses are greater than your personal income each month then, this figure is negative (in deficit).

It means that your business will need to bring in sufficient income to help you cover these costs.

This might imply that you’ll need to spend part of the money meant for your business to cover your personal costs.

Therefore, in your Cash Flow forecast your salary will be zero.

Otherwise, if you are earning more income than you are generating costs, the figure is positive (in surplus).

This means that any money you take from your business as a salary will be a bonus.  

You don’t need make any changes to this column and any column in yellow because these figures will auto-populate.

Annual balance

The annual balance is the remaining balance after you remove all your total expenses from all areas from your total income from all sources.

You may not need this figure for anything other than for reference.

The annual figure will not be used in your Cash Flow Forecast.

Conclusion

You can watch the tutorial video on how to make a simple personal budget calculator using a spreadsheet below.

Otherwise, you can download the free template here.

Categories
Business Tools

HOW TO REMOVE IMAGE BACKGROUND USING PAINT 3D

Remove image background using paint 3D. Using the windows built-in creativity application to remove image is very simple.

As a small business owner or entrepreneur, use this application when you need to make video thumbnails or posters for your website.

The application comes with your Windows 10 so it is free to use.

In this short tutorial, we’ll create a YouTube thumbnail together using paint 3D.

Get image

There are many websites to get free to use images for your design. Some of my favorites are Pixaby, Pexels and Unsplash.

Many of the images are ready to use. That is, they already have transparent background.

However, if you do not like a particular background or the picture you like does not have a transparent background, you may want to change it.

Sometimes, you may also need to combine pictures to fit a particular concept.

For this tutorial I got two images and I’ll remove the background.

remove image background using paint 3D. Make image transparent.
Image by Awala
remove image background using paint 3D. Alternative to photoshop and free
Image by Callmejalloh

Afterwards, I’ll combine the separate pictures and use as a thumbnail.

Watch the demonstration video below:

Follow these steps to remove the background from images using Paint 3D

Step one

Open Paint 3D and start a New Project.

Step two

Upload the image you want to remove the background.

Step three

Select Magic Select 

Drag in the corners of the image to indicate the part of the image which is the cutout. When done click Next.

Step four

The cutout image should be highlighted now. Refine the cutout image using the Pencil  to add any missing parts.

In addition, if there are unwanted parts in the cutout, use the Eraser to remove such parts.

Step five

Move the  cutout away from the background. Then , right click the cutout and Select All.

Step six

Next, move to the background and right click. Delete the background.

Step seven

The next thing to do is to place the cutout on the plain background.

Step eight

Finally, Save as type PNG (Image) and select Transparency. Conclusion

In addition, you can create your thumbnail using Paint 3D, WPS, PowerPoint or any other application you desire.

If you want to create a thumbnail using WPS, just open a blank template. Design a background and paste the image. Add text using your desired font.

However, in order to export your template as an image, you need to have a premium plan. With such a plan you can also add watermark on your design.

Alternatively you can screenshot the template and paste the image in Paint 3D and crop the image. Save the image as PNG and you’re done!

Categories
Business Tools

HOW TO MAKE WORLD MAP ANIMATION IN WPS PRESENTATION

How to make world map animation in WPS Presentation. This is a short tutorial on how to make a world map animation in WPS Presentation.

You can also watch the accompanying video below.

WPS is an office is an office suite available for Microsoft Windows, macOS, Linux and Android.

Here is the link to download WPS (Writer, Presentation and Spreadsheet) if you need it and if you haven’t done so already.

A world map animation can be used for your business presentation or converted to a video.

For example, you could use the map to indicate your business location, your major markets or where you source your products etc.

Check the full video below to aid you in creating your own world map animation effect for your presentation or video.

To make world map animation in WPS, open WPS presentation and follow the steps below.

Make world animation in WPS step 1

Open a blank presentation and add a rectangle shape.  Cover the frame with the rectangle and the add a circle in the middle.

Ensure the circle is perfect. To check whether the circle is perfect, go to

Drawing Tools – Shape effect – More Effects – Size and Properties

add a rectangle shape WPS

Make world animation in WPS step 2

Copy the circle and paste it to duplicate the circle. Drag the other circle and place just outside the frame.

Make world animation in WPS step 3

Merge the inner circle with the rectangle to create a transparent effect. You’ll notice the Merge Shapes is greyed out.

In order to merge shapes in WPS, you need to press shift key and select the shapes one after the other.

When Merge Shapes becomes active select Combine. The middle circle then becomes transparent.

Step 4

Bring in the circle outside the frame and place on the transparent circle. Make sure both are aligned.

Select Drawing Tools-Shape Fill-More Fill-Gradient Fill

Adjust transparency to 95%.

Step 5

Add more effects. You can add a bit of 3D rotation. Be creative as you can!

Add animation effects WPS

Step 6

Paste or insert a world map image. Adjust it so it fits the circle. Copy and paste two more of the same image and align all three.

Step 7

Right click and group the three images. Next add animation. To add animation to the image.

Select Animation – Custom Animation – Add Effect – Motion Paths – Right

The Motion Path selected (Right) means the image would move from left towards right.

Step 8

Extend the motion path to both ends of the image. At this point you’ll need to tweak the animation.

In the animation selection pane you can change the speed to how fast or slow you want the map to scroll and also set the timing.

To do this click on the small orange drop down in Group and select Effect Options

use WPS for animation

Step 9

Once you’re satisfied with the animation, right click the image and select Send to Back

Make world animation in WPS

Step 10

Add text as you wish and add text animation. To do this select the text and go to Animation – Appear – Custom Animation-Modify Appear.

Then click the small orange drop down and select Effect Options.

If you want the words to appear by letter rather than at once, select Animate Text By Letter in Effect Options.

There you are! You’ve made an animated world map using WPS.