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 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 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 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 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 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 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 |
(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 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
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 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