Worksheets

Loan Worksheet

The loan worksheet lets you analyze fixed-rate loans. You enter a value in four of the first five fields, and tic the checkbox next to the field you want calculated. By clicking on 'Calculate', PawCalc will calculate the field you selected plus the total payment for your loan.

The first field is "Amount". This is loan you owe at the beginning of the period. The second field is "End amount". This is the amount you owe at the end of the period. To pay off a loan, use zero as the end amount. The third field is the annual percentage rate (APR) for the loan. The fourth field is the length of the loan. The popup list lets you specify the unit; either months, quarters, half-years, or years. The fifth field is the periodic payment. This payment is due at the end of each period as specified by the popup list for field four.

Example:

You take out a 30-year fixed rate mortgage of $100,000 for your new house. The interest rate is 6 percent annual interest, and the payments are monthly. What will your monthly payments be?

Set up your loan worksheet as follows and press 'Calculate':

• Amount: 100,000
• End amount: 0
• APR: 6
• Months: 360
• Check the box next to 'Payment'

After you press 'Calculate', you will see that your monthly payment is $599.55, and your total payment over the course of the loan is $215,838.

Now assume you decide to pay $25 extra per months. How long will it take you to pay off the loan?

• Amount: 100,000
• End amount: 0
• APR: 6
• Check the box next to Months
• Payment: 599.55+25

After you press 'Calculate', you will see that your loan will be paid off in 323 months, and your total payment over the course of the loan is $201,898.

Savings Worksheet

The savings worksheet lets you analyze fixed-rate savings. You enter a value in four of the first five fields, and tic the checkbox next to the field you want calculated. By clicking on 'Calculate', PawCalc will calculate the field you selected plus the total amount of the deposits.

The first field is "Start amount". This is the amount of your savings at the beginning of the period. The second field is "End amount". This is the amount of your savings at the end of the period. The third field is the annual percentage rate (APR) for for the savings. The fourth field is the length of the savings. The popup list lets you specify the unit; either months, quarters, half-years, or years. The fifth field is the periodic deposits. This payment is due at the beginning of each period as specified by the popup list for field four.

Example:

You deposit $100 each month for 30 years. You expect your savings to make 7.5% annually in interest. How much money will you have after 30 years?

Set up your savings worksheet as follows and press 'Calculate':

• Start amount: 0
• Check the box next to 'End amount'
• APR: 7.5
• Months: 360
• Deposit: 100

After you press 'Calculate', you will see that the final amount of your savings are $134,744, and your total deposits are $36,000.

Tips Worksheet

The tips worksheet helps your split the bill between multiple people. You enter a value in three fields. By clicking on 'Calculate', PawCalc will split the bill for you.

The first field is "Amount". This is the amount on the bill. The second field is "Tips (in %)". This is the amount of tips (in percent). The third field is the number of people to split the bill.

Example:

Your want to split a $100 bill between 2 people. You want to tip 15%. How much will each of you pay?

Set up your tips worksheet as follows and press 'Calculate':

• Amount: 100
• Tips (in %): 15
• #people: 2

After you press 'Calculate', you will see that the amount of tips is $15, the total amount to pay is $114, and each person should pay $57.50.