All categories

3 years ago

To indicate grouping in access, select _____ as the entry in the total row for the field to be used for grouping

1 answer:

3 0

Select the Group By function. This makes it so that records of the same group are placed onto a single record with a column that is added and holds a nested table of the remaining columns. This function also returns a table with records grouped together based on the values in one or more columns.

You might be interested in

Sultan Services has 1.2 million shares outstanding. It expects earnings at the end of the year of $6.0 million. Sultan pays out

Kisachek [45]

Answer:

A) $60.00

Explanation:

to calculate the value of Sultan's stocks, we need to use the growing perpetuity formula:

stock price = dividend / (required return rate - growth rate)

dividend = ($6,000,000 x 60%) / 1.2 million shares = $3,600,000 / 1.2 million shares = $3 per share
required return rate = 10%
growth rate = 5%

stock price = $3 / (10% - 5%) = $3 / 5% = $60 per share

5 0

3 years ago

A seller listed a home for $200,000 and agreed to pay a commission rate of 5%. The MLS stated that the commission would be share

Virty [35]

Answer:

The answer is: $2,700

Explanation:

The house sold for $180,000 (= 90% x $200,000).

The total commission was $9,000 (= $180,000 x 5%), split in half between listing office and selling office.

The selling broker received his $4,500 commission, and then h paid his selling associate 60% of it.

The selling associate received a $2,700 commission (= 60% x $4,500)

3 0

3 years ago

On January 1, 2019, East Lansing, Inc., issues $2,000,000 of 10 percent, 5-year bonds that pay interest of $100,000 semiannually

xenn [34]

Answer:

The issue price of the bond is the present value of the future cash flows of the bond,which is $2,162,217.92.

The calculation of the issue price is shown below.

Explanation

The bond will pay interest of $100000 for 10 periods plus $2000000 par at the end of the tenth period.

The formula applicable is: Future value of each period multiplied by applicable discounting factor.

Even though the bond is issued for only 5 years,but the fact that it pays interest semi-annually makes it 10 period duration(5years*2).

Interest rate should also be adjusted to show the time horizon of six month each by dividing 8% per year by 2.

The detailed computation of present value is as follows:

Periods Coupon Interest @10%/2 DCF=1/(1+r)^n PV

1.00 100,000.00 0.9615 96,153.85

2.00 100,000.00 0.9246 92,455.62

3.00 100,000.00 0.8890 88,899.64

4.00 100,000.00 0.8548 85,480.42

5.00 100,000.00 0.8219 82,192.71

6.00 100,000.00 0.7903 79,031.45

7.00 100,000.00 0.7599 75,991.78

8.00 100,000.00 0.7307 73,069.02

9.00 100,000.00 0.7026 70,258.67

10.00 2,100,000.00 0.6756 1,418,684.75

2,162,217.92

7 0

3 years ago

The primary concerns when first starting your business are:

const2013 [10]

The primary concerns when first starting your business are: financing and planning

8 0

2 years ago

Let’s say you own a firm that produces and sells Ping-Pong tables. The name of your company is iPong because your tables have a

Afina-wow [57]

Answer:

Increase

Explanation:

Bonds refer to medium of raising long term finance whereby the issuer agrees to pay periodic coupon payments and principal repayment upon maturity to the lenders.

Bond ratings convey the credit risk a bond carries. For instance, AAA rating is considered to be the best rating followed by AA, etc. Such ratings depict the credit worthiness of the bond issuer.

Higher or better the credit rating, more popular the bonds would be, lesser would be the investment risk and thus more would be their demand.

In the given case, the bonds which were initially rated BBB have been upgraded to AA. This would result into an increase in the demand for such bonds.

4 0

3 years ago