41. Write a program that, given a beginning balance in your savings accou calculates the balance at the end of 1 year. The interest is 5.3% c pounded quarterly. Show the interest earned and balance at the end d each quarter. Present the data in tabular columns with appropriate ha ings. Use separate functions to compute the interest and print the balan

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter3: Performing Calculations With Formulas And Functions
Section: Chapter Questions
Problem 1.3CP
Question

code for number 41 problem

Projects
40. Prepare a payroll earnings statement for the sales force at the Arctic Ice
Company. All of Arctic's employees are on a straight commission basis of
12.5% of sales. Each month, they also receive a bonus that varies
depending on the profit for the month and their length of service. The
sales manager calculates the bonus separately and enters it with the
salesperson's total sales for the month. Your program is also to calculate
the withholding taxes and retirement for the month based on the follow
ing rates:
a. 25% Federal withholding
b. 10% State withholding
c.
8% Retirement plan
Use the test data in Table 4-2 to test the program.
Salesperson
Sales
Bonus
1
53,500
425
2
41,300
300
3
56,800
350
4
36,200
175
TABLE 4-2 Test Data for Project 40
41. Write a program that, given a beginning balance in your savings accout
calculates the balance at the end of 1 year. The interest is 5.3% con
pounded quarterly. Show the interest earned and balance at the end
each quarter. Present the data in tabular columns with appropriate hai
ings. Use separate functions to compute the interest and print the balan
Transcribed Image Text:Projects 40. Prepare a payroll earnings statement for the sales force at the Arctic Ice Company. All of Arctic's employees are on a straight commission basis of 12.5% of sales. Each month, they also receive a bonus that varies depending on the profit for the month and their length of service. The sales manager calculates the bonus separately and enters it with the salesperson's total sales for the month. Your program is also to calculate the withholding taxes and retirement for the month based on the follow ing rates: a. 25% Federal withholding b. 10% State withholding c. 8% Retirement plan Use the test data in Table 4-2 to test the program. Salesperson Sales Bonus 1 53,500 425 2 41,300 300 3 56,800 350 4 36,200 175 TABLE 4-2 Test Data for Project 40 41. Write a program that, given a beginning balance in your savings accout calculates the balance at the end of 1 year. The interest is 5.3% con pounded quarterly. Show the interest earned and balance at the end each quarter. Present the data in tabular columns with appropriate hai ings. Use separate functions to compute the interest and print the balan
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Datatypes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage