A formula is a math equation used in a spreadsheet....... true or false

You are saving for a Porsche Carrera Cabriolet, which currently sells for nearly half a million dollars. Your plan is to deposit

nordsb [41]

Answer:

a.) $217,298.44

b.) $253,514.84.

c.) $239,061.37 .

Explanation:

a. Determine how much you will have saved after 10 years

This is an ordinary annuity question and you are required to find the Future value (FV) at year 10. Using a financial calculator, key in the following inputs;

Total duration of investment; N = 10

Recurring payment; PMT = -15,000

Interest rate ; I/Y = 8%

PV = 0

then compute Future value; CPT FV = 217,298.437

Therefore, in 10 years, you will have saved $217,298.44 which does not meet your goal of half a million dollars.

b. Determine the amount saved if you were able to deposit $17, 500 each year.

With the recurring payment increasing to 17,500 per year and the interest rate remaining at 8%, find the new Future value by keying in the following inputs;

Recurring payment; PMT = - 17,500

Interest rate ; I/Y = 8%

Total duration of investment; N = 10

PV = 0

then compute Future value; CPT FV = 253,514.843

Therefore, in 10 years, you will have saved $253,514.84.

c. Determine the amount saved if you deposit $15,000 each year, but with 10 percent interest.

It is still an ordinary annuity question , however, the recurring payment(PMT) will be 15,000 as before but with an annual interest rate(I/Y) of 10%. Using a financial calculator, key in the following inputs;

Total duration of investment; N = 10

Recurring payment; PMT = -15,000

Interest rate ; I/Y = 10%

PV = 0

then compute Future value; CPT FV = 239,061.369

Therefore, in 10 years, you will have saved $239,061.37 .

7 0

3 years ago

As defined in the Investment Advisers Act of 1940, the term "person associated with an investment adviser" would include all of

kogti [31]

Answer:

A) an employee of the firm with a degree in communications whose job is the graphic design of the investment adviser's research publications

Explanation:

In this case, the employee who performs tasks related to graphic design, but doesn't carry out any function similar to an associate partner or director of an investment adviser, is not considered a "person associated with an investment adviser". Even if that person actually worked for the investment adviser, his/her functions are considered clerical, the same as a secretary or receptionist.

4 0

3 years ago

Two firms, A and B, must each choose either a low price or a high price for their product. The payoff matrix shows the profit

ahrayia [7]

Answer: 1. A.Both firms will choose the low price.

2. B. Both firms would choose the high price.

Explanation:

1. If the firms cannot cooperate with each other and must choose simultaneously, both firms will choose the low price.

This is because at the low price both of them are at the highest profit they can make when they are not cooperating. For instance, if Firm B chooses Low Price and Firm A chooses High Price, Firm A will make $3 million while Firm be will make $8 million.

If Firm B decides to have a high price then firm A will take the low price and make $8 million in profit while Firm B makes $4 million. If they are not working together, they will both have to take the low price to make the most profit.

2. If the firms could cooperate with each other, both firms would choose the high price.

The is because they will be making more than competing and getting a lower profit. Should they cooperate they will each get $7 million in profit because they will pick the option they can both make the highest profit at. The is better than competing and making only $5 and $6 million respectively.

If you need any clarification do comment. Cheers.

4 0

3 years ago

Assume an organization's current service level on order fill is as follows:

frosja888 [35]

Answer:

Answer for the question:

Assume an organization's current service level on order fill is as follows:

Current order fill 80%

Number of orders per year 5,000

Percent of unfilled orders back-ordered 70%

Percent of unfilled orders cancelled 30%

Back order costs per order $150

Lost pretax profit per cancelled order $12,500

a) What is the lost cash flow to the seller at this 80 percent service level?

b) What would be the resulting increase in cash flow if the seller improved order fill to 92 percent

c) If the seller invested $2 million to produce this increased service level, would the investment be justified financially?

d) What is the role of activity-based costing in customer relationship management? In customer segmentation?

is given in the attachment.

Explanation:

Download pdf

7 0

3 years ago

5

gtnhenbr [62]

Answer:

option c it will have negative consequences..

5 0

3 years ago