Accounts-Q25 Online Services


1. This portion of the exam is open book and open note, but you are not to consult with any other student, teacher, friend, parent, cousin who is a CPA, etc. In other words, you may use the non-human resource available to you.
2. The take home exam consists of several problems that are worth 50 points in total.
3. Read each problem carefully and enter your responses in the provided excel file.
a. Within the excel file, use tabs named “Problem X Answer” to record your final answers to each problem. Use the tabs named “Problem X Calculations” to show any work you did that is not reflected in the answers tab. YOU MUST SHOW YOUR WORK (i.e., leaving the calculations page blank will receive a score of zero).
b. Eliminating entries provided in worksheet format MUST BE NUMBERED (so that I can tell which debits and credits are part of the same entry) in order to receive credit.
4. Submit your completed excel file via Webcourses no later than December 8 at 11:59PM.
5. Please refrain from sharing this exam with others even after the semester has concluded.
Statement of Academic Integrity
By submitting your take home final for grading you are pledging that the work contained therein is entirely your own and that you have not received, or given, help from any other person in completing this assignment. Cheating of any kind on this examination will result in a score of zero and referral to the Office of Student Conduct for further action. (This is not an idle threat – students have received zeros in the past.)
Excel Tip
Select the following commands from the Excel menu to view your “Calculations tab” side-by-side with your “Answers tab”:
Problem 1: Date of Acquisition (10 points)
Balance sheets for Pilates Company and Spinning Company on August 1, 2014, are as follows:
$ 331,000
$ 212,000
Investment in bonds

Investment in S Company

Plant and equipment (net)
Total Assets
$ 4,916,000
$ 1,920,000
Accounts payable
$ 348,000
$ 116,000
Accrued expenses
Bonds payable 8%

Common stock
Other contributed capital
Retained earnings
Total Liabilities and Equities
$ 4,916,000
$ 1,920,000

You can read more about our case study assignment help services here.

How it Works

How It works ?

Step 1:- Click on Submit your Assignment here or shown in left side corner of every page and fill the quotation form with all the details. In the comment section, please mention Case Id mentioned in end of every Q&A Page. You can also send us your details through our email id with Case Id in the email body. Case Id is essential to locate your questions so please mentioned that in your email or submit your quotes form comment section.

Step 2:- While filling submit your quotes form please fill all details like deadline date, expected budget, topic , your comments in addition to Case Id . The date is asked to provide deadline.

Step 3:- Once we received your assignments through submit your quotes form or email, we will review the Questions and notify our price through our email id. Kindly ensure that our email id and must not go into your spam folders. We request you to provide your expected budget as it will help us in negotiating with our experts.

Step 4:- Once you agreed with our price, kindly pay by clicking on Pay Now and please ensure that while entering your credit card details for making payment, it must be done correctly and address should be your credit card billing address. You can also request for invoice to our live chat representatives.

Step 5:- Once we received the payment we will notify through our email and will deliver the Q&A solution through mail as per agreed upon deadline.

Step 6:-You can also call us in our phone no. as given in the top of the home page or chat with our customer service representatives by clicking on chat now given in the bottom right corner.

Case Approach

Scientific Methodology

We use best scientific approach to solve case study as recommended and designed by best professors and experts in the World. The approach followed by our experts are given below:

Defining Problem

The first step in solving any case study analysis is to define its problem carefully. In order to do this step, our experts read the case two three times so as to define problem carefully and accurately. This step acts as a base and help in building the structure in next steps.

Structure Definition

The second step is to define structure to solve the case. Different cases has different requirements and so as the structure. Our experts understand this and follow student;s university guidelines to come out with best structure so that student will receive best mark for the same.

Research and Analysis

This is the most important step which actually defines the strength of any case analysis. In order to provide best case analysis, our experts not only refer case materials but also outside materials if required to come out with best analysis for the case.

Conclusion & Recommendations

A weak conclusion or recommendations spoil the entire case analysis. Our expert know this and always provide good chunks of volume for this part so that instructors will see the effort put by students in arriving at solution so as to provide best mark.

Related Services

Prepare a workpaper for a consolidated balance sheet for Pilates Company and its subsidiary on August 1, 2014, taking into consideration the following

1. Pilates Company acquired 90% of the outstanding common stock of Spinning Company on August 1, 2014, for a cash payment of $1,173,000.
2. Included in the Investment in Bonds account are $80,000 par value of Spinning Company bonds payable that were purchased at par by Pilates Company in 2002. The bonds pay interest on April 30 and October 31. S Company has appropriately accrued interest expense on August 1, 2014; Pilates Company, however, inadvertently failed to accrue interest income on the Spinning Company bonds.
3. Included in Pilates Company receivables is a $70,000 cash advance to Spinning Company that was mailed on August 1, 2014. Spinning Company had not yet received the advance at the time of the preparation of its August 1, 2014 balance sheet.
4. Assume that any excess of book value over the value implied by purchase price is due to overvalued plant and equipment.
Problem 2: Accounting for Investment in Subsidiary (14 points)
The following accounts appeared in the separate financial statements at the end of 2014 for Pretzel, Inc. and its wholly-owned subsidiary, Salt, Inc. Salt was acquired on January 1, 2014 at book value.
Investment in subsidiary

Dividends receivable

Dividends payable
Common stock
Additional paid-in-capital
Retained earnings, 12/31/14
Dividends declared
Equity in net loss of subsidiary

Retained earnings at 1/1/14


1. (1 point) How can you determine whether Pretzel is using the cost or equity method to account for its investment in Salt?
2. (1 point) Compute consolidated net income.
3. (1 point) How much income did Pretzel, Inc. earn from its own independent operations?
4. (1 point) Compute consolidated retained earnings at 12/31/14.
5. (1 point) What are consolidated dividends?
6. (1 point) Compute retained earnings at 1/1/14 for Salt, Inc.
7. (4 points) Was there any difference between book value and the value implied by the purchase price at acquisition? Prepare workpaper entries needed at the end of 2014.
8. (1 point) If Pretzel used the cost method instead of the equity method, how would Pretzel, Inc.’s non-consolidated retained earnings change at the end of 2014? Describe in words.
9. (3 points) If Pretzel uses the cost method instead of the equity method, what workpaper entries would be required at the end of 2014? Describe in words and compare to the equity method entries.
Problem 3: Consolidation After Acquisition (12 points)
On January 1, 2017, Pence Company purchased 85% of the outstanding common stock of Spicer Company for $525,000. On that date, Spicer Company’s stockholders’ equity consisted of common stock, $150,000; other contributed capital, $60,000; and retained earnings, $210,000. Pence Company paid more than the book value of net assets acquired because the recorded cost of Spicer Company’s land was significantly less than its fair value.
During 2017 Spicer Company earned $222,000 and declared and paid a $75,000 dividend. Pence Company used the partial equity method to record its investment in Spicer Company.
A. (6 points) Prepare the investment related entries on Pence Company’s books for 2017.
B. (6 Points) Prepare the workpaper eliminating entries for a workpaper on December 31, 2017.
Problem 4: Consolidation with Allocation after the Date of Acquisition (14 points)
Parcival Corporation acquired 70% of the voting stock of Summer Corporation on January 1, 2016, for $210,000 when Summer had common stock of $140,000 and retained earnings of $24,000. The excess of implied over book value was allocated $11,000 to inventories that were sold in 2016, $35,000 to equipment with a 5-year remaining useful life under the straight-line method, and the remainder to goodwill.
Financial statements for Parcival and Summer Corporations at the end of the fiscal year ended December 31, 2017 (two years after acquisition) are provided below. Parcival Corp. has accounted for its investment in Summer using the complete equity method of accounting.

Income Statement
$ 618,000
$ 180,000
Equity from Subsidiary Income
Cost of Sales
Other Expenses (incl. Depreciation)
Net Income
$ 74,300
$ 36,000
Retained Earnings
1/1 Retained Earnings
$ 71,200
$ 30,000
Add: Net Income
Less: Dividends
12/31 Retained Earnings
$ 85,500
$ 54,000
Balance Sheets
$ 32,000
$ 21,000
Note Receivable
Equipment (net)
Investment in Subsidiary
Total Assets
$ 543,500
$ 249,000
Note Payable
$ 10,000
Other Liabilities
$ 158,000
Common Stock
Retained Earnings
Total Liabilities and Equities
$ 543,500
$ 249,000
Product Code-Accounts-Q25

Looking for best Accounts-Q25 online,please click here