Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows:
Decreased waste | $300,000 |
Increased quality | 400,000 |
Decrease in operating costs | 600,000 |
Increase in on-time deliveries | 200,000 |
The system will cost $9,000,000 and last 10 years. The company’s cost of capital is 12 percent.
The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems.
Required:
1. Calculate the payback period for the
system.
years
Assume that the company has a policy of only accepting projects
with a payback of five years or less. Would the system be
acquired?
No
2. Calculate the NPV and IRR for the project. Round your IRR answers to the nearest whole percentage value (for example, 15.6% rounds to 16% and should be entered as "16" in the answer box). If the NPV is negative, enter your answer as a negative value.
NPV: | $ | ||||
IRR: | Between | % | and | % |
Should the system be purchased—even if it does not meet the
payback criterion?
Yes
3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of $1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of $300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Round your IRR answers to the nearest whole percentage value (for example, 15.6% rounds to 16% and should be entered as "16" in the answer box). If the NPV is negative, enter your answer as a negative value.
Payback period: | years | ||||
NPV: | $ | ||||
IRR: | Between | % | and | % |
Does the decision change?
Yes
Suppose that the salvage value is only half what is projected.
Does this make a difference in the outcome? Does the salvage value
have any real bearing on the company's decision?
No - in this case the decrease in salvage value is not enough to
change the decision
In: Accounting
The following problem is an example of typical transactions that a not-for-profit college or university might have. Use the information in the FASB Accounting Standards Codification to help you answer the requirements of the problem.
Beatty College, a not-for-profit college, engaged in the following transactions during its fiscal year ending June 30, 2015.
Requirements: Prepare appropriate journal entries, indicating the types of funds (by restrictiveness) in which they would be recorded.
Transactions:
1. In May 2015 Beatty College collected $100,000,000 in student tuition. Of this amount $10,000,000 was applicable to the summer semester, which ran from June1 to August 30, 2015, and $1,000,000 was applicable to the fall semester that began September, 2015.
2. Beatty College received a contribution of $1,000,000 in stocks and bonds to establish an endowed chair in accounting. Income from the chair endowment must be used to supplement the salary of a professor accounting.
3. During 2015, the accounting chair endowment earned interest and dividends of $50,000 all of which was used to supplement the salary of the chair of the accounting department. (Note: a. record the investment earnings and b. record cash paid for the chair’s salary.) Use the same $50,000 for both entries.
4. The fair value of the investment of the accounting chair endowment declined by $80,000.
5. Using funds restricted for this purpose, the college purchased $150,000 of equipment for the college athletics department.
6. Beatty College recorded depreciation of $30,000.
7. The annual alumni campaign yielded $1,800,000 in pledges. The college estimated that 2% would be uncollectible. During the year, Beatty college collected $1,500,000 on the pledges.
In: Accounting
wite a paper on the cost of quality in a medical device company.
In: Accounting
Net Present Value Method, Present Value Index, and Analysis
United Bankshores, Inc. wishes to evaluate three capital investment proposals by using the net present value method. Relevant data related to the proposals are summarized as follows:
Branch Office Expansion |
Computer System Upgrade |
Install Internet Bill-Pay |
|||||
Amount to be invested | $837,326 | $465,641 | $258,271 | ||||
Annual net cash flows: | |||||||
Year 1 | 320,000 | 218,000 | 141,000 | ||||
Year 2 | 298,000 | 196,000 | 97,000 | ||||
Year 3 | 272,000 | 174,000 | 71,000 |
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1. Assuming that the desired rate of return is 6%, prepare a net present value analysis for each proposal. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value. If required, round to the nearest dollar.
Branch Office Expansion | Computer System Upgrade | Install Internet Bill-Pay | |
Present value of net cash flow total | $ | $ | $ |
Amount to be invested | $ | $ | $ |
Net present value | $ | $ | $ |
2. Determine a present value index for each proposal. If required, round your answers to two decimal places.
Present Value Index | |
Branch Office Expansion | |
Computer System Upgrade | |
Install Internet Bill-Pay |
In: Accounting
Average Rate of Return Method, Net Present Value Method, and Analysis
The capital investment committee of Cross Continent Trucking Inc. is considering two capital investments. The estimated income from operations and net cash flows from each investment are as follows:
Warehouse | Tracking Technology | |||||||||
Year | Income from Operations |
Net Cash Flow |
Income from Operations |
Net Cash Flow |
||||||
1 | $24,000 | $77,000 | $50,000 | $123,000 | ||||||
2 | 24,000 | 77,000 | 38,000 | 104,000 | ||||||
3 | 24,000 | 77,000 | 19,000 | 73,000 | ||||||
4 | 24,000 | 77,000 | 8,000 | 50,000 | ||||||
5 | 24,000 | 77,000 | 5,000 | 35,000 | ||||||
Total | $120,000 | $385,000 | $120,000 | $385,000 |
Each project requires an investment of $400,000. Straight-line depreciation will be used, and no residual value is expected. The committee has selected a rate of 12% for purposes of the net present value analysis.
Present Value of $1 at Compound Interest | |||||
Year | 6% | 10% | 12% | 15% | 20% |
1 | 0.943 | 0.909 | 0.893 | 0.870 | 0.833 |
2 | 0.890 | 0.826 | 0.797 | 0.756 | 0.694 |
3 | 0.840 | 0.751 | 0.712 | 0.658 | 0.579 |
4 | 0.792 | 0.683 | 0.636 | 0.572 | 0.482 |
5 | 0.747 | 0.621 | 0.567 | 0.497 | 0.402 |
6 | 0.705 | 0.564 | 0.507 | 0.432 | 0.335 |
7 | 0.665 | 0.513 | 0.452 | 0.376 | 0.279 |
8 | 0.627 | 0.467 | 0.404 | 0.327 | 0.233 |
9 | 0.592 | 0.424 | 0.361 | 0.284 | 0.194 |
10 | 0.558 | 0.386 | 0.322 | 0.247 | 0.162 |
Required:
1a. Compute the average rate of return for each investment. If required, round your answer to one decimal place.
Average Rate of Return | |
Warehouse | % |
Tracking Technology | % |
1b. Compute the net present value for each investment. Use the present value of $1 table above. If required, use the minus sign to indicate a negative net present value.
Warehouse | Tracking Technology | ||
Present value of net cash flow total | $ | $ | |
Less amount to be invested | $ | $ | |
Net present value |
In: Accounting
Develop and use accounting information for daily recording of business financial transactions in a manufacturing environment, and construct and use operational budgets for a manufacturing company
In: Accounting
Feather Friends, Inc., distributes a high-quality wooden birdhouse that sells for $120 per unit. Variable expenses are $60.00 per unit, and fixed expenses total $200,000 per year. Its operating results for last year were as follows:
Sales $ 3,360,000
Variable expenses 1,680,000
Contribution margin 1,680,000
Fixed expenses 200,000
Net operating income $ 1,480,000
Required: Answer each question independently based on the original data:
1. What is the product's CM ratio? 2. Use the CM ratio to determine the break-even point in dollar sales. 3. If this year's sales increase by $51,000 and fixed expenses do not change, how much will net operating income increase? 4-a. What is the degree of operating leverage based on last year's sales? 4-b. Assume the president expects this year's sales to increase by 15%. Using the degree of operating leverage from last year, what percentage increase in net operating income will the company realize this year? 5. The sales manager is convinced that a 11% reduction in the selling price, combined with a $60,000 increase in advertising, would increase this year's unit sales by 25%. a. If the sales manager is right, what would be this year's net operating income if his ideas are implemented? b. If the sales manager's ideas are implemented, how much will net operating income increase or decrease over last year? 6. The president does not want to change the selling price. Instead, he wants to increase the sales commission by $1.70 per unit. He thinks that this move, combined with some increase in advertising, would increase this year's sales by 25%. How much could the president increase this year's advertising expense and still earn the same $1,480,000 net operating income as last year?
In: Accounting
Below are several transactions for Meyers Corporation for 2021.
Required:
For each transaction, determine the amount of cash flows. If cash is involved in the transaction, indicate whether Meyers should classify it as operating, investing, or financing in a statement of cash flows. (Enter N/A if the question is not applicable to the statement. List cash outflows as negative amounts.)
Calculate net cash flows for the year. (List cash outflows as negative amounts.)
Assuming the balance of cash on January 1, 2021, equals $4,300, calculate the balance of cash on December 31, 2021.
In: Accounting
Prepare journal entries for a local government to record the following transactions, first for fund financial statements and then for government-wide financial statements.
The government sells $992,000 in bonds at face value to finance construction of a warehouse.
A $1.14 million contract is signed for construction of the warehouse. The commitment is required if allowed.
A $164,000 transfer of unrestricted funds was made for the eventual payment of the debt in (a).
Equipment for the fire department is received with a cost of $15,240. When it was ordered, an anticipated cost of $14,600 had been recorded.
Supplies to be used in the schools are bought for $4,200 cash. The consumption method is used.
A state grant of $109,250 is awarded to supplement police salaries. The money will be paid to reimburse the government after the supplement payments have been made to the police officers.
Property tax assessments are mailed to citizens of the government. The total assessment is $648,000, although officials anticipate that 4 percent will never be collected. There is an enforceable legal claim for this money and the government can use it immediately.
In: Accounting
How to obtain acquisition date book value and fair value in excess of book value
In: Accounting
Comprehensive Master (Operating) Budget
Bee Gee Distributors, a wholesale company, is considering whether to open a new distribution center near Bowling Green, Ohio. The center would open January 1, 2020. The economic outlook is reasonable, but extensive advance planning is required if such a commitment is to be made. As a part of the planning process, The Board of Directors requires a Master (i.e. Operating) Budgetfor the center’s first quarter of operations(i.e. January, February & March of 2020). In order to prepare anybudget, management must make reasonable assumptions about expected sales, inventory levels and cash flows.
Required: Your help is needed to construct the entire first quarter Master Budget based upon the following two pages of management assumptions:
SALES BUDGET: “What is the Profit Plan?”
** It all starts with a sales forecast **
a. January sales are estimated to be $400,000 of which $100,000 (25%) will be cash and $300,000 will be on credit. Management expects the above sales pattern to continue with an overall grow rate of 10% per month. Prepare a sales budget.
b. The company expects to collect 100% of the accounts receivable in the month following the month of the sale. Prepare a schedule of expected cash receipts.
c. Use the information developed above in requirements a and bto determine the amount of accounts receivable on the March 31 pro forma balance sheet and the amount of sales on the first quarter pro forma income statement.
_____________________________________________________________________
PURCHASES BUDGET: “What are our total needs, less what do we have”?
d. Cost of goods sold will be 60% of sales. Company policy is to budget an ending inventory balance equal to 25% of the next month’s projected cost of goods sold. Prepare an inventory purchases budget.
Note: For March analysis needs, Aprilcost of goods sold is expected to be $314,000.
In: Accounting
Vertical Analysis of Income Statement
The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Motor Speedways Inc., owner and operator of several major motor speedways.
Current Year | Previous Year | |||||||
Revenues: | ||||||||
Admissions | $89,870 | $102,690 | ||||||
Event-related revenue | 145,684 | 147,189 | ||||||
NASCAR broadcasting revenue | 170,753 | 161,859 | ||||||
Other operating revenue | 66,693 | 77,262 | ||||||
Total revenues | $473,000 | $489,000 | ||||||
Expenses and other: | ||||||||
Direct expense of events | $97,911 | $97,800 | ||||||
NASCAR purse and sanction fees | 116,358 | 117,849 | ||||||
Other direct expenses | 16,082 | 21,027 | ||||||
General and administrative | 187,308 | 221,028 | ||||||
Total expenses and other | $417,659 | $457,704 | ||||||
Income from continuing operations | $55,341 | $31,296 |
a. Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Enter all amounts as positive numbers. (Note: Due to rounding, amounts may not total 100%).
Round your percentages to one decimal place. Due to rounding differences, you will need to:
Motor Speedways Inc. | ||||
Comparative Income Statement (in thousands of dollars) | ||||
For the Years Ended December 31 | ||||
Current Year Amount | Current Year Percent | Prior Year Amount | Prior Year Percent | |
Revenues: | ||||
Admissions | $89,870 | % | $102,690 | % |
Event-related revenue | 145,684 | % | 147,189 | % |
NASCAR broadcasting revenue | 170,753 | % | 161,859 | % |
Other operating revenue | 66,693 | % | 77,262 | % |
Total revenues | $473,000 | % | $489,000 | % |
Expenses and other: | ||||
Direct expense of events | $97,911 | % | $97,800 | % |
NASCAR purse and sanction fees | 116,358 | % | 117,849 | % |
Other direct expenses | 16,082 | % | 21,027 | % |
General and administrative | 187,308 | % | 221,028 | % |
Total expenses and other | $417,659 | % | $457,704 | % |
Income from continuing operations | $55,341 | % | $31,296 | % |
b. While overall revenue some between the two years, the overall mix of revenue sources did change somewhat. The NASCAR broadcasting revenue as a percent of total revenue by 3 percentage points, while the percent of admissions revenue to total revenue by 2 percentage points. Overall, it appears that income from continuing operations has significantly improved because of .
In: Accounting
In Shavertown, Pennsylvania, the owner of Wilkes-Barre Bookkeeping LLC was indicted for embezzling over $375,000 of his clients’ payroll tax remittances between 2010 and 2016 and for lying to clients about his actions. Additionally, he embezzled nearly $70,000 from a nonprofit for which he was the treasurer. He was sentenced to 38 months in prison and ordered to pay restitution totaling nearly $500,000.
In: Accounting
Problem 20-4A Manufacturing: Preparation of a complete master budget LO P1, P2, P3
The management of Zigby Manufacturing prepared the following
estimated balance sheet for March 2017:
ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 |
|||||||
Assets | |||||||
Cash | $ | 80,000 | |||||
Accounts receivable | 364,000 | ||||||
Raw materials inventory | 96,000 | ||||||
Finished goods inventory | 364,800 | ||||||
Total current assets | 904,800 | ||||||
Equipment, gross | 610,000 | ||||||
Accumulated depreciation | (155,000 | ) | |||||
Equipment, net | 455,000 | ||||||
Total assets | $ | 1,359,800 | |||||
Liabilities and Equity | |||||||
Accounts payable | $ | 195,500 | |||||
Short-term notes payable | 17,000 | ||||||
Total current liabilities | 212,500 | ||||||
Long-term note payable | 510,000 | ||||||
Total liabilities | 722,500 | ||||||
Common stock | 340,000 | ||||||
Retained earnings | 297,300 | ||||||
Total stockholders’ equity | 637,300 | ||||||
Total liabilities and equity | $ | 1,359,800 | |||||
To prepare a master budget for April, May, and June of 2017,
management gathers the following information:
Required:
Prepare the following budgets and other financial information as
required. All budgets and other financial information should be
prepared for the second calendar quarter, except as otherwise noted
below. (Round calculations up to the nearest whole dollar, except
for the amount of cash sales, which should be rounded down to the
nearest whole dollar.):
1. Sales budget.
2. Production budget.
3. Raw materials budget.
4. Direct labor budget.
5. Factory overhead budget.
6. Selling expense budget.
7. General and administrative expense budget.
8. Cash budget.
9. Budgeted income statement for the entire second quarter (not for
each month separately).
10. Budgeted balance sheet.
In: Accounting
Determination of whether a legal entity is a variable interest entity Assume a Legal Entity's capital structure consists of the following accounts: Short-term note payable $60,000 Long-term note payable 21,000 Mandatorily redeemable preferred stock 85,000 Common stock 30,000 Additional paid-in capital 60,000 Retained earnings 20,000 Total liabilities and equity $276,000 Note that FASB ASC 480 ("Distinguishing Liabilities from Equity") requires mandatorily redeemable preferred stock to be classified as a liability for financial reporting purposes. Unless otherwise indicated, each of the following parts of this question is independent: a. What is the maximum amount of expected losses that the Legal Entity can expect to sustain without being considered a variable interest entity (VIE)? $276,000 $131,000 $195,000 $110,000 b. What is the maximum amount of expected losses that the Legal Entity can expect to sustain if the lender of the long term note payable is the sole shareholder of the Legal Entity? $131,000 $276,000 $110,000 $195,000 c. What is the maximum amount of expected losses that the Legal Entity can expect to sustain if the long term note payable is convertible to common equity at the option of the holder of the note? Why? (Note that FASB ASC 470-20 ("Debt with Conversion and Other Features") requires convertible debt to be classified as a liability for financial reporting purposes.) $110,000 $195,000 $131,000 $276,000
In: Accounting