Scribd
Upload
16 views3 pages

Test Examples

The document outlines tax rates and net income for individuals, including calculations for total income in specific categories. It also details a loan scenario with yearly payment calculations at an 8% interest rate and retirement investment projections over 20 years. Key figures include net incomes for individuals and future values of investments based on different payment timings.

Uploaded by

walidaiyash2001
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
16 views3 pages

Test Examples

The document outlines tax rates and net income for individuals, including calculations for total income in specific categories. It also details a loan scenario with yearly payment calculations at an 8% interest rate and retirement investment projections over 20 years. Key figures include net incomes for individuals and future values of investments based on different payment timings.

Uploaded by

walidaiyash2001
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Q1 The sheet below contains two table define the name Rates for first one and Clerks

for the sec


1- The rates for all names using the Rates table.
2- Net income for all names.
3- Total income for Category 2
4- The net income for the name entered in G12.

Income level Tax rate


Name Net
$ - 0.11 Income
$ 15,000.00 0.15
$ 32,000.00 0.24
$ 45,000.00 0.30 Net income for Tom Davis 84000
$ 60,000.00 0.35
$ 80,000.00 0.40
Total income for Category 2

Name Sex CategoryNo. income Rate Net income


Tom Davis M 1 84000
Alex Hunk M 2 40600
Peter Duke M 1 79890
Samia Salim F 3 30800
Jemes Lang M 4 14900
Ladia Casina F 2 59000
ne and Clerks for the second. Use Excel to return:

Q2 I am borrowing $30,000 for 5 years with an annual interest rate of 8 percent.


What are my yearly payments ?
Payment Value beginning of year
Payment Value end of year
Payment Value end of year if the future value $700
Net
Income Q3 If at the end of each of the next 20 years I invest $1,900 a year toward my retirement

Invest $1900 end of year ($86,947.73)


Invest $1900 beginning of year ($93,903.55)
We start with $25000 ($203,471.66)
nterest rate of 8 percent.

($6,957.12)
($7,513.69)
($6,846.64)

900 a year toward my retirement and earn

You might also like