Hello my dear, i need help with this question and i will appreciate your help!

Hello my dear, I need help with this question and I will appreciate your help!
The company I am writing about is Apple.Inc. I need a single Excel chart that compares the data of the overall corporate revenue (sales) data for the previous five full years of Apple, along with the same data from one primary competitor.
Please make sure to follow the instructions in the question file and feel free to ask for any clarification if needed!

Identify the issue in one of the tax situations

Norse Co, a calendar-year taxpayer, received a check for $180,000 in payment for services rendered as a commissioned sales agent near the end of 2017. In 2018, the customer discovered that the commission was incorrectly computed on the sale, and Norse Inc. refunded $30,000 of the $180,000 to the customer.
Norse Inc. (a C corporation) was in a 35% tax bracket in 2017, but in 2018 due to the Tax Cuts and Jobs Act is now in a 21% bracket in 2018. Since Norse was taxed on the full $180,000 under the claim of right doctrine, it may deduct the $30,000 in 2018, but this will not “make them whole.”
Choose one of the situations above. Please research and identify the authority which would provide them relief.
INSTRUCTIONS:
1. Prepare a tax research memo using the format shown in attached doc.
2. Identify the issue in one of the tax situations
3. Identify statutory authority
4. Identify regulatory authority
5. Cite primary authority
6. Use proper citation in end notes to the memo

However, you should remember the format you use for the cover letter, as your resume should match in style and font choices.

A cover letter specifically tailored to the job ad you posted in the discussion board
Purpose: The purpose of the cover letter is to present your credentials and argument for being a person qualified and interested in the position so that you make it to the interview.
Goals: Persuasion
To build a positive image of your qualifications
To show you have researched the company and analyzed the job ad extensively based on the information from in-class lecture, examples, and activities
To convince the hiring manager/HR person/computer that you should be met with for an interview.
Tasks: Your cover letter should engage the following:
You are to respond to the job listing you posted on the discussion board and create a cover letter for the position.
You should not create a “form” cover letter or resume. You need to understand how to compose the cover letter to meet specifics from the job ad.
A Good cover letter “shows” as opposed to “tells,” so focus on incorporating 1-2 of the short narratives you created in the short assignment this week.
Format: Cover letters have a specific format. You can review this week’s video and the material in chapter 10 of the textbook for ideas of how to format the letter and its contents. You should NOT use a template from Word or available online. These are often thrown into the trash without being read by hiring managers. However, you should remember the format you use for the cover letter, as your resume should match in style and font choices.
Length: The cover letter should be one page in length. This is always advisable, but as you gain more time and experience in your field, the letter may surpass this length. For this assignment, stick to one page.
Remember: Much like you matched a brand for the company when you wrote the negative response letter, your cover letter creates a personal brand that is an introduction to who you are for employers. Consider how your tone, word choice, mechanics, and other rhetorical moves present you.

Charles’s adjusted basis in the beach house was $150,000, and its fair market value on the date of his death was $240,000.

Alton Newman, age 67, is married and files a joint return with his wife, Clair, age 65. Alton and Clair are both retired, and during 2019, they received Social Security benefits of $10,000. Both Alton and Clair are covered by Medicare. Alton’s Social Security number is 111-11-1119, and Clair’s is 123-45-6786. They reside at 210 College Drive, Columbia, SC 29201. Alton, who retired on January 1, 2019, receives benefits from a qualified pension plan of $2,750 a month for life. His total contributions to the plan (none of which were deductible) were $168,250. In January 2019, he received a bonus of $2,000 from his former employer for service performed in 2018. No income taxes were withheld on this bonus by his former employer (Amalgamated Industries, Inc.; EIN 12-3456789; 114 Main Street, Columbia, SC 29201). Although Amalgamated Industries, Inc., accrued the bonus in 2018, it was not paid until 2019. Clair, who retired on December 31, 2018, started receiving benefits of $1,400 a month on January 1, 2019. Her contributions to the qualified pension plan (none of which were deductible) were $74,100. On September 27, 2019, Alton and Clair received a pro rata 10% stock dividend on 600 shares of stock they owned. They had bought the stock on March 5, 2012, for $20 a share. On December 16, 2019, they sold the 60 dividend shares for $55 a share. On October 10, 2019, Clair sold the car she had used in commuting to and from work for $17,000. She had paid $31,000 for the car in 2013. On July 14, 2011, Alton and Clair received a gift of 1,000 shares of stock from their son, Thomas. Thomas’s basis in the stock was $35 a share (fair market value at the date of gift was $25). No gift tax was paid on the transfer. Alton and Clair sold the stock on October 8, 2019, for $24 a share. On May 1, 2019, Clair’s mother died, and Clair inherited her personal residence. In February 2019, her mother had paid the property taxes for 2019 of $2,100. The residence had a fair market value of $235,000 and an adjusted basis to the mother of $160,000 on the date of her death. Clair listed the house with a real estate agent, who estimated it was worth $240,000 as of December 31, 2019. Clair received rent income of $6,000 on a beach house she inherited three years ago from her uncle Charles. She had rented the property for one week during the July 4 weekend and one week during the Thanksgiving holiday. Charles’s adjusted basis in the beach house was $150,000, and its fair market value on the date of his death was $240,000. Clair and Alton used the beach house for personal purposes for 56 days during the year. Expenses associated with the house were $3,700 for utilities, maintenance, and repairs; $2,200 for property taxes; and $800 for insurance. There are no mortgages on the property. Clair and Alton paid estimated Federal income tax of $2,000 and had itemized deductions of $6,800 (excluding any itemized deductions associated with the beach house). They did not engage in any virtual currency transactions during the year. If they have overpaid their Federal income tax, they want the amount refunded. Both Clair and Alton want $3 to go to the Presidential Election Campaign Fund. Compute their net tax payable or refund due for 2019, using the appropriate tax rate schedule (not the Tax Tables). If you use tax forms for your computations, you will need at a minimum Form 1040–SR and Schedule D. Suggested software: ProConnect Tax Online.
Second problem please find attached.
Complete the Tax Return Problem using MS-Excel, using functions and formulas as appropriate.

If you do not have a lot of financial instruments like stocks, bonds, life insurance, you need to describe in the paper your future to obtain these instruments.

You will be creating a personal financial plan throughout the course. This plan is intended to allow you to demonstrate that you have learned the concepts of the class and can apply them to a real-world financial plan. Some students are not independent and still rely on a parent for economic security. Even for these students all sections of the financial plan need to be completed. For example, if your health insurance is provided by a parent, you can still describe the kind of coverage that you have by talking to your parents.

If you do not have a lot of financial instruments like stocks, bonds, life insurance, you need to describe in the paper your future to obtain these instruments. As an alternative, you can use the financial information of a friend or relative if yours is limited. If you choose to use a friend or relatives′ financial information, please state this in the section where you do this. It is important that you work on this paper all semester long and not just at the end.

All projects are destroyed by the instructor after the class and will not be returned.
If you do not feel comfortable documenting your actual financial information in the term project you can modify the actual cash values and instruments in your plan to use simulated values.

Write a 350- to 525-word response to q6-2 on p. 406 of governmental and nonprofit accounting:

Assignment Content
Different types of expenditures include current operations, those between intergovernmental entities, capital outlay, debt service, inventories, and prepayments. Expenditures come from various funds depending on the type of expenditure. Understanding expenditures is important in accounting because they are recorded on government budgets and financial statements.
Imagine you are part of a career day panel of government accountants in your county who are fielding questions from local high school students. These students are studying governmental accounting and are interested to hear from professionals in the field about a recent topic they have been discussing in their accounting class: general fund expenditures. In preparation, you are going to write down your thoughts and prepare an example of how the transactions of a General Fund are recorded to share with the students.
Part 1:
Write a 350- to 525-word response to Q6-2 on p. 406 of Governmental and Nonprofit Accounting:
When should General Fund expenditures be recognized? What are the major exceptions?
Part 2:
Complete E6-3 on p. 410 of Governmental and Nonprofit Accounting using the Exercise 6-3 Template.
Submit your assignment.
Comments from Customer
Discipline: government accounting