calculating adjusted gross income

PART I: Bob Parker has the following items of income for 2017. Based on these items, please calculate Bob’s adjusted gross income (AGI). In addition, cite your reference to substantiate your rationale for each item.

Wages from employer

55,000

Interest from municipal bonds

1,250

Dividend income from ABC stock

750

Capital loss from stock transactions

5,000

Interest from savings account

500

Amount received as life insurance beneficiary

25,000

Trip awarded to Bob for meeting sales quota

5,000

Contributed to IRA

2,500

Alimony paid

12,000

Early withdrawal penalty on savings account

50

Loss due to damage on personal vehicle

1,000

Requirements

Clearly identify the requirements being addressed.

PART 2: Show all calculations within the cells of an MS Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well; no hard coding of solutions. Submit a single MS Excel file for grading.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post calculating adjusted gross income appeared first on The Nursing Hub.

"Are you looking for this answer? We can Help click Order Now"