custom writing services

Need more information?: Chat with us


support@myprivateresearcher.com

order download
Average score 4.96 out of 5 based on 673 opinions

Order engineering and construction assignment

Order engineering and construction assignment. This assignment is based on the exercises you should have carried out in your own time on the use of Microsoft Access and Microsoft Excel (see the Moodle page for MN1505).
Preview
A mutual fund portfolio manager wants to restructure her fund using troubled-stock buy-and-sell rules. You have been called in to automate the restructuring to some extent, using an Excel spreadsheet and Access database.
Background
Your friend Ellen has just taken over as manager of a mutual fund. The fund has several stocks, some of which have declined in price. Ellen thinks that the fund needs to be restructured, and she wants to weed out stocks that are ripe for sale. With the proceeds, she will buy other stocks that appear to be undervalued in the stock market.

Ellen has a database with a table for stocks the fund owns and another table for stocks the fund might buy. She wants to use the database and a spreadsheet to automate the portfolio restructuring. Knowing how good you are with Access and Excel, she has asked you for help.

Ellen wants to follow the troubled stocks strategy in her restructuring. The strategy has the following rules for selling and buying stocks:
Ellen would sell a stock if its price has risen 25% or more since it was purchased. She reasons that such a stocks price will not increase in value much more and might go down, so why not sell it now and take the profit?
Ellen would use stock sale proceeds to buy stocks that are now selling for 75% or less that their highest price in the past 52 weeks. She seasons that a stock that has fallen that far might be ripe for an increase in price.
The strategy also has rules for industry concentrations. She would not want to put more than 20% of the portfolio in stocks of companies in any one industry. However, she does not want trivial representation either, so she would want stocks of any industry to represent at least 8% of the portfolio.

The database INVEST.accdb has a table of data about stocks currently owned in the portfolio. The database also has a table of data about stocks that could possibly be purchased. The database tables are discussed next.

The OWNED Table
The OWNED stocks table shows data about the portfolios stocks. The fields are as follows:
STOCK NAME: shows the companys name
INDUSTRY: shows the companys industry
SHARES: shows the number of shares of the stock owned in the portfolio
AVERAGE PRICE: shows the average purchase price of the shares owned in the portfolio
MARKET PRICE: shows the current share price in the stock market

The COULD BUY Table
The COULD BUY table shows data about stocks that Ellen thinks are interesting and worth following. The fields are as follows:
STOCK NAME: shows the companys name
INDUSTRY: shows the companys industry
52 WEEK HIGH: shows the stocks highest market price in the past 52 weeks
MARKET PRICE: shows the current share price in the stock market
TASK 1: Access Data Preparation
Ellen has rules governing how she would sell and buy stocks shown in the database tables. You want to restructure the portfolio using the data in Access and Excel. You will use the following steps:
1)Open the INVEST.accdb database, from the Moodle page for MN1505 Assignment section. Click on Enable Content at the top of the page and then on Save As at the top of the page and save the file in your MN1505 folder (you should have created this folder in your Y: drive earlier in the term). By default the database file will be saved with the name INVEST1.accdb. If your Y: drive is full you may need to delete some of its contents to be able to do this
2)Make a new table based on the OWNED table. It should:Order engineering and construction assignment
a)Be named CURRENT PORTFOLIO
b)Include all the fields from the OWNED table
c)Include a new field to be called SELL STOCK RATIO that calculates the ratio of the current market price to the average price. This ratios values will govern the selling decision.
d)Include a new field to be called BOOK VALUE whose values are obtained by computing the book value (at the average price) of each stock
e)Include a new field to be called SELL? which will be used to identify those stocks that should be sold. Leave it blank for the moment (you should use as the value) you will update it later
f)Include a new field to be called SELL FOR which will be used to calculate the sales values for stocks to be sold. Leave it blank for the moment you will update it later
g)You should save the query you used to do this
h)Check the design of the CURRENT PORTFOLIO table and change the data type for the SELL FOR field to NUMBER
3)Update the CURRENT PORTFOLIO table to give information about stocks that should be kept or sold. Save each query before going on to the next
a)Identify stocks that should be sold by updating the value in the SELL? field to SELL. Remember that Ellen has decided to sell stocks whose price has risen 25% or more since they were purchased.
b)Identify stocks that should be kept by updating the value in the SELL? field to KEEP. Remember that Ellen has decided to sell stocks whose price has risen 25% or more since they were purchased.
c)Compute the sales values for stocks to be sold. If sold, the value is the number of shares times the current price. The sales value is zero if the stock will be kept. This will require two individual queries.
4)Make a new table based on the CURRENT PORTFOLIO table. It should:
a)Be named AFTER SELLING
b)Only include data about stocks that are going to be kept.
c)You should save the query you used to do this.
5)Make a table based on the COULD BUY table. It should:
a)Be named POSSIBLE BUYS
b)Include all the fields from the COULD BUY table.
c)Include a new field to be called BUY STOCK RATIO that calculates the ratio of the current market price to the 52-week-high price. This ratios values will govern the buying decision.
d)Include a new field to be called BUY? which will be used to identify those stocks that should be bought. Leave it blank for the moment (you should use as the value) you will update it later
e)You should save the query you used to do this
6)Update the POSSIBLE BUYS table to give information about stocks that should be bought. Save each query before going on to the next
a)Identify stocks that should be bought by updating the value in the BUY? field to BUY. Remember that Ellen has decided to buy stocks that are now selling for 75% or less than their highest prices in the past 52 weeks.
b)Identify stocks that should not be bought by updating the value in the BUY? field to IGNORE. Remember that Ellen has decided to buy stocks that are now selling for 75% or less than their highest prices in the past 52 weeks.
c)Delete from the POSSIBLE BUYS table rows which show stocks that should be ignored.
7)Close the INVEST.accdb database and Access.
———-
Added on 11.03.2016 14:47
This is the full instruction below:
MN1505 Assignment (30%)
This assignment is based on the exercises you should have carried out in your own time on the use of Microsoft Access and Microsoft Excel (see the Moodle page for MN1505).
Preview
A mutual fund portfolio manager wants to restructure her fund using troubled-stock buy-and-sell rules. You have been called in to automate the restructuring to some extent, using an Excel spreadsheet and Access database.
Background
Your friend Ellen has just taken over as manager of a mutual fund. The fund has several stocks, some of which have declined in price. Ellen thinks that the fund needs to be restructured, and she wants to weed out stocks that are ripe for sale. With the proceeds, she will buy other stocks that appear to be undervalued in the stock market.

Ellen has a database with a table for stocks the fund owns and another table for stocks the fund might buy. She wants to use the database and a spreadsheet to automate the portfolio restructuring. Knowing how good you are with Access and Excel, she has asked you for help.

Ellen wants to follow the troubled stocks strategy in her restructuring. The strategy has the following rules for selling and buyi

HOW IT WORKS

  simple order process Pricing order download You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
Master’s
Doctoral
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. . 1 Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written? Myprivateresearcher.com  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at myprivateresearcher.com  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

9.5
, FL

Our statisticsOur Statistics

  • Orders Completed todate 65387

  • Number of writers 246

  • Satisfied customers 98.7%

  • Returning customers 92.3%

  • Orders placed today 204