Replace Equipment

A machine with a book value of $247,000 has an estimated six-year life. A proposal is offered to sell the old machine for $215,600 and replace it with a new machine at a cost of $283,600. The new machine has a six-year life with no residual value. The new machine would reduce annual direct labor costs from $49,600 to $39,700.

Prepare a differential analysis dated February 18, on whether to continue with the old machine (Alternative 1) or replace the old machine (Alternative 2). If an amount is zero, enter zero "0". Use a minus sign to indicate a loss.

Should the company continue with the old machine (Alternative 1) or replace the old machine (Alternative 2)?

Phillips Company bought 40 percent ownership in Jones Bag Company on January 1, 20X1, at underlying book value. During the period of January 1, 20X1, through December 31, 20X3, the market value of Phillips' investment in Jones' stock increased by $2,000 each year. In 20X1, 20X2, and 20X3, Jones Bag reported the following:

The balance in Phillips Company’s investment account on December 31, 20X3, was $54,000.

Required:
In each of the following independent cases, determine the amount that Phillips paid for its investment in Jones Bag stock assuming that Phillips accounted for its investment by carrying the investment at fair value, or using the equity method.
  

Using fixed asset disclosure to compare companies'/Fixed asset turnover and average age of depreciable assets

The following PP & E information for fiscal year 2017 is available:

Required:

1. Estimate the total useful life, age and remaining useful life for each company.
2. Interpret the estimates. What items might effect comparisons across these companies
3. Calculate and compare fixed asset turnover for each company

or the following exercise, complete the calculations below. Evaluate different capital investment appraisal techniques by completing the calculations shown below: Bongo Ltd. is considering the selection of one of two mutually exclusive projects. Both would involve purchasing machinery with an estimated useful life of 5 years. Project 1 would generate annual cash flows (receipts less payments) of £200,000; the machinery would cost £556,000 with a scrap value of £56,000. Project 2 would generate cash flows of £500,000 per annum; the machinery would cost £1,616,000 with a scrap value of £301,000. Bongo uses straight-line depreciation. Its cost of capital is 15% per annum. Assume that all cash flows arise on the anniversaries of the initial outlay, that there are no price changes over the project lives, and that accepting either project will have no impact on working capital requirements. Assess the choice using the following methods by completing the calculations shown below: ARR NPV IRR Payback period Calculate the missing answers: Project 1 Project 2 ARR (see workings) 33% ??? NPV (£’000) ??? 210 IRR 25% ??? Payback Period (yrs) ??? 3.2 ARR workings (Project 1) Cash flows 200 Less: depreciation (see below) 100 Accounting profits 100 These profits are the same each year in this question. Annual depreciation (Cost – SV) / 5 (556,000 – 56,000) / 5 100 Average NBV of investments (556 + 56) /2 306 ARR

Cash Payback Period, Net Present Value Method, and Analysis

Elite Apparel Inc. is considering two investment projects. The estimated net cash flows from each project are as follows:

Each project requires an investment of $317,000. A rate of 12% has been selected for the net present value analysis.

Required:

1a. Compute the cash payback period for each project.

1b. Compute the net present value. Use the present value of $1 table above. If required, round to the nearest dollar.

A 5-year annuity of ten $4500 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. If the discount rate is 12% compounded monthly, what is the value of this annuity five years from now? What is the value three years from now? What is the current value of the annuity?

I have calculate the PVa at t=9 is 73073.68, but I don't know how to do the next steps...

Please explain as clearly as possible

Thanks!!

The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also.

Additional information from the accounting records:

1. A building that originally cost $116,000, and which was three-fourths depreciated, was sold for $24,000.
2. The common stock of Byrd Corporation was purchased for $24,000 as a long-term investment.
3. Property was acquired by issuing a 10%, seven-year, $74,000 note payable to the seller.
4. New equipment was purchased for $34,000 cash.
5. On January 1, 2018, bonds were sold at their $44,000 face value.
6. On January 19, Dux issued a 4% stock dividend (1,000 shares). The market price of the $10 par value common stock was $13 per share at that time.
7. Cash dividends of $68,000 were paid to shareholders.
8. On November 54,000 shares of common stock were repurchased as treasury stock at a cost of $27,000.

Required:
Prepare the statement of cash flows for Dux Company using the indirect method. (Do not round intermediate calculations. Amounts to be deducted should be indicated with a minus sign. Enter your answers in thousands. (i.e., 10,000 should be entered as 10).))

Problem 4-2 Discontinued operations [LO4-4]

The following condensed income statements of the Jackson Holding Company are presented for the two years ended December 31, 2018 and 2017:

On October 15, 2018, Jackson entered into a tentative agreement to sell the assets of one of its divisions. The division qualifies as a component of an entity as defined by GAAP. The division was sold on December 31, 2018, for $5,090,000. Book value of the division’s assets was $4,460,000. The division’s contribution to Jackson’s operating income before-tax for each year was as follows:

Assume an income tax rate of 20%.

Required: (In each case, net any gain or loss on sale of division with annual income or loss from the division and show the tax effect on a separate line)
1. Prepare revised income statements according to generally accepted accounting principles, beginning with income from continuing operations before income taxes. Ignore EPS disclosures.
2. Assume that by December 31, 2018, the division had not yet been sold but was considered held for sale. The fair value of the division’s assets on December 31 was $5,090,000. Prepare revised income statements according to generally accepted accounting principles, beginning with income from continuing operations before income taxes. Ignore EPS disclosures.
3. Assume that by December 31, 2018, the division had not yet been sold but was considered held for sale. The fair value of the division’s assets on December 31 was $3,930,000. Prepare revised income statements according to generally accepted accounting principles, beginning with income from continuing operations before income taxes. Ignore EPS disclosures.

Whispering Winds Manufacturing has an annual capacity of 80,400 units per year. Currently, the company is making and selling 78,100 units a year. The normal sales price is $106 per unit, variable costs are $70 per unit, and total fixed expenses are $2,000,000. An out-of-state distributor has offered to buy 5,600 units at $75 per unit. Whispering Winds's cost structure should not change as a result of this special order. By how much will Whispering Winds's income change if the company accepts this order?

Whispering Winds’ net income will(increase/decrease) by $ if it accepts the special order?

    1) A corporation has three investment centers with the following data:

Compute the ROI in two parts for each division.   Compute the residual income for each division.                                                                                                                         Assume each division is presented with an investment opportunity that yields a return on investment of 8%.                                                                                                                                                      

A) If performance is measured by ROI, which division(s) would probably accept the offer? Reject?                                                                                                                     B) If performance is measured by residual income, which division(s) would probably accept the offer? Reject?

2) A corporation has a segment, Division A that sells a part on the outside market for $120. Its costs, based on a unit capacity of 200,000 units, are $25 variable and $45 fixed. The company has a related segment, Division B that could use the part in its own assembly operations. Division B buys the part from another supplier for $112, and it will need 40,000 units.

Required: 1) Assume division A is selling 140,000 units to outside customers.

1. From the standpoint of Division A, what is the lowest acceptable transfer price for units sold to Division B?
2. From the standpoint of Division B, what is the highest acceptable transfer price for units purchased from Division A.
3. If left to bargain freely, would you expect the division managers to voluntarily agree on a transfer of units from Division A to Division B? Give reasons.
4. From the standpoint of the entire company, should the transfer take place? Give reasons.

2) Now assume Division A is selling all its capacity to outside customers. Answer a through d under this new condition.

“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:

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:

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?

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:

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?

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).

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.
1. 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.
50. 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.
1000. 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

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.