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
yKpoI14uk [10]
3 years ago
10

A financial planning service offers a college savings program. The plan calls for you to make six annual payments of $14,000 eac

h, with the first payment occurring today on your child’s 12th birthday. Beginning on your child’s 18th birthday, the plan will provide $25,000 per year for four years. What return is this investment offering?
Business
1 answer:
Alchen [17]3 years ago
5 0

Answer:

Ans. the rate of return of this invesment is 3.5278% annual.

Explanation:

Hi, what we need to do here is to find the future value of all six payments, beginning when the child turns 12, which will end when he turns 17. One year later (when the child turns 18) he will receive $25,000 per year, for the next 4 years. This is the equation that we need to use (and solve for "r").

\frac{A_{1}((1+r)^{6}-1)  }{r} =\frac{A_{2}((1+r)^{4}-1)  }{r(1+r)^{4} }

Where:

A1=$14,000

A2=$25,000

So, everything should look like this

\frac{14,000((1+r)^{6}-1)  }{r} =\frac{25,000((1+r)^{4}-1)  }{r(1+r)^{4} }

As you can see, this would take forever to solve, so what we have to do is to use MS Excel, we have to use the "Goal Seek" function. Please check the MS Excel spread sheet attached to this answer.

Please use this function with the following parameters.

Set Cell: G7

To Value: 0

By changing cell: G2

Ans. 3.5278%

Best of luck.

Download xlsx
You might be interested in
Briefly explain the distillation process of alcohol.​
marishachu [46]

Answer:

Distilling is essentially the process whereby a liquid made of two or more parts is separated into smaller parts of desired purity by the addition and subtraction of heat from the mixture. The vapours/liquids distilled will separated other ingredients that have lower boiling points.

3 0
3 years ago
Why is it considered bad manners to leave the Subject field blank?
Bogdan [553]

It is noted as so due to the fact the reader would like to know the reasoning behind the message. Following that the bots used to monitor emails for scams, spam, or viruses typically send off empty subjects as a spam.

3 0
4 years ago
Read 2 more answers
A politician employs illegal immigrants for housekeeping services. A nearby restaurant also employs illegal immigrants. The rest
Veronika [31]

The politician has more power and position to resist consequences.

<u>Explanation:</u>

The gatherings individuals have a place with on account of their place or position in history and society. All individuals have a social area that is characterized by their sex, race, social class, age, capacity, religion, sexual direction, and geographic area is known as Social location.

Social location is significant in light of the fact that it recognizes that all individuals in a general public don't think the same or experience reality similarly. In spite of numerous favorable circumstances, individuals in progressively special positions can be oblivious to the social experience of the individuals who have experienced separation or persecution.

5 0
3 years ago
Grouper Corporation has outstanding 1,900 $1,000 bonds, each convertible into 60 shares of $10 par value common stock. The bonds
natima [27]

Answer:

Explanation:

The journal entries are shown below:

1. Bonds payable A/c Dr   $1,900,000 (1,900 × $1,000)

          To Discount on bonds payable $37,000

          To Common stock $1,140,000  ($10 × 60 shares × 1,900)

          To Additional paid-in capital in excess of par $723,000

(Being the conversion of bonds is recorded and the remaining balance is credited to the Additional paid-in capital in excess of par)

4 0
4 years ago
After graduation many students' demand for used cars decreases. This may be because used cars are considered a normal good to co
Blababa [14]

Answer:

The statement is: False.

Explanation:

Normal goods are those with increasing demand as a result of increases in consumer wages. Examples of normal goods are food staples or clothing. On the other hand, inferior goods are those with decreasing demand when people's income rise. Bus travels and corned beef are examples of inferior goods.

Thus, <em>used cars are considered inferior goods to college students since after graduation, when they start working and earning an income, they are likely to stop purchasing used cars to buy brand new vehicles.</em>

3 0
4 years ago
Other questions:
  • Which exhibit would be the least likely choice for a museum specializing in european art?
    7·1 answer
  • Paul subscribes to an Internet service that alerts him whenever other firms in his industry are quoted in the media. This allows
    6·1 answer
  • A manufacturer creates massive demand for its new plastic sandal and greatly increases its production level. Over time, its high
    9·1 answer
  • A customer walks in to your pharmacy and wants to buy a Blood Pressure Monitor. They choose one that retails for $79.99. Today i
    10·1 answer
  • Magical Productions is a large production company that controls a major portion of the television industry's market share along
    7·1 answer
  • In the aggregate expenditures model, it is assumed that: a.gross investment (I), government purchases (G), and net exports (NX)
    8·1 answer
  • On January 1, 2021, Legion Company sold $270,000 of 4% ten-year bonds. Interest is payable semiannually on June 30 and December
    11·1 answer
  • The first step to merging is entering the ramp and _____.
    10·1 answer
  • Separture: Mon, 11:26p.m.<br> Arrival Time: Tues, 4:32 a.m.<br> Travel Time: ?
    8·1 answer
  • Some of the benefits of clean air and water regulations are Group of answer choices Boost to growth and higher efficiency higher
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!