![Bundle: Accounting Information Systems, Loose-Leaf Version, 11th + MindTap Accounting, 1 term (6 months) Printed Access Card](https://www.bartleby.com/isbn_cover_images/9781337587297/9781337587297_largeCoverImage.gif)
1)
To determine: The control plan for the given system failure.
Introduction:
1)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Company W ordered 30 circuit breakers from Company E and received only 25. Other 5 circuit breakers were on the backorder at Company E. However, an invoice was received for 30 circuit breakers and paid fully.
Determine the control plan for the given system failure:
Match invoice, PO, and receiving report: Matching invoice with Purchase Order (PO) and the receiving report helps the firm to avoid the invoices for the goods which were not ordered or received.
2)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
2)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Company T usually does not receive invoices and record invoices in a timely manner for payment discounts.
Determine the control plan for the given system failure:
Tickler file of open POs and receiving reports: Tickler files are an electronic or manual area where the documents, which need follow-up will be stored. It will help the firm to follow up the vendors who have not sent invoices.
3)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
3)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Person N is a cashier at Company S who has been writing checks to herself and no one detected for years.
Determine the control plan for the given system failure:
Reconcile bank account: Reconcile bank account helps to make sure that the payments made by the bank are accurate and authorized.
4)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
4)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
At Company E, some of the incoming invoices are not matched against receiving reports and PO. Person J would prepare a PO to cover the invoice if he cannot find a PO for the incoming invoices.
Determine the control plan for the given system failure:
Segregate duties among purchasing, receiving, and accounts payable: The duties of the purchasing and receiving department, and accounts payable should be segregated.
5)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
5)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
The company I receive vendor invoices once each day as batches from the Value-Added Network (VAN) through EDI feed. However, some of the invoices are from the fake vendors.
Determine the control plan for the given system failure:
Compare input data with master data: Comparing the input data with the master vendor data helps to determine the invoices from the authorized vendors.
6)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
6)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Due to the cash flow diagrams, Company W loses discounts on vendor payments.
Determine the control plan for the given system failure:
Review of a cash planning report: On a regular basis, the treasurer should produce and review an aging of accounts payable to make sure that enough funds are available to pay obligations.
7)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
7)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Person A is an accounts payable clerk at Company F, who has grown drained of resolving discrepancies. Person A has changed the accounts payable invoice programs to allow large variances to reduce rejects.
Determine the control plan for the given system failure:
Program change controls: Program that performs a credit check and validation should be prevented from the unauthorized alternation which can be done with the help of program change controls.
8)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
8)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Person N is an account payable who send the batch of vendor invoices to the clerk in cash disbursements twice a week. However, it is discovered that not all the payments were made correctly.
Determine the control plan for the given system failure:
Reconcile run-to-run totals: The batch totals for approved payments should be created by the cash disbursement clerk and it must be compared with the actual amount paid.
9)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
9)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Company S receives the electronic invoice by the third party via a web portal. It is discovered that the invoices were altered in transit from the vendor, as most of the invoices are not correct.
Determine the control plan for the given system failure:
Digital signature: Digital signatures make sure that there is only authorized access to the computer.
10)
To determine: The control plan for the given system failure.
Introduction:
Accounting Information System (AIS) is said to be the specialized subsystem of the Information System (IS). AIS can be used in the business events for the purpose of collecting, processing, and reporting the financial information.
10)
![Check Mark](/static/check-mark.png)
Explanation of Solution
Given system failure:
Person G is the cashier who received invoices and made payments as needed. Some of the payments are to fake vendors.
Determine the control plan for the given system failure:
Segregate duties between accounts payable and cashier: The duties of accounts payable and cashier should be segregated to take care of the things without difficulties.
Want to see more full solutions like this?
Chapter 13 Solutions
Bundle: Accounting Information Systems, Loose-Leaf Version, 11th + MindTap Accounting, 1 term (6 months) Printed Access Card
- John 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_forward6-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_forward
- required 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_forwardYou 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_forward
- 3. 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_forwardConsider the following three bonds (see Table 1), which all have a par value of $100 and pay coupons semiannually if the coupon rate is not zero. What is the 6.5-year spot rate on a BEY basis? Bond Coupon Rate Price Maturity(yrs) A 106 3 6 75 B 0 6 115 C 4 6.5arrow_forward
- Problem 6-8 Project Evaluation Dog Up! Franks is looking at a new sausage system with an installed cost of $445,000. This cost will be depreciated straight-line to zero over the project's five-year life, at the end of which the sausage system can be scrapped for $53,000. The sausage system will save the firm $139,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $25,000. If the tax rate is 23 percent and the discount rate is 11 percent, what is the NPV of this project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) NPVarrow_forwardAn investment has an expected return of X percent per year, is expected to make annual payments of $3,170 for 7 years, is worth $14,532, and the first payment is expected 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. percentarrow_forwardYou just took out a loan for $29,449 that requires annual payments of $4,570 for 20 years. The interest rate on the loan is X percent per year and the first regular payment will be made 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. percentarrow_forward
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LAuditing: A Risk Based-Approach to Conducting a Q...AccountingISBN:9781305080577Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:South-Western College PubAccounting Information SystemsFinanceISBN:9781337552127Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan HillPublisher:Cengage Learning
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Auditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781133935940/9781133935940_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305080577/9781305080577_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337552127/9781337552127_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619455/9781337619455_smallCoverImage.gif)