1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
ElenaW [278]
2 years ago
10

You want to save at least $10,000 for a down payment on a new car. In cell B6, enter a formula to calculate how much you will ha

ve saved by putting away $500 per month for 24 months at a 1.5% annual interest rate. Use the appropriate cell references. Remember to use a negative value for the Pmt argument. There is no money in the account yet and payments are applied at the end of every month, so omit both the Pv and Type arguments. (Hint: Use the FV function.)
Business
1 answer:
Ilya [14]2 years ago
4 0

Answer:

$14,316.76

Explanation:

How much you will have saved?

<em>Using MS Excel to calculate the FV function</em>

= FV(Rate, Nper, Pmt)

= FV(1,5%, 24, 500)

= 14316.7604

= $14,316.76

So, the total amount you will have saved by putting away $500 per month for 24 months at a 1.5% annual interest rate is $14,316.76

You might be interested in
Union Local School District has bonds outstanding with a coupon rate of 4.9 percent paid semiannually and 20 years to maturity.
RUDIKE [14]

Answer:

Ans. Price of the bond is $9,250.57

Explanation:

Hi, first we need to establish the semi-annual coupon of the bond and the semi-annual discount rate (YTM semi-annually)

Coupon=10000*(4.9%/2)= $245

To turn the annaul YTM to semi-annual, we have to use the following equation

YTM(semi-annual)=(1+YTM)^{\frac{1}{2} } -1

YTM(semi-annual)=(1+0.056)^{\frac{1}{2} } -1=0.0276

After all this, we are ready to find the price, here is the math of this.

Price=\frac{245((1+0.0276)^{39}-1) }{0.0276(1+0.0276)^{39} } +\frac{(245+10000)}{(1+0.0276)^{40} } =9250.57

Best of luck.

4 0
3 years ago
1.42 pointsItem 4Item 4 1.42 pointsOn January 1, Revis Consulting entered into a contract to complete a cost reduction program f
deff fn [24]

Question Continuation

Prepare the following journal entries for Revis:

1. The journal entry on January 31 to record the first month of revenue under the contract.

2. Assuming total cost savings exceed target, the journal entry on June 30 to record receipt of the bonus.

3. Assuming total cost savings fall short of target, the journal entry on June 30 to record payment of the penalty.

Answer:

1. The journal entry on January 31 to record the first month of revenue under the contract.

Possible Price -------------------------------Possibility------------Expected Amount

$130,000 ($20,000*6+$10,000) ------80% ------- --------------$104,000 (80% * $130,000)

$110,000 ($20,000*6-$10,000) --------20% -----------------------$22,000 (20% * $110,000)

Expected value--------------------------------------------------------------$126,000 ($104,000 + $22,000)

Accounts ------------------------Debit------------Credit

Cash -------------------------------$20,000 (Debit)

Bonus receivable----------------$1,000 (Debit)

Service revenue --------------------------------- $21,000 ($126,000/6)(Credit)

2. If total cost savings exceed target, record the entry on June 30 for receipt of the bonus

Accounts --------------Debit--------------------------Credit

Cash --------------------- $10,000 (Debit)

Bonus receivable-------------------------------------$6,000 (Credit) ($1000 * 6)

Service revenue ------------------------------------- $4,000 (Credit)

3. If total cost savings fall short of target and record the entry on June 30 for payment of the penalty.

Accounts --------------Debit--------------------------Credit

Service Revenue ---------------- $16,000 (Debit)

Bonus receivable-------------------------------------$6,000 (Credit) ($126,000 / 6)

Cash ------------------------------------- $4,000 (Credit)

3 0
3 years ago
How is the measure of occupational prestige determined? a. Employers are asked how prestigious they believe their businesses are
Readme [11.4K]

Answer:

The measure of occupational prestige is determined through the process in which a nationwide sample of people is asked to evaluate a series of different jobs.

Explanation:

Occupational prestige is also known as job prestige. It is a way used by sociologists to define the social position or standing of people based on their occupation. Rather than using the personal attributes of individuals, it ranks people according to their profession or occupation. The ranks lie from 0 to 100, with 0 being lowest score and 100 the highest. These ranks are alloted to different professions by conducting nationwide surveys.

7 0
3 years ago
Did social media help the participants in the Occupy movement or the Arab Spring more distinctly?
Lana71 [14]

Answer:

A

the arab Spring,because it ended up having more of an impact that the OccupyMovement

5 0
2 years ago
Nichols Corporation's value of operations is equal to $600 million after a recapitalization (the firm had no debt before the rec
Daniel [21]

Answer:

The answer is $750 millions

Explanation:

After recapitalization, the Weight of Debts of Nichols Corporation is 25%. Hence, its Weight of Equity Capital is: 100% - 25% = 75%.

The formula of Value of Operations as follows:

Value of Operations = Weight of Debts x Value of Debts + Weight of Equity Capital x Value of Equity Capital

Because Nichols Corporation's value of operations is equal to $600 million after recapitalization, we have the following equation with S as the value of equity after the recap:

600 = 25% x 150 + 75% x S

=> S = (600 - 25% x 150) / 75% = 750

8 0
3 years ago
Other questions:
  • To produce espressos, a coffee shop has fixed costs of 200 dollars each day and variable costs of one dollar per espresso. The n
    6·1 answer
  • Digger Inc. sells a high-speed retrieval system for mining information. It provides the following information for the year.
    14·1 answer
  • KSB is considering a project that will require $39,000 in net working capital and $68,000 in fixed assets. The project is expect
    6·1 answer
  • Congratulations! Your portfolio returned 17.5​% last​ year, 2.2​% better than the market return of 15.3​%. Your portfolio had a
    12·1 answer
  • A commission employee derives their income from the number of items or goods that they produce. True or Flase
    10·1 answer
  • Last year you forgot to pay a total of three department store monthly statements. Two of the three charged you a $35 fee for thi
    12·1 answer
  • You are a provider of portfolio insurance and are establishing a four-year program. The portfolio you manage is currently worth
    11·1 answer
  • The idea that the mission of business is to produce goods and services at a profit, thus maximizing its contribution to society
    11·1 answer
  • Extrinsic rewards: a. are under the control of the individual performing the action. b. are internal in nature. c. include promo
    14·1 answer
  • The types of companies that make particularly attractive acquisition targets would be:_______
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!