3,1. Suppose that the price of an asset at close of trading yesterday was $350 and its volatility was estimated as 1.4Voper day. The price at the close of trading today is $347. Update the volatility estimate using
(a) The EWMA model with A = 0.95,
(b) The GARCFI(1,1) model with tir = 0.000003, o= 0.05, and B = Q.<15. (5)
3.2 The number of visitors to websites follows the power law in equation (10.1) with q = 2.
Suppose that 1 .5% of sites get 550 or more visitors per day. What percentage of sites get
(a) 1,500 more visitors per day
(b) 2,500 or more visitors per day

Assume the following relations are given,

Student: <StudentiD, Name, Surname, Major, YearStarted>

Write necessary queries for the followings:

1- Create the table and define necessary constraints (primary key, null constraint, etc.).

2- Insert at least 5 records into the table using Insert SQL.command.

3- Select all students having a major of Computer Engineering, print their name and student ID.

4- Update starting year of all Engineering students to 2015 (use like clause).

5- Delete all student with starting year less than 2010.

6- List all records and verify the results.

7- Drop the table.

Prepare an amortization spreadsheet in Excel.  The sheet should be labeled, and I should be able to change purchase price, interest rate, or the other relevant factors and the spreadsheet should automatically update. As we discussed in class, spend some time labeling the spreadsheet and using proper cell references.  This is the first but not the last spreadsheet of this type, it is highly likely that elements of this spreadsheet will be helpful in subsequent assignments, so time spent here may mean less time in the future.

For an initial calculation, assume you are purchasing a $400,000 home with 5% down at an interest rate of 4%, financed over 30 years using a traditional mortgage.

The following grammar for a program has a problem with semicolons:

• Program ::= Block "."
• Block ::= "{" Statement (";" Statement )* "}"
• Statement ::= Assignment | IfStatement | Block
• Assignment ::= "="
• IfStatement ::= "if" "(" Assignment ")" Statement

Use JavaCC to update

When an if statement has a block after it, the block sometimes must end with a semicolon sometimes but not all the time.

1. Write an example showing a required semicolon after a "}"
2. Write an example where a semicolon is not required after a "}"
3. How can the grammar be modified so that several semicolons can occur in a row with not statements.
4. Can the grammar be modified so that a semicolon is not required after a "}" that ends a Block? Rewrite the grammar to make a semicolon not be required after a "}".

Protrade Corporation acquired 80 percent of the outstanding voting stock of Seacraft Company on January 1, 2017, for $428,000 in cash and other consideration. At the acquisition date, Protrade assessed Seacraft's identifiable assets and liabilities at a collective net fair value of $585,000 and the fair value of the 20 percent noncontrolling interest was $107,000. No excess fair value over book value amortization accompanied the acquisition.

The following selected account balances are from the individual financial records of these two companies as of December 31, 2018:

Each of the following problems is an independent situation:

• Assume that Protrade sells Seacraft inventory at a markup equal to 60 percent of cost. Intra-entity transfers were $96,000 in 2017 and $116,000 in 2018. Of this inventory, Seacraft retained and then sold $34,000 of the 2017 transfers in 2018 and held $48,000 of the 2018 transfers until 2019.
  Determine balances for the following items that would appear on consolidated financial statements for 2018:
• Assume that Seacraft sells inventory to Protrade at a markup equal to 60 percent of cost. Intra-entity transfers were $56,000 in 2017 and $86,000 in 2018. Of this inventory, $27,000 of the 2017 transfers were retained and then sold by Protrade in 2018, whereas $41,000 of the 2018 transfers were held until 2019.
  Determine balances for the following items that would appear on consolidated financial statements for 2018:
• Protrade sells Seacraft a building on January 1, 2017, for $92,000, although its book value was only $56,000 on this date. The building had a five-year remaining life and was to be depreciated using the straight-line method with no salvage value.
  Determine balances for the following items that would appear on consolidated financial statements for 2018:

Abbott Equipment leased a protein analyzer to Werner Chemical, Inc. on September 30, 2018. Abbott purchased the machine from NutraLabs, Inc., at a cost of $6.35 million. The five-year lease agreement calls for Werner to make quarterly lease payments of $414,389, payable each September 30, December 31, March 31, June 30, with the first payment at September 30, 2018. Abbot's implicit interest rate is 16%. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.)

Required:
1. What pretax amounts related to the lease would Abbott report in its balance sheet at December 31, 2018?
2. What pretax amounts related to the lease would Abbott report in its income statement for the year ended December 31, 2018?
3. What pretax amounts related to the lease would Abbott report in its statement of cash flows for the year ended December 31, 2018?

What pretax amounts related to the lease would Abbott report in its balance sheet at December 31, 2018 and income statement for the year ended December 31, 2018? (Enter your answer in whole dollars. Round your intermediate and final answers to nearest whole dollar.)