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
On December 1, Macy Company sold merchandise with a selling price of $9,000 on account to Mrs. Jorgensen, with terms 4/10, n/30.
Marysya12 [62]

Answer:

B) Debit Sales Revenue for $7,968, debit Sales Discounts for $332, and credit Accounts Receivable for $8,300.

Explanation:

The journal entry is shown below:

Cash A/c Dr                   $7,968

Sales Discount A/c Dr $332

     To  Accounts receivable    $8,300

(Being cash received recorded)

The computation of the account receivable  

= Credit sales - returned goods

= $9,000 - $700

= $8,300

And, the discount would be

= Accounts receivable × percentage given

= $8,300 × 4%

= $332

The remaining amount would be credited to the cash account.

8 0
3 years ago
Portions of the financial statements for Software Associates are provided below. SOFTWARE ASSOCIATES Income Statement For the ye
charle [14.2K]

Answer:

Explanation:

The preparation of the Cash Flows from Operating Activities—Indirect Method is shown below:

Cash flow from Operating activities - Indirect method

Net income $78,000

Adjustment made:

Add : Depreciation expense $33,000

Add: Decrease in accounts receivable $10,000

Add: Decrease in inventory $13,000

Add: Increase in accounts payable $7,000

Less: Decrease in salaries payable -$4,000

Add: Increase in income tax payable $8,000

Less: Increase in prepaid rent -$3,000

Total of Adjustments $64,000

Net Cash flow from Operating activities                   $142,000

7 0
3 years ago
Indirect labor includes:_________ (You may select more than one answer. Single click the box with the question mark to produce a
ch4aika [34]

Answer:

b labor of the maintenance employees

c labor of the clerical staff

Explanation:

During the production or composition of finished goods, some form of labors are directly or indirectly involved in the manufacturing of such finished product. Where labor is not readily traced to the manufacturing of finished product, such is known as indirect labor.

On the other hand, labor that is directly involved in the composition of finished product is known as direct labor. Examples of indirect labor are ; wages of supervisors , clerical staff, general helpers , material handlers and maintenance workers.

3 0
3 years ago
Why​ isn't elasticity just measured by the slope of the demand​ curve?
marissa [1.9K]
I think its B if not B than C most likely
6 0
3 years ago
Which of the following is a way for college students to watch their favorite tv shows without spending a lot of money
Delvig [45]
Watch online you watch tv for free youtube,hulu,netflix
4 0
3 years ago
Read 2 more answers
Other questions:
  • Accounting profit is equal to a. total revenue minus the opportunity cost of producing goods and services. b. average revenue mi
    15·1 answer
  • Just Dew It Corporation reports the following balance sheet information for 2017 and 2018.
    9·2 answers
  • If the marginal propensity to consume is 0.6, the marginal propensity to save is 0.4, and government spending increases by $2 bi
    6·2 answers
  • Differential analysis can aid management in making decisions on a variety of alternatives, including whether to discontinue an u
    10·1 answer
  • Assume that three identical units are purchased separately on the following three dates and at the respective costs:________. Ju
    15·1 answer
  • At August 31, 2022, Carla Vista Company has this bank information: cash balance per bank $10,690; outstanding checks $840; depos
    15·1 answer
  • How will the depreciation of the Japanese Yen vis-à-vis the USD impact FDI from U.S. into Japan?
    12·1 answer
  • mariah would like to start eating healthier by making low sugar meals. Which of the following word searches should she use in or
    13·2 answers
  • __________is the name for the doctrine that holds that the manufacturer of a product has legal responsibilities to compensate th
    9·1 answer
  • Investment depends on the ______ interest rate, and money demand depends on the ______ interest rate. a. real; real b. nominal;
    9·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!