Question: compute the weighted average (instead of the average) yield by nation (yield is defined as dividend divided by price, and is reported as a

compute the weighted average (instead of the average) yield by nation (yield is defined as dividend divided by price, and is F 1nationID Firms code FC pe 16 21 Price 27.50 55.25 31.82 Quantity 10529 12635 22010 3PT 110 13 4Dividend 1.84 2.50 1. A BC 1 code 2 UK 3 USA 4 AUS 5 IND nationName United Kingdom United States Australia India exchangeRate 10.67 0.46 0.02 6

compute the weighted average (instead of the average) yield by nation (yield is defined as dividend divided by price, and is reported as a percentage). The weighted average includes the quantity of shares as a weight 1 Firm's code Firm's name Price Quantity Dividend pe nationID 2 FC Freedonia Copper 27.50 10529 1.84 16 1 3 PT Patagonian Tea 55.25 12635 2.50 10 1 4 AR Abyssinian Ruby 31.82 22010 1.32 13 1 5 SLG Sri Lankan Gold 50.37 32868 2.68 16 1 6 ILZ Indian Lead and Zinc 37.75 6390 3.00 12 1 Burmese Elephant Bolivian Sheep 7 BE 0.07 154713 0.01 1 8 BS 12.75 231678 1.78 11 1 Nigerian Geese Canadian Sugar 9 NG 35.00 12323 1.68 10 1 10 CS 52.78 4716 2.50 15 1 11 ROF Royal Ostric Farms 33.75 1234923 3.00 1 12 MG Minnesota Gold 53.87 816122 1.00 25 2 13 GP Georgia Peach 2.35 387333 0.20 14 NE Narembeen Emu 12.34 45619 1.00 8 15 QD Queensland Dia ond 6.73 89251 0.50 20 3 Indoorpilly Ruby Bombay Duck 16 IR 15.92 56147 0.50 20 17 BD 25.55 167382 1.00 12 4 18 19 A B 1 code 2 UK nationName exchangeRate United Kingdom 1 3 USA United States 0.67 4 AUS Australia 0.46 5 IND India 0.02

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

first create the tables with given information with following code table shares CREATE TABLE shares ID Integer firmscode Text PRIMARY KEY firmsname TE... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

On August 1, 2016, Stephanie Ram, a sole proprietor, started a new business, Ram Wholesale Company. The company sells refrigerators (merchandise) to various retail stores and uses the periodic...

2. (2 points) In what month will the borrower begin paying more towards principal month than interest? 3. (2 points) What is the total amount of interest the borrower will pay over the life of this...

es Down Under Boomerang, Inc., is considering a new three-year expansion project that requires an initial fixed asset investment of $2.85 million. The fixed asset will be depreciated straight-line to...

a. Compute the weighted average cost of capital for this project, assuming that the long-term debt financing is in dollars and ignoring any taxes. b. Assuming that the peso/dollar exchange rate...

Bonds A and B are two straight yen-denominated international bonds, with the same maturity of four years and the same YTM of 9 percent. Bond A has an annual coupon of 11 percent and is accordingly...

8. Bonds A and B are two straight yen-denominated Eurobonds, with the same maturity of four years and the same YTM of 9 percent. Bond A has an annual coupon of 11 percent and is accordingly priced at...

State total budgeted cost formula, and prepare flexible budget s for 2 time periods P10-3A State total budgeted cost formula, and prepare flexible budget s for 2 time periods Ratchet Company uses...

Use the data given in P14-6 for Prince Company. Required: 1. Present component percentages for 2012 only. 2. Respond to the following for 2012: a. What was the average percentage markup on sales? b....

The Backwoods American Company in Problem 2-1 produces approximately 20,000 parkas annually. The quality management program the company implemented was able to improve the average percentage of good...

Refer to the time series data in Problem. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy: a. Mean absolute error...

Refer to the time series data in Exercise 1. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy: a. Mean absolute...

A new school district is opening and recently hired a large group of new staff. The HR specialist is concerned that the hiring trends may have violated the 4/5 rule. The district hired 26...

A piace is in level flight at constant speed and each of its two wings has an area of 25 m'. If the speed of the air is 180 km / h over the lower wing and 234 km/h over the upper wing surface,...

2. Th e following exercises involve constructing defi nitions: Construct lexical defi nitions for capital and depression, and indicate two diff erent meanings for each.

Concentric Spherical Shells A small conducting spherical shell with inner radius a and outer radius b is concentric with a larger conducting spherical shell with inner radius c and outer radius d...

Reporting an Income Statement, Statement of Stockholders Equity, and Balance Sheet Refer to E4-18. Required: Using the adjusted balances in E4-18, prepare an income statement, statement of...

Recording Closing Entries Refer to E4-18. Required: 1. What are the purposes of closing the books at the end of the accounting period? 2. Using the adjusted balances in E4-18, give the closing entry...

Using the moving average method of perpetual inventory costing and the information presented in E2-6, compute the cost of materials used and the cost of the July 31 inventory. (Round unit prices to...

Simple Machines Ramps for the disabled are used because a large weight w can be raised by a relatively small force equal to w sin a plus the small friction force. Such inclined planes are an example...

After transcription, mRNA leaves the (Click to select) and enters the (Click to select) of the cell. Once there, it becomes associated with ribosomes, constructed out of (Click to select) and...

I am not sure about the rest of them, could you plz give a specific Excel code with the following function in the second graph? Thank you. Problem 16-1 Gladstone Corporation is about to launch a new...

I need help for cost accounting project, It is a group project . I need help for excel and answer two questions DAY CARE IN PUBLIC HOUSING Assignment: Dan Schaefer, executive director of the...

11-2, Speedy Delivery Systems can buy a piece of equipment that is anticipated to provide an 11 percent return and can be financed at 6 percent with debt. Later in the year, the firm turns down an...

Please give me 2-3 paragraphs on an ANALYSIS of the COST VOLUME PROFIT (CVP) and answer the following questions (3-5). I put the excel below. If you do any excel calculations please submit seperate...

You must use formulas for ALL calculation (addition, subtraction, multiplication and division). Your amount will be marked wrong if you use a calculator or mental math instead of a formula You should...