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
Morgan is going to give a presentation on how to prepare a tax return. Which of the following would constitute a suitable thesis
sasho [114]

Answer:

The correct answer is a. Preparing a tax return is a fairly simple process, if you know what documents you need.

Explanation:

Terror should not be imposed on people, due to the complexity that in some cases merits the professional advice of an accountant. For this reason, the best thesis that Morgan can use is to make them see that the process does not really involve excessive efforts if you have all the information at hand. The basic premise in tax matters is the organization, the basic knowledge of the standard ensures important levels of trust.

4 0
3 years ago
Which of the following is an example of public relations?
vaieri [72.5K]
Can you give us the multiple choice answers?
5 0
3 years ago
Colin has just received a delivery from the company's distribution center. He opens the containers and finds the popcorn and sna
gulaghasi [49]

Answer:

Floor ready shipment

Explanation:

Floor ready shipment is the one which is already pre tagged and pre ticketed with all the details which is necessary for the retail store before it reach to the store.

In this case, Colin receive delivery and when open the containers he finds that the items are priced and packaged. So, it is a floor ready shipment.

3 0
3 years ago
How are you avalon23413?
Orlov [11]

Answer:

im great

Explanation:

8 0
2 years ago
Read 2 more answers
Suppose Deborah gets a sales bonus at her place of work that gives her an extra $600 of disposable income. She chooses to spend
Mashutka [201]

Answer:

Option (d) is correct.

Explanation:

Suppose Deborah gets a sales bonus at her place of work,

Disposable Income, YD = $ 600

Consumption, C = $480

Savings , S = $ 120

Marginal propensity to consumer, MPC:

= Consumption ÷ Disposable Income

= 480 ÷ 600

= 0.8

Therefore, Deborah marginal propensity to consume (MPC) is 0.80

Option (d)

7 0
3 years ago
Other questions:
  • 1. The 1924 name change from The Computing, Tabulating, and Recording Company to the International Business Machines was done in
    9·1 answer
  • People who buy bonds are called?<br> A.Debtors<br> B.owners<br> C.Creditors<br> D.consumers
    9·1 answer
  • What is something that parents can do to improve their child’s academic self-esteem?
    14·2 answers
  • A local bank will pay you $275 at the end of each year for your lifetime if you deposit $4,400 in the bank today. If you plan to
    15·1 answer
  • Lake House. Harry has two houses, a house on the lake and a house in town. Rebecca wants to buy the house on the lake. Harry and
    14·1 answer
  • _____ goals are set by and for an organization's top management. a. Operational b. Diversification c. Strategic
    13·1 answer
  • The rate of return is the _____.
    5·1 answer
  • The two factors that are most important in determining the density of air are:
    7·1 answer
  • Find any example of a real project with a real project manager. Feel free to use projects in the media (such as the Olympics, te
    10·1 answer
  • Ski ABC Company manufactured too many ski jackets, overestimating the quantity retailers would purchase. So Ski ABC has offered
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!