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
Prepare the journal entries for Mayhem Manufacturing:
Rama09 [41]
Organization Expenses Dr 7,500
Cash 7,500

June 14 Cash Dr 120,000
Common Stock 110,000
Paid-In Capital in Excess of par value—Common 10,000

June 22 Cash Dr 120,000
Preferred Stock 90,000
Paid-In Capital in Excess of par value—Preferred 30,000
6 0
3 years ago
John invested $12,000 in the stock of Hyper Cyber. Eight years later, Hyper Cyber's shares reached $125,000, but John held onto
Nata [24]

Answer:

B. $12,000 is a sunk cost

Explanation:

By considering the given information, the cost that is correct is a sunk cost for $12,000

The sunk cost is the cost already incurred and will not be retrieved in the future. Plus, it's also termed a past cost.  

It is a useless cost and it can be avoided also.  

It is that cost that is not considered at the time of decisions making.

So, option B is correct

5 0
3 years ago
Read 2 more answers
CAN SOMEONE PLEASE HELP ME????
Vikentia [17]

Answer:

1.D

2.D

Hope this helps

7 0
3 years ago
Rinker Audio Products has a fully-staffed purchasing department that procures various inputs. It also has various domestic manuf
Mandarinka [93]

Answer: Logistics

Explanation: Logistics refers to the group of complex operation that are to be performed within an organisation by different individuals under the guidance of various different experts of such tasks. These operations are dependent on each other for their effective performance.

Thus, we can conclude that the combination of Rinker's manufacturing, distribution and purchasing activities will collectively be called as logistics.

7 0
3 years ago
PLZ!!! SOMEONE HELP ME Drag each label to the correct location on the table. Match the characteristics with the organizations th
astra-53 [7]

Answer:

umm you already said it

Explanation:

...

5 0
3 years ago
Read 2 more answers
Other questions:
  • He van halen contract with concert venues, article 126, states that the dressing rooms must have certain munchies, including m&a
    13·1 answer
  • Explain where on that financial statement you would find the debt information.
    11·1 answer
  • Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are p
    8·1 answer
  • Here are the 2015 revenues for the Wendover Group Practice Association for four different budgets (in thousands of dollars):
    11·2 answers
  • Malcolm has been researching reports generated by government agencies and the local chamber of commerce. What kind of research i
    8·2 answers
  • 1. Explain the meaning of Newton's Law of<br>Gravitation.​
    15·1 answer
  • Maria usually sleeps until 8 am, but tomorrow she needs to be at work at 6 am. She should probably _____.
    13·2 answers
  • You work for an accounting firm, and your supervisor is interested in learning more about the proposed tax reforms in your state
    14·1 answer
  • A $72 NSF check was returned from Mr. Smith, a company client. On a bank reconciliation, this would be shows as a(n)
    6·1 answer
  • Kamal plans to save $7,000 a year for 17 years starting a year from today. He expects to earn 9% on his investment. How much wil
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!