Accounting Information Systems
11th Edition
ISBN: 9781337552127
Author: Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 7DQ
Summary Introduction
To explain: The problems that are solved by transforming from 2NF to 3NF.
Introduction:
Database management systems (DBMS):
It is computer software for creating and managing databases. The DBMS provides a way for the users to create, update, retrieve and manage the data present in the database. It also supports the administration and use of the database on different platforms.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Ch 26: Assignment - Mergers and Corporate Control
Widget Corp., which is considering the acquisition of Exteter Enterprise Inc., estimates that acquiring Exteter will result in an incremental value for the
firm. The analysts involved in the deal have collected the following information from the projected financial statements of the target company:
Data Collected (in millions of dollars)
Year 1
Year 2
Year 3
EBIT
$13.0
$15.6
$19.5
Interest expense
5.0
5.5
6.0
Debt
35.2
41.6
44.8
Total net operating capital
107.1
109.2
111.3
Exteter Enterprise Inc. is a publicly traded company, and its market-determined pre-merger beta is 1.00. You also have the following information
about the company and the projected statements:
•Exteter currently has a $38.00 million market value of equity and $24.70 million in debt.
The risk-free rate is 3.5%, there is a 5.60% market risk premium, and the Capital Asset Pricing Model produces a pre-merger
required rate of return on equity ISL of 9.10%.
•Exteter's cost…
3. Problem 30-03 (Plan Funding)
Plan Funding
eBook
Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations:
Year
11-15
16-20
21-25
Annual Total Payment
$3,480,000
2,980,000
26-30
31-35
2,480,000
1,980,000
1,480,000
The current value of the firm's pension fund is $5.6 million. Assume that all cash flows occur at year-end.
a. Consolidated's expected return on pension assets is 11%, and it uses 11% to discount the expected pension benefit payments. What is the present value of the firm's pension fund benefits? Do not round
intermediate calculations. Round your answer to the nearest dollar.
$
b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places.
Funding ratio=
which means the assets are select than the PV of benefits and the plan is
select
Less or greater
Select
underfunded
overfunded
Plan Funding
Consolidated Industries is planning to operate for 10 more years and then cease operations. At that time (in 10 years), it expects to have the following pension benefit obligations:
Year
11-15
16-20
21-25
Annual Total Payment
$3,500,000
3,000,000
2,500,000
26-30
31-35
2,000,000
1,500,000
The current value of the firm's pension fund is $6.1 million. Assume that all cash flows occur at year-end.
a. Consolidated's expected return on pension assets is 12%, and it uses 12% to discount the expected pension benefit payments. What is the present value of the firm's pension fund
benefits? Do not round intermediate calculations. Round your answer to the nearest dollar.
$
b. Is the plan underfunded or overfunded? Do not round intermediate calculations. Round your answer to two decimal places.
Funding ratio =
which means the assets are -Select- than the PV of benefits and the plan is -Select- ☑.
Less or Greater
Overfunded or Underfunded
Chapter 5 Solutions
Accounting Information Systems
Ch. 5 - Prob. 1RQCh. 5 - Prob. 2RQCh. 5 - Prob. 3RQCh. 5 - What are the most important limitations of the...Ch. 5 - Prob. 5RQCh. 5 - Prob. 6RQCh. 5 - Prob. 7RQCh. 5 - Prob. 8RQCh. 5 - Prob. 9RQCh. 5 - Prob. 10RQ
Ch. 5 - Prob. 11RQCh. 5 - Prob. 12RQCh. 5 - Prob. 13RQCh. 5 - What is a partial dependency?Ch. 5 - Prob. 15RQCh. 5 - Prob. 16RQCh. 5 - Prob. 17RQCh. 5 - What factors distinguish DSS from EIS?Ch. 5 - Describe the basic differences between ES and NN.Ch. 5 - What role do intelligent agents play in the...Ch. 5 - Why have knowledge management systems become so...Ch. 5 - Prob. 22RQCh. 5 - Prob. 23RQCh. 5 - Prob. 1DQCh. 5 - How has the technological availability and...Ch. 5 - Prob. 3DQCh. 5 - Prob. 4DQCh. 5 - What are the differences between a logical view...Ch. 5 - Prob. 6DQCh. 5 - Prob. 7DQCh. 5 - Prob. 8DQCh. 5 - Prob. 9DQCh. 5 - Prob. 10DQCh. 5 - Prob. 11DQCh. 5 - Prob. 12DQCh. 5 - Prob. 1SPCh. 5 - Prob. 2SPCh. 5 - Prob. 7PCh. 5 - Prob. 12PCh. 5 - Use the Internet to research knowledge management...
Knowledge Booster
Similar questions
- Benefits and Contributions The Certainty Company (CC) operates in a world of certainty. It has just hired Mr. Jones, age 27, who will retire at age 65, draw retirement benefits for 14 years, and die at age 79. Mr. Jones' salary is $21,000 per year, but wages are expected to increase at the 6% annual rate of inflation. CC has a defined benefit plan in which workers receive 1% of the final year's wage for each year employed. The retirement benefit, once started, does not have a cost-of-living adjustment. CC earns 12% annually on its pension fund assets and uses a 10% rate to discount its expected future benefit payments. Assume that pension contribution and benefit cash flows occur at year-end. Do not round intermediate calculations. Round your answers to the nearest dollar. a. How much will Mr. Jones receive in annual retirement benefits? $ b. What is CC's required annual contribution to fully fund Mr. Jones' retirement benefits? $ c. Assume now that CC hires Mr. Smith at the same…arrow_forwardlab.infoseclearning.com/console/5061763/3047 310-win10 Project Three Milestone - GNS3 File Edit View Control Node Annotate Tools Help e 41 Sales_PC1 0000 Sales_PC2 Sales_PC3 Enforce US Keyboard Layout View Fullscreen Send Ctrl+Alt+Delete Reboot To exit full screen, press and hold esc ■C00/6@ Q Sales_Switch Human Resources_Switch Office_Router Sales PC4 Customer_Service_Switch X: -299.0 Y: -136.0 Z: 1.0 H Type here to search CS_FTP_Server HR_PC2 HR_PC1 7:19 PM 12/14/2024 Barrow_forwardAGG is a US multinational that manufactures specialist high tech parts in the airline engine industry. AGG is an established company with steady growth in turnover and dividends over the last 10 years. The company is undertaking a projected titled Project Big as a strategic response to the changing market scene. AGG will develop a new state of the art highly automated plant located in Cambodia which is expected to result in cost advantages if it is implemented. The details about the project are below • Initital investment has been estimated at $500m • • The annual pre tax savings in operating costs at current exchange rates has been calculated at $150m for the first four years (starting in the first year) The residual value of the project at the end of the four years is estimated to be $250m The initial investment, net of residual value, qualifies for capital allowance and can be claimed back on a straight line basis over the four years of the project. Current AGG's cost of capital is…arrow_forward
- You have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or provide how to do the calculations in Excel. Explain why there is a difference between the present value of the Strayer lottery jackpot and the future value of the twenty-six annual payments based on your calculations and the information provided.arrow_forwardYou have just won the Strayer Lottery jackpot of $11,000,000. You will be paid in twenty-six equal annual installments beginning immediately. If you had the money now, you could invest it in an account with a quoted annual interest rate of 9% with monthly compounding of interest. Calculate the present value of the payments you will receive. Show your calculations using formulas in your paper or in an attached spreadsheet file.arrow_forwardThe approach uses a weighted average cost of capital that is unique to a particular project while determining the appropriate discount rate.arrow_forward
- An all-equity firm faces a risk-free rate of 4%, a beta of 2, and a market risk premium of 6%. What is its cost of capital? Multiple choice question. 18% 12% 14% 16%arrow_forwardcreated or destroyed. uses the weighted average cost of capital to determine if value is beingarrow_forwardUnder the subjective approach for project evaluation, all proposed projects are placed into several Blank______ categories. Multiple choice question. risk cost revenue returnarrow_forward
- Using the WACC as the discount rate for future cash flows is appropriate only when the proposed investment is Blank______ the firm's existing activities. Multiple choice question. riskier than different from less risky than similar toarrow_forwardSuppose a project has a cost of $20 million and expected cash flows of 10 million per year for two years. If the WACC is 10%, what is the NPV of this project? Multiple choice question. $17.4 million –$2.6 million $2.6 million 0 millionarrow_forwardAlpha Corporation consists of two divisions, X and Y. Division X is riskier than Division Y. If Alpha Corporation uses the firm's overall weighted average cost of capital to evaluate both divisions' projects, which division(s) will tend to be awarded greater funds for investment? Multiple choice question. Only division X Neither division Both divisions Only division Yarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,