Accounting
ORDER A PLAGIARISM FREE PAPER NOW
In early December 20X2, Nick Riley called Tom Fasbee to tell him that, in addition to meeting several other criteria, Aguamaint’s loan covenants required annual financial statements be submitted to the bank. Regina Sontag at Midwest Regional Bank had reminded Nick that the statements must be reviewed by a CPA and that the review and related report should be comparable to what Lake & Lock had done last year. In addition, the bank requested comparative financial statements, including notes that provide the fair value of all financial instruments and information on major customers. Nick wanted to know if Lake & Lock would do the work again. Tom said his firm would be delighted to do it. Nick then requested that Tom send out the same person. He indicated that Aguamaint’s people knew you and had confidence in your ability. Tom indicated that Nick’s staffing request would be “no problem.”
You, of course, were happy to be called on again. You made arrangements with Jerry Loos to obtain financial statements as early as possible in 20X3. You received Aguamaint’s 20X2 financial statements on Wednesday, January 13. A preliminary review revealed the large crew truck investment made earlier in the year. You decided that a quick stop at Linda Durkee’s office would be appropriate. Linda represented Lake & Lock on Aguamaint’s tax work. You asked Linda how the crew trucks would be depreciated for tax purposes. She indicated that they would be depreciated using the 5-year half year convention Modified Accelerated Cost Recovery System (MACRS) schedule. She also reminded you that the Shop Equipment purchased last year is being depreciated using the 7-year half year convention MACRS schedule. She also noted that she understood that all items classified as property, plant, and equipment are depreciated to the nearest full year for book purposes.
Linda had a number of questions for you on another client, so you completed your conversation over lunch. Before leaving, she reminded you that the MACRS depreciation schedules can be found on the IRS.gov website.
You planned to spend the afternoon reviewing Aguamaint’s preliminary financial statements in detail and get questions to Jerry by Thursday. Jerry then would prepare responses so that you could begin the review on the following Monday.
REQUIRED:
The journal entries and financial statements prepared by Jerry Loos are attached. The crew truck cost schedule you recommended Jerry prepare is also included. You will find that it is not at all clear how Jerry calculated the numbers on the schedule.
Review the client’s data and prepare a list of additional information items needed from Jerry. Be sure to include any necessary questions to get the information needed to reconcile each truck schedule number, and to add any needed items. Be as specific as possible and phrase your requests in the form of questions as they normally would be asked of a client. Be sure to provide a written reason that you are asking each question and also provide a reference to the FASB codification where appropriate.
Jerry assured you that the bank account has been reconciled and that outstanding checks account for the only reconciling items. He also indicated that all vendor invoices reflecting business through December 31, 20X2 have been booked.
AGUAMAINT, INC.
JOURNAL ENTRIES
DECEMBER 31, 20X2 (cont.)
Solution to the Crew Trucks Cost Schedule
YOUR QUESTIONS AND CLIENT RESPONSES
1. Who planned the truck modification work? How was it supervised? Was it someone on payroll or do you have an invoice for this work?
The specifications were drawn by Nick Riley, which took him only about 10 hours. The actual work was supervised by Ray Ballard, who spent about 20 hours on this task. We just calculated the amounts on an average hourly rate based on their salaries.
2. We noticed shop labor on your schedule of truck additions. Was this work done by your employees, and if so, did they work only on the trucks during that month and a half period, or was there other business-related work going on in the shop at the same time? If they worked on other jobs besides the retooling of the trucks, we need to know what cost driver you used to allocate the rent and utilities. We also need to make sure the $7,200 in labor costs did not include work on jobs other than the truck modifications. Also, how many hours did they work on the trucks?
All the work on the trucks was completed by Aguamaint’s crew. They worked on the trucks and other jobs in the shop during that time, and the entire $7,200 was incurred on the retooling job. Total shop labor for the same period amounted to $17,475. That ratio was the basis of my allocation of rent and utilities. The crew worked 300 hours on the trucks.
3. How much was the total rent and utilities for the month and a half that you worked on the trucks?
Shop rent and utilities expense for the one and one-half months totaled $5,656.
4. We did not see any interest expense accrued for 20X2. Shouldn’t we expense the interest due on the note as of year-end?
I didn’t record the interest because I didn’t have to make a payment until this year.
5. Speaking of interest, we believe that you can capitalize some interest cost to the trucks since the retooling qualifies as a self-constructed asset. As long as the investment was substantial and an extended period of time was spent preparing the property for use, GAAP allows this. We think you meet this criteria, but we need to know when you purchased the various items used to modify the trucks to be able to complete our calculation.
All materials were on hand or purchased by February 1 so they would be available as needed.
6. Do you anticipate any collection problems on accounts receivable? Your ending balance has increased by over 77 percent. Is an allowance required at year-end?
We think it is all collectible. The last payment received on the $13,000 monthly contract executed on 3/1 was received at the end of October, for work done in September. Nick says we just will not renew the contract if the balance is not paid by March 1, so I am not going to worry about it until then. We are confident it will be paid. We have a $12,000 amount due from another client, but they told us the check is in the mail, so that is not a problem either. Everything else is on time.
7. We remember at the end of last year that you had not booked the supplies inventory on hand as an asset. Were these supplies inventoried at year-end this year? How were their values calculated?
Shop supplies were inventoried on December 31 and their costs were computed from the latest invoices. I made an adjusting entry for this similar to the one you had me make last year.
8. We noticed that wages payable decreased quite a bit from last year, despite having one more day in the pay period to accrue and the fact that your operations increased this year. Is there a reason for this decrease and could you make the time cards available to us?
Things went well for us this year and due to a very mild December, we ended up being ahead of schedule in completing our maintenance work for the month. As a result, we were able to close down over the holiday and give our crew several days off. Unfortunately, it was unpaid time, but they were still happy to have the break. In addition, we did not have to pay any overtime at the end of December this year. I have the time cards if you need them.
9. From our calculations, it appears that you are depreciating the original cost of the trucks over a six-year period, using straight-line and with no salvage value. Is that correct? Also, we did not see any depreciation taken on the additions to the trucks. We will need to adjust for that using the same method you used for the trucks.
Yes, the trucks are depreciated over six years to the nearest full year. Salvage value is expected to be zero. I guess I was so busy getting that truck schedule done that I forgot to take the additional depreciation. Would the capitalized interest affect that depreciation amount? Can you take care of that for me please?
10. What are the requirements set out by the covenants on the bank loan?
There are a few ratios that we need to calculate. They want our current ratio to be at least 1.5 and they want our long-term liabilities to equity ratio to be under 1.2. Dividends may not be distributed unless earnings exceed five times interest. Loans may not be made either to Mr. Ballard or to Mr. Riley. Salary increases for Mr. Ballard and Mr. Riley must be approved by the bank. We are in compliance with all of those things. In fact our current ratio is about 3.5.
11. It looks like the short-term portion of the truck note needs to be reclassified. What do you think?
I didn’t reclassify the short-term principal portion due in 20X3. I didn’t think I needed it on the financial statements because I have a loan amortization schedule from the bank that helps me keep track of how the payments are allocated to principal and interest.
12. Could we get a list all maintenance contracts and their terms please? We need this information as a basis for disclosing any major customers.
Here it is…we have got some new contracts that we collect in advance now, so that has really helped us bump up our revenue.
13. We noticed that the cost of leasing trucks has decreased to $24,600 for this year. Is this because you purchased the two new trucks? We also noticed that the lease payment on your new building is $39,000, which is much higher than you paid for your location last year. We are assuming you entered into a long-term lease when you moved, so we need some additional information from you to help us determine if this is an operating or a finance lease. How long is the lease? Will you own the building when the lease ends? Can you provide us with the fair value of the building and also the interest rate used to determine the annual payments? We also need to know the useful life of the building.
We no longer lease the trucks since we purchased and retooled the new ones. That $24,600 was incurred to rent trucks at the $150/day rate until we got the new trucks retooled.
I agree that the $39,000 is a little high, but that’s the agreement that Nick and Ray negotiated. They settled on a 5.25% interest rate and a 10 year lease term. We only rent a little over half of the building, so will not own it at the end of the 10 years. I am pretty sure the building is worth well over a million dollars. It’s a relatively new building, so is not going to wear out anytime soon—certainly not within the next 50 years. We have a great location here, and the real estate prices just keep going up in this area. That is all the information I have. You can see that I recorded the lease payment correctly in the journal entries, and even allocated it between the shop and the office spaces. Why do you need all this detail? Do you want a copy of the lease?
14. We noticed the prepaid insurance balance has not changed from last year. Did you purchase any more insurance or did any of the terms of the policies change?
I forgot about adjusting that. We did not buy any more insurance and nothing has changed. That reminds me, we need to renew those policies next month.
15. Have you considered temporary differences in your income tax calculations for the year? It appears you may have a few of these.
I really don’t understand taxes very well. I just multiplied our income by a tax rate of 30%. I have no idea what you mean by temporary differences. What would cause those?
16. Are there any transactions or events that have occurred since year end 20X2 that we should disclose as subsequent events this year?
As a matter of fact, yes, there is one thing. We are implementing a retirement plan for all Aguamaint employees as of January 1, 20X3. I am very happy about this since it was not something I expected to happen.
11553SERVICE COSTS-DIRECT-FUEL 42,077
101CASH 42,077
To record purchase and payment of truck fuel.
12181VEHICLES 11,934
564SERVICE COSTS-INDIRECT-SUPPLIES 32,660
302ACCTS PAY-SUPPLIERS-OTHER COSTS 44,594
To record purchase of supplies, and to capitalize parts used for truck modifications.
13129SUPPLIES ON HAND 2,987
564SERVICE COSTS-INDIRECT-SUPPLIES 2,987
To adjust to ending supplies inventory count.
14552SERVICE COSTS-DIRECT-LEASE EXPENSE-TRUCKS 24,600
101CASH 24,600
To record rent payment for maintenance trucks.
15302ACCTS PAY-SUPPLIERS-OTHER COSTS 51,440
101CASH 51,440
To record payment on account.
1612/31/X2701TRUCK DEPRECIATION 34,667
182VEHICLES-ACCUMULATED DEPRECIATION 34,667
To record depreciation expense on trucks.
1712/31/X2704EQUIPMENT DEPRECIATION 6,100
172EQUIPMENT-ACCUMULATED DEPRECIATION 6,100
To record depreciation expense on shop equipment.
1812/31/X2710AMORTIZATION OF LICENSING COSTS 3,200
197LICENSE 3,200
To record amortization of licensing costs.
1912/31/X2821INCOME TAX EXPENSE 112,624
314INCOME TAX PAYABLE 112,624
To record income tax expense at statutory rate of 30%.
Totals3,904,987 3,904,987
Initial investment, Dealer 1208,000$
Additions:
Shop crew labor7,200
Materials11,934
Planning and supervision975
Shop rent allocation1,674
Shop utilities allocation657
Crew Truck Cost230,440$
AGUAMAINT, INC.
Crew Trucks Cost Schedule
20X2
Supporting Calculations:
Initial investment, Dealer 1208,000$
Additions:
Shop crew labor7,200 per client records
Materials11,934 per invoices
Planning and supervision975 $65,000/2,000 X 30
Shop rent allocation1,674 7,200/17,475 X 5,656 X 32,500/45,250
Shop utilities allocation657 7,200/17,475 X 5,656 X 12,750/45,250
Capitalize interest1,560 12,480/12 X 1.5
Total Crew Truck Cost232,000$
20X2
Note: Interest is calculated based on the assumption that the cost of all materials, labor, and overhead allocations were
incurred at the beginning of the retooling period since the work on the trucks only took one and a half months. In other
words, the benefit of calculating the weighted average expenditures is not cost effective.
AGUAMAINT, INC.
Crew Trucks Cost Schedule
OriginalTermBeginning A/RTotal CashMonths Earned# PaymentsEnding A/R
Contract #Contract TermMonthsPayment ArrangementBalanceReceivedin Current YearReceivedBalance
12/1/X1-1/31/X212End of Month Payment$12,000$132,0001211$24,000
$12,000
22/1/X1-1/31/X212End of Month Payment$14,000$168,0001212$14,000
$14,000
32/1/X1-1/31/X212End of Month Payment$13,000$156,0001212$13,000
$13,000
43/1/X1-2/28/X212End of Month Payment$9,000$108,0001212$9,000
$9,000
53/1/X1-2/28/X212End of Month Payment$13,000$130,0001210$39,000
$13,000
65/1/X1-4/30/X212End of Month Payment$8,600$103,2001212$8,600
$8,600
78/1/X1-7/31/X212End of Month Payment$10,000$120,0001212$10,000
$10,000
83/1/X2-2/28/X312Advance Payment$112,80010
$9,400
93/1/X2-2/28/X312Advance Payment$162,00010
$13,500
105/1/X2-4/30/X312End of Month Payment$77,00087$11,000
$11,000
1112/1/X2-11/30/X312End of Month Payment$010$12,500
$12,500
$79,600$1,269,000$141,100
AGUAMAINT, INC.
Contract List for 20X2
20X2
CURRENT ASSETS
Cash322,474$
Accounts receivable141,100
Supplies on hand 8,177
Prepaid insurance 2,649
Total Current Assets474,400
LONG-TERM ASSETS
Equipment 42,700
Accumulated depreciation-equipment(12,200)
Vehicles230,440
Accumulated depreciation-vehicles(34,667)
NOL tax benefit 3,832
NOL valuation allowance (1,341)
License 41,600
Total Long-Term Assets270,364
TOTAL ASSETS 744,764$
LIABILITIES
CURRENT LIABILITIES
Accounts payable 12,254$
Wages payable 9,380
Taxes payable112,624
Total Current Liabilities134,258
LONG TERM LIABILITIES
Note payable208,000
STOCKHOLDERS’ EQUITY
Common stock150,000
Retained earnings252,506
Total Stockholders’ Equity402,506
TOTAL LIABILITIES AND STOCKHOLDERS’ EQUITY 744,764$
BALANCE SHEET
LIABILITIES AND STOCKHOLDERS’ EQUITY
AGUAMAINT, INC.
ASSETS
DECEMBER 31, 20X2
20X2
Service revenue1,330,500$
Cost of goods sold633,279
Gross profit697,221
Operating expenses
Selling and administrative277,840
Depreciation and amortization43,967
Total operating expenses321,807
Operating income before income taxes375,414
Income tax expense(112,624)
Net income262,790$
AGUAMAINT, INC.
STATEMENT OF INCOME
FOR THE YEARS ENDING DECEMBER 31,
J/E #DATEACCT #ACCOUNT NAME DEBITCREDIT
11/1/X2563SERVICE COSTS-INDIRECT-LEASE EXPENSE-SHOP BLDG 32,500
602SELLING & ADMIN-LEASE EXPENSE-OFFICE BLDG 6,500
101CASH 39,000
To record and allocate new building lease payment.
22/1/X2101CASH 208,000
401LONG-TERM DEBT-NOTES 208,000
To record issuance of long-term notes payable.
32/1/X2181VEHICLES 208,000
101CASH 208,000
To record purchase of two new trucks.
4101CASH 274,800
105ACCOUNTS RECEIVABLE 1,055,700
505SERVICE REVENUE FROM CONTRACTS WITH CUSTOMERS 1,330,500
To record revenue from maintenance contracts.
5101CASH 994,200
105ACCOUNTS RECEIVABLE 994,200
To record receipts on account.
6560SERVICE COSTS-DIRECT-CREW WAGES 347,010
305WAGES PAYABLE 15,050
101CASH 355,780
305WAGES PAYABLE 6,280
To record accrual and payment of crew wages.
7181VEHICLES 7,200
561SERVICE COSTS-INDIRECT-SHOP WAGES 147,000
101CASH 151,100
305WAGES PAYABLE 3,100
To record accrual and payment of shop wages, including wages capitalized to trucks.
8181VEHICLES 975
631SELLING & ADMINISTRATIVE-OTHER 7,250
611SELLING & ADMIN-OFFICERS SALARIES 129,025
612SELLING & ADMIN-OTHER SALARIES 52,000
609SELLING & ADMIN-PROFESSIONAL FEES 5,820
615SELLING & ADMIN-PAYROLL AND OTHER TAXES 58,695
607SELLING & ADMIN-SUPPLIES 16,000
101CASH 269,765
To record accrual and payment of S&A expenses, including salary capitalized to trucks.
9181VEHICLES 657
562SERVICE COSTS-INDIRECT-SHOP UTILITIES 12,093
601SELLING & ADMIN-UTILITIES 2,550
101CASH 15,300
To record accrual and payment of utilities, including amount capitalized to trucks.
10181VEHICLES 1,674
563SERVICE COSTS-INDIRECT-LEASE EXPENSE-SHOP BLDG 1,674
To capitalize part of shop rent to trucks.
AGUAMAINT, INC.
JOURNAL ENTRIES
DECEMBER 31, 20X2