Using excel prepare a reconciliation for the corporation

Assignment Help Financial Accounting
Reference no: EM131476420

Assignment: Corporation Special Situations and Organization Structure

Please use the Student Template Assignment 2 template (linked at the bottom of the page) for the assignment below.

Tarass Inc. is an accrual-method calendar-year corporation. Tarass, Inc. did not qualify for the domestic production activities deduction. The following information has been provided about the activities occurring in 2013:

Life insurance proceeds from CFO's death

$100,000

Revenue from sales

$3,500,000

Key person life insurance premium

$6,800

Utilities cost

$275,000

Employee benefits expense

$65,000

Intangible drilling costs

$40,000

Mining exploration and development costs

$60,000

Interest income on qualified private activity, tax-exempt bonds

$25,000

Interest paid on loan to purchase tax-exempt bonds

$25,000

Alternative Minimum NOL Deduction

$35,000

Rental income received and earned in 2013

$5,000

Rental income received but not earned in 201

$10,000

Overhead costs : Expensed in 2013

$5,000

Overhead costs expensed for financial reporting in 2012

$10,000

Charitable contributions

$315,000

Using Excel, prepare a reconciliation. Set up the Excel spreadsheet using the example below:

 

Line Item *a

2013 Taxable Income *b:

"I"  OR" "D"


OR "N"

Adjustments OR Preferences 

*c:

AMTI EFFECTS

*d:

Positive(P)

Negative (N)

Either (E)

 

Adjustments (A)

Neither(N)

 

Preferences (P)

NOTE *a: Line Item is each activity recorded for Tarass in 2013.

NOTE *b: "2013 Taxable Income" refers to if the line item would increase, decrease, or have no effect on Tarass's book income under GAAP. Put an "I" if the line item would increase 2013 taxable income OR "D" if the item would decrease 2013 taxable income OR "N" if the line item would neither increase nor decrease 2013 taxable income.

NOTE *c: "Adjustments OR Preferences" refers to if the line item is an adjustment or a preference. Please place an "A" if the line item is an adjustments OR a "P" if the line item is a preference OR an "N" if the line item is neither an adjustment nor a preference.

NOTE *d: "AMTI Effects" refers to if the line item would have a positive, negative, or no effect on the Alternative Minimum Taxable Income. Please place a (P) for a positive affect OR (N) for a negative effect OR an (E) if the line item could have either a positive or negative effect. If the line item is not applicable to AMTI, leave the block blank.

Attachment:- Template_Assignment.rar

Reference no: EM131476420

Questions Cloud

What is the sample frequency : Assume the sample frequency is Fs = 48 kHz, and the frame size is 1024 (per channel) as defined by BUFFER_COUNT in the C code for the frame-based approach.
Describe and analyze stockholder rights : Students should be able to describe and analyze stockholder rights, corporate governance, and consumer protection.
What is minimum input data length need to achieve frequency : Given an input data length of 4096 values, compare the approximate number of complex mathematical operations needed to evaluate a DFT versus a radix-2 FFT.
Assessment of leadership skills and competencies : In the Northouse text, complete the "Skills Inventory: Leadership Instrument: LMX 7 Questionnaire," on pages 154â156 (at the end of Chapter 7).
Using excel prepare a reconciliation for the corporation : Using Excel, prepare a reconciliation. Set up the Excel spreadsheet using the example below:
How were mouths often rendered on figures : During the early Ptolemaic period, the foreign kings continued to build temples consistent with Egyptian structural traditions instead of Hellenistic forms.
Proprietor of a business known as mousetraps : Mickey Mouse is sole proprietor of a business known as "Mousetraps". Mickey wants to solicit new capital from his uncle, Donald Duck, and his aunt
Product that relied solely on public relations : Can you think of any other product that relied solely on public relations? What was it about its unique selling proposition that made this feasible.
Explain the trim command : Suppose that you have a 256 GB solid state drive that the operating system and drive both support the TRIM command. To evaluate the drive, you do an experiment.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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