Questions
“I know headquarters wants us to add that new product line,” said Dell Havasi, manager of...

“I know headquarters wants us to add that new product line,” said Dell Havasi, manager of Billings Company’s Office Products Division. “But I want to see the numbers before I make any move. Our division’s return on investment (ROI) has led the company for three years, and I don’t want any letdown.”

Billings Company is a decentralized wholesaler with five autonomous divisions. The divisions are evaluated on the basis of ROI, with year-end bonuses given to the divisional managers who have the highest ROIs. Operating results for the company’s Office Products Division for this year are given below:

Sales $ 22,045,000
Variable expenses 13,882,000
Contribution margin 8,163,000
Fixed expenses 6,070,000
Net operating income $ 2,093,000
Divisional average operating assets $ 5,500,000

The company had an overall return on investment (ROI) of 16.00% this year (considering all divisions). Next year the Office Products Division has an opportunity to add a new product line that would require an additional investment that would increase average operating assets by $2,501,500. The cost and revenue characteristics of the new product line per year would be:

Sales $9,500,000
Variable expenses 65% of sales
Fixed expenses $2,574,100

Required:

1. Compute the Office Products Division’s ROI for this year.

2. Compute the Office Products Division’s ROI for the new product line by itself.

3. Compute the Office Products Division’s ROI for next year assuming that it performs the same as this year and adds the new product line.

4. If you were in Dell Havasi’s position, would you accept or reject the new product line?

5. Why do you suppose headquarters is anxious for the Office Products Division to add the new product line?

6. Suppose that the company’s minimum required rate of return on operating assets is 13% and that performance is evaluated using residual income.

a. Compute the Office Products Division’s residual income for this year.

b. Compute the Office Products Division’s residual income for the new product line by itself.

c. Compute the Office Products Division’s residual income for next year assuming that it performs the same as this year and adds the new product line.

d. Using the residual income approach, if you were in Dell Havasi’s position, would you accept or reject the new product line?

In: Accounting

Bridger Company currently has the capacity to manufacture 250,000 widgets a year. The widgets normally sell...

Bridger Company currently has the capacity to manufacture 250,000 widgets a year. The widgets normally sell for $8.00 each.

Bridger Company has the following costs related to manufacturing and selling 200,000 widgets:

Direct materials $300,000
Direct labor $540,000
Variable manufacturing overhead $180,000
Depreciation on equipment only used for the widgets $40,000
Depreciation on factory $100,000
Salary of widget production manager $70,000
Variable selling costs (commissions) $60,000
Fixed selling costs $80,000
Total $1,370,000


Assume Minot Inc. asks Bridger to complete a manufacture a special order of 10,000 widgets. Minot is willing to pay $5.50 per widget (and the sales commission will apply on this special order).

By how much will Bridger's income change if they accept the special order?

a.

$4,000 increase

b.

$1,000 increase

c.

$13,500 decrease

d.

$1,000 decrease

e.

$25,000 decrease

In: Accounting

Mr. Bailey has approached you regarding an opportunity he has to become a homeowner.  Mr. Bailey has...

Mr. Bailey has approached you regarding an opportunity he has to become a homeowner.  Mr. Bailey has asked you to perform a financial analysis to determine if this would be a wise move to purchase the new condominium, or if he should continue to rent.  You will create an Excel spreadsheet and a written Word document to explain the results for Mr. Bailey.  

Currently he rents a downtown condominium for $2500 per month. A neighboring unit has recently gone onto the market for $500,000. Mr. Bailey feels that this would make a great investment for him and it would make sense to stop renting and purchase this unit. Mr. Bailey can put down 20% on the new unit. He will assume a 30-year mortgage for the condominium with a 6% APR. Mr. Bailey plans to remain in the condominium for 5 years and then sell and move to suburban Berkshire Farms.

Financial Details
If Mr. Bailey purchases the condo, he will have additional monthly fees of:

$1000 HOA fee (maintenance, pool, health club)
$300 property taxes
$100 repairs

You have reviewed real estate trends and have determined that over 5 years the condo will appreciate approximately 3% per year. When he sells the condo, you estimate that he will pay 5% in commission and an additional $2,000 in closing costs.


Excel Spreadsheet:

  1. Mortgage payment with costs to Buy versus Rent (Sheet 1)
  2. Amortization Schedule for the mortgage (Sheet 2)
  3. Present value of the proceeds if he were to sell the property in 5 years (Sheet 3)

Word Document:

In a professional 3- 5 page written analysis explain the results of your findings for Mr. Bailey. Provide a detailed written explanation of your calculations for the present value of the proceeds if he were to sell the property in 5 years. In addition, provide an explanation of the importance of the time value of money and the key decisions to be made in this buy versus rent decision. You should also include qualitative decisions to consider in this scenario for Mr. Bailey (e.g. what are some factors which influence this buy versus rent decision which should be considered).

In: Accounting

The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton...

The Grilton Tire Company manufactures racing tires for bicycles. Grilton sells tires for $50 each. Grilton is planning for next year by developing a master budget by quarters. Grifton’s balance sheet for December 31, 2016 follows:

GRILTON TIRE COMPANY

Balance Sheet

December 31, 2016

Assets

Current Assets:

  Cash                                                                                           $  39,000

  Accounts Receivable                                                                   40,000

  Raw Materials Inventory                                                              2,400

  Finished Goods Inventory                                                            8,700

  Total Current Assets                                                                                               $  90,100

Property, Plant and Equipment:

  Equipment                                                                                 177,000

  Less: Accumulated Depreciation                                            (42,000)                135,000

Total Assets                                                                                                               $225,100

Liabilities

Current Liabilities:

  Accounts Payable                                                                                                  $  8,000

Stockholder’s Equity

Common Stock, no par                                                           $ 130,000

Retained Earnings                                                                         87,100

  Total Stockholder’s Equity                                                                                  217,100

Total Liabilities and Stockholder’s Equity                                                          $225,100

Other data for Grilton Tire Company:

  1. Budgeted Sales are 1,500 for the first quarter and expected to increase by 200 tires per quarter. Cash Sales are expected to be 30% of total sales, with the remaining 70% of sales on account.
  2. Finished Goods Inventory on December 31, 2016 consists of 300 tires at $29 each.
  3. Desired ending Finished Goods Inventory is 40% of the next quarter’s sales; first quarter sales for 2018 are expected to be 2,300 tires and second quarter sales for 2018 are expected to be 2,500.  FIFO inventory costing method is used.
  4. Direct Materials cost is $8 per tire.
  5. Desired ending Finished Goods Inventory is 30% of the next quarter’s direct materials needed for production.
  6. Each tire requires 0.40 hours of direct labor; direct labor costs average $16 per hour.
  7. Variable manufacturing overhead is $2 per tire produced.
  8. Fixed manufacturing overhead includes $4,500 per quarter in depreciation and $26,780 per quarter for other costs, such as utilities, insurance, and property taxes.
  9. Fixed selling and administrative expenses include $8,000 per quarter for salaries; $1,800 per quarter for rent; $1,200 per quarter for insurance; and $500 per quarter for depreciation.
  10. Variable selling and administrative expenses include supplies at 2% of sales.
  11. Capital expenditures include $45,000 for new manufacturing equipment, to be purchased and paid in the first quarter.
  12. Cash receipts for sales on account are 60% in the quarter of sale and 40% in the quarter following the sale; December 31, 2016, Accounts Receivable is received in the first quarter of 2017.
  13. Direct materials purchases are paid 70% in the quarter purchased and 30% in the following quarter; December 31, 2016, Accounts Payable is paid in the first quarter of 2017.
  14. Direct labor, manufacturing overhead, and selling and administrative costs are paid in the quarter incurred.
  15. Income tax expense is projected at $3,500 per quarter and is paid in the quarter incurred.
  16. Grilton desires to maintain a minimum cash balance of $35,000 and borrows from the local bank as needed in increments of $1,000 at the beginning of the quarter; principal repayments are made at the beginning of the quarter when excess funds are available and in increments of $1,000; interest is 6% per year and paid at the beginning of the quarter based on the amount outstanding from the previous quarter.

REQUIREMENTS:

  1. Prepare a schedule of expected cash disbursements for purchases of  materials for each quarter and in total of the year 2017. (5 pts.)
  2. Prepare a budgeted Schedule of Cost of Goods Manufactured for the year of 2017. (10 pts.)
  3. Prepare a budgeted Income Statement for the year of 2017    (10 pts.)
  4. Prepare a cash budget for the year of 2017.   (15 pts.
  5. Essay:  What types of information do your budgets yield? Is cash flow adequate?  Do sales need to be increased, costs reduced? Etc….. ( 5 pts.)

10.Neatness and completeness (5 pts)

Please do number 1,2,3,4,5

In: Accounting

TEL Company provided the following account balances on December 31, 2019: Accounts receivable 400,000.00 Advances to...

TEL Company provided the following account balances on December 31, 2019:

Accounts receivable
400,000.00

Advances to officers-not-currently collectible
100,000.00

Sinking fund
400,000.00

Building
5,000,000.00

Long-term refundable deposit
50,000.00

Cash and cash equivalents
500,000.00

Cash surrender value
60,000.00

Equipment
1,000,000.00

Lease rights
100,000.00

Accrued interest on notes receivable
10,000.00

Inventories
1,300,000.00

Land
1,500,000.00

Land held for speculation
500,000.00

Notes receivable
250,000.00

Computer software
3,250,000.00

Prepaid expenses
70,000.00

Trading securities
280,000.00

Unearned rent income
40,000.00

Retained earnings (deficit)
(1,800,000.00)

Share premium – preference
500,000.00

Premium on bonds payable
1,000,000.00

Preference share capital
2,000,000.00

Share premium – ordinary
200,000.00

Notes payable
300,000.00

SSS payable
10,000.00

Accounts payable
400,000.00

Accrued salaries
100,000.00

Accumulated depreciation – building
2,000,000.00

Accumulated depreciation – equipment
200,000.00

Allowance for doubtful accounts
20,000.00

Bonds payable
5,000,000.00

Dividends payable
120,000.00

Ordinary share capital
5,000,000.00

Withholding tax payable
30,000.00

Preference share redemption fund
350,000.00

Required: A detail "NOTES" and financial position on December 31, 2019.

In: Accounting

Exercise 14-29 Reporting bonds at fair value [LO14-6] Federal Semiconductors issued 12% bonds, dated January 1,...

Exercise 14-29 Reporting bonds at fair value [LO14-6]

Federal Semiconductors issued 12% bonds, dated January 1, with a face amount of $840 million on January 1, 2018. The bonds sold for $780,588,787 and mature on December 31, 2037 (20 years). For bonds of similar risk and maturity the market yield was 13%. Interest is paid semiannually on June 30 and December 31. Federal determines interest at the effective rate. Federal elected the option to report these bonds at their fair value. On December 31, 2018, the fair value of the bonds was $760 million as determined by their market value in the over-the-counter market. Assume the fair value of the bonds on December 31, 2019 had risen to $766 million.

Required:

Complete the below table to record the following journal entries.
1. & 2. Prepare the journal entry to adjust the bonds to their fair value for presentation in the December 31, 2018, balance sheet, and adjust the bonds to their fair value for presentation in the December 31, 2019, balance sheet. Federal determined that one-half of the increase in fair value was due to a decline in general interest rates.

  • Calculation
  • General Journal

Complete the below table to record the following journal entries. (Negative amount should be indicated by a minus sign. Round final answers to the nearest whole dollars.)

Semiannual Interest Period-End Cash Interest Paid Bond Interest Expense Increase in Balance Carrying Value Fair Value Unrealized Holding Gain (loss)
01/01/2018 $780,588,787
06/30/2018 $50,400,000 $50,738,271 $338,271 780,927,058
12/31/2018 50,400,000 50,760,259 360,259 781,287,317 $760,000,000 $21,287,317
06/30/2019 50,400,000 0 0
12/31/2019 0 0 0 $766,000,000
Bonds Payable Fair Value Adjustment Net Liability(FMV)
01/01/2018 780,588,787 01/01/2018
06/30/2018 338,271 06/30/2018
12/31/2018 360,259 12/31/2018 $21,287,317
781,287,317 21,287,317 $760,000,000
06/30/2019 06/30/2019
12/31/2019 12/31/2019 (21,287,317)
781,287,317
  • Calculation
  • Journal entry worksheet

  • Record the interest expense.
  • Note: Enter debits before credits.

    Date General Journal Debit Credit
    June 30, 2018
  • Record the interest expense.
  • Note: Enter debits before credits.

    Date General Journal Debit Credit
    December 31, 2018
  • Record the fair value adjustment.

Note: Enter debits before credits.

Date General Journal Debit Credit
December 31, 2018
  • Record the interest expense.

Note: Enter debits before credits.

Date General Journal Debit Credit
June 30, 2019
  • Record the interest expense.

Note: Enter debits before credits.

Date General Journal Debit Credit
December 31, 2019
  • Federal determined that one-half of the increase in fair value was due to a decline in general interest rates.

Note: Enter debits before credits.

Date General Journal Debit Credit
December 31, 2019

In: Accounting

Cornhusker Company provides the following information at the end of 2018.    Cash remaining $ 2,900...

Cornhusker Company provides the following information at the end of 2018.   

Cash remaining $ 2,900
Rent expense for the year 5,100
Land that has been purchased 21,000
Retained earnings 10,500
Utility expense for the year 3,000
Accounts receivable from customers 5,300
Service revenue earned during the year 27,500
Salary expense for the year 11,400
Accounts payable to suppliers 1,250
Dividends paid to shareholders during the year 1,300
Common stock that has been issued prior to 2018 16,000
Salaries owed at the end of the year 1,450
Insurance expense for the year 1,600

No common stock is issued during 2018, and the balance of retained earnings at the beginning of 2018 equals $5,400.

Required:

1. Prepare the income statement for Cornhusker Company on December 31, 2018.

2. Prepare the statement of stockholders’ equity for Cornhusker Company on December 31, 2018.
  


3. Prepare the balance sheet for Cornhusker Company on December 31, 2018.

In: Accounting

1.Boris Corporation issued 25,000 shares of $10 par value common stock at $30 per share. As...

1.Boris Corporation issued 25,000 shares of $10 par value common stock at $30 per share. As a result of this transaction, Boris Corporation’s: A. Paid in Capital in Excess of Par Value increased by $250,000 B. Paid in Capital in Excess of Par Value increased by $750,000 C. Common Stock increased by $250,000 D. Common Stock increased by $750,000

2.Karin, Inc. has 5,000 shares of 6%, $200 par value, cumulative preferred stock and 100,000 shares of $2 par value common stock outstanding. There were no dividends declared in 2015. The board of directors declared and paid dividends of $100,000 each in 2016 and 2017.

What is the amount of dividends received by the common stockholders in 2017?

A.

$80,000

B.

$40,000

C.

$20,000

D.

$60,000

                

3.

The stockholders equity section of Prancer Company showed the following:

Common Stock--$20 par value, 60,000 shares issued and outstanding

$1,200,000

Contributed Capital in excess of par value, common stock

3,600,000

Retained Earnings

3,200,000


Prancer declared a 10% stock dividend on a day when the market value of the stock was $60 per share. The stock dividend will:

A.

Increase Common Stock by $360,000

B.

Decrease Retained Earnings by $240,000

C.

Increase Paid-in capital in excess of par value, Common Stock by $240,000

D.

Increase Paid-in capital in excess of par value, Common Stock by $360,000

4.

Stockholders' equity represents the current market value of a company.

True

False

5.

The cumulative feature on preferred stock means that regular dividends to preferred stockholders omitted in past years must be paid in addition to the current year's dividend before any dividend distribution may be made to common stockholders.

True

False

6.

A statement of retained earnings will disclose the amount of net income (or loss) for the accounting period.

True

False

In: Accounting

The following situations should be considered independently. (FV of $1, PV of $1, FVA of $1,...

The following situations should be considered independently. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) 1. John Jamison wants to accumulate $63,968 for a down payment on a small business. He will invest $32,000 today in a bank account paying 8% interest compounded annually. Approximately how long will it take John to reach his goal? 2. The Jasmine Tea Company purchased merchandise from a supplier for $32,802. Payment was a noninterest-bearing note requiring Jasmine to make five annual payments of $8,000 beginning one year from the date of purchase. What is the interest rate implicit in this agreement? 3. Sam Robinson borrowed $14,000 from a friend and promised to pay the loan in 12 equal annual installments beginning one year from the date of the loan. Sam’s friend would like to be reimbursed for the time value of money at a 9% annual rate. What is the annual payment Sam must make to pay back his friend?

In: Accounting

Revenues $300,000 Less operating expenses: Rent $169,000 Insurance 15,000 Depreciation 46,000 Maintenance 20,000 250,000 Net operating...

Revenues

$300,000

Less operating expenses:

Rent

$169,000

Insurance

15,000

Depreciation

46,000

Maintenance

20,000

250,000

Net operating income

$   50,000

1. A company has estimated the annual revenues and expenses for a project it is considering (listed above) that will cost a total of $500,000, have a ten-year useful life, and has a salvage value of $40,000. The company requires a payback period of 5 years or less.

  1. Using the information above, what is the expected annual cash flow for this company? ______________
  2. What is the payback period?    __________________________
    Would the company consider this project?   ______________
  3. What is the internal rate of return to the nearest percent?   _______________
  4. What is the simple rate of return promised by the project? _____________________________
    If the company requires a simple rate of return of at least 10%, will the games be purchased?    __________

Please show work

In: Accounting

Item1 Item1 Item 1 As a newly hired management accountant, you have been asked to prepare...

Item1

Item1

Item 1

As a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you’ve been asked to do some what-if analyses. Following is the budgeted information regarding the coming year:

Selling price per unit $ 100.00
Variable cost per unit 70.00
Fixed costs (per year) 1,200,000

Required:

1. What is the breakeven volume, in units and dollars, for the coming year?

2. Assume that the goal of the company is to earn a pretax (operating) profit of $300,000 for the coming year. How many units would the company have to sell to achieve this goal?

3. Assume that of the $70 variable cost per unit the labor-cost component is $25. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is 4% higher than anticipated? What if labor costs are 6% higher than anticipated? What if labor costs turn out to be 8% higher than anticipated?

4. Assume now that management is convinced that labor costs will be 5% higher than originally planned when the budget for the year was put together. What selling price per unit must the company charge to maintain the budgeted ratio of contribution margin to sales? (Hint: Use the Goal Seek function in Excel to answer this question.)

  • equired 1
  • Required 2
  • Required 3
  • Required 4

What is the breakeven volume, in units and dollars, for the coming year?

Break-even volume (units)
Break-even volume (dollars)

Assume that the goal of the company is to earn a pretax (operating) profit of $300,000 for the coming year. How many units would the company have to sell to achieve this goal?

Required sales volume units

Assume that of the $70 variable cost per unit the labor-cost component is $25. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is 4% higher than anticipated? What if labor costs are 6% higher than anticipated? What if labor costs turn out to be 8% higher than anticipated? (Round "Per Unit" and "% Change in Breakeven Point" answers to 2 decimal places and other answers to the nearest whoie number.)

Show less

Situation % Change in $25 DL cost Component (given) Revised Variable Cost per Unit Revised Contribution Margin per Unit Breakeven volume (units) Unit Change in Breakeven Point % Change in Breakeven Point
Baseline 0.00 % %
1 4.00 % %
2 6.00 % %
3 8.00 % %

Assume now that management is convinced that labor costs will be 5% higher than originally planned when the budget for the year was put together. What selling price per unit must the company charge to maintain the budgeted ratio of contribution margin to sales? (Round your answer to 2 decimal places.) (Hint: Use the Goal Seek function in Excel to answer this question.)

Selling price per unit

In: Accounting

In Chapter 7, we discussed the differences between preventive, detective, and corrective controls. Chapters 8-10 offer...

In Chapter 7, we discussed the differences between preventive, detective, and corrective controls. Chapters 8-10 offer specific types of controls within those categories over information security, confidentiality, privacy, processing integrity, and availability.

Think about controls that you have encountered in your own life (personal, professional, within organizational memberships, etc.). Note that at the time, you may or may not have realized that the answer to “why is this done?” was that a control was being implemented: a control over operations, reporting, and/or compliance.

  1. Provide a specific example of a preventive control that you have encountered. Describe what it was and its purpose (i.e., describe the specific organizational objective within one of the three categories that it was implemented to protect – note the category and describe in the context of the situation). As part of the description, note whether it was a control over information security, confidentiality, privacy, processing integrity, availability and/or something else. Explain.

In: Accounting

Hutto Corp. has set the following standard direct materials and direct labor costs per unit for...

Hutto Corp. has set the following standard direct materials and direct labor costs per unit for the product it manufactures.

Direct materials (14 lbs. @ $4 per lb.) $56
Direct labor (3 hrs. @ $16 per hr.) 48


During May the company incurred the following actual costs to produce 8,100 units.

Direct materials (116,300 lbs. @ $3.80 per lb.) $ 441,940
Direct labor (28,900 hrs. @ $16.10 per hr.). 465,290


AQ = Actual Quantity
SQ = Standard Quantity
AP = Actual Price
SP = Standard Price

AH = Actual Hours
SH = Standard Hours
AR = Actual Rate
SR = Standard Rate

(2) Compute the direct labor rate variance and the direct labor efficiency variance. Indicate whether each variance is favorable or unfavorable.

In: Accounting

Oerstman, Inc., uses a standard costing system and develops its overhead rates from the current annual...

Oerstman, Inc., uses a standard costing system and develops its overhead rates from the current annual budget. The budget is based on an expected annual output of 125,000 units requiring 500,000 direct labor hours. (Practical capacity is 520,000 hours.) Annual budgeted overhead costs total $815,000, of which $580,000 is fixed overhead. A total of 119,200 units using 498,000 direct labor hours were produced during the year. Actual variable overhead costs for the year were $261,300, and actual fixed overhead costs were $556,150.

1. Compute the fixed overhead spending and volume variances.

Fixed Overhead Spending Variance $
Fixed Overhead Volume Variance $

2. Compute the variable overhead spending and efficiency variances. Do not round intermediate calculations

Variable Overhead Spending Variance $
Variable Overhead Efficiency Variance $

In: Accounting

Carlsville Company, which began operations in 2017, invests its idle cash in trading securities. The following...

Carlsville Company, which began operations in 2017, invests its idle cash in trading securities. The following transactions are from its short-term investments in trading securities.

2017

Jan. 20 Purchased 1,000 shares of Ford Motor Co. at $28 per share plus a $120 commission.
Feb. 9 Purchased 2,300 shares of Lucent at $31 per share plus a $200 commission.
Oct. 12 Purchased 800 shares of Z-Seven at $7.60 per share plus a $100 commission.
Dec. 31 Fair value of the short-term investments in trading securities is $111,400.



2018

Apr. 15 Sold 1,000 shares of Ford Motor Co. at $30 per share less a $295 commission.
July 5 Sold 800 shares of Z-Seven at $11.00 per share less a $95 commission.
July 22 Purchased 1,700 shares of Hunt Corp. at $35 per share plus a $225 commission.
Aug. 19 Purchased 1,900 shares of Donna Karan at $44.80 per share plus a $100 commission.
Dec. 31 Fair value of the short-term investments in trading securities is $213,185.



2019

Feb. 27 Purchased 4,000 shares of HCA at $35 per share plus a $440 commission.
Mar. 3 Sold 1,700 shares of Hunt at $30 per share less a $120 commission.
June 21 Sold 2,300 shares of Lucent at $28.75 per share less a $42 commission.
June 30 Purchased 1,200 shares of Black & Decker at $47.50 per share plus a $595 commission.
Nov. 1 Sold 1,900 shares of Donna Karan at $44.80 per share less a $119 commission.
Dec. 31 Fair value of the short-term investments in trading securities is $204,100.


Required:
Prepare journal entries to record these short-term investment activities for the years shown. On December 31 of each year, prepare the adjusting entry to record any necessary fair value adjustment for the portfolio of trading securities. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Do not round your intermediate calculations.)

In: Accounting