GeoGebra Template for Calculating Your Monthly Paycheck

You can use Spreadsheet in GeoGebra to calculate your net income. In Item 2 below, there’s a template you can follow. At the end of the entry, there’s an example so you can see how you can use the template in practice.

That said, it’s often better to use Excel , since it has more built-in tools like charts and formatting options than there are in GeoGebra.

GeoGebra Instruction 1

Calculating Income in `Spreadsheet`

1.: Open Spreadsheet under View in Menu.
2.: Copy the template in the image below. The cells without formulas in them need to be filled with information you get from your exercise. Note that GeoGebra doesn’t display the equal sign before each formula, nor the multiplication symbol (*) between the cell names, but you must type them nonetheless.

Screenshot of GeoGebra showing a spreadsheet template for income calculations

Example 1

You have a fixed salary of $ $3900$ per month. Your normal workweek is 40 hours, and you receive an additional $40 %$ to your hourly rate when working overtime during weekdays, and $100 %$ when working overtime on Sundays. One month, you work 15 hours’ overtime during the week and 6 hours’ overtime on Sundays. $35 %$ of your salary goes to taxes. What is your net income?

Follow Item 2 and insert the numbers from the exercise. Your spreadsheet should look like the one in the image below.

Screenshot of GeoGebra showing a spreadsheet with income data

Want to know more?Sign UpIt's free!

Spreadsheets for Budget and Accounting in GeoGebra

Go back

Calculating Income in Spreadsheet

Calculating Income in `Spreadsheet`