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
icang [17]
3 years ago
13

Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wa

nts a fixed retirement income that has the same purchasing power at the time he retires as $60,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24 additional annual payments. Annual inflation is expected to be 5%. He currently has $105,000 saved, and he expects to earn 8% annually on his savings. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below.How much must he save during each of the next 10 years (end-of-year deposits) to meet his retirement goal?
Business
1 answer:
Hunter-Best [27]3 years ago
6 0

Answer:

It will need  $ 107,120.321 dolalr per year to achieve his retirement goal

Explanation:

We first must calcualte the prsent value of the 25 payments with equal worth of 60,000 dollar of today.

First we move the 60,000 forward 10 years

Principal \: (1+ r)^{time} = Amount

Principal 60,000.00

time 10.00

rate 0.05000

60000 \: (1+ 0.05)^{10} = Amount

Amount 97,733.68

Now, we calculate the present value of an annuity considering this 5% inflation

C_0 \times \frac{(1+r)^n-(1+g)^n}{r-g}  = PV

g 0.05

r 0.08

C 97,734

n 25

$ 1,778,492.341

Then, decrease this by the amounnt already saved by our father:

Principal \: (1+ r)^{time} = Amount

Principal 105,000.00

time 10.00

rate 0.08000

105000 \: (1+ 0.08)^{10} = Amount

Amount 226,687.12

Additional saving needed:

1,778.492-34 - 226,687.12 = 1.551.805,22

Now, we solve the annual saving to achieve this future value:

PV \div \frac{(1+r)^{time} -1}{rate} = C\\

PV 1,551,805.22

time 10

rate 0.08

1551805.22 \div \frac{(1+0.08)^{10} -1}{0.08} = C\\

C  $ 107,120.321

‬

You might be interested in
abares Corporation had these transactions during 2020. Indicate whether each transaction is an operating activity, investing act
scZoUnD [109]

Answer:

(a) Issued $50,000 par value common stock for cash = Financing Activities

b) Purchased a machine for $30,000, giving a long-term note in exchange. Financing Activities = Non-cash Investing and Financing Activity

(c) Issued $200,000 par value common stock upon conversion of bonds having a face value of $200,000 =  Non-cash Investing and Financing Activities

(d) Declared and paid a cash dividend of $18,000 = Financing Activities

(e) Sold a long-term investment with a cost of $15,000 for $15,000 cash = Investing Activities

(f) Collected $16,000 from sale of goods = Operating Activities

Explanation:

The Cash flows related to raising of capital is known as Cash flow from Financing Activities.

The Cash flows related to growing and selling of Assets of the business is known as Cash flow from Investing Activities.

The Cash flow related to trade in Ordinary course business of the Company is known as Cash flow from Operating Activities.

7 0
3 years ago
Label the statements as increasing GDP in either Canada or the United States.
Sidana [21]

Answer:

Increasing Canadian GDP:

-Toyota, a Japanese company, manufactures cars in Toronto, Ontario.

-ATI Technologies, a Canadian company, operates in Alberta.

Increasing American GDP:

-Toyota, a Japanese company, manufactures cars in San Antonio, Texas.

-Starbucks, a U.S. company, opens stores in New York state.

-Tim Horton's, a Canadian company, opens coffee shops in New England.

Explanation:

Gross domestic product (GDP) is the sum of all final goods and services produced in an economic space for a certain period, usually one year, excluding the intermediate consumption used in production. Until the 1980's, the use of Gross National Product (GNP) was preferred, a measure almost identical to GDP but incorporating goods and services produced by external factors. The variation in this macroeconomic magnitude is often used to measure economic growth.

5 0
3 years ago
Assume there must be one-to-one matching between consultants and projects. For the optimal schedule, what is the total number of
katrin2010 [14]

Complete Question:

The president of a consulting firm wants to minimize the total number of hours it will take to complete three projects for a new client. Accordingly, she has estimated the time it should take for each of her top consultants-Charlie, Betty, Johnny, and Rick-to complete any of the three projects, as follows: Project (Hours) Consultant Charlie 16 11 13 Betty 15 14 18 Johnny 22 12 15 Rick 17 12 22 Assume there must be one-to-one matching between consultants and projects. For the optimal schedule, what is the total number of hours it will take these consultants to complete these projects? Options: 46 hours, 61 hours, 53 hours, 54 hours, 50 hours

Answer:

For the optimal schedule, the total number of hours it will take these consultants to complete these projects is:

54 hours

Explanation:

a) Data and Calculations:

                                        Project (Hours)

Consultant             A            B            C          D   Project assignment

Charlie                   13           16           11          13    Charles takes C for 11      

Betty                       11           15           14         18    Betty takes A for 11

Johnny                   15          22          12         15    Johnny takes D for 15

Rick                        17           17           12         22   Rick takes B for 17

Minimum hours     11            15          11          13    Total hours taken 54

b) To achieve optimal schedule, Consultant Betty should take project A, spending 11 hours.  Consultant Charlie should take project C for 11 hours.  Consultant Johnny should take project D for 15 hours, while Rick takes project B for 17 hours.  This gives a total of 54 hours spent on the four projects.

8 0
3 years ago
A college professor wants to know if the university students in the Unites States will find the new textbook that he has authore
matrenka [14]

Answer:

b. judgment sampling.

Explanation:

In this scenario, where he believes that this group of students will be representative of the university student population in the United States, the professor is most likely using Judgment or Expert sampling which is normally used in circumstances where the pointed population involves very intelligent people like student of the University of United States here who cannot be determined by using any different type of probability or non-probability sampling method.

4 0
3 years ago
What three factors influence the value of a country’s currency?
kondor19780726 [428]

Economics conditions, political stability and balance of payments 3

7 0
3 years ago
Read 2 more answers
Other questions:
  • Jung inc. owns a patent for which it paid $71 million. at the end of 2016, it had accumulated amortization on the patent of $16
    5·1 answer
  • A highly-efficient computer engineer would most likely have _____ parietal lobes.
    12·1 answer
  • All of the following are services that are available at banks except _____.
    9·1 answer
  • What are the pros and cons of relocating a small or midsized manufacturing firm (that makes mature products) from the united sta
    11·1 answer
  • Nice Corporation produces and sells a single product. Data concerning that product appear below: Per Unit Percent of Sales Selli
    13·1 answer
  • Madison Company issued an interest-bearing note payable with a face amount of $9,000 and a stated interest rate of 8% to the Met
    15·1 answer
  • You want to go to Europe 5 years from now, and you can save $7,300 per year, beginning one year from today. You plan to deposit
    12·2 answers
  • Which of the following groups of people could be considered the first target market in America?
    8·1 answer
  • Money that you owe the Internal Revenue Service because you did not pay enough in over the year is known as a ________________.
    15·1 answer
  • Jasper was the sales manager for three of his organization's retail outlets. What type of manager was he
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!