A firm reports sales of €50,000,000 for the year ended December 31, 2018. Its accounts receivable balances were €6,000,000 at January 1, 2018 and €7,500,000 at December 31, 2018. The company’s cash collections from sales (€) for 2018 is closest to:

a) 51,500,000 b)42,500,000 c)48,500,000

1. List the owner's name of all male customers in the bank who have a ’Checking’ account.
2. Find all accounts associated with ’Alexander Felix’.
3. For each account of the previous question, compute the Balance, and return a table that shows the account number, type, and balance for each account (hint: use UNION).
4. The list of customer names that have transactions greater than or equal to one thousand dollars.

Bank.sql is under this statement.

DROP DATABASE IF EXISTS Bank;
CREATE DATABASE Bank;
USE Bank;

DROP TABLE IF EXISTS transaction;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS account;

CREATE TABLE customer (
name VARCHAR(20),
sex CHAR(1),
ssn CHAR(9) NOT NULL,
phone CHAR(15),
dob DATE,
address VARCHAR(50),
PRIMARY KEY(ssn)

);
  
CREATE TABLE account (
number CHAR(16) UNIQUE NOT NULL,
open_date DATE,
type CHAR(20),
owner_ssn CHAR(9) NOT NULL,
PRIMARY KEY(number)
);
  
CREATE TABLE transaction (
id INT(20) UNIQUE NOT NULL,
amount DECIMAL(9,2),
tdate DATE,
type CHAR(10),
account_num CHAR(16),
PRIMARY KEY(id)
);

INSERT INTO customer VALUE ('John Adam', 'M', '512432341', '(438) 321-2553', '1987-11-15',NULL);
INSERT INTO customer VALUE ('Alexander Felix', 'M', '724432341', '(541) 321-8553', '1991-05-22', NULL);
INSERT INTO customer VALUE ('Andrew William', 'M', '861894272', '(308) 692-1110', '1995-01-04', NULL);
INSERT INTO customer VALUE ('Ana Bert', 'F', '844192241', '(203) 932-7000', '1982-12-07', '23 Boston Post Rd, West Haven, CT 06516');

INSERT INTO account VALUE ('1111222233331441', '2018-12-03', 'Checking', '861894272');
INSERT INTO account VALUE ('2111222233332442', '2019-01-06', 'Saving', '512432341');
INSERT INTO account VALUE ('3111222233333443', '2017-09-22', 'Checking', '844192241');
INSERT INTO account VALUE ('4111222233335444', '2016-04-11', 'Checking', '724432341');
INSERT INTO account VALUE ('5111222233339445', '2018-11-05', 'Saving', '724432341');
INSERT INTO transaction VALUE (1001, 202.50, '2019-08-15', 'Deposit', '5111222233339445');
INSERT INTO transaction VALUE (1002, 100.00, '2019-09-21', 'Deposit','2111222233332442');
INSERT INTO transaction VALUE (1003, 200.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1004, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1005, 1000.00, '2019-09-29', 'Deposit','3111222233333443');
INSERT INTO transaction VALUE (1006, -202.50, '2019-08-29', 'Withdraw', '5111222233339445');
INSERT INTO transaction VALUE (1007, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1008, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1009, -10.00, '2019-09-26', 'Withdraw', '2111222233332442');
INSERT INTO transaction VALUE (1010, 50.00, '2019-09-29', 'Deposit', '4111222233335444');
INSERT INTO transaction VALUE (1011, 320.00, '2019-09-29', 'Deposit', '5111222233339445');
INSERT INTO transaction VALUE (1012, 50.00, '2019-09-18', 'Deposit', '4111222233335444');
INSERT INTO transaction VALUE (1013, 5000.00, '2019-06-21', 'Deposit', '1111222233331441');
INSERT INTO transaction VALUE (1014, -100.00, '2019-09-02', 'Withdraw', '1111222233331441');
INSERT INTO transaction VALUE (1015, -200.00, '2019-09-08', 'Withdraw', '1111222233331441');

1. Find the total amount of ’Deposit’ transactions at the bank
2. Find the list of transactions (statement) of September 2019 (09/01/2019 to 09/30/2019) for account ’1111222233331441’ (note: look at the date format).
3. Find the balance of ’1111222233331441’ before 09/01/2019 ((not including 09/01/2019).
4. Find the name of the customer that deposited the highest amount with one transaction (include the transaction amount).

The SQL code to solve these problems is below:

DROP DATABASE IF EXISTS Bank;
CREATE DATABASE Bank;
USE Bank;

DROP TABLE IF EXISTS transaction;
DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS account;

CREATE TABLE customer (
name VARCHAR(20),
sex CHAR(1),
ssn CHAR(9) NOT NULL,
phone CHAR(15),
dob DATE,
address VARCHAR(50),
PRIMARY KEY(ssn)

);
  
CREATE TABLE account (
number CHAR(16) UNIQUE NOT NULL,
open_date DATE,
type CHAR(20),
owner_ssn CHAR(9) NOT NULL,
PRIMARY KEY(number)
);
  
CREATE TABLE transaction (
id INT(20) UNIQUE NOT NULL,
amount DECIMAL(9,2),
tdate DATE,
type CHAR(10),
account_num CHAR(16),
PRIMARY KEY(id)
);

INSERT INTO customer VALUE ('John Adam', 'M', '512432341', '(438) 321-2553', '1987-11-15',NULL);
INSERT INTO customer VALUE ('Alexander Felix', 'M', '724432341', '(541) 321-8553', '1991-05-22', NULL);
INSERT INTO customer VALUE ('Andrew William', 'M', '861894272', '(308) 692-1110', '1995-01-04', NULL);
INSERT INTO customer VALUE ('Ana Bert', 'F', '844192241', '(203) 932-7000', '1982-12-07', '23 Boston Post Rd, West Haven, CT 06516');

INSERT INTO account VALUE ('1111222233331441', '2018-12-03', 'Checking', '861894272');
INSERT INTO account VALUE ('2111222233332442', '2019-01-06', 'Saving', '512432341');
INSERT INTO account VALUE ('3111222233333443', '2017-09-22', 'Checking', '844192241');
INSERT INTO account VALUE ('4111222233335444', '2016-04-11', 'Checking', '724432341');
INSERT INTO account VALUE ('5111222233339445', '2018-11-05', 'Saving', '724432341');
INSERT INTO transaction VALUE (1001, 202.50, '2019-08-15', 'Deposit', '5111222233339445');
INSERT INTO transaction VALUE (1002, 100.00, '2019-09-21', 'Deposit','2111222233332442');
INSERT INTO transaction VALUE (1003, 200.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1004, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1005, 1000.00, '2019-09-29', 'Deposit','3111222233333443');
INSERT INTO transaction VALUE (1006, -202.50, '2019-08-29', 'Withdraw', '5111222233339445');
INSERT INTO transaction VALUE (1007, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1008, 50.00, '2019-09-29', 'Deposit', '2111222233332442');
INSERT INTO transaction VALUE (1009, -10.00, '2019-09-26', 'Withdraw', '2111222233332442');
INSERT INTO transaction VALUE (1010, 50.00, '2019-09-29', 'Deposit', '4111222233335444');
INSERT INTO transaction VALUE (1011, 320.00, '2019-09-29', 'Deposit', '5111222233339445');
INSERT INTO transaction VALUE (1012, 50.00, '2019-09-18', 'Deposit', '4111222233335444');
INSERT INTO transaction VALUE (1013, 5000.00, '2019-06-21', 'Deposit', '1111222233331441');
INSERT INTO transaction VALUE (1014, -100.00, '2019-09-02', 'Withdraw', '1111222233331441');
INSERT INTO transaction VALUE (1015, -200.00, '2019-09-08', 'Withdraw', '1111222233331441');

The following facts pertain to a non-cancelable lease agreement between Alschuler Leasing Company and McKee Electronics, a lessee, for a computer system.

The collectability of the lease payments is probable by the lessor. The asset will revert to the lessor at the end of the lease term. The straight-line depreciation method is used for all equipment. The following amortization schedule has been prepared correctly for use by both the lessor and the lessee in accounting for this lease. The lease is to be accounted for properly as a finance lease by the lessee and as a sales-type lease by the lessor.

a) Assuming the lessee's accounting period ends on September 30, answer the following questions with respect to this lease agreement.

1. What items and amounts will appear on the lessee's income statement for the year ending September 30, 2018?

2. What items and amounts will appear on the lessee's balance sheet at September 30, 2018?

3. What items and amounts will appear on the lessee's income statement for the year ending September 30, 2019?

4. What items and amounts will appear on the lessee's balance sheet at September 30, 2019?

b) Assuming the lessee's accounting period ends on December 31, answer the following questions with respect to this lease agreement.

1. What items and amounts will appear on the lessee's income statement for the year ending December 31, 2017?

2. What items and amounts will appear on the lessee's balance sheet at December 31, 2017?

3. What items and amounts will appear on the lessee's income statement for the year ending December 31, 2018?

4. What items and amounts will appear on the lessee's balance sheet at December 31, 2018?

Arndt, Inc., reported the following for 2018 and 2019 ($ in millions):

1. Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018.
2. Expenses include $2 million insurance premiums each year for life insurance on key executives.
3. Arndt sells one-year subscriptions to a weekly journal. Subscription sales collected and taxable in 2018 and 2019 were $34 million and $31 million, respectively. Subscriptions included in 2018 and 2019 financial reporting revenues were $21 million ($10 million collected in 2017 but not recognized as revenue until 2018) and $29 million, respectively. Hint: View this as two temporary differences—one reversing in 2018; one originating in 2018.
4. 2018 expenses included a $12 million unrealized loss from reducing investments (classified as trading securities) to fair value. The investments were sold in 2019.
5. During 2017, accounting income included an estimated loss of $5 million from having accrued a loss contingency. The loss was paid in 2018 at which time it is tax deductible.
6. At January 1, 2018, Arndt had a deferred tax asset of $5 million and no deferred tax liability.

Compute the deferred tax amounts that should be reported on the 2018 balance sheet. (Enter your answers in millions (i.e., 10,000,000 should be entered as 10).)

Arndt, Inc., reported the following for 2018 and 2019 ($ in millions): 2018 2019 Revenues $ 996 $ 1,031 Expenses 784 824 Pretax accounting income (income statement) $ 212 $ 207 Taxable income (tax return) $ 210 $ 230 Tax rate: 40% Expenses each year include $30 million from a two-year casualty insurance policy purchased in 2018 for $60 million. The cost is tax deductible in 2018. Expenses include $3 million insurance premiums each year for life insurance on key executives. Arndt sells one-year subscriptions to a weekly journal. Subscription sales collected and taxable in 2018 and 2019 were $36 million and $48 million, respectively. Subscriptions included in 2018 and 2019 financial reporting revenues were $28 million ($10 million collected in 2017 but not recognized as revenue until 2018) and $36 million, respectively. Hint: View this as two temporary differences—one reversing in 2018; one originating in 2018. 2018 expenses included a $22 million unrealized loss from reducing investments (classified as trading securities) to fair value. The investments were sold in 2019. During 2017, accounting income included an estimated loss of $5 million from having accrued a loss contingency. The loss was paid in 2018 at which time it is tax deductible. At January 1, 2018, Arndt had a deferred tax asset of $7 million and no deferred tax liability.

2. Prepare a schedule that reconciles the difference between pretax accounting income and taxable income. Using the schedule,

prepare the necessary journal entry to record income taxes for 2018.

Find 2018 financial statements and other financial data (e.g., beta) for the Boeing Company (Stock ticker: BA) from Yahoo! Finance, Google Finance, MSN Money, or other sources.

(1)  Estimate the company’s weights of capital (debt, preferred stock, and common stock) in 2018

(2)  Estimate the company’s before-tax and after-tax component cost of debt in 2018

(3)  Estimate the firm’s component cost of preferred stock in 2018

(4)  Estimate the component cost of common equity using CAPM in 2018

(5)  Compute the firm’s weighted average cost of capital (WACC) in 2018

Income Statement

All numbers in thousands

Balance Sheet

Statement of Cash Flows

2 The following information is available for Barone Corporation in 2018 with Net Income of $20,250,000. The company also had Preferred Stock, 6%, $50 par value with 150,000 shares authorized and 135,000 issued and outstanding. The full dividend was paid this year. January 1, 2018 Shares outstanding 4,000,000 April 1, 2018 Shares issued 640,000 July 1, 2018 Treasury shares purchased 240,000 October 1, 2018 Shares issued in a 30% stock dividend November 1, 2018 2::1 Split

Compute the basic EPS. (Please show all of your work)

Interpret these Financial liquidity Ratios for Home Depot and Lowes over 2017-2019 .Identify any trends . answer question with analytical response

Account Payable turnover ratio:

Home Depot

Lowes

Quick Ratio:

Home Depot

Lowes

Current Ratio:

Home Depot

Lowes