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 6, Problem 3DQ
Summary Introduction
To explain: The determination of placement of primary keys in relational tables to link the primary keys of different tables together.
Introduction:
Relational database:
It is a collection of multiple data sets constituted by rows, columns, and tables. It aids in developing a well-established relationship between different database tables. Information is shared between these tables for efficient use.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please don't use Ai solution
ng
Equipment is worth $998,454. It is expected to produce regular cash flows of $78,377 per year for 20 years and a special cash flow of
$34,800 in 20 years. The cost of capital is X percent per year and the first regular cash flow will be produced in 1 year. What is X?
Input instructions: Input your answer as the number that appears before the percentage sign. For example, enter 9.86 for 9.86% (do
not enter .0986 or 9.86%). Round your answer to at least 2 decimal places.
percent
3 years ago, you invested $6,700. In 5 years, you expect to have $12,201. If you expect to earn the same annual return after 5 years from today as the annual return implied from the past and expected values given in the problem, then in how many years from today do you expect to have $25,254?
Chapter 6 Solutions
Accounting Information Systems
Ch. 6 - What is business intelligence (BI)?Ch. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - What is a relationship?Ch. 6 - Prob. 6RQCh. 6 - Prob. 7RQCh. 6 - Prob. 8RQCh. 6 - How can an REA model help an organization improve...Ch. 6 - Prob. 10RQ
Ch. 6 - Prob. 11RQCh. 6 - Prob. 12RQCh. 6 - What is a foreign key? How are foreign keys...Ch. 6 - Prob. 14RQCh. 6 - Prob. 15RQCh. 6 - Prob. 1DQCh. 6 - What is a model? How is modeling a database or...Ch. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Prob. 6DQCh. 6 - Although todays enterprise systems incorporate...Ch. 6 - Prob. 8DQCh. 6 - Prob. 1SPCh. 6 - Prob. 2SPCh. 6 - Examine Figure 6.18, which contains the REA model...Ch. 6 - Prob. 6SPCh. 6 - Prob. 7SPCh. 6 - What SQL command(s) would you use to add the date...Ch. 6 - Prob. 2P
Knowledge Booster
Similar questions
- 4 years ago, you invested $3,600. In 2 years, you expect to have $7,201. If you expect to earn the same annual return after 2 years from today as the annual return implied from the past and expected values given in the problem, then in how many years from today do you expect to have $10,022? Input instructions: Round your answer to at least 2 decimal places. yearsarrow_forwardSince ROE can sometimes be boosted artificially through financial leverage, do you think it would be more beneficial for investors to rely on a combination of ROE and other financial health indicators, such as the debt-to-equity ratio or interest coverage ratio, when assessing a stock's long-term potential?arrow_forwardGiven that Merck and Pfizer both face revenue risks from patent expirations, how do you think financial managers at these companies should adjust their capital structure to maintain stability and investor confidence?arrow_forward
- Don't used hand raiting and don't used Ai solutionarrow_forwardJohn works for a fixed income hedge fund. Your fund invests in $100 million in mortgage-backed-bonds (MBS) with a duration of 10. He finances these bonds with $2 million in investor capital and $98 million of overnight repurchase agreements (required haircut=2%) with an interest rate of 1%. After hours, negative news comes out on the evening news that increases yields on MBS by 25 basis points. Moreover, effective tomorrow, because of this bad news, repurchase agreement lenders will now require a haircut of 3% to lend to you via repurchase agreements with your MBS as collateral. Assuming he receives no interest payments from your MBS, how much cash does he need to not default on today’s repurchase agreement and to keep the position open for one more day tomorrow? Please provide calculations in excel.arrow_forward220 6-1. (Expected return and risk) Universal Corporation is planning to invest in a secu- LO1 LO2 rity that has several possible rates of return. Given the following probability distribu- tion of returns, what is the expected rate of return on the investment? Also, compute the standard deviations of the returns. What do the resulting numbers represent? PROBABILITY 0.10 0.20 0.30 RETURN -10% 5% 0.40 10% 25% 6-2. (Average expected return and risk) Given the holding-period returns shown here, calculate the average returns and the standard deviations for the Kaifu Corporation Myb and for the market. MONTH 1 2 3 KAIFU CORP. 4% 6% 0% 2% MARKET 2% 3% 1% -1% 6-3. (Expected rate of return and risk) Carter, Inc. is evaluating a security. Calculate the investment's expected return and its standard deviation. PROBABILITY 0.15 RETURN 6% 0.30 9% 0.40 10% 0.15 15% PART 2 The Valuation of Financial Assets 6-4. (Expected rate of return and risk) Summerville, Inc. is considering an investment in one of…arrow_forward
- 6-14. (Expected return, standard deviation, and capital asset pricing model) The following LO5 are the end-of-month prices for both the Standard & Poor's 500 Index and Nike's common stock. a. Using the data here, calculate the holding-period returns for each of the months. NIKE S&P 500 INDEX 2017 January $52.90 $2,279 February 57.16 2,364 March 55.73 2,363 April 55.41 2,384 May 52.99 2,412 June 59.00 2,423 July 59.05 2,470 August 52.81 2,472 September 51.85 2,519 October 54.99 2,575 November 60.42 2,648 December 62.55 2,674 2018 January 68.22 2,824 b. Calculate the average monthly return and the standard deviation for both the S&P 500 and Nike. 222 PART 2 • The Valuation of Financial Assets c. Develop a graph that shows the relationship between the Nike stock returns and the S&P 500 Index. (Show the Nike returns on the vertical axis and the S&P 500 Index returns on the horizontal axis as done in Figure 6-5.) d. From your graph, describe the nature of the relationship between Nike stock…arrow_forwardrequired rates of return for the three securities? 6-23. (Portfolio beta and security market line) You own a portfolio consisting of the ☑ stocks below: PERCENTAGE OF STOCK OR SECURITY PORTFOLIO BETA EXPECTED RETURN 1 20% 1.00 12% 2 30% 0.85 8% 3 15% 1.20 12% 25% 0.60 7% 5 10% 1.60 16% The risk-free rate is 3 percent. Also, the expected return on the market portfolio is 11 percent. a. Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns, where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta. c. Given the foregoing information, plot the security market line on paper. Plot the stocks from your portfolio on your graph. d. From your plot in part (c), which stocks appear to be your winners and which ones appear to be your losers? e. Why should you consider your conclusion in part (d) to be less than certain? 6-24. (Portfolio beta) Assume you…arrow_forwardWizzy Wigs is an unleveraged firm with $80 million in total assets, 2 million shares outstanding, and $15 million in EBIT. The shares price is $40, tax adjusted cost of debt 4.61%, and corporate tax rate of 21%. What are the returns on equity (ROEs) for the firm if it shifts to a 0.75 debt-to-equity ratio and for an individual with 700 shares who created homemade leverage at the same DE ratio? ◻ firm 25.61%; inv. 24.99% firm 18.24%; inv. 19.46% firm 38.59%; inv. 35.53% firm 23.19%; inv. 22.46% firm 30.07%; inv. 30.19% Please show work on excel spreadsheetarrow_forward
- You are running a hot Internet company. Analysts predict that its earnings will grow at 20% per year for the next 9 years. After that, as competition increases, earnings growth is expected to slow to 4% per year and continue at that level forever. Your company has just announced earnings of $4 million. What is the present value of all future earnings if the interest rate is 9%? (Assume all cash flows occur at the end of the year.) The present value of all future earnings is million. (Round to two decimal places.)arrow_forward3. Losses for an insurance company next year are estimated to be 100 million with standard deviation 250 million. Using lognormal and two-parameter Pareto distributions to obtain the VaR at the 95%, 97.5%, 99% security levels. Comment on your findings.arrow_forwardA company sold 4 million shares in its IPO, at a priceof $18.50 per share. Management negotiated a fee(the underwriting spread) of 7% on this transaction.What was the dollar cost of this fee?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub