In: Accounting
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.
R&M Cost
Year (per copier)
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:
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.