1. Jane is 40 years old and has $ 50,000 in her investment account equally spread . And she plans to put in $ 2000 every year in each of the two funds . (15 % of this grade)

• Fund A :
  1. Current amount : $ 25,000
  2. Historical performance , 10 year average : 8.5 %
  3. Fund beta : 1.2
  4. $2000 added ever year
• Fund B :
  1. Current amount : $ 25,000
  2. Historical performance , 10 year average : 4 .5 %
  3. Fund beta : 0.5
  4. $2000 added ever year

1. Using ten year average performance, calculate amount in each fund, and total portfolio at end of 10 years, 20 years and 30 years
2. Calculate portfolio beta at 10 year, 20 years and 30 years ( Hint : Portfolio beta is weighted average beta . Covered in Std deviation and Beta lectures…. recorded lecture for Beta)

TVM Consulting bought new building for its headquarters in the year 2000. The purchase cost was 228197 dollars and in addition it had to spend 22004 dollars adapting the space for its services. The building has been in use since June 21st, 2000. TVM Consulting forecasted that in 2030 the building would have a net salvage value of $100,000. Using the US Straight Line Depreciation Schedule, estimate the total value of depreciation recorded in the accounting books if TVM consulting decides to sell the building on April 15th , 2004 (i.e. summation of all annual depreciation amounts recorded throughout the years of usage). (note: round your answer to the nearest cent and do not include spaces, currency signs, or commas)

CORRECT ANSWER: 24592.16

I am assuming the date of purchase is June 21st, 2000. This is all of the information given.

Write Program in C:

Write a program that: program starts; declares and initializes to 7.25% constant float variable NJSALES_TAX; declares and initializes to 1000 an integer variable total; declares and initializes to zero a float variable grand_total; prompt and input on new line total; calculate grand_total to equal total plus (total*NJSALES_TAX); if grand_total <= 1000 print on new line “Grand total is less than or equal to 1000 it is $” and the grand_total to two decimal places; else if grand_total between 1000 <= 2000 print on new line “Grand total is more than 1000 less than or equal to 2000 it is $” and the grand_total to two decimal places; else print on new line “Grand total is greater than 2000 it is $” and the grand_total to two decimal places; just before ending print on new line “Program finished!” then terminate program.

An investor has a certain amount of money available to invest now. Three alternative investments are available. The estimated profits ($) of each investment under each economic condition are indicated in the following payoff table:

INVESTMENT SELECTION

EVENT A B C

Economy declines 500 -2000 -7000

No change 1000 2000 -1000

Economy expands 2000 5000 20000

Based on his own past experience, the investor assigns the following probabilities to each economic condition:

P (Economy declines) = 0.30

P (No change) = 0.50

P (Economy expands) = 0.20

a. determine the optimal action based on the maximax criterion.

b. determine the optimal action based on the maximin criterion.

c.compute the the expected monetary value for each investment

d. compute the expected opportunity loss for each investment

e. based on (c) or (d) which investment would you choose, and why?

2. working with databases and files in python

a) Write a function with prototype “def profound():” that will prompt the user to type something profound. It will then record the date and time using the “datetime” module and then append the date, time and profound line to a file called “profound.txt”. Do only one line per function call. Use a single write and f-string such that the file contents look like:

2020-10-27 11:20:22 -- Has eighteen letters does

2020-10-27 11:20:36 -- something profound

b) Write a function with prototype “def bestwords():” that will prompt the user to enter a line with some of the best words (separated by spaces). These will be converted to lower case and stored in a data base file (using the dbm and pickle modules) whose keys are a tuple of the current year, month and day (using the datetime module) and the “values” are a set of words collected on that day. Each new word should be checked against all previously-entered words (even those on other days) and it is not added if it already exists in the database. (Hint: I simply subtracted all previous sets of words from the current set, then added that new set to the one for the current day (if it already existed).

c) Write a function with prototype “def printbestwords():” that will simply open the database of best words and print the keys and values, sorted by the keys. Don’t forget to close the database on exit. Example output:

(2020, 10, 26) {'infantroopen', 'susbesdig'}

(2020, 10, 27) {'deligitimatize'}

(2020, 10, 28) {'transpants', 'resaption'}

Consider the below database schema for company ABC:

Employee(empNo, givename, famname, gender, DOB)

Supervises(super_empNo*, empNo*, description)

Department(deptNo, name, manager_empNo*)

Dependent(empNo*, name, relationship)

Project(projNo, description, deptNo*)

The relations Employee, Supervises, Department, Dependent and Project keep data for employees, supervision, departments, dependents of employees and projects of ABC.

For the database, primary keys, and parent and child relations for foreign keys are annotated. The meaning of most attributes is self-explanatory. Answer questions below.

Your answer to each question must be according to the given database schema and instance.

1.1. (2 points) Does the primary key of Supervises (super_empNo, empNo) ensure that each supervisor supervises a different employee? Explain your answer.

1.2. (5 points) Is it possible that a project has no department? Explain why/why not. If possible, identify any data integrity constraints that can be placed on the Project table to prevent this? Can a project have many departments? Explain using the data integrity constraints on the Project table.

1.3. (2 points) Is it possible that a supervisor does not supervise any employees? Explain your answer using the data constraints on the Supervises table.

1.4 (3 point) Assuming that every department is working on at least one project (and the Department table contains a record with department number 8), can the SQL statement below be successfully executed? Explain your answer. DELETE FROM Department WHERE deptNo = 8;

Introduction to the Problem

Design an Amazon Virtual Private Cloud (VPC):

"Scenario: You have a small business with a website that is hosted on an Amazon Elastic Compute Cloud (Amazon EC2) instance. You have customer data that is stored on a backend database that you want to keep private. You want to use Amazon VPC to set up a VPC that meets the following requirements:

•          Your web server and database server must be in separate subnets.

•          The first address of your network must be 10.0.0.0. Each subnet must have 256 total IPv4 addresses.

•          Your customers must always be able to access your web server.

•          Your database server must be able to access the internet to make patch updates.

•          Your architecture must be highly available and use at least one custom firewall layer."

For the Program Level Assessment, short summary report using the following criteria:

Define the Problem

re-state the problem you are asked to solve and detail all relevant findings and recommendations.

Identify Strategies

Explain how your VPC design meets requirements in scenario.

Propose Solutions

How you can improve or change your design using additional services learned in class.

Evaluate Outcomes

Briefly explain how your design and propose solutions meets at least two of the pillars of AWS Well-Architected Framework.

Submit a Word Document

Using the section headers above, provide responses for each and summary report.

Morning Star Ltd was registered on 1 July 2018, as a company with a constitution limiting the

shares that could be offered to 7 000 000 Ordinary shares (including all classes) and 2 000 000

preference shares. The company issued a prospectus dated 1 July 2018 inviting the public to

apply for 4 000 000 Ordinary A class shares at $3.00 per share. The terms of the shares on issue

are $1.50 on application, $1.00 on allotment and $0.50 to be called within six months of

allotment before 31 December 2018.

If the issue is oversubscribed the directors will make a pro-rata issue of shares and the excess

application money will be applied to allotment and calls before any refunds will be given.

On 15 July, the directors also decided to issue 1 000 000 non-voting Ordinary B shares as fully

paid to the promoters for a payment of $2.00 per share.

On 30 July applications closed. Applications for 5 000 000 shares in total had been received with

applicants for 3 500 000 shares paying the full price and 1 500 000 shares paying only the

application fee.

On 1 August, the shares were allotted with all allotment money owed paid by the 30 August.

The company paid share issue costs of $100,000 for the issuing of Ordinary A shares on 1

September. The share issue costs related to legal expenses associated with the share issue and

fees associated with the drafting and advertising of the prospectus and share issue.

The call on the Ordinary A shares was made on 15 Septmber and due by 30 September. All call

money was received except for the call on 75 000 shares. The directors met and forfeited the

shares on 15 October. On 30 October the forfeited shares were reissued at $2.80 fully paid to

$3.00. Costs associated with reissuing the forfeited shares totalled $5,000. The remaining money

was refunded to the defaulting shareholders on 15 November.

The directors decided on 1 November to make a one-day offer of a non-renouceable rights issue

to existing Ordinary A shareholders to purchase additional shares at $1 each for every 5 shares

of holding. Holders of 2 000 000 shares exercised their right.

On 1 January 2019, Morning Star Ltd issued via a private placement semi-annual coupon

debentures (which pay interest every 6 months) with a nominal value of $300,000. The debenture

term is five years and the coupon rate is 12% per year. The market requires a rate of return of

10% per year. The money came in and the debentures were allotted on the same date.

The company issued via a private placement 1 million redeemable preference shares of $2.00

each on 30 June 2019. The shares offer a fixed dividend of 7 per cent per annum. The shares are

later redeemed to non-voting Ordinary Class B shares at the options of the shareholders on 30

June 2021.

Required:

(a) Prepare journal entries for the above transactions for the year ended 30 June 2019.

Note: the entries should be in strict date order of the underlying event.

There are 4 questions required by this exercise (at the very bottom). Show your calculated ratios. Make sure you show the data used to calculate the ratios.