Question

In: Accounting

You are a staff accountant at a confectionary company, Philly Chocolates International (“the Company” or PCI)....

You are a staff accountant at a confectionary company, Philly Chocolates International (“the Company” or PCI). The lease on the current multifunction copiers the Company has in its headquarters is almost up. PCI has decided to replace the current copiers with Canon imageRunnerAdvanceC55501 copiers. The CFO has asked you to investigate the impact to the financial statements over the next five years if PCI buys the copiers for cash. The following is the information you have been able to gather so far.

  • The copiers cost $9,190 each and PCI will need 15 copiers.
  • The local dealer is willing to offer credit terms of 2/15, net 45 on the purchase. PCI usually takes advantage of such discounts.
  • The copiers have an estimated useful life of 5 years and a projected salvage value of $900 each. PCI depreciates similar assets using the double declining balance and nearest month methods.
  • Based on its research, PCI’s tech department estimates that repairs and maintenance on the new copiers will be minimal the first two years while they are under warranty and increase steadily over the remaining useful lives. They have provided you with the following estimates.

         R&M Cost

Year       (per copier)

  1. $ 50
  2. $200
  3. $300
  4. $500
  5. $500
  6. $500

Assignment

Prepare a set of schedules for the CFO summarizing the impact to the balance sheet and income statement over the next five years of buying 15 Canon imageRunnerAdvanceC55501 copiers as well as projected costs as outlined above. Note assume the College purchases the copiers on October 31, 2018 and pays for repairs and maintenance with cash. To support your analysis you should include the following supporting schedules:

  1. A table summarizing the balance sheet and income statement impact in each of the five years
  2. Using Hershey’s 3rd Quarter 2018 financial statements, project the year-end 2018 balances with and without this transaction. What would Asset Turnover, Profit Margin on Sales, and Return on Assets be with and without this transaction?

Solutions

Expert Solution

Credit of 2/15, net 45 means the discount of 2% is allowed, if the payment is made within 15 days and without any discount can be made within 45 days.As stated in the question, PCI usually takes the advantage of such discounts, the total amount spent on the purchase of 15 copiers are as under:-

Total Cost= Cost of each copier * No. of copiers

= $9190 * 15 = $137850

After discount, the amount spent would be:- $137850 - 2%(137850)= $ 135093

The company is following Double declining balance method. The beginning book value of the asset is $135093. The salvage value is $900 each which meant $13500 for 15 copiers. The total depriciable amount for the life of the asset is the difference between beginning book value and salvage value that is $(135093-13500)= $ 121593. The estimated useful life is 5 years.

The annual depriciation rate would be (100% / 5years = 20%), but we are following double declining rate of depriciation so we will multiply the beginning book value with twice the annual depriciation rate i.e 40%. The depriciation expense for five years is as follows:- (Assuming the depriciation for the full year)

Year1 Year2 Year3 Year4 Year5

Beginning Book value $135093 $81056 $48634 $29180 $17508

Depriciation expense $(54037) $(32422) $(19454) $(11672) $(4008)

Ending Book Value $81056 $48634 $29180 $17508 $13500

In year 5, the balance would shift and the accelerated approach would have only $4008 of depriciation.

A)

Now, as asked in in question, the extract of Income statement and Balance sheet over the five years are as follows:-

INCOME STATEMENT    Year1 Year2 Year3 Year4 Year5

Sales - - - - -

Expense Cost(15 copier)       (750) (3000) (4500) (7500) (7500)

Fixed Asset Cost (54037) (32422) (19454) (11672) (4008)

-------------------------------------------------------------------------------------------------------------------------------------------------------------

Net Profit/ (Loss) (54787) (35422) (23954) (19172) (11508)

---------------------------------------------------------------------------------------------------------------------------------------------------------------

BalanceSheet ( Extract) Year1 Year2 Year3 Year4 Year5

Fixed Asset $135093 $135093 $135093 $135093 $135093

Accumulated Depriciation (54037) (86459) (105913) (117585) (121593)

----------------------------------------------------------------------------------------------------------------------------------------------------------------

NET BOOK Value $81056 $48634 $29180 $17508 $13500

-----------------------------------------------------------------------------------------------------------------------------------------------------------------

b) For computing the Asset Turnover ratio, Divide the net sales or revenue by the average total assets. In this question, revenue or total sales of the company is not provided so it cannot be computed. Also, Profit margin on sales cannot be computed without sales figure.

Return on assets means net income divided by total assets. Since the sales figures are not provided in question, we are getting net loss as shown above, so this also cannot be computed.


Related Solutions

You are a staff accountant at a confectionary company, Philly Chocolates International (“the Company” or PCI)....
You are a staff accountant at a confectionary company, Philly Chocolates International (“the Company” or PCI). The lease on the current multifunction copiers the Company has in its headquarters is almost up. PCI has decided to replace the current copiers with Canon imageRunnerAdvanceC55501 copiers. The CFO has asked you to investigate the impact to the financial statements over the next five years if PCI buys the copiers for cash. The following is the information you have been able to gather...
You are a staff accountant at a higher education institution, Philly College of Business (“the College”...
You are a staff accountant at a higher education institution, Philly College of Business (“the College” or PCB). The lease on the current multifunction copiers the College uses is almost up. The college has decided to replace the current copiers with Canon imageRunner AdvanceC55501 copiers. The following is the information you have been able to gather so far related to renting the copiers. The IT department was able to negotiate the following lease terms to rent the 15 copiers needed....
You have just joined a company as a new staff accountant. Your company is in an...
You have just joined a company as a new staff accountant. Your company is in an acquisition mode (acquiring 5 to 10 smaller companies each of the last 4 years). You are excited to hear that you are going with an acquisition team to facilitate another acquisition (Company X). You have been instructed to sit down with Company X’s controller and explain some pre-acquisition (before the acquisition is finalized) accounting expectations. Expectations for Company X before the acquisition is finalized....
You are a staff accountant at Reimer & Company, a small public accounting firm. One of...
You are a staff accountant at Reimer & Company, a small public accounting firm. One of the firm's partners, Leona Reimer, has asked you to deal with a disgruntled client, Mr. Robert Ramsey, owner of the city's largest clothing store. Mr. Ramsey is applying to a local bank for a substantial loan to remodel his store. The bank requires accrual based financial statements, but Mr. Ramsey has always kept the company's records on a cash basis. He does not see...
You have been hired as a staff accountant by a small company that recently completed an...
You have been hired as a staff accountant by a small company that recently completed an initial public offering (IPO) of its common stock. At its inception, the company had been financed by Pegasus, an investment group. Pegasus had bought a significant amount of the company’s debt (equal to a third of its total assets) in the form of convertible bonds. The stock price has appreciated significant since the IPO, and Pegasus has decided to convert its debt securities into...
You are a staff accountant in a large accounting department in a multinational public company. Your...
You are a staff accountant in a large accounting department in a multinational public company. Your job requires you to review documents related to the company’s equipment perchases. Upon verifying that purchases are properly approved, you prepare journal entries to record the equipment purchases in the accounting system. Typically, you handle equipment purchases costing $100,000 or less. One day, the CFO unexpectedly calls you into an immediate meeting. You are anxious about the meeting and in your three years working...
You are recently hired as a staff accountant for a small finished goods manufacturing company. Part...
You are recently hired as a staff accountant for a small finished goods manufacturing company. Part of your duties include doing the month end inventory of finished goods. After a few months you do not look forward to this as the amount of inventory seems to be increasing. In order to satisfy your thoughts on this increase of inventory you decide to review the financial information for the last few months. Looking over the Income Statement you see the profits...
You are recently hired as a staff accountant for a small finished goods manufacturing company. Part...
You are recently hired as a staff accountant for a small finished goods manufacturing company. Part of your duties include doing the month end inventory of finished goods. After a few months you do not look forward to this as the amount of inventory seems to be increasing. In order to satisfy your thoughts on this increase of inventory you decide to review the financial information for the last few months. Looking over the Income Statement you see the profits...
Ms. Daneen is the management accountant of Delight Confectionaries which is a company manufacturing chocolates and...
Ms. Daneen is the management accountant of Delight Confectionaries which is a company manufacturing chocolates and candies in many flavours since 2017. The company has marketing, finance, production, customer services and human resources department. The management of the company has decided to introduce budgetary control system in the company from the year 2019. ANSWER THE FOLLOWING QUESTIONS: A. List, explain and justify the FOUR important budgets which Ms. Daneen will be preparing for the confectionaries company with suitable examples. Note:...
You are the accountant for an international shipping company. Provide the names of two asset accounts,...
You are the accountant for an international shipping company. Provide the names of two asset accounts, liabilityaccounts, and equity accounts for your company. Also describe the kinds of transactions that can be recorded in a general journal. Should a transaction be recorded first in a journal or a ledger?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT