Internal Rate of Return Method—Two Projects
Munch N’ Crunch Snack Company is considering two possible investments: a delivery truck or a bagging machine. The delivery truck would cost $48,601.8 and could be used to deliver an additional 54,000 bags of pretzels per year. Each bag of pretzels can be sold for a contribution margin of $0.38. The delivery truck operating expenses, excluding depreciation, are $0.52 per mile for 18,000 miles per year. The bagging machine would replace an old bagging machine, and its net investment cost would be $46,248.75. The new machine would require three fewer hours of direct labor per day. Direct labor is $15 per hour. There are 250 operating days in the year. Both the truck and the bagging machine are estimated to have six-year lives. The minimum rate of return is 11%. However, Munch N’ Crunch has funds to invest in only one of the projects.
| Present Value of an Annuity of $1 at Compound Interest | |||||
| Year | 6% | 10% | 12% | 15% | 20% |
| 1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
| 2 | 1.833 | 1.736 | 1.690 | 1.626 | 1.528 |
| 3 | 2.673 | 2.487 | 2.402 | 2.283 | 2.106 |
| 4 | 3.465 | 3.170 | 3.037 | 2.855 | 2.589 |
| 5 | 4.212 | 3.791 | 3.605 | 3.352 | 2.991 |
| 6 | 4.917 | 4.355 | 4.111 | 3.784 | 3.326 |
| 7 | 5.582 | 4.868 | 4.564 | 4.160 | 3.605 |
| 8 | 6.210 | 5.335 | 4.968 | 4.487 | 3.837 |
| 9 | 6.802 | 5.759 | 5.328 | 4.772 | 4.031 |
| 10 | 7.360 | 6.145 | 5.650 | 5.019 | 4.192 |
a. Compute the internal rate of return for each investment. Use the above table of present value of an annuity of $1. If required, round your present value factor answers to three decimal places and internal rate of return to the nearest percent.
| Delivery Truck | Bagging Machine | |
| Present value factor | ||
| Internal rate of return | % | % |
b. The bagging machine rate of return was less than the minimum rate of return requirement of 11% while the delivery truck rate of return was greater than the minimum rate of return requirement of 11%. Therefore the recommendation is to invest in the delivery truck .
In: Accounting
Following is information on two alternative investments being
considered by Jolee Company. The company requires a 10% return from
its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1)
(Use appropriate factor(s) from the tables
provided.)
| Project A | Project B | |||||||||
| Initial investment | $ | (184,325 | ) | $ | (156,960 | ) | ||||
| Expected net cash flows in year: | ||||||||||
| 1 | 54,000 | 31,000 | ||||||||
| 2 | 49,000 | 54,000 | ||||||||
| 3 | 85,295 | 51,000 | ||||||||
| 4 | 81,400 | 70,000 | ||||||||
| 5 | 54,000 | 29,000 | ||||||||
a. For each alternative project compute the net
present value.
b. For each alternative project compute the
profitability index. If the company can only select one project,
which should it choose?
In: Accounting
Usefulness of income statement and cash flow statement for the invsetors
In: Accounting
Define organizational culture, observable culture, and core culture
In: Accounting
The following is an actual headline that was recently reported in the media about the New Zealand company Sky TV:
“Sky TV’s profit dropped 20.9 per cent in the year to the end of June. The pay TV company released its full-year results today, which showed a net profit of more than $116.3 million, down from $147.1 million the previous year.”
(a). Discuss the key findings of the Ball and Brown (1968) study and explain how the above earnings announcement might affect Sky TV’s share price.
In: Accounting
What if Leaders Institute appointed a Chief Communications Manager (CCM) who will be responsible for identifying, developing and monitoring all the communication channels within the organisation? Please provide detailed answer on this question. 1000 word essay
In: Accounting
Part 2: Cameron Company is interested in establishing the relationship between utility costs and machine hours. Data has been collected and a regression analysis prepared using Excel. The monthly data and the regression output follow:
| Month | MACHINE HOURS | ELECTRICITY COSTS |
| JAN | 3250 | 22080 |
| FEB | 3770 | 25200 |
| MAR | 2470 | 16200 |
| APR | 4030 | 27600 |
| MAY | 4940 | 33900 |
| JUN | 4290 | 26400 |
| JUL | 5330 | 29700 |
| AUG | 4550 | 27300 |
| SEP | 2600 | 18600 |
| OCT | 4810 | 31200 |
| NOV | 6110 | 37200 |
| DEC | 5460 | 33300 |
Required:
a. Using Excel, perform a regression analysis on the above data and
generate a summary output.
b. What is the equation for utility costs using the regression analysis?
c. Prepare an estimate of utility costs for a month when 3,000 machine hours are worked.
In: Accounting
Developing accounting standards is challenging and requires coordinated efforts among various parties to successfully execute. If you were given complete authority in this matter, how would you propose that GAAP should be developed and enforced? What process would you put in place to protect all parties that are impacted?
In: Accounting
Required information Problem 21-3A Flexible budget preparation; computation of materials, labor, and overhead variances; and overhead variance report LO P1, P2, P3, C2 [The following information applies to the questions displayed below.] Antuan Company set the following standard costs for one unit of its product. Direct materials (6 Ibs. @ $5 per Ib.) $ 30 Direct labor (2 hrs. @ $17 per hr.) 34 Overhead (2 hrs. @ $18.50 per hr.) 37 Total standard cost $ 101 The predetermined overhead rate ($18.50 per direct labor hour) is based on an expected volume of 75% of the factory’s capacity of 20,000 units per month. Following are the company’s budgeted overhead costs per month at the 75% capacity level. Overhead Budget (75% Capacity) Variable overhead costs Indirect materials $ 45,000 Indirect labor 180,000 Power 45,000 Repairs and maintenance 90,000 Total variable overhead costs $ 360,000 Fixed overhead costs Depreciation—Building 24,000 Depreciation—Machinery 80,000 Taxes and insurance 12,000 Supervision 79,000 Total fixed overhead costs 195,000 Total overhead costs $ 555,000 The company incurred the following actual costs when it operated at 75% of capacity in October. Direct materials (91,000 Ibs. @ $5.10 per lb.) $ 464,100 Direct labor (30,500 hrs. @ $17.25 per hr.) 526,125 Overhead costs Indirect materials $ 44,250 Indirect labor 177,750 Power 43,000 Repairs and maintenance 96,000 Depreciation—Building 24,000 Depreciation—Machinery 75,000 Taxes and insurance 11,500 Supervision 89,000 560,500 Total costs $ 1,550,725 Problem 21-3A Part 1&2 Required: 1&2. Prepare flexible overhead budgets for October showing the amounts of each variable and fixed cost at the 65%, 75%, and 85% capacity levels and classify all items listed in the fixed budget as variable or fixed.
In: Accounting
The production supervisor of the Machining Department for Niland Company agreed to the following monthly static budget for the upcoming year:
| Niland Company Machining Department Monthly Production Budget |
|
| Wages | $867,000 |
| Utilities | 52,000 |
| Depreciation | 87,000 |
| Total | $1,006,000 |
The actual amount spent and the actual units produced in the first three months in the Machining Department were as follows:
| Amount Spent | Units Produced | |||
| January | $948,000 | 106,000 | ||
| February | 910,000 | 97,000 | ||
| March | 864,000 | 87,000 | ||
The Machining Department supervisor has been very pleased with this performance because actual expenditures for January–March have been significantly less than the monthly static budget of 1,006,000. However, the plant manager believes that the budget should not remain fixed for every month but should “flex” or adjust to the volume of work that is produced in the Machining Department. Additional budget information for the Machining Department is as follows:
| Wages per hour | $15 |
| Utility cost per direct labor hour | $0.9 |
| Direct labor hours per unit | 0.5 |
| Planned monthly unit production | 116,000 |
a. Prepare a flexible budget for the actual units produced for January, February, and March in the Machining Department. Assume depreciation is a fixed cost. If required, use per unit amounts carried out to two decimal places.
| Niland Company | |||
| Machining Department Budget | |||
| For the Three Months Ending March 31 | |||
| January | February | March | |
| Units of production | 106,000 | 97,000 | 87,000 |
| Wages | $ | $ | $ |
| Utilities | |||
| Depreciation | |||
| Total | $ | $ | $ |
| Supporting calculations: | |||
| Units of production | 106,000 | 97,000 | 87,000 |
| Hours per unit | x | x | x |
| Total hours of production | |||
| Wages per hour | x $ | x $ | x $ |
| Total wages | $ | $ | $ |
| Total hours of production | |||
| Utility costs per hour | x $ | x $ | x $ |
| Total utilities | $ | $ | $ |
b. Compare the flexible budget with the actual expenditures for the first three months.
| January | February | March | |
| Total flexible budget | $ | $ | $ |
| Actual cost | |||
| Excess of actual cost over budget | $ | $ | $ |
What does this comparison suggest?
| The Machining Department has performed better than originally thought. | Yes/No? |
| The department is spending more than would be expected. | Yes/No? |
Please show work for each step.
In: Accounting
Why deferrals are reported in government financial statements separately?
In: Accounting
Tami Tyler opened Tami’s Creations, Inc., a small manufacturing company, at the beginning of the year. Getting the company through its first quarter of operations placed a considerable strain on Ms. Tyler’s personal finances. The following income statement for the first quarter was prepared by a friend who has just completed a course in managerial accounting at State University.
|
Tami’s Creations, Inc. Income Statement For the Quarter Ended March 31 |
||||||
| Sales (28,500 units) | $ | 1,140,000 | ||||
| Variable expenses: | ||||||
| Variable cost of goods sold | $ | 427,500 | ||||
| Variable selling and administrative | 196,650 | 624,150 | ||||
| Contribution margin | 515,850 | |||||
| Fixed expenses: | ||||||
| Fixed manufacturing overhead | 283,500 | |||||
| Fixed selling and administrative | 245,850 | 529,350 | ||||
| Net operating loss | $ | ( 13,500) | ||||
Ms. Tyler is discouraged over the loss shown for the quarter, particularly because she had planned to use the statement as support for a bank loan. Another friend, a CPA, insists that the company should be using absorption costing rather than variable costing and argues that if absorption costing had been used the company probably would have reported at least some profit for the quarter.
At this point, Ms. Tyler is manufacturing only one product—a swimsuit. Production and cost data relating to the swimsuit for the first quarter follow:
| Units produced | 31,500 | |||
| Units sold | 28,500 | |||
| Variable costs per unit: | ||||
| Direct materials | $ | 7.20 | ||
| Direct labor | $ | 6.10 | ||
| Variable manufacturing overhead | $ | 1.70 | ||
| Variable selling and administrative | $ | 6.90 | ||
Required:
1. Complete the following:
a. Compute the unit product cost under absorption costing.
b. What is the company’s absorption costing net operating income (loss) for the quarter?
c. Reconcile the variable and absorption costing net operating income (loss) figures.
3. During the second quarter of operations, the company again produced 31,500 units but sold 34,500 units. (Assume no change in total fixed costs.)
a. What is the company’s variable costing net operating income (loss) for the second quarter?
b. What is the company’s absorption costing net operating income (loss) for the second quarter?
c. Reconcile the variable costing and absorption costing net operating incomes for the second quarter.
In: Accounting
You oversee the $250 petty cash for your company. When an employee needs a special item that is not in inventory, you take money from petty cash to purchase that item.
One day, you are short on cash for lunch. You decide to borrow $10 each day for the next 3 days until payday for a total of $30 from petty cash. After payday, you do not have enough to repay petty cash, so you decide to record a cash short/over expense of $30.
Since this is the first time you have ever done this, is this a problem? If so, what steps should be taken to fix this problem? If not, why not?
In: Accounting
Define in own words
CHAPTER 5 – Accounting Systems
In: Accounting
Baltic Limited is a listed company based in California. On January 1, 2019, the company granted 10,000 share units to its vice president. Each share unit has a contractual service period of five years and a vesting condition based on market performance.
Each share unit is convertible into ordinary shares of Baltic Limited as follows:
On the grant date, the company’s ordinary shares have a fair value of $10 per share.
Management believes the probability of the above scenarios occurring are 40% and 60%, and uses this information to calculate the fair value of the share unit award.
The company’s accountant has asked for your help to calculate compensation costs for these share units so that the appropriate journal entry can be recorded in 2019.
Ignore the effects of taxes.
Provide the journal entries and calculations to answer this question.
In: Accounting