List box that uses the percentages and calculates

Reference no: EM13766392

The company you work for will contribute 12 percent of your gross pay to a 401(k) plan in your name. You can add up to another 10 percent of your gross pay to the same account, but the total contribution (the company's plus yours) cannot exceed $ 10,000. Create a worksheet with the following columns: Gross Pay, Employer Contribution, My Contribution, and Total contribution. Enter a value for your gross pay and create a formula to calculate the company contribution. In a column to the right, enter the numbers 0 to 10. Format them as percentages. Create a list box that uses the percentages and calculates your contribution for the My Contribution column. Total the contributions. Use the combo box to see how much of the gross pay you can contribute to the IRA without exceeding the $10,000 limit.

Reference no: EM13766392

Questions Cloud

What are the ramifications of given situation : You are managing a project that is just barely within budget. You are confused because you know that your bid was high enough to produce a nice profit. What are the ramifications of this situation? What steps do you think you should take to rectify..

Discus healthcare research impact on evidence based practice : Discuss the Healthcare research's impact on evidence based practice and Key Components of research studies impacting rigor, validity, and ethical considerations.

Kin selection and kin recognition rules be useful : How might you expect foraging patterns to differ between these two lizard populations with respect to the time spent in a given patch - How might both kin selection and kin recognition rules be useful in understanding cases of "adoption" in animals?

Calculate the net present value of the new purchase option : David Co. produces all-terrain vehicles (ATVs). The once successful line is no longer selling well, so the company is considering production of a new improved 4 passenger ATV. This can be done by buying needed production equipment. The after tax cash..

List box that uses the percentages and calculates : Create a list box that uses the percentages and calculates your contribution for the My Contribution column. Total the contributions. Use the combo box to see how much of the gross pay you can contribute to the IRA without exceeding the $10,000 li..

Framework for an ideal psychological support agency : Develop the framework for an ideal psychological support agency to respond to a national catastrophic event

Expect interest rates to decrease : Jackson Central has a 6-year, 8% annual coupon bond with a $1,000 par value. Earls Enterprises has a 12-yr, 8% annual coupon bond with a $1,000 par value. Both bonds currently have a yield to maturity of 6%. Which of these two bonds should you buy if..

What differences did you find among the four states : Conduct an Internet search by visiting the state websites for Arizona, Illinois, New York, and California. What differences did you find among the four states

Competitive advantage to the company in the market space : Assess how using an ABC system can provide a competitive advantage to the company in the market space it operates and the resulting impact to the business performance.

User Account

All Pages