Excel 2016 Final Assignment

Spring 2020

This is the final assignment for MS Excel 2016 class.

You have two days (48 hours) to complete and submit it via email.

The email must be arrived by 2200 hours (10:00 pm) on June 26th 2020. My email address is

jhala.excel@gmail.com

I do expect your best and honesty.

Once again, plagiarism is a crime.

Good luck to you all!

1. You are given 9 questions.

2. Create a new workbook, name it as “your first & last name_class#_your ID_final2020spring”.

ex). Halla University_A_123456789_final2020spring

3. Create 8 different worksheet and name them as 1, 2, 3, 4, 5, 6, 7, and 8.

4. Format cell font to ‘Arial’ and size 12.

Q1. Calculate loan payment

Enter following data to worksheet 1.

Use formulas to calculate ?payment per period, ?principal amount, and ?interest amount.

Loan Amount: $55,000.00

Annual Interest Rate: 5.25%

Payment Period (months): 1

Number of Periods: 48

Payment per Period: ?

Period 36

Principal Amount ?

Interest Amount ?

Q2. With the data you would get from Q1, create a table of 48 months that has headings as period, payment, principal and interest on the worksheet 2.

Q3. With the table you create above, create a line chart accordingly right next to the table on the same worksheet.

Q4. Calculate credit card payment.

Create two tables below on worksheet 3 and use formulas to calculate to fill the empty cells.

Credit Card Balance: $248,000.00

Annual Interest Rate: 21.25%

Minimum Payment Pct: 2.00%

Minimum Monthly Payment Amount: ?

Your Actual Monthly Payment: $5,000.00

No. of Payments Required: ?

Total Amount Paid: ?

Total Interest Paid: ?

Other Payoff Periods (months) Pmt Required Total Pmts Total Interest

2

6

12

24

36

48

60

72

84

96

108

120

132

Q5. Create two tables below on worksheet 4 and use formulas to calculate to fill the empty cells.

Loan Amount: $756,000

Annual Interest Rate: 7.25%

Pmt. Period (months): 1

Number of Periods: 60

Payment Amount:

Total Payments:

Total Interest:

7.00% 7.25% 7.50% 7.75% 8.00% 8.25% 8.50%

Payment Amount:

Total Payments:

Total Interest:

Q6. Create two tables below on worksheet 5 and use formulas to calculate to fill the empty cells.

Loan Amount: $854,000

Annual Interest Rate: 7.25%

Pmt. Period (months): 1

Number of Periods: 72

Payment Amount:

Total Payments:

Total Interest:

Annual Interest Rate

7.00% 7.25% 7.50% 7.75% 8.00% 8.25% 8.50%

$850,000

$855,000

$860,000

$865,000

$870,000

$875,000

Create tables below on worksheet 6 and use formulas to calculate to fill the empty cells.

Deposits…

Initial investment: $1,500.00

Periodic deposit amount: $3,540.00

No. periodic deposits per year : 12

Deposits made at beginning of period? TRUE

Investment Period…

Length of investment (years): 9

Interest Rate…

Annual interest rate: 3.25%

Calculations

Initial investment

Additional deposits:

Total amount invested:

Periodic interest rate:

Value of investment at end of term:

Interest earned on investment:

Create a table below on worksheet 7 and create a combo chart accordingly.

The headings are each chart types.

? Add chart title on top of it as ‘Combo Chart’.

? Add data labels

Area Column Line Pie XY

Jan 2 9 6 2 13

Feb 3 7 6 4 10

Mar 2 8 6 5 7

Apr 6 5 5 6 8

May 3 5 8 10

Jun 2 4 10 12

Create a table below on worksheet 8.

Calculate the differences between test 1&2, and use conditional formatting to enter 5 colored arrows in ‘Trend’ column as flowing condition. ? put when the differences are = 10

? put when the differences are 10 and = 5

? put when the differences are 5 and = 0

? put when the differences are 0 and = -5

? put when the differences are -5

Student Test 1 Test 2 Change Trend

Amy 59 70 11

Bob 82 78 -4

Calvind 98 100 2

Doug 56 69 13

Ephraim 98 88 -10

Frank 67 75 8

Gretta 78 90 12

Harold 87 92 5

Inez 56 85 29

June 87 72 -15

Kenny 87 88 1

Lance 92 92 0

Marvin 82 73 -9

Noel 98 100 2

Opie 84 73 -11

Paul 94 93 -1

Quinton 68 92 24

Rasmus 91 90 -1

Sam 85 86 1

Ted 72 92 20

Ursie 80 75 -5

Valerie 77 65 -12

Wally 64 40 -24

Xerxes 59 59 0

Yolanda 89 99 10

Zippy 85 82 -3

Spring 2020

This is the final assignment for MS Excel 2016 class.

You have two days (48 hours) to complete and submit it via email.

The email must be arrived by 2200 hours (10:00 pm) on June 26th 2020. My email address is

jhala.excel@gmail.com

I do expect your best and honesty.

Once again, plagiarism is a crime.

Good luck to you all!

1. You are given 9 questions.

2. Create a new workbook, name it as “your first & last name_class#_your ID_final2020spring”.

ex). Halla University_A_123456789_final2020spring

3. Create 8 different worksheet and name them as 1, 2, 3, 4, 5, 6, 7, and 8.

4. Format cell font to ‘Arial’ and size 12.

Q1. Calculate loan payment

Enter following data to worksheet 1.

Use formulas to calculate ?payment per period, ?principal amount, and ?interest amount.

Loan Amount: $55,000.00

Annual Interest Rate: 5.25%

Payment Period (months): 1

Number of Periods: 48

Payment per Period: ?

Period 36

Principal Amount ?

Interest Amount ?

Q2. With the data you would get from Q1, create a table of 48 months that has headings as period, payment, principal and interest on the worksheet 2.

Q3. With the table you create above, create a line chart accordingly right next to the table on the same worksheet.

Q4. Calculate credit card payment.

Create two tables below on worksheet 3 and use formulas to calculate to fill the empty cells.

Credit Card Balance: $248,000.00

Annual Interest Rate: 21.25%

Minimum Payment Pct: 2.00%

Minimum Monthly Payment Amount: ?

Your Actual Monthly Payment: $5,000.00

No. of Payments Required: ?

Total Amount Paid: ?

Total Interest Paid: ?

Other Payoff Periods (months) Pmt Required Total Pmts Total Interest

2

6

12

24

36

48

60

72

84

96

108

120

132

Q5. Create two tables below on worksheet 4 and use formulas to calculate to fill the empty cells.

Loan Amount: $756,000

Annual Interest Rate: 7.25%

Pmt. Period (months): 1

Number of Periods: 60

Payment Amount:

Total Payments:

Total Interest:

7.00% 7.25% 7.50% 7.75% 8.00% 8.25% 8.50%

Payment Amount:

Total Payments:

Total Interest:

Q6. Create two tables below on worksheet 5 and use formulas to calculate to fill the empty cells.

Loan Amount: $854,000

Annual Interest Rate: 7.25%

Pmt. Period (months): 1

Number of Periods: 72

Payment Amount:

Total Payments:

Total Interest:

Annual Interest Rate

7.00% 7.25% 7.50% 7.75% 8.00% 8.25% 8.50%

$850,000

$855,000

$860,000

$865,000

$870,000

$875,000

Create tables below on worksheet 6 and use formulas to calculate to fill the empty cells.

Deposits…

Initial investment: $1,500.00

Periodic deposit amount: $3,540.00

No. periodic deposits per year : 12

Deposits made at beginning of period? TRUE

Investment Period…

Length of investment (years): 9

Interest Rate…

Annual interest rate: 3.25%

Calculations

Initial investment

Additional deposits:

Total amount invested:

Periodic interest rate:

Value of investment at end of term:

Interest earned on investment:

Create a table below on worksheet 7 and create a combo chart accordingly.

The headings are each chart types.

? Add chart title on top of it as ‘Combo Chart’.

? Add data labels

Area Column Line Pie XY

Jan 2 9 6 2 13

Feb 3 7 6 4 10

Mar 2 8 6 5 7

Apr 6 5 5 6 8

May 3 5 8 10

Jun 2 4 10 12

Create a table below on worksheet 8.

Calculate the differences between test 1&2, and use conditional formatting to enter 5 colored arrows in ‘Trend’ column as flowing condition. ? put when the differences are = 10

? put when the differences are 10 and = 5

? put when the differences are 5 and = 0

? put when the differences are 0 and = -5

? put when the differences are -5

Student Test 1 Test 2 Change Trend

Amy 59 70 11

Bob 82 78 -4

Calvind 98 100 2

Doug 56 69 13

Ephraim 98 88 -10

Frank 67 75 8

Gretta 78 90 12

Harold 87 92 5

Inez 56 85 29

June 87 72 -15

Kenny 87 88 1

Lance 92 92 0

Marvin 82 73 -9

Noel 98 100 2

Opie 84 73 -11

Paul 94 93 -1

Quinton 68 92 24

Rasmus 91 90 -1

Sam 85 86 1

Ted 72 92 20

Ursie 80 75 -5

Valerie 77 65 -12

Wally 64 40 -24

Xerxes 59 59 0

Yolanda 89 99 10

Zippy 85 82 -3

Bachelor of Tourism and HospitalityBTHM Management2021-SEM3-THH3113 Cost and Performance Management for Tourism and HospitalityAssessment Task 2: Individual AssignmentAssessment of the assignment is based...Identify & research a best practice organisational or departmental workflow within Quality Management & Validation in your area e.g. pharma, medtech or Engineering etc. Critically justify your...For first task you have to read the article and i give 200 response to the question that is in the screenshot.2nd task You should write 300-500 words (or more if you like) in total on the important/impactful...ASSESSMENT BRIEFSubject Code and Name ACCT6001 Accounting Information SystemsAssessment Assessment 4 – Database Application - Case StudyIndividual/Group IndividualLearning Outcomes (b) Explain the characteristics...Adapted by permission of the copyright holder © 2020 CAQAEncryption Project 2Project Scenario : Southern StarBusiness this assessment is based on:Documentation reviewed as preparation: Southern Star...Project DetailsLearning OutcomesStudents are required to:1. Work in a team and engage in negotiation of goals and methods. (PTS4)2. Solve a software development related problem while choosing the right...Suppose 𝑦 = 𝛽0 + 𝛽1𝑥1 + 𝛽2𝑥2 + 𝜖 is linear regressionmodel of weekly food expenditure (y) on weeklyhousehold income (x1) and household size (x2)....**Show All Questions**