(JAVA)

Create a program that creates a mini database of numbers that allows the user to: reset the database, print the database, add a number to the database, find the sum of the elements in the database, or quit.

In main, you will declare an array of 10 integers (this is a requirement). Then you will define the following methods: • printArray (int[ ] arr) – this takes in an array and prints it • initArray (int[ ] arr) – this initializes the array so that each cell is 0 • printSum (int[ ] arr) – this calculates the sum of the elements in the array and prints it • enterNum(int[ ] arr) – this asks the user for a slot number and value – putting the value into the array in the correct slot • printMenu (int[ ] arr) – prints the menu in the sample output (that’s it, nothing more)

In main, create an array of 10 integers and immediately call initArray( ). Then, continuously looping, print the menu and ask the user what they want to do – calling the appropriate methods based on the user’s choice. Note that every time you call a method, you must pass the array that was created in main. If it makes it easier, we used a do-while loop and a switch statement in main.

It should behave like the sample output below: (user input = bold)

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

1

Enter the slot: 5

Enter the new value: 76

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

1

Enter the slot: 2

Enter the new value: 33

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

2

|0|0|33|0|0|76|0|0|0|0

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

3

109

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

4

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

2

|0|0|0|0|0|0|0|0|0|0

Would you like to:

1) Enter a number

2) Print the array

3) Find the sum of the array

4) Reset the array

5) Quit

5

The following section is taken from Privy Ltd’s statement of financial position at 31 December 2018.

Interest is payable half-yearly on 1 January and 1 July. Assume no interest is accrued on 30 June.

Required: Prepare journal entries to record interest payments, and redemption of unsecured notes.

a.    Journalise the payment of interest on 1 January 2019.

2. Prepare the entry to pay the interest due on 1 July 2019.
3. Assume on 1 July 2021, after paying interest, that UGGS Ltd redeems half of the unsecured notes at 105.
4. Record the redemption of the notes.

1. With so many foreigners living in Thailand, a number of them western and non-western, work in the Kingdom without proper approval; work permits. As they are paid cash for their illegal work, how do you think this affects the Thai economy, money supply, and capital available for loan.
2. Consider an economy. This economy’s real GDP is constant. The government decides to buy out the government bonds from the commercial banks. What macroeconomic variables will such policy affect? Explain why. Would this effect be different if there was more output produced in the same year? What concept explains this?
3. Over 2018 the cumulative inflation in Venezuela reached 80,000%. How is such phenomenon called? What can cause inflation to reach such value? Explain your answer using the quantity theory of money. Give examples.

Larkspur Leasing Company signs a lease agreement on January 1, 2017, to lease electronic equipment to Crane Company. The term of the non-cancelable lease is 2 years, and payments are required at the end of each year. The following information relates to this agreement: 1. Crane has the option to purchase the equipment for $15,500 upon termination of the lease. It is not reasonably certain that Crane will exercise this option. 2. The equipment has a cost of $110,000 and fair value of $158,500 to Larkspur Leasing. The useful economic life is 2 years, with a residual value of $15,500. 3. Larkspur Leasing desires to earn a return of 5% on its investment. 4. Collectibility of the payments by Larkspur Leasing is probable.

Prepare the journal entries on the books of Larkspur Leasing to reflect the payments received under the lease and to recognize income for the years 2017 and 2018.

Assume that today is December 31, 2018, and that the following information applies to Abner Airlines:

After-tax operating income [EBIT(1 - T)] for 2019 is expected to be $550 million.

The depreciation expense for 2019 is expected to be $50 million.

The capital expenditures for 2019 are expected to be $475 million.

No change is expected in net operating working capital.

The free cash flow is expected to grow at a constant rate of 7% per year.

The required return on equity is 16%. The WACC is 11%.

The firm has $202 million of non-operating assets.

The market value of the company's debt is $3.183 billion.

200 million shares of stock are outstanding.

Using the corporate valuation model approach, what should be the company's stock price today? Do not round intermediate calculations. Round your answer to the nearest cent.

Shamrock Leasing Company signs a lease agreement on January 1, 2017, to lease electronic equipment to Pharoah Company. The term of the non-cancelable lease is 2 years, and payments are required at the end of each year. The following information relates to this agreement:

1. Pharoah has the option to purchase the equipment for $17,500 upon termination of the lease. It is not reasonably certain that Pharoah will exercise this option.

2. The equipment has a cost of $150,000 and fair value of $199,000 to Shamrock Leasing. The useful economic life is 2 years, with a residual value of $17,500.

3. Shamrock Leasing desires to earn a return of 5% on its investment. 4. Collectibility of the payments by Shamrock Leasing is probable.

Prepare the journal entries on the books of Shamrock Leasing to reflect the payments received under the lease and to recognize income for the years 2017 and 2018.

Homework Assignment #3: Data Resource Management

Information is not just stored for business related events. Data is created, saved and processed regarding almost every aspect of modern life. This assignment will have 3 sections, the first two will cover your personal experience with information storage and access. The third section will deal with current issues regarding any concerns associated with the amount of information available today. Each section should contain a page of single space text with two pages required for the third section. Cite your sources.

Section #1: Data Storage

Have you ever actively stored information electronically? This does not have to be limited to creating your own database, but could include anything from storing personal files to even creating a list of information. Discuss you experiences with storing information, such as creating a Music Catalog or Database, organization of Expenses or Bills, etc.

Section #2: Accessing Data

Where and how do you access information stored in a Database? Discuss how you use information either at work, school or in your personal life. For example: accessing a product inventory, customer account information, checking the balance or making a deposit in your bank account, etc. What application do you use to reference this information, such as using a web interface to access an XML or MySQL database? Further outline your experience with data storage and database management by discussing your experience with common database applications and the programming language behind them, such as using Microsoft Access based on Visual Basic or an Oracle Suite with SQL for performing backend queries.

Section #3: Issues Regarding Data Access

• With the amount of information being stored allowing easier access along with the ability to cross-reference many different sources, do you see any areas needing improvement? This could be achieved either by better organization for easier access or through more regulation on availability. Some examples to consider include the rights for the public to obtain data through the US Freedom of Information Act (FOIA) after a certain amount of time. Another is the voluntary release of phone records by all major mobile communication carriers. Some recent information privacy laws have been enacted such as the California Consumer Privacy Act CCPA or the GDPR in the European Union.

• What do you think about Government Data Mining and Private Third Party Data Warehousing? Many private sector companies will sell or purchase information mainly for marketing purposes and access to potential customers. This is often general demographic statistics based on home location and average income, but can include personal information such as product preferences based on purchases tracked by use of a preferred customer card. Please find and make recommendations for any existing regulations regarding the collection or sale of this personal customer data. Also outline your experiences with such marketing practices, for example receiving unwanted credit card applications. This ubiquitous marketing method is often based on information sold by your existing bank, school, etc. You may request to be taken off such lists and can often find who sold that company your information, but such laws are often changing and based on public awareness.

Draw an ERD with the following information:

You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Johnson Video Store in town. The owners have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with the owners to discuss their business and watch their operation for about a week. You discover quickly that a video and a DVD are both copies of a movie kept in a separate plastic case that is rented out. They have several copies of each movie they rent; therefore, there are several videos and DVDs for each movie title. You learn that in their inventory they have several thousand videos and DVDs, which they get wholesale from about a half dozen distributors. The video and DVD prices for them are based on the quantity of their shipment and the past business they have done with each company. The price of a DVD for a movie might be different from the price of a video for the same movie, even from the same distributor. Each distributor provides different types of movies (e.g., suspense, horror, mystery, comedy, etc.). A single distributor may provide several different types of movies in both video and DVD format. It is possible to obtain the same movie from multiple distributors and at different wholesale prices. Each video and DVD has a unique identification number that The owners assign in their inventory, in addition to the distributor's serial number for the item. Each movie also has a unique identification number. The owners assign in addition to the title and any movie IDs the distributors use in their electronic catalogs. Distributors provide electronic catalogs to the owners, and the information from these catalogs must be included in the database. The owners need to record when a video or DVD is rented, when a video or DVD is returned, and all customer charges such as late and damaged fees, failure to rewind fees, and taxes. They need a report of which videos are returned late because there are standard and late charges. On occasion, there are discount prices for specific movies or types of movies. Customers want to rent movies based on actors or actresses, running length, type of movie, rating, year released, the director, and the Academy Awards won (by the movie, the actors, the actresses and/or the directors). Customers also want to know how many videos they have rented in the last month, year, and so forth. The owners need to keep only basic information on customers in their database, such as name, address, telephone numbers, etc. There must be no limit to the number of video and/or DVD copies of a movie that the owners can have in their inventory. Video/DVD ID numbers, movie ID numbers, and distributor ID numbers for videos, DVDs, and movies are all different. Also, each movie must be able to have an unlimited number of actors, actresses, directors, and Academy Awards (i.e., Oscars). Other types of awards (e.g., Golden Globe, People's Choice, etc.) are not of interest for this application. The rental of equipment, sale of videos, DVDs, popcorn, etc., is not to be kept in the database.

The following information relates to Egoly Ltd for the year ended 30^th June 2019:

EGOLY LTD

BALANCE SHEET

AS AT 30^th JUNE 2019

QUESTION 3 CONT’D

The Income Statement and general ledger for the year ended 30^th June 2019 reflected the following:

       Profit after tax                                                                                                     $225,474

Additional information:

1. A fully depreciated machine with a cost of $14,200 was scrapped during the year. No proceeds were received when it was scrapped.

2. New equipment was purchased for cash during the year.

3. No new debentures were issued during the current year.

4. As at 1^st July 2018, Egoly had 284,000 shares issued, at an issue price of $3 per share. During the current year, Egoly issued an additional 213,000 fully paid shares at an issue price of $3 per share.

5. A cash dividend of 40c per share was declared and paid during the year on all issued shares including those issued during the year.

6. Bills payable are used by Egoly as part of their longer-term cash management and are repayable within five years.

REQUIRED:

1. Prepare a cash flow statement for Egoly Ltd using the DIRECT method for the year ended 30^th June 2019. [18 Marks]

2. Wayne Deng is reviewing the statement of cash flows for his technology business. The statement has been provided by his accountant. He is concerned that the statement shows net cash outflows for investing activities. Discuss if Wayne should be worried by this. [3 marks].

Note: The advertising, telephone, and electricity expenses are debited to miscellaneous expense since there are no separate expense accounts provided for the same.