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

  At the end of the current year accounts receivable has a

at the end of the current year accounts receivable has a balance of 2500000 allowance for doubtful accounts has a debit

  Dawns new car has a fmv of 20000 and it weighs 3000 pounds

dawns new car has a fmv of 20000 and it weighs 3000 pounds. the county also assessed a property tax on the car. the tax

  Expected value and consumer choices

Consumers' choices are prey to subtle discrepancies that arise in cognitive accounting. Learning how and when you are prey to these discrepancies is an important step in improving your decision making.

  Which entries would company make to record change

The new method. Williams Company experiences a 40% tax burden. Which one of the following entries would the company make to record this change?

  Net working capital is expected to decline by 5000 the firm

a corporation is evaluating the relevant cash flows for a capital budgeting decision and must estimate the terminal

  On june 30 2013 rosetta granite purchased a machine for

on june 30 2013 rosetta granite purchased a machine for 146000. the estimated useful life of the machine is eight years

  Essential of allowance method of accounting

What are the essential of the allowance method of accounting for bad debts?

  A current asset on emmet co. balance sheet.

A current asset on emmet co.'s balance sheet.

  Rankin the comptroller of lazy inc has been embezzling

rankin the comptroller of lazy inc. has been embezzling funds from his employer for many years to date he has taken

  Matuseski corporation is preparing its cash budget for

matuseski corporation is preparing its cash budget for october. the budgeted beginning cash balance is 17000. budgeted

  Nol carryback and carryforward-valuation account needed

Topper Company reported the following pretax financial income (loss) for the years 2013 through 2017.

  Prepare the journal entries to record above events in

prepare the stockholders equity section ofthe corporate balance sheet for each company for the year endingdecember 31

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