Questions
Confused how to calculate SPI with lots of info and if is should be using the...

Confused how to calculate SPI with lots of info and if is should be using the average of all the info?

Year: 2018

Goods or Service

Quantity for a typical student in a year

Student 1 price

Student 2 price

Student 3 price

Average Price

Cost of Basket

Unleaded Gas

100 gallons

$2.45

$2.90

$2.60

$2.65

Hygiene Products

25

$3.50

$3.00

$4.00

$3.50

Textbooks

10

$150.00

$215.00

$175.00

$180.00

Coffee

150

$2.00

$4.00

$3.25

$3.08

Calculators

1

$100.00

$85.00

$110.00

$98.33

Total Cost of 2018 Basket

=

Year: 2019

Goods or Service

Quantity for a typical student in a year

Student 1 price

Student 2 price

Student 3 price

Average Price

Cost of Basket

Unleaded Gas

100 gallons

$3.25

$2.90

$2.50

$2.88

Hygiene Products

25

$3.00

$4.00

$4.50

$3.83

Textbooks

10

$90

$100

$150

$113.33

Coffee

150

$2.50

$3.50

$4.00

$3.33

Calculators

1

$100.00

$110.00

$125.00

$111.67

Total Cost of 2019 Basket

=

Set 2018 as the base year. Calculate the SPI for 2018 and 2019 and find the inflation rate.

Year

Value of Student Market Basket

SPI

Inflation Rate

2018

-

2019

In: Economics

Suppose you purchased two call option contracts (100 shares per contract) with $15 strike price at...

Suppose you purchased two call option contracts (100 shares per contract) with $15 strike price at a quoted price of $0.08 premium/share. What is your total profit on this investment if the price is $14.80 on the option expiration date?

In: Finance

Solve using excel: A. Given the following information, calculate the debt coverage ratio of this commercial...

Solve using excel:

A. Given the following information, calculate the debt coverage ratio of this commercial loan. Estimated net operating income (NOI) in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000

B. Given the following information, calculate the loan-to-value ratio of this commercial loan. Estimated net operating income in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000

C. Given the following information, calculate the debt yield ratio on the following commercial property. Estimated Net Operating Income in the first year: $2,500,000, Debt service in the first year: $960,000, Loan amount: $20,000,000, Purchase price: $27,300,000

In: Accounting

Imagine Chiquita owns a start up – Swanky Dog Inc. – a firm that sells high...

Imagine Chiquita owns a start up – Swanky Dog Inc. – a firm that sells high end winter coats for dogs. Dog coats sell for $80 each without deviation. She only has enough capacity in her facility to produce a maximum of 10 coats per week. The fixed costs of production are $100. The total variable costs are as follows:

price

quantity

FC

VC

80

0

100

0

80

1

100

55

80

2

100

84

80

3

100

114

80

4

100

184

80

5

100

270

80

6

100

389

80

7

100

513

80

8

100

651

80

9

100

809

80

10

100

977

Using the above information, start an Excel worksheet. Make categories and calculate the values for each of the following: price, quantity, fixed cost, variable cost, average variable cost, total costs, average total costs, marginal cost, total revenue, marginal revenue, and profit.

After finding all values in the worksheet, determine what the profit maximizing quantity is for Chiquita’s firm. How can you tell?

c)      Plot the data. In one plot, show ATC, AVC, MC, and MR for Q=[0, 10]. In a separate plot, show Profits as a function of quantity produced over Q=[0,10].

In: Economics

A five-year bond with a $100 face value provides a coupon of 5%per annum payable...

A five-year bond with a $100 face value provides a coupon of 5% per annum payable semiannually. Its price is $100. What is the bond’s yield?

- please do not use excel. Explain step by step

In: Finance

Describe if there is a relationship between the variables Product Quality, Competitive Price, Accessibility, and Advertising...

Describe if there is a relationship between the variables Product Quality, Competitive Price, Accessibility, and Advertising Capability towards Customer Satisfaction, use these data

Customer Satisfaction

Customer Satisfaction

Pearson Correlation

1

Sig. (2-tailed)

N

100

Product Quality

Pearson Correlation

.486**

Sig. (2-tailed)

.000

N

100

Competitive Price

Pearson Correlation

.113

Sig. (2-tailed)

.265

N

100

Accessibility

Pearson Correlation

.305**

Sig. (2-tailed)

.002

N

100

**. Correlation is significant at the 0.01 level (2-tailed).

2. State also the hypothesis

3. which has the highest relationship toward Customer Relationship? Which has the lowest relationship? Briefly Explain

In: Statistics and Probability

While answering the questions below, assume France is a small country and thus unable to influence...

While answering the questions below, assume France is a small country and thus unable to influence the world price. Its demand and supply schedules for washing machines are shown in Table below.

Price of a washing machine ($)

Quantity Demanded

Quantity Supplied

500

0

50

400

10

40

300

20

30

200

30

20

100

40

10

0

50

0

  1. Draw the graphs of demand and supply and determine the equilibrium price and quantity.
  2. Suppose France imports washing machines at a world price of $100 each. How many washing machines will be produced, consumed, and imported?
  3. To protect its producers from foreign competition, suppose the French government levies a specific tariff of $100 on imported washing machines.

(a) Find and show graphically the domestic price of washing machines in France, the quantity of washing machines supplied by French producers, the quantity of washing machines demanded by French consumers, and the amount of import after the tariff is imposed. Explain how the domestic price and quantities changed as compared to the no-tariff situation.

(b) Show graphically and calculate the effects of this tariff on consumers, producers, government, and on the economy as a whole.

In: Economics

Ms. Bodkin bought 500 shares of common stock of ABC Ltd. at $60 a share a...

Ms. Bodkin bought 500 shares of common stock of ABC Ltd. at $60 a share a few years ago. Currently, price per share of ABC's stock is $100. Suppose she takes a short position of 400 shares at the current price of $100. For the following possible spot price on the settlement date, denoted by S1, calculate capital gain(loss) for her total position in ABC's stock: (i)St = $120 (ii) St = $40 Does her short position of 400 shares provide a perfect or a partial edge? Explain.

In: Finance

Coupon Rate as mentioned is 8.750% Payment Frequency is Semi Annually meaning payment to be done...

  • Coupon Rate as mentioned is 8.750%
  • Payment Frequency is Semi Annually meaning payment to be done two times in a year.
  • Offering Date is 01/05/1983
  • Maturity Date is 01/15/2023
  • Offering Price is $99.45
  • FV = 100
  • Trading Price = 105.06

A. Using the offering price found in step 3 and assuming the FV = 100 what is the YTM of your bond on offering (This means compute the YTM as if today was the offering date, show all work).

B. Compute the using the information found in step 3, compute the current YTM.

In: Finance

A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1...

A company blends two materials: A and B to produce two types of fertilizers. Fertilizer 1 must be at least 50% of A and sells for $65 per kilo gram. Fertilizer 2 must be at least 70% of B and sells for $48 per kilogram. The price of martial A is $10 per 100 kilo grams and the price of martial B is $14 per 100 kilo grams if they purchased over 10,000 kilo gram the price will be reduced by 10%. Total budget of the company to spend on raw martial is $2000.
a) Write the linear optimization model for the company to make the best decision

In: Statistics and Probability