Search here for Tutorials

If the Data is different in your question, please send your questions to homeworksolutionsnow@gmail.com. The questions will be answered at the same price.

LBJ Company -- You have just been contracted as a budget consultant by LBJ Company

You have just been contracted as a budget consultant by LBJ Company

COURSE PROJECT 1 INSTRUCTIONS
You have just been contracted as a budget consultant by LBJ Company, a distributor of bracelets to various retail outlets across the country. The company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash.

You have decided to prepare a cash budget for the upcoming fourth quarter in order to show management the benefits that can be gained from proper cash planning.  You have worked with accounting and other areas to gather the information assembled below.

The company sells many styles of bracelets, but all are sold for the same $10 price.  Actual sales of bracelets for the last three months and budgeted sales for the next six months follow:

July (actual)
20,000
August (actual)
26,000
September (actual)  
40,000        
October (budget)      
70,000
November (budget)   
110,000
December (budget)   
60,000
January (budget)       
30,000
February (budget)      
28,000
March (budget)             
25,000

The concentration of sales in the fourth quarter is due to the Christmas holiday. Sufficient inventory should be on hand at the end of each month to supply 40% of the bracelets sold in the following month.

 Suppliers are paid $4 for each bracelet.  Fifty-percent of a month's purchases is paid for in the month of purchase; the other 50% is paid for in the following month.  All sales are on credit with no discounts.  The company has found, however, that only 20% of a month's sales are collected in the month of sale. An additional 70% is collected in the following month, and the remaining 10% is collected in the second month following sale.  Bad debts have been negligible.

Monthly operating expenses for the company are given below:
Variable expenses:
Sales commissions                         4% of sales
Fixed expenses:
Advertising                                        $220,000
Rent                                                      $20,000
Salaries                                          $110,000
Utilities                                              $10,000
Insurance                                            $5,000
Depreciation                                      $18,000

Insurance is paid on an annual basis, in January of each year.

The company plans to purchase $22,000 in new equipment during October and $50,000 in new equipment during November; both purchases will be for cash. The company declares dividends of $20,000 each quarter, payable in the first month of the following quarter.

 Other relevant data is given below:
Cash balance as of September 30                       $74,000
Inventory balance as of September 30             $112,000
Merchandise purchases for September            $200,000

The company maintains a minimum cash balance of at least $50,000 at the end of each month.  All borrowing is done at the beginning of a month; any repayments are made at the end of a month.

The company has an agreement with a bank that allows the company to borrow the exact amount needed at the beginning of each month. The interest rate on these loans is 1% per month and for simplicity we will assume that interest is not compounded. At the end of the quarter, the company will pay the bank all of the accrued interest on the loan and as much of the loan as possible while still retaining at least $50,000 in cash.

Required:
Prepare a cash budget for the three-month period ending December 31. Include the following detailed budgets:
1.
aA sales budget, by month and in total.
bA schedule of expected cash collections from sales, by month and in total.
cA merchandise purchases budget in units and in dollars. Show the budget by month and in total.
dA schedule of expected cash disbursements for merchandise purchases, by month and in total.

2. A cash budget. Show the budget by month and in total. Determine any borrowing that would be needed to maintain the minimum cash balance of $50,000.

TUTORIAL PREVIEW
LBJ Company
SALES BUDGET:
October
November
December
Quarter
Budgeted unit sales
     70,000
      110,000
       60,000
      240,000
Selling price per unit
           10
             10
             10
              10
Total Sales
   700,000
   1,100,000
     600,000
    2,400,000

 

File name: LBJ Company.xlsx  File type: .xlsx PRICE: $20

ACC 550 INTERMEDIATE ACCOUNTING I -- The following transactions pertain to Ski Training Company for 2015

ACC 550
INTERMEDIATE ACCOUNTING I
PRINCIPLES REVIEW #2
SPRING SEMESTER I 2016

The following transactions pertain to Ski Training Company for 2015:

· Jan 30 Established the business when it acquired $75,000 cash from the issuance of common stock. · Feb 1 Paid rent for office space for two years, $24,000 cash.
· Mar 1 Borrowed $20,000 cash from National Bank. The note issued had a 9% annual rate of interest and matures in one year.
· Apr 10 Purchased $5,300 of supplies on account.
· Jun 1 Paid $27,000 cash for a computer system which had a three-year useful life and no salvage value.
· July 1 Received $50,000 cash in advance for services to be provided over the next year.
· July 20 Paid $1,800 of the accounts payable from April 10.
· Aug 15 Billed a customer $32,000 for services provided during August.
· Sep 15 Completed a job and received $19,000 cash for services rendered.
· Oct 1 Paid employee salaries of $20,000 cash.
· Oct 15 Received $25,000 cash from accounts receivable.
· Nov 16 Billed customers $37,000 for services rendered on account
· Dec 1 Paid a dividend of $6,000 cash to the stockholders.
· Dec 31 Adjusted records to recognize the amount of services provided on contract on July 1 (assume earned ratably).
· Dec 31 Recorded the accrued interest on the note to National Bank (see March 1).
· Dec 31 Recorded depreciation on the computer system used in the business (see June 1).
· Dec 31 Recorded $4,500 of accrued salaries as of December 31.
· Dec 31 Recorded the rent expense for the year (see February 1).
· Dec 31 Physically counted supplies; $480 was on hand at the end of the period.

REQUIRED:
(a) Prepare journal entries for the transactions above. Use good form for the journal entries.
(b) Prepare a trial balance at December 31 based on the journal entries above.
(c) Prepare an income statement for the year.
(d) Prepare a statement of shareholders’ equity for the year.
(e) Prepare a classified balance sheet as of the end of the year.
(f) Prepare closing journal entries for the month.
(g) Prepare a post-closing trial balance after making the closing entries above.


TUTORIAL PREVIEW
(a) Journal entries:
Date
Account Title
Debit
Credit
30-Jan
Cash
75,000
      Common Stock
75,000
01-Feb
Prepaid rent
24,000
      Cash
24,000



File name: Ski Training Company.xlsx File type: .xlsx PRICE: $40

P21-1 P21-4 P21-8 PA-1

P21-1 P21-4 P21-8 PA-1

 
P21-1 Listed below are transactions that might be reported as investing and/or financing activities on a statement of cash flows.


P21-1 Classification of cash flows from investing and financing activities


P21-1 Listed below are transactions that might be reported as investing and/or financing activities on a statement of cash flows. Possible reporting classifications of those transactions are provided also.

 
Required:
Indicate the reporting classification of each transaction by entering the appropriate classification code


P21-4 Statement of cash flows; direct method
P21-4 The comparative balance sheets for 2013 and 2012 and the statement of income for 2013 are given below for Dux Company. Additional information from Dux's accounting records is provided also.

Additional information from the accounting records:

a. A building that originally cost $40,000, and which was three-fourths depreciated, was sold for $7,000.
b. The common stock of Byrd Corporation was purchased for $5,000 as a long-term investment.
c. Property was acquired by issuing a 13%, seven-year, $30,000 note payable to the seller.
d. New equipment was purchased for $15,000 cash.
e. On January 1, 2013, $25,000 of bonds were sold at face value.
f. On January 19, Dux issued a 5% stock dividend (1,000 shares). The market price of the $10 par value common stock was $14 per share at that time.
g. Cash dividends of $13,000 were paid to shareholders.
h. On November 12, 500 shares of common stock were repurchased as treasury stock at a cost of $8,000.

Required:
Prepare the statement of cash flows of Dux Company for the year ended December 31, 2011. Present cash flows from operating activities by the direct method. (You may omit the schedule to reconcile net income to cash flows from operating activities.)

 
P21-8 Cash flows from operating activities (direct method and indirect method)—deferred income tax liability and amortization of bond discount

P21-8 Portions of the financial statements for Parnell Company are provided below.

Required:
1. Prepare the cash flows from operating activities section of the statement of cash flows for Parnell Company using the direct method.
2. Prepare the cash flows from operating activities section of the statement of cash flows for Parnell Company using the indirect method.

 
PA-1 Derivatives – interest rate swap
On January 1, 2013, Labtech Circuits borrowed $100,000 from First Bank by issuing a

On January 1, 2013, Labtech Circuits borrowed $100,000 from First Bank by issuing a three-year, 8% note, payable on December 31, 2015. Labtech wanted to hedge the risk that general interest rates will decline, causing the fair value of its debt to increase. Therefore, Labtech entered into a three-year interest rate swap agreement on January 1, 2013, and designated the swap as a fair value hedge. The agreement called for the company to receive payment based on an 8% fixed interest rate on a notional amount of $100,000 and to pay interest based on a floating interest rate tied to LIBOR. The contract called for cash settlement of the net interest amount on December 31 of each year. Floating (LIBOR) settlement rates were 8% at inception and 9%, 7%, and 7% at the end of 2013, 2014, and 2015, respectively. The fair values of the swap are quotes obtained from a derivatives dealer. These quotes and the fair values of the note are as follows:

Required:

1. Calculate the net cash settlement at the end of 2013, 2014, and 2015.

2. Prepare the journal entries during 2013 to record the issuance of the note, interest, and necessary adjustments for changes in fair value.

3. Prepare the journal entries during 2014 to record interest, net cash interest settlement for the interest rate swap, and necessary adjustments for changes in fair value. A-18

4. Prepare the journal entries during 2015 to record interest, net cash interest settlement for the interest rate swap, necessary adjustments for changes in fair value, and repayment of the debt.

5. Calculate the carrying values of both the swap account and the note in each of the three years.

6. Calculate the net effect on earnings of the hedging arrangement in each of the three years. (Ignore income taxes.) 7. Suppose the fair value of the note at December 31, 2013, had been $97,000 rather than $98,241 with the additional decline in fair value due to investors' perceptions that the creditworthiness of Labtech was worsening. How would that affect your entries to record changes in the fair values? 


TUTORIAL PREVIEW
Direct Method
Cash Flows From Operating Activities:
 
Cash received from customers
$692
Cash paid to suppliers
(103)
Cash paid to employees
(111)

 

File name: P21-1 P21-4 P21-8 PA-1.docx  File type: .doc PRICE: $40

P19-1 P19-5 P20-1 P20-7 P20-8 P20-12

P19-1 P19-5 P20-1 P20-7 P20-8 P20-12

P19-1 On October 15, 2012, the board of directors of Ensor Materials Corporation approved a stock option plan for key executives. On January 1, 2013, 20 million stock options were granted, exercisable for 20 million shares of Ensor's $1 par common stock. The options are exercisable between January 1, 2016, and December 31, 2018, at 80% of the quoted market price on January 1, 2013, which was $15. The fair value of the 20 million options, estimated by an appropriate option pricing model, is $6 per option.

Two million options were forfeited when an executive resigned in 2014. All other options were exercised on July 12, 2017, when the stock's price jumped unexpectedly to $19 per share.

Required:
1. When is Ensor's stock option measurement date?
2. Determine the compensation expense for the stock option plan in 2013. (Ignore taxes.)
3. What is the effect of forfeiture of the stock options on Ensor's financial statements for 2014 and 2015?
4. Is this effect consistent with the general approach for accounting for changes in estimates? Explain.
5. How should Ensor account for the exercise of the options in 2017? (Enter your answers in millions. (Round your answers to the nearest dollar amount. Omit the "$" sign in your response.)


P19-5 Apple inc provides its executives compensation under a variety of share based compensation plan including restricted stock awards. The following disclosure note from Apple’s 2009 annual report describes the plan created for the company’s chief executive officer, Steve Jobs;

CEO RESTRICTED STOCK AWARD
On March 19, 2003, the company’s board of Directors granted 10 million shares of restricted stock to the company’s CEO that vested on March 19, 2006. The amount of the restrict stock award expensed by the company was based on the closing market price of the company’s common stock on the date of grant and was amortized ratably on a straight line basis over the three year requisite service period. Upon vesting during 2006, the 10 million shares of restricted stock had a fair value of $646.6 million and had grant date fair value of $7.48 per share. The restricted stock award wat net share settled such that the company withheld shares with value equivalent to the CEO’s minimum statutory obligation for the applicable income and other employment taxes, and remitted the cash to the appropriate taxing authorities. The total shares withheld of 4.6 million were based on the value of the restricted stock awarded on the vesting date as determined by the company’s closing stock price of $64.66. the remaining shares net of those withheld were delivered to the company’s CEO. Total payments for the CEO’s tax obligations to the taxing authorities were $296 million in 2006 and are reflected as a financing activity within the consolidated statements of cash flows. The net share settlement had the effect of share repurchases by the company as it reduced and retired the number of shares outstanding and did not represent an expense to the company. The company’s CEO has no remaining shares of restricted stock.

Real World Financials
Required.
1.  How much compensation did Apple record for its CEO related to the restricted stock in its fiscal year ended.
2. What was the CEO’s combined income tax and employment tax rate that Apple used to determine the shares to be withheld at vesting?
3. From the information provided in the disclosure note, recreate the journal entries Apple used to record compensation expense and its related tax affects on September 24, 2005 , the end of the 2005 fiscal year.
4. From the information provided in the disclosure not, recreate the journal entries Apple used to record the vesting of the restricted stock and its related tax effect s on March 16, 2006, assuming the remaining compensation expense already has been recorded.

P 20-1 Change in inventory costing methods; comparative income statements

The Cecil-Booker Vending Company changed its method of valuing inventory from the average cost method to the FIFO cost method at the beginning of 2013. At December 31, 2012, inventories were $120,000 (average cost basis) and were $124,000 a year earlier. Cecil-Booker's accountants determined that the inventories would have totaled $155,000 at December 31, 2012, and $160,000 at December 31, 2011, if determined on a FIFO basis. A tax rate of 40% is in effect for all years.

One hundred thousand common shares were outstanding each year. Income from continuing operations was $400,000 in 2012 and $525,000 in 2013. There were no extraordinary items either year.


Required:
1. Prepare the journal entry to record the change in accounting principle. (All tax effects should be reflected in the deferred tax liability account.)

2. Prepare the 2013–2012 comparative income statements beginning with income from continuing operations. Include per share amounts.

P 20-7 Depletion; change in estimate

In 2013, the Marion Company purchased land containing a mineral mine for $1,600,000. Additional costs of $600,000 were incurred to develop the mine. Geologists estimated that 400,000 tons of ore would be extracted. After the ore is removed, the land will have a resale value of $100,000.

To aid in the extraction, Marion built various structures and small storage buildings on the site at a cost of $150,000. These structures have a useful life of 10 years. The structures cannot be moved after the ore has been removed and will be left at the site. In addition, new equipment costing $80,000 was purchased and installed at the site. Marion does not plan to move the equipment to another site, but estimates that it can be sold at auction for $4,000 after the mining project is completed

In 2013, 50,000 tons of ore were extracted and sold. In 2014, the estimate of total tons of ore in the mine was revised from 400,000 to 487,500. During 2014, 80,000 tons were extracted.

Required:
1. Compute depletion and depreciation of the mine and the mining facilities and equipment for 2013 and 2014. Marion uses the units-of-production method to determine depreciation on mining facilities and equipment.

2. Compute the book value of the mineral mine, structures, and equipment as of December 31, 2014.


P 20-8 Accounting changes; six situations

Described below are six independent and unrelated situations involving accounting changes. Each change occurs during 2013 before any adjusting entries or closing entries were prepared. Assume the tax rate for each company is 40% in all years. Any tax effects should be adjusted through the deferred tax liability account.

a.  Fleming Home Products introduced a new line of commercial awnings in 2012 that carry a one-year warranty against manufacturer's defects. Based on industry experience, warranty costs were expected to approximate 3% of sales. Sales of the awnings in 2012 were $3,500,000. Accordingly, warranty expense and a warranty liability of $105,000 were recorded in 2012. In late 2013, the company's claims experience was evaluated and it was determined that claims were far fewer than expected: 2% of sales rather than 3%. Sales of the awnings in 2013 were $4,000,000 and warranty expenditures in 2013 totaled $91,000.

b. On December 30, 2009, Rival Industries acquired its office building at a cost of $1,000,000. It was depreciated on a straight-line basis assuming a useful life of 40 years and no salvage value. However, plans were finalized in 2013 to relocate the company headquarters at the end of 2017. The vacated office building will have a salvage value at that time of $700,000.

c. Hobbs-Barto Merchandising, Inc., changed inventory cost methods to LIFO from FIFO at the end of 2013 for both financial statement and income tax purposes. Under FIFO, the inventory at January 1, 2014, is $690,000.

d. At the beginning of 2010, the Hoffman Group purchased office equipment at a cost of $330,000. Its useful life was estimated to be 10 years with no salvage value. The equipment was depreciated by the sum-of-the-years'-digits method. On January 1, 2013, the company changed to the straight-line method.

e. In November 2011, the State of Minnesota filed suit against Huggins Manufacturing Company, seeking penalties for violations of clean air laws. When the financial statements were issued in 2012, Huggins had not reached a settlement with state authorities, but legal counsel advised Huggins that it was probable the company would have to pay $200,000 in penalties. Accordingly, the following entry was recorded:
Loss—litigation ................................................ 200,000
Liability—litigation ........................................                      200,000

Late in 2013, a settlement was reached with state authorities to pay a total of $350,000 in penalties.

f. At the beginning of 2013, Jantzen Specialties, which uses the sum-of-the-years'-digits method, changed to the straight-line method for newly acquired buildings and equipment. The change increased current year net earnings by $445,000.

Required:
For each situation:
1. Identify the type of change.
2. Prepare any journal entry necessary as a direct result of the change as well as any adjusting entry for 2011 related to the situation described.
3. Briefly describe any other steps that should be taken to appropriately report the situation.

P20-12 Accounting changes and error correction; eight situations; tax effects ignored
Williams-Santana, Inc., is a manufacturer of high-tech industrial parts that was started in 2001 by two talented engineers with little business training. In 2013, the company was acquired by one of its major customers. As part of an internal audit, the following facts were discovered. The audit occurred during 2013 before any adjusting entries or closing entries were prepared.

a. A five-year casualty insurance policy was purchased at the beginning of 2011 for $35,000. The full amount was debited to insurance expense at the time.
b. Effective January 1, 2013, the company changed the salvage value used in calculating depreciation for its office building. The building cost $600,000 on December 29, 2002, and has been depreciated on a straight-line basis assuming a useful life of 40 years and a salvage value of $100,000. Declining real estate values in the area indicate that the salvage value will be no more than $25,000.
c. On December 31, 2012, merchandise inventory was overstated by $25,000 due to a mistake in the physical inventory count using the periodic inventory system.
d. The company changed inventory cost methods to FIFO from LIFO at the end of 2013 for both financial statement and income tax purposes. The change will cause a $960,000 increase in the beginning inventory at January 1, 2014.
e. At the end of 2012, the company failed to accrue $15,500 of sales commissions earned by employees during 2012. The expense was recorded when the commissions were paid in early 2013.
f. At the beginning of 2011, the company purchased a machine at a cost of $720,000. Its useful life was estimated to be 10 years with no salvage value. The machine has been depreciated by the double-declining balance method. Its carrying amount on December 31, 2012, was $460,800. On January 1, 2013, the company changed to the straight-line method.
g. Bad debt expense is determined each year as 1% of credit sales. Actual collection experience of recent years indicates that 0.75% is a better indication of uncollectible accounts. Management effects the change in 2013. Credit sales for 2013 are $4,000,000; in 2012 they were $3,700,000.

Required:
For each situation:
1. Identify whether it represents an accounting change or an error. If an accounting change, identify the type of change.
2. Prepare any journal entry necessary as a direct result of the change or error correction as well as any adjusting entry for 2013 related to the situation described. (Ignore tax effects.)
3. Briefly describe any other steps that should be taken to appropriately report the situation.



TUTORIAL PREVIEW
SOLUTION
Requirement 1
Cost of mineral mine:
Purchase price
$1,600,000
Development costs
    600,000

$2,200,000
                                   
Depletion:
Depletion per ton  = ($2,200,000 – 100,000)/ 400,000 tons=  $5.25 per ton 


File name: P19-1 P19-5 P20-1 P20-7 P20-8 P20-12.docx File type: .doc PRICE: $35