List box that uses the percentages and calculates

Assignment Help Accounting Basics
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.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd