Aubrae and Tylor Williamson began operations of their furniture repair shop (Furniture Refinishers, Inc.) on January 1, 2019. The annual reporting period ends December 31. The trial balance on January 1, 2020, was as follows:
| Furniture Refinishers, Inc. Trial Balance on January 1, 2020 |
|||||||
| Account Titles | Debit | Credit | |||||
| Cash | 5,000 | ||||||
| Accounts receivable | 4,000 | ||||||
| Supplies | 6,000 | ||||||
| Small tools | 6,000 | ||||||
| Equipment | |||||||
| Accumulated depreciation (on equipment) | |||||||
| Other noncurrent assets (not detailed to simplify) | 8,000 | ||||||
| Accounts payable | 6,000 | ||||||
| Dividends payable | |||||||
| Notes payable | |||||||
| Wages payable | |||||||
| Interest payable | |||||||
| Income taxes payable | |||||||
| Unearned revenue | |||||||
| Common stock (40,000 shares, $0.10 par value) | 4,000 | ||||||
| Additional paid-in capital | 6,000 | ||||||
| Retained earnings | 13,000 | ||||||
| Service revenue | |||||||
| Depreciation expense | |||||||
| Wages expense | |||||||
| Interest expense | |||||||
| Income tax expense | |||||||
| Miscellaneous expenses (not detailed to simplify) | |||||||
| Totals | 29,000 | 29,000 | |||||
Transactions during 2020 follow:
Data for adjusting entries:
In: Accounting
| Spring 2020 Spreadsheet Project | ||||||
| Name: | ||||||
| Lexie's Wool Sweaters | ||||||
| Projected Budgeting Data | ||||||
| Sales & Collections | ||||||
|
October 2020 |
November 2020 |
December 2020 |
January 2021 |
February 2021 |
||
| Sales in Units (Sweaters) | 30,000 | 34,000 | 55,000 | 47,000 | 32,000 | |
| Selling Price per Sweater | $ 100.00 | |||||
| Cash Sales Collected in the Month of Sale | 30% | |||||
| Credit Sales Collected in the Month of Sale | 50% | |||||
| Credit Sales Collected in the Following Month | 20% | |||||
| Ending FG Inventory Requirement | 3% | of next months unit sweater sales | ||||
| Ending FG Inventory, September 30 , 2020 | 1,500 | sweaters | ||||
| Product Input Expenses | ||||||
| Direct Materials | ||||||
| Ending RM Inventory, September 30, 2020 | 8265.60 | yards | ||||
| Yards of Wool Required per Sweater | 4 | yards per sweater | ||||
| Raw Materials Cost per Yard of Wool | $ 3.50 | per yard | ||||
| Ending RM Inventory Requirement | 7% | of next months sweater production needs | ||||
| Wool Purchases Paid for in the Month of Purchase | 85% | |||||
| Wool Purchases Paid for in the Month following the Purchase | 15% | |||||
| Direct Labor | ||||||
| Number of Workers Required for the Making of Each Sweater | 5 | workers | ||||
| Labor Hours Required per Worker per Unit of FG (Sweater) | 0.5 | hours | ||||
| Labor Cost per Hour | $ 15.00 | per hour | ||||
| Manufacturing Overhead | ||||||
| Variable Manufacturing Overhead | $ 11.75 | per sweater | ||||
| Fixed Manufacturing Overhead | $ 30,200.00 | per month (Oct.) | $ 30,750.00 | per month (Nov. & beyond) | ||
| Noncash Fixed Manufacturing Overhead (included in above) | $ 10,250.00 | per month (Oct.) | $ 15,750.00 | per month (Nov. & beyond) | ||
| Selling & Administrative Expenses | ||||||
| Variable S&A | $ 7.37 | per unit sold | ||||
| Fixed S&A | $ 23,900.00 | per month | ||||
| Noncash Fixed S&A (included in above) | $ (10,750.00) | per month | ||||
| Factory Update & Cash Flow | ||||||
| Factory Update (PP&E) | $ 400,500.00 | paid on October 31, 2020 | ||||
| Principle Borrowed on October 1, 2020 | $ 300,000.00 | |||||
| Principle Repaid on November 30, 2020 | $ 300,000.00 | |||||
| Interest Payment on Borrowings in October & November | $ 9,000.00 |
per month (paid in following month) |
||||
Create a Schedule of Cash Collections in Excel using formulas only
In: Accounting
Headquartered in Toronto, Indigo Books & Music Inc. (TSX: IDG) is Canada’s largest book retailer and the third largest in North America. The following information was taken from the management discussion and analysis section of the company’s March 31, 2020, annual report (in thousands):
|
2020 |
2019 |
2018 |
|
|
Cost of sales (cost of goods sold) |
$600,400 |
$585,700 |
$538,500 |
|
Inventories |
$229,706 |
$232,694 |
$224,406 |
Additional information from the company’s annual report:
1. Inventories are valued at the lower of cost, determined using a moving average cost formula, and market, being net realizable value. Under this method, inventory is recorded at the level of the individual article (stock-keeping unit or SKU).
2. Costs include all direct and reasonable expenditures that are incurred in bringing inventories to their present location and condition. Vendor rebates are recorded as a reduction in the price of the products and corresponding inventory is recorded net of vendor rebates.
3. The average cost of an article is continually updated based on the cost of each purchase recorded in inventory. When the company permanently reduces the retail price of an item, there is a corresponding reduction in inventory recognized in the period if the markdown incurred brings the retail price below the cost of the item.
4. The amount of inventory write-downs as a result of net realizable value lower than cost was $10.3 million in 2020 ($7.3 million in fiscal 2019), and there were no reversals of inventory write-downs that were recognized in 2020 or in prior
periods. The amount of inventory at March 31, 2020 with net realizable value equal to cost was $1.7 million ($2.3 million at March 31, 2019).
(a) Calculate the company’s inventory turnover and days sales in inventory ratios for 2020 and 2019. Comment on whether Indigo’s management of its inventory improved or weakened in fiscal 2020.
|
Inventory Turnover |
Days Sales in Inventory |
|
|
2020 |
||
|
2019 |
(b) Does Indigo follow the lower of cost or net
realizable value rule? Did the application of this rule have any
effect on 2020 results? Explain
(c) Indigo uses the average cost formula to account for its
inventories. A major competitor, Amazon Inc., uses the FIFO cost
formula to account for its inventories. What difficulties would
this create in comparing Indigo’s financial results with those of
Amazon? Explain.
In: Accounting
Sheridan Inc. earns $470000 and pays cash dividends of $100000 during 2020. Carla Vista Corporation owns 62700 of the 209000 outstanding shares of Sheridan Inc. How much revenue from investment should Carla Vista report in 2020?
Sunland Inc. earns $550000 and pays cash dividends of $145000 during 2020. Wildhorse Corporation owns 73850 of the 211000 outstanding shares of Sunland. What amount should Wildhorse show in the investment account at December 31, 2020 if the beginning of the year balance in the account was $40000?
On January 2, Matthews Corporation acquired 20% of the outstanding common stock of Dennehy Company for $450,000. For the year ended December 31, Dennehy reported net income of $90,000 and paid cash dividends of $30,000 on its common stock. On December 31, the carrying value of Matthews’ investment in Dennehy under the equity method is
At December 31, 2020, the trading securities for Eddy Company are as follows:
Security Cost
Fair Value
A $16,000
$20,000
B 34,000
32,000
$50,000 $52,000
Prepare the adjusting entry at December 31, 2020, to report the securities at fair value. (Credit account titles are automatically indented when the amount is entered. Do not indent manually.)
CoronadoCorp. has common stock of $4600000, retained earnings of
$1600000, unrealized gains on trading securities of $120000 and
unrealized losses on available-for-sale securities of $180000. What
is the total amount of its stockholders’ equity?
On January 1, 2020, Sheffield Corp. paid $940000 for 117500
shares of Ivanhoe Company’s common stock, which represents 26% of
Ivanhoe's outstanding common stock. Ivanhoe reported net income of
$224000 and paid cash dividends of $63000 during 2020. Sheffield
should report the investment in Ivanhoe Company on its December 31,
2020, balance sheet at:
Which of the following is the correct matching concerning the appropriate accounting for long-term stock investments?
% of Investor Ownership Accounting
Guidelines
Coronado Corporation purchased 960 shares of Wildhorse common stock ($50 par) at $82 per share as a short-term investment. The shares were subsequently sold at $78 per share. The cost of the securities purchased and gain or loss on the sale were
Cost Gain or Loss
In: Accounting
Analyzing Accounts and Notes Receivable; Computing Interest, Estimating Value, and Recording Bad Debts
Analyze each of the four separate scenarios and answer the requirements.
Note: Round each of your answers to the nearest whole dollar.
1. On December 31, 2020, Helena Company, a California real estate firm, received two $28,000 notes from customers in exchange for services rendered. The 8% note from El Dorado Company is due in nine months, and the 3% note from Newcastle Company is due in five years. The market interest rate for similar notes on December 31, 2020, was 8%. At what amounts should the two notes be reported in Helena’s December 31, 2020, balance sheet?
| Note receivable, El Dorado Company | Answer |
| Note receivable, Newcastle Company | Answer |
2. EPPA, an environmental management firm, issued to Dara, a $14,000, 8%, five-year installment note that required five equal annual year-end payments. This note was discounted to yield a 9% rate to Dara. What is the total amount of interest revenue to be recognized by Dara on this note?
| Total interest revenue | Answer |
3. On July 1, 2020, Lezix Company, a maker of denim clothing, sold goods in exchange for a $140,000, one-year, noninterest-bearing note. At the time of the sale, the market rate of interest was 12% on similar notes. At what amount should Lezix record the note receivable on July 1, 2020?
| Note receivable | Answer |
4. The records of Quest Company included the following accounts (with normal balances).
| Cash sales | $1,680,000 |
| Credit sales | 1,260,000 |
| Balance in accounts receivable, December 31, 2019 | 252,000 |
| Balance in accounts receivable, December 31, 2020 | 280,000 |
| Balance in allowance for doubtful accounts, December 31, 2019 (Cr.) | 4,200 |
| Accounts written off as uncollectible during 2020 | 7,000 |
The company estimates bad debts as 2% of receivables at year-end to be uncollectible.
Prepare the adjusting entry at December 31, 2020, to adjust the allowance for doubtful accounts.
| Date | Account Name | Dr. | Cr. |
|---|---|---|---|
| Dec. 31, 2020 | Answer |
| Answer | Answer |
| Answer |
| Answer | Answer |
In: Accounting
| Spring 2020 Spreadsheet Project | ||||||
| Name: | ||||||
| Lexie's Wool Sweaters | ||||||
| Projected Budgeting Data | ||||||
| Sales & Collections | ||||||
|
October 2020 |
November 2020 |
December 2020 |
January 2021 |
February 2021 |
||
| Sales in Units (Sweaters) | 30,000 | 34,000 | 55,000 | 47,000 | 32,000 | |
| Selling Price per Sweater | $ 100.00 | |||||
| Cash Sales Collected in the Month of Sale | 30% | |||||
| Credit Sales Collected in the Month of Sale | 50% | |||||
| Credit Sales Collected in the Following Month | 20% | |||||
| Ending FG Inventory Requirement | 3% | of next months unit sweater sales | ||||
| Ending FG Inventory, September 30 , 2020 | 1,500 | sweaters | ||||
| Product Input Expenses | ||||||
| Direct Materials | ||||||
| Ending RM Inventory, September 30, 2020 | 8265.60 | yards | ||||
| Yards of Wool Required per Sweater | 4 | yards per sweater | ||||
| Raw Materials Cost per Yard of Wool | $ 3.50 | per yard | ||||
| Ending RM Inventory Requirement | 7% | of next months sweater production needs | ||||
| Wool Purchases Paid for in the Month of Purchase | 85% | |||||
| Wool Purchases Paid for in the Month following the Purchase | 15% | |||||
| Direct Labor | ||||||
| Number of Workers Required for the Making of Each Sweater | 5 | workers | ||||
| Labor Hours Required per Worker per Unit of FG (Sweater) | 0.5 | hours | ||||
| Labor Cost per Hour | $ 15.00 | per hour | ||||
| Manufacturing Overhead | ||||||
| Variable Manufacturing Overhead | $ 11.75 | per sweater | ||||
| Fixed Manufacturing Overhead | $ 30,200.00 | per month (Oct.) | $ 30,750.00 | per month (Nov. & beyond) | ||
| Noncash Fixed Manufacturing Overhead (included in above) | $ 10,250.00 | per month (Oct.) | $ 15,750.00 | per month (Nov. & beyond) | ||
| Selling & Administrative Expenses | ||||||
| Variable S&A | $ 7.37 | per unit sold | ||||
| Fixed S&A | $ 23,900.00 | per month | ||||
| Noncash Fixed S&A (included in above) | $ (10,750.00) | per month | ||||
| Factory Update & Cash Flow | ||||||
| Factory Update (PP&E) | $ 400,500.00 | paid on October 31, 2020 | ||||
| Principle Borrowed on October 1, 2020 | $ 300,000.00 | |||||
| Principle Repaid on November 30, 2020 | $ 300,000.00 | |||||
| Interest Payment on Borrowings in October & November | $ 9,000.00 | per month (paid in following month) | ||||
Create a Direct Labor Budget in Excel using Formulas only
In: Accounting
N =
I =
PV =
PMT =
FV =
P/Y =
In: Finance
In 2015, Yum! Brands, Inc., the world’s largest quick-service restaurant company (Pizza Hut, Kentucky Fried Chicken, and Taco Bell), opened 577 new Pizza Hut restaurants and closed 456 others.
Required
If you were in charge of these decisions, what information would you want to collect?
In: Accounting
A cylindrical tube of mean radius 1” and wall thickness 0.1” is subjected to an internal pressure p = 300 psi and a torque T = 2000 lb-in. The ends of the tube are closed. Find the safety factor against yielding if the material yields in uniaxial tension at SY = 8 ksi and Von Mises theory is used.
In: Mechanical Engineering
A mole of air is sampled from the atmosphere when the atmospheric pressure is 765 mmHg, the temperature is 25 C, an relative humidity is 75%. The sample of air is placed inside a closed container and heated to 135 C and then compressed to 2 atm. What are the relative humidity, the humidity, and the mole fraction of water in the compressed air?
In: Chemistry